1.php

极限网络智能办公系统—MYOA26—100％—源程序。

<?php

echo "<!-------------------- 今日日程 ----------------------->\r\n";
echo "<s";
echo "cript>\r\nfunction my_note(CAL_ID)\r\n{\r\n  my_left=document.body.scrollLeft+event.clientX-event.offsetX-50;\r\n  my_top=document.body.scrollTop+event.clientY-event.offsetY+150;\r\n  window.open(\"/general/calendar/arrange/note.php?CAL_ID=\"+CAL_ID,\"note_win\"+CAL_ID,\"height=170,width=180,status=0,toolbar=no,menubar=no,location=no,scrollbars=auto,top=\"+ my_top +\",left=\"+ my_left +\",resizable=no\");\r\n}\r\n\r\nfunct";
echo "ion my_note1(AFF_ID)\r\n{\r\n  my_left=document.body.scrollLeft+event.clientX-event.offsetX-50;\r\n  my_top=document.body.scrollTop+event.clientY-event.offsetY+150;\r\n\r\n  window.open(\"/general/calendar/affair/note.php?AFF_ID=\"+AFF_ID,\"note_win\"+AFF_ID,\"height=170,width=180,status=0,toolbar=no,menubar=no,location=no,scrollbars=auto,top=\"+ my_top +\",left=\"+ my_left +\",resizable=no\");\r\n}\r\n</script>\r\n\r\n <tr cl";
echo "ass=\"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 height=\"50\">\r\n";
$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 " <a href=\"#\" onclick=\"javascript:my_note(";
	echo $CAL_ID;
	echo ");\">";
	echo $CONTENT;
	echo "</a><br>\r\n";
}
$CUR_DATE = date( "Y-m-d", time( ) );
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$connection = openconnection( );
$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 " <a href=\"#\" onclick=\"javascript:my_note1(";
		echo $AFF_ID;
		echo ");\">";
		echo $CONTENT;
		echo "</a><br>\r\n";
	}
}
if ( $CAL_COUNT == 0 )
{
	echo "暂无日程安排";
}
echo "\r\n <br>\r\n </td>\r\n</tr>\r\n";
?>