Orders.php 9.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\model\OrderInfo;
  4. use app\admin\model\Refund;
  5. use app\common\controller\Backend;
  6. use app\common\model\OrderLogistics;
  7. use think\Db;
  8. use think\db\Query;
  9. /**
  10. *
  11. *
  12. * @icon fa fa-circle-o
  13. */
  14. class Orders extends Backend
  15. {
  16. /**
  17. * Orders模型对象
  18. * @var \app\admin\model\Orders
  19. */
  20. protected $model = null;
  21. public function _initialize()
  22. {
  23. parent::_initialize();
  24. $this->model = new \app\admin\model\Orders;
  25. $this->assign('status',$this->model::getStatus());
  26. $this->assign('pay_types',$this->model::getPayTypes());
  27. }
  28. public function import()
  29. {
  30. parent::import();
  31. }
  32. /**
  33. * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
  34. * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
  35. * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
  36. */
  37. /**
  38. * 查看
  39. */
  40. public function index()
  41. {
  42. //当前是否为关联查询
  43. $this->relationSearch = true;
  44. //设置过滤方法
  45. $this->request->filter(['strip_tags', 'trim']);
  46. if ($this->request->isAjax()) {
  47. //如果发送的来源是Selectpage,则转发到Selectpage
  48. if ($this->request->request('keyField')) {
  49. return $this->selectpage();
  50. }
  51. list($where, $sort, $order, $offset, $limit) = $this->buildparams();
  52. $filter=json_decode(input('filter'));
  53. $list = $this->model
  54. ->with(['user','logistics','voucher','admin','info','info.refund'])
  55. ->where($where)
  56. ->where(function (Query $query){
  57. if($this->admin('is_seller')){
  58. $query->where('orders.admin_id',$this->admin('id'));
  59. }
  60. })
  61. ->order($sort, $order)
  62. ->paginate($limit);
  63. /* foreach ($list as $row) {
  64. }*/
  65. $result = array("total" => $list->total(), "rows" => $list->items(),'filter'=>$filter);
  66. $result['link']=$this->request->url().'&export=1';
  67. return json($result);
  68. }
  69. return $this->view->fetch();
  70. }
  71. #发货
  72. public function send($ids){
  73. $order=$this->model->find($ids);
  74. if($this->request->isGet()){
  75. $companys = Db('LogisticsCompany')->where(['use'=>1])->select();
  76. $this->assign('row',$order);
  77. $this->assign('companys',$companys);
  78. return $this->fetch();
  79. }else{
  80. /*$data=input('row/a');
  81. $this->validate($data,[
  82. 'com_id'=>['require',],
  83. 'trans_no'=>['require'],
  84. 'from_area|发货地'=>['require'],
  85. 'from_address|发货地详细地址'=>['require'],
  86. 'from_username|发货人'=>['require'],
  87. 'from_mobile|发货人手机号'=>['require','mobile'],
  88. 'remark|备注'=>['max:100'],
  89. ]);
  90. if($order->logistics){
  91. $this->error('已发货无法再次发货');
  92. }
  93. $order->makeSend($order->logistics,$data);
  94. $this->success();*/
  95. $data=input('row/a');
  96. $this->validate($data,[
  97. 'address_id|发货地址'=>['require',],
  98. 'province|发货方式'=>['require',],
  99. 'remark|备注'=>['max:100'],
  100. ]);
  101. $address=\app\admin\model\Address::lock(true)->find($data['address_id']);
  102. if(!$address){
  103. $this->error('发货地址不存在');
  104. }
  105. $kuayue1 = [1=>'次日达',2=>'隔日达',3=>'陆运件',4=>'省内次日',5=>'同城次日'];
  106. $debangkuaidi1 = [6=>'大件快递360',7=>'重包入户'];
  107. $shunfeng1 = [8=>'顺丰标快',9=>'顺丰特快'];
  108. $kuaidi_data = [1=>'次日达',2=>'隔日达',3=>'陆运件',4=>'省内次日',5=>'同城次日',6=>'大件快递360',7=>'重包入户',8=>'顺丰标快',9=>'顺丰特快'];
  109. $kuayue = [1,2,3,4,5];
  110. $debangkuaidi = [6,7];
  111. $shunfeng = [8,9];
  112. if(in_array($data['province'],$kuayue)){
  113. $com_id = 23;
  114. }
  115. if(in_array($data['province'],$debangkuaidi)){
  116. $com_id = 15;
  117. }
  118. if(in_array($data['province'],$shunfeng)){
  119. $com_id = 1;
  120. }
  121. $expType = $kuaidi_data[$data['province']];
  122. Db::startTrans();
  123. $order->makeSendSelf($address,$data['remark']??'',$com_id,$expType);
  124. Db::commit();
  125. $this->success();
  126. }
  127. }
  128. /**
  129. * 判断是否是同城
  130. **/
  131. public function is_same_city(){
  132. $address_id = $this->request->request("address_id");
  133. $order_id = $this->request->request("order_id");
  134. $address = \app\admin\model\Address::lock(true)->find($address_id)->toArray();
  135. if(!$address){
  136. $this->error('发货地址不存在');
  137. }
  138. $order_address = \app\common\model\OrderAddress::where(['order_id'=>$order_id])->find()->toArray();
  139. if(!$order_address){
  140. $this->error('订单地址不存在');
  141. }
  142. $cityId = explode(',',$order_address['area']);
  143. $to_city = \app\common\model\Area::where(['id'=>$cityId[1]])->value('name');
  144. if(!$to_city){
  145. $this->error('未获取订单地址');
  146. }
  147. $from_city = explode("/",$address['area']);
  148. if(isset($from_city[1])){
  149. $type = '0';
  150. if($to_city == $from_city[1]){
  151. $type = '1';
  152. }
  153. $this->success('获取成功','',['type'=>$type]);
  154. }
  155. $this->error('发货地址格式错误');
  156. }
  157. #详情
  158. public function detail($ids){
  159. $voucher=input('voucher');
  160. if($voucher){
  161. $ids=\app\admin\model\OrderVoucher::where('id',$ids)->value('order_id');
  162. }
  163. $refund=input('refund');
  164. if($refund){
  165. $ids=Refund::where('id',$ids)->value('order_id');
  166. }
  167. //当前是否为关联查询
  168. $this->relationSearch = true;
  169. //设置过滤方法
  170. $this->request->filter(['strip_tags', 'trim']);
  171. if ($this->request->isAjax()) {
  172. //如果发送的来源是Selectpage,则转发到Selectpage
  173. if ($this->request->request('keyField')) {
  174. return $this->selectpage();
  175. }
  176. list($where, $sort, $order, $offset, $limit) = $this->buildparams();
  177. $list = OrderInfo::where($where)
  178. ->with(['refund'])
  179. ->where('order_info.order_id',$ids)
  180. ->select();
  181. $result = array("total" => $list->count(), "rows" => $list->all());
  182. return json($result);
  183. }
  184. $this->assign('refund_status',Refund::getRefundStatus());
  185. $this->assign('refund_type',Refund::getRefundTypes());
  186. $this->assign('order',$this->model->find($ids));
  187. return $this->view->fetch();
  188. }
  189. #发票
  190. public function tax($ids){
  191. $order=$this->model->find($ids);
  192. if($this->request->isGet()){
  193. $this->assign('row',$order);
  194. return $this->fetch();
  195. }else{
  196. $data=input('row/a');
  197. $this->validate($data,[
  198. 'tax_link|发票'=>['require',],
  199. ]);
  200. $order['tax_link']=$data['tax_link'];
  201. $order->save();
  202. $this->success();
  203. }
  204. }
  205. #查看物流
  206. public function logistics($ids){
  207. $order=$this->model->find($ids);
  208. $timeLine=logistics()
  209. ->setLogistics($order->logistics->com)
  210. ->setPhone($order->address->mobile)
  211. ->setUserName($order->address->name)
  212. ->setNo($order->logistics->trans_no)
  213. ->query();
  214. $this->assign('timeLine',$timeLine);
  215. return $this->fetch();
  216. }
  217. #收款
  218. public function payed($ids){
  219. Db::startTrans();
  220. $order=$this->model->lock(true)->find($ids);
  221. if($order->is_wait_pay){
  222. $order->makePay();
  223. }
  224. Db::commit();
  225. $this->success();
  226. }
  227. #md
  228. public function md($ids){
  229. $order=$this->model->find($ids);
  230. if($this->request->isGet()){
  231. return $this->fetch();
  232. }else{
  233. list($isSuc,$data)=logistics()
  234. ->setLogistics($order->logistics->com)
  235. ->setUserName($order->address->name)
  236. ->setPhone($order->address->mobile)
  237. ->setToArea($order->address->address)
  238. ->setFromUsername($order->logistics->from_username)
  239. ->setFromMobile($order->logistics->from_mobile)
  240. ->setFromArea($order->logistics->fullArea())
  241. ->setCargo(implode(',',$order->info()->column('goods_name')))
  242. ->setCount($order->info()->sum('num'))
  243. ->setOrderNo($order->order_no)
  244. ->labelOrder();
  245. if(!$isSuc){
  246. $this->error($data);
  247. }
  248. $this->success();
  249. }
  250. }
  251. }