今日日程.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/calendar.gif" WIDTH="18" HEIGHT="16" align="absmiddle"> 今日日程</td>
   <td id="module_<?=$MODULE_ID?>_more" align="right">
   <div id="module_<?=$MODULE_ID?>_op" style="float:left;display:none;"><a href="javascript:_edit('<?=$MODULE_ID?>');"><img border="0" src="/images/edit.gif" alt="设置显示条数"></a><?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"><a href="/general/calendar/"> <img src="/images/green_arrow.gif" border="0" align="absmiddle"> 全部</a>&nbsp;</div>
   </td>
 </tr>
 <tr class="TableControl" id="module_<?=$MODULE_ID?>_edit" style="display:none;">
   <td colspan="2" align="right">
     <div id="module_<?=$MODULE_ID?>_info" style="float:left;"></div>
     显示条数：<input type="input" size="3" class="SmallInput" value="<?=$_COOKIE[$LOGIN_USER_ID."_my_".$MODULE_ID."_nums"]?>" name="MODULE_NUM_<?=$MODULE_ID?>">&nbsp;
     <a href="javascript:SetNums('<?=$MODULE_ID?>');" title="保存设置">设置</a>
     <a href="javascript:_edit('<?=$MODULE_ID?>');" title="关闭">关闭</a>
    </td>
  </tr>
 <tr style="background:#FFFFFF url(/images/water/calendar.jpg) no-repeat bottom right">
    <td colspan=2 height="50">
<?
 //============================ 显示日程安排 =======================================
 $CUR_DATE=date("Y-m-d",time());
 $CUR_TIME=date("Y-m-d H:i:s",time());
 $MAX_COUNT=intVal($_COOKIE[$LOGIN_USER_ID."_my_".$MODULE_ID."_nums"]);
 if($MAX_COUNT<=0 || $MAX_COUNT>=1000)
    $MAX_COUNT=10;

 $query = "SELECT * from CALENDAR where USER_ID='$LOGIN_USER_ID' and to_days(CAL_TIME)=to_days('$CUR_DATE') order by CAL_TIME";
 $cursor= exequery($connection,$query);
 $CAL_COUNT=0;

 while($ROW=mysql_fetch_array($cursor))
 {
    $CAL_COUNT++;
    if($CAL_COUNT>$MAX_COUNT)
      break;
    $CAL_ID=$ROW["CAL_ID"];
    $CAL_TIME=$ROW["CAL_TIME"];
    $END_TIME=$ROW["END_TIME"];

    $CAL_TIME=strtok($CAL_TIME," ");
    $CAL_TIME=strtok(" ");
    $CAL_TIME=substr($CAL_TIME,0,5);

    $END_TIME=strtok($END_TIME," ");
    $END_TIME=strtok(" ");
    $END_TIME=substr($END_TIME,0,5);

    $CONTENT=$ROW["CONTENT"];
    $CONTENT=str_replace("<","&lt",$CONTENT);
    $CONTENT=str_replace(">","&gt",$CONTENT);
    $CONTENT=stripslashes($CONTENT);
?>
         ·<?=$CAL_TIME?>-<?=$END_TIME?> <?=$CONTENT?><br>
<?
 }

 //============================ 显示日常事务 =======================================
 $query = "SELECT * from AFFAIR where USER_ID='$LOGIN_USER_ID' and BEGIN_TIME<='$CUR_TIME' order by REMIND_TIME";
 $cursor= exequery($connection,$query);
 while($ROW=mysql_fetch_array($cursor))
 {
    $AFF_ID=$ROW["AFF_ID"];
    $USER_ID=$ROW["USER_ID"];
    $TYPE=$ROW["TYPE"];
    $REMIND_DATE=$ROW["REMIND_DATE"];
    $REMIND_TIME=$ROW["REMIND_TIME"];
    $CONTENT=$ROW["CONTENT"];

    $FLAG=0;
    if($TYPE=="2")
       $FLAG=1;
    elseif($TYPE=="3" && date("w",time())==$REMIND_DATE)
       $FLAG=1;
    elseif($TYPE=="4" && date("j",time())==$REMIND_DATE)
       $FLAG=1;
    elseif($TYPE=="5")
    {
       $REMIND_ARR=explode("-",$REMIND_DATE);
       $REMIND_DATE_MON=$REMIND_ARR[0];
       $REMIND_DATE_DAY=$REMIND_ARR[1];
       if(date("n",time())==$REMIND_DATE_MON && date("j",time())==$REMIND_DATE_DAY)
          $FLAG=1;
    }

    if($FLAG==1)
    {
    	$CAL_COUNT++;
?>
         ·<?=substr($REMIND_TIME,0,5)?> <?=$CONTENT?><br>
<?
    }
 }

 if($CAL_COUNT==0)
 {
      echo "·暂无日程安排";
 }
?>
 </td>
</tr>
</table>
</div>