📄 index.php
字号:
<?php
include_once( "inc/auth.php" );
$query = "select * from SMS2_PRIV";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$TYPE_PRIV = $ROW['TYPE_PRIV'];
}
$query = "select * from SYS_PARA where PARA_NAME='SMS_REMIND'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$PARA_VALUE = $ROW['PARA_VALUE'];
}
$SMS2_REMIND = substr( $PARA_VALUE, strpos( $PARA_VALUE, "|" ) + 1 );
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<script Language=JavaScript>\r\nwindow.setTimeout('this.location.reload();',60000);\r\nfunction LoadWindow2(STATUS,LEAVE_ID,USER_ID)\r\n{\r\n";
if ( find_id( $TYPE_PRIV, 6 ) )
{
echo "\tif(document.all(\"LEAVE_SMS2_REMIND\"+LEAVE_ID).checked)\r\n\t MOBILE_FLAG=1;\r\n else\r\n";
}
echo " MOBILE_FLAG=0;\r\n URL=\"back.php?STATUS=\"+STATUS+\"&LEAVE_ID=\"+LEAVE_ID+\"&USER_ID=\"+USER_ID+\"&MOBILE_FLAG=\"+MOBILE_FLAG;\r\n myleft=(screen.availWidth-650)/2;\r\n window.open(URL,\"formul_edit\",\"height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n}\r\nfunction out_confirm(CONFIRM,USER_ID,SUBMIT_TIME,count)\r\n{\r\n";
if ( find_id( $TYPE_PRIV, 6 ) )
{
echo "\tif(document.all(\"OUT_SMS2_REMIND\"+count).checked)\r\n MOBILE_FLAG=1;\r\n else\r\n";
}
echo " MOBILE_FLAG=0;\r\n\r\n if(CONFIRM==2)\r\n {\r\n URL=\"out_reason.php?CONFIRM=\"+CONFIRM+\"&USER_ID=\"+USER_ID+\"&SUBMIT_TIME=\"+SUBMIT_TIME+\"&MOBILE_FLAG=\"+MOBILE_FLAG;\r\n window.open(URL,\"reason\",\"height=500,width=600,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=200,top=60,resizable=yes\");\r\n }\r\n else\r\n {\r\n URL=\"out_confirm.php?CONFIRM=\"+CONFIRM+\"&USER_ID=\"+USER_ID+\"&SUBMIT_TIME=\"+SUBMIT_TIME+\"&MOBILE_FLAG=\"+MOBILE_FLAG;\r\n window.location=URL;\r\n }\r\n}\r\nfunction leave_confirm(CONFIRM,USER_ID,LEAVE_ID)\r\n{\r\n";
if ( find_id( $TYPE_PRIV, 6 ) )
{
echo "\tif(document.all(\"LEAVE_SMS2_REMIND\"+LEAVE_ID).checked)\r\n\t MOBILE_FLAG=1;\r\n else\r\n";
}
echo " MOBILE_FLAG=0;\r\n\r\n if(CONFIRM==2)\r\n {\r\n URL=\"leave_reason.php?CONFIRM=\"+CONFIRM+\"&USER_ID=\"+USER_ID+\"&MOBILE_FLAG=\"+MOBILE_FLAG+\"&LEAVE_ID=\"+LEAVE_ID;\r\n window.open(URL,\"reason\",\"height=500,width=600,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=200,top=60,resizable=yes\");\r\n }\r\n else\r\n {\r\n URL=\"leave_confirm.php?CONFIRM=\"+CONFIRM+\"&USER_ID=\"+USER_ID+\"&MOBILE_FLAG=\"+MOBILE_FLAG+\"&LEAVE_ID=\"+LEAVE_ID;\r\n window.location=URL;\r\n }\r\n}\r\n\r\nfunction evection_confirm(CONFIRM,EVECTION_ID,USER_ID)\r\n{\r\n";
if ( find_id( $TYPE_PRIV, 6 ) )
{
echo "\tif(document.all(\"EVECTION_SMS2_REMIND\"+EVECTION_ID).checked)\r\n\t MOBILE_FLAG=1;\r\n else\r\n";
}
echo " MOBILE_FLAG=0;\r\n\r\n if(CONFIRM==2)\r\n {\r\n URL=\"evection_reason.php?CONFIRM=\"+CONFIRM+\"&USER_ID=\"+USER_ID+\"&MOBILE_FLAG=\"+MOBILE_FLAG+\"&EVECTION_ID=\"+EVECTION_ID;\r\n window.open(URL,\"reason\",\"height=500,width=600,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=200,top=60,resizable=yes\");\r\n }\r\n else\r\n {\r\n URL=\"evection_confirm.php?CONFIRM=\"+CONFIRM+\"&USER_ID=\"+USER_ID+\"&MOBILE_FLAG=\"+MOBILE_FLAG+\"&EVECTION_ID=\"+EVECTION_ID;\r\n window.location=URL;\r\n }\r\n}\r\n\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
$CUR_DATE = date( "Y-m-d", time( ) );
echo "\r\n<!------------------------------------- 今日外出审批 ------------------------------->\r\n<table border=\"0\" width=\"100%\" 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\"><span class=\"big3\"> 外出审批</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n<br>\r\n\r\n";
if ( $LOGIN_USER_ID == "admin" )
{
$query = "SELECT * from ATTEND_OUT,USER where ATTEND_OUT.USER_ID=USER.USER_ID and ALLOW='0' order by USER.USER_ID";
}
else
{
$query = "SELECT * from ATTEND_OUT,USER where ATTEND_OUT.USER_ID=USER.USER_ID and LEADER_ID='".$LOGIN_USER_ID."' and ALLOW='0' order by USER.USER_ID";
}
$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'];
$ALLOW = $ROW['ALLOW'];
$CREATE_DATE1 = $ROW['CREATE_DATE'];
$DEPT_ID = $ROW['DEPT_ID'];
$SUBMIT_TIME = $ROW['SUBMIT_TIME'];
$SUBMIT_TIME1 = substr( $SUBMIT_TIME, 0, 10 );
$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 class=\"TableList\" width=\"95%\">\r\n";
}
if ( $OUT_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n <td nowrap align=\"center\">";
echo $USER_DEPT_NAME;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $USER_NAME;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $CREATE_DATE1;
echo "</td>\r\n <td>";
echo $OUT_TYPE;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $SUBMIT_TIME1;
echo " ";
echo $OUT_TIME1;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $SUBMIT_TIME1;
echo " ";
echo $OUT_TIME2;
echo "</td>\r\n <td nowrap align=\"center\">\r\n";
if ( find_id( $TYPE_PRIV, 6 ) )
{
echo " <input type=\"checkbox\" name=\"OUT_SMS2_REMIND";
echo $OUT_COUNT;
echo "\" id=\"OUT_SMS2_REMIND";
echo $OUT_COUNT;
echo "\" ";
if ( find_id( $SMS2_REMIND, "6" ) )
{
echo "checked";
}
echo "><label for=\"OUT_SMS2_REMIND";
echo $OUT_COUNT;
echo "\">手机提醒</label>\r\n";
}
echo " <a href=\"javascript:out_confirm('1','";
echo $USER_ID;
echo "','";
echo $SUBMIT_TIME;
echo "','";
echo $OUT_COUNT;
echo "');\">批准</a>\r\n <a href=\"javascript:out_confirm('2','";
echo $USER_ID;
echo "','";
echo $SUBMIT_TIME;
echo "','";
echo $OUT_COUNT;
echo "');\">不批准</a>\r\n </td>\r\n </tr>\r\n";
}
if ( 0 < $OUT_COUNT )
{
echo " <thead class=\"TableHeader\">\r\n <td nowrap align=\"center\">部门</td>\r\n <td nowrap align=\"center\">姓名</td>\r\n <td nowrap align=\"center\">申请时间</td>\r\n <td nowrap align=\"center\">外出原因</td>\r\n <td nowrap align=\"center\">外出时间</td>\r\n <td nowrap align=\"center\">预计归来时间</td>\r\n <td nowrap align=\"center\">操作</td>\r\n </thead>\r\n </table>\r\n";
}
else
{
message( "", "无外出审批申请" );
}
echo "\r\n<br>\r\n<table width=\"95%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"3\">\r\n <tr>\r\n <td background=\"/images/dian1.gif\" width=\"100%\"></td>\r\n </tr>\r\n</table>\r\n\r\n<!------------------------------------- 请假审批 ------------------------------->\r\n\r\n<table border=\"0\" width=\"100%\" 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\"><span class=\"big3\"> 请假审批</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<br>\r\n\r\n";
if ( $LOGIN_USER_ID == "admin" )
{
$query = "SELECT * from ATTEND_LEAVE,USER where ATTEND_LEAVE.USER_ID=USER.USER_ID and status='1' and allow in('0','3')";
}
else
{
$query = "SELECT * from ATTEND_LEAVE,USER where ATTEND_LEAVE.USER_ID=USER.USER_ID and LEADER_ID='".$LOGIN_USER_ID."' and status='1' and allow in('0','3')";
}
$cursor = exequery( $connection, $query );
$LEAVE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$LEAVE_COUNT;
$LEAVE_ID = $ROW['LEAVE_ID'];
$USER_ID = $ROW['USER_ID'];
$USER_NAME = $ROW['USER_NAME'];
$LEAVE_DATE1 = $ROW['LEAVE_DATE1'];
$LEAVE_DATE2 = $ROW['LEAVE_DATE2'];
$LEAVE_TYPE = $ROW['LEAVE_TYPE'];
$DESTROY_TIME = $ROW['DESTROY_TIME'];
if ( $DESTROY_TIME == "0000-00-00 00:00:00" )
{
$DESTROY_TIME = "";
}
$ALLOW = $ROW['ALLOW'];
$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 ( $LEAVE_COUNT == 1 )
{
echo "\r\n <table class=\"TableList\" width=\"95%\">\r\n\r\n";
}
if ( $LEAVE_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n <td nowrap align=\"center\">";
echo $USER_DEPT_NAME;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -