Order.php 7.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228
  1. <?php
  2. namespace app\api\controller\company;
  3. use app\common\controller\Apic;
  4. use think\Db;
  5. use alipaysdkphpallmaster\aop\AopClient;
  6. use alipaysdkphpallmaster\aop\request\AlipayTradePayRequest;
  7. /**
  8. * 订单管理
  9. */
  10. class Order extends Apic
  11. {
  12. protected $noNeedLogin = [];
  13. protected $noNeedRight = '*';
  14. private function status_text($status){
  15. $arr = [
  16. 1 => '待支付',
  17. 2 => '待处理',
  18. 3 => '已完成',
  19. 4 => '已取消',
  20. ];
  21. return isset($arr[$status]) ? $arr[$status] : '';
  22. }
  23. //
  24. public function lists(){
  25. $keyword = input('keyword','');
  26. $starttime = input('starttime',0);
  27. $endtime = input('endtime',0);
  28. $servicetype_id = intval(input('servicetype_id',0));
  29. $status = intval(input('status',0));
  30. $where = [
  31. 'company_id' => $this->auth->company_id,
  32. ];
  33. //员工
  34. if($this->auth->type == 2){
  35. $where['staff_id'] = $this->auth->id;
  36. }//员工
  37. if($starttime || $endtime){
  38. $where['createtime'] = ['between',$starttime,$endtime];
  39. }
  40. if($servicetype_id){
  41. $where['servicetype_id'] = $servicetype_id;
  42. }
  43. if($status){
  44. $where['status'] = $status; //状态:1=待支付,2=待处理,3=已核销(完成),4=已取消
  45. }
  46. if(!empty($keyword))
  47. {
  48. $where['user_car_number|user_mobile'] = ['LIKE','%'.$keyword.'%'];
  49. }
  50. $list = Db::name('order')->alias('order')
  51. ->join('servicetype','order.servicetype_id = servicetype.id','LEFT')
  52. ->field('order.id,orderno,ordertype,user_name,user_car_number,createtime,servicetype_id,server_info,status,finish_time,cancel_reason,servicetype.title as servicetype_title,servicetype.baoyang_switch')->where($where)->order('order.id desc')->autopage()->select();
  53. foreach($list as $key => &$val){
  54. $val['status_text'] = $this->status_text($val['status']);
  55. }
  56. $this->success(1,$list);
  57. }
  58. //详情
  59. public function info(){
  60. $id = input('id',0);
  61. $info = Db::name('order')->alias('order')
  62. ->join('servicetype','order.servicetype_id = servicetype.id','LEFT')
  63. ->field('order.*,servicetype.title as servicetype_title,servicetype.baoyang_switch')
  64. ->where('order.id',$id)->find();
  65. $info = info_domain_image($info,['server_images']);
  66. $info['status_text'] = $this->status_text($info['status']);
  67. $info['appen_list'] = Db::name('order_appen')->where('order_id',$id)->select();
  68. $this->success(1,$info);
  69. }
  70. //取消
  71. public function cancel(){
  72. $id = input('id',0);
  73. $reason = input('reason','');
  74. $info = Db::name('order')->where('id',$id)->where('company_id',$this->auth->company_id)->find();
  75. if($info['status'] == 4){
  76. $this->error('当前订单已经取消');
  77. }
  78. if($info['status'] != 0 && $info['status'] != 2){
  79. $this->error('当前订单状态不能取消');
  80. }
  81. if($info['ordertype'] == 3){
  82. $this->error('套餐订单不能取消');
  83. }
  84. //取消
  85. $rs = Db::name('order')->where('id',$id)->update(['status'=>4,'cancel_time'=>time(),'finish_time'=>time(),'cancel_reason'=>$reason]);
  86. if($rs === false){
  87. $this->error('取消失败');
  88. }
  89. $this->success('取消成功');
  90. }
  91. //完成
  92. public function finish(){
  93. $id = input('id',0);
  94. Db::startTrans();
  95. $info = Db::name('order')->where('id',$id)->where('company_id',$this->auth->company_id)->lock(true)->find();
  96. if($info['status'] != 2){
  97. Db::rollback();
  98. $this->error('当前订单不能完成');
  99. }
  100. //完成
  101. $rs = Db::name('order')->where('id',$id)->update(['status'=>3,'finish_time'=>time(),'staff_id'=>$this->auth->id]);
  102. if($rs === false){
  103. Db::rollback();
  104. $this->error('操作失败');
  105. }
  106. //给门店加钱
  107. if($info['ordertype'] == 3 && $info['paytype'] == 3 && $info['pay_fee'] > 0){
  108. $wallet_rs = model('walletcompany')->lockChangeAccountRemain($this->auth->company_id,'money',$info['pay_fee'],203,$remark='套餐订单完成服务','order',$id);
  109. if($wallet_rs['status'] === false){
  110. Db::rollback();
  111. $this->error($wallet_rs['msg']);
  112. }
  113. }
  114. //是否弹出保养
  115. $baoyang_switch = Db::name('servicetype')->where('id',$info['servicetype_id'])->value('baoyang_switch');
  116. $this->success('操作成功',$baoyang_switch);
  117. }
  118. //设置保养时间提醒
  119. public function baoyang(){
  120. $id = input('id',0);
  121. $info = Db::name('order')->where('id',$id)->where('company_id',$this->auth->company_id)->find();
  122. if(!$info){
  123. $this->error('不存在的订单');
  124. }
  125. //更新
  126. $next_date = input('next_date','');
  127. $next_carlicheng = input('next_carlicheng','');
  128. $data = [
  129. 'next_date' => $next_date,
  130. 'next_carlicheng' => $next_carlicheng,
  131. ];
  132. Db::name('order')->where('id',$id)->update($data);
  133. $this->success('操作成功');
  134. }
  135. //追加列表
  136. public function appen_lists(){
  137. $id = input('id',0);
  138. $info = Db::name('order')->field('id,orderno,pay_fee,appen_fee')->where('id',$id)->where('company_id',$this->auth->company_id)->find();
  139. if(!$info){
  140. $this->error('不存在的订单');
  141. }
  142. $info['appen_list'] = Db::name('order_appen')->where('order_id',$id)->select();
  143. $this->success(1,$info);
  144. }
  145. //追加新费用
  146. public function appen_newone(){
  147. $id = input('id',0);
  148. Db::startTrans();
  149. $info = Db::name('order')->field('id,orderno,pay_fee,appen_fee')->where('id',$id)->where('company_id',$this->auth->company_id)->lock(true)->find();
  150. if(!$info){
  151. $this->error('不存在的订单');
  152. }
  153. //加入新的一条
  154. $name = input('name','');
  155. $price = intval(input('price',0));
  156. if($price <= 0){
  157. Db::rollback();
  158. $this->error('请填写正确的金额');
  159. }
  160. $data = [
  161. 'order_id' => $id,
  162. 'name' => $name,
  163. 'price' => $price,
  164. 'createtime' => time(),
  165. ];
  166. $log_id = Db::name('order_appen')->insertGetId($data);
  167. if(!$log_id){
  168. Db::rollback();
  169. $this->error('操作失败');
  170. }
  171. //计算追加总额做冗余
  172. $sum_price = Db::name('order_appen')->where('order_id',$id)->sum('price');
  173. $rs = Db::name('order')->where('id',$id)->update(['appen_fee'=>$sum_price]);
  174. if($rs === false){
  175. Db::rollback();
  176. $this->error('操作失败');
  177. }
  178. //结束
  179. Db::commit();
  180. $this->success();
  181. }
  182. }