content_27.php

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

<?php

$paraarray = getindexpara( $block_id );
$rownum = $paraarray['block_row'];
$rownum1 = intval( $rownum / 2 );
$rownum2 = $rownum - $rownum1;
$LOGIN_USER_ID = $_SESSION['LOGIN_USER_ID'];
$CUR_DATE = date( "Y-m-d", time( ) );
$sql1 = "\r\n\t\t SELECT COUNT(*) from CALENDAR where USER_ID='".$LOGIN_USER_ID."' and TO_DAYS(CAL_TIME)=TO_DAYS('{$CUR_DATE}');\r\n\t\t";
$cur = exequery( $connection, $sql1 );
$ROW1 = mysql_fetch_array( $cur );
$COUNT_CALENDAR = $ROW1[0];
$OUTDATA = $rownum1 - $COUNT_CALENDAR;
if ( 0 < $OUTDATA )
{
	$rownum2 = $rownum2 + $OUTDATA;
	$rownum1 = $COUNT_CALENDAR;
}
else
{
	$year = $year != "" ? $year : date( "Y" );
	$month = $month != "" ? $month : date( "m" );
	$day = $day != "" ? $day : date( "d" );
	$week = date( "w", strtotime( $year."-".$month."-".$day ) );
	$sql2 = "\r\n\t\t  SELECT COUNT(*) FROM affair \r\n\t\t\t\t    WHERE TO_DAYS(BEGIN_TIME)<=TO_DAYS('".$year."-".$month."-".$day."')\r\n\t\t\t\t\tAND (TYPE=2 \r\n\t\t\t\t\t\tOR (TYPE=3 AND REMIND_DATE='".$week."')\r\n\t\t\t\t\t\tOR (TYPE=4 AND REMIND_DATE='".$day."') \r\n\t\t\t\t\t\tOR (TYPE=5 AND REMIND_DATE='".abs( $month )."-".abs( $day )."'))\r\n\t\t\t\t\tAND USER_ID='".$LOGIN_USER_ID."' \r\n\t\t";
	$cur1 = exequery( $connection, $sql2 );
	$ROW2 = mysql_fetch_array( $cur1 );
	$COUNT_AFFAIR = $ROW2[0];
	$OUTDATA = $rownum2 - $COUNT_AFFAIR;
	if ( 0 < $OUTDATA )
	{
		$rownum1 = $rownum1 + $OUTDATA;
		$rownum2 = $COUNT_AFFAIR;
	}
}
$query = "\r\n\t\tSELECT * from CALENDAR where USER_ID='{$LOGIN_USER_ID}' and to_days(CAL_TIME)=to_days('{$CUR_DATE}') order by CAL_TIME LIMIT 0,{$rownum1}\r\n\t\t";
$cursor = exequery( $connection, $query );
$CAL_COUNT = 0;
$i = 1;
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 "    <div class = \"linkdiv\">\r\n\t<IMG SRC=\"/images/littlegif/news_bullet.gif\" WIDTH=\"15\" HEIGHT=\"10\" BORDER=\"0\" ALT=\"\">\r\n    <a href=\"#\" onclick = \"openWindows('/general/calendar/arrange/note.php?CAL_ID=";
	echo $CAL_ID;
	echo "')\">";
	echo substrgb( $CONTENT, $paraarray['subject_length'], "..." );
	echo "</a>\r\n\t";
	echo "<s";
	echo "pan class = \"linkgray\">";
	echo $CAL_TIME;
	echo "-";
	echo $END_TIME;
	echo "</span>\r\n\t</div>\r\n\r\n\r\n";
}
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$connection = openconnection( );
$year = $year != "" ? $year : date( "Y" );
$month = $month != "" ? $month : date( "m" );
$day = $day != "" ? $day : date( "d" );
$week = date( "w", strtotime( $year."-".$month."-".$day ) );
$query = "\r\n\t\t          SELECT * FROM affair \r\n\t\t\t\t    WHERE TO_DAYS(BEGIN_TIME)<=TO_DAYS('".$year."-".$month."-".$day."')\r\n\t\t\t\t\tAND (TYPE=2 \r\n\t\t\t\t\t\tOR (TYPE=3 AND REMIND_DATE='".$week."')\r\n\t\t\t\t\t\tOR (TYPE=4 AND REMIND_DATE='".$day."') \r\n\t\t\t\t\t\tOR (TYPE=5 AND REMIND_DATE='".abs( $month )."-".abs( $day )."'))\r\n\t\t\t\t\tAND USER_ID='".$_SESSION['LOGIN_USER_ID']."' \r\n\t\t\t\t\tORDER BY REMIND_TIME ASC limit 0,{$rownum2}\r\n\t\t  \r\n\t\t           ";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$CAL_COUNT;
	$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'];
	echo "\t<Div class = \"linkdiv\">\r\n\t<IMG SRC=\"/images/littlegif/news_bullet.gif\" WIDTH=\"15\" HEIGHT=\"10\" BORDER=\"0\" ALT=\"\">";
	echo substr( $REMIND_TIME, 0, 5 );
	echo "      <a href=\"#\" onclick=\"openWindows('/general/calendar/affair/note.php?AFF_ID=";
	echo $AFF_ID;
	echo "')\">";
	echo substrgb( $CONTENT, $paraarray['subject_length'], "..." );
	echo "</a>\r\n\t</div>\r\n\r\n\r\n";
}
if ( $CAL_COUNT == 0 )
{
	echo $nothingdata;
}
echo "<div align=\"right\" style=\"padding:2px；font-size:12px;\"><a href=\"/general/calendar/tplan.php\">更多</a></div>";
?>