ecshop版本比较.docx

1、ecshop版本比较EcShopV272修改版与EcShopV272原版的比较注:下面文本中红色的部分就是修改过的文件(EcShopV272修改版)1. ecshop/article_cat.php原文件：修改后的2. ecshop/brand.php原文件：修改后的3. ecshop/category.php原文件：修改后的原文件：修改后：4ecshop/ exchange.php原文件：修改后：5.ecshop/ flow.php原文件：修改后：6. ecshop/ goods.php原文件：修改后的文件/* 商品购买记录 */* $sql = SELECT u.user_name, og

2、.goods_number, oi.add_time, IF(oi.order_status IN (2, 3, 4), 0, 1) AS order_status . FROM . $ecs-table(order_info) . AS oi LEFT JOIN . $ecs-table(users) . AS u ON oi.user_id = u.user_id, . $ecs-table(order_goods) . AS og . WHERE oi.order_id = og.order_id AND . time() . - oi.add_time 1) ? ($page-1) :

3、 0) * 5 . ,5; $bought_notes = $db-getAll($sql); */ $sql = SELECT u.user_name, og.goods_number, oi.add_time, IF(oi.order_status IN (2, 3, 4), 0, 1) AS order_status . FROM . $ecs-table(order_info) . AS oi LEFT JOIN . $ecs-table(users) . AS u ON oi.user_id = u.user_id, . $ecs-table(order_goods) . AS og

4、 . WHERE oi.order_id = og.order_id AND og.goods_id = . $goods_id . ORDER BY oi.add_time DESC LIMIT . ($page 1) ? ($page-1) : 0) * 5 . ,5; $bought_notes = $db-getAll($sql); foreach ($bought_notes as $key = $val) $bought_notes$keyadd_time = local_date(Y-m-d G:i:s, $valadd_time); /* $sql = SELECT count

5、(*) . FROM . $ecs-table(order_info) . AS oi LEFT JOIN . $ecs-table(users) . AS u ON oi.user_id = u.user_id, . $ecs-table(order_goods) . AS og . WHERE oi.order_id = og.order_id AND . time() . - oi.add_time table(order_info) . AS oi LEFT JOIN . $ecs-table(users) . AS u ON oi.user_id = u.user_id, . $ec

6、s-table(order_goods) . AS og . WHERE oi.order_id = og.order_id AND og.goods_id = . $goods_id; $count = $db-getOne($sql); /* 商品购买记录分页样式 */原文件：修改后：7.ecshop/ group_buy.php原文件修改后：8.ecshop/ pick_out.php原文件修改后：9.ecshop/ search.php原文件修改后：10.ecshop/ user.php（1）原文件：修改后：（2）在原版976行的下面加： /若编辑，插入当前编辑时间;若添加，插入当前添

7、加时间 if($addressaddress_id 0) $updatetime = date(Y-m-d H:i:s); $addressupdatetime = $updatetime; else $createtime = date(Y-m-d H:i:s); $addresscreatetime = $createtime; 就是修改后的版本（3）原版本修改后：11.ecshop/ admin/flashplay.php原文件：修改后：12.ecshop /admin/goods.php原文件：13.ecshop/ goods_batch.php原文件：修改后：14.ecshop/ad

8、min/index.php原文件：修改后：15.ecshop/ admin/magazine_list.php原文件：（1）修改后文件：（2）原文件：修改后：16.ecshop/admin/ order.php原文件修改后：17.修改后的版本比原版本多出的文件：ecshop/ admin/PHPExcel.php，PHP瀵煎嚭Excel.xls，stock.php18.ecshop/admin/ sms.php原文件：修改后：19.ecshop/admin/ users.php原版本从553行572行：/*- */- 收货地址查看/*- */elseif ($_REQUESTact = add

9、ress_list) $id = isset($_GETid) ? intval($_GETid) : 0; $sql = SELECT a.*, c.region_name AS country_name, p.region_name AS province, ct.region_name AS city_name, d.region_name AS district_name . FROM .$ecs-table(user_address). as a . LEFT JOIN . $ecs-table(region) . AS c ON c.region_id = a.country .

10、LEFT JOIN . $ecs-table(region) . AS p ON p.region_id = a.province . LEFT JOIN . $ecs-table(region) . AS ct ON ct.region_id = a.city . LEFT JOIN . $ecs-table(region) . AS d ON d.region_id = a.district . WHERE user_id=$id; $address = $db-getAll($sql); $smarty-assign(address, $address); assign_query_in

11、fo(); $smarty-assign(ur_here, $_LANGaddress_list); $smarty-assign(action_link, array(text = $_LANG03_users_list, href=users.php?act=list& . list_link_postfix(); $smarty-display(user_address_list.htm);修改后：（用红色的替换上面蓝色的，就是修改后的版本）/*- */- 收货地址查看/*- */elseif ($_REQUESTact = address_list) if(isset($_REQUES

12、Tkwname) | isset($_REQUESTkwtel) $kwname = $_REQUESTkwname; /echo $kwname; return; $kwtel = $_REQUESTkwtel; $sql = SELECT a.*, c.region_name AS country_name, p.region_name AS province_name, ct.region_name AS city_name, d.region_name AS district_name . FROM .$ecs-table(user_address). as a . LEFT JOIN

13、 . $ecs-table(region) . AS c ON c.region_id = a.country . LEFT JOIN . $ecs-table(region) . AS p ON p.region_id = a.province . LEFT JOIN . $ecs-table(region) . AS ct ON ct.region_id = a.city . LEFT JOIN . $ecs-table(region) . AS d ON d.region_id = a.district . WHERE (consignee LIKE %.$kwname.%) AND (

14、tel = $kwtel OR mobile = $kwtel); $address = $db-getAll($sql); /echo ; print_r($address); echo ; return; /$smarty-assign(user_id, $id); $smarty-assign(noshowadd, 1); $smarty-assign(address, $address); assign_query_info(); $smarty-assign(ur_here, $_LANGaddress_list); $smarty-assign(action_link, array

15、(text = $_LANG03_users_list, href=users.php?act=list& . list_link_postfix(); $smarty-display(user_address_list.htm); else $id = isset($_GETid) ? intval($_GETid) : 0; $sql = SELECT a.*, c.region_name AS country_name, p.region_name AS province_name, ct.region_name AS city_name, d.region_name AS distri

16、ct_name . FROM .$ecs-table(user_address). as a . LEFT JOIN . $ecs-table(region) . AS c ON c.region_id = a.country . LEFT JOIN . $ecs-table(region) . AS p ON p.region_id = a.province . LEFT JOIN . $ecs-table(region) . AS ct ON ct.region_id = a.city . LEFT JOIN . $ecs-table(region) . AS d ON d.region_

17、id = a.district . WHERE user_id=$id; $address = $db-getAll($sql); /echo ; print_r($address); echo ; return; /$smarty-assign(user_id, $id); $smarty-assign(address, $address); assign_query_info(); $smarty-assign(ur_here, $_LANGaddress_list); $smarty-assign(action_link, array(text = $_LANG03_users_list

18、, href=users.php?act=list& . list_link_postfix(); $smarty-display(user_address_list.htm); /*- */- 收货地址模糊查询，最终查所属会员/*- */elseif ($_REQUESTact = address_list2) if(isset($_REQUESTshadd) $shadd = $_REQUESTshadd; /echo $shadd; return; $sql = SELECT a.*, c.region_name AS country_name, p.region_name AS pro

19、vince_name, ct.region_name AS city_name, d.region_name AS district_name . FROM .$ecs-table(user_address). as a . LEFT JOIN . $ecs-table(region) . AS c ON c.region_id = a.country . LEFT JOIN . $ecs-table(region) . AS p ON p.region_id = a.province . LEFT JOIN . $ecs-table(region) . AS ct ON ct.region_

20、id = a.city . LEFT JOIN . $ecs-table(region) . AS d ON d.region_id = a.district . WHERE (address LIKE %.$shadd.%); $address = $db-getAll($sql); /echo ; print_r($address); echo ; return; /$smarty-assign(user_id, $id); $smarty-assign(noshowadd, 1); $smarty-assign(address, $address); assign_query_info(

21、); $smarty-assign(ur_here, $_LANGaddress_list); $smarty-assign(action_link, array(text = $_LANG03_users_list, href=users.php?act=list& . list_link_postfix(); $smarty-display(user_address_list.htm); else $id = isset($_GETid) ? intval($_GETid) : 0; $sql = SELECT a.*, c.region_name AS country_name, p.r

22、egion_name AS province_name, ct.region_name AS city_name, d.region_name AS district_name . FROM .$ecs-table(user_address). as a . LEFT JOIN . $ecs-table(region) . AS c ON c.region_id = a.country . LEFT JOIN . $ecs-table(region) . AS p ON p.region_id = a.province . LEFT JOIN . $ecs-table(region) . AS

23、 ct ON ct.region_id = a.city . LEFT JOIN . $ecs-table(region) . AS d ON d.region_id = a.district . WHERE user_id=$id; $address = $db-getAll($sql); /echo ; print_r($address); echo ; return; /$smarty-assign(user_id, $id); $smarty-assign(address, $address); assign_query_info(); $smarty-assign(ur_here,

24、$_LANGaddress_list); $smarty-assign(action_link, array(text = $_LANG03_users_list, href=users.php?act=list& . list_link_postfix(); $smarty-display(user_address_list.htm); /*- */- 指定ID的收货地址显示/*- */elseif ($_REQUESTact = address_one) $id = isset($_GETid) ? intval($_GETid) : 0; /echo $id; return; $sql

25、= SELECT a.*, c.region_name AS country_name, p.region_name AS province_name, ct.region_name AS city_name, d.region_name AS district_name . FROM .$ecs-table(user_address). as a . LEFT JOIN . $ecs-table(region) . AS c ON c.region_id = a.country . LEFT JOIN . $ecs-table(region) . AS p ON p.region_id =

26、a.province . LEFT JOIN . $ecs-table(region) . AS ct ON ct.region_id = a.city . LEFT JOIN . $ecs-table(region) . AS d ON d.region_id = a.district . WHERE address_id=$id; /$address = $db-getAll($sql); $address = $db-getRow($sql); /echo ; print_r($address); echo ; return; $_SESSIONold_address = $address; /echo ; print_r($_SESSIONold_address); echo ; return; /* 取得区域名 */* $sql = SELECT concat(IFNULL(c.regi