📄 search_flow.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?php

function flowlinksssfunc( $flow_type, $type )
{
	switch ( $type )
	{
	case "form" :
		$link = $flow_type == 1 ? "/general/workflow/print/" : "/general/workflow/print/";
		break;
	case "chart" :
		$link = $flow_type == 1 ? "/general/workflow/flow_view.php" : "/general/workflow/free_flow_view.php";
		break;
	case "transact" :
		$link = $flow_type == 1 ? "/general/workflow/input_form/" : "/general/workflow/input_form/";
		break;
	case "turnnext" :
		$link = $flow_type == 1 ? "/general/workflow/turn/turn_next.php" : "/general/workflow/turn/turn_next_free.php";
		break;
	case "cancel" :
		$link = $flow_type == 1 ? "" : "";
		break;
	case "entrust" :
		$link = $flow_type == 1 ? "/general/workflow/others/others.php" : "/general/workflow/others/others_free.php";
		break;
	case "end" :
		$link = $flow_type == 1 ? "" : "";
	}
	return $link;
}

include_once( "inc/auth.php" );
include_once( "inc/function_page_01.php" );
include_once( "ikernel/utility.php" );
include_once( "inc/utility_all.php" );
if ( $_REQUEST['cur_page'] == "" )
{
	$cur_page = 1;
}
else
{
	$cur_page = $_REQUEST['cur_page'];
}
$page_purview = 2;
echo "\r\n<html>\r\n<head>\r\n<title>工作流程 - 查询结果</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n\r\n";
echo "<s";
echo "tyle type=\"text/css\">\r\n\r\n</style></head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
$SAFE_CHECK_OK = 0;
if ( find_id( $USER_FUNC_ID_STR, $page_purview ) )
{
	$SAFE_CHECK_OK = 1;
}
if ( $SAFE_CHECK_OK == 0 )
{
	message( "警告", "无该模块使用权限！如需使用该模块，请联系管理员重新设置本角色权限！" );
	exit( );
}
echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\" class=\"small\">\r\n  <tr>\r\n    <td class=\"tablehead1\"><img src=\"/images/menu/inbox.gif\" align=\"absmiddle\"> 工作流程 -  查询结果</td>\r\n\r\n\r\n\t</tr>\r\n  <tr class=\"tablehead2\">\r\n    <td>&nbsp;</td>\r\n  </tr>\r\n\r\n</table>\r\n<br>\r\n\r\n\r\n<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" cellpadding=\"5\">\r\n  <tr class=\"TableHeader\">\r\n    ";
$sens = $_REQUEST['sens'] ? 0 : 1;
$sensimg = $_REQUEST['sens'] ? "arrow_up.gif" : "arrow_down.gif";
$sensimg = "/images/".$sensimg;
$sufurl = $_SERVER['PHP_SELF']."?sens=".$sens."&keyword=".$_REQUEST['keyword'];
echo "    \r\n  \r\n    <td width=\"12%\" nowrap ><a href=\"";
echo $sufurl;
echo "&order=flowname\">流程名称</a> ";
if ( $_REQUEST['order'] == "flowname" )
{
	echo "<img src='".$sensimg."'>";
}
echo "</td>\r\n    <td width=\"25%\" nowrap ><a href=\"";
echo $sufurl;
echo "&order=runname\">文号/说明</a> ";
if ( $_REQUEST['order'] == "runname" )
{
	echo "<img src='".$sensimg."'>";
}
echo "</td>\r\n    <td nowrap >操作</td>\r\n    <td width=\"10%\" nowrap >创建人</td>\r\n    <td width=\"15%\" nowrap >流程开始时间</td>\r\n    <td width=\"5%\" nowrap >状态</td>\r\n  </tr>\r\n  ";
$sql = "   \r\n         SELECT u.USER_ID,u.USER_NAME,up.PRIV_NAME,d.DEPT_NAME FROM user u,user_priv up,department d\r\n\t\t     WHERE 1 \r\n\t\t\t  AND u.USER_PRIV=up.USER_PRIV \r\n\t\t\t  AND u.DEPT_ID=d.DEPT_ID\r\n\t\t\t    ORDER BY u.USER_ID DESC ";
$res = exequery( $connection, $sql );
while ( $row = mysql_fetch_array( $res ) )
{
	$userarray[$row['USER_ID']]['username'] = $row['USER_NAME'];
	$userarray[$row['USER_ID']]['priv'] = $row['PRIV_NAME'];
	$userarray[$row['USER_ID']]['dept'] = $row['DEPT_NAME'];
}
$sql = "SELECT FLOW_ID,FLOW_NAME FROM FLOW_TYPE";
$res = exequery( $connection, $sql );
while ( $row = mysql_fetch_array( $res ) )
{
	$arrayflow[$row['FLOW_ID']] = $row['FLOW_NAME'];
}
$sql = "SELECT RUN_ID,RUN_NAME FROM flow_run";
$res = exequery( $connection, $sql );
while ( $row = mysql_fetch_array( $res ) )
{
	$arrayrun[$row['RUN_ID']] = $row['RUN_NAME'];
}
$sql = "\r\n        SELECT frp.*,ft.FLOW_NAME,fr.RUN_NAME,ft.FLOW_ID,ft.FLOW_SORT,ft.FLOW_TYPE\r\n\t\tFROM FLOW_TYPE ft,FLOW_RUN fr,FLOW_RUN_PRCS frp\r\n\t\t    WHERE 1\r\n\t\t\t   AND ft.FLOW_ID=fr.FLOW_ID\r\n\t\t\t   AND fr.RUN_ID=frp.RUN_ID \r\n\t\t\t   AND (frp.USER_ID LIKE '".$_SESSION['LOGIN_USER_ID']."' \r\n\t\t\t        OR ft.MANAGE_USER LIKE '%".$_SESSION['LOGIN_USER_ID'].",%'\r\n\t\t\t   \r\n\t\t\t   )\r\n       ";
if ( $_REQUEST['keyword'] != "" )
{
	$sql .= " \r\n\t\t\t AND (ft.FLOW_NAME LIKE '%".$_REQUEST['keyword']."%' \r\n\t\t\t      OR fr.RUN_NAME LIKE '%".$_REQUEST['keyword']."%' \r\n\t\t )\r\n\t ";
}
$sql .= "GROUP BY frp.RUN_ID ";
switch ( $_REQUEST['order'] )
{
case "flowname" :
	$sql .= "ORDER BY ft.FLOW_NAME ";
	break;
case "runmame" :
	$sql .= "ORDER BY fr.RUN_NAME ";
	break;
default :
	$sql .= "ORDER BY fr.RUN_NAME ";
}
$sql .= $_REQUEST['sens'] ? " ASC" : " DESC";
$sql = page( $sql, 12 );
$res = exequery( $connection, $sql );
$run_count = 0;
$run_flow_transact_count = 0;
$run_flow_manage_count = 0;
$run_flow_end_count = 0;
while ( $row = mysql_fetch_array( $res ) )
{
	++$run_count;
	$flow_name = $row['FLOW_NAME'];
	if ( $_REQUEST['keyword'] != "" )
	{
		$flow_name_str = replacestr( substrgb( strip_tags( $row['FLOW_NAME'] ), 40, "..." ), "red", $_REQUEST['keyword'] );
		$run_name_str = replacestr( substrgb( strip_tags( $row['RUN_NAME'] ), 40, "..." ), "red", $_REQUEST['keyword'] );
	}
	else
	{
		$flow_name_str = substrgb( strip_tags( $row['FLOW_NAME'] ), 40, "..." );
		$run_name_str = substrgb( strip_tags( $row['RUN_NAME'] ), 40, "..." );
	}
	$run_id = $row['RUN_ID'];
	$flow_id = $row['FLOW_ID'];
	$sort_id = $row['FLOW_SORT'];
	$sqlsort = "SELECT TITLE FROM FLOW_SORT WHERE ID=".$sort_id;
	$ressort = exequery( $connection, $sqlsort );
	$rowsort = mysql_fetch_array( $ressort );
	$sort_name = $rowsort['TITLE'];
	$sqlcrus = "\r\n\t            SELECT USER_ID,PRCS_ID,PRCS_TIME,LIMIT_DATE,IS_REMIND FROM flow_run_prcs \r\n\t\t\t\t    WHERE RUN_ID=".$run_id." \r\n\t\t\t\t\t    AND PRCS_ID=1\r\n\t           ";
	$resrus = exequery( $connection, $sqlcrus );
	$rowrus = mysql_fetch_array( $resrus );
	$create_user_id = $rowrus['USER_ID'];
	$create_user_name = $userarray[$create_user_id]['username'];
	$create_time = $rowrus['PRCS_TIME'];
	if ( $rowrus['IS_REMIND'] == 1 )
	{
		$remin_str = "限时办理";
		$remin_time = date( "Y-m-d", $rowrus['LIMIT_DATE'] );
	}
	$sqlfis = "\r\n\t            SELECT COUNT(*) AS cnt FROM flow_run_prcs \r\n\t\t\t\t   WHERE RUN_ID=".$run_id." \r\n\t\t\t\t      AND PRCS_FLAG<>'4'\r\n\t           ";
	$resfis = exequery( $connection, $sqlfis );
	$rowfis = mysql_fetch_array( $resfis );
	$is_over = $rowfis['cnt'] ? false : true;
	$status_str = $rowfis['cnt'] ? "执行中" : "已结束";
	$flow_type = $row['FLOW_TYPE'];
	$flow_type_str = $flow_type == 1 ? "固定流程" : "自由流程";
	unset( $flow_step_str );
	if ( $flow_type == 1 )
	{
		$sqlfwst = "\r\n\t\t           SELECT ID,PRCS_ID,PRCS_NAME FROM flow_process \r\n\t\t\t\t       WHERE FLOW_ID=".$flow_id." \r\n\t\t\t\t\t     ORDER BY ID ASC\r\n\t\t           ";
		$resfwst = exequery( $connection, $sqlfwst );
		while ( $rowfwst = mysql_fetch_array( $resfwst ) )
		{
			$flow_step_str .= "".$rowfwst['PRCS_ID']." : ".$rowfwst['PRCS_NAME']." \r\n";
		}
	}
	$public_func = "<a style=\"cursor:hand;color:#0000FF\" onclick=\"openWindows('".flowlinksssfunc( $flow_type, "form" )."?RUN_ID=".$run_id."&FLOW_ID=".$flow_id."',600,500)\"> 表单</a>";
	$public_func .= "<a style=\"cursor:hand;color:#0000FF\" onclick=\"openWindows('".flowlinksssfunc( $flow_type, "chart" )."?RUN_ID=".$run_id."&FLOW_ID=".$flow_id."',600,500)\"> 流程图</a>";
	$is_link_run_name = 0;
12 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -