📄 index.php
字号:
<?php
include_once( "inc/auth.php" );
echo "\r\n<html>\r\n<head>\r\n<title>今日外出登记</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n\r\n";
$connection = openconnection( );
$CUR_DATE = date( "Y-m-d", time( ) );
$query = "SELECT * from ATTEND_OUT where USER_ID='{$LOGIN_USER_ID}' and to_days(SUBMIT_TIME)=to_days('{$CUR_DATE}')";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
echo "<s";
echo "cript Language=JavaScript>\r\nwindow.setTimeout('this.location.reload();',30000);\r\n</script>\r\n";
}
echo "\r\n";
echo "<s";
echo "cript>\r\nfunction CheckForm()\r\n{\r\n\r\n if(document.form1.OUT_TIME1.value==\"\" || document.form1.OUT_TIME2.value==\"\")\r\n { alert(\"外出起止时间不能为空！\");\r\n return (false);\r\n }\r\n\r\n if(document.form1.OUT_TYPE.value==\"\")\r\n { alert(\"外出原因不能为空！\");\r\n return (false);\r\n }\r\n\r\n return (true);\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n<table border=\"0\" width=\"1";
echo "00%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/attendance.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\"> 今日外出登记</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<br>\r\n<div align=\"center\">\r\n\r\n";
$query = "SELECT * from ATTEND_OUT where USER_ID='{$LOGIN_USER_ID}' and to_days(SUBMIT_TIME)=to_days('{$CUR_DATE}') and STATUS='0'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$OUT_TIME1 = $ROW['OUT_TIME1'];
$OUT_TIME2 = $ROW['OUT_TIME2'];
$OUT_TYPE = $ROW['OUT_TYPE'];
$ALLOW = $ROW['ALLOW'];
$OUT_TYPE = str_replace( "<", "<", $OUT_TYPE );
$OUT_TYPE = str_replace( ">", ">", $OUT_TYPE );
$OUT_TYPE = stripslashes( $OUT_TYPE );
}
if ( $OUT_TIME1 == "" )
{
$CUR_TIME = date( "H:i", time( ) );
echo " <form action=\"out.php\" method=\"post\" name=\"form1\" class=\"big1\" onsubmit=\"return CheckForm();\">\r\n <b>\r\n 因 <input type=\"text\" name=\"OUT_TYPE\" size=\"20\" maxlength=\"50\" class=\"BigInput\">\r\n 由 <input type=\"text\" name=\"OUT_TIME1\" size=\"5\" maxlength=\"5\" class=\"BigInput\" value=\"";
echo $CUR_TIME;
echo "\">\r\n 至 <input type=\"text\" name=\"OUT_TIME2\" size=\"5\" maxlength=\"5\" class=\"BigInput\" value=\"";
echo $CUR_TIME;
echo "\">\r\n 向 ";
echo "<s";
echo "elect name=\"LEADER_ID\" class=\"BigSelect\">\r\n";
$connection = openconnection( );
$COUNT = 0;
$query = "select * from ATTEND_MANAGER where MANAGER_ID=1";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$MANAGER_ID = $ROW['MANAGER_ID'];
$MANAGERS = $ROW['MANAGERS'];
}
$query = "SELECT * from USER";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_ID = $ROW['USER_ID'];
$USER_NAME = $ROW['USER_NAME'];
if ( find_id( $MANAGERS, $USER_ID ) )
{
++$COUNT;
echo " <option value=\"";
echo $USER_ID;
echo "\">";
echo $USER_NAME;
echo "</option>\r\n\r\n";
}
}
if ( $COUNT == 0 )
{
$query = "SELECT * from USER_PRIV where USER_PRIV={$LOGIN_USER_PRIV}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$PRIV_NO = $ROW['PRIV_NO'];
}
$query = "SELECT * from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV and PRIV_NO<={$PRIV_NO} order by PRIV_NO,USER_NAME";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_ID = $ROW['USER_ID'];
$USER_NAME = $ROW['USER_NAME'];
echo " <option value=\"";
echo $USER_ID;
echo "\">";
echo $USER_NAME;
echo "</option>\r\n";
}
}
echo " </select>\r\n <input type=\"submit\" value=\"申请外出\" class=\"BigButton\" title=\"申请外出\">\r\n </b>\r\n </form>\r\n";
}
else if ( $ALLOW == "0" )
{
message( "", "今日，因 ".$OUT_TYPE." 由 ".$OUT_TIME1." 至 ".$OUT_TIME2." 申请外出，领导尚未批示" );
echo " <br>\r\n <br>\r\n <input type=\"button\" value=\"撤销申请\" class=\"BigButton\" onclick=\"location='delete.php'\" title=\"撤销申请\"> \r\n";
}
else if ( $ALLOW == "1" )
{
message( "", "今日，因 ".$OUT_TYPE." 由 ".$OUT_TIME1." 至 ".$OUT_TIME2." 申请外出，领导批示：已批准" );
echo " <br>\r\n <br>\r\n <input type=\"button\" value=\"外出归来\" class=\"BigButton\" onclick=\"location='back.php'\" title=\"外出归来\"> \r\n";
}
else if ( $ALLOW == "2" )
{
message( "", "今日，因 ".$OUT_TYPE." 由 ".$OUT_TIME1." 至 ".$OUT_TIME2." 申请外出，领导批示：不批准" );
echo " <br>\r\n <br>\r\n <input type=\"button\" value=\"删除申请\" class=\"BigButton\" onclick=\"location='delete.php'\" title=\"删除申请\"> \r\n";
}
echo "</div>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -