本周员工生日.php

来自「极限网络智能办公系统 Office Automation V3.0官方100％源」· PHP 代码 · 共 49 行

<?
//-------------------------- 本周员工生日 -------------------------
 $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' 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 || $DATA> $WEEK_END || $BIRTHDAY=="1900-01-01 00:00:00" || $BIRTHDAY=="0000-00-00 00:00:00")
       continue;
    $PERSON_STR.=$USER_NAME."(".date("m-d",strtotime($DATA)).")&nbsp&nbsp&nbsp&nbsp";
    $PERSON_COUNT++;
}
?>
<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/notify.gif" WIDTH="18" HEIGHT="16" align="absmiddle"> 本周生日员工</td>
  <td id="module_<?=$MODULE_ID?>_more" align="right" nowrap>
  <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>
<?
if($PERSON_COUNT>0)
{
?>
    <marquee style="color:#FF6600;" behavior=scroll scrollamount=2 scrolldelay=100 onmouseover='this.stop()' onmouseout='this.start()' border=0>
     本周生日：<?=$PERSON_STR?>
     </marquee>
<?
}
else
   echo "本周无员工生日";
?>
 </td>
</tr>
</table>
</div>