index.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 244 行
PHP
244 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>日程安排</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript 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';
echo '="small">
<tr>
<td class="Big"><img src="/images/menu/calendar.gif" WIDTH="22" HEIGHT="20" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 新建事务（';
echo $YEAR;
echo '年';
echo $MONTH;
echo '月';
echo $DAY;
echo '日）</span><br>
</td>
</tr>
</table>
<div align="center">
<input type="button" value="新建事务" class="BigButton" onClick="window.open(\'new?YEAR=';
echo $YEAR;
echo '&MONTH=';
echo $MONTH;
echo '&DAY=';
echo $DAY;
echo '\',\'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>
';
$CUR_TIME = date ('Y-m-d H:i:s', time ());
echo '
<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">';
echo '<s';
echo 'pan class="big3"> 管理日程安排（';
echo $YEAR;
echo '年';
echo $MONTH;
echo '月';
echo $DAY;
echo '日）</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 = htmlspecialchars ($CONTENT);
if ((($OVER_STATUS == '') OR ($OVER_STATUS == '1')))
{
$OVER_STATUS1 = '<font color=\'#00AA00\'><b>已完成</b></font>';
}
else
{
if (($OVER_STATUS == '0'))
{
$OVER_STATUS1 = '<font color=\'#FF0000\'><b>未完成</b></font>';
}
}
$CAL_TYPE = get_code_name ($CAL_TYPE, 'CAL_TYPE');
if ((0 < compare_time ($CUR_TIME, $END_TIME)))
{
$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))
{
echo ' <table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
';
}
echo ' <tr class="TableData">
<td nowrap align="center">';
echo $CAL_TIME;
echo '</td>
<td nowrap align="center">';
echo $END_TIME;
echo '</td>
<td nowrap align="center">';
echo $CAL_TYPE;
echo '</td>
<td>';
echo $CONTENT;
echo '</td>
<td nowrap align="center">';
echo $MANAGER_NAME;
echo '</td>
<td nowrap align="center">';
echo $STATUS;
echo '</td>
<td nowrap align="center">';
echo $OVER_STATUS1;
echo '</td>
<td nowrap align="center" width="170">
<a href="javascript:my_note(';
echo $CAL_ID;
echo ');"> 便笺</a>
';
if (($OVER_STATUS == '0'))
{
echo ' <a href="status.php?CAL_ID=';
echo $CAL_ID;
echo '&OVER_STATUS=1&YEAR=';
echo $YEAR;
echo '&MONTH=';
echo $MONTH;
echo '&DAY=';
echo $DAY;
echo '"> 完成</a>
';
}
else
{
if ((($OVER_STATUS == '') OR ($OVER_STATUS == '1')))
{
echo ' <a href="status.php?CAL_ID=';
echo $CAL_ID;
echo '&OVER_STATUS=0&YEAR=';
echo $YEAR;
echo '&MONTH=';
echo $MONTH;
echo '&DAY=';
echo $DAY;
echo '"> 未完成</a>
';
}
}
if ((($MANAGER_ID == '') OR ($MANAGER_ID == $LOGIN_USER_ID)))
{
echo ' <a href="modify.php?CAL_ID=';
echo $CAL_ID;
echo '&YEAR=';
echo $YEAR;
echo '&MONTH=';
echo $MONTH;
echo '&DAY=';
echo $DAY;
echo '"> 修改</a>
<a href="delete.php?CAL_ID=';
echo $CAL_ID;
echo '&YEAR=';
echo $YEAR;
echo '&MONTH=';
echo $MONTH;
echo '&DAY=';
echo $DAY;
echo '"> 删除</a>
';
}
echo ' </td>
</tr>
';
}
if (($CAL_COUNT == 0))
{
message ('', '无日程安排');
}
else
{
echo ' <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">完成状';
echo '态</td>
<td nowrap align="center">操作</td>
</thead>
</table>
';
}
echo '
<div align="center">
<br>
<input type="button" value="返回" class="BigButton" onClick="location=\'../index.php?YEAR=';
echo $YEAR;
echo '&MONTH=';
echo $MONTH;
echo '\';">
</div>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?