📄 user.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">
<script>
function CheckForm1()
{
if(document.form1.DATE1.value=="")
{ alert("起始日期不能为空！");
return (false);
}
if(document.form1.DATE2.value=="")
{ alert("截止日期不能为空！");
return (false);
}
return (true);
}
function CheckForm2()
{
if(document.form2.SOME_DATE.value=="")
{ alert("查询日期不能为空！");
return (false);
}
return (true);
}
function td_calendar(fieldname)
{
myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<?
$SOME_DATE=date("Y-m-d",time());
$query1="select * from USER where USER_ID='$USER_ID'";
$cursor1= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor1))
{
$DUTY_TYPE=$ROW["DUTY_TYPE"];
$USER_NAME=$ROW["USER_NAME"];
}
Message("","$USER_NAME");
//---- 取规定上下班时间 -----
$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"];
}
$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>";
}
if($HOLIDAY=="")
{
$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>";
}
?>
<!---- 上下班登记 ---->
<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"> 今日上下班登记 (<?=$DUTY_NAME?>)</span><br>
</td>
</tr>
</table>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="2" align="center">
<tr class="TableHeader">
<td nowrap align="center">登记次序</td>
<td nowrap align="center">登记类型</td>
<td nowrap align="center">规定时间</td>
<td nowrap align="center">登记时间</td>
<td nowrap align="center">登记IP</td>
</tr>
<?
//---- 查看今日上下班情况 -----
$CUR_DATE=date("Y-m-d",time());
//---- 第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="";
$REGISTER_IP="";
$REMARK11="";
$query = "SELECT * from ATTEND_DUTY where USER_ID='$USER_ID' and to_days(REGISTER_TIME)=to_days('$CUR_DATE') and REGISTER_TYPE='$I'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$REGISTER_TIME=$ROW["REGISTER_TIME"];
$REGISTER_IP=$ROW["REGISTER_IP"];
$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;}
}
if($DUTY_TYPE_I=="1")
$DUTY_TYPE_DESC="上班登记";
else
$DUTY_TYPE_DESC="下班登记";
?>
<tr class="TableData">
<td nowrap align="center">第<?=$I?>次登记</td>
<td nowrap align="center"><?=$DUTY_TYPE_DESC?></td>
<td nowrap align="center"><?=$DUTY_TIME_I?></td>
<td nowrap align="center">
<?
if($REGISTER_TIME=="")
{
if($HOLIDAY1=="")
echo "未登记";
else
echo $HOLIDAY1;
}
else
echo $REGISTER_TIME.$REMARK11;
?>
</td>
<td nowrap align="center"><?=$REGISTER_IP?></td>
</tr>
<?
}
?>
</table>
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
<tr>
<td background="/images/dian1.gif" width="100%"></td>
</tr>
</table>
<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"> 考勤查询与统计</span><br>
</td>
</tr>
</table>
<?
$CUR_DATE_FIRST=date("Y-m-01",time());
?>
<div align="center" class="big1">
<form action="search.php" name="form1" onsubmit="return CheckForm1();">
<b>
起始日期：<input type="text" name="DATE1" class="BigInput" size="10" maxlength="10" value="<?=$CUR_DATE_FIRST?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.DATE1');">
截止日期：<input type="text" name="DATE2" class="BigInput" size="10" maxlength="10" value="<?=$CUR_DATE?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.DATE2');">
<input type="hidden" name="USER_ID" value="<?=$USER_ID?>">
<input type="submit" value="考勤统计" class="BigButton" title="考勤统计">
</form>
<br>
<form action="some_day.php" name="form2" onsubmit="return CheckForm2();">
查询日期：<input type="text" name="SOME_DATE" class="BigInput" size="10" maxlength="10" value="<?=$CUR_DATE?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form2.SOME_DATE');">
<input type="hidden" name="USER_ID" value="<?=$USER_ID?>">
<input type="submit" value="上下班登记查询" class="BigButton" title="上下班登记查询">
</b>
</form>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -