📄 user.php
字号:
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>人员考勤管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="JavaScript">
function remark(REGISTER_TYPE,REGISTER_TIME)
{
URL="remark.php?REGISTER_TYPE="+REGISTER_TYPE+"®ISTER_TIME="+REGISTER_TIME;
myleft=(screen.availWidth-650)/2;
window.open(URL,"formul_edit","height=250,width=450,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
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>';
}
}
echo '
<!---- 上下班登记 ---->
<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"> 今日上下班登记 (';
echo $DUTY_NAME;
echo ')</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>
<td nowrap align="center">操作</td>
</tr>
';
$CUR_DATE = date ('Y-m-d', time ());
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;
$SIGN = '0';
if (!($DUTY_TIME_I == ''))
{
if (!($DUTY_TIME_I == '00:00:00'))
{
$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 == '')
{
if ($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 = '';
$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_TIME22 = $ROW['REGISTER_TIME'];
$REGISTER_IP = $ROW['REGISTER_IP'];
$REGISTER_TIME = strtok ($REGISTER_TIME, ' ');
$REGISTER_TIME = strtok (' ');
if ($HOLIDAY1 == '')
{
if ($DUTY_TYPE_I == '1')
{
if (compare_time ($REGISTER_TIME, $DUTY_TIME_I) == 1)
{
$REGISTER_TIME .= ' 迟到';
$SIGN = '1';
}
}
}
if ($HOLIDAY1 == '')
{
if ($DUTY_TYPE_I == '2')
{
if (compare_time ($REGISTER_TIME, $DUTY_TIME_I) == -1)
{
$REGISTER_TIME .= ' 早退';
$SIGN = '1';
}
}
}
}
if ($DUTY_TYPE_I == '1')
{
$DUTY_TYPE_DESC = '上班登记';
}
else
{
$DUTY_TYPE_DESC = '下班登记';
}
echo ' <tr class="TableData">
<td nowrap align="center">第';
echo $I;
echo '次登记</td>
<td nowrap align="center">';
echo $DUTY_TYPE_DESC;
echo '</td>
<td nowrap align="center">';
echo $DUTY_TIME_I;
echo '</td>
<td nowrap align="center">
';
if ($REGISTER_TIME == '')
{
if ($HOLIDAY1 == '')
{
echo '未登记';
}
else
{
echo $HOLIDAY1;
}
}
else
{
echo $REGISTER_TIME;
}
echo ' </td>
<td nowrap align="center">';
echo $REGISTER_IP;
echo '</td>
<td nowrap align="center">
';
if ($REGISTER_TIME == '')
{
echo ' <a href="duty_submit.php?REGISTER_TYPE=';
echo $I;
echo '&USER_ID=';
echo $USER_ID;
echo '">';
echo $DUTY_TYPE_DESC;
echo '</a>
';
}
else
{
if ($SIGN == '1')
{
echo ' <a href="javascript:remark(\'';
echo $I;
echo '\',\'';
echo $REGISTER_TIME22;
echo '\');">备注</a>
';
}
else
{
echo '无';
}
}
echo ' </td>
</tr>
';
continue;
}
continue;
}
}
echo ' <tr class="TableHeader">
<td colspan="6" align="center">
<input type="button" value="修改登记时间" class="SmallButton" onClick="location=\'duty_edit.php?DUTY_TYPE=';
echo $DUTY_TYPE;
echo '&USER_ID=';
echo $USER_ID;
echo '&SOME_DATE=';
echo $SOME_DATE;
echo '\'">
</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 ());
echo '
<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="';
echo $CUR_DATE_FIRST;
echo '">
<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="';
echo $CUR_DATE;
echo '">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.DATE2\');">
<input type="hidden" name="USER_ID" value="';
echo $USER_ID;
echo '">
<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="';
echo $CUR_DATE;
echo '">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form2.SOME_DATE\');">
<input type="hidden" name="USER_ID" value="';
echo $USER_ID;
echo '">
<input type="submit" value="上下班登记查询" class="BigButton" title="上下班登记查询">
</b>
</form>
</div>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -