📄 submit.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>日程安排查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
</script>
</head>
<body class="bodycolor" topmargin="5">
<?
$connection=OpenConnection();
$CUR_DATE=date("Y-m-d",time());
$CUR_TIME=date("Y-m-d H:i:s",time());
//----------- 合法性校验 ---------
if($SEND_TIME_MIN!="")
{
$TIME_OK=is_date($SEND_TIME_MIN);
if(!$TIME_OK)
{ Message("错误","\"日期\"的格式不对，应形如 ".$CUR_DATE);
Button_Back();
exit;
}
$SEND_TIME_MIN=$SEND_TIME_MIN." 00:00:00";
}
if($SEND_TIME_MAX!="")
{
$TIME_OK=is_date($SEND_TIME_MAX);
if(!$TIME_OK)
{ Message("错误","\"日期\"的格式不对，应形如 ".$CUR_DATE);
Button_Back();
exit;
}
$SEND_TIME_MAX=$SEND_TIME_MAX." 23:59:59";
}
//------------------------ 生成条件字符串 ------------------
$CONDITION_STR="";
if($CAL_TYPE!="")
$CONDITION_STR.=" and CAL_TYPE=$CAL_TYPE";
if($CONTENT!="")
$CONDITION_STR.=" and CONTENT like '%".$CONTENT."%'";
if($SEND_TIME_MIN!="")
$CONDITION_STR.=" and CAL_TIME>='$SEND_TIME_MIN'";
if($SEND_TIME_MAX!="")
$CONDITION_STR.=" and END_TIME<='$SEND_TIME_MAX'";
$query = "SELECT * from CALENDAR where USER_ID='$LOGIN_USER_ID'".$CONDITION_STR." order by CAL_TIME,END_TIME";
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/infofind.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 日程安排查询结果</span><br>
</td>
</tr>
</table>
<?
$cursor=exequery($connection,$query);
$CAL_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$CAL_COUNT++;
$CAL_ID=$ROW["CAL_ID"];
$CAL_TIME=$ROW["CAL_TIME"];
$END_TIME=$ROW["END_TIME"];
$CAL_TYPE=$ROW["CAL_TYPE"];
$CONTENT=$ROW["CONTENT"];
$MANAGER_ID=$ROW["MANAGER_ID"];
$OVER_STATUS=$ROW["OVER_STATUS"];
$MANAGER_NAME="";
if($MANAGER_ID!="")
{
$query = "SELECT * from USER where USER_ID='$MANAGER_ID'";
$cursor1= exequery($connection,$query);
if($ROW1=mysql_fetch_array($cursor1))
$MANAGER_NAME=$ROW1["USER_NAME"];
}
$CONTENT=str_replace("<","<",$CONTENT);
$CONTENT=str_replace(">",">",$CONTENT);
$CONTENT=stripslashes($CONTENT);
if($OVER_STATUS=="" || $OVER_STATUS=="1")
$OVER_STATUS1="<font color='#00AA00'><b>已完成</span>";
elseif($OVER_STATUS=="0")
$OVER_STATUS1="<font color='#FF0000'><b>未完成</span>";
switch($CAL_TYPE)
{
case "1":
$CAL_TYPE="工作事务";
break;
case "2":
$CAL_TYPE="个人事务";
break;
}
if(compare_time($CUR_TIME,$END_TIME)>0)
$STATUS="<font color='#FF0000'><b>过期</span>";
else if(compare_time($CUR_TIME,$CAL_TIME)<0)
$STATUS="<font color='#0000AA'><b>未至</span>";
else
$STATUS="<font color='#00AA00'><b>进行中</span>";
if($CAL_COUNT==1)
{
?>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<thead class="TableHeader">
<td nowrap align="center">开始时间 <img border=0 src="/images/arrow_up.gif" width="11" height="10"></td>
<td nowrap align="center">结束时间</td>
<td nowrap align="center">事务类型</td>
<td nowrap align="center">事务内容</td>
<td nowrap align="center">安排人</td>
<td nowrap align="center">时间状态</td>
<td nowrap align="center">完成状态</td>
</thead>
<?
}
?>
<tr class="TableData">
<td nowrap align="center"><?=$CAL_TIME?></td>
<td nowrap align="center"><?=$END_TIME?></td>
<td nowrap align="center"><?=$CAL_TYPE?></td>
<td><?=$CONTENT?></td>
<td nowrap align="center"><?=$MANAGER_NAME?></td>
<td nowrap align="center"><?=$STATUS?></td>
<td nowrap align="center"><?=$OVER_STATUS1?></td>
</tr>
<?
}
if($CAL_COUNT==0)
{
Message("","无符合条件的日程安排");
Button_Back();
exit;
}
else
{
?>
</table>
<?
Button_Back();
}
?>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -