office_automation/webmain/task/openapi/openmeetAction.php

<?php

/**
 *    会议相关
 *    请求地址如：http://oa.test/api.php?m=openmeet&a=test&openkey=fee5efd3a93ca5c6a85b679cde60faa2
 */
class openmeetClassAction extends openapiAction
{

    public function testAction() {
        $str = $this->postdata;
        return json_encode($str);
    }

    // 绑定设备
    public function bindDeviceAction() {
        $rawArr = $this->getpostarr();

        if (!isset($rawArr['device_id'])) {
            return [
                "code"=>-1,
                "message"=>"参数错误！"
            ];
        }

        $rawData = m('meeting_room')->getone(" mac like '%{$rawArr['device_id']}%'", "id, room_name");

        $meetData = m('meeting')->getone(" status = 1 and meet_state = 1 and meeting_room = '{$rawData['room_name']}'");

        $now = date('Y年m月d日('.$this->getWeek().') H:i');

        if ($rawData['id'] ?? 0 > 0) {
            return [
                "code"=>200,
                "message"=>"已绑定",
                "data"=>[
                    "room_id"=>$rawData['id'],
                    "meetingRoomName"=>$rawData['room_name'],
                    "meetingTime"=>$now,
                    "stateText"=>isset($meetData['id']) ? "会议中" : "空闲中",
                    "meetingState"=>isset($meetData['id']),
                    "meetingId"=>$meetData['id'] ?? null,
                ]
            ];
        } else {
            return [
                "code"=>0,
                "message"=>"设备未绑定!"
            ];
        }
    }

    // 获取会议信息
    public function getMeetInfoAction() {
        $rawArr = $this->getpostarr();

        if (!isset($rawArr['room_id'])) {
            return [
                "code"=>-1,
                "message"=>"参数错误！",
                "data"=>[
                    "meetingState"=>False
                ]
            ];
        }

        $rawData = m('meeting_room')->getone(" id = '{$rawArr['room_id']}'");

        if (!isset($rawData['room_name'])) {
            return [
                "code"=>-1,
                "message"=>"未找到会议室！",
                "data"=>[
                    "meetingState"=>False
                ]
            ];
        }

        $sqlStr = /** @lang text */
            "SELECT 1 as type, id, title, start_time, end_time, null as compere, meet_state  FROM `xinhu_meeting` where start_time REGEXP '".date("Y-m-d")."' and meeting_room = '".$rawData['room_name']."'
             union all
             SELECT 2 as type, id, title, start_time, end_time, compere, meet_state  FROM `xinhu_meeting_key` where start_time REGEXP '".date("Y-m-d")."' and meeting_room = '".$rawData['room_name']."'";

        $meetData = $this->db->getall($sqlStr);

        if (count($meetData) == 0) {
            return [
                "code"=>2,
                "message"=>"暂无会议！",
                "data"=>[
                    "meetingState"=>False,
                    "data" => $rawData['room_name']
                ]
            ];
        }


        $data = [];

        for ($i = 0; $i < count($meetData); $i++) {
            $meeting = $meetData[$i];
            $data['meeting_list'][$i] = [
                "meeting_name"=>$meeting['title'],
                "meeting_time"=>date("H:i", strtotime($meeting['start_time'])).' ~ '.date("H:i", strtotime($meeting['end_time'])),
                "meeting_moderator"=>$meeting['compere'],
                "meeting_state"=>$meeting['meet_state'],
                "meeting_state_text"=>m("meeting")->hyarra[$meeting['meet_state']],
            ];

            // 时间到了自动结束一下
            if ($meeting['end_time'] < date("Y-m-d H:i:s")) {
                if ($meeting['type'] == 1) {
                    m("meeting")->update(["meet_state"=>2], "id=".$meeting['id']);
                } else {
                    m("meeting_key")->update(["meet_state"=>2], "id=".$meeting['id']);
                }
            }
        }

        $nowMeetingSql = /** @lang text */
            "SELECT 1 as type, id, title, start_time, end_time, null as compere, meet_state, meeting_room  FROM `xinhu_meeting` where start_time < now() and end_time > now() and meeting_room = '".$rawData['room_name']."'
             union all
             SELECT 2 as type, id, title, start_time, end_time, compere, meet_state, meeting_room  FROM `xinhu_meeting_key` where start_time < now() and end_time > now() and meeting_room = '".$rawData['room_name']."'";
        $nowMeetingData = $this->db->getall($nowMeetingSql);

//        return $nowMeetingSql;

        if (count($nowMeetingData) > 0) {
            $nowMeet = $nowMeetingData[0];
            $data['$basic_information'] = [
                "meeting_room_name" => $nowMeet['meeting_room'],
                "meeting_name" => $nowMeet['title'],
                "meeting_time" => date("H:i", strtotime($nowMeet['start_time'])).' ~ '.date("H:i", strtotime($nowMeet['end_time'])),
                "meeting_moderator" => $nowMeet['compere'],
            ];
            if ($nowMeet['type'] == 2) {
                $topics = $this->db->getall("select `id`, `topic_title`, `topic_attendee`, `topic_state`, `topic_info` from `[Q]meeting_topics` where mid = {$nowMeet['id']} order by sort");
                $this_topics = [];
                $next_topics = [];
                // 会议议题处理
                for ($i = 0; $i < count($topics); $i++) {
                    $info = $topics[$i];
                    $data['meetingTopic'][$i]['state'] = $info['topic_state'];
                    $data['meetingTopic'][$i]['tip'] = m("meeting")->ytarra[$info['topic_state']];
                    $data['meetingTopic'][$i]['text'] = $info['topic_title'];
                    if ($info['topic_state'] == 2) {
                        $this_topics = [
                            "topics" => $info['topic_title'],
                            "personnel_list" => $info['topic_info'],
                        ];

                        if (isset($topics[$i + 1])) {
                            $next_topics = [
                                "topics" => $topics[$i + 1]['topic_title'],
                                "personnel_list" => $topics[$i + 1]['topic_info'],
                            ];
                        }
                    }

                }

                $data['participants'][] = $this_topics;
                $data['participants'][] = $next_topics;

            } else {
                $data['meetingTopic'] = [];
                $data['participants'] = [];
            }
        } else {
            $data['$basic_information'] = [
                "meeting_room_name" => "空闲中",
                "meeting_name" => null,
                "meeting_time" => null,
                "meeting_moderator" => null,
            ];
            $data['meetingTopic'] = [];
            $data['participants'] = [];
        }


        return $data;

//        $topicMeetingSql = /** @lang text */
//            "SELECT id  FROM `xinhu_meeting_key` where meet_state = 1 and start_time REGEXP '".date("Y-m-d H:i:s")."' and meeting_room = '".$rawData['room_name']."'";

//        $topicMeetingData = $this->db->getall($topicMeetingSql);

//        $topics = $this->db->getall("select `id`, `topic_title`, `topic_attendee`, `topic_state` from `[Q]meeting_topics` where mid = {$topicMeetingSql['id']} order by sort");


        // 将日期时间字符串转换为UNIX时间戳
        $ts = strtotime($meetData['start_time']);
        // 根据需要格式化日期
        $meetStartDate = date("Y年m月d日", $ts);
        $meetDate=$meetStartDate." (".$this->getWeek($meetStartDate).") ".date("H:i", strtotime($meetData['start_time']))."~".date("H:i", strtotime($meetData['end_time']));

        $topicsList = [];

        // 会议议题处理
        for ($i = 0; $i < count($topics); $i++) {
            $info = $topics[$i];
            $topicsList[$i]['id'] = $info['id'];
            $topicsList[$i]['text'] = $info['topic_title'];
            $topicsList[$i]['tip'] = $this->topicState($info['topic_state']);
            $topicsList[$i]['state'] = $info['topic_state'];
            $topicsList[$i]['person'] = explode(',', $info['topic_attendee'] );
        }

        // 接口返回数据
        $res=[
            "code"=>200,
            "message"=>"请求成功！",
            "data"=>[
                "meetingId"=>$rawData['id'],
                "meetingRoomName"=>$rawData['room_name'],
                "meetingName"=>$meetData['title'],
                "meetingTime"=>$meetDate,
                "meetingPerson"=>explode(",", $meetData['attendees']),
                "meetingTopic"=>$topicsList ?? [],
                "meetingState"=>!empty($rawData['mac'])
            ]
        ];
        return $res;
    }

    // 切换议题
    public function switchTopicsAction() {
        $rawArr = $this->getpostarr();

        $this->showreturn($rawArr,'请求成功!');
    }

    protected function topicState($code): string
    {
        $info = '等待';
        switch ($code) {
            case 1:
                $info = '待进行';
                break;
            case 2:
                $info = '进行中';
                break;
            case 3:
                $info = '已结束';
                break;
        }
        return $info;
    }

    protected function getWeek($date=null) {
        if (!isset($date)) {
            $date = date("Y-m-d H:i:s");
        }
        // 将日期转换为时间戳
        $timestamp = strtotime($date);

        // 格式化输出星期几（返回值为英文）
        $weekday_en = date('l', $timestamp);

        // 如果需要显示中文星期几，则需要进行相关处理
        switch ($weekday_en) {
            case 'Monday':
                $weekday_cn = "星期一";
                break;
            case 'Tuesday':
                $weekday_cn = "星期二";
                break;
            case 'Wednesday':
                $weekday_cn = "星期三";
                break;
            case 'Thursday':
                $weekday_cn = "星期四";
                break;
            case 'Friday':
                $weekday_cn = "星期五";
                break;
            case 'Saturday':
                $weekday_cn = "星期六";
                break;
            default:
                $weekday_cn = "星期天";
        }
        return $weekday_cn;
    }

}