content_3.php

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

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility.php" );
include_once( "general/new_mytable/index_function.php" );
ob_end_clean( );
$paraarray = getindexpara( $block_id );
$rownum = $paraarray['block_row'];
$flowid = $paraarray['common_id'];
$query = "SELECT * FROM flow_run_prcs frp,flow_run fr,flow_type ft\r\n\t\t      WHERE frp.USER_ID='{$LOGIN_USER_ID}' \r\n\t\t\t  AND ( (frp.prcs_flag='2' AND frp.SAVEFORM_TIME IS NULL AND frp.OP_FLAG=0) \r\n\t\t\t        OR (frp.prcs_flag='2' AND frp.OP_FLAG=1) \r\n\t\t\t\t\tOR frp.prcs_flag='1' \r\n\t\t\t\t  ) \r\n\t\t\t  AND (fr.RUN_ID=frp.RUN_ID AND ft.FLOW_ID=fr.FLOW_ID)";
if ( 0 < $flowid )
{
	$query .= " AND fr.FLOW_ID=".$flowid." ";
}
$query .= " ORDER BY frp.RUN_ID DESC LIMIT 0,".$rownum;
$cursor = exequery( $connection, $query );
$flow_count = 0;
while ( $row = mysql_fetch_array( $cursor ) )
{
	++$flow_count;
	$run_id = $row['RUN_ID'];
	$prcs_flag = $row['PRCS_FLAG'];
	$prcs_id = $row['PRCS_ID'];
	$flow_prcs = $row['FLOW_PRCS'];
	if ( $prcs_flag == "1" )
	{
		$status = "<img src='/images/newred.gif' alt='未查看' align='absmiddle'>";
	}
	else
	{
		$status = "";
	}
	$sql = "SELECT USER_ID,PRCS_TIME FROM flow_run_prcs WHERE RUN_ID={$run_id} AND PRCS_ID=1";
	$rs = exequery( $connection, $sql );
	$row1 = mysql_fetch_array( $rs );
	$username = getusername( $row1['USER_ID'] );
	$datetime = date( "Y-m-d H:i", strtotime( $row1['PRCS_TIME'] ) );
	$query = "SELECT * from FLOW_RUN WHERE RUN_ID={$run_id}";
	$cursor1 = exequery( $connection, $query );
	if ( $row = mysql_fetch_array( $cursor1 ) )
	{
		$flow_id = $row['FLOW_ID'];
		$run_name = $row['RUN_NAME'];
	}
	$query = "SELECT * from FLOW_TYPE WHERE FLOW_ID={$flow_id}";
	$cursor1 = exequery( $connection, $query );
	if ( $row = mysql_fetch_array( $cursor1 ) )
	{
		$flow_name = $row['FLOW_NAME'];
		$flow_type = $row['FLOW_TYPE'];
	}
	$url = "input_form.php";
	if ( $flow_type == 2 )
	{
		$url = "free_input_form.php";
	}
	echo "\r\n<div class=\"linkdiv\"><IMG SRC=\"/images/littlegif/news_bullet.gif\" WIDTH=\"15\" HEIGHT=\"10\" BORDER=\"0\" ALT=\"\"><a href=\"/general/workflow/input_form/";
	echo $url;
	echo "?RUN_ID=";
	echo $run_id;
	echo "&FLOW_ID=";
	echo $flow_id;
	echo "&PRCS_ID=";
	echo $prcs_id;
	echo "&FLOW_PRCS=";
	echo $flow_prcs;
	echo "\">";
	echo substrgb( $run_name, $paraarray['subject_length'], "..." );
	echo "</a>";
	echo $status;
	echo " \r\n";
	if ( $paraarray['is_show_date'] )
	{
		echo "<span class='linkgray10'>(".$datetime.")</span>";
	}
	if ( $paraarray['is_show_creator'] )
	{
		echo "<span class='linkgray'>".$username."</span>";
	}
	echo "\r\n</div>\r\n";
}
if ( $flow_count == 0 )
{
	echo $nothingdata;
}
echo "<div align=\"right\" style=\"padding:2px；font-size:12px;\"><a href=\"/general/workflow/work_list.php\">更多</a></div>";
?>