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 = /** @lang text */ '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 = ''.$this->hyarra[$zt].''; return $html; } else { return null; } } }