office_automation/webmain/model/meetingModel.php

<?php

class meetingClassModel extends Model
{

    public $hyarra, $ytarra, $hyarrb;

    public function initModel()
    {
        $this->hyarra = array('正常', '会议中', '结束', '取消');
        $this->ytarra = array('待进行', '待进行', '进行中', '已结束');
        $this->hyarrb = array('green', 'blue', '#ff6600', '#888888');
    }

    /**
     *	判断会议室是否重复申请了
     */
//    public function isapplymsg($startdt, $enddt, $hyname, $id=0)
//    {
//        $msg 		= '';
//        $rows 		= $this->getall("id <> '$id' and `meet_state` in(0,1)");
////        $gdrow		= m('flow')->initflow('meeting')->createmeet(0, substr($startdt,0,10) ,true);//从固定会议中读取
////        foreach($gdrow as $k1=>$rs1)$rows[]=$rs1;
//
//        foreach($rows as $k=>$rs){
//            if($rs['meeting_room'] != $hyname)continue;
//            $sdt = $rs['start_time'];
//            $edt = $rs['end_time'];
//            if(
//                ($sdt<=$startdt && $edt>$startdt)
//                || ($sdt<$enddt && $edt>=$enddt)
//                || ($sdt>$startdt && $edt<$enddt)
//                || ($sdt==$startdt && $edt==$enddt)
//            )$msg = '该会议室的时间段已被申请过了，主题“'.$rs['title'].'”';
//        }
//        return $msg;
//    }


    public function isapplymsg($startdt, $enddt, $hyname, $id=0)
    {
        $msg 		= '';
        $sql        = `select id, meeting_room, start_time, end_time from xinhu_meeting  where id <> {$id} and meet_state in (0, 1)
                       union ALL
                       select id, meeting_room, start_time, end_time from xinhu_meeting_key where id <> {$id} and meet_state in (0, 1)`;
        $rows 		= $this->db->getall($sql);

        foreach($rows as $k=>$rs){
            if($rs['meeting_room'] != $hyname)continue;
            $sdt = $rs['start_time'];
            $edt = $rs['end_time'];
            if(
                ($sdt<=$startdt && $edt>$startdt)
                || ($sdt<$enddt && $edt>=$enddt)
                || ($sdt>$startdt && $edt<$enddt)
                || ($sdt==$startdt && $edt==$enddt)
            )$msg = '该会议室的时间段已被申请过了，主题“'.$rs['title'].'”';
        }
        return $msg;
    }

    public function firstMeetingTopicStart($meeting_id) {

        $topic = m('meeting_topics')->getone("mid={$meeting_id}", "id", 'sort');
        if (isset($topic['id'])) {
            m('meeting_topics')->update(['topic_state'=>'2'], 'id='.$topic['id']);
        }
    }

    // 会议室状态
    public function getstatezt($zt)
    {
        if (isset($this->hyarrb[$zt])) {
            $html = '<font color="'.$this->hyarrb[$zt].'">'.$this->hyarra[$zt].'</font>';
            return $html;
        } else {
            return null;
        }
    }
}