index.php
来自「极限网络智能办公系统 Office Automation V3.0官方100％源」· PHP 代码 · 共 184 行
PHP
184 行
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>日程安排</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language=JavaScript>
window.setTimeout('this.location.reload();',60000);
function my_note(CAL_ID)
{
window.open("../note.php?CAL_ID="+CAL_ID,"note_win"+CAL_ID,"height=200,width=250,status=0,toolbar=no,menubar=no,location=no,scrollbars=auto,resizable=no");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/calendar.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 新建事务（<?=$YEAR?>年<?=$MONTH?>月<?=$DAY?>日）</span><br>
</td>
</tr>
</table>
<div align="center">
<input type="button" value="新建事务" class="BigButton" onClick="window.open('new?YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&DAY=<?=$DAY?>','oa_sub_window','height=300,width=500,status=0,toolbar=no,menubar=no,location=no,left=300,top=200,scrollbars=yes,resizable=yes');" title="创建新的事务，以便提醒自己">
</div>
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
<tr>
<td background="/images/dian1.gif" width="100%"></td>
</tr>
</table>
<?
$connection=OpenConnection();
$CUR_TIME=date("Y-m-d H:i:s",time());
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/calendar.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 管理日程安排（<?=$YEAR?>年<?=$MONTH?>月<?=$DAY?>日）</span>
</td>
</tr>
</table>
<br>
<?
//============================ 显示日程安排 =======================================
$query = "SELECT * from CALENDAR where USER_ID='$LOGIN_USER_ID' and TO_DAYS(CAL_TIME)=TO_DAYS('$YEAR-$MONTH-$DAY') order by CAL_TIME"; $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>已完成</b></font>";
elseif($OVER_STATUS=="0")
$OVER_STATUS1="<font color='#FF0000'><b>未完成</b></font>";
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>过期</b></font>";
else if(compare_time($CUR_TIME,$CAL_TIME)<0)
$STATUS="<font color='#0000AA'><b>未至</b></font>";
else
$STATUS="<font color='#00AA00'><b>进行中</b></font>";
$CAL_TIME=strtok($CAL_TIME," ");
$CAL_TIME=strtok(" ");
$END_TIME=strtok($END_TIME," ");
$END_TIME=strtok(" ");
if($CAL_COUNT==1)
{
?>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<?
}
?>
<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>
<td nowrap align="center" width="170">
<a href="javascript:my_note(<?=$CAL_ID?>);"> 便笺</a>
<?
if($OVER_STATUS=="0")
{
?>
<a href="status.php?CAL_ID=<?=$CAL_ID?>&OVER_STATUS=1&YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&DAY=<?=$DAY?>"> 完成</a>
<?
}
elseif($OVER_STATUS=="" || $OVER_STATUS=="1")
{
?>
<a href="status.php?CAL_ID=<?=$CAL_ID?>&OVER_STATUS=0&YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&DAY=<?=$DAY?>"> 未完成</a>
<?
}
if($MANAGER_ID=="" || $MANAGER_ID==$LOGIN_USER_ID)
{
?>
<a href="modify.php?CAL_ID=<?=$CAL_ID?>&YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&DAY=<?=$DAY?>"> 修改</a>
<a href="delete.php?CAL_ID=<?=$CAL_ID?>&YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&DAY=<?=$DAY?>"> 删除</a>
<?
}
?>
</td>
</tr>
<?
}
if($CAL_COUNT==0)
{
Message("","无日程安排");
}
else
{
?>
<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>
<td nowrap align="center">操作</td>
</thead>
</table>
<?
}
?>
<div align="center">
<br>
<input type="button" value="返回" class="BigButton" onClick="location='../index.php?YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>';">
</div>
</body>
</html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?