📄 flow_img.php
字号:
<?php
ob_start( );
include_once( "inc/auth.php" );
include_once( "inc/img_flow.inc.php" );
include_once( "inc/img_patten.inc.php" );
ob_end_clean( );
$query = "SELECT FLOW_NAME from FLOW_TYPE WHERE FLOW_ID={$FLOW_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FLOW_NAME = $ROW[0];
}
$RUN_NAME = $FLOW_NAME."(".$CUR_TIME.")";
$query = "SELECT * from FLOW_RUN where FLOW_ID={$FLOW_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FLOW_READ_ONLY = 1;
}
$query = "SELECT FLOW_PRCS,OP_FLAG from FLOW_RUN_PRCS where RUN_ID={$RUN_ID} AND USER_ID='".$LOGIN_USER_ID."' ORDER BY PRCS_ID DESC";
$cursor = exequery( $connection, $query );
$ROW = mysql_fetch_array( $cursor );
$OP_FLAG = $ROW['OP_FLAG'];
include_once( "inc/img_flow.inc.php" );
include_once( "inc/img_patten.inc.php" );
$sql = "\r\n SELECT FLOW_PRCS FROM flow_run_prcs \r\n\t\t WHERE RUN_ID=".$_REQUEST['RUN_ID']." \r\n\t\t GROUP BY PRCS_ID ASC \r\n ";
$res = exequery( $connection, $sql );
while ( $row = mysql_fetch_array( $res ) )
{
$exportv[] = $row['FLOW_PRCS'];
}
$sql = " \r\n SELECT ID,FLOW_ID,PRCS_ID,PRCS_NAME,PRCS_USER,PRCS_ITEM,PRCS_DEPT,PRCS_PRIV,PRCS_TO \r\n\t FROM flow_process \r\n\t\t WHERE FLOW_ID=".$_REQUEST['FLOW_ID']." \r\n\t\t\t ORDER BY PRCS_ID\r\n\t\t\t\t ";
$res = exequery( $connection, $sql );
while ( $row = mysql_fetch_array( $res ) )
{
$export[$row['PRCS_ID']] = $row['PRCS_TO'];
}
$NowImg = new imgflow( );
$ImgPatten = new formatex( );
$export = $ImgPatten->makeupex( $export );
$export = $ImgPatten->replaceflag( $export );
$screenxy = $ImgPatten->countsize( $export );
$exportv = $ImgPatten->replaceflagrun( $export, $exportv );
$current = $ImgPatten->getcurrentsetp( $exportv );
$width = $screenxy['x'] - 49;
$height = $screenxy['y'];
$NowImg->definepic( "jpeg", $width, $height );
$w = $NowImg->layer_w;
$h = $NowImg->layer_h;
$NowImg->defineexport( $export );
$NowImg->destroyimg( );
$coordinate = $NowImg->coordinate;
echo "<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"1\">\r\n <tr>\r\n <td bgcolor=\"#F5F5F5\">\r\n\r\n";
$flowinfo = $coordinate;
$query = "SELECT * from FLOW_PROCESS WHERE FLOW_ID=".$_REQUEST['FLOW_ID']." ORDER BY PRCS_ID";
$cursor = exequery( $connection, $query );
$PRCS_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$PRCS_COUNT;
$flowinfo[$PRCS_COUNT]['prcsname'] = $ROW['PRCS_NAME'];
$flowinfo[$PRCS_COUNT]['id'] = $ROW['ID'];
$flowinfo[$PRCS_COUNT]['prcsid'] = $ROW['PRCS_ID'];
}
echo "\r\n<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n <tr>\r\n <td><div id=\"parentLayer\" style=\"position:absolute; width:1px; height:1px; z-index:0\">\r\n";
reset( $flowinfo );
unset( $k );
while ( list( $key, $flowdetail ) = each( $flowinfo ) )
{
++$k;
$x = $flowdetail['TL']['0'];
$y = $flowdetail['TL']['1'];
$prcsname = $flowdetail['prcsname'];
$prcsid = $flowdetail['prcsid'];
echo "<div id=\"";
echo "layer".$k;
echo "\" style=\"position:absolute; left:";
echo $x;
echo "px; top:";
echo $y;
echo "px; width:";
echo $w;
echo "px; height:";
echo $h;
echo "px; z-index:0; background-color: #E2E4E3; layer-background-color: #E2E4E3; border: 1px none #000000;\">\r\n ";
$sqlp = "\r\n SELECT u.USER_NAME,frp.* FROM flow_run_prcs frp,user u \r\n\t\t WHERE u.USER_ID=frp.USER_ID \r\n\t\t\t AND frp.RUN_ID=".$_REQUEST['RUN_ID']." AND frp.FLOW_PRCS=".$prcsid."\r\n \r\n ";
$resp = exequery( $connection, $sqlp );
$mostly_man = array( );
$subordination_man = array( );
$mk = 0;
while ( $rowp = mysql_fetch_array( $resp ) )
{
if ( $rowp['OP_FLAG'] == 1 )
{
$mostly_man[]['name'] = $rowp['USER_NAME'];
$mostly_man[]['flag'] = $rowp['PRCS_FLAG'];
}
else
{
$subordination_man[$mk]['name'] = $rowp['USER_NAME'];
$subordination_man[$mk]['flag'] = $rowp['PRCS_FLAG'];
}
++$mk;
}
unset( $strSubd );
if ( 0 < count( $subordination_man ) )
{
while ( list( $key, $var ) = each( $subordination_man ) )
{
$strSubd .= "<tr><td>".$var['name'];
$strSubd .= $strM."</td></tr>";
}
}
if ( $strSubd == "" )
{
$strSubd = "<tr><td> </td></tr>";
}
$drc2HTML = "<table width=190 border=0 cellspacing=0 cellpadding=2><tr><td width=40% height=50 align=right valign=top>经办人:</td><td align=left valign=top><table width=100% border=0 cellspacing=0 cellpadding=0>{$strSubd}</table></td></tr></table>";
$mostlyHTML = $mostly_man[0][name];
unset( $drcHTML );
if ( $mostlyHTML != "" )
{
$drcHTML = "\t\t\tonmouseover=\"drc('<b><font color=FFFFFF>主办人：{$mostlyHTML}</font></b>', '{$drc2HTML}'); high(popup)\" \r\n\t\t\t\t\t\t\t\t\t\t\tstyle=\"CURSOR: hand\" onfocus=this.blur() \r\n\t\t\t\t\t\t\t\t\t\t\tonmouseout=low(popup); ";
}
echo " \r\n \r\n <table width=\"100%\" height=\"";
echo $h;
echo "\" border=\"1\" cellpadding=\"0\" cellspacing=\"1\" bordercolor=\"#666666\">\r\n <tr align=\"center\">\r\n\t<td height=\"20\" bgcolor=\"#0099CC\">";
echo "<s";
echo "pan style=\"color:#FFFFFF;font-weight:bolder \">\r\n\t节点:";
echo $prcsid;
echo "</span>\r\n\t</td>\r\n\t</tr>\r\n <tr >\r\n <td align=\"center\" valign=\"middle\">\r\n\t\t<table width=\"100%\" height=\"";
echo $h - 28;
echo "\" ";
if ( $k == $current )
{
echo "border='1'";
}
echo " cellpadding=\"0\" cellspacing=\"0\" bordercolor=\"#FF0000\">\r\n\t\t <tr>\r\n\t\t\t<td align=\"center\" valign=\"middle\">";
echo $prcsname;
echo "</td>\r\n\t\t </tr>\r\n\t\t</table>\t \r\n\t </td>\r\n </tr>\r\n </table>\r\n</div>\r\n";
}
echo "\t\r\n\t\r\n\t</div> \r\n\t\r\n\t <img src='/general/workflow/runimgflow.php?FLOW_ID=";
echo $_REQUEST['FLOW_ID'];
echo "&RUN_ID=";
echo $_REQUEST['RUN_ID'];
echo "' id=\"idflowimg\"></td>\r\n </tr>\r\n</table>\r\n\r\n\t\r\n\t</td>\r\n </tr>\r\n</table>\r\n\r\n<!-- 办理状况 -->\r\n\r\n<table border=\"0\" cellspacing=\"1\" cellpadding=\"5\" width=\"100%\">\r\n\t<tr class=\"tableheader\">\r\n\t\t<td width=\"50\">\r\n\t\t步骤\r\n\t\t</td>\r\n\t\t<td>\r\n\t\t节点\r\n\t\t</td>\r\n\t\t<td width=\"120\">\r\n\t\t办理人\r\n\t\t</td>\r\n\t\t<td width=\"120\">\r\n\t\t办理状态\r\n\t\t</td>\r\n\t\t<td width=\"150\">\r\n\t\t接收时间\r\n\t\t</td>\r\n\t\t<td width=\"150\">\r\n\t\t用时\r\n\t\t</td>\r\n\t</tr>\r\n ";
$query = "SELECT MAX(PRCS_ID) from FLOW_PROCESS WHERE FLOW_ID={$FLOW_ID}";
$PRCS_MAX = 0;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$PRCS_MAX = $ROW[0];
}
$PRCS_ID_I = 1;
for ( ; $PRCS_ID_I <= $PRCS_ID; ++$PRCS_ID_I )
{
$query = "SELECT * from FLOW_RUN_PRCS where RUN_ID={$RUN_ID} and PRCS_ID={$PRCS_ID_I}";
$cursor = exequery( $connection, $query );
$USER_NAME_STR = "";
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_ID = $ROW['USER_ID'];
$FLOW_PRCS = $ROW['FLOW_PRCS'];
$PRCS_TIME = $ROW['PRCS_TIME'];
$DELIVER_TIME = $ROW['DELIVER_TIME'];
$SAVEFORM_TIME = $ROW['SAVEFORM_TIME'];
$PRCS_FLAG = $ROW['PRCS_FLAG'];
$OP_FLAG = $ROW['OP_FLAG'];
$query1 = "SELECT * from USER where USER_ID='{$USER_ID}'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$USER_NAME = $ROW['USER_NAME'];
$USER_NAME_STR .= $ROW['USER_NAME'].",";
}
$arrayPrcsTime[$PRCS_ID_I][] = $PRCS_TIME;
$arrayDeliverTime[$PRCS_ID_I][] = $DELIVER_TIME;
$arraySaveTime[$PRCS_ID_I][] = $SAVEFORM_TIME;
$arrayPrcsFlag[$PRCS_ID_I][] = $PRCS_FLAG;
$arrayPrcsName[$PRCS_ID_I][] = $USER_NAME;
$arrayOpFlag[$PRCS_ID_I][] = $OP_FLAG;
}
$query1 = "SELECT * from FLOW_PROCESS WHERE FLOW_ID={$FLOW_ID} and PRCS_ID={$FLOW_PRCS}";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$PRCS_NAME = $ROW['PRCS_NAME'];
}
$USER_NAME_STR = substr( $USER_NAME_STR, 0, strlen( $USER_NAME_STR ) - 1 );
if ( $PRCS_ID_I % 2 == 0 )
{
$tableline = "tableline1";
}
else
{
$tableline = "tableline2";
}
echo " <tr class=\"";
echo $tableline;
echo "\">\r\n <td valign=\"top\">第<b>";
echo "<s";
echo "pan class=big4>\r\n ";
echo $PRCS_ID_I;
echo " </span></b>步\r\n\t\t</td>\r\n\t\t<td valign=\"top\">\r\n ";
echo $PRCS_NAME;
echo " ";
if ( $PRCS_ID_I == $PRCS_ID )
{
echo "(当前步骤)";
}
echo " </td>\r\n <td colspan=4>\r\n\t<table border=\"0\" cellspacing=\"0\" cellpadding=\"2\" width=\"100%\">\r\n\t\t ";
$i = 0;
for ( ; $i < count( $arrayPrcsName[$PRCS_ID_I] ); ++$i )
{
$flag_view = 0;
echo "<tr><td width='120'>";
if ( $arrayOpFlag[$PRCS_ID_I][$i] == 1 )
{
echo "<span style='color:#0066FF'>".$arrayPrcsName[$PRCS_ID_I][$i]."</span>";
}
else
{
echo $arrayPrcsName[$PRCS_ID_I][$i];
}
echo "</td>\n";
$strStatus = "";
if ( $arrayOpFlag[$PRCS_ID_I][$i] == 1 )
{
if ( $arrayPrcsFlag[$PRCS_ID_I][$i] == 1 )
{
$strStatus = "<span style='color:#FF0000'>未查看</span>";
}
if ( $arrayPrcsFlag[$PRCS_ID_I][$i] == 2 )
{
$strStatus = "<span style='color:#CC6666'>已查看</span>";
$flag_view = 1;
}
if ( $arrayPrcsFlag[$PRCS_ID_I][$i] == 4 )
{
$strStatus = "已提交";
$TIME_USED = strtotime( $arrayDeliverTime[$PRCS_ID_I][$i] ) - strtotime( $arrayPrcsTime[$PRCS_ID_I][$i] );
$flag_view = 1;
}
if ( $arrayPrcsFlag[$PRCS_ID_I][$i] == 3 )
{
$strStatus = "<span style='color:#FF9900'>已转交</span>";
$flag_view = 1;
}
}
else
{
if ( $arrayPrcsFlag[$PRCS_ID_I][$i] == 1 )
{
$strStatus = "<span style='color:#FF0000'>未查看</span>";
}
if ( $arrayPrcsFlag[$PRCS_ID_I][$i] == 2 )
{
$strStatus = "<span style='color:#CC6666'>已查看</span>";
$flag_view = 1;
}
if ( $arraySaveTime[$PRCS_ID_I][$i] != "" )
{
$strStatus = "已办理";
$TIME_USED = strtotime( $arraySaveTime[$PRCS_ID_I][$i] ) - strtotime( $arrayPrcsTime[$PRCS_ID_I][$i] );
$flag_view = 1;
}
if ( $arrayPrcsFlag[$PRCS_ID_I][$i] == 4 && $arraySaveTime[$PRCS_ID_I][$i] == "" )
{
$strStatus = "<span style='color:#999999'>未办理</span>";
$flag_view = 0;
}
}
$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."秒";
}
echo "<td width='120'>";
echo $strStatus;
echo "</td>\n";
echo "<td width='150'>";
echo "<span style='font-size:10px'>";
echo $arrayPrcsTime[$PRCS_ID_I][$i];
echo "</span>";
echo "</td>\n";
echo "<td width='150'>";
if ( $flag_view == 1 )
{
echo $TIME_STR;
}
echo "</td>\n";
echo "</tr>\n";
}
echo "\t</table>\r\n\t \r\n\t </td>\r\n </tr>\r\n ";
}
$PRCS_NEXT = $PRCS_ID + 1;
echo "</table> \r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -