Preorder.php 5.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155
  1. <?php
  2. namespace app\api\controller\company;
  3. use app\common\controller\Apic;
  4. use app\common\service\UserService;
  5. use think\Db;
  6. use think\Log;
  7. /**
  8. * 预约管理
  9. */
  10. class Preorder extends Apic
  11. {
  12. protected $noNeedLogin = [];
  13. protected $noNeedRight = '*';
  14. //列表
  15. public function lists(){
  16. $pre_order_status = input('pre_order_status',1);
  17. $where = [
  18. 'po.company_id' => $this->auth->company_id,
  19. 'po.pre_order_status' => $pre_order_status,
  20. ];
  21. $list = Db::name('pre_order')->alias('po')->field('po.*,servicetype.title')
  22. ->join('servicetype','po.servicetype_id = servicetype.id','LEFT')
  23. ->where($where)->order('po.id desc')->autopage()->select();
  24. $this->success(1,$list);
  25. }
  26. //取消
  27. public function cancel(){
  28. $id = input('pre_order_id',0);
  29. $cancel_reason = input('cancel_reason','');
  30. $update = [
  31. 'cancel_reason' => $cancel_reason,
  32. 'cancel_time' => time(),
  33. 'updatetime' => time(),
  34. 'pre_order_status' => 0,
  35. ];
  36. Db::name('pre_order')->where('id',$id)->where('company_id',$this->auth->company_id)->update($update);
  37. $userService = new UserService();
  38. $params['pre_order_id'] = $id;
  39. $preOrderRes = $userService->msgPreOrder($params);
  40. if (!$preOrderRes['status']) {
  41. Log::error('pre_order_id:'.$id.' error:'.$preOrderRes['msg']);
  42. }
  43. $this->success('取消成功');
  44. }
  45. //详情
  46. public function info(){
  47. $id = input('pre_order_id',0);
  48. $info = Db::name('pre_order')->alias('po')
  49. ->field('po.*,servicetype.title as servicetype_title')
  50. ->join('servicetype','po.servicetype_id = servicetype.id','LEFT')
  51. ->where('po.id',$id)->find();
  52. $this->success(1,$info);
  53. }
  54. //车牌号或手机号搜用户
  55. public function searchuser(){
  56. $keyword = input('keyword','');
  57. //先搜手机
  58. $where = [
  59. 'mobile' => ['LIKE','%'.$keyword.'%']
  60. ];
  61. $user_ids = Db::name('user')->where($where)->column('id');
  62. //再搜车牌
  63. $where = [
  64. 'car_number' => ['LIKE','%'.$keyword.'%']
  65. ];
  66. $car_user_ids = Db::name('user_car')->where($where)->column('user_id');
  67. //合并用户ids
  68. $new_user_ids = array_merge($user_ids,$car_user_ids);
  69. $new_user_ids = array_flip(array_flip($new_user_ids));
  70. //搜用户
  71. $user_list = Db::name('user')->field('id,mobile,nickname')->where('id','IN',$new_user_ids)->autopage()->select();
  72. foreach($user_list as $key => &$val){
  73. $user_car = Db::name('user_car')->where('user_id',$val['id'])->select();
  74. $val['car_list'] = $user_car;
  75. $val['address'] = Db::name('user_wallet')->where('user_id',$val['id'])->where('company_id',$this->auth->company_id)->value('address');
  76. }
  77. $this->success(1,$user_list);
  78. }
  79. //预约开单 在线开单
  80. public function submit_order(){
  81. $pre_order_id = input('pre_order_id',0); //预约单id
  82. $data = request_post_hub([
  83. 'user_name','user_car_number','user_mobile','user_address',
  84. 'servicetype_id','server_time','server_info','server_images','pay_fee'
  85. ]);
  86. //检查用户
  87. $user_info = Db::name('user')->where('mobile',$data['user_mobile'])->find();
  88. if(empty($user_info)){
  89. $this->error('不存在的用户,请先让客户扫店铺码注册');
  90. }
  91. $data['user_id'] = $user_info['id'];
  92. //预约单
  93. $pre_order = [];
  94. if($pre_order_id > 0){
  95. $map = ['id'=>$pre_order_id,'company_id'=>$this->auth->company_id,'pre_order_status'=>1];
  96. $pre_order = Db::name('pre_order')->where($map)->find();
  97. if(empty($pre_order)){
  98. $this->error('不存在的预约单');
  99. }else{
  100. $data['pre_order_id'] = $pre_order_id;
  101. //数据一致性
  102. if($pre_order['user_id'] != $data['user_id']){
  103. $this->error('预约单用户非当前用户');
  104. }
  105. }
  106. //修改状态
  107. $update = [
  108. 'order_time' => time(),
  109. 'updatetime' => time(),
  110. 'pre_order_status' => 2,
  111. ];
  112. Db::name('pre_order')->where('id',$pre_order_id)->update($update);
  113. }else{
  114. $data['pre_order_id'] = 0;
  115. }
  116. //检索car_id,没必要了
  117. //准备数据
  118. $data['orderno'] = createUniqueNo('O',$this->auth->id);
  119. $data['ordertype'] = ($pre_order_id > 0) ? 1 : 2; //类型:1=预约下单,2=在线下单,3=套餐订单
  120. $data['company_id'] = $this->auth->company_id;
  121. $data['staff_id'] = $this->auth->id;
  122. $data['total_fee'] = $data['pay_fee'];
  123. $data['status'] = 2; //2=已支付,待处理
  124. $data['createtime'] = time();
  125. $order_id = Db::name('order')->insertGetId($data);
  126. $this->success('下单完成',$order_id);
  127. }
  128. //查看预约单下的订单
  129. }