📄 getdata.php
字号:
<?php
include_once( "inc/auth.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( );
$query = "SELECT \r\n a.RUN_ID,a.PRCS_ID,a.FLOW_PRCS,a.PRCS_FLAG,a.OP_FLAG,a.PRCS_TIME,\r\n b.FREE_OTHER, b.FLOW_ID,b.FLOW_NAME,b.FLOW_TYPE,\r\n c.RUN_NAME, c.BEGIN_USER, c.END_TIME\r\n from FLOW_RUN_PRCS AS a, FLOW_TYPE AS b, FLOW_RUN AS c \r\n WHERE a.RUN_ID=c.RUN_ID and c.FLOW_ID=b.FLOW_ID and c.DEL_FLAG='0' AND a.CHILD_RUN=0 and a.USER_ID='".$LOGIN_USER_ID."'";
if ( $TYPE )
{
$query .= " and PRCS_FLAG IN(".$TYPE.")";
}
if ( $OP_FLAG != "" )
{
$query .= " and OP_FLAG='".$OP_FLAG."'";
}
if ( $FLOW_ID != 0 )
{
$query .= " and b.FLOW_ID=".$FLOW_ID;
$FLOW_ID_GLOBAL = $FLOW_ID;
}
if ( $RUN_ID )
{
$query .= " and a.RUN_ID=".$RUN_ID;
}
if ( $RUN_NAME )
{
$query .= " and c.RUN_NAME LIKE '%".$RUN_NAME."%'";
}
if ( $TYPE == "3,4" )
{
$query .= " GROUP BY a.RUN_ID";
}
$query .= " order by a.RUN_ID DESC,PRCS_TIME DESC";
if ( !$RUN_ID || !$RUN_NAME )
{
$limit = $endrecord - $startrecord + 1;
$start = $startrecord - 1;
$query .= " limit ".$start.",{$limit}";
}
$cursor = exequery( $connection, $query );
$FLOW_COUNT = 0;
$USER_ARRAY = array( );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$FLOW_COUNT;
$RUN_ID = $ROW['RUN_ID'];
$PRCS_ID = $ROW['PRCS_ID'];
$FLOW_PRCS = $ROW['FLOW_PRCS'];
$PRCS_FLAG = $ROW['PRCS_FLAG'];
$OP_FLAG = $ROW['OP_FLAG'];
$FLOW_ID = $ROW['FLOW_ID'];
$RUN_NAME = $ROW['RUN_NAME'];
$PRCS_TIME = $ROW['PRCS_TIME'];
$FREE_OTHER = $ROW['FREE_OTHER'];
$FIRST_USER_ID = $ROW['BEGIN_USER'];
$END_TIME = $ROW['END_TIME'];
if ( $TYPE == "3,4" )
{
$query1 = "select * from FLOW_RUN_PRCS WHERE RUN_ID='".$RUN_ID."' AND USER_ID='{$LOGIN_USER_ID}' AND PRCS_FLAG IN ({$TYPE}) ORDER BY PRCS_ID DESC limit 1";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$PRCS_ID = $ROW1['PRCS_ID'];
$FLOW_PRCS = $ROW1['FLOW_PRCS'];
$OP_FLAG = $ROW1['OP_FLAG'];
$PRCS_FLAG = $ROW1['PRCS_FLAG'];
}
if ( $END_TIME )
{
$RUN_STATUS = "<font color=red>已结束</font>";
}
else
{
$RUN_STATUS = "<font color=green>执行中</font>";
}
}
if ( $OP_FLAG )
{
$OP_FLAG_DESC = "主办";
}
else
{
$OP_FLAG_DESC = "会签";
}
$FLOW_NAME = $ROW['FLOW_NAME'];
$FLOW_TYPE = $ROW['FLOW_TYPE'];
if ( $FLOW_TYPE == "1" )
{
$FLOW_TYPE_DESC = "固定流程";
}
else
{
$FLOW_TYPE_DESC = "自由流程";
}
if ( array_key_exists( $FIRST_USER_ID, $USER_ARRAY ) )
{
$FIRST_USER_NAME = $USER_ARRAY["{$FIRST_USER_ID}"];
}
else
{
$query = "SELECT USER_NAME from USER WHERE USER_ID='".$FIRST_USER_ID."'";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FIRST_USER_NAME = $ROW['USER_NAME'];
}
$USER_ARRAY["{$FIRST_USER_ID}"] = $FIRST_USER_NAME;
}
if ( $FLOW_TYPE == "1" )
{
$query = "SELECT PRCS_NAME,TIME_OUT from FLOW_PROCESS WHERE FLOW_ID=".$FLOW_ID." 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."步";
$TIME_OUT = "";
}
$TIME_OUT_FLAG = 0;
if ( ( $PRCS_FLAG == "2" || $PRCS_FLAG == "1" ) && $TIME_OUT != "" )
{
if ( $PRCS_FLAG == 1 && $PRCS_ID != 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 ? $PRCS_TIME : date( "Y-m-d H:i:s", time( ) );
}
$TIME_USED = time( ) - strtotime( $PRCS_BEGIN_TIME );
if ( $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."秒";
}
}
}
if ( $FLOW_COUNT % 2 == 0 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
if ( $TIME_OUT_FLAG )
{
$TableLine .= " TableRed";
}
if ( $TYPE == "3,4" )
{
if ( $OP_FLAG == 1 )
{
$OP_FLAG_INFO = "<span style=\"color:red\">(".$OP_FLAG_DESC.")</span>";
}
else
{
$OP_FLAG_INFO = "(".$OP_FLAG_DESC.")";
}
}
echo " \r\n <tr id=\"";
echo $RUN_ID;
echo "\" class=\"";
if ( $TIME_OUT_FLAG )
{
echo "TableRed";
}
else
{
echo $TableLine;
}
echo "\">\r\n \t<td nowrap align=\"center\"><b>";
echo $RUN_ID;
echo "</b></td>\r\n <td><a title=\"流程类型：";
echo $FLOW_TYPE_DESC;
echo "\" ";
if ( $FLOW_TYPE == 1 )
{
echo "href=\"javascript:view_graph(";
echo $FLOW_ID;
echo ");\"";
}
echo ">";
echo $FLOW_NAME;
echo "</a></td>\r\n <td><a href=\"javascript:form_view(";
echo $RUN_ID;
echo ",";
echo $FLOW_ID;
echo ");\">";
echo $RUN_NAME;
echo "</a></td>\r\n <td nowrap align=\"center\"><a href=\"javascript:user_view('";
echo $FIRST_USER_ID;
echo "');\">";
echo $FIRST_USER_NAME;
echo "</a></td>\r\n <td><a href=\"javascript:flow_view(";
echo $RUN_ID;
echo ",";
echo $FLOW_ID;
echo ")\">";
echo $OP_FLAG_INFO;
echo " ";
echo $PRCS_NAME;
if ( $FLOW_TYPE == 2 )
{
echo "-自由流程";
}
echo "</a>\r\n";
if ( $TIME_OUT_FLAG )
{
echo " <br><font color=red>超时";
echo $TIME_USED;
echo "</font>\r\n";
}
echo " </td>\r\n";
if ( $TYPE == "3,4" )
{
echo " <td nowrap align=\"center\">";
echo $RUN_STATUS;
echo "</td>\r\n";
}
echo " <td nowrap>\r\n";
if ( $PRCS_FLAG == "1" || $PRCS_FLAG == "2" )
{
echo " <a href=\"#\" onclick=\"parent.location='input_form?MENU_FLAG=";
echo $MENU_FLAG;
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 "'\" title=\"";
if ( $OP_FLAG )
{
echo "作为主办人办理工作，填写表单和会签意见";
}
else
{
echo "作为经办人办理工作，填写会签意见";
}
echo "\">\r\n \t<img src=\"/images/edit.gif\" align=absmiddle border=\"0\"><b>";
echo $OP_FLAG_DESC;
echo "</b></a> \r\n";
if ( !( $FREE_OTHER == 1 ) && $OP_FLAG || $FREE_OTHER == 2 || $FREE_OTHER == 3 )
{
echo " <a href=\"#\" onclick=\"javascript:others('";
echo $FLOW_ID;
echo "','";
echo $RUN_ID;
echo "','";
echo $PRCS_ID;
echo "','";
echo $FLOW_PRCS;
echo "','";
echo $FLOW_TYPE;
echo "');\" title=\"将工作委托其他人办理\">委托</a>\r\n";
}
}
else if ( $OP_FLAG && $PRCS_FLAG == 3 && $END_TIME == "" )
{
echo " <a href=\"javascript:call_back(";
echo $RUN_ID;
echo ",";
echo $PRCS_ID;
echo ",";
echo $FLOW_PRCS;
echo ");\" title=\"收回已经转交下一步骤的工作\">收回</a>\r\n";
}
if ( $PRCS_FLAG == "2" )
{
if ( $FLOW_TYPE == "1" )
{
if ( $OP_FLAG )
{
echo " <a href=\"#\" onclick=\"parent.location='turn/turn_next.php?MENU_FLAG=";
echo $MENU_FLAG;
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 "'\" title=\"转交工作至下一步骤\">\r\n \t<img src=\"/images/flow_next.gif\" border=\"0\">转交</a>\r\n";
}
}
else if ( $OP_FLAG )
{
echo " <a href=\"#\" onclick=\"parent.location='turn/turn_next_free.php?MENU_FLAG=";
echo $MENU_FLAG;
echo "&RUN_ID=";
echo $RUN_ID;
echo "&FLOW_ID=";
echo $FLOW_ID;
echo "&PRCS_ID=";
echo $PRCS_ID;
echo "'\" title=\"转交工作至下一步骤\"><img src=\"/images/flow_next.gif\" border=\"0\">转交</a>\r\n <a href=\"javascript:stop_run(";
echo $RUN_ID;
echo ",";
echo $PRCS_ID;
echo ");\" title=\"结束执行中工作\">结束</a>\r\n";
}
}
echo " <a href=\"../query/export_zip.php?RUN_ID_STR=";
echo $RUN_ID;
echo "\" title=\"导出zip压缩包\">导出</a>\r\n";
if ( !( $PRCS_ID == 1 ) && $PRCS_FLAG < 3 || $LOGIN_USER_PRIV == 1 )
{
echo " <a href=\"javascript:delete_run(";
echo $RUN_ID;
echo ");\" title=\"删除此项工作\">删除</a>\r\n";
}
echo " </td>\r\n </tr>\r\n";
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -