📄 sign.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
<? 
include_once("../auth.php"); 
?> 

<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"><?=$CONTENT?></textarea> 
<br> 
<input type="hidden" name="P" value="<?=$P?>"> 
<input type="hidden" name="FLOW_ID" value="<?=$FLOW_ID?>"> 
<input type="hidden" name="RUN_ID" value="<?=$RUN_ID?>"> 
<input type="hidden" name="PRCS_ID" value="<?=$PRCS_ID?>"> 
<input type="button" value="返回" onClick="location='index.php?P=<?=$P?>'">&nbsp; 
<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=""; 

$PRCS_FLAG_ALL=4; 
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"]; 

if($PRCS_FLAG!=4) 
$PRCS_FLAG_ALL=0; 

$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.=" 未接收"; 
elseif($PRCS_FLAG==2) 
$PRCS_FLAG_DESC.=" 办理中"; 
elseif($PRCS_FLAG==3) 
$PRCS_FLAG_DESC.=" 已转交"; 
elseif($PRCS_FLAG==4) 
$PRCS_FLAG_DESC.=" 已办结"; 

$PRCS_FLAG_DESC.=" 开始于 $PRCS_TIME"; 
$PRCS_FLAG_DESC.=" ".$FEED_CONTENT."<br>"; 
} 

if($PRCS_FLAG>2) 
$PRCS_FLAG_DESC.="<br>步骤结束于 $DELIVER_TIME"; 
?> 
<b>第<?=$PRCS_ID_I?>步: 
<? 
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; 
} 
?> 
</b> <?=$PRCS_FLAG_DESC?><br> 
<? 
} 
?> 

</body> 
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -