📄 report_attach.php

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

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/csv.php" );
$sql = "SELECT * FROM report_define WHERE REPORT_DF_ID=".$_REQUEST['REPORT_DF_ID'];
$rs = exequery( $connection, $sql );
$row = mysql_fetch_array( $rs );
$ATTACHMENT_ID = $row['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $row['ATTACHMENT_NAME'];
$csv_file = $ATTACH_PATH.$ATTACHMENT_ID."/".$ATTACHMENT_NAME;
$csv = new csv( );
$csv->file = $csv_file;
$csv->spot = ",";
$csv->open( 0 );
$rows = $csv->rows( );
$field = $csv->getfield( );
$i = 0;
for ( ;	$i <= count( $field ) - 1;	++$i	)
{
	$field[$i];
}
$fieldtotal = count( $field );
while ( $record = $csv->getrecord( ) )
{
	$i = 0;
	for ( ;	$i < $fieldtotal;	++$i	)
	{
		$arrayData[$i]['FIELD_NAME'] = $field[$i];
		$arrayData[$i]['FIELD_VALUE'] += $record[$i];
	}
}
echo "<html>\r\n<head>\r\n<title>报表</title>\r\n<LINK href=\"/theme/1/style.css\" type=text/css rel=stylesheet>\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</head>\r\n";
echo "<s";
echo "tyle type=\"text/css\">\r\n#popupExampleId{\r\n\tborder: 1px solid #A2C7D9;\r\n\tbackground-color: #F1F7F9;\r\n\tpadding:5px;\r\n\twidth: 400px;\r\n\t\r\n}\r\n.imglink{\r\n\tcursor:hand;margin-right:2px;\r\n}\r\n</style>\r\n\r\n";
echo "<s";
echo "cript>\r\nvar field_name_array = new Array();\r\nvar field_value_array = new Array();\r\nvar field_check_array = new Array();\r\nvar field_checkid_array = new Array();\r\n";
while ( list( $key, $var ) = each( $arrayData ) )
{
	$fieldname = $var['FIELD_NAME'];
	$fieldvalue = $var['FIELD_VALUE'];
	echo "field_name_array[";
	echo $key;
	echo "] = \"";
	echo $fieldname;
	echo "\";\r\nfield_value_array[";
	echo $key;
	echo "] = \"";
	echo $fieldvalue;
	echo "\";\r\nfield_check_array[";
	echo $key;
	echo "] = 0;\r\n";
}
reset( $arrayData );
echo "\r\nfunction openRpPic(){\r\n\tvar arraylen = field_name_array.length;\r\n\tvar reportstr;\r\n\tvar reportstr_1=\"\";\r\n\tvar reportstr_2=\"\";\r\n\tvar reportstr_3=\"\";\r\n\tfor(var i=0;i<arraylen;i++){\r\n\t\tvar objCheckId = document.getElementById('field_check_'+i);\r\n\r\n\t\tif (objCheckId.checked != false){\r\n\t\t\treportstr_1 += field_name_array[i]+\";\";\r\n\t\t\treportstr_2 += field_value_array[i]+\";\";\r\n\t\t\treportstr_3 += \"1;\";\r\n\t\t}\r";
echo "\n\r\n\t}\r\n\treportstr = reportstr_1+\"|\"+reportstr_2+\"|\"+reportstr_3;\r\n\t\r\n\t//加密字符过多(可能有误) 2007-12-18 lxl\r\n\t//reportstr = encode64(reportstr);\r\n\t\r\n\tvar redirectUrl = \"/general/report/search_report_index.php?reportstr=\"+reportstr;\r\n\tvar distance = 400;\r\n\tvar width = screen.width-distance;\r\n\tvar height = screen.height-distance;\r\n\tvar top = distance/2 ;\r\n\tvar left = distance/2 ;\r\n\tvar szFeatures ";
echo "= \"top=\"+top+\",\" ; \r\n\tszFeatures +=\"left=\"+left+\",\" ;\r\n\tszFeatures +=\"width=\"+width+\",\" ;\r\n\tszFeatures +=\"height=\"+height+\",\" ; \r\n\tszFeatures +=\"directories=no,\" ;\r\n\tszFeatures +=\"status=1,\" ;\r\n\tszFeatures +=\"menubar=no,\" ;\r\n\r\n\tszFeatures +=\"scrollbars=yes,\" ;\r\n\tszFeatures +=\"resizable=yes\" ; //channelmode\r\n\r\n\r\n\tvar open_flag=window.open(redirectUrl,\"\",szFeatures);\r\n\r\n}\r\n</script>\r\n\r\n";
echo "<s";
echo "tyle>\r\ntd{\r\n\tvertical-align:top;\r\n}\r\n</style>\r\n<BODY onload=\"setVariables(); checkLocation('divsave',120,20,1);\" topmargin=\"5\">\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\"  cellpadding=\"0\">\r\n<form name=\"fieldform\">\r\n   <tr class=\"tablehead1\">\r\n    <td ><img src=\"/images/workflow.gif\"  align=\"absmiddle\">外部数据\r\n    </td>\r\n  </tr>\r\n\t\r\n\r\n  <tr class=\"tablehead2\">\r\n    <td><BUTTON class=btn onclick=\"openR";
echo "pPic();\"><table><tr valign=middle ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\"> 确 定</span></td></tr></table></BUTTON>\r\n  </td>\r\n  </tr>\r\n</table>\r\n<br>\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\"  cellpadding=\"5\">\r\n\t<tr class=\"tableheader\">\r\n\t\t<td width=\"30%\">字段名</td>\r\n\t\t<td width=\"50%\">数值</td>\r\n\t\t<td><input type=\"checkbox\" value=\"1\" id=\"allcheckid\"\r\n\t\tonclick=\"checkBox('all')\">选择</td>\r\n\t</tr>\r\n";
while ( list( $key, $var ) = each( $arrayData ) )
{
	$fieldname = $var['FIELD_NAME'];
	$fieldvalue = $var['FIELD_VALUE'];
	if ( $key % 2 == 0 )
	{
		$trclass = "tableline1";
	}
	else
	{
		$trclass = "tableline2";
	}
	echo "\t<tr class=\"";
	echo $trclass;
	echo "\">\r\n\t\t<td width=\"30%\">";
	echo $fieldname;
	echo "<input type=\"hidden\" value=\"";
	echo $fieldname;
	echo "\" id=\"field_name_";
	echo $key;
	echo "\"></td>\r\n\t\t<td width=\"50%\">";
	echo $fieldvalue;
	echo "<input type=\"hidden\" value=\"";
	echo $fieldvalue;
	echo "\" id=\"field_value_";
	echo $key;
	echo "\"></td>\r\n\t\t<td><input type=\"checkbox\" value=\"1\" id=\"field_check_";
	echo $key;
	echo "\" onclick=\"checkSelf(this)\"></td>\r\n\t</tr>\r\n\r\n";
}
echo "</form>\r\n</table>\r\n</body>\r\n\r\n\r\n</html>\r\n";
echo "<s";
echo "cript language=\"JavaScript\">\r\nvar formname\t\t= \"fieldform\";\r\nvar allcheckid\t\t= \"allcheckid\";\r\nvar objForm\t\t\t= document.forms[formname];\r\nvar objAllcheckid\t= document.getElementById('allcheckid');\r\nvar bgColor         = \"#d6d6d6\";\r\n\r\nfunction checkSelf(obj){\r\n\tvar trStyle = obj.parentElement.parentElement.style;\r\n\ttrStyle.backgroundColor = bgColor;\r\n\tif(obj.checked == false){\r\n\t\tobjAllcheckid.checke";
echo "d = false;\r\n\t\ttrStyle.backgroundColor = \"\";\r\n\t}\r\n}\r\n\r\nfunction checkBox(type){\r\n    var len = objForm.length;\r\n    for (var i = 0; i < len; i++){\r\n\t\tif (objForm.elements[i].type == \"checkbox\"){\r\n\t\t\tvar trStyle = objForm.elements[i].parentElement.parentElement.style;\r\n\t\t\t\r\n\t\t\tswitch(type){\r\n\t\t\t\tcase \"all\":\r\n\t\t\t\t\t\tif (objAllcheckid.checked == true){\r\n\t\t\t\t\t\t\tobjForm.elements[i].checked = true;\r\n\t\t\t\t\t\t";
echo "\ttrStyle.backgroundColor = bgColor;\r\n\t\t\t\t\t\t}\r\n\t\t\t\t\t\telse{\r\n\t\t\t\t\t\t\tobjForm.elements[i].checked = false;\r\n\t\t\t\t\t\t\ttrStyle.backgroundColor = \"\";\r\n\t\t\t\t\t\t}\r\n\t\t\t\t\tbreak;\r\n\t\t\t}\r\n\t\t}\r\n    }\r\n}\r\n\r\n\r\n</script>\r\n";
?>
⌨️ 快捷键说明

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