out.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 95 行
PHP
95 行
<?
include_once 'inc/auth.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();\',30000);
</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/attendance.gif" WIDTH="22" HEIGHT="20" align="absm';
echo 'iddle">';
echo '<s';
echo 'pan class="big3"> 外出人员</span><br>
</td>
</tr>
</table>
<br>
';
$CUR_DATE = date ('Y-m-d', time ());
$query = (((''.'SELECT * from ATTEND_OUT,USER,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and ATTEND_OUT.USER_ID=USER.USER_ID and to_days(SUBMIT_TIME)=to_days(\'').$CUR_DATE).'\') and ALLOW=\'1\' order by DEPT_NO,USER.USER_NAME');
$cursor = exequery ($connection, $query);
$OUT_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
++$OUT_COUNT;
$USER_ID = $ROW['USER_ID'];
$USER_NAME = $ROW['USER_NAME'];
$OUT_TYPE = $ROW['OUT_TYPE'];
$OUT_TIME1 = $ROW['OUT_TIME1'];
$OUT_TIME2 = $ROW['OUT_TIME2'];
$DEPT_ID = $ROW['DEPT_ID'];
$query1 = ((''.'select * from DEPARTMENT where DEPT_ID=').$DEPT_ID);
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$USER_DEPT_NAME = $ROW['DEPT_NAME'];
}
if (($OUT_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 $USER_DEPT_NAME;
echo '</td>
<td nowrap align="center">';
echo $USER_NAME;
echo '</td>
<td nowrap align="center">';
echo $OUT_TYPE;
echo '</td>
<td nowrap align="center">';
echo $OUT_TIME1;
echo '</td>
<td nowrap align="center">';
echo $OUT_TIME2;
echo '</td>
</tr>
';
}
if ((0 < $OUT_COUNT))
{
echo ' <thead class="TableHeader">
<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>
';
}
else
{
message ('', '无外出人员');
}
echo '
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location=\'user_all.php\'">
</div>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?