📄 att_pass.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.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 "<div >\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\">\r\n <tr class=\"tablehead1\">\r\n <td ><img src=\"/images/manage/hrms.gif\" align=\"absmiddle\">考勤批示</td>\r\n </tr>\r\n <tr class=\"tablehead2\">\r\n <td> </td>\r\n </tr>\r\n</table>\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</";
echo "table>\r\n\r\n<!------------------------------------- 今日外出批示 ------------------------------->\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"3\">\r\n <tr>\r\n <td >";
echo "<s";
echo "trong>今日外出批示</strong></td>\r\n </tr>\r\n</table>\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 "<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" cellpadding=\"5\">\r\n ";
}
if ( $OUT_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n <td nowrap >";
echo $USER_DEPT_NAME;
echo "</td>\r\n <td nowrap >";
echo $USER_NAME;
echo "</td>\r\n <td nowrap ><a href=\"#\" onClick=\"javascript:window.open('../personal/out/detail.php?USER_ID=";
echo $USER_ID;
echo "','','topbar=no,width=200,height=200')\">\r\n ";
echo substrgb( $OUT_TYPE, 20, "..." );
echo " </a></td>\r\n <td nowrap >";
echo $OUT_TIME1;
echo "</td>\r\n <td nowrap >";
echo $OUT_TIME2;
echo "</td>\r\n <td nowrap ><a href=\"#\" onCLick=\"outConfirm('";
echo $USER_ID;
echo "',1,'MOBILE_SMS_REMIND";
echo $USER_ID;
echo "');\">批准</a> <a href=\"#\" onCLick=\"outConfirm('";
echo $USER_ID;
echo "',2,'MOBILE_SMS_REMIND";
echo $USER_ID;
echo "');\">不批准</a>\r\n \r\n <input type=\"checkbox\" name=\"MOBILE_SMS_REMIND";
echo $USER_ID;
echo "\" value=\"checkbox\" id=\"MOBILE_SMS_REMIND";
echo $USER_ID;
echo "\"><label for=\"";
echo $USER_ID;
echo "\" title=\"手机短信通知\"> \r\n <img src=\"/images/littlegif/icon_phone.gif\"> </label></td>\r\n </tr>\r\n ";
}
if ( 0 < $OUT_COUNT )
{
echo " <thead class=\"TableHeader\">\r\n <td nowrap >部门</td>\r\n <td nowrap >姓名</td>\r\n <td nowrap >外出原因</td>\r\n <td nowrap >外出时间</td>\r\n <td nowrap >预计归来时间</td>\r\n <td nowrap >操作</td>\r\n</table>\r\n";
}
else
{
message( "", "无未批示的申请" );
}
echo "<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=\"1\" cellpadding=\"3\">\r\n <tr >\r\n <td >";
echo "<s";
echo "trong> 请假批示</strong></td>\r\n </tr>\r\n</table>\r\n\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=\"100%\" class=\"small\" 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 >";
echo $USER_DEPT_NAME;
echo "</td>\r\n <td nowrap >";
echo $USER_NAME;
echo "</td>\r\n <td nowrap ><a href=\"#\" onClick=\"javascript:window.open('../personal/leave/leaveinfo.php?LEAVE_ID=";
echo $LEAVE_ID;
echo "','','topbar=no,width=200,height=200')\">";
echo substrgb( $LEAVE_TYPE, 20, "..." );
echo "</a></td>\r\n <td nowrap >";
echo $LEAVE_DATE1;
echo "</td>\r\n <td nowrap >";
echo $LEAVE_DATE2;
echo "</td>\r\n";
if ( $ALLOW == "0" )
{
echo " <td nowrap >请假申请</td>\r\n <td nowrap >\r\n <a href=\"#\" onClick=\"leaveConfirm('";
echo $USER_ID;
echo "',1,'MOBILE_SMS_REMIND";
echo $LEAVE_ID;
echo "',";
echo $LEAVE_ID;
echo ");\">批准</a> \r\n <a href=\"#\" onClick=\"leaveConfirm('";
echo $USER_ID;
echo "',2,'MOBILE_SMS_REMIND";
echo $LEAVE_ID;
echo "',";
echo $LEAVE_ID;
echo ");\">不批准</a> <input type=\"checkbox\" name=\"MOBILE_SMS_REMIND";
echo $LEAVE_ID;
echo "\" value=\"checkbox\" id=\"MOBILE_SMS_REMIND";
echo $LEAVE_ID;
echo "\">\r\n <label for=\"";
echo $LEAVE_ID;
echo "\" title=\"手机短信通知\"> <img src=\"/images/littlegif/icon_phone.gif\"> </label>\r\n";
}
else
{
echo " \r\n <td nowrap >销假申请</td>\r\n <td nowrap >\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 >部门</td>\r\n <td nowrap >姓名</td>\r\n <td nowrap >请假原因</td>\r\n <td nowrap >开始日期</td>\r\n <td nowrap >结束日期</td>\r\n <td nowrap >申请类型</td>\r\n <td nowrap >操作</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<div></div>\r\n\r\n</body>\r\n</html>\r\n";
echo "<s";
echo "cript>\r\nfunction outConfirm(userId,n,formId){\r\n msrv = '';\r\n msr = document.getElementById(formId);\r\n\tif (msr.checked){\r\n\t msrv = 1;\r\n\t}\r\n url = \"out/confirm.php?CONFIRM=\"+n+\"&USER_ID=\"+userId+\"&MOBILE_SMS_REMIND=\"+msrv;\r\n window.location=url;\r\n}\r\n\r\nfunction leaveConfirm(userId,n,formId,leaveId){\r\n msrv = '';\r\n msr = document.getElementById(formId);\r\n\tif (msr.checked){\r\n\t m";
echo "srv = 1;\r\n\t}\r\n url = \"leave/confirm.php?CONFIRM=\"+n+\"&USER_ID=\"+userId+\"&LEAVE_ID=\"+leaveId+\"&MOBILE_SMS_REMIND=\"+msrv;\r\n window.location=url;\r\n}\r\n\r\n</script>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -