function _filter(&$map)
{
//用户只能查看自己发布的信息
if (!authsuperadmin(session('uid'))) {
$map['_logic'] = 'and';
$map['uid'] = array('eq', session("uid"));
}
if (IS_POST) {
if (isset($_REQUEST['s_startdt']) && $_REQUEST['s_startdt'] != '' && isset($_REQUEST['s_enddt']) && $_REQUEST['s_enddt'] != '') {
$map['_logic'] = 'or';
$map['startdt'] = array(array('egt', I('s_startdt')), array('elt', I('s_enddt')));
$map['_logic'] = 'or';
$map['enddt'] = array(array('egt', I('s_startdt')), array('elt', I('s_enddt')));
}
if (isset($_REQUEST['s_title']) && $_REQUEST['s_title'] != '') {
$map['_logic'] = 'and';
$map['title'] = array('like', "%" . I('s_title') . "%");
}
if (isset($_REQUEST['s_orgname']) && $_REQUEST['s_orgname'] != '' || isset($_REQUEST['s_keysname']) && $_REQUEST['s_keysname'] != '') {
$map['_logic'] = 'and';
//$map['_string'] = 'status=1 AND score>10';
$map['_string'] = " 1=1 ";
if (isset($_REQUEST['s_orgname']) && $_REQUEST['s_orgname'] != '') {
$map['_string'] .= " and concat(',',orgsname,',') regexp concat(',(',replace('" . $_REQUEST['s_orgname'] . "',',','|'),'),')";
}
if (isset($_REQUEST['s_keysname']) && $_REQUEST['s_keysname'] != '') {
$map['_string'] .= " and concat(',',keysname,',') regexp concat(',(',replace('" . $_REQUEST['s_keysname'] . "',',','|'),'),')";
}
}
if (isset($_REQUEST['s_importantid']) && $_REQUEST['s_importantid'] != '') {
$map['_logic'] = 'and';
$map['importantid'] = array('eq', I('s_importantid'));
}
if (isset($_REQUEST['s_statusid']) && $_REQUEST['s_statusid'] != '' && $_REQUEST['s_statusid'] != '-1') {
$map['_logic'] = 'and';
$map['status'] = array('eq', I('s_statusid'));
}
//return $map;
//var_dump($map);
}
}
public function GetReservByID($id)
{
$demo = M("uv_getmeetingreserv");
$list = $demo->where("id = '" . $id . "'")->select();
/*
$list=$demo->table(C('DB_PREFIX')."meetingreserv a")
->join("left join ".C('DB_PREFIX')."meeting b ON (a.meetingid=b.id)")
->join("left join ".C('DB_PREFIX')."user c ON (a.userid=c.id)")
->field("a.id,a.meetingid,b.name,c.username,a.title,
date_format(a.startdate,'%Y-%m-%d') as startdate,
date_format(a.starttime,'%H:%i') as starttime,
date_format(a.endtime,'%H:%i') as endtime,
a.status,a.note,a.hasallday,a.timelength,a.orgid,a.userid,
b.hastv,b.hasprojection,b.hasvideo,b.hastel")
->order("a.startdate,a.startdate desc")
->where("a.id = '".$id."'")
->select();
echo $demo->getLastSql();
*/
$nowDate = date('Y-m-d', time());
$Date315 = date('Y') . "-03-15";
$Date331 = date('Y-m-d', time());
if (intval(date("n", time())) >= 4) {
$Date331 = date('Y') + 1 . "-03-31";
} else {
$Date331 = date('Y') . "-03-31";
}
// if($nowDate>=$Date315&&$nowDate<=$Date331)
// {
$maxDate = $Date331;
// }
// else
// {
// $maxDate="2050-12-31";
// }
//var_dump($maxDate);
//var_dump($demo->getLastSql());
//die();
$builtindevices = $list[0]["builtindevices"];
$listbuiltindevices = array();
if ($builtindevices == '' || !isset($builtindevices)) {
$listbuiltindevices = array("hastv" => "unchecked", "hasprojection" => "unchecked", "hasvideo" => "unchecked", "hastel" => "unchecked");
} else {
$arrbuiltindevices = explode(',', $builtindevices);
$listbuiltindevices = array("hastv" => $arrbuiltindevices[0], "hasprojection" => $arrbuiltindevices[1], "hasvideo" => $arrbuiltindevices[2], "hastel" => $arrbuiltindevices[3]);
}
//工厂长，部长，副总，总经理，秘书 可以预约 5#和接待室
$demo = M("meetingreserv");
$listdep = array();
//新增时没有会议室ID，用社员ID进行筛选
if ($id != "0" && isset($id)) {
$listdep = $demo->table(C('DB_PREFIX') . "user a")->join("left join " . C('DB_PREFIX') . "meetroomauthgroup b ON (a.meetroomauthgroupid=b.id)")->join("left join " . C('DB_PREFIX') . "meetingreserv c ON (a.id=c.userid)")->field("b.rules")->where("c.id='" . $id . "'")->select();
} else {
$listdep = $demo->table(C('DB_PREFIX') . "user a")->join("left join " . C('DB_PREFIX') . "meetroomauthgroup b ON (a.meetroomauthgroupid=b.id)")->field("b.rules")->where("a.id='" . session('uid') . "'")->select();
}
// var_dump($demo->getLastSql());
// die();
if (isset($listdep) && count($listdep) > 0) {
$result = $listdep[0]["rules"];
} else {
$result = "";
}
$demo = M('meeting');
if (authsuperadmin(session('uid'))) {
$listz = $demo->where(array('status' => 1))->select();
} else {
if ($result != "") {
$listz = $demo->where("status='1' and id in (" . $result . ")")->select();
}
}
//var_dump($demo->getLastSql());
//die();
//var_dump($list[0]);
// die();
//工厂长，部长，副总，总经理，秘书 可以预约 5#和接待室
$this->assign('orgName', $this->getOrgNameByUid($id));
$this->assign('id', $id);
$this->assign('builtindeviceslist', $listbuiltindevices);
$this->assign('beforlist', $list[0]);
$this->assign('maxDate', $maxDate);
$this->assign('listz', $listz);
}
