📄 others.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "../prcs_role.php" );
if ( !run_role( $RUN_ID, $PRCS_ID ) )
{
exit( );
}
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</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$connection = openconnection( );
$query = "SELECT * from FLOW_TYPE WHERE FLOW_ID={$FLOW_ID}";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FLOW_NAME = $ROW['FLOW_NAME'];
$FORM_ID = $ROW['FORM_ID'];
}
echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/green_arrow.gif\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\"> 委托代办人 (";
echo $FLOW_NAME;
echo ")</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<br>\r\n\r\n<form action=\"others_submit.php\" method=\"post\" name=\"form1\">\r\n<table border=\"0\" cellspacing=\"1\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\" align=\"center\" width=\"90%\">\r\n <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\" class=\"Big\" colspan=\"2\"><b>";
echo $FLOW_NAME;
echo "</b></td>\r\n </tr>\r\n\r\n";
$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 = "";
$USER_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$USER_COUNT;
$USER_ID = $ROW['USER_ID'];
$FLOW_PRCS = $ROW['FLOW_PRCS'];
$query1 = "SELECT * from USER where USER_ID='{$USER_ID}'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$USER_NAME_STR .= $ROW['USER_NAME'].",";
}
}
$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'];
$PRCS_USER = $ROW['PRCS_USER'];
$PRCS_DEPT = $ROW['PRCS_DEPT'];
$PRCS_PRIV = $ROW['PRCS_PRIV'];
}
$USER_NAME_STR = substr( $USER_NAME_STR, 0, strlen( $USER_NAME_STR ) - 1 );
if ( $PRCS_ID_I != $PRCS_ID )
{
echo "\r\n <tr class=\"TableData\">\r\n <td nowrap width=\"10%\">";
echo $PRCS_ID_I;
echo "：";
echo $PRCS_NAME;
echo "</td>\r\n <td>";
echo $USER_NAME_STR;
echo "</td>\r\n </tr>\r\n";
}
else
{
echo " <tr class=\"TableData\">\r\n <td nowrap width=\"10%\">";
echo $PRCS_ID_I;
echo "：";
echo $PRCS_NAME;
echo " (当前步骤)</td>\r\n <td nowrap>\r\n";
if ( 1 < $USER_COUNT )
{
echo "本步骤为会签步骤，不能指定代办人";
}
else
{
if ( $PRCS_DEPT != "" )
{
$PRCS_DEPT = substr( $PRCS_DEPT, 0, strlen( $PRCS_DEPT ) - 1 );
$query1 = "SELECT * from USER,USER_PRIV WHERE USER.USER_PRIV=USER_PRIV.USER_PRIV and DEPT_ID in({$PRCS_DEPT}) order by PRIV_NO,USER_NAME";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$USER_ID = $ROW['USER_ID'];
$PRCS_USER .= $USER_ID.",";
}
}
if ( $PRCS_PRIV != "" )
{
$PRCS_PRIV = substr( $PRCS_PRIV, 0, strlen( $PRCS_PRIV ) - 1 );
$query1 = "SELECT * from USER,USER_PRIV WHERE USER.USER_PRIV=USER_PRIV.USER_PRIV and USER.USER_PRIV in({$PRCS_PRIV}) order by PRIV_NO,USER_NAME";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$USER_ID = $ROW['USER_ID'];
$PRCS_USER .= $USER_ID.",";
}
}
$MY_ARRAY = explode( ",", $PRCS_USER );
$ARRAY_COUNT = sizeof( $MY_ARRAY );
if ( $MY_ARRAY[$ARRAY_COUNT - 1] == "" )
{
--$ARRAY_COUNT;
}
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
if ( $MY_ARRAY[$I] != $LOGIN_USER_ID )
{
$query1 = "SELECT * from USER where USER_ID='{$MY_ARRAY[$I]}'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$USER_NAME = $ROW['USER_NAME'];
}
if ( $I == 0 )
{
echo "请指定当前步骤的代办人：<br>";
}
echo " <input type=\"radio\" name=\"USER_ID\" value=\"";
echo $MY_ARRAY[$I];
echo "\" ";
if ( $I == 0 )
{
echo "checked";
}
echo ">";
echo $USER_NAME;
echo "<br>\r\n";
}
}
if ( $MY_ARRAY[0] == $LOGIN_USER_ID && $ARRAY_COUNT == 1 )
{
$I = 0;
}
if ( $I == 0 )
{
echo "本步骤无可选择的代办人";
}
}
echo " </td>\r\n </tr>\r\n";
}
}
echo " <tr class=\"TableControl\">\r\n <td nowrap align=\"center\" colspan=\"2\">\r\n <input type=\"hidden\" name=\"RUN_ID\" value=\"";
echo $RUN_ID;
echo "\">\r\n <input type=\"hidden\" name=\"PRCS_ID\" value=\"";
echo $PRCS_ID;
echo "\">\r\n <input type=\"hidden\" name=\"PRCS_USER\" value=\"";
echo $PRCS_USER;
echo "\">\r\n";
if ( $I != 0 )
{
echo " <input type=\"submit\" value=\"确定\" class=\"BigButton\" name=\"submit\"> \r\n";
}
echo " <input type=\"button\" value=\"返回\" class=\"BigButton\" name=\"back\" onClick=\"history.back();\">\r\n </td>\r\n </tr>\r\n</table>\r\n</form>\r\n\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -