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 getMeetInfoAction() {
        $rawArr = $this->getpostarr();

        if (!isset($rawArr['device_id'])) {
            $this->showreturn([], "参数错误", 201);
        }

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

        if (!isset($rawData['room_name'])) {
            $this->showreturn([], "未找到会议室", 202);
        }

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

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

        if (count($meetData) == 0) {
            $this->showreturn(
                [
                    "meeting_list"=>[],
                    "basic_information"=>[
                        "meeting_room_name" => $rawData['room_name'],
                        "meeting_name" => '空闲中',
                        "meeting_time" => null,
                        "meeting_moderator" => null,
                    ],
                    "meetingTopic"=>[],
                    "participants"=>[]
                ],
                "暂无会议",
                203);
        }

        $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'] == 1 ? 1 : 0,
            ];

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

        $nowMeetingSql = /** @lang text */
            "select * from (
            SELECT 1 as type, id, title, start_time, end_time, null as compere, meet_state, meeting_room, attendees
               FROM `[Q]meeting` 
              where status = 1 
                and 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, null as attendees
               FROM `[Q]meeting_key` 
              where start_time < now() and end_time > now() and meeting_room = '".$rawData['room_name']."'
              ) as t order by start_time";
        $nowMeetingData = $this->db->getall($nowMeetingSql);


        if (count($nowMeetingData) > 0 && $nowMeetingData[0]['meet_state'] != 2) {
            $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'],
            ];
            $data['meetingTopic'] = [];
            $data['participants'] = [];

            // 党委会议（需要加入议题）
            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");
                $j = count($topics);
                $meetingTopic = array_fill(0, count($topics), null);
                // 会议议题处理
                for ($i = 0; $i < count($topics); $i++) {
                    $info = $topics[$i];
                    // 用于排序（已结束放最后）
                    if ($info['topic_state'] == 3) {
                        $index = $j - $i - 1;
                    } else {
                        $index = $i - 2;
                    }
                    $meetingTopic[$index]['state'] = $info['topic_state'];
                    $meetingTopic[$index]['tip'] = m("meeting")->ytarra[$info['topic_state']];
                    $meetingTopic[$index]['text'] = $info['topic_title'];

                    if ($info['topic_state'] == 2) {
                        // 当前议题 + 参会人员
                        $data['participants'][] = [
                            "topics" => $info['topic_title'],
                            "personnel_list" => str_replace("\n", "<br />", $info['topic_info']),
                        ];
                        // 下一议题 + 参会人员
                        if (isset($topics[$i + 1])) {
                            $data['participants'][] = [
                                "topics" => $topics[$i + 1]['topic_title'],
                                "personnel_list" => str_replace("\n", "<br />", $topics[$i + 1]['topic_info']),
                            ];
                        }
                    }
                }
                $data['meetingTopic'] = $meetingTopic;

            } else {
                // 普通会议，议题为空
                $data['meetingTopic'] = [];
                // 基础会议人员信息
                $data['participants'] = [
                    [
                        "topics"=>$nowMeet['title'],
                        "personnel_list"=>str_replace("\n", "<br />", $nowMeet['attendees']),
                    ]
                ];
            }
        } else {
            $data['basic_information'] = [
                "meeting_room_name" => $rawData['room_name'],
                "meeting_name" => '空闲中',
                "meeting_time" => null,
                "meeting_moderator" => null,
            ];
            $data['meetingTopic'] = [];
            $data['participants'] = [];
        }
        $this->showreturn($data, "请求成功");
    }


    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;
    }

}