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

📄 search.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
🔍 
<?
include_once("inc/auth.php");
include_once("inc/check_type.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">

<?
  //----------- 合法性校验 ---------
  if($DATE1!="")
  {
    $TIME_OK=is_date($DATE1);

    if(!$TIME_OK)
    { Message("错误","起始日期格式不对，应形如 1999-1-2");
      Button_Back();
      exit;
    }
  }

  if($DATE2!="")
  {
    $TIME_OK=is_date($DATE2);

    if(!$TIME_OK)
    { Message("错误","截止日期格式不对，应形如 1999-1-2");
      Button_Back();
      exit;
    }
  }

  if(compare_date($DATE1,$DATE2)==1)
  { Message("错误","查询的起始日期不能晚于截止日期");
    Button_Back();
    exit;
  }

 $query = "SELECT to_days('$DATE2')-to_days('$DATE1') from ATTEND_CONFIG";
 $cursor= exequery($connection,$query);
 if($ROW=mysql_fetch_array($cursor))
    $DAY_TOTAL=$ROW[0]+1;
?>

<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($DATE1)?> 至 <?=format_date($DATE2)?> 共<?=$DAY_TOTAL?>天]</span><br>
    </td>
  </tr>
</table>

<br>

<?
 $connection=OpenConnection();

 $query = "SELECT * from USER where USER_ID='$LOGIN_USER_ID'";
 $cursor= exequery($connection,$query);
 if($ROW=mysql_fetch_array($cursor))
    $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" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3" align="center">
  <tr class="TableHeader">
    <td nowrap align="center">日期</td>
<?
 if($DUTY_TIME1!="")
 {
    if($DUTY_TYPE1=="1")
       $DUTY_TYPE_DESC="上班";
    else
       $DUTY_TYPE_DESC="下班";
?>
    <td nowrap align="center"><?=$DUTY_TYPE_DESC?> (<?=$DUTY_TIME1?>)</td>
<?
 }
 if($DUTY_TIME2!="")
 {
    if($DUTY_TYPE2=="1")
       $DUTY_TYPE_DESC="上班";
    else
       $DUTY_TYPE_DESC="下班";
?>
    <td nowrap align="center"><?=$DUTY_TYPE_DESC?> (<?=$DUTY_TIME2?>)</td>
<?
 }
 if($DUTY_TIME3!="")
 {
    if($DUTY_TYPE3=="1")
       $DUTY_TYPE_DESC="上班";
    else
       $DUTY_TYPE_DESC="下班";
?>
    <td nowrap align="center"><?=$DUTY_TYPE_DESC?> (<?=$DUTY_TIME3?>)</td>
<?
 }
 if($DUTY_TIME4!="")
 {
    if($DUTY_TYPE4=="1")
       $DUTY_TYPE_DESC="上班";
    else
       $DUTY_TYPE_DESC="下班";
?>
    <td nowrap align="center"><?=$DUTY_TYPE_DESC?> (<?=$DUTY_TIME4?>)</td>
<?
 }
 if($DUTY_TIME5!="")
 {
    if($DUTY_TYPE5=="1")
       $DUTY_TYPE_DESC="上班";
    else
       $DUTY_TYPE_DESC="下班";
?>
    <td nowrap align="center"><?=$DUTY_TYPE_DESC?> (<?=$DUTY_TIME5?>)</td>
<?
 }
 if($DUTY_TIME6!="")
 {
    if($DUTY_TYPE6=="1")
       $DUTY_TYPE_DESC="上班";
    else
       $DUTY_TYPE_DESC="下班";
?>
    <td nowrap align="center"><?=$DUTY_TYPE_DESC?> (<?=$DUTY_TIME6?>)</td>
<?
 }
?>
  </tr>

<?
$query1 = "SELECT * from ATTEND_DUTY where USER_ID='$LOGIN_USER_ID' and to_days(REGISTER_TIME)>=to_days('$DATE1') and to_days(REGISTER_TIME)<=to_days('$DATE2') GROUP by to_days(REGISTER_TIME)";
$cursor1= exequery($connection,$query1);

$LINE_COUNT=0;
while($ROW=mysql_fetch_array($cursor1))
{
  $LINE_COUNT++;
  $REGISTER_TIME=$ROW["REGISTER_TIME"];
  $SOME_DATE=strtok($REGISTER_TIME," ");
  $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=="")
     $TableLine="TableData";
  else
     $TableLine="TableContent";
?>
    <tr class="<?=$TableLine?>">      <td nowrap align="center"><?=$SOME_DATE?> （周<?=get_week($SOME_DATE)?>）</td>

<?
 //---- 第1组 -----
 if($DUTY_TIME1!="")
 {  
 	  $REMARK11="";
    $query = "SELECT * from ATTEND_DUTY where USER_ID='$LOGIN_USER_ID' and to_days(REGISTER_TIME)=to_days('$SOME_DATE') and REGISTER_TYPE='1'";
    $cursor= exequery($connection,$query);
    if($ROW=mysql_fetch_array($cursor))
    { 
    	 
       $REGISTER_TIME1=$ROW["REGISTER_TIME"];
       $REMAK1=$ROW["REMARK"];
       $REGISTER_TIME1=strtok($REGISTER_TIME1," ");
       $REGISTER_TIME1=strtok(" ");

       if($HOLIDAY==""&&$DUTY_TYPE1=="1" && compare_time($REGISTER_TIME1,$DUTY_TIME1)==1)
          {$REGISTER_TIME1.=" 迟到";$REMARK11="备注：".$REMAK1;}

       if($HOLIDAY==""&&$DUTY_TYPE1=="2" && compare_time($REGISTER_TIME1,$DUTY_TIME1)==1)
          {$REGISTER_TIME1.=" 早退";$REMARK11="备注：".$REMAK1;}
    }
    else
    {
       if($HOLIDAY=="")
          $REGISTER_TIME1="未登记";
       else
          $REGISTER_TIME1=$HOLIDAY;
       
    }

?>
      <td nowrap align="center"><?=$REGISTER_TIME1?><br><?=$REMARK11?></td>
<?
 }

 //---- 第2组 -----
 if($DUTY_TIME2!="")
 {  
 	  $REMARK22="";
    $query = "SELECT * from ATTEND_DUTY where USER_ID='$LOGIN_USER_ID' and to_days(REGISTER_TIME)=to_days('$SOME_DATE') and REGISTER_TYPE='2'";
    $cursor= exequery($connection,$query);
    if($ROW=mysql_fetch_array($cursor))
    {  
    	 
       $REGISTER_TIME2=$ROW["REGISTER_TIME"];
       $REMAK2=$ROW["REMARK"];
       $REGISTER_TIME2=strtok($REGISTER_TIME2," ");
       $REGISTER_TIME2=strtok(" ");

       if($HOLIDAY==""&&$DUTY_TYPE2=="1" && compare_time($REGISTER_TIME2,$DUTY_TIME2)==1)
          {$REGISTER_TIME2.=" 迟到";$REMARK22="备注：".$REMAK2;}

       if($HOLIDAY==""&&$DUTY_TYPE2=="2" && compare_time($REGISTER_TIME2,$DUTY_TIME2)==-1)
          {$REGISTER_TIME2.=" 早退";$REMARK22="备注：".$REMAK2;}
    }
    else
    {
       if($HOLIDAY=="")
          $REGISTER_TIME2="未登记";
       else
          $REGISTER_TIME2=$HOLIDAY;
       
    }

?>
      <td nowrap align="center"><?=$REGISTER_TIME2?><br><?=$REMARK22?></td>
<?
 }

 //---- 第3组 -----
 if($DUTY_TIME3!="")
 {
 	  $REMARK33="";
    $query = "SELECT * from ATTEND_DUTY where USER_ID='$LOGIN_USER_ID' and to_days(REGISTER_TIME)=to_days('$SOME_DATE') and REGISTER_TYPE='3'";
    $cursor= exequery($connection,$query);
    if($ROW=mysql_fetch_array($cursor))
    {
       $REGISTER_TIME3=$ROW["REGISTER_TIME"];
       $REMAK3=$ROW["REMARK"];
       $REGISTER_TIME3=strtok($REGISTER_TIME3," ");
       $REGISTER_TIME3=strtok(" ");

       if($HOLIDAY==""&&$DUTY_TYPE3=="1" && compare_time($REGISTER_TIME3,$DUTY_TIME3)==1)
          {$REGISTER_TIME3.=" 迟到";$REMARK33="备注：".$REMAK3;}

       if($HOLIDAY==""&&$DUTY_TYPE3=="2" && compare_time($REGISTER_TIME3,$DUTY_TIME3)==-1)
          {$REGISTER_TIME3.=" 早退";$REMARK33="备注：".$REMAK3;}
    }
    else
    {
       if($HOLIDAY=="")
          $REGISTER_TIME3="未登记";
       else
          $REGISTER_TIME3=$HOLIDAY;
       
    }

?>
      <td nowrap align="center"><?=$REGISTER_TIME3?><br><?=$REMARK33?></td>
<?
 }

 //---- 第4组 -----
 if($DUTY_TIME4!="")
 {  
 	  $REMARK44="";
    $query = "SELECT * from ATTEND_DUTY where USER_ID='$LOGIN_USER_ID' and to_days(REGISTER_TIME)=to_days('$SOME_DATE') and REGISTER_TYPE='4'";
    $cursor= exequery($connection,$query);
    if($ROW=mysql_fetch_array($cursor))
    {
       $REGISTER_TIME4=$ROW["REGISTER_TIME"];
       $REMAK4=$ROW["REMARK"];
       $REGISTER_TIME4=strtok($REGISTER_TIME4," ");
       $REGISTER_TIME4=strtok(" ");

       if($HOLIDAY==""&&$DUTY_TYPE4=="1" && compare_time($REGISTER_TIME4,$DUTY_TIME4)==1)
          {$REGISTER_TIME4.=" 迟到";$REMARK44="备注：".$REMAK4;}

       if($HOLIDAY==""&&$DUTY_TYPE4=="2" && compare_time($REGISTER_TIME4,$DUTY_TIME4)==-1)
          {$REGISTER_TIME4.=" 早退";$REMARK44="备注：".$REMAK4;}
    }
    else
    {
       if($HOLIDAY=="")
          $REGISTER_TIME4="未登记";
       else
          $REGISTER_TIME4=$HOLIDAY;
       
    }

?>
      <td nowrap align="center"><?=$REGISTER_TIME4?><br><?=$REMARK44?></td>
<?
 }

 //---- 第5组 -----
 if($DUTY_TIME5!="")
 {  
 	  $REMARK55="";
    $query = "SELECT * from ATTEND_DUTY where USER_ID='$LOGIN_USER_ID' and to_days(REGISTER_TIME)=to_days('$SOME_DATE') and REGISTER_TYPE='5'";
    $cursor= exequery($connection,$query);
    if($ROW=mysql_fetch_array($cursor))
    {
       $REGISTER_TIME5=$ROW["REGISTER_TIME"];
       $REMAK5=$ROW["REMARK"];
       $REGISTER_TIME5=strtok($REGISTER_TIME5," ");
       $REGISTER_TIME5=strtok(" ");

       if($HOLIDAY==""&&$DUTY_TYPE5=="1" && compare_time($REGISTER_TIME5,$DUTY_TIME5)==1)
          {$REGISTER_TIME5.=" 迟到";$REMARK55="备注：".$REMAK5;}

       if($HOLIDAY==""&&$DUTY_TYPE5=="2" && compare_time($REGISTER_TIME5,$DUTY_TIME5)==-1)
          {$REGISTER_TIME5.=" 早退";$REMARK55="备注：".$REMAK5;}
    }
    else
    {
       if($HOLIDAY=="")
          $REGISTER_TIME5="未登记";
       else
          $REGISTER_TIME5=$HOLIDAY;
       
    }

?>
      <td nowrap align="center"><?=$REGISTER_TIME5?><br><?=$REMARK55?></td>
<?
 }

 //---- 第6组 -----
 if($DUTY_TIME6!="")
 {  
 	  $REMARK66="";
    $query = "SELECT * from ATTEND_DUTY where USER_ID='$LOGIN_USER_ID' and to_days(REGISTER_TIME)=to_days('$SOME_DATE') and REGISTER_TYPE='6'";
    $cursor= exequery($connection,$query);
    if($ROW=mysql_fetch_array($cursor))
    {
       $REGISTER_TIME6=$ROW["REGISTER_TIME"];
       $REMAK6=$ROW["REMARK"];
       $REGISTER_TIME6=strtok($REGISTER_TIME6," ");
       $REGISTER_TIME6=strtok(" ");

       if($HOLIDAY==""&&$DUTY_TYPE6=="1" && compare_time($REGISTER_TIME6,$DUTY_TIME6)==1)
          {$REGISTER_TIME6.=" 迟到";$REMARK66="备注：".$REMAK6;}

       if($HOLIDAY==""&&$DUTY_TYPE6=="2" && compare_time($REGISTER_TIME6,$DUTY_TIME6)==-1)
          {$REGISTER_TIME6.=" 早退";$REMARK66="备注：".$REMAK6;}
    }
    else
    {
       if($HOLIDAY=="")
          $REGISTER_TIME6="未登记";
       else
          $REGISTER_TIME6=$HOLIDAY;
       
    }

?>
      <td nowrap align="center"><?=$REGISTER_TIME6?><br><?=$REMARK66?></td>
<?
 }
?>
    </tr>
<?
}//while
?>

</table>

<?
Button_Back();
?>

</body>
</html>

⌨️ 快捷键说明

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