search_flow.php

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

	$func_link_str = "";
	if ( $is_over == true )
	{
		++$run_flow_end_count;
		$func_link_str .= "";
		$sqlman = "\r\n\t\t           SELECT FLOW_ID FROM flow_type \r\n\t\t\t\t      WHERE FLOW_ID=".$flow_id." \r\n\t\t\t\t\t     AND MANAGE_USER LIKE '%".$_SESSION['LOGIN_USER_ID'].",%'\r\n\t\t          ";
		$resman = exequery( $connection, $sqlman );
		if ( $rowman = mysql_fetch_array( $resman ) )
		{
			++$run_flow_manage_count;
			$func_link_str .= "<a onClick=\"delete_run(".$run_id.");\" style=\"cursor:hand;color:blue\" title=\"以监控人员身份删除\"> 删除</a>";
		}
	}
	else
	{
		$sqltra = " \r\n\t\t          SELECT * FROM flow_run_prcs \r\n\t\t              WHERE USER_ID='".$_SESSION['LOGIN_USER_ID']."' \r\n\t\t\t\t\t     AND PRCS_FLAG<>'4' \r\n\t\t\t\t\t\t AND RUN_ID=".$run_id." ORDER BY PRCS_ID DESC\r\n\t\t\t\t\t  ";
		$restra = exequery( $connection, $sqltra );
		if ( $rowtra = mysql_fetch_array( $restra ) )
		{
			$prcs_flag = $rowtra['PRCS_FLAG'];
			$prcs_id = $rowtra['PRCS_ID'];
			$flow_prcs = $rowtra['FLOW_PRCS'];
			$op_flag = $rowtra['OP_FLAG'];
			if ( $prcs_flag == 1 || $prcs_flag == 2 )
			{
				++$run_flow_transact_count;
				$is_link_run_name = 1;
				$run_name_link_str = flowlinksssfunc( $flow_type, "transact" )."?RUN_ID=".$run_id."&FLOW_ID=".$flow_id."&PRCS_ID=".$prcs_id."&FLOW_PRCS=".$flow_prcs."&FLOW_TYPE=".$flow_type;
				$func_link_str .= "<a href=\"".flowlinksssfunc( $flow_type, "transact" )."?RUN_ID=".$run_id."&FLOW_ID=".$flow_id."&PRCS_ID=".$prcs_id."&FLOW_PRCS=".$flow_prcs."&FLOW_TYPE=".$flow_type."\"> 办理</a>";
				$sqlcountpid = "SELECT COUNT(PRCS_ID) AS cnt_pid FROM flow_run_prcs WHERE PRCS_ID=".$prcs_id." AND RUN_ID=".$run_id;
				$rescountpid = exequery( $connection, $sqlcountpid );
				$rowcountpid = mysql_fetch_array( $rescountpid );
				if ( $rowcountpid['cnt_pid'] == 1 )
				{
					$func_link_str .= "<a href=\"".flowlinksssfunc( $flow_type, "entrust" )."?RUN_ID=".$run_id."&FLOW_ID=".$flow_id."&PRCS_ID=".$prcs_id."\"> 委托</a>";
				}
			}
			else if ( $op_flag == 1 )
			{
				$func_link_str .= "<a onClick=\"call_back(".$run_id.",".$prcs_id.");\" style=\"cursor:hand;color:#0000FF\"> 收回</a>";
			}
		}
		$sqlman = "\r\n\t\t           SELECT FLOW_ID FROM flow_type \r\n\t\t\t\t      WHERE FLOW_ID=".$flow_id." \r\n\t\t\t\t\t     AND MANAGE_USER LIKE '%".$_SESSION['LOGIN_USER_ID'].",%'\r\n\t\t          ";
		$resman = exequery( $connection, $sqlman );
		if ( $rowman = mysql_fetch_array( $resman ) )
		{
			++$run_flow_manage_count;
			$sqlmaxpid = "SELECT MAX(PRCS_ID) AS pid FROM flow_run_prcs WHERE RUN_ID=".$run_id;
			$resmaxpid = exequery( $connection, $sqlmaxpid );
			$rowmaxpid = mysql_fetch_array( $resmaxpid );
			$prcs_id_max = $rowmaxpid['pid'];
			$func_link_str .= "<a href=\"".flowlinksssfunc( $flow_type, "turnnext" )."?OP=MANAGE&RUN_ID=".$run_id."&FLOW_ID=".$flow_id."&PRCS_ID=".$prcs_id_max."\" title=\"以监控人员身份转到下一步\"> 转到下一步</a>";
			if ( $flow_type == 2 )
			{
				$func_link_str .= "<a onClick=\"stop_run(".$run_id.",".$flow_id.",".$prcs_id_max.");\" style=\"cursor:hand;color:#0000FF\" title=\"以监控人员身份终止\"> 终止</a>";
			}
			$func_link_str .= "<a onClick=\"delete_run(".$run_id.");\" style=\"cursor:hand;color:#0000FF\" title=\"以监控人员身份删除\"> 删除</a>";
		}
	}
	$func_link_str = $public_func.$func_link_str;
	$run_name_str_title = "";
	if ( $flow_type == 1 )
	{
		$sqlmaxpid = "SELECT MAX(PRCS_ID) AS pid FROM flow_run_prcs WHERE RUN_ID=".$run_id;
		$resmaxpid = exequery( $connection, $sqlmaxpid );
		$rowmaxpid = mysql_fetch_array( $resmaxpid );
		$prcs_id_max = $rowmaxpid['pid'];
		$sqlcurrent = "SELECT USER_ID,FLOW_PRCS,IS_REMIND,LIMIT_DATE FROM flow_run_prcs WHERE PRCS_ID=".$prcs_id_max." AND RUN_ID=".$run_id." AND OP_FLAG=1";
		$rescurrent = exequery( $connection, $sqlcurrent );
		$rowcurrent = mysql_fetch_array( $rescurrent );
		$current_op_user_id = $rowcurrent['USER_ID'];
		$current_flow_prcs = $rowcurrent['FLOW_PRCS'];
		$current_is_remind = $rowcurrent['IS_REMIND'];
		$current_limit_date_tmp = $rowcurrent['LIMIT_DATE'];
		$current_limit_date = date( "Y-m-d", strtotime( $rowcurrent['LIMIT_DATE'] ) );
		$current_op_user_name = $userarray[$current_op_user_id]['username'];
		$sqlconcourse = "SELECT PRCS_CONCOURSE,PRCS_NAME FROM flow_process WHERE FLOW_ID=".$flow_id." AND PRCS_ID=".$current_flow_prcs;
		$resconcourse = exequery( $connection, $sqlconcourse );
		$rowconcourse = mysql_fetch_array( $resconcourse );
		$current_concourse = $rowconcourse['PRCS_CONCOURSE'];
		$current_prcs_name = $rowconcourse['PRCS_NAME'];
		$run_name_str_title .= "当前节点:".$current_prcs_name;
		if ( $current_is_remind == 0 && $current_limit_date_tmp != "0000-00-00 00:00:00" )
		{
			$run_name_str_title .= "\r\n催促办理时间：".$current_limit_date;
		}
		if ( $current_concourse == 1 )
		{
			$run_name_str_title .= "\r\n当前节点需要会签";
		}
	}
	$flow_name_str_title = $sort_name."\r\n".$flow_type_str."\r\n".$flow_step_str;
	$create_user_name_title = "部门：".$userarray[$create_user_id]['dept']." \r\n角色：".$userarray[$create_user_id]['priv'];
	if ( $run_count % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "  \r\n\r\n  <tr class=\"";
	echo $TableLine;
	echo "\">\r\n    <td nowrap>";
	if ( $is_link_run_name == 1 )
	{
		echo " <a href=\"";
		echo $run_name_link_str;
		echo "\" title=\"";
		echo $flow_name_str_title;
		echo "\">";
		echo $flow_name_str;
		echo "</a>  ";
	}
	else
	{
		echo "<s";
		echo "pan title=\"";
		echo $flow_name_str_title;
		echo "\"> ";
		echo $flow_name_str;
		echo " </span> ";
	}
	echo "</td>\r\n    <td>";
	if ( $is_link_run_name == 1 )
	{
		echo " <a href=\"";
		echo $run_name_link_str;
		echo "\" title=\"";
		echo $run_name_str_title;
		echo "\">";
		echo $run_name_str;
		echo "</a>  ";
	}
	else
	{
		echo "<s";
		echo "pan title=\"";
		echo $run_name_str_title;
		echo "\"> ";
		echo $run_name_str;
		echo " </span> ";
	}
	echo "</td>\r\n    <td width=\"18%\">";
	echo $func_link_str;
	echo "    <td nowrap >";
	echo "<s";
	echo "pan title=\"";
	echo $create_user_name_title;
	echo "\">";
	echo $create_user_name;
	echo "</span></td>\r\n    <td nowrap >";
	echo $create_time;
	echo "</td>\r\n    <td nowrap >";
	echo $status_str;
	echo "</td>\r\n  </tr>\r\n  ";
}
echo "</table>\r\n<table width=\"100%\"  border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n  <tr class=\"TableLine2\">\r\n    <td align=\"right\">";
disp( "keyword=".$_REQUEST['keyword']."&sens=".$_REQUEST['sens']."&orderbyname=".$_REQUEST['orderbyname']."&orderbydesc=".$_REQUEST['orderbydesc'] );
echo "</td>\r\n    <td width=\"2%\" align=\"right\">&nbsp;</td>\r\n  </tr>\r\n</table>\r\n</body>\r\n</html>\r\n";
echo "<s";
echo "cript>\r\nfunction openWindows(url,width,height){\r\n  window.open(url,'','status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,width='+width+',height='+height);\r\n}\r\nfunction call_back(RUN_ID,PRCS_ID)\r\n{\r\n  msg='下一步骤尚未接收办理，确认要收回至本步骤重新办理么？';\r\n  if(window.confirm(msg))\r\n  {\r\n    url=\"/general/workflow/call_back.php?RUN_ID=\"+RUN_ID+\"&PRCS_ID=\"+PRCS_ID;\r\n    lo";
echo "cation=url;\r\n  }\r\n}\r\nfunction delete_run(RUN_ID)\r\n{\r\n  msg='确认要删除该工作流程么？';\r\n  if(window.confirm(msg))\r\n  {\r\n    url=\"/general/workflow/delete.php?OP=MANAGE&RUN_ID=\"+RUN_ID;\r\n    location=url;\r\n  }\r\n}\r\nfunction stop_run(RUN_ID,FLOW_ID,PRCS_ID)\r\n{\r\n  msg='确认要终止该工作流程么？';\r\n  if(window.confirm(msg))\r\n  {\r\n    url=\"/general/workflow/stop.php?OP=MANAGE&RUN_ID=\"+RUN_ID+\"&FLOW_ID=\"+";
echo "FLOW_ID+\"&PRCS_ID=\"+PRCS_ID;\r\n    location=url;\r\n  }\r\n}\r\n</script>\r\n";
if ( 0 < ( $n = $_REQUEST['cur_page'] - $total_page_nums ) )
{
	$cur_page = $_REQUEST['cur_page'] - $n;
	header( "location:".$_SERVER['PHP_SELF']."?&keyword=".$_REQUEST['keyword']."&order=".$_REQUEST['order']."&sens=".$_REQUEST['sens']."&cur_page=".$cur_page );
}
?>