📄 form.php

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

$query = "SELECT * from FLOW_TYPE WHERE FLOW_ID='$FLOW_ID'"; 
$cursor1= exequery($connection,$query); 
if($ROW=mysql_fetch_array($cursor1)) 
$FORM_ID=$ROW["FORM_ID"]; 

//--- 文号 --- 
$query1 = "SELECT * from FLOW_RUN where RUN_ID='$RUN_ID'"; 
$cursor1 = exequery($connection,$query1); 
if($ROW=mysql_fetch_array($cursor1)) 
{ 
$RUN_NAME=$ROW["RUN_NAME"]; 
$ATTACHMENT_ID = $ROW["ATTACHMENT_ID"]; 
$ATTACHMENT_NAME = $ROW["ATTACHMENT_NAME"]; 
} 

//--- 开始时间 --- 
$PRCS_TIME=""; 
$query1 = "SELECT * from FLOW_RUN_PRCS WHERE RUN_ID=$RUN_ID AND PRCS_ID=1"; 
$cursor1= exequery($connection,$query1); 
if($ROW=mysql_fetch_array($cursor1)) 
{ 
$PRCS_TIME=$ROW["PRCS_TIME"]; 
if($PRCS_TIME=="0000-00-00 00:00:00") 
$PRCS_TIME=""; 
} 
?> 

<html> 
<head> 
<title>查看表单</title> 
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"> 
</head> 

<body> 
<font color=blue size=+2><b>查看表单</b></font><br><br> 

<b>名称/文号</b>:<?=$RUN_NAME?><br> 
<b>流程开始</b>:<?=$PRCS_TIME?><br> 
<b>附件</b>: 
<? 
if($ATTACHMENT_NAME=="") 
echo "无"; 
else 
{ 
$ATTACHMENT_ID_ARRAY=explode(",",$ATTACHMENT_ID); 
$ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME); 

$ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY); 
for($I=0;$I<$ARRAY_COUNT-1;$I++) 
{ 
      $ATTACH_SIZE=attach_size($ATTACHMENT_ID_ARRAY[$I],$ATTACHMENT_NAME_ARRAY[$I]); 
$ATTACH_SIZE=number_format($ATTACH_SIZE,0, ".",","); 
?> 
<a href="../attach.php?P=<?=$P?>&ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>" target="_blank"><?=$ATTACHMENT_NAME_ARRAY[$I]?></a> 
(<?=$ATTACH_SIZE?>字节) 
<? 
}//for 
}//else 
?> 
<hr> 
<? 
//--- 表单数据 --- 
$query = "SELECT * from FLOW_RUN_DATA where RUN_ID=$RUN_ID order by ITEM_ID"; 
$cursor = exequery($connection,$query); 
while($ROW=mysql_fetch_array($cursor)) 
{ 
$ITEM_ID=$ROW["ITEM_ID"]; 
$ITEM_DATA=$ROW["ITEM_DATA"]; 
$STR="DATA_".$ITEM_ID; 
$$STR=$ITEM_DATA; 
} 

$query = "SELECT * from FLOW_FORM_TYPE WHERE FORM_ID='$FORM_ID'"; 
$cursor1= exequery($connection,$query); 
if($ROW=mysql_fetch_array($cursor1)) 
$PRINT_MODEL=$ROW["PRINT_MODEL"]; 

$ELEMENT_ARRAY=html_element($PRINT_MODEL); 
$ITEM_ID_MAX=sizeof($ELEMENT_ARRAY); 
$ITEM_ID=0; 
for($I=0;$I<$ITEM_ID_MAX;$I++) 
{ 
$ELEMENT=$ELEMENT_ARRAY[$I]; 
$ENAME=get_attr($ELEMENT,"NAME"); 
$ETITLE=get_attr($ELEMENT,"TITLE"); 
$ECLASS=get_attr($ELEMENT,"CLASS"); 
$EVALUE=get_attr($ELEMENT,"VALUE"); 

$ETITLE=str_replace("<","&lt",$ETITLE); 
$ETITLE=str_replace(">","&gt",$ETITLE); 
$ETITLE=stripslashes($ETITLE); 

if($ECLASS!="DATE") 
$ITEM_ID++; 
else 
continue; 

$STR="DATA_".$ITEM_ID; 
$ITEM_VALUE=$$STR; 


if($ECLASS!="LIST_VIEW") 
$ITEM_VALUE=str_replace("\r\n"," ",$ITEM_VALUE); 

if($ECLASS=="AUTO" && $ENAME=="SELECT" && $ITEM_VALUE!="") //--- 列表型宏控件 --- 
{ 
$EDATAFLD=get_attr($ELEMENT,"DATAFLD"); 
switch($EDATAFLD) 
{ 
case "SYS_LIST_DEPT": 
$query_auto="SELECT * from DEPARTMENT where DEPT_ID='$ITEM_VALUE'"; 
$cursor_auto = exequery($connection,$query_auto); 
if($ROW=mysql_fetch_array($cursor_auto)) 
$ITEM_VALUE=$ROW["DEPT_NAME"]; 
break; 
case "SYS_LIST_PRIV": 
$query_auto="SELECT * from USER_PRIV where USER_PRIV=$ITEM_VALUE"; 
$cursor_auto = exequery($connection,$query_auto); 
if($ROW=mysql_fetch_array($cursor_auto)) 
$ITEM_VALUE=$ROW["PRIV_NAME"]; 
break; 
case "SYS_LIST_USER": 
case "SYS_LIST_PRCSUSER1": 
case "SYS_LIST_PRCSUSER2": 
$query_auto="SELECT * from USER where USER_ID='$ITEM_VALUE'"; 
$cursor_auto = exequery($connection,$query_auto); 
if($ROW=mysql_fetch_array($cursor_auto)) 
$ITEM_VALUE=$ROW["USER_NAME"]; 
break; 
case "SYS_LIST_SQL": 
break; 
} 

} 
elseif($ECLASS=="LIST_VIEW") //列表控件 
{ 
$ITEM_VALUE=str_replace("\r\n","|",$ITEM_VALUE); 
$ITEM_VALUE=str_replace("`",",",$ITEM_VALUE); 
} 
else //--- 普通控件 --- 
{ 
if($ECLASS=="AUTO" && $ITEM_VALUE=="{宏控件}") 
$ITEM_VALUE=""; 

$ITEM_VALUE=str_replace("<","&lt",$ITEM_VALUE); 
$ITEM_VALUE=str_replace(">","&gt",$ITEM_VALUE); 
$ITEM_VALUE=stripslashes($ITEM_VALUE); 

if($ENAME=="INPUT" && strstr($ELEMENT,"type=checkbox")) 
{ 
if($ITEM_VALUE=="on") 
$ITEM_VALUE="是"; 
else 
$ITEM_VALUE="否"; 
} 
} 
echo "<b>".$ETITLE."</b>:".$ITEM_VALUE."<br>"; 
}//for 
?> 
<a href="javascript:history.back()">返回</a>
⌨️ 快捷键说明

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