近日日程.php

信达OA增加模块

<!-------------------- 近日日程 -----------------------> 
<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"> 近日日程(10日内)</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')<10 and to_days('$CUR_DATE')<=to_days(CAL_TIME) 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_DATE=strtok($CAL_TIME," "); 
$CAL_TIME1=strtok($CAL_TIME," "); 
$CAL_TIME1=strtok(" "); 
$CAL_TIME1=substr($CAL_TIME1,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); 

$OVER_STATUS=$ROW["OVER_STATUS"]; 
if($OVER_STATUS=="" || $OVER_STATUS=="1") 
$OVER_STATUS1="<font color='#00AA00'><b>已完成</b></font>"; 
elseif($OVER_STATUS=="0") 
$OVER_STATUS1=""; 
?> 
·<b><?=$CAL_DATE?></b><?if($CUR_DATE==$CAL_DATE)echo " <font color=red><b>今日</b></font>";echo " 星期".get_week($CAL_TIME);?> <?=$CAL_TIME1?>-<?=$END_TIME?> <?=$CONTENT?> <?=$OVER_STATUS1?><br> 
<? 
} 

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