model = Db::name('pre_order'); } /** * 列表 * @return void */ public function getList(){ try { $preOrderStatus = input('pre_order_status',''); $po = 'pre_order'; $st = 'servicetype'; $o = 'order'; $where[$po.'.user_id'] = $this->auth->id; $where[$po.'.company_id'] = $this->auth->company_id; if ($preOrderStatus != '') { $where[$po.'.pre_order_status'] = $preOrderStatus; } $field = $po.'.id,name,mobile,address,remark,'.$po.'.car_id,'.$po.'.car_number,pre_time,order_time,'.$po.'.cancel_time,'. $po.'.cancel_reason,'.$st.'.title,pre_order_status,'.$o.'.id as `order_id`,'.$o.'.server_time'; $result = $this->model->alias($po)->field($field) ->join($st,$st.'.id = '.$po.'.servicetype_id','LEFT') ->join($o,$o.'.pre_order_id = '.$po.'.id','LEFT') ->where($where)->order($po.'.createtime desc')->autopage()->select(); if (!empty($result)) { $model = model('PreOrder'); $statusArr = $model->getPreOrderStatusList(); $timeArr = ['pre_time','order_time','cancel_time','server_time']; foreach ($result as $key => &$value) { foreach ($timeArr as $k => $v) { $value[$v] = !empty($value[$v]) ? date('Y年m月d日 H:i:s', $value[$v]) : ''; } $value['order_id'] = empty($value['order_id']) ? 0 : $value['order_id']; $value['pre_order_status_text'] = isset($statusArr[$value['pre_order_status']]) ? $statusArr[$value['pre_order_status']] : ''; } } $this->success('获取成功', $result); } catch (Exception $e) { $this->error($e->getMessage()); } } /** * 保存 * @return void */ public function save() { try { //验证参数 $id = $this->request->param('id',0); $carId = $this->request->param('car_id',0); $preTime = $this->request->param('pre_time',''); $name = $this->request->param('name', ''); $mobile = $this->request->param('mobile', ''); $userId = $this->auth->id; $companyId = $this->auth->company_id; $scene = !empty($id) ? 'edit' : 'add'; $validate = validate('PreOrder'); if(!$validate->check($this->request->param(),[],$scene)){ throw new Exception($validate->getError()); } $preTime = strtotime($preTime); //获取车辆信息 $userCarWhere['user_id'] = $userId; $userCarWhere['id'] = $carId; $userCar = Db::name('user_car')->where($userCarWhere)->find(); if (empty($userCar)) { throw new Exception('未找到车辆信息'); } $time = time(); $carNo = isset($userCar['car_number']) ? $userCar['car_number'] : ''; $data = [ 'name' => $name, 'mobile' => $mobile, 'address' => $this->request->param('address', ''), 'remark' => $this->request->param('remark', ''), 'car_id' => $carId, 'car_number' => $carNo, 'servicetype_id' => $this->request->param('servicetype_id', 0), 'pre_time' => $preTime, ]; if (empty($id)) { $data['company_id'] = $companyId; $data['pre_order_no'] = createUniqueNo('PO',$userId); $data['user_id'] = $userId; $data['createtime'] = $time; $res = $this->model->insertGetId($data); $id = $res; //绑定门店 $userService = new UserService(); $userParams = [ 'user_id' => $userId, 'company_id' => $companyId, 'comefrom' => '平台引流',//来源 ]; $userBindRes = $userService->userWallet($userParams); if (!$userBindRes['status']) { throw new Exception($userBindRes['msg']); } //用户预约发送短信通知 $service = new PreOrderService(); $params = [ 'company_id' => $companyId,//门店ID 'name' => $name,//联系人 'mobile' => $mobile,//手机号 'pre_time' => $preTime,//预约时间 ]; $service->preOrderToUser($params); } else { $data['updatetime'] = $time; $where['id'] = $id; $where['user_id'] = $userId; $res = $this->model->where($where)->update($data); } if (!$res) { throw new Exception('操作失败'); } $result = [ 'pre_order_id' => $id, 'template_ids' => config('param.wechat_template_ids'),//微信消息模版ID ]; $this->success('操作成功',$result); } catch (Exception $e) { $this->error($e->getMessage()); } } /** * 微信消息通知 * @return void */ public function wxMessage() { try { $preOrderId = $this->request->param('pre_order_id',0); $userService = new UserService(); $params = ['pre_order_id' => $preOrderId]; $wechatMsgRes = $userService->wechatMessageSend($params); if (!$wechatMsgRes['status']) { throw new Exception($wechatMsgRes['msg']); } $this->success('操作成功'); } catch (Exception $e) { $this->error($e->getMessage()); } } /** * 详情 * @return void */ public function getInfo() { try { $id = $this->request->param('id',0); $po = 'pre_order'; $st = 'servicetype'; $o = 'order'; $where[$po.'.user_id'] = $this->auth->id; $where[$po.'.company_id'] = $this->auth->company_id; $where[$po.'.id'] = $id; $field = $po.'.id,name,mobile,address,remark,'.$po.'.car_id,'.$po.'.car_number,pre_time,order_time,'. $po.'.cancel_time,'.$po.'.cancel_reason,'.$po.'.createtime,'.$po.'.servicetype_id,'.$st. '.title as `servicetype_title`,pre_order_status,'.$o.'.id as `order_id`'; $result = $this->model->alias($po)->field($field) ->join($st,$st.'.id = '.$po.'.servicetype_id','LEFT') ->join($o,$o.'.pre_order_id = '.$po.'.id','LEFT') ->where($where)->order($po.'.createtime desc')->find(); if (!empty($result)) { $model = model('PreOrder'); $statusArr = $model->getPreOrderStatusList(); $timeArr = ['pre_time','order_time','cancel_time','createtime']; foreach ($timeArr as $k => $v) { $result[$v] = !empty($result[$v]) ? date('Y年m月d日 H:i:s', $result[$v]) : ''; } $result['order_id'] = empty($result['order_id']) ? 0 : $result['order_id']; $result['pre_order_status_text'] = isset($statusArr[$result['pre_order_status']]) ? $statusArr[$result['pre_order_status']] : ''; } $this->success('获取成功',$result); } catch (Exception $e) { $this->error($e->getMessage()); } } /** * 取消 * @return void */ public function cancel() { try { $id = $this->request->param('id',0); $cancelReason = $this->request->param('cancel_reason',''); $time = time(); $where['user_id'] = $this->auth->id; $where['id'] = $id; $modelData = model('PreOrder')->where($where)->find(); if (empty($modelData)) { throw new Exception('未找到预约信息'); } if ($modelData['pre_order_status'] != 1) { throw new Exception('该预约单无法取消或已取消'); } $modelData->pre_order_status = 0; $modelData->cancel_reason = $cancelReason; $modelData->cancel_time = $time; $res = $modelData->save(); if (!$res) { throw new Exception('操作失败'); } $this->success('操作成功'); } catch (Exception $e) { $this->error($e->getMessage()); } } }