Order.php 5.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198
  1. <?php
  2. namespace app\admin\controller\shop;
  3. use app\common\controller\Backend;
  4. /**
  5. *
  6. *
  7. * @icon fa fa-circle-o
  8. */
  9. class Order extends Backend
  10. {
  11. /**
  12. * Order模型对象
  13. * @var \app\admin\model\Order
  14. */
  15. protected $model = null;
  16. public function _initialize()
  17. {
  18. parent::_initialize();
  19. $this->model = new \app\admin\model\Order;
  20. }
  21. /**
  22. * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
  23. * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
  24. * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
  25. */
  26. /**
  27. * 查看
  28. */
  29. public function index()
  30. {
  31. //当前是否为关联查询
  32. $this->relationSearch = false;
  33. //设置过滤方法
  34. $this->request->filter(['strip_tags']);
  35. if ($this->request->isAjax())
  36. {
  37. //如果发送的来源是Selectpage,则转发到Selectpage
  38. if ($this->request->request('keyField'))
  39. {
  40. return $this->selectpage();
  41. }
  42. list($where, $sort, $order, $offset, $limit) = $this->buildparams();
  43. $total = $this->model
  44. ->where($where)
  45. ->order($sort, $order)
  46. ->count();
  47. $list = $this->model
  48. ->where($where)
  49. ->order($sort, $order)
  50. ->limit($offset, $limit)
  51. ->select();
  52. foreach ($list as $row) {
  53. $row['status']=config('orderStatus')[$row['orderStatus']];
  54. }
  55. $list = collection($list)->toArray();
  56. $result = array("total" => $total, "rows" => $list);
  57. return json($result);
  58. }
  59. return $this->view->fetch();
  60. }
  61. /* 订单详情 */
  62. function info()
  63. {
  64. $ids=input('ids');
  65. $orderinfo=db('order')->where(['id'=>$ids])->find();
  66. $orderinfo['status']=config('orderStatus')[$orderinfo['orderStatus']];
  67. if(empty($orderinfo))
  68. {
  69. $this->error('订单不存在');
  70. }
  71. $goods=db('order_goods')->where(['orderid'=>$ids])->select();
  72. if(empty($goods))
  73. {
  74. $goods=[];
  75. }
  76. $this->view->assign([
  77. 'info'=>$orderinfo,
  78. 'goods'=>$goods,
  79. ]);
  80. return $this->view->fetch();
  81. }
  82. /* 发货 */
  83. function send()
  84. {
  85. if ($this->request->isPost()) {
  86. $params=$this->request->post('row/a');
  87. if(empty($params['express']))
  88. {
  89. $this->error("请输入快递公司名称");
  90. }
  91. if(empty($params['expressNo']))
  92. {
  93. $this->error("请输入快递单号");
  94. }
  95. $params['orderStatus']=2;
  96. $params['utime']=time();
  97. $res=db('order')->where(['id'=>$params['id']])->update($params);
  98. if($res)
  99. {
  100. $orderinfo=db('order')->where(['id'=>$params['id']])->find();
  101. db('order_log')->insertGetId(['orderid'=>$params['id'],'content'=>'您的订单已发货,请注意查收','userid'=>$orderinfo['userid'],'ctime'=>time()]);
  102. $this->success("发货完成");
  103. }else{
  104. $this->error("发货失败");
  105. }
  106. }
  107. $ids=input('ids');
  108. $this->view->assign('id',$ids);
  109. return $this->view->fetch();
  110. }
  111. function cancelsend()
  112. {
  113. $ids=input('ids');
  114. $orderinfo=db('order')->where(['id'=>$ids])->find();
  115. if(empty($orderinfo))
  116. {
  117. $this->error('要操作的数据不存在');
  118. }else{
  119. db()->startTrans();
  120. $orgoods=db('order_goods')->where(['orderid'=>$ids])->find();
  121. $res1=db('order')->where(['id'=>$ids])->update(['orderStatus'=>-1,'utime'=>time()]);
  122. $res2=db('goods')->where(['id'=>$orgoods['goodsid']])->update(['on_sale'=>1]);
  123. if($res1 && $res2)
  124. {
  125. db()->commit();
  126. $this->success('取消成功');
  127. }else{
  128. db()->rollback();
  129. $this->error('取消失败');
  130. }
  131. }
  132. }
  133. /* 退款 */
  134. function refund()
  135. {
  136. if ($this->request->isPost()) {
  137. $isagree=$this->request->post('isagree');
  138. $id=$this->request->post('id');
  139. $orderinfo=db('order')->where(['id'=>$id])->find();
  140. if($isagree == 1)
  141. {
  142. $res=db('order')->where(['id'=>$id])->update(['orderStatus'=>-3,'utime'=>time()]);
  143. $changedata=[
  144. 'type'=>15,
  145. 'money'=>$orderinfo['totalMoney']+$orderinfo['deliverMoney'],
  146. 'userid'=>$orderinfo['userid'],
  147. 'relevant_userid'=>$orderinfo['userid'],
  148. 'remark'=>'取消返还',
  149. ];
  150. $res=caiwu($changedata, 'bonus');
  151. if($res)
  152. {
  153. db('order_log')->insertGetId(['orderid'=>$id,'content'=>'您的订单已同意退款申请,请注意查收退款额','userid'=>$orderinfo['userid'],'ctime'=>time()]);
  154. $this->success("退款完成");
  155. }else{
  156. $this->error("退款失败");
  157. }
  158. }else{
  159. $express=$this->request->post('express');
  160. if(empty($express))
  161. {
  162. $this->error('请输入物流公司');
  163. }
  164. $expressNo=$this->request->post('expressNo');
  165. if(empty($expressNo))
  166. {
  167. $this->error('请输入快递单号');
  168. }
  169. $res=db('order')->where(['id'=>$id])->update(['orderStatus'=>2,'express'=>$express,'expressNo'=>$expressNo,'utime'=>time()]);
  170. if($res)
  171. {
  172. db('order_log')->insertGetId(['orderid'=>$id,'content'=>'您的订单已发货,请注意查收','userid'=>$orderinfo['userid'],'ctime'=>time()]);
  173. $this->success("操作完成");
  174. }else{
  175. $this->error("操作失败");
  176. }
  177. }
  178. }
  179. $ids=input('ids');
  180. $orderinfo=db('order')->where(['id'=>$ids])->find();
  181. $this->view->assign('info',$orderinfo);
  182. return $this->view->fetch();
  183. }
  184. }