📄 duty.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>上下班登记</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</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="absmiddle"><span class="big3"> 上下班查询结果 - <?=format_date($SOME_DATE)?></span><br>
</td>
</tr>
</table>
<br>
<?
//---- 取规定上下班时间 -----
$query = "SELECT * from ATTEND_CONFIG where DUTY_TYPE=$DUTY_TYPE";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$DUTY_NAME=$ROW["DUTY_NAME"];
$GENERAL=$ROW["GENERAL"];
$DUTY_TIME1=$ROW["DUTY_TIME1"];
$DUTY_TIME2=$ROW["DUTY_TIME2"];
$DUTY_TIME3=$ROW["DUTY_TIME3"];
$DUTY_TIME4=$ROW["DUTY_TIME4"];
$DUTY_TIME5=$ROW["DUTY_TIME5"];
$DUTY_TIME6=$ROW["DUTY_TIME6"];
$DUTY_TYPE1=$ROW["DUTY_TYPE1"];
$DUTY_TYPE2=$ROW["DUTY_TYPE2"];
$DUTY_TYPE3=$ROW["DUTY_TYPE3"];
$DUTY_TYPE4=$ROW["DUTY_TYPE4"];
$DUTY_TYPE5=$ROW["DUTY_TYPE5"];
$DUTY_TYPE6=$ROW["DUTY_TYPE6"];
}
$query = "SELECT * from SYS_PARA where PARA_NAME='NO_DUTY_USER'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$NO_DUTY_USER=$ROW["PARA_VALUE"];
//---- 逐一查询用户 -----
if($DEPARTMENT!="ALL_DEPT")
$query = "SELECT * from USER,USER_PRIV where USER.NOT_LOGIN='0' and not find_in_set(USER.USER_ID,'$NO_DUTY_USER') and DEPT_ID=$DEPARTMENT and DUTY_TYPE=$DUTY_TYPE and USER.USER_PRIV=USER_PRIV.USER_PRIV order by PRIV_NO,USER_NO,USER_NAME";
else
$query = "SELECT * from USER,USER_PRIV,DEPARTMENT where USER.NOT_LOGIN='0' and not find_in_set(USER.USER_ID,'$NO_DUTY_USER') and DEPARTMENT.DEPT_ID=USER.DEPT_ID and DUTY_TYPE=$DUTY_TYPE and USER.USER_PRIV=USER_PRIV.USER_PRIV order by DEPT_NO,PRIV_NO,USER_NO,USER_NAME";
$USER_COUNT=0;
$cursor_1= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor_1))
{
$USER_COUNT++;
$USER_ID=$ROW["USER_ID"];
$USER_NAME=$ROW["USER_NAME"];
$DEPT_ID=$ROW["DEPT_ID"];
if($USER_COUNT==1)
{
?>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3" align="center">
<tr class="TableHeader">
<td nowrap align="center">部门</td>
<td nowrap align="center">姓名</td>
<?
for($I=1;$I<=6;$I++)
{
$DUTY_TIME_I="DUTY_TIME".$I;
$DUTY_TIME_I=$$DUTY_TIME_I;
$DUTY_TYPE_I="DUTY_TYPE".$I;
$DUTY_TYPE_I=$$DUTY_TYPE_I;
if($DUTY_TIME_I=="")
continue;
if($DUTY_TYPE_I=="1")
$DUTY_TYPE_DESC="上班";
else
$DUTY_TYPE_DESC="下班";
?>
<td nowrap align="center"><?=$DUTY_TYPE_DESC?> (<?=$DUTY_TIME_I?>)</td>
<?
}
?>
</tr>
<?
}
$WEEK=date("w",strtotime($SOME_DATE));
$HOLIDAY="";
$query="select * from ATTEND_HOLIDAY where BEGIN_DATE <='$SOME_DATE' and END_DATE>='$SOME_DATE'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$HOLIDAY="<font color='#008000'>节假日</font>";
else
{
if(find_id($GENERAL,$WEEK))
$HOLIDAY="<font color='#008000'>公休日</font>";
}
$query="select * from ATTEND_EVECTION where USER_ID='$USER_ID' and ALLOW='1' and to_days(EVECTION_DATE1)<=to_days('$SOME_DATE') and to_days(EVECTION_DATE2)>=to_days('$SOME_DATE')";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$HOLIDAY="<font color='#008000'>出差</font>";
$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($USER_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><?=$USER_DEPT_NAME?></td>
<td nowrap align="center"><?=$USER_NAME?></td>
<?
//---- 第1组 -----
for($I=1;$I<=6;$I++)
{
$DUTY_TIME_I="DUTY_TIME".$I;
$DUTY_TIME_I=$$DUTY_TIME_I;
$DUTY_TYPE_I="DUTY_TYPE".$I;
$DUTY_TYPE_I=$$DUTY_TYPE_I;
if($DUTY_TIME_I=="" || $DUTY_TIME_I=="00:00:00")
continue;
$HOLIDAY1="";
if($HOLIDAY=="")
{
$query="select * from ATTEND_LEAVE where USER_ID='$USER_ID' and ALLOW='1' and LEAVE_DATE1<='$SOME_DATE $DUTY_TIME_I' and LEAVE_DATE2>='$SOME_DATE $DUTY_TIME_I'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$HOLIDAY1="<font color='#008000'>请假</font>";
}
else
$HOLIDAY1=$HOLIDAY;
if($HOLIDAY==""&&$HOLIDAY1=="")
{
$query="select * from ATTEND_OUT where USER_ID='$USER_ID' and ALLOW='1' and to_days(SUBMIT_TIME)=to_days('$SOME_DATE') and OUT_TIME1<='".substr($DUTY_TIME_I,0,strrpos($DUTY_TIME_I,":"))."' and OUT_TIME2>='".substr($DUTY_TIME_I,0,strrpos($DUTY_TIME_I,":"))."'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$HOLIDAY1="<font color='#008000'>外出</font>";
}
$REGISTER_TIME="";
$REMARK11="";
$query = "SELECT * from ATTEND_DUTY where USER_ID='$USER_ID' and to_days(REGISTER_TIME)=to_days('$SOME_DATE') and REGISTER_TYPE='$I'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$REGISTER_TIME=$ROW["REGISTER_TIME"];
$REMAK=$ROW["REMARK"];
$REGISTER_TIME=strtok($REGISTER_TIME," ");
$REGISTER_TIME=strtok(" ");
if($HOLIDAY1=="" && $DUTY_TYPE_I=="1" && compare_time($REGISTER_TIME,$DUTY_TIME_I)==1)
{$REGISTER_TIME.=" 迟到";$REMARK11="<br>"."备注：".$REMAK;}
if($HOLIDAY1=="" && $DUTY_TYPE_I=="2" && compare_time($REGISTER_TIME,$DUTY_TIME_I)==-1)
{$REGISTER_TIME.=" 早退";$REMARK11="<br>"."备注：".$REMAK;}
}
else
{
if($HOLIDAY1=="")
$REGISTER_TIME="未登记";
else
$REGISTER_TIME=$HOLIDAY1;
}
?>
<td nowrap align="center"><?=$REGISTER_TIME?><?=$REMARK11?></td>
<?
}
?>
</tr>
<?
}
if($USER_COUNT>0)
{
?>
</table>
<?
}
else
Message("","无符合条件的记录");
Button_Back();
?>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -