虚拟销售量.doc

ecshop后台添加虚拟销量以及前台显示销量 2015-6-25 16:56?|?发布者: 慕容清思?|?栏目：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} ? tha href=javascript:listTable.sort(goods_number); {$lang.goods_number}/a{$sort_goods_number}/th ? {/if} ? 后，添加 ? tha href=javascript:listTable.sort(sales_volume_base); {$lang.sales_volume_base}/a{$sort_sales_volume_base}/th ? 在 ? {if $use_storage} ? td align=rightspan onclick=listTable.edit(this, edit_goods_number, {$goods.goods_id}){$goods.goods_number