Preorder.php 5.0 KB

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