外出人员公告牌.php

通达OA2007SE源代码 非常好的

<?
  echo '<!-------------------- 外出人员公告牌----------------------->
<div id="module_';
  echo $MODULE_ID;
  echo '"  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_';
  echo $MODULE_ID;
  echo '_head" class="TableHeader" width="58%"><img src="/images/menu/attendance.gif" WIDTH="19" HEIGHT="17" align="absmiddle"> 外出人员</td>
   <td id="module_';
  echo $MODULE_ID;
  echo '_more" align="right">
   <div id="module_';
  echo $MODULE_ID;
  echo '_op" style="float:left;display:none;">';
  if (($VIEW_TYPE != '2'))
  {
    echo '<a id="module_';
    echo $MODULE_ID;
    echo '_url" href="#" onclick="_del(\'';
    echo $MODULE_ID;
    echo '\');"><img border="0" src="/images/x.gif" alt="不显示该模块"></a>';
  }
  echo '</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 USER_NAME,EVECTION_DEST,EVECTION_DATE1,EVECTION_DATE2 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 ((12 < $COUNT1))
    {
      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))
    {
      echo '  <fieldset class="small">
  <legend align=left>
      <b>出差人员</b>
  </legend>
';
    }
    echo '
  <u title="';
    echo $EVECTION_DATE1;
    echo ' 至 ';
    echo $EVECTION_DATE2;
    echo ' 地点：';
    echo $EVECTION_DEST;
    echo '" style="cursor:hand">';
    echo $USER_NAME;
    echo '</u>
';
  }
  if ((0 < $COUNT1))
  {
    echo '</fieldset>';
  }
  $COUNT2 = 0;
  $query = (((((''.'SELECT USER_NAME,LEAVE_DATE1,LEAVE_DATE2 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 ((12 < $COUNT2))
    {
      break;
    }
    $USER_NAME = $ROW1['USER_NAME'];
    $LEAVE_DATE1 = $ROW1['LEAVE_DATE1'];
    $LEAVE_DATE2 = $ROW1['LEAVE_DATE2'];
    if (($COUNT2 == 1))
    {
      echo '  <fieldset class="small">
  <legend align=left>
      <b>请假人员</b>
  </legend>
';
    }
    echo '
  <u title="';
    echo $LEAVE_DATE1;
    echo ' 至 ';
    echo $LEAVE_DATE2;
    echo '" style="cursor:hand">';
    echo $USER_NAME;
    echo '</u>
';
  }
  if ((0 < $COUNT2))
  {
    echo '</fieldset>';
  }
  $COUNT3 = 0;
  $query = (((((((''.'SELECT USER_NAME,OUT_TIME1,OUT_TIME2 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 ((12 < $COUNT3))
    {
      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))
    {
      echo '  <fieldset class="small">
  <legend align=left>
      <b>外出人员</b>
  </legend>
';
    }
    echo '
  <u title="';
    echo $OUT_TIME1;
    echo ' 至 ';
    echo $OUT_TIME2;
    echo '" style="cursor:hand">';
    echo $USER_NAME;
    echo '</u>
';
  }
  if ((0 < $COUNT3))
  {
    echo '</fieldset>';
  }
  if (((($COUNT1 == 0) AND ($COUNT2 == 0)) AND ($COUNT3 == 0)))
  {
    echo '·无外出人员';
  }
  echo '
 </td>
</tr>
</table>
</div>
';
?>