📄 field_set.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
字号:
<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_html.php" );
$sql = "SELECT COUNT(*) AS cnt FROM flow_report_field WHERE REPORT_ID=".$_REQUEST['REPORT_ID'];
$rs = exequery( $connection, $sql );
$row = mysql_fetch_array( $rs );
if ( $row['cnt'] < 1 )
{
	$sql = "SELECT FORM_ID FROM flow_type WHERE FLOW_ID=".$_REQUEST['FLOW_ID']."";
	$rs = exequery( $connection, $sql );
	$row = mysql_fetch_array( $rs );
	$FORM_ID = $row['FORM_ID'];
	$query = "select * from FLOW_FORM_TYPE where FORM_ID={$FORM_ID}";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$PRINT_MODEL = $ROW['PRINT_MODEL'];
	}
	$ELEMENT_ARRAY = html_element( $PRINT_MODEL );
	$ARRAY_COUNT = sizeof( $ELEMENT_ARRAY );
	$I = 0;
	for ( ;	$I < $ARRAY_COUNT;	++$I	)
	{
		$E_TITLE = get_attr( $ELEMENT_ARRAY[$I], "TITLE" );
		$E_VALUE = get_attr( $ELEMENT_ARRAY[$I], "VALUE" );
		$ITEM_NAME_ALL .= $E_TITLE.",";
		$ITEM_VALUE_ALL .= $E_VALUE.",";
	}
	if ( $FLOW_DOC == "1" )
	{
		$ITEM_NAME_ALL .= "[A@],";
		$ITEM_VALUE_ALL .= "{ATTACH},";
	}
	$ITEM_NAME_ALL = str_replace( "+", "＋", $ITEM_NAME_ALL );
	$ITEM_NAME_ALL = str_replace( "#", "＃", $ITEM_NAME_ALL );
	$itemArray = explode( ",", $ITEM_NAME_ALL );
	$i = 0;
	for ( ;	$i < count( $itemArray ) - 1;	++$i	)
	{
		if ( $itemArray[$i] != "[A@]" )
		{
			$sqlfi = "INSERT INTO flow_report_field (REPORT_ID,FLOW_ID,FIELD_NAME ) VALUES (".$_REQUEST['REPORT_ID'].",".$_REQUEST['FLOW_ID'].",'".$itemArray[$i]."')";
			exequery( $connection, $sqlfi );
		}
	}
}
echo "<html>\r\n<head>\r\n<title>流程表单</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n";
echo "<s";
echo "cript src=\"/inc/prototype.js\"></script>\r\n";
echo "<s";
echo "cript src=\"/inc/common.js\"></script>\r\n";
echo "<s";
echo "cript src=\"/inc/follow.js\"></script>\r\n\r\n";
echo "<s";
echo "tyle>\r\nbody{\r\n\tmargin-left: 0px;\r\n\tmargin-top: 0px;\r\n\tmargin-right: 0px;\r\n\tmargin-bottom: 0px;\r\n\tpadding-left:10px\r\n}\r\n</style>\r\n";
echo "<s";
echo "cript>\r\n\r\n\r\n\r\nfunction submitForm(){\r\n\tvar subObj = document.getElementById('savebutton');\r\n\tvar simgObj = document.getElementById('saveimg');\r\n\r\n\tsimgObj.style.filter = \"gray()\";\r\n\tsubObj.disabled = true;\r\n\tdocument.fieldform.submit();\r\n\r\n}\r\n\r\nfunction LoadFieldTerm()\r\n{\r\n\t  URL=\"/module/report_term_select_new/?REPORT_ID=";
echo $_REQUEST['REPORT_ID'];
echo "&FLOW_ID=";
echo $_REQUEST['FLOW_ID'];
echo "\";\r\n\t  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;\r\n\t  loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;\r\n\t  window.showModalDialog(URL,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:450px;dialogHeight:420px;dialogTop:\");\r\n}\r\n</script>\r\n\r\n</head>\r\n<body onload=\"setVariables(); checkLocation('divsave',120,20,1);\">\r\n<table border=\"0\" width=\"100%\" cell";
echo "spacing=\"1\" cellpadding=\"0\" >\r\n  <tr class=\"tablehead2\">\r\n    <td >\r\n\t<BUTTON id=\"savebutton\" class=btn onclick=\"submitForm();\"><table><tr valign=middle ><td><img src=\"/images/workflow/save.gif\" align=\"center\" id=\"saveimg\"></td> <td> &nbsp;保 &nbsp;&nbsp;存</td></tr></table></BUTTON>  <BUTTON class=btn onclick=\"location='flow_report_view.php?FLOW_ID=";
echo $_REQUEST['FLOW_ID'];
echo "&REPORT_ID=";
echo $_REQUEST['REPORT_ID'];
echo "'\"><table><tr valign=middle ><td><img src=\"/images/workflow/view.gif\" align=\"center\"></td> <td> &nbsp;预览报表</td></tr></table></BUTTON> <BUTTON class=btn onclick=\"location='flow_report.php?FLOW_ID=";
echo $_REQUEST['FLOW_ID'];
echo "'\"><table><tr valign=middle ><td><img src=\"/images/workflow/return.gif\" align=\"center\"></td> <td> &nbsp;返 &nbsp;&nbsp;回</td></tr></table></BUTTON> \r\n    </td>\r\n    </td>\r\n  </tr>\r\n</table>\r\n<hr width=\"95%\" height=\"1\" align=\"left\" color=\"#ffffff\">\r\n\r\n<table border=\"0\" cellspacing=\"1\" cellpadding=\"5\" width=\"100%\">\r\n<form action=\"field_do.php\" name=\"fieldform\" method=\"post\">\r\n<input type=\"hidden\" name=\"REPORT_ID\" va";
echo "lue=\"";
echo $_REQUEST['REPORT_ID'];
echo "\">\r\n<input type=\"hidden\" name=\"FLOW_ID\" value=\"";
echo $_REQUEST['FLOW_ID'];
echo "\">\r\n<input type=\"hidden\" name=\"f\" value=\"save\">\r\n\t<tr class=\"TableHeader\">\r\n\t\t<td width=\"25%\">字段名</td>\r\n\r\n\t\t<td>图形分析</td>\r\n\t</tr>\r\n\t";
$sql = "SELECT * FROM flow_report_field WHERE REPORT_ID=".$_REQUEST['REPORT_ID'];
$rs = exequery( $connection, $sql );
$cnt = 0;
while ( $row = mysql_fetch_array( $rs ) )
{
	$fieldid = $row['FIELD_ID'];
	$reportid = $row['REPORT_ID'];
	$fieldname = $row['FIELD_NAME'];
	$flowid = $row['FLOW_ID'];
	$fieldterm = $row['FIELD_TERM'];
	$fieldview = $row['FIELD_VIEW'];
	$fieldproperty = $row['FIELD_PROPERTY'];
	$fieldcount = $row['FIELD_COUNT'];
	$fieldimg = $row['FIELD_IMG'];
	$checkview = "";
	$checkcount = "";
	$checkimg = "";
	if ( $fieldview )
	{
		$checkview = "checked";
	}
	if ( $fieldcount )
	{
		$checkcount = "checked";
	}
	if ( $fieldimg )
	{
		$checkimg = "checked";
	}
	if ( strpos( $fieldname, "日期控件" ) === false )
	{
		$disabled = "";
	}
	else
	{
		$checkimg = "";
		$disabled = "disabled";
	}
	++$cnt;
	$classtd = "tableline1";
	if ( $cnt % 2 == 0 )
	{
		$classtd = "tableline2";
	}
	echo "\t<tr class=\"";
	echo $classtd;
	echo "\">\r\n\t\t<td>";
	echo $fieldname;
	echo "<input type=\"hidden\" name=\"fieldid[]\" value=\"";
	echo $fieldid;
	echo "\"></td>\r\n\t\t<td><input value=\"1\" type=\"checkbox\" id=\"imrp";
	echo $fieldid;
	echo "\" name=\"imrp";
	echo $fieldid;
	echo "\" ";
	echo $checkimg;
	echo " ";
	echo $disabled;
	echo "></td>\r\n\t</tr>\r\n\r\n\t\t";
}
echo "</form>\r\n</table>\r\n<div>\r\n";
echo "<s";
echo "pan id=\"textNote\" style=\"padding:5px\">\r\n<br>注<br>\r\n图形分析：计算所选字段的综合数据并以图形表示（字段必须是数字）<br>\r\n\r\n</span>\r\n\r\n</div>\r\n\r\n</body>\r\n</html>\r\n";
echo "<s";
echo "cript>\r\n";
if ( $_REQUEST['o'] == 1 )
{
	echo "showOText();\r\n";
}
echo "</script>";
?>
⌨️ 快捷键说明

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