📄 getdata.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "../prcs_role.php" );
while ( list( $k, $v ) = each( &$GLOBALS['_GET'] ) )
{
$$k = iconv( "UTF-8", "GBK", $v );
}
while ( list( $k, $v ) = each( &$GLOBALS['_POST'] ) )
{
$$k = iconv( "UTF-8", "GBK", $v );
}
ob_clean( );
$MY_DEPT_STR = getmydept( );
if ( $act == "count" )
{
$query = "SELECT count(*),TOP_FLAG from FLOW_RUN_PRCS,FLOW_RUN,FLOW_TYPE,USER WHERE FLOW_TYPE.FLOW_ID=FLOW_RUN.FLOW_ID AND FLOW_RUN.BEGIN_USER=USER.USER_ID AND FLOW_RUN_PRCS.RUN_ID=FLOW_RUN.RUN_ID and FLOW_RUN.DEL_FLAG=0 and ( FIND_IN_SET('".$LOGIN_USER_ID."',MANAGE_USER) OR (USER.DEPT_ID IN ({$MY_DEPT_STR}) AND FIND_IN_SET('{$LOGIN_USER_ID}',MANAGE_USER_DEPT))) and PRCS_FLAG in('1','2') and (OP_FLAG=1 or TOP_FLAG=2)";
}
else
{
$query = "SELECT FLOW_RUN_PRCS.RUN_ID,PRCS_ID,FLOW_RUN_PRCS.USER_ID,PRCS_FLAG,PRCS_TIME,FLOW_PRCS from FLOW_RUN_PRCS,FLOW_RUN,FLOW_TYPE,USER WHERE FLOW_TYPE.FLOW_ID=FLOW_RUN.FLOW_ID AND FLOW_RUN.BEGIN_USER=USER.USER_ID AND FLOW_RUN_PRCS.RUN_ID=FLOW_RUN.RUN_ID and FLOW_RUN.DEL_FLAG=0 and (FIND_IN_SET('".$LOGIN_USER_ID."',MANAGE_USER) OR (USER.DEPT_ID IN ({$MY_DEPT_STR}) AND FIND_IN_SET('{$LOGIN_USER_ID}',MANAGE_USER_DEPT))) and PRCS_FLAG in('1','2') and (OP_FLAG=1 or TOP_FLAG=2)";
}
if ( $FLOW_ID != "ALL" )
{
$query .= " and FLOW_RUN.FLOW_ID='".$FLOW_ID."'";
}
if ( $RUN_ID != "" )
{
$query .= " and FLOW_RUN.RUN_ID='".$RUN_ID."'";
}
if ( $RUN_NAME != "" )
{
$query .= " and FLOW_RUN.RUN_NAME like '%".$RUN_NAME."%'";
}
if ( $TO_ID != "" )
{
if ( $USER_TYPE == 0 )
{
$query .= " and FLOW_RUN_PRCS.USER_ID='".$TO_ID."'";
}
else
{
$query .= " and FLOW_RUN.BEGIN_USER='".$TO_ID."'";
}
}
$query .= " group by FLOW_RUN_PRCS.RUN_ID,PRCS_ID,FLOW_PRCS ";
if ( $act == "count" )
{
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
if ( $ROW[1] == 2 )
{
++$FLOW_COUNT;
}
else
{
$FLOW_COUNT += $ROW[0];
}
}
echo $FLOW_COUNT;
exit( );
}
if ( $ORDER_FIELD == "" )
{
$ORDER_FIELD = "RUN_ID";
$ORDER_TYPE = "DESC";
}
$query .= " order by ".$ORDER_FIELD." ".$ORDER_TYPE;
$limit = $endrecord - $startrecord + 1;
$start = $startrecord - 1;
$query .= " limit ".$start.",{$limit}";
$cursor = exequery( $connection, $query );
$FLOW_COUNT = 0;
$TOP_RUN_STR = "";
$USER_ARRAY = array( );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$RUN_ID = $ROW['RUN_ID'];
$PRCS_ID = $ROW['PRCS_ID'];
$USER_ID = $ROW['USER_ID'];
$PRCS_FLAG = $ROW['PRCS_FLAG'];
$PRCS_TIME = $ROW['PRCS_TIME'];
$FLOW_PRCS = $ROW['FLOW_PRCS'];
$query = "SELECT FLOW_TYPE.FLOW_ID,FLOW_TYPE.FREE_OTHER,RUN_NAME,FLOW_NAME,FLOW_TYPE,FLOW_SORT from FLOW_TYPE,FLOW_RUN WHERE FLOW_TYPE.FLOW_ID=FLOW_RUN.FLOW_ID and RUN_ID='".$RUN_ID."' limit 1";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FLOW_ID1 = $ROW['FLOW_ID'];
$FREE_OTHER = $ROW['FREE_OTHER'];
$RUN_NAME = $ROW['RUN_NAME'];
$FLOW_NAME = $ROW['FLOW_NAME'];
$FLOW_TYPE = $ROW['FLOW_TYPE'];
$FLOW_SORT = $ROW['FLOW_SORT'];
if ( $FLOW_TYPE == "1" )
{
$FLOW_TYPE_DESC = "固定流程";
}
else
{
$FLOW_TYPE_DESC = "自由流程";
}
}
++$FLOW_COUNT;
if ( array_key_exists( $USER_ID, $USER_ARRAY ) )
{
$USER_NAME = $USER_ARRAY["{$USER_ID}"];
}
else
{
$query = "SELECT USER_NAME from USER WHERE USER_ID='".$USER_ID."' limit 1";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$USER_NAME = $ROW['USER_NAME'];
}
else
{
$USER_NAME = $USER_ID;
}
$USER_ARRAY["{$USER_ID}"] = $USER_NAME;
}
if ( $FLOW_TYPE == "1" )
{
$query = "SELECT PRCS_NAME,TIME_OUT from FLOW_PROCESS WHERE FLOW_ID=".$FLOW_ID1." AND PRCS_ID={$FLOW_PRCS} limit 1";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$PRCS_NAME = "第".$PRCS_ID."步：".$ROW['PRCS_NAME'];
$TIME_OUT = $ROW['TIME_OUT'];
}
}
else
{
$PRCS_NAME = "第".$PRCS_ID."步";
}
if ( $PRCS_FLAG == "1" )
{
$STATUS = "<img src='/images/email_close.gif' alt='未接收'>";
}
else if ( $PRCS_FLAG == "2" )
{
$STATUS = "<img src='/images/email_open.gif' alt='已接收'>";
}
else
{
$STATUS = "<img src='/images/flow_next.gif' alt='已办结'>";
}
if ( $FLOW_COUNT == 1 )
{
echo "<table id=\"flow_table\" width=\"100%\" class=\"TableList\">\r\n <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\"><a href=\"#\">状态</a></td>\r\n <td nowrap align=\"center\"><a href=\"#\">流水号</a></td>\r\n <td nowrap align=\"center\"><a href=\"#\">流程名称</a></td>\r\n <td nowrap align=\"center\"><a href=\"#\">工作名称/文号</a></td>\r\n <td nowrap align=\"center\"><a href=\"#\">当前步骤</a></td>\r\n <td nowrap align=\"center\"><a href=\"#\">当前主办人</a></td>\r\n <td nowrap align=\"center\"><a href=\"#\">办理时间</a></td>\r\n <td nowrap align=\"center\"><b>操作</b></td>\r\n </tr>\r\n";
}
if ( $FLOW_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr id=\"";
echo $RUN_ID;
echo "\" class=\"";
echo $TableLine;
echo "\">\r\n <td align=\"center\" nowrap>";
echo $STATUS;
echo "</td>\r\n <td align=\"center\" nowrap><b>";
echo $RUN_ID;
echo "</b></td>\r\n <td><a title=\"流程类型：";
echo $FLOW_TYPE_DESC;
echo "\" href=\"javascript:view_graph(";
echo $FLOW_ID1;
echo ");\">";
echo $FLOW_NAME;
echo "</a></td>\r\n <td><a href=\"javascript:form_view(";
echo $RUN_ID;
echo ",";
echo $FLOW_ID1;
echo ");\">";
echo $RUN_NAME;
echo "</a></td>\r\n <td><a href=\"javascript:flow_view(";
echo $RUN_ID;
echo ",";
echo $FLOW_ID1;
echo ")\">";
echo $PRCS_NAME;
echo "</a></td>\r\n <td align=\"center\" nowrap><a href=\"javascript:user_view('";
echo $USER_ID;
echo "')\">";
echo $USER_NAME;
echo "</td>\r\n\r\n";
if ( $PRCS_FLAG == 1 )
{
$PRE_PRCS_ID = $PRCS_ID - 1;
$query1 = "select DELIVER_TIME from FLOW_RUN_PRCS WHERE RUN_ID='".$RUN_ID."' AND PRCS_ID='{$PRE_PRCS_ID}'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$PRCS_BEGIN_TIME = $ROW1['DELIVER_TIME'];
}
}
else
{
$PRCS_BEGIN_TIME = $PRCS_TIME;
}
if ( $PRCS_BEGIN_TIME == "0000-00-00 00:00:00" || $PRCS_BEGIN_TIME == "" )
{
$PRCS_BEGIN_TIME = date( "Y-m-d H:i:s", time( ) );
}
$TIME_USED = time( ) - strtotime( $PRCS_BEGIN_TIME );
$DAY = floor( $TIME_USED / 86400 );
$HOUR = floor( $TIME_USED % 86400 / 3600 );
$MIN = floor( $TIME_USED % 3600 / 60 );
$SEC = floor( $TIME_USED % 60 );
$TIME_STR = "";
if ( 0 < $DAY )
{
$TIME_STR .= $DAY."天";
}
if ( 0 < $HOUR )
{
$TIME_STR .= $HOUR."时";
}
if ( 0 < $MIN )
{
$TIME_STR .= $MIN."分";
}
if ( 0 < $SEC )
{
$TIME_STR .= $SEC."秒";
}
if ( $PRCS_FLAG == 1 )
{
$TIME_STR = "接收延迟".$TIME_STR;
}
else
{
$TIME_STR = "用时".$TIME_STR;
}
if ( 30 < $DAY )
{
$DAY = 30;
}
$WIDTH = ( $DAY + 1 ) * 4;
$IMG = 1;
$TIME_OUT_FLAG = 0;
if ( $TIME_OUT != "" && $TIME_OUT * 3600 < $TIME_USED )
{
$TIME_OUT_FLAG = 1;
$TIME_USED -= $TIME_OUT * 3600;
$DAY = floor( $TIME_USED / 86400 );
$HOUR = floor( $TIME_USED % 86400 / 3600 );
$MIN = floor( $TIME_USED % 3600 / 60 );
$SEC = floor( $TIME_USED % 60 );
$TIME_USED = "";
if ( 0 < $DAY )
{
$TIME_USED .= $DAY."天";
}
if ( 0 < $HOUR )
{
$TIME_USED .= $HOUR."时";
}
if ( 0 < $MIN )
{
$TIME_USED .= $MIN."分";
}
if ( 0 < $SEC )
{
$TIME_USED .= $SEC."秒";
}
$IMG = 2;
$TIME_STR = "时限".$TIME_OUT."小时,".$TIME_STR.",超时".$TIME_USED;
if ( $USER_NAME != "" && !find_id( $TIME_TO_ID, $USER_ID ) )
{
$TIME_TO_ID .= $USER_ID.",";
$TIME_TO_NAME .= $USER_NAME.",";
}
}
if ( $PRCS_TIME == "" )
{
echo "<td title=";
echo $TIME_STR;
echo "><img src='/images/email_close.gif' alt='未接收'><br>";
}
else
{
echo "<td title=";
echo $TIME_STR;
echo ">";
echo $PRCS_TIME;
echo "<br>";
}
if ( $TIME_OUT_FLAG )
{
echo "<font color=red>超时".$TIME_USED."</font><br>";
}
echo "<img src=/images/flow_time";
echo $IMG;
echo ".gif width=";
echo $WIDTH;
echo " height=6></td> <td nowrap>\r\n <a href=\"../list/turn/";
if ( $FLOW_TYPE == "1" )
{
echo "turn_next";
}
else
{
echo "turn_next_free";
}
echo ".php?OP=MANAGE&RUN_ID=";
echo $RUN_ID;
echo "&FLOW_ID=";
echo $FLOW_ID1;
echo "&PRCS_ID=";
echo $PRCS_ID;
echo "&MENU_FLAG=";
echo $MENU_FLAG;
echo "&FLOW_PRCS=";
echo $FLOW_PRCS;
echo "\" title=\"转交下一步骤\"><img src=\"/images/flow_next.gif\" border=\"0\"> 转交下步</a>\r\n <a href=\"javascript:stop_run(";
echo $RUN_ID;
echo ",";
echo $FLOW_ID1;
echo ",";
echo $PRCS_ID;
echo ",";
echo $FLOW_TYPE;
echo ");\">结束</a>\r\n";
if ( $FREE_OTHER != 0 )
{
echo " <a href=\"javascript:others('";
echo $FLOW_ID1;
echo "','";
echo $RUN_ID;
echo "','";
echo $PRCS_ID;
echo "','";
echo $FLOW_PRCS;
echo "','";
echo $FLOW_TYPE;
echo "');\" title=\"将工作委托其他人办理\">委托</a>\r\n";
}
echo " <a href=\"javascript:delete_run(";
echo $RUN_ID;
echo ");\">删除</a>\r\n </td>\r\n </tr>\r\n";
}
if ( 0 < $FLOW_COUNT )
{
echo " </table>\r\n <input type=\"hidden\" value=\"";
echo $TIME_TO_ID;
echo "\" id=\"TIME_TO_ID\">\r\n";
}
else
{
message( "提示", "所选流程暂无可以监控的工作" );
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -