request->param(); $validate = new \think\Validate([ ['page', 'number'], ['pagenum', 'number|<=:1000'] ]); if (!$validate->check($post)) { $this->json_error('提交失败:' . $validate->getError()); } $where = []; $addressIds = (new appointmentModel())->availableAddressIds(); $where['id'] = ['in', $addressIds]; $pagenum = $this->request->param('pagenum', 20, 'intval'); $datalist = (new Address())->where($where)->paginate($pagenum, true); if (empty($datalist)) { $this->json_error("没有数据"); } $this->json_success("查询成功", $datalist); } //按地址id获取号源信息 public function getTicketByAddressId() { $post = $this->request->param(); $validate = new \think\Validate([ ['address_id', 'require|number'], ['daytime', 'dateFormat:Y-m-d'], ]); if (!$validate->check($post)) { $this->json_error('提交失败:' . $validate->getError()); } $address_id = $this->request->param('address_id'); $daytime = $this->request->param('daytime', date('Y-m-d')); $ticketModel = new AppointmentTicket(); $tickets = $ticketModel->where('address_id', $address_id)->where('appointment_daytime', strtotime($daytime))->select(); foreach ($tickets as $k => $item) { $appoint = $item->appointment; $item['price'] = $appoint->price; //日期 $item['appointment_daytime_text'] = date('Y-m-d', $item->appointment_daytime); //专家信息 $item->specialist; $item->specialist->head_pic = geturl($item->specialist->head_pic, '', true); //剩余预约号码 $item['morning_remaining'] = $appoint->morning_num - $item->morning_use; $item['afternoon_remaining'] = $appoint->afternoon_num - $item->afternoon_use; $item['night_remaining'] = $appoint->night_num - $item->night_use; //拆分预约时段 $ticketPeriods = (new AppointmentApplication())->where('appointment_ticket_id', $item->id)->column('appointment_time'); $item['morning_time_period'] = $this->setPeriodStatus(DateHelper::splitTimePeriod($appoint->morning_start_time, $appoint->morning_end_time, $appoint->morning_num), $ticketPeriods); $item['afternoon_time_period'] = $this->setPeriodStatus(DateHelper::splitTimePeriod($appoint->afternoon_start_time, $appoint->afternoon_end_time, $appoint->afternoon_num), $ticketPeriods); $item['night_time_period'] = $this->setPeriodStatus(DateHelper::splitTimePeriod($appoint->night_start_time, $appoint->night_end_time, $appoint->night_num), $ticketPeriods); $tickets[$k] = $item; } $this->json_success($tickets); } /** * @param $timePeriods array 拆分的时间段 * @param $ticketPeriods array 已经预约的时间段 * @return array */ private function setPeriodStatus($timePeriods, $ticketPeriods) { $arr = []; foreach ($timePeriods as $ticket => $period) { if (in_array($period, $ticketPeriods)) { $arr[] = ['period' => $period, 'status' => 1]; } else { $arr[] = ['period' => $period, 'status' => 0]; } } return $arr; } //按时间获取地址列表 public function addressListByDayTime() { appointmentModel::createTicketFromAllAppointment(); $ticketModel = new AppointmentTicket(); //可预约日期列表 // $maxEndTime = $ticketModel->max('end_time'); // $daylist = DateHelper::getDateList(date('Y-m-d'), date('Y-m-d', $maxEndTime), true); $post = $this->request->param(); $validate = new \think\Validate([ ['daytime', 'date|dateFormat:Y-m-d'], ['page', 'number'], ['pagenum', 'number|<=:1000'] ]); if (!$validate->check($post)) { $this->json_error('提交失败:' . $validate->getError()); } $daytime = $this->request->param('daytime', date('Y-m-d')); $addressIds = $ticketModel->where('appointment_daytime', strtotime($daytime))->column('address_id'); $where = []; $where['id'] = ['in', $addressIds]; $pagenum = $this->request->param('pagenum', 20, 'intval'); $datalist = (new Address())->where($where)->paginate($pagenum, true); if (empty($datalist)) { $this->json_error("没有数据"); } $this->json_success("查询成功", $datalist); } }