📄 sign.php
字号:
<?
include_once '../auth.php';
echo '
<html>
<head>
<title>会签</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<font color=blue size=+2><b>会签</b></font>
<form action="sign_submit.php" method="post" name="form1">
会签意见<br>
<textarea cols="18" name="CONTENT" rows="3" wrap="on">';
echo $CONTENT;
echo '</textarea>
<br>
<input type="hidden" name="P" value="';
echo $P;
echo '">
<input type="hidden" name="FLOW_ID" value="';
echo $FLOW_ID;
echo '">
<input type="hidden" name="RUN_ID" value="';
echo $RUN_ID;
echo '">
<input type="hidden" name="PRCS_ID" value="';
echo $PRCS_ID;
echo '">
<input type="button" value="返回" onClick="location=\'index.php?P=';
echo $P;
echo '\'">
<input type="submit" value="保存">
</form>
<hr>
';
$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'];
$FLOW_TYPE = $ROW['FLOW_TYPE'];
}
$CUR_TIME = date ('Y-m-d H:i:s', time ());
$query = ((((((''.'SELECT * from FLOW_RUN_PRCS where USER_ID=\'').$LOGIN_USER_ID).'\' AND RUN_ID=').$RUN_ID).' AND PRCS_ID=').$PRCS_ID);
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$PRCS_FLAG = $ROW['PRCS_FLAG'];
$TOP_FLAG = $ROW['TOP_FLAG'];
if (($PRCS_FLAG == 1))
{
$query = ((((((((''.'update FLOW_RUN_PRCS set PRCS_FLAG=\'2\',PRCS_TIME=\'').$CUR_TIME).'\' WHERE USER_ID=\'').$LOGIN_USER_ID).'\' AND RUN_ID=').$RUN_ID).' AND PRCS_ID=').$PRCS_ID);
exequery ($connection, $query);
}
}
$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];
}
for ($PRCS_ID_I = 1; ($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).' order by PRCS_FLAG desc,PRCS_TIME');
$cursor = exequery ($connection, $query);
$PRCS_FLAG_DESC = '';
while ($ROW = mysql_fetch_array ($cursor))
{
$PRCS_USER = $ROW['USER_ID'];
$PRCS_TIME = $ROW['PRCS_TIME'];
$DELIVER_TIME = $ROW['DELIVER_TIME'];
$PRCS_FLAG = $ROW['PRCS_FLAG'];
$FLOW_PRCS = $ROW['FLOW_PRCS'];
$OP_FLAG = $ROW['OP_FLAG'];
$PRCS_USER_NAME = '';
$query1 = (((''.'SELECT * from USER where USER_ID=\'').$PRCS_USER).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$PRCS_USER_NAME = $ROW['USER_NAME'];
}
else
{
$PRCS_USER_NAME = $PRCS_USER;
}
$query = (((((((''.'SELECT * from FLOW_RUN_FEEDBACK where RUN_ID=').$RUN_ID).' and PRCS_ID=').$PRCS_ID_I).' and USER_ID=\'').$LOGIN_USER_ID).'\' order by EDIT_TIME');
$cursor1 = exequery ($connection, $query);
$FEED_CONTENT = '';
while ($ROW = mysql_fetch_array ($cursor1))
{
if (($FEED_CONTENT == ''))
{
$FEED_CONTENT = '
会签意见：
';
}
($FEED_CONTENT .= ($ROW['CONTENT'].'
'));
}
($PRCS_FLAG_DESC .= $PRCS_USER_NAME);
if (($OP_FLAG == 1))
{
($PRCS_FLAG_DESC .= ' 主办人 ');
}
if (($PRCS_FLAG == 1))
{
($PRCS_FLAG_DESC .= ' 未接收');
}
else
{
if (($PRCS_FLAG == 2))
{
($PRCS_FLAG_DESC .= ' 办理中');
}
else
{
if (($PRCS_FLAG == 3))
{
($PRCS_FLAG_DESC .= ' 已转交');
}
else
{
if (($PRCS_FLAG == 4))
{
($PRCS_FLAG_DESC .= ' 已办结');
}
}
}
}
($PRCS_FLAG_DESC .= ((''.' 开始于 ').$PRCS_TIME));
($PRCS_FLAG_DESC .= ((' '.$FEED_CONTENT).'<br>'));
}
if ((2 < $PRCS_FLAG))
{
($PRCS_FLAG_DESC .= ((''.'<br>步骤结束于 ').$DELIVER_TIME));
}
echo ' <b>第';
echo $PRCS_ID_I;
echo '步:
';
if (($FLOW_TYPE == 1))
{
$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'];
}
else
{
$PRCS_NAME = '<font color=red>步骤已删除</font>';
}
echo $PRCS_NAME;
}
echo ' </b> ';
echo $PRCS_FLAG_DESC;
echo '<br>
';
}
echo '
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -