📄 index.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<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");
}
</script>
<html>
<head>
<title>上下班登记</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?
//---- IP检验开始 ---
$USER_IP=get_client_ip();
if(!check_ip($USER_IP,"1",$LOGIN_USER_ID))
{
Message("警告","您无权限从该IP(".$USER_IP.")考勤!");
exit;
}
//---- IP检验结束 ---
$query1="select * from USER where USER_ID='$LOGIN_USER_ID'";
$cursor1= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor1))
$DUTY_TYPE=$ROW["DUTY_TYPE"];
//---- 取规定上下班时间 -----
$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"];
}
?>
<!---- 上下班登记 ---->
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small" align="center">
<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>
<?
$query = "SELECT * from SYS_PARA where PARA_NAME='DUTY_INTERVAL_BEFORE1'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$DUTY_INTERVAL_BEFORE1=$ROW["PARA_VALUE"];
$query = "SELECT * from SYS_PARA where PARA_NAME='DUTY_INTERVAL_AFTER1'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$DUTY_INTERVAL_AFTER1=$ROW["PARA_VALUE"];
$query = "SELECT * from SYS_PARA where PARA_NAME='DUTY_INTERVAL_BEFORE2'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$DUTY_INTERVAL_BEFORE2=$ROW["PARA_VALUE"];
$query = "SELECT * from SYS_PARA where PARA_NAME='DUTY_INTERVAL_AFTER2'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$DUTY_INTERVAL_AFTER2=$ROW["PARA_VALUE"];
Message("","规定时间之前 $DUTY_INTERVAL_BEFORE1 分钟，之后 $DUTY_INTERVAL_AFTER1 分钟起可进行上班登记，规定时间之前 $DUTY_INTERVAL_BEFORE2 分钟，之后 $DUTY_INTERVAL_AFTER2 分钟起可进行下班登记");
$SOME_DATE=date("Y-m-d");
$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>";
}
?>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="2">
<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">操作</td>
</tr>
<?
//---- 查看今日上下班情况 -----
$CUR_DATE=date("Y-m-d",time());
$CUR_TIME=date("Y-m-d H:i:s",time());
//---- 第1组 -----
if($DUTY_TIME1!="")
{
$SIGN="0";
$query = "SELECT * from ATTEND_DUTY where USER_ID='$LOGIN_USER_ID' and to_days(REGISTER_TIME)=to_days('$CUR_DATE') and REGISTER_TYPE='1'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$REGISTER_TIME1=$ROW["REGISTER_TIME"];
$REGISTER_TIME11=$ROW["REGISTER_TIME"];
$REGISTER_TIME1=strtok($REGISTER_TIME1," ");
$REGISTER_TIME1=strtok(" ");
if($HOLIDAY==""&&$DUTY_TYPE1=="1" && compare_time($REGISTER_TIME1,$DUTY_TIME1)==1)
{$REGISTER_TIME1.=" 迟到";$SIGN="1";}
if($HOLIDAY==""&&$DUTY_TYPE1=="2" && compare_time($REGISTER_TIME1,$DUTY_TIME1)==1)
{$REGISTER_TIME1.=" 早退";$SIGN="1";}
}
$DUTY_INTERVAL_BEFORE="DUTY_INTERVAL_BEFORE".$DUTY_TYPE1;
$DUTY_INTERVAL_AFTER="DUTY_INTERVAL_AFTER".$DUTY_TYPE1;
if($DUTY_TYPE1=="1")
$DUTY_TYPENAME1="上班登记";
else
$DUTY_TYPENAME1="下班登记";
?>
<tr class="TableData">
<td nowrap align="center">第1次登记</td>
<td nowrap align="center"><?=$DUTY_TYPENAME1?></td>
<td nowrap align="center"><?=$DUTY_TIME1?></td>
<?
if($REGISTER_TIME1=="")
{
?>
<td nowrap align="center">未登记</td>
<td nowrap align="center">
<?
$REGISTER_TIME=$CUR_DATE." ".$DUTY_TIME1;
if(strtotime($REGISTER_TIME)-strtotime($CUR_TIME)<=$$DUTY_INTERVAL_BEFORE*60&&strtotime($CUR_TIME)-strtotime($REGISTER_TIME)<=$$DUTY_INTERVAL_AFTER*60)
{
?>
<a href="submit.php?REGISTER_TYPE=1"><?=$DUTY_TYPENAME1?></a>
<?
}
else
{
echo "无";
}
?>
</td>
</tr>
<?
}
else
{
?>
<td nowrap align="center"><?=$REGISTER_TIME1?></td>
<td nowrap align="center">
<?
if($SIGN=="1")
{
?>
<a href="javascript:remark('1','<?=$REGISTER_TIME11?>');">备注</a>
<?
}
else
{
?>
无
<?
}
?>
</td>
</tr>
<?
}
}
//---- 第2组 -----
if($DUTY_TIME2!="")
{
$SIGN="0";
$query = "SELECT * from ATTEND_DUTY where USER_ID='$LOGIN_USER_ID' and to_days(REGISTER_TIME)=to_days('$CUR_DATE') and REGISTER_TYPE='2'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$REGISTER_TIME2=$ROW["REGISTER_TIME"];
$REGISTER_TIME22=$ROW["REGISTER_TIME"];
$REGISTER_TIME2=strtok($REGISTER_TIME2," ");
$REGISTER_TIME2=strtok(" ");
if($DUTY_TYPE2=="1" && compare_time($REGISTER_TIME2,$DUTY_TIME2)==1)
{$REGISTER_TIME2.=" 迟到";$SIGN="1";}
if($DUTY_TYPE2=="2" && compare_time($REGISTER_TIME2,$DUTY_TIME2)==-1)
{$REGISTER_TIME2.=" 早退";$SIGN="1";}
}
$DUTY_INTERVAL_BEFORE="DUTY_INTERVAL_BEFORE".$DUTY_TYPE2;
$DUTY_INTERVAL_AFTER="DUTY_INTERVAL_AFTER".$DUTY_TYPE2;
if($DUTY_TYPE2=="1")
$DUTY_TYPENAME2="上班登记";
else
$DUTY_TYPENAME2="下班登记";
?>
<tr class="TableData">
<td nowrap align="center">第2次登记</td>
<td nowrap align="center"><?=$DUTY_TYPENAME2?></td>
<td nowrap align="center"><?=$DUTY_TIME2?></td>
<?
if($REGISTER_TIME2=="")
{
?>
<td nowrap align="center">未登记</td>
<td nowrap align="center">
<?
$REGISTER_TIME=$CUR_DATE." ".$DUTY_TIME2;
if(strtotime($REGISTER_TIME)-strtotime($CUR_TIME)<=$$DUTY_INTERVAL_BEFORE*60&&strtotime($CUR_TIME)-strtotime($REGISTER_TIME)<=$$DUTY_INTERVAL_AFTER*60)
{
?>
<a href="submit.php?REGISTER_TYPE=2"><?=$DUTY_TYPENAME2?></a>
<?
}
else
{
echo "无";
}
?>
</td>
</tr>
<?
}
else
{
?>
<td nowrap align="center"><?=$REGISTER_TIME2?></td>
<td nowrap align="center">
<?
if($SIGN=="1")
{
?>
<a href="javascript:remark('2','<?=$REGISTER_TIME22?>');">备注</a>
<?
}
else
{
?>
无
<?
}
?>
</td>
</tr>
<?
}
}
//---- 第3组 -----
if($DUTY_TIME3!="")
{
$SIGN="0";
$query = "SELECT * from ATTEND_DUTY where USER_ID='$LOGIN_USER_ID' and to_days(REGISTER_TIME)=to_days('$CUR_DATE') and REGISTER_TYPE='3'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$REGISTER_TIME3=$ROW["REGISTER_TIME"];
$REGISTER_TIME33=$ROW["REGISTER_TIME"];
$REGISTER_TIME3=strtok($REGISTER_TIME3," ");
$REGISTER_TIME3=strtok(" ");
if($DUTY_TYPE3=="1" && compare_time($REGISTER_TIME3,$DUTY_TIME3)==1)
{$REGISTER_TIME3.=" 迟到";$SIGN="1";}
if($DUTY_TYPE3=="2" && compare_time($REGISTER_TIME3,$DUTY_TIME3)==-1)
{$REGISTER_TIME3.=" 早退";$SIGN="1";}
}
$DUTY_INTERVAL_BEFORE="DUTY_INTERVAL_BEFORE".$DUTY_TYPE3;
$DUTY_INTERVAL_AFTER="DUTY_INTERVAL_AFTER".$DUTY_TYPE3;
if($DUTY_TYPE3=="1")
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -