本周员工生日.php

通达OA2007SE源代码 非常好的

<?
  $CUR_DATE = date ('Y-m-d', time ());
  $WEEK_BEGIN = date ('Y-m-d', (strtotime ($CUR_DATE) - ((date ('w', strtotime ($CUR_DATE)) * 24) * 3600)));
  $WEEK_END = date ('Y-m-d', (strtotime ($CUR_DATE) + (((6 - date ('w', strtotime ($CUR_DATE))) * 24) * 3600)));
  $query = 'SELECT USER_NAME,BIRTHDAY from USER where NOT_LOGIN!=\'1\' and DEPT_ID!=0 order by SUBSTRING(BIRTHDAY,6,5),USER_NAME ASC';
  $cursor = exequery ($connection, $query);
  $PERSON_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $USER_NAME = $ROW['USER_NAME'];
    $BIRTHDAY = $ROW['BIRTHDAY'];
    $DATA = (substr ($CUR_DATE, 0, 4).substr ($BIRTHDAY, 4, 6));
    if ((((($DATA < $WEEK_BEGIN) OR ($WEEK_END < $DATA)) OR ($BIRTHDAY == '1900-01-01 00:00:00')) OR ($BIRTHDAY == '0000-00-00 00:00:00')))
    {
      continue;
    }
    else
    {
      ($PERSON_STR .= ((($USER_NAME.'(').date ('m-d', strtotime ($DATA))).')&nbsp&nbsp&nbsp&nbsp'));
      ++$PERSON_COUNT;
      continue;
    }
  }
  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/notify.gif" WIDTH="18" HEIGHT="18" align="absmiddle"> 本周生日员工</td>
  <td id="module_';
  echo $MODULE_ID;
  echo '_more" align="right" nowrap>
  <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>
';
  if ((0 < $PERSON_COUNT))
  {
    echo '    <marquee style="color:#FF6600;" behavior=scroll scrollamount=2 scrolldelay=100 onmouseover=\'this.stop()\' onmouseout=\'this.start()\' border=0>
     本周生日：';
    echo $PERSON_STR;
    echo '     </marquee>
';
  }
  else
  {
    echo '本周无员工生日';
  }
  echo ' </td>
</tr>
</table>
</div>
';
?>