ecshop商品销量后台添加虚拟销量以及前台显示商品已销售销量

使用ECSHOP做网站时，有个苦恼，就是推广前期，商城销量很少，要是能够显示一个假的销量就好了。
通过本教程就可以实现。
教程开始
1.在sq执行语句
ALTER TABLE `ecs_goods` ADD `sales_volume_base` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'
INSERT INTO `ecs_shop_config` (`parent_id`, `code`, `type`, `store_range`, `store_dir`, `value`, `sort_order` ) VALUES ('7','show_goods_sales', 'select', '1,0', '', '1', '1');
INSERT INTO `ecs_shop_config` (`parent_id`, `code`, `type`, `store_range`, `store_dir`, `value`, `sort_order` ) VALUES ('3', 'show_sales_type', 'select', '1,0', '', '1', '1');
注意：如果你的数据表前缀不是‘ecs_’ 请自行修改
2./admin/includes/lib_goods.php中
$sql = "SELECT goods_id, goods_name, goods_type, goods_sn, shop_price, is_on_sale, is_best, is_new, is_hot, sort_order, goods_number, integral, " .                     " (promote_price > 0 AND promote_start_date <= '$today' AND promote_end_date >= '$today') AS is_promote ".                     " FROM " . $GLOBALS['ecs']->table('goods') . " AS g WHERE is_delete='$is_delete' $where" .                     " ORDER BY $filter[sort_by] $filter[sort_order] ".                     " LIMIT " . $filter['start'] . ",$filter[page_size]";
修改为
$sql = "SELECT goods_id, goods_name, goods_type, goods_sn, shop_price, is_on_sale, is_best, is_new, is_hot, sort_order, goods_number, integral, sales_volume_base, " .   " (promote_price > 0 AND promote_start_date <= '$today' AND promote_end_date >= '$today') AS is_promote ". " FROM " . $GLOBALS['ecs']->table('goods') . " AS g WHERE is_delete='$is_delete' $where" . " ORDER BY $filter[sort_by] $filter[sort_order] ". " LIMIT " . $filter['start'] . ",$filter[page_size]";
3./admin/templates/goods_list.htm，在
{if $use_storage} <th><a href="javascript:listTable.sort('goods_number'); ">{$lang.goods_number}</a>{$sort_goods_number}</th>     {/if}
后，添加
<th><a href="javascript:listTable.sort('sales_volume_base'); ">{$lang.sales_volume_base}</a>{$sort_sales_volume_base}</th>
在
{if $use_storage}     <td align="right"><span onclick="listTable.edit(this, 'edit_goods_number', {$goods.goods_id})">{$goods.goods_number}</span></td>     {/if}
后，添加
<td align="center"><span onclick="listTable.edit(this, 'edit_sales_volume_base', {$goods.goods_id})">{$goods.sales_volume_base}</span></td>
4./admin/goods.php，在
/**  * 列表链接  * @param   bool    $is_add         是否添加（插入）  * @param   string  $extension_code 虚拟商品扩展代码，实体商品为空  * @return  array('href' => $href, 'text' => $text)  */ function list_link($is_add = true, $extension_code = '')
前，添加
/*------------------------------------------------------ */ //-- 修改商品虚拟销量 /*------------------------------------------------------ */ elseif ($_REQUEST['act'] == 'edit_sales_volume_base') { check_authz_json('goods_manage');   $goods_id = intval($_POST['id']); $sales_volume_base = json_str_iconv(trim($_POST['val']));   if ($exc->edit("sales_volume_base = '$sales_volume_base', last_update=" .gmtime(), $goods_id)) { clear_cache_files(); make_json_result(stripslashes($sales_volume_base)); } }
5.goods.php，在
$smarty->assign('categories',         get_categories_tree($goods['cat_id']));  // 分类树
后，添加
$smarty->assign('sales_count', get_sales_count($goods_id));
在末尾添加
/* 商品累计销量带自定义_新增加 */ function get_sales_count($goods_id) {  /* 查询该商品的自定义销量 */ $sales_base = $GLOBALS['db']->getOne('SELECT sales_volume_base FROM '.$GLOBALS['ecs']->table('goods').' WHERE goods_id = '.$goods_id); /* 查询该商品的实际销量 */  $sql = 'SELECT IFNULL(SUM(g.goods_number), 0) ' . 'FROM ' . $GLOBALS['ecs']->table('order_info') . ' AS o, ' . $GLOBALS['ecs']->table('order_goods') . ' AS g ' . "WHERE o.order_id = g.order_id " . "AND o.order_status " . db_create_in(array(OS_CONFIRMED, OS_SPLITED)) . "AND o.shipping_status " . db_create_in(array(SS_SHIPPED, SS_RECEIVED)) . " AND o.pay_status " . db_create_in(array(PS_PAYED, PS_PAYING)) . " AND g.goods_id = '$goods_id'"; $sales_count = $GLOBALS['db']->getOne($sql); /* 商品累计销量默认显示方式 */ if ($GLOBALS['_CFG']['show_sales_type']) { $row['sales_volume_total'] =&nbsp; $sales_count; //实际销量 } else { $row['sales_volume_total'] =&nbsp; $sales_base + $sales_count; //自定义销量+实际销量 } return ($row['sales_volume_total']); }
6.在/languages/zh_cn/admin/shop_config.php，中
/languages/zh_cn/admin/shop_config.php
下，添加 7./languages/zh_cn/admin/goods.php，中 后，添加 8./languages/zh_cn/common.php，中 后，添加 9./themes/default/goods.dwt，在 后，添加 OK，完成！

本文标签：

声明：本文由代码号注册/游客用户【高季晨】供稿发布，本站不对用户发布的ecshop商品销量后台添加虚拟销量以及前台显示商品已销售销量信息内容原创度和真实性等负责。如内容侵犯您的版权或其他权益，请留言并加以说明。站长审查之后若情况属实会及时为您删除。同时遵循 CC 4.0 BY-SA 版权协议，尊重和保护作者的劳动成果，转载请标明出处链接和本声明内容。本文作者：高季晨» /dmh/11721.html

很赞哦！ (0)