服务报价 | 域名主机 | 网络营销 | 软件工具| [加入收藏]
 热线电话: #
当前位置: 主页 > php教程 > ecshop教程 >

修改ecshop让订单详情里将会员地址详情全部显示

时间:2011-04-24 03:46来源:未知 作者:最模板 点击:
$sql = SELECT concat(IFNULL(c.region_name, ''), ' ', IFNULL(p.region_name, ''), . ' ', IFNULL(t.region_name, ''), ' ', IFNULL(d.region_name, '')) AS region . FROM . $GLOBALS['ecs']-table('order_info') . AS o . LEFT JOIN . $GLOBALS['ecs']-ta

 

$sql = "SELECT concat(IFNULL(c.region_name, ''), '  ', IFNULL(p.region_name, ''), " .

                "'  ', IFNULL(t.region_name, ''), '  ', IFNULL(d.region_name, '')) AS region " .

            "FROM " . $GLOBALS['ecs']->table('order_info') . " AS o " .

                "LEFT JOIN " . $GLOBALS['ecs']->table('region') . " AS c ON o.country = c.region_id " .

                "LEFT JOIN " . $GLOBALS['ecs']->table('region') . " AS p ON o.province = p.region_id " .

                "LEFT JOIN " . $GLOBALS['ecs']->table('region') . " AS t ON o.city = t.region_id " .

                "LEFT JOIN " . $GLOBALS['ecs']->table('region') . " AS d ON o.district = d.region_id " .

            "WHERE o.order_id = '$order[order_id]'";

       $res = $GLOBALS['db']->getRow($sql);

 

       $smarty->assign('address',$res['region']);

在user.php中的

elseif ($action == 'order_detail')里面加上上面那句话

 

在user_transaction.dwt中找到对应的代码显示出来即可

 

 

(责任编辑:最模板)
顶一下
(0)
0%
踩一下
(3)
100%
------分隔线----------------------------
栏目列表
热点内容