📄 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";
echo "<s";
echo "cript Language=JavaScript>\r\nwindow.setTimeout('this.location.reload();',60000);\r\n</script>\r\n";
echo "<s";
echo "cript>\r\nfunction CheckForm1()\r\n{\r\n if(document.form1.DATE1.value==\"\")\r\n { alert(\"起始日期不能为空！\");\r\n return (false);\r\n }\r\n\r\n if(document.form1.DATE2.value==\"\")\r\n { alert(\"截止日期不能为空！\");\r\n return (false);\r\n }\r\n\r\n return (true);\r\n}\r\n\r\nfunction CheckForm2()\r\n{\r\n if(document.form2.SOME_DATE.value==\"\")\r\n { alert(\"查询日期不能为空！\");\r\n return (false);\r\n }\r\n\r\n";
echo " return (true);\r\n}\r\n\r\nfunction td_calendar(fieldname)\r\n{\r\n myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;\r\n mytop=document.body.scrollTop+event.clientY-event.offsetY+140;\r\n window.showModalDialog(\"/inc/calendar.php?FIELDNAME=\"+fieldname,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:205px;dialogTop:\"+mytop+\"px;dialogLeft:\"+myleft+\"px\");\r";
echo "\n}\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$connection = openconnection( );
$CUR_DATE = date( "Y-m-d", time( ) );
echo "\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\">";
echo "<s";
echo "pan class=\"big3\"> 今日考勤</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n<div align=\"center\">\r\n<input type=\"button\" value=\"今日考勤情况\" class=\"BigButton\" onClick=\"location='today';\" title=\"查看今日的考勤情况\">\r\n</div>\r\n\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<!-----------------------------";
echo "-------- 今日外出批示 ------------------------------->\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\">";
echo "<s";
echo "pan class=\"big3\"> 今日外出批示</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n";
if ( $LOGIN_USER_ID == "admin" )
{
$query = "SELECT * from ATTEND_OUT,USER where ATTEND_OUT.USER_ID=USER.USER_ID and to_days(SUBMIT_TIME)=to_days('{$CUR_DATE}') 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 to_days(SUBMIT_TIME)=to_days('{$CUR_DATE}') 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'];
$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 "\r\n <table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n\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 $OUT_TYPE;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $OUT_TIME1;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $OUT_TIME2;
echo "</td>\r\n <td nowrap align=\"center\">\r\n <a href=\"out/confirm.php?CONFIRM=1&USER_ID=";
echo $USER_ID;
echo "\">批准</a> \r\n <a href=\"out/confirm.php?CONFIRM=2&USER_ID=";
echo $USER_ID;
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 </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\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\" ";
echo "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\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') order by USER.USER_ID";
}
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') order by USER.USER_ID";
}
$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'];
$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 border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\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;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $USER_NAME;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $LEAVE_TYPE;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $LEAVE_DATE1;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $LEAVE_DATE2;
echo "</td>\r\n";
if ( $ALLOW == "0" )
{
echo " <td nowrap align=\"center\">请假申请</td>\r\n <td nowrap align=\"center\">\r\n <a href=\"leave/confirm.php?CONFIRM=1&LEAVE_ID=";
echo $LEAVE_ID;
echo "&USER_ID=";
echo $USER_ID;
echo "\">批准</a> \r\n <a href=\"leave/confirm.php?CONFIRM=2&LEAVE_ID=";
echo $LEAVE_ID;
echo "&USER_ID=";
echo $USER_ID;
echo "\">不批准</a> \r\n";
}
else
{
echo " <td nowrap align=\"center\">销假申请</td>\r\n <td nowrap align=\"center\">\r\n <a href=\"leave/confirm.php?STATUS=2&LEAVE_ID=";
echo $LEAVE_ID;
echo "&USER_ID=";
echo $USER_ID;
echo "\">销假</a>\r\n </td>\r\n";
}
echo " </td>\r\n </tr>\r\n";
}
if ( 0 < $LEAVE_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<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\">";
echo "<s";
echo "pan class=\"big3\"> 考勤记录查询与管理</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n<div align=\"center\" class=\"big1\">\r\n<form action=\"search.php\" name=\"form1\" onsubmit=\"return CheckForm1();\">\r\n<b>\r\n起始日期：<input type=\"text\" name=\"DATE1\" class=\"BigInput\" size=\"10\" maxlength=\"10\" value=\"";
echo $CUR_DATE;
echo "\">\r\n <img src=\"/images/menu/calendar.gif\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.DATE1');\">\r\n \r\n截止日期：<input type=\"text\" name=\"DATE2\" class=\"BigInput\" size=\"10\" maxlength=\"10\" value=\"";
echo $CUR_DATE;
echo "\">\r\n <img src=\"/images/menu/calendar.gif\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.DATE2');\">\r\n \r\n<input type=\"submit\" value=\"考勤统计\" class=\"BigButton\" title=\"考勤记录统计\">\r\n</form>\r\n\r\n<br>\r\n<form action=\"some_day\" name=\"form2\" onsubmit=\"return CheckForm2();\">\r\n查询日期：<input type=\"text\" name=\"SOME_DATE\" class=\"BigInput\" size=\"10\" maxlength=\"10\" value=\"";
echo $CUR_DATE;
echo "\">\r\n <img src=\"/images/menu/calendar.gif\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form2.SOME_DATE');\">\r\n \r\n<input type=\"submit\" value=\"考勤明细\" class=\"BigButton\" title=\"考勤记录明细查询\">\r\n</b>\r\n</form>\r\n\r\n</div>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -