📄 sign.php
字号:
<?php
include_once( "../auth.php" );
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>\r\n\r\n<font color=blue size=+2><b>会签</b></font>\r\n<form action=\"sign_submit.php\" method=\"post\" name=\"form1\">\r\n会签意见<br>\r\n<textarea cols=\"18\" name=\"CONTENT\" rows=\"3\" wrap=\"on\">";
echo $CONTENT;
echo "</textarea>\r\n<br>\r\n<input type=\"hidden\" name=\"P\" value=\"";
echo $P;
echo "\">\r\n<input type=\"hidden\" name=\"FLOW_ID\" value=\"";
echo $FLOW_ID;
echo "\">\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=\"button\" value=\"返回\" onClick=\"location='index.php?P=";
echo $P;
echo "'\"> \r\n<input type=\"submit\" value=\"保存\">\r\n</form>\r\n<hr>\r\n\r\n";
$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];
}
$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} 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 = "\n\n会签意见：\n";
}
$FEED_CONTENT .= $ROW['CONTENT']."\n";
}
$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 "步:\r\n";
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>\r\n";
}
echo "\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -