⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 some_day.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 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">

<?
 $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"];
 }

 //---- 取规定上下班时间 -----
 $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?>)  <?=$SOME_DATE?></span><br>
    </td>
  </tr>
</table>

<br>

<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>
<?
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('$SOME_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>
<div align="center">
  <input type="button"  value="返回" class="BigButton" onClick="history.back();">
</div>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -