ecshop

推荐列表 站点导航

当前位置:首页 > 建站教程 > ecshop >

ECSHOP全部品牌页实现分页换页功能方法

来源:网络整理  作者:fen  发布时间:2020-12-25 05:09
这篇文章主要介绍了ECSHOP全部品牌页实现分页换页功能方法,需要的朋友可以参考下...

最近看到有朋友在论坛问到过此类问题,所以抽空写了下文,“在全部品牌页实现分页换页功能”,对商品品牌较多的朋友也许会有帮助,这个修改教程需要修改ecshop的系统文件,所以修改之前请先备份文件。

修改教程

打开brand.php找到

if (empty($brand_id)) {

再找到

exit(); }

将这两者之间的代码全部替换为下面代码


 

复制代码

代码如下:


assign_template();
$position = assign_ur_here('', $_LANG['all_brand']);
$smarty->assign('page_title', $position['title']); // 页面标题
$smarty->assign('ur_here', $position['ur_here']); // 当前位置
$smarty->assign('categories', get_categories_tree()); // 分类树
$smarty->assign('helps', get_shop_help()); // 网店帮助
$smarty->assign('top_goods', get_top10()); // 销售排行
$sql = "SELECT count(IT之家) as brand_count from ( select b.brand_id ".
"FROM " . $GLOBALS['ecs']->table('brand') . "AS b, ".
$GLOBALS['ecs']->table('goods') . " AS g ".
"WHERE g.brand_id = b.brand_id AND is_show = 1 " .
" AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 ".
"GROUP BY b.brand_id ) AS gb";
$brand_count=$GLOBALS['db']->getOne($sql); //品牌(含有商品的)数量 
$page = !empty($_REQUEST['page']) && intval($_REQUEST['page']) > 0 ? intval($_REQUEST['page']) : 1;
$size = 3;
$max_page = ($brand_count> 0) ? ceil($brand_count / $size) : 1;
if ($page > $max_page) {$page = $max_page;}
$start=($page - 1) IT之家 $size; 
$sql = "SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(IT之家) AS goods_num, IF(b.brand_logo > '', '1', '0') AS tag ".
"FROM " . $GLOBALS['ecs']->table('brand') . "AS b, ".
$GLOBALS['ecs']->table('goods') . " AS g ".
"WHERE g.brand_id = b.brand_id AND is_show = 1 " .
" AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 ".
"GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY tag DESC, b.sort_order ASC limit $start,$size";
$row = $GLOBALS['db']->getAll($sql);
foreach ($row AS $key => $val)
{
$row[$key]['url'] = build_uri('brand', array('cid' => $cat, 'bid' => $val['brand_id']), $val['brand_name']);
$row[$key]['brand_desc'] = htmlspecialchars($val['brand_desc'],ENT_QUOTES);
}
$pager['search'] = array( );
$pager = get_pager('brand.php', $pager['search'], $brand_count, $page, $size);
$pager['display'] = $display;
$smarty->assign('pager', $pager);
$smarty->assign('brand_list', $row); 
$smarty->display('brand_list.dwt');

打开 模板文件 brand_list.dwt 在你想要显示换页信息的地方加入下面代码

<!-- #BeginLibraryItem "/library/pages.lbi" --><!-- #EndLibraryItem -->

如果你使用的是官方默认模板,那么在

<div class="dashed"></div>

这行代码下面添加

<!-- #BeginLibraryItem "/library/pages.lbi" --><!-- #EndLibraryItem -->

这样就可以在品牌添加分页代码了。

相关热词: 功能 ecshop 方法

本站内容来源于网络,如有侵权请与我们联系,我们会及时删除,我们深感抱歉!
注:本站所有信息仅供用于网络技术学习参考,学习中请遵循相关法律法规!

本文地址: https://v30.fanwenzhu.com/jz/ecshop/8791.shtml

最新文章
ecshop中设置顺丰快递支持 ecshop中设置顺丰快递支持

时间:2020-12-28

ecshop图文安装过程详解 ecshop图文安装过程详解

时间:2020-12-28

ecshop邮件服务器设置方法 ecshop邮件服务器设置方法

时间:2020-12-23

Copyright © www.juheyunku.com      关于 | 合作 | 声明 | 联系 | 更新 | 地图 | Tags

ECSHOP全部品牌页实现分页换页功能方法

2020-12-25 编辑:fen

最近看到有朋友在论坛问到过此类问题,所以抽空写了下文,“在全部品牌页实现分页换页功能”,对商品品牌较多的朋友也许会有帮助,这个修改教程需要修改ecshop的系统文件,所以修改之前请先备份文件。

修改教程

打开brand.php找到

if (empty($brand_id)) {

再找到

exit(); }

将这两者之间的代码全部替换为下面代码


 

复制代码

代码如下:


assign_template();
$position = assign_ur_here('', $_LANG['all_brand']);
$smarty->assign('page_title', $position['title']); // 页面标题
$smarty->assign('ur_here', $position['ur_here']); // 当前位置
$smarty->assign('categories', get_categories_tree()); // 分类树
$smarty->assign('helps', get_shop_help()); // 网店帮助
$smarty->assign('top_goods', get_top10()); // 销售排行
$sql = "SELECT count(IT之家) as brand_count from ( select b.brand_id ".
"FROM " . $GLOBALS['ecs']->table('brand') . "AS b, ".
$GLOBALS['ecs']->table('goods') . " AS g ".
"WHERE g.brand_id = b.brand_id AND is_show = 1 " .
" AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 ".
"GROUP BY b.brand_id ) AS gb";
$brand_count=$GLOBALS['db']->getOne($sql); //品牌(含有商品的)数量 
$page = !empty($_REQUEST['page']) && intval($_REQUEST['page']) > 0 ? intval($_REQUEST['page']) : 1;
$size = 3;
$max_page = ($brand_count> 0) ? ceil($brand_count / $size) : 1;
if ($page > $max_page) {$page = $max_page;}
$start=($page - 1) IT之家 $size; 
$sql = "SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(IT之家) AS goods_num, IF(b.brand_logo > '', '1', '0') AS tag ".
"FROM " . $GLOBALS['ecs']->table('brand') . "AS b, ".
$GLOBALS['ecs']->table('goods') . " AS g ".
"WHERE g.brand_id = b.brand_id AND is_show = 1 " .
" AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 ".
"GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY tag DESC, b.sort_order ASC limit $start,$size";
$row = $GLOBALS['db']->getAll($sql);
foreach ($row AS $key => $val)
{
$row[$key]['url'] = build_uri('brand', array('cid' => $cat, 'bid' => $val['brand_id']), $val['brand_name']);
$row[$key]['brand_desc'] = htmlspecialchars($val['brand_desc'],ENT_QUOTES);
}
$pager['search'] = array( );
$pager = get_pager('brand.php', $pager['search'], $brand_count, $page, $size);
$pager['display'] = $display;
$smarty->assign('pager', $pager);
$smarty->assign('brand_list', $row); 
$smarty->display('brand_list.dwt');

打开 模板文件 brand_list.dwt 在你想要显示换页信息的地方加入下面代码

<!-- #BeginLibraryItem "/library/pages.lbi" --><!-- #EndLibraryItem -->

如果你使用的是官方默认模板,那么在

<div class="dashed"></div>

这行代码下面添加

<!-- #BeginLibraryItem "/library/pages.lbi" --><!-- #EndLibraryItem -->

这样就可以在品牌添加分页代码了。

本站内容来源于网络,如有侵权请与我们联系,我们会及时删除,我们深感抱歉!
注:本站所有信息仅供学习参考!
本文地址为 https://v30.fanwenzhu.com/jz/ecshop/8791.shtml

相关文章

风云图片

推荐阅读

返回ecshop频道首页