订单列表中,如何列出办事处的名称.??
2016-07-07 15:00 来源:www.chinab4c.com 作者:ecshop专家
如题: 订单列表中,如何列出办事处的名称.??谢谢.. |
回答:
好象回答过这个问题,还写出了sql语句 |
$sql = "SELECT o.order_id, o.order_sn,o.agency_id, o.add_time, o.order_status, o.shipping_status, o.order_amount, o.money_paid,ag.agency_name," . "o.pay_status, o.c**ignee, o.address, o.email, o.tel, o.extension_code, o.extension_id, " . "(" . order_amount_field('o.') . ") AS total_fee, " . "IFNULL(u.user_name, '" .$GLOBALS['_LANG']['anonymous']. "') AS buyer ". " FROM " . $GLOBALS['ecs']->table('order_info') . " AS o " . " LEFT JOIN " .$GLOBALS['ecs']->table('users')." AS u ON u.user_id=o.user_id LEFT JOIN ". $GLOBALS['ecs']->table('agency') ." AS ag ON o.agency_id = ag.agency_id". $where . " ORDER BY $filter[sort_by] $filter[sort_order] ". " LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ",$filter[page_size]"; 前台用{$order.agency_name} 调用成功,谢谢大家. |
最近更新
常用插件
- ecshop二次开发详细页面生
插件介绍: ECSHOP系统,在很多时候,很多商品没有人购买,不但购买的人...
- ecshop商品分类名称增加样
ecshop插件介绍:本插件可以方便在后台管理,为ecshop商品分类名称增加样...
- ecshop分类批量扩展插件
ecshop分类批量扩展插件,这个插件是ecshop插件里面比较核心的插件。我们...
- ecshop2.7.1打印发货单插件
ecshop2.7.1打印发货单插件介绍:ecshop2.7.1和以前的ecshop版本不一样,ecs...
- ecshop二次商品订购人信息
ecshop二次商品订购人信息填写插件,有时候给朋友送花,或者是送礼品的...
ecshop热门问答
ecshop热门资料
ecshop促销插件
ecshop经济
ecshop472
ecshopandriod
ecshop绣绣联盟十字绣
ecshoppriv
ecshoppayday
ecshop发大财
ecshop天空
ecshp拍卖
ecshop求网站修改战略
ecshop时效
ecshopgallery
ecshop企业网站模板下载
ecshop小鸟
ecshoplvmore模板
rabbitmq持久化
ecshop总结
ecshop热销
ecshoplibs
ecshop轮播调用
ecshop编写
ecshop搜索关键词
ecshopstorage
ecshopdizscuz
ecshopjoyo粉色模板
ecshop1745
ecshopdoes
ecshop字数控制出错
ecshop链接串字符