今日日程.php

极限网络智能办公系统 - Office Automation 2.8 100％ 源码

<?php

echo "<!-------------------- 今日日程 ----------------------->\r\n\r\n <tr class=\"TableControl\">\r\n   <td class=\"TableHeader\" width=\"70%\"><img src=\"/images/menu/calendar.gif\" WIDTH=\"18\" HEIGHT=\"16\" align=\"absmiddle\"> 今日日程</td>\r\n   <td align=\"right\"><a href=\"/general/calendar/\"> <img src=\"/images/green_arrow.gif\" border=\"0\" align=\"absmiddle\"> 全部</a>&nbsp;</td>\r\n </tr>\r\n <tr class=\"TableData\">\r\n    <td colspan=2 heig";
echo "ht=\"50\">\r\n";
$CUR_DATE = date( "Y-m-d", time( ) );
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$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;
	$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 );
	echo "         ·";
	echo $CAL_TIME;
	echo "-";
	echo $END_TIME;
	echo " ";
	echo $CONTENT;
	echo "<br>\r\n";
}
$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;
	}
	else if ( $TYPE == "3" && date( "w", time( ) ) == $REMIND_DATE )
	{
		$FLAG = 1;
	}
	else if ( $TYPE == "4" && date( "j", time( ) ) == $REMIND_DATE )
	{
		$FLAG = 1;
	}
	else if ( $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;
		echo "         ·";
		echo substr( $REMIND_TIME, 0, 5 );
		echo " ";
		echo $CONTENT;
		echo "<br>\r\n";
	}
}
if ( $CAL_COUNT == 0 )
{
	echo "·暂无日程安排";
}
echo "\r\n <br>\r\n </td>\r\n</tr>\r\n";
?>