office_automation/webmain/model/meeting_keyModel.php

<?php

class meeting_keyClassModel extends Model
{
    public $tp;
    public function initModel()
    {
        parent::initModel(); // TODO: Change the autogenerated stub

        $this->tp = [
            'mor'=>[
                'name'=>'上午',
                'start_time'=>"06:30:00",
                'end_time'=>'13:00:00'
            ],
            'aft'=>[
                'name'=>'下午',
                'start_time'=>"13:00:00",
                'end_time'=>'18:00:00'
            ]
        ];
    }


    public function getTopicList($mid) {
        $topics = $this->db->getall("select `id`, `topic_title`, `topic_attendee`, `topic_state`, `topic_info` from `[Q]meeting_topics` where mid = {$mid} order by sort");
        $meetingTopic = array_fill(0, count($topics) - 1, null);

        // 会议议题处理
        for ($i = 0,$j = 0; $i < count($topics); $i++) {
            $info = $topics[$i];

            $ts = $info['topic_state'];
            $tt = $info['topic_title'];
            $ti = $info['topic_info'];
            $pl = str_replace("\n", "<br />", $ti);

            // 用于排序（已结束放最后）
            if ($ts == 3) {
                $index = count($topics) - 1 - $j++;
            } else {
                $index = $i-$j;
            }
            $mt = $meetingTopic[$index];
            $mt['state'] = $ts;
            $mt['tip'] = m("meeting")->ytarra[$ts];
            $mt['text'] = $tt;
            $mt['personnel_list'] = $pl;

            if ($ts == 2) {
                // 当前议题 + 参会人员
                $data['participants'][] = [
                    "topics" => $tt,
                    "personnel_list" => $pl,
                ];
                // 下一议题 + 参会人员
                if (isset($topics[$i + 1])) {
                    $t = $topics[$i + 1];
                    $ntt = $t['topic_title'];
                    $npl = str_replace("\n", "<br />", $t['topic_info']);
                    $data['participants'][] = [
                        "topics" => $ntt,
                        "personnel_list" => $npl,
                    ];
                }
            }
            $meetingTopic[$index] = $mt;
        }
        return $meetingTopic;

    }

    public function getNowTopic($mid)
    {
        $topics = $this->db->getone("[Q]meeting_topics", "mid = {$mid} and topic_state = 2", "*", "sort");
        if ($topics) {
            $topics['topic_info'] = str_replace("\n", "<br />", $topics['topic_info']);
        }
        return $topics;
    }

    public function getNextTopic($mid) {

        $topics = $this->db->getone("[Q]meeting_topics", "mid = {$mid} and topic_state = 1", "*", "sort");
        if ($topics) {
            $topics['topic_info'] = str_replace("\n", "<br />", $topics['topic_info']);
        }
        return $topics;
    }

    public function getRecTopic($mid) {

//        $topics = $this->db->getall("[Q]meeting_topics", "mid = {$mid} and topic_state in (1, 2)", "*", "topic_state desc, sort");
        $sqlStr = "select * from [Q]meeting_topics where mid = {$mid} and topic_state in (1, 2) order by topic_state desc, sort";
        $topics = $this->db->getall($sqlStr);
//        for ($i = 0; $i < count($topics); $i++) {
//            $topic = $topics[$i];
//            $topics[$i]['topic_info'] = str_replace("\n", "<br />", $topic['topic_info']);
//        }
        return $topics;
    }

}