ecshop 在商品列表页添加类似于精品、热销的功能

效果：

在商品列表页添加自定义字段
1、首先要修改数据表结构，给表 ecs_goods 增加新字段：is_top_sellers，
进入ECSHOP后台 》数据库管理 》SQL查询，输入下面SQL语句，提交。注意如果你的数据表前缀不是ecs_ 请自行修改之
alter table ecs_goods add column is_top_sellers is_top_sellers tinyint(1) NOT NULL after is_promote;
2. 打开admin/goods.php
在/* 处理商品数据 */那里
$is_hot = isset($_POST['is_hot']) ? 1 : 0;（大约803行）
$is_top_sellers = isset($_POST['is_top_sellers']) ? 1 : 0;
在 /* 入库 */添加
/* 入库 */
if ($is_insert)
{
if ($code == ")
{
$sql = “INSERT INTO " . $ecs->table('goods') . " (goods_name, goods_name_style, goods_sn, " .
“cat_id, brand_id, shop_price, market_price, is_promote, promote_price, " .
“promote_start_date, promote_end_date, goods_img, goods_thumb, original_img, keywords, goods_brief, " .
“seller_note, goods_weight, goods_number, warn_number, integral, give_integral, is_best, is_new, is_hot,is_top_sellers," .
“is_on_sale, is_alone_sale, is_shipping, goods_desc, add_time, last_update, goods_type, rank_integral, suppliers_id)" .
“VALUES ('$_POST[goods_name]', '$goods_name_style', '$goods_sn', '$catgory_id', " .
“'$brand_id', '$shop_price', '$market_price', '$is_promote','$promote_price', “.
“'$promote_start_date', '$promote_end_date', '$goods_img', '$goods_thumb', '$original_img', “.
“'$_POST[keywords]', '$_POST[goods_brief]', '$_POST[seller_note]', '$goods_weight', '$goods_number',".
" '$warn_number', '$_POST[integral]', '$give_integral', '$is_best', '$is_new', '$is_hot','$is_top_sellers', '$is_on_sale', '$is_alone_sale', $is_shipping, “.
" '$_POST[goods_desc]', '" . gmtime() . “', '". gmtime() ."', '$goods_type', '$rank_integral', '$suppliers_id')";
}
else
{
$sql = “INSERT INTO " . $ecs->table('goods') . " (goods_name, goods_name_style, goods_sn, " .
“cat_id, brand_id, shop_price, market_price, is_promote, promote_price, " .
“promote_start_date, promote_end_date, goods_img, goods_thumb, original_img, keywords, goods_brief, " .
“seller_note, goods_weight, goods_number, warn_number, integral, give_integral, is_best, is_new, is_hot,is_top_sellers,is_real, " .
“is_on_sale, is_alone_sale, is_shipping, goods_desc, add_time, last_update, goods_type, extension_code, rank_integral)" .
“VALUES ('$_POST[goods_name]', '$goods_name_style', '$goods_sn', '$catgory_id', " .
“'$brand_id', '$shop_price', '$market_price', '$is_promote','$promote_price', “.
“'$promote_start_date', '$promote_end_date', '$goods_img', '$goods_thumb', '$original_img', “.
“'$_POST[keywords]', '$_POST[goods_brief]', '$_POST[seller_note]', '$goods_weight', '$goods_number',".
" '$warn_number', '$_POST[integral]', '$give_integral', '$is_best', '$is_new', '$is_hot','$is_top_sellers', 0, '$is_on_sale', '$is_alone_sale', $is_shipping, “.
" '$_POST[goods_desc]', '" . gmtime() . “', '". gmtime() ."', '$goods_type', '$code', '$rank_integral')";
}
}
在 /* 如果有上传图片，需要更新数据库 */
$sql .= “keywords = '$_POST[keywords]', " .
“goods_brief = '$_POST[goods_brief]', " .
“seller_note = '$_POST[seller_note]', " .
“goods_weight = '$goods_weight'," .
“goods_number = '$goods_number', " .
“warn_number = '$warn_number', " .
“integral = '$_POST[integral]', " .
“give_integral = '$give_integral', " .
“rank_integral = '$rank_integral', " .
“is_best = '$is_best', " .
“is_new = '$is_new', " .
“is_top_sellers = '$is_top_sellers', " .
“is_hot = '$is_hot', " .
“is_on_sale = '$is_on_sale', " .
“is_alone_sale = '$is_alone_sale', " .
“is_shipping = '$is_shipping', " .
“goods_desc = '$_POST[goods_desc]', " .
“last_update = '". gmtime() ."', “.
“goods_type = '$goods_type' " .
“WHERE goods_id = '$_REQUEST[goods_id]' LIMIT 1″;
在 /* 取消新品 */后添加
/* 设为is_top_sellers */
elseif ($_POST['type'] == 'is_top_sellers')
{
/* 检查权限 */
admin_priv('goods_manage');
update_goods($goods_id, 'is_top_sellers', '1′);
}
/* 取消is_top_sellers */
elseif ($_POST['type'] == 'not_is_top_sellers')
{
/* 检查权限 */
admin_priv('goods_manage');
update_goods($goods_id, 'is_top_sellers', '0′);
}
在 //– 修改新品推荐状态后面
/*—————————————————— */
//– 修改is_top_sellers推荐状态
/*—————————————————— */
elseif ($_REQUEST['act'] == 'toggle_is_top_sellers')
{
check_authz_json('goods_manage');
$goods_id = intval($_POST['id']);
$is_top_sellers = intval($_POST['val']);
if ($exc->edit(“is_top_sellers = '$is_top_sellers', last_update=" .gmtime(), $goods_id))
{
clear_cache_files();
make_json_result($is_top_sellers);
}
}
3.打开admin/includes/lib_goods.php
/* 分页大小 */
        $filter = page_and_size($filter);
        $sql = "SELECT goods_id, goods_name, goods_type, goods_sn, shop_price, is_on_sale, is_best, is_new, is_hot,is_top_sellers, 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]";

4.在admin/templates/goods_list.htm
在31行{$lang.handler}后
添加 <th><a href="javascript:listTable.sort('is_top_sellers'); ">自定义</a>{$sort_is_top_sellers}</th>
在66行后添加
<td align="center"><img src="images/{if $goods.is_top_sellers}yes{else}no{/if}.gif" οnclick="listTable.toggle(this, 'toggle_is_top_sellers', {$goods.goods_id})" /></td>

这样就可以了，另外listTable.toggle()函数在admin下的js里的listtable.js里大家可以看下