submit.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 178 行
PHP
178 行
<?
include_once 'inc/auth.php';
include_once 'inc/check_type.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>
</script>
</head>
<body class="bodycolor" topmargin="5">
';
$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');
echo '
<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">';
echo '<s';
echo 'pan 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 == '') OR ($OVER_STATUS == '1')))
{
$OVER_STATUS1 = '<font color=\'#00AA00\'><b>已完成</span>';
}
else
{
if (($OVER_STATUS == '0'))
{
$OVER_STATUS1 = '<font color=\'#FF0000\'><b>未完成</span>';
}
}
$CAL_TYPE = get_code_name ($CAL_TYPE, 'CAL_TYPE');
if ((0 < compare_time ($CUR_TIME, $END_TIME)))
{
$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))
{
echo '
<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="cent';
echo 'er">安排人</td>
<td nowrap align="center">时间状态</td>
<td nowrap align="center">完成状态</td>
</thead>
';
}
echo ' <tr class="TableData">
<td nowrap align="center">';
echo substr ($CAL_TIME, 0, -3);
echo '</td>
<td nowrap align="center">';
echo substr ($END_TIME, 0, -3);
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>
</tr>
';
}
if (($CAL_COUNT == 0))
{
message ('', '无符合条件的日程安排');
button_back ();
exit ();
}
else
{
echo '</table>
';
button_back ();
}
echo '</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?