content_30.php

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

<?php

$paraarray = getindexpara( $block_id );
$rownum = $paraarray['block_row'];
$CUR_DATE = date( "Y-m-d", time( ) );
$connection = openconnection( );
$query = "SELECT * from WORK_PLAN ORDER BY PLAN_ID DESC ";
$cursor = exequery( $connection, $query );
$PLAN_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$plan_id = $ROW['PLAN_ID'];
	$name = $ROW['NAME'];
	$CONTENT = $ROW['CONTENT'];
	$BEGIN_DATE = $ROW['BEGIN_DATE'];
	$END_DATE = $ROW['END_DATE'];
	$manager = $ROW['MANAGER'];
	$participator = $ROW['PARTICIPATOR'];
	$to_id = $ROW['TO_ID'];
	$sql = "select DEPT_ID from user where USER_ID='".$_SESSION['LOGIN_USER_ID']."'";
	$cs = exequery( $connection, $query );
	if ( $r = mysql_fetch_row( $cs ) )
	{
		$dept_id = $r[0];
	}
	if ( $to_id != "ALL_DEPT" && strpos( $manager, $_SESSION['LOGIN_USER_ID'] ) === false && strpos( $participator, $_SESSION['LOGIN_USER_ID'] ) === false && strpos( $to_id, $dept_id ) === false )
	{
		continue;
	}
	++$PLAN_COUNT;
	if ( $rownum < $PLAN_COUNT )
	{
	}
	else
	{
		if ( compare_date( $CUR_DATE, $BEGIN_DATE ) < 0 )
		{
			$STATUS = 1;
			$STATUS_DESC = "(待生效)";
		}
		else
		{
			$STATUS = 2;
			$STATUS_DESC = "<font color='#00AA00'><b>(已生效)</b></span>";
		}
		if ( $END_DATE != "0000-00-00" && 0 < compare_date( $CUR_DATE, $END_DATE ) )
		{
			$STATUS = 3;
			$STATUS_DESC = "<font color='#FF0000'><b>(已终止)</b></span>";
		}
		echo "<div class =\"linkdiv\">\r\n<IMG SRC=\"/images/littlegif/news_bullet.gif\" WIDTH=\"15\" HEIGHT=\"10\" BORDER=\"0\" ALT=\"\">\r\n<a href=\"#\" onclick=\"openWindows('/general/work_plan/show/plan_detail.php?PLAN_ID=";
		echo $plan_id;
		echo "');\">\r\n";
		echo substrgb( $name, $paraarray['subject_length'], "..." );
		echo "</a>\r\n";
		if ( $paraarray['is_show_date'] == 1 )
		{
			echo "<span class =\"linkgray10\">({$BEGIN_DATE} 至 {$END_DATE})</span>";
		}
		if ( $paraarray['is_show_creator'] == 1 )
		{
			$user_name = getusername( $manager );
		}
		echo "<span class =\"linkgray\">{$user_name}</span>";
		echo $STATUS_DESC;
		echo "</div>\r\n";
	}
}
if ( $PLAN_COUNT == 0 )
{
	echo $nothingdata;
}
echo "<div align=\"right\" style=\"padding:2px；font-size:12px;\"><a href=\"/general/work_plan/show\">更多</a></div>\r\n";
?>