reservation_admin/app/api/controller/Appointment.php

<?php

namespace app\api\controller;

use app\api\controller\base\Base;
use app\common\model\Address;
use app\common\model\Appointment as appointmentModel;
use app\common\model\AppointmentApplication;
use time\DateHelper;

class Appointment extends Base
{
    //获取地址列表
    public function addressList()
    {
        $post = $this->request->param();
        $validate = new \think\Validate([
            ['page', 'number'],
            ['pagenum', 'number|<=:1000']
        ]);
        if (!$validate->check($post)) {
            $this->json_error('提交失败：' . $validate->getError());
        }

        $pagenum = $this->request->param('pagenum', 20, 'intval');
        $datalist = (new Address())->paginate($pagenum, true);
        if (empty($datalist)) {
            $this->json_error("没有数据");
        }
        foreach ($datalist as $key => $item) {
            $item['thumb_url'] = geturl($item->thumb, '', true);
            $datalist[$key] = $item;
        }
        $this->json_success("查询成功", $datalist);
    }


    //可预约的地址
    public function availableAddressList()
    {
        $post = $this->request->param();
        $validate = new \think\Validate([
            ['page', 'number'],
            ['pagenum', 'number|<=:1000']
        ]);
        if (!$validate->check($post)) {
            $this->json_error('提交失败：' . $validate->getError());
        }

        $where = [];
        $addressIds = (new appointmentModel())->where('daytime', '>=', strtotime(date('Y-m-d')))->distinct(true)->column('address_id');
        $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("没有数据");
        }
        foreach ($datalist as $key => $item) {
            $item['thumb_url'] = geturl($item->thumb, '', true);
            $datalist[$key] = $item;
        }
        $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 appointmentModel();
        $tickets = $ticketModel->where('address_id', $address_id)->where('daytime', strtotime($daytime))->select();

        foreach ($tickets as $k => $item) {
            //专家信息
            $item->specialist;
            $item->specialist->head_pic = geturl($item->specialist->head_pic, '', true);
            //拆分预约时段
            $ticketPeriods = (new AppointmentApplication())->where('appointment_ticket_id', $item->id)->column('appointment_time');
            $item['morning_time_period'] = $this->setPeriodStatus(DateHelper::splitTimePeriod($item->morning_start_time, $item->morning_end_time, $item->morning_num), $ticketPeriods);
            $item['afternoon_time_period'] = $this->setPeriodStatus(DateHelper::splitTimePeriod($item->afternoon_start_time, $item->afternoon_end_time, $item->afternoon_num), $ticketPeriods);
            $item['night_time_period'] = $this->setPeriodStatus(DateHelper::splitTimePeriod($item->night_start_time, $item->night_end_time, $item->night_num), $ticketPeriods);
            //剩余预约号码
            $item['morning_remaining'] = count($item['morning_time_period']);
            $item['afternoon_remaining'] = count($item['afternoon_time_period']);
            $item['night_remaining'] = count($item['night_time_period']);
            $tickets[$k] = $item;
        }

        $this->json_success("查询成功", $tickets);
    }


    /**
     * @param $timePeriods array 拆分的时间段
     * @param $ticketPeriods array 已经预约的时间段
     * @return array
     */
    private function setPeriodStatus($timePeriods, $ticketPeriods)
    {
        $daytime = $this->request->param('daytime', date('Y-m-d'));
        $arr = [];
        $now = time();
        foreach ($timePeriods as $ticket => $period) {
            //排除过期时段
            $timerang = explode(' - ', $period);
            $period_end = $timerang[1];
            if ($now > strtotime($daytime . ' ' . $period_end)) {
                continue;
            }
            //标记预约状态
            if (in_array($period, $ticketPeriods)) {
//                $arr[] = ['period' => $period, 'status' => 1];
                continue;//排除
            } else {
                $arr[] = ['period' => $period, 'status' => 0];
            }
        }
        return $arr;
    }

    //按时间获取地址列表
    public function addressListByDayTime()
    {
        $ticketModel = new appointmentModel();
        $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('daytime', strtotime($daytime))->distinct(true)->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("没有数据");
        }
        foreach ($datalist as $key => $item) {
            $item['thumb_url'] = geturl($item->thumb, '', true);
            $datalist[$key] = $item;
        }
        $this->json_success("查询成功", $datalist);
    }
}