外出人员公告牌.php

极限网络智能办公系统 Office Automation V3.0官方100％源代码.

<!-------------------- 外出人员公告牌----------------------->
<div id="module_<?=$MODULE_ID?>"  style="position: relative;padding-bottom:10px;">
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableControl">
   <td id="module_<?=$MODULE_ID?>_head" class="TableHeader" width="58%"><img src="/images/menu/attendance.gif" WIDTH="19" HEIGHT="17" align="absmiddle"> 外出人员</td>
   <td id="module_<?=$MODULE_ID?>_more" align="right">
   <div id="module_<?=$MODULE_ID?>_op" style="float:left;display:none;"><?if($VIEW_TYPE!="2"){?><a id="module_<?=$MODULE_ID?>_url" href="#" onclick="_del('<?=$MODULE_ID?>');"><img border="0" src="/images/x.gif" alt="不显示该模块"></a><?}?></div>
   <div style="float:right">&nbsp;</div>
   </td>
</tr>

<tr class="TableData">
   <td colspan=2 height="50">

<?
 $CUR_TIME=date("Y-m-d H:i:s",time());

 $COUNT1=0;
 $query = "SELECT * from USER,USER_PRIV,ATTEND_EVECTION where USER.USER_ID=ATTEND_EVECTION.USER_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV and STATUS='1' and ALLOW='1' and to_days(EVECTION_DATE1)<=to_days('$CUR_TIME') and to_days(EVECTION_DATE2)>=to_days('$CUR_TIME') order by USER_PRIV.PRIV_NO,USER.USER_NO";
 $cursor= exequery($connection,$query);
 while($ROW1=mysql_fetch_array($cursor))
 {
    $COUNT1++;
    if($COUNT1>12)
       break;

    $USER_NAME=$ROW1["USER_NAME"];
    $EVECTION_DEST=$ROW1["EVECTION_DEST"];
    $EVECTION_DATE1=substr($ROW1["EVECTION_DATE1"],0,10);
    $EVECTION_DATE2=substr($ROW1["EVECTION_DATE2"],0,10);

    if($COUNT1==1)
    {
?>
  <fieldset class="small">
  <legend align=left>
      <b>出差人员</b>
  </legend>
<?
    }
?>

  <u title="<?=$EVECTION_DATE1?> 至 <?=$EVECTION_DATE2?> 地点：<?=$EVECTION_DEST?>" style="cursor:hand"><?=$USER_NAME?></u>

<?
 }

 if($COUNT1>0)
    echo "</fieldset>";

 $COUNT2=0;
 $query = "SELECT * from USER,USER_PRIV,ATTEND_LEAVE where USER.USER_ID=ATTEND_LEAVE.USER_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV and STATUS='1' and ALLOW='1' and LEAVE_DATE1<='$CUR_TIME' and LEAVE_DATE2>='$CUR_TIME' order by USER_PRIV.PRIV_NO,USER.USER_NO";
 $cursor= exequery($connection,$query);
 while($ROW1=mysql_fetch_array($cursor))
 {
    $COUNT2++;
    if($COUNT2>12)
       break;

    $USER_NAME=$ROW1["USER_NAME"];
    $LEAVE_DATE1=$ROW1["LEAVE_DATE1"];
    $LEAVE_DATE2=$ROW1["LEAVE_DATE2"];
    if($COUNT2==1)
    {
?>
  <fieldset class="small">
  <legend align=left>
      <b>请假人员</b>
  </legend>
<?
    }
?>

  <u title="<?=$LEAVE_DATE1?> 至 <?=$LEAVE_DATE2?>" style="cursor:hand"><?=$USER_NAME?></u>

<?
 }

 if($COUNT2>0)
    echo "</fieldset>";


 $COUNT3=0;
 $query = "SELECT * from USER,USER_PRIV,ATTEND_OUT where USER.USER_ID=ATTEND_OUT.USER_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV and STATUS='0' and ALLOW='1' and to_days(SUBMIT_TIME)=to_days('$CUR_TIME') and OUT_TIME1<='".date("H:i",time())."' and OUT_TIME2>='".date("H:i",time())."' order by USER_PRIV.PRIV_NO,USER.USER_NO";
 $cursor= exequery($connection,$query);
 while($ROW1=mysql_fetch_array($cursor))
 {
    $COUNT3++;
    if($COUNT3>12)
       break;

    $USER_NAME=$ROW1["USER_NAME"];
    $OUT_TIME1=$ROW1["OUT_TIME1"];
    $OUT_TIME2=$ROW1["OUT_TIME2"];
    $SUBMIT_TIME=substr($ROW1["SUBMIT_TIME"],0,-3);
    if($COUNT3==1)
    {
?>
  <fieldset class="small">
  <legend align=left>
      <b>外出人员</b>
  </legend>
<?
    }
?>

  <u title="<?=$SUBMIT_TIME?> 至 <?=$OUT_TIME2?>" style="cursor:hand"><?=$USER_NAME?></u>

<?
 }

 if($COUNT3>0)
    echo "</fieldset>";

 if($COUNT1==0&&$COUNT2==0&&$COUNT3==0)
    echo "·无外出人员";
?>

 </td>
</tr>
</table>
</div>