ecshop ecs_template 解释 作用，数据字段 首页自定义分类显示，美乐乐

最新推荐文章于 2021-03-27 05:58:48 发布
最新推荐文章于 2021-03-27 05:58:48 发布
阅读量2.3k 收藏
点赞数
CC 4.0 BY-SA版权
分类专栏： ecshop网店系统二次开发
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/zhangfeng1133/article/details/51387680
本文介绍了一种用于网站首页模板的个性化配置方法，通过动态分配不同分类的商品展示，实现首页内容的灵活定制。涉及商品分类、品牌和文章列表等数据字段的获取与展示。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

ecshop ecs_template 解释 作用，数据字段



作用： 用于某个模板的个性化设置，例如首页分类显示 哪几个分类


搜索

结果



使用方法

    assign_dynamic('index');

    $smarty->assign('cat_goods',$smarty->_var['cat_goods_1']);
    $smarty->assign('goods_cat',$smarty->_var['goods_cat_1']);
    echo  $smarty->fetch('library/cat_goods.lbi');
    
    $smarty->assign('cat_goods',$smarty->_var['cat_goods_2']);
    $smarty->assign('goods_cat',$smarty->_var['goods_cat_2']);
    echo  $smarty->fetch('library/cat_goods.lbi');

    $smarty->assign('cat_goods',$smarty->_var['cat_goods_3']);
    $smarty->assign('goods_cat',$smarty->_var['goods_cat_3']);
    echo $smarty->fetch('library/cat_goods.lbi');


相关函数

/**
 * 获得指定页面的动态内容
 *
 * @access  public
 * @param   string  $tmp    模板名称
 * @return  void
 */
function assign_dynamic($tmp)
{
    $sql = 'SELECT id, number, type FROM ' . $GLOBALS['ecs']->table('template') .
        " WHERE filename = '$tmp' AND type > 0 AND remarks ='' AND theme='" . $GLOBALS['_CFG']['template'] . "'";
    $res = $GLOBALS['db']->getAll($sql);

   foreach ($res AS $row)
    {
        switch ($row['type'])
        {
            case 1:
                /* 分类下的商品 */
                $GLOBALS['smarty']->assign('goods_cat_' . $row['id'], assign_cat_goods($row['id'], $row['number']));
            break;
            case 2:
                /* 品牌的商品 */
                $brand_goods = assign_brand_goods($row['id'], $row['number']);

                $GLOBALS['smarty']->assign('brand_goods_' . $row['id'], $brand_goods['goods']);
                $GLOBALS['smarty']->assign('goods_brand_' . $row['id'], $brand_goods['brand']);
            break;
            case 3:
                /* 文章列表 */
                $cat_articles = assign_articles($row['id'], $row['number']);

                $GLOBALS['smarty']->assign('articles_cat_' . $row['id'], $cat_articles['cat']);
                $GLOBALS['smarty']->assign('articles_' . $row['id'], $cat_articles['arr']);
            break;
        }
    }
}



/**
 * 取得某模板某库设置的数量
 * @param   string      $template   模板名，如index
 * @param   string      $library    库名，如recommend_best
 * @param   int         $def_num    默认数量：如果没有设置模板，显示的数量
 * @return  int         数量
 */
function get_library_number($library, $template = null)
{
    global $page_libs;

    if (empty($template))
    {
        $template = basename(PHP_SELF);
        $template = substr($template, 0, strrpos($template, '.'));
    }
    $template = addslashes($template);

    static $lib_list = array();

    /* 如果没有该模板的信息，取得该模板的信息 */
    if (!isset($lib_list[$template]))
    {
        $lib_list[$template] = array();
        $sql = "SELECT library, number FROM " . $GLOBALS['ecs']->table('template') .
                " WHERE theme = '" . $GLOBALS['_CFG']['template'] . "'" .
                " AND filename = '$template' AND remarks='' ";
        $res = $GLOBALS['db']->query($sql);
		
        while ($row = $GLOBALS['db']->fetchRow($res))
        {
            $lib = basename(strtolower(substr($row['library'], 0, strpos($row['library'], '.'))));
            $lib_list[$template][$lib] = $row['number'];
        }
    }
	
    $num = 0;
    if (isset($lib_list[$template][$library]))
    {
        $num = intval($lib_list[$template][$library]);
    }
    else
    {
        /* 模板设置文件查找默认值 */
        include_once(ROOT_PATH . ADMIN_PATH . '/includes/lib_template.php');
        static $static_page_libs = null;
        if ($static_page_libs == null)
        {
            $static_page_libs = $page_libs;
        }
        $lib = '/library/' . $library . '.lbi';

        $num = isset($static_page_libs[$template][$lib]) ? $static_page_libs[$template][$lib] :  3;
    }

    return $num;
}



/**
 * 获得指定分类下的商品
 *
 * @access  public
 * @param   integer     $cat_id     分类ID
 * @param   integer     $num        数量
 * @param   string      $from       来自web/wap的调用
 * @param   string      $order_rule 指定商品排序规则
 * @return  array
 */
function assign_cat_goods($cat_id, $num = 0, $from = 'web', $order_rule = '')
{
	$sql = 'SELECT sort_order FROM ' . $GLOBALS['ecs']->table('template') .
        " WHERE filename = 'index' AND type = 1 AND remarks ='' AND id = $cat_id ";
    $sort_order = $GLOBALS['db']->getOne($sql);
	$cat['sort_order'] = $sort_order;

    $children = get_children($cat_id);

    $sql = 'SELECT g.goods_id, g.goods_name, g.market_price, g.shop_price AS org_price, ' .
                "IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, ".
               'g.promote_price, promote_start_date, promote_end_date, g.goods_brief, g.goods_thumb, g.goods_img ' .
            "FROM " . $GLOBALS['ecs']->table('goods') . ' AS g '.
            "LEFT JOIN " . $GLOBALS['ecs']->table('member_price') . " AS mp ".
                    "ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' ".
            'WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND '.
                'g.is_delete = 0 AND (' . $children . 'OR ' . get_extension_goods($children) . ') ';

    $order_rule = empty($order_rule) ? 'ORDER BY g.sort_order, g.goods_id DESC' : $order_rule;
    $sql .= $order_rule;
    if ($num > 0)
    {
        $sql .= ' LIMIT ' . $num;
    }
    $res = $GLOBALS['db']->getAll($sql);

    $goods = array();
    foreach ($res AS $idx => $row)
    {
        if ($row['promote_price'] > 0)
        {
            $promote_price = bargain_price($row['promote_price'], $row['promote_start_date'], $row['promote_end_date']);
            $goods[$idx]['promote_price'] = $promote_price > 0 ? price_format($promote_price) : '';
        }
        else
        {
            $goods[$idx]['promote_price'] = '';
        }

        $goods[$idx]['id']           = $row['goods_id'];
        $goods[$idx]['name']         = $row['goods_name'];
        $goods[$idx]['brief']        = $row['goods_brief'];
        $goods[$idx]['market_price'] = price_format($row['market_price']);
        $goods[$idx]['short_name']   = $GLOBALS['_CFG']['goods_name_length'] > 0 ?
                                        sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];
        $goods[$idx]['shop_price']   = price_format($row['shop_price']);
        $goods[$idx]['thumb']        = get_image_path($row['goods_id'], $row['goods_thumb'], true);
        $goods[$idx]['goods_img']    = get_image_path($row['goods_id'], $row['goods_img']);
        $goods[$idx]['url']          = build_uri('goods', array('gid' => $row['goods_id']), $row['goods_name']);
        /* 会员等级价格 add by yanggg */
        $sql = "SELECT rank_id, IFNULL(mp.user_price, r.discount * $row[shop_price] / 100) AS price, r.rank_name, r.discount " . 'FROM '
            . $GLOBALS['ecs']->table('user_rank') . ' AS r ' . 'LEFT JOIN ' . $GLOBALS['ecs']->table('member_price')    . " AS mp "
            . "ON mp.goods_id = '$row[goods_id]' AND mp.user_rank = r.rank_id "
            . "WHERE r.show_price = 1 OR r.rank_id = '$_SESSION[user_rank]'";
        $res_up = $GLOBALS['db']->query($sql);
        while ($row_up = $GLOBALS['db']->fetchRow($res_up)) {
            $goods[$idx]['user_price'][$row_up['rank_id']] = 
                array(
                'rank_name' => htmlspecialchars($row_up['rank_name']),
                'price' => price_format($row_up['price']),
                'rank_id' =>$row_up['rank_id'],
                'min_account'=>$row_up['min_account'],
                );
        }
    }

    if ($from == 'web')
    {
        $GLOBALS['smarty']->assign('cat_goods_' . $cat_id, $goods);
    }
    elseif ($from == 'wap')
    {
        $cat['goods'] = $goods;
    }

    /* 分类信息 */
    $sql = 'SELECT cat_name FROM ' . $GLOBALS['ecs']->table('category') . " WHERE cat_id = $cat_id";
    $cat['name'] = $GLOBALS['db']->getOne($sql);
    $cat['url']  = build_uri('category', array('cid' => $cat_id), $cat['name']);
    $cat['id']   = $cat_id;
	$cat['cat_clild'] = get_clild_list($cat_id);
	//获取二级分类下的商品
	$cat_list_arr  = cat_list($cat_id, 0 , false);

	foreach($cat_list_arr as $key=>$value)
	{
		if($value['level'] == 1)
		{
			 $sql = 'SELECT g.goods_id,g.cat_id, g.goods_name, g.market_price, g.shop_price AS org_price, ' .
					"IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, ".
					'g.promote_price, promote_start_date, promote_end_date, g.goods_brief, g.goods_thumb, g.goods_img '.
					'FROM '.$GLOBALS['ecs']->table('goods') .' AS g '.
					'LEFT JOIN ' . $GLOBALS['ecs']->table('member_price') . ' AS mp '.
					"ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' ".
					'WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND is_delete = 0 AND ' . get_children($value['cat_id']) . ' ORDER BY g.sort_order, g.goods_id DESC';
			if ($num > 0)
			{
				$sql .= ' LIMIT ' . $num;
			}


			 $goods_res = $GLOBALS['db']->getAll($sql);
			 foreach($goods_res as $idx=>$row)
			 {
			 		if ($row['promote_price'] > 0)
					{
						$promote_price = bargain_price($row['promote_price'], $row['promote_start_date'], $row['promote_end_date']);
						$goods_res[$idx]['promote_price'] = $promote_price > 0 ? price_format($promote_price) : '';
					}
					else
					{
						$goods_res[$idx]['promote_price'] = '';
					}
					$goods_res[$idx]['market_price']  = price_format($row['market_price']);
					$goods_res[$idx]['shop_price']    = price_format($row['shop_price']);
					$goods_res[$idx]['promote_price'] = $promote_price > 0 ? price_format($promote_price) : '';
					$goods_res[$idx]['shop_price']   = price_format($row['shop_price']);
					$goods_res[$idx]['short_name']   = $GLOBALS['_CFG']['goods_name_length'] > 0 ? sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];
					$goods_res[$idx]['url']          = build_uri('goods', array('gid' => $row['goods_id']), $row['goods_name']);
			 }
			 $cat_list_arr[$key]['goods'] = $goods_res;
		}
		else
		{
			unset($cat_list_arr[$key]);
		}
	}

	$cat['goods_level2'] = $cat_list_arr;


	// 获取分类下品牌

	$sql = "SELECT b.brand_id, b.brand_name, brand_logo , COUNT(*) AS goods_num ".
			"FROM " . $GLOBALS['ecs']->table('brand') . "AS b, ".
			$GLOBALS['ecs']->table('goods') . " AS g LEFT JOIN ". $GLOBALS['ecs']->table('goods_cat') . " AS gc ON g.goods_id = gc.goods_id " .
			"WHERE g.brand_id = b.brand_id AND ($children OR " . 'gc.cat_id ' . db_create_in(array_unique(array_merge(array($cat_id), array_keys(cat_list($cat_id, 0, false))))) . ") AND b.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 b.sort_order, b.brand_id ASC LIMIT 3";

	$brands = $GLOBALS['db']->getAll($sql);

	foreach ($brands AS $key => $val)
	{
		$brands[$key]['brand_name'] = $val['brand_name'];
		$brands[$key]['url']  = build_uri('brand', array('bid' => $val['brand_id']), $val['brand_name']);
		$brands[$key]['logo'] = 'data/brandlogo/'.$val['brand_logo'];
	}
	$cat['brands'] = $brands;

    return $cat;
}



E_D("replace into `ecs_template` values('index','分类-商品','/library/cat_goods.lbi','1','2','5','1','meilele','');");
E_D("replace into `ecs_template` values('index','分类-商品','/library/cat_goods.lbi','2','3','5','1','meilele','');");
E_D("replace into `ecs_template` values('index','','/library/brands.lbi','0','0','3','0','meilele','');");
E_D("replace into `ecs_template` values('index','分类-商品','/library/cat_goods.lbi','0','1','5','1','meilele','');");
E_D("replace into `ecs_template` values('index','','/library/auction.lbi','0','0','3','0','meilele','');");
E_D("replace into `ecs_template` values('index','','/library/group_buy.lbi','0','0','1','0','meilele','');");
E_D("replace into `ecs_template` values('index','','/library/recommend_promotion.lbi','0','0','4','0','meilele','');");
E_D("replace into `ecs_template` values('index','','/library/recommend_hot.lbi','0','0','3','0','meilele','');");
E_D("replace into `ecs_template` values('index','','/library/recommend_new.lbi','0','0','3','0','meilele','');");
E_D("replace into `ecs_template` values('index','','/library/recommend_best.lbi','0','0','3','0','meilele','');");
E_D("replace into `ecs_template` values('index','文章-网站公告','/library/cat_articles.lbi','0','9','3','3','meilele','');");



ECSHOP数据结构，表结构，数据库设计
08-04
### ECSHOP 数据结构、表结构与数据库设计详解 #### 概述 ECSHOP是一款基于PHP语言的开源网上商店系统，具有丰富的功能和良好的用户体验。本文将详细介绍ECSHOP v2.7.2版本中的数据结构、表结构以及数据库设计等...
ecshop二次开发数据表结构及说明
02-18
### ecshop二次开发数据表结构及说明 #### 1. ecs_account_log - 用户账目日志表 - **用途**：记录用户的财务变动情况，包括充值、退款等。 - **字段说明**： - `id`：日志记录的唯一标识。 - `user_id`：与之...
ecshop订单表结构ecs_order_goods说明
10-12 5498
-- 表的结构 `ecs_order_goods` CREATE TABLE IF NOT EXISTS `ecs_order_goods` ( `rec_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '订单商品信息自增id', `order_id` mediumint(8) unsigned NOT NULL DEFAU
Ecshop新增单页面模板的方法
sweetyhyh的博客
04-27 2723
【第一】在根目录创建一个php文件，命名为single.php[注：single.php乃我自定义的页面。 define('IN_ECS', true); require(dirname(__FILE__) . '/includes/init.php'); if ((DEBUG_MODE & 2) != 2) {$smarty->caching = true;} /* 清除缓存
ecshop ecs_bonus_type
weixin_30488085的博客
03-01 138
红包类型表 详细解释： ecs_bonus_type表结构说明 转载：http://blog.youkuaiyun.com/umulmek/article/details/59110549 转载于:https://www.cnblogs.com/ecshopdevelop/p/6484922.html
ecshop ipdel.php,ecshop程序中涉及充值内容三个数据库表的用途与区别
weixin_39841610的博客
03-27 135
昨天一无忧主机php独立ip空间客户咨询无忧主机小编，Ecshop涉及用户充值的表有哪些，他需要针对表内的一些数据进行删除，这个小编没特别在意ecshop程序的数据库，于是在本地的wamp集成环境安装了ecshop程序，并对数据库表的内容进行审查，得出涉及用户充值内容的数据库表有三个，分别是：account_log、pay_log、user_account这三张，不需要操作的朋友可以记一下，需要对...
关于$GLOBALS['ecs']->table()的问题？
weixin_30729609的博客
10-28 175
$ecs对象定义数据库和表前缀 class ECS { var $db_name = ''; var $prefix = 'ecs_'; function ECS($db_name, $prefix) { $this->db_name = $db_name; $this->prefix...
ecshop 2.7.3表结构
09-16
此外，还有如`ecs_category`的分类表，`ecs_article`的文章表用于新闻公告，`ecs_coupon`的优惠券表，以及`ecs_wechat`的微信接口配置表等。 在进行ECSHOP 2.7.3的二次开发时，开发者需要深入理解这些表的结构和...
ecshop开发教程大全
07-26
开发者需要熟悉每个表的字段含义和关系，例如商品表（ecs_goods）、订单表（ecs_orders）、用户表（ecs_users）等。理解数据库结构有助于高效地进行数据查询和操作，同时也能为性能优化提供基础。 四、模板结构 ...
ECshop教程.pdf
09-30
首先，关于首页调用文章分类，ECShop模板通常分为两栏或三栏布局，如left、right或left、center、right。在想要添加文章分类的地方，你需要创建一个可编辑区域。例如，在两栏模板的index.dwt文件中，找到右侧模块...
ecshop广告图片增加 alt=”广告关键字描述”
04-16
ecshop广告位置并没有显示描述文字的功能，但是可以自己修改添加代码实现可以从后台增加alt广告位描述的功能。 alt=”广告关键字描述”
ecshop 模板机制
weixin_30877755的博客
08-15 110
ECShop模板是基于smarty 文件名cls_template.php lib_main.php中的assign_template()会设置我们的网店的公共信息及网站设置；assign_dynamic()方法则是设置该页面中的动态加载内容。当页面所需的变量设置完成后，进入smarty的display()方法。 首先，在ECshop中有.dwt和.lbi两种格式的模板文件，那么这两种文件...
ecshop中最基本的一些知识与操作
lixing1359199697的博客
06-28 1167
①ecshop中的一些公用函数都会放在includes文件夹里， 而这些公用函数几乎我们都可以用来参照一下就能轻松做出我们想要的其他功能了。 init.php文件中包含以下代码，$smarty->assign('lang', $_LANG); 来设置ecshop的语言包。 ② ecshop的数据库操作类是很强大的，一些常用的函数如下： ECShop的数据操作类文件是includes...
replace into用法
醉且逍遥
01-14 3707
replace into 跟 insert 功能类似，不同点在于：replace into 首先尝试插入数据到表中，  1. 如果发现表中已经有此行数据（根据主键或者唯一索引判断）则先删除此行数据，然后插入新的数据。  2. 否则，直接插入新数据。 要注意的是：插入数据的表必须有主键或者是唯一索引！否则的话，replace into 会直接插入数据，这将导致表中出现重复的数据。 MySQL
Ecshop对接discuz步骤
越看越顺眼专栏
05-04 2232
Ecshop对接discuz步骤   1.安装discuz 2.将upload下uc_client文件夹复制到ecshop根目录下   3.在ecshop后台》用户管理》会员整合  选择ucenter安装 在上图的地方点击"直接保存配置信息".   4.回到会员整合页面 对UCenter进行设置     5.登录discuz后台》站长》UCenter设置   然后提交
ECSHOP报错The table 'ecs_sessions' is full的解决方法
生如夏花
01-21 1540
#ECSHOP报错The table ‘ecs_sessions’ is full的解决方法 访问前台页面时提示 MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO `ecshop`.`ecs...
ecshop $_CFG是什么意思
01-03 2921
/* 如果使用余额，取得用户余额 */ if ((!isset($_CFG['use_surplus']) || $_CFG['use_surplus'] == '1') && $_SESSION['user_id'] > 0 && $user_info['user_money'] > 0) { // 能使用余额 $s
ecshop调用指定广告的方法
weixin_30722589的博客
03-13 190
在include/lib_goods.php文件下面新增：function getads($cat,$num){ $time = gmtime();$sql = "SELECT * FROM " . $GLOBALS['ecs']->table('ad') . " where position_id=".$cat." and start_time <= '" . $time . "'...
2017年ecs_region地区数据更新及行政代码整理
根据提供的文件信息，我们将深入探讨关于ecs_region、ecshop以及区域代码字段的相关知识点，同时结合文件中的具体项目（整理行政代码.csv和hybx_region_new.sql）来进行详细说明。 ### 一、ECSHOP系统概述 ECSHOP...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值