📄 view_list.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "../../prcs_role.php" );
setcookie( "flow_view", 1, time( ) + 86400000, "/" );
$RUN_ROLE = run_role( $RUN_ID, 0 );
if ( $RUN_ROLE == "" )
{
exit( );
}
$query = "SELECT * from FLOW_RUN WHERE RUN_ID=".$RUN_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$RUN_NAME = $ROW['RUN_NAME'];
$FLOW_ID = $ROW['FLOW_ID'];
$DEL_FLAG = $ROW['DEL_FLAG'];
}
$query = "SELECT * from FLOW_TYPE where FLOW_ID=".$FLOW_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FLOW_NAME = $ROW['FLOW_NAME'];
$FLOW_TYPE = $ROW['FLOW_TYPE'];
}
$TITLE = "流程图 - ".$FLOW_NAME.( " - (".$RUN_ID.")" ).$RUN_NAME;
if ( $PRINT_FLAG != 1 )
{
echo "\r\n<html>\r\n<head>\r\n<title>";
echo $TITLE;
echo "</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<style>\r\n#tooltip {z-index:65535;position:absolute;border:1px solid #333;background:#f7f5d1;padding:2px 5px;color:#333;display:none;}\t\r\n.tip {position:absolute;display:none;text-align:center;font-size:9pt;font-weight:bold;z-index:65535;background-color:#DE7293;color:white;padding:10px}\r\n</style>\r\n<link rel=\"stylesheet\" type=\"text/css\" href=\"/theme/";
echo $LOGIN_THEME;
echo "/dialog.css\">\r\n<script language=\"javascript\" src=\"/inc/js/utility.js\"></script>\r\n<script language=\"javascript\" src=\"/inc/js/jquery/jquery.js\"></script>\r\n<script language=\"javascript\" src=\"/inc/js/jquery/utility.js\"></script>\r\n<script>\r\njQuery(document).ready(function(){\r\n tooltip();});\r\nfocus();\r\nfunction re_do(RUN_ID,PRCS_ID,FLOW_PRCS,PRCS_USER)\r\n{\r\n\tvar msg=\"确定要让此经办人重新会签吗？\";\r\n if(window.confirm(msg))\r\n {\r\n \tvar url=\"re_do.php?RUN_ID=\"+RUN_ID+\"&PRCS_ID=\"+PRCS_ID+\"&FLOW_PRCS=\"+FLOW_PRCS+\"&PRCS_USER=\"+PRCS_USER;\r\n jQuery.get(url,function(data){\r\n \tif(data==0)\r\n \t showTip('<div class=\"tip\" id=\"loading\">您无权操作</div>');\r\n \telse\r\n \t location.reload();\r\n });\r\n }\r\n}\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
}
if ( $DEL_FLAG )
{
echo "<div align=\"center\" style=\"position:absolute;width:128;height:128;left:expression((body.clientWidth-128)/2);top:expression((body.clientHeight-128)/2);background:#FFFFFF url(/images/run_deleted.png) no-repeat center center;filter:alpha(opacity=30)\">\r\n</div>\r\n";
}
echo "\r\n<table style='border-collapse:collapse' border=1 cellspacing=0 cellpadding=3 bordercolor='#000000' width=\"100%\" class=\"small\">\r\n";
if ( $PRINT_FLAG )
{
echo " <tr>\r\n <td nowrap colspan=\"3\" class=\"TableHeader\"><b>流程图</b></td>\r\n </tr>\r\n";
}
$query = "SELECT MAX(PRCS_ID) from FLOW_RUN_PRCS where RUN_ID=".$RUN_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$PRCS_ID = $ROW[0];
}
$query = "SELECT MAX(PRCS_ID) from FLOW_RUN_PRCS where RUN_ID=".$RUN_ID." and PRCS_FLAG<>'5'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$PRCS_ID_NOW = $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} group by FLOW_PRCS";
$cursor = exequery( $connection, $query );
$NUM_ROWS = mysql_num_rows( $cursor );
$FLOW_PRCS_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$FLOW_PRCS = $ROW['FLOW_PRCS'];
$PARENT = $ROW['PARENT'];
++$FLOW_PRCS_COUNT;
$query1 = "SELECT 1 from FLOW_RUN_PRCS WHERE RUN_ID='".$RUN_ID."' AND PRCS_ID='{$PRCS_ID_I}' AND FLOW_PRCS='{$FLOW_PRCS}' AND USER_ID='{$LOGIN_USER_ID}'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$IS_PROC_USER = 1;
}
else
{
$IS_PROC_USER = 0;
}
$query1 = "SELECT USER_ID,PRCS_FLAG from FLOW_RUN_PRCS where RUN_ID=".$RUN_ID." and PRCS_ID={$PRCS_ID_I} and FLOW_PRCS='{$FLOW_PRCS}' and OP_FLAG=1";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$OP_USER = $ROW['USER_ID'];
$OP_PRCS_FLAG = $ROW['PRCS_FLAG'];
}
if ( $FLOW_TYPE == 1 )
{
$query2 = "SELECT PRCS_NAME,TIME_OUT,SIGNLOOK from FLOW_PROCESS WHERE FLOW_ID=".$FLOW_ID." AND PRCS_ID={$FLOW_PRCS}";
$cursor2 = exequery( $connection, $query2 );
if ( $ROW = mysql_fetch_array( $cursor2 ) )
{
$PRCS_NAME = $ROW['PRCS_NAME'];
$TIME_OUT = $ROW['TIME_OUT'];
$SIGNLOOK = $ROW['SIGNLOOK'];
}
else
{
$PRCS_NAME = "<font color=red>流程步骤已删除</font>";
}
}
$query1 = "SELECT * from FLOW_RUN_PRCS where RUN_ID=".$RUN_ID." and PRCS_ID={$PRCS_ID_I} and FLOW_PRCS='{$FLOW_PRCS}' order by PRCS_FLAG desc,PRCS_TIME";
$cursor1 = exequery( $connection, $query1 );
$PRCS_FLAG_DESC = "";
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$PRCS_USER = $ROW['USER_ID'];
$PRCS_TIME = $ROW['PRCS_TIME'];
$DELIVER_TIME = $ROW['DELIVER_TIME'];
$PRCS_FLAG = $ROW['PRCS_FLAG'];
$OP_FLAG = $ROW['OP_FLAG'];
$PRCS_USER_NAME = "";
$query2 = "SELECT USER_NAME,DEPT_ID from USER where USER_ID='".$PRCS_USER."'";
$cursor2 = exequery( $connection, $query2 );
if ( $ROW = mysql_fetch_array( $cursor2 ) )
{
$PRCS_USER_NAME = $ROW['USER_NAME'];
$PRCS_USER_NAME1 = $PRCS_USER_NAME;
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = dept_long_name( $DEPT_ID );
}
else
{
$PRCS_USER_NAME = $PRCS_USER;
}
$SEE_SIGN = 1;
$FEED_CONTENT = "";
if ( $FLOW_TYPE == 1 )
{
if ( $SIGNLOOK == 2 )
{
if ( $IS_PROC_USER == 0 )
{
$SEE_SIGN = 0;
}
}
else if ( $SIGNLOOK == 1 && $IS_PROC_USER == 1 && $PRCS_USER != $LOGIN_USER_ID )
{
$SEE_SIGN = 0;
}
}
if ( $SEE_SIGN == 1 )
{
$query2 = "SELECT CONTENT,EDIT_TIME from FLOW_RUN_FEEDBACK where RUN_ID=".$RUN_ID." and PRCS_ID={$PRCS_ID_I} and USER_ID='{$PRCS_USER}' order by EDIT_TIME";
$cursor2 = exequery( $connection, $query2 );
$FEED_CONTENT = "";
while ( $ROW = mysql_fetch_array( $cursor2 ) )
{
if ( $FEED_CONTENT == "" )
{
$FEED_CONTENT = "\n\n会签与点评：\n";
}
$FEED_CONTENT .= $ROW['CONTENT']." ".$ROW['EDIT_TIME']."\n";
}
}
if ( $OP_FLAG == 1 )
{
$PRCS_USER_NAME = "<span class='big4'><u title='<b>主办人</b> <br>部门：".$DEPT_NAME." <br> {$FEED_CONTENT}' style='cursor:pointer'><b>".$PRCS_USER_NAME." 主办</b></u></span>";
}
else
{
$PRCS_USER_NAME = "<u title='部门：".$DEPT_NAME."' style='cursor:pointer'><b>{$PRCS_USER_NAME}</b></u>";
}
if ( $PRCS_FLAG == 1 )
{
$TIME_USED = 0;
}
else if ( $PRCS_FLAG == 2 )
{
$TIME_USED = time( ) - strtotime( $PRCS_TIME );
}
else
{
$TIME_USED = strtotime( $DELIVER_TIME ) - strtotime( $PRCS_TIME );
if ( $DELIVER_TIME == "" )
{
$TIME_USED = 0;
}
}
if ( $PRCS_TIME == "" )
{
$TIME_USED = 0;
}
$DAY = floor( $TIME_USED / 86400 );
$HOUR = floor( $TIME_USED % 86400 / 3600 );
$MIN = floor( $TIME_USED % 3600 / 60 );
$SEC = floor( $TIME_USED % 60 );
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -