hyarra = array('等待中', '会议中', '结束', '取消'); $this->ytarra = array('等待', '待进行', '进行中', '已结束'); $this->hyarrb = array('green', 'blue', '#ff6600', '#888888'); } /** * 判断会议室是否重复申请了 */ public function isapplymsg($startdt, $enddt, $hyname, $id=0, $meetType=1) { $msg = ''; if ($meetType == 1) { $sql = /** @lang text */ 'select id, meeting_room, start_time, end_time, title from [Q]meeting where id <> '.$id.' and meet_state in (0, 1) union all select id, meeting_room, start_time, end_time, title from [Q]meeting_key where meet_state in (0, 1) '; } else { $sql = /** @lang text */ 'select id, meeting_room, start_time, end_time, title from [Q]meeting where meet_state in (0, 1) union all select id, meeting_room, start_time, end_time, title from [Q]meeting_key where id <> '.$id.' and meet_state in (0, 1)'; } m('log')->addlog("验证1", $sql); $rows = $this->db->getall($sql); foreach($rows as $k=>$rs){ // m('log')->addlog("验证2", $rs['meeting_room']); // m('log')->addlog("验证3", $hyname); if($rs['meeting_room'] != $hyname)continue; $sdt = $rs['start_time']; $edt = $rs['end_time']; // m('log')->addlog("验证", json_encode($rs)); 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')->getall("mid={$meeting_id}", "id", 'sort'); if (isset($topic[0]['id'])) { m('meeting_topics')->update(['topic_state'=>'2'], 'id='.$topic[0]['id']); } if (isset($topic[1]['id'])) { m('meeting_topics')->update(['topic_state'=>'1'], 'id='.$topic[1]['id']); } } // 会议室状态 public function getstatezt($zt) { if (isset($this->hyarrb[$zt])) { $html = ''.$this->hyarra[$zt].''; return $html; } else { return null; } } // 会议状态 public function meetingState($stime, $etime, $type=1) { // type == 1 获取状态码， type==2获取状态名 $code = [0, 1, 2]; $info = m('meeting')->hyarra; if ($stime > date("Y-m-d H:i:s")) { // 开始时间比当前时间大——未开始 return $type == 1 ? $code[0] : $info[0]; } else if ($etime < date("Y-m-d H:i:s")) { // 当前时间 比 结束时间比——已结束 return $type == 1 ? $code[2] : $info[2]; } else { // 在时间段内——会议中 return $type == 1 ? $code[1] : $info[1]; } } }