📄 search_result.php

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

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "search_data.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";
echo "<s";
echo "cript src=\"/inc/common.js\"></script>\r\n";
echo "<s";
echo "cript src=\"/inc/base64.js\"></script>\r\n";
echo "<s";
echo "cript>\r\n\r\n\r\nfunction openRpPic(){\r\n\r\n\tvar formname\t\t= \"fieldform\";\r\n\tvar objForm\t\t\t= document.forms[formname];\r\n\r\n\tvar reportstr;\r\n\tvar reportstr_1=\"\";\r\n\tvar reportstr_2=\"\";\r\n\tvar reportstr_3=\"\";\r\n\r\n\tvar type = \"\";\r\n\tvar itemid = \"\";\r\n\tvar objFieldName;\r\n\tvar objFieldValue;\r\n\r\n    var len = objForm.length;\r\n    for (var i = 0; i < len; i++){\r\n\t\tif (objForm.elements[i].type == \"radio\"){\r\n\t\t\tvar objR";
echo "adio = objForm.elements[i];\r\n\t\t\tif(objRadio.checked == true){\r\n\t\t\t\t\r\n\t\t\t\ttype = objRadio.value;\r\n\t\t\t}\r\n\t\t}\r\n\t}\r\n\r\n\t\r\n\tif(type == \"\"){\r\n\t\talert(\"请选择报表方式\");\r\n\t\treturn;\r\n\t\r\n\t}\r\n\t\r\n\r\n    for (var i = 0; i < len; i++){\r\n\t\tif(objForm.elements[i].type == \"checkbox\"){\r\n\t\t\tif(objForm.elements[i].checked == true){\r\n\t\t\t\tif(objForm.elements[i].id != type){\r\n\t\t\t\t\titemid =  objForm.elements[i].id.replace(";
echo "\"field_check\"+type,\"\");\r\n\t\t\t\t\tobjFieldName  = document.getElementById(\"field_name\"+type+itemid);\r\n\t\t\t\t\tobjFieldValue = document.getElementById(\"field_value\"+type+itemid);\r\n\t\t\t\t\treportstr_1 += objFieldName.value+\";\";\r\n\t\t\t\t\treportstr_2 += objFieldValue.value+\";\";\r\n\t\t\t\t\treportstr_3 += \"1;\";\r\n\t\t\t\t\t\r\n\t\t\t\t}\r\n\t\t\t}\r\n\t\t}\r\n\t}\r\n\r\n\r\n\treportstr = reportstr_1+\"|\"+reportstr_2+\"|\"+reportstr_3;\r\n\r\n\t\r\n\tvar redirect";
echo "Url = \"/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 = \"top=\"+top+\",\" ; \r\n\tszFeatures +=\"left=\"+left+\",\" ;\r\n\tszFeatures +=\"width=\"+width+\",\" ;\r\n\tszFeatures +=\"height=\"+height+\",\" ; \r\n\tszFeatures +=\"directories=no,\" ;\r";
echo "\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</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\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";
echo "=\"/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=\"openRpPic();\"><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> <BUTTON class=btn onClick=\"javscript:history.back();\" title=\"返回\"><table><tr valign=top ><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=\"30%\">字段名</td>\r\n\t\t<td width=\"20%\">数值</td>\r\n\t\t<td>选择</td>\r\n\t</tr>\r\n\t<tr class=\"tableline2\">\r\n\t\t<td ><input type=\"radio\" name=\"radio_report\" id=\"radio_ct_report\" value=\"_ct_\" onclick=\"che";
echo "ckRadio()\">客户状态</td>\r\n\t\t<td >&nbsp;</td>\r\n\t\t<td >&nbsp;</td>\r\n\t\t<td><input type=\"checkbox\" value=\"1\" id=\"_ct_\"\r\n\t\tonclick=\"checkBox('_ct_')\" disabled=\"none\">全选</td>\r\n\t</tr>\r\n\r\n\t<tr id=\"table_ct_tr\" style=\"display:none\">\r\n\t\t<td colspan=\"4\">\r\n\t\t<table border=\"0\" width=\"100%\" cellspacing=\"0\"  cellpadding=\"0\">\r\n";
if ( is_array( $arrayDataCT ) )
{
	while ( list( $key, $var ) = each( $arrayDataCT ) )
	{
		$fieldname = $var['FIELD_NAME'];
		if ( $fieldname == "" )
		{
			$fieldname = "未知";
		}
		$fieldvalue = $var['FIELD_VALUE'];
		if ( $key % 2 == 0 )
		{
			$trclass = "tableline1";
		}
		else
		{
			$trclass = "tableline2";
		}
		echo "\t\t<tr class=\"";
		echo $trclass;
		echo "\">\r\n\t\t\t<td width=\"30%\">&nbsp;</td>\r\n\t\t\t<td width=\"30%\">";
		echo $fieldname;
		echo "<input type=\"hidden\" value=\"";
		echo $fieldname;
		echo "\" id=\"field_name_ct_";
		echo $key;
		echo "\"></td>\r\n\t\t\t<td width=\"20%\">";
		echo $fieldvalue;
		echo "<input type=\"hidden\" value=\"";
		echo $fieldvalue;
		echo "\" id=\"field_value_ct_";
		echo $key;
		echo "\"></td>\r\n\t\t\t<td><input type=\"checkbox\" value=\"1\" id=\"field_check_ct_";
		echo $key;
		echo "\" onclick=\"checkSelf(this,'_ct_')\"></td>\r\n\t\t</tr>\r\n\r\n\t";
	}
}
echo "\t\t</table>\r\n\t\t</td>\r\n\t</tr>\r\n\r\n\t<tr class=\"tableline2\">\r\n\t\t<td><input type=\"radio\" name=\"radio_report\" id=\"radio_cs_report\" value=\"_cs_\" onclick=\"checkRadio()\">规模</td>\r\n\t\t<td>&nbsp;</td>\r\n\t\t<td>&nbsp;</td>\r\n\t\t<td><input type=\"checkbox\" value=\"1\" id=\"_cs_\"\r\n\t\tonclick=\"checkBox('_cs_')\" disabled=\"none\">全选</td>\r\n\t</tr>\r\n\r\n\r\n\t<tr id=\"table_cs_tr\" style=\"display:none\">\r\n\t\t<td colspan=\"4\">\r\n\t\t<table border=\"0\" width=";
echo "\"100%\" cellspacing=\"0\"  cellpadding=\"0\">\r\n";
if ( is_array( $arrayDataCS ) )
{
	while ( list( $key, $var ) = each( $arrayDataCS ) )
	{
		$fieldname = $var['FIELD_NAME'];
		if ( $fieldname == "" )
		{
			$fieldname = "未知";
		}
		$fieldvalue = $var['FIELD_VALUE'];
		if ( $key % 2 == 0 )
		{
			$trclass = "tableline1";
		}
		else
		{
			$trclass = "tableline2";
		}
		echo "\t\t<tr class=\"";
		echo $trclass;
		echo "\">\r\n\t\t\t<td width=\"30%\">&nbsp;</td>\r\n\t\t\t<td width=\"30%\">";
		echo $fieldname;
		echo "<input type=\"hidden\" value=\"";
		echo $fieldname;
		echo "\" id=\"field_name_cs_";
		echo $key;
		echo "\"></td>\r\n\t\t\t<td width=\"20%\">";
		echo $fieldvalue;
		echo "<input type=\"hidden\" value=\"";
		echo $fieldvalue;
		echo "\" id=\"field_value_cs_";
		echo $key;
		echo "\"></td>\r\n\t\t\t<td><input type=\"checkbox\" value=\"1\" id=\"field_check_cs_";
		echo $key;
		echo "\" onclick=\"checkSelf(this,'_cs_')\"></td>\r\n\t\t</tr>\r\n\r\n\t";
	}
}
echo "\t\t</table>\r\n\t\t</td>\r\n\t</tr>\r\n\r\n\t<tr class=\"tableline2\">\r\n\t\t<td><input type=\"radio\" name=\"radio_report\" id=\"radio_mn_report\" value=\"_mn_\" onclick=\"checkRadio()\">客户经理</td>\r\n\t\t<td>&nbsp;</td>\r\n\t\t<td>&nbsp;</td>\r\n\t\t<td><input type=\"checkbox\" value=\"1\" id=\"_mn_\"\r\n\t\tonclick=\"checkBox('_mn_')\" disabled=\"none\">全选</td>\r\n\t</tr>\r\n\r\n\t<tr id=\"table_mn_tr\" style=\"display:none\">\r\n\t\t<td colspan=\"4\">\r\n\t\t<table border=\"0\" widt";
echo "h=\"100%\" cellspacing=\"0\"  cellpadding=\"0\">\r\n\r\n";
if ( is_array( $arrayDataMN ) )
{
	while ( list( $key, $var ) = each( $arrayDataCS ) )
	{
		$fieldname = $var['FIELD_NAME'];
		if ( $fieldname == "" )
		{
			$fieldname = "未知";
		}
		$fieldvalue = $var['FIELD_VALUE'];
		if ( $key % 2 == 0 )
		{
			$trclass = "tableline1";
		}
		else
		{
			$trclass = "tableline2";
		}
		echo "\t\t<tr class=\"";
		echo $trclass;
		echo "\">\r\n\t\t\t<td width=\"30%\">&nbsp;</td>\r\n\t\t\t<td width=\"30%\">";
		echo $fieldname;
		echo "<input type=\"hidden\" value=\"";
		echo $fieldname;
		echo "\" id=\"field_name_mn_";
		echo $key;
		echo "\"></td>\r\n\t\t\t<td width=\"20%\">";
		echo $fieldvalue;
		echo "<input type=\"hidden\" value=\"";
		echo $fieldvalue;
		echo "\" id=\"field_value_mn_";
		echo $key;
		echo "\"></td>\r\n\t\t\t<td><input type=\"checkbox\" value=\"1\" id=\"field_check_mn_";
		echo $key;
		echo "\" onclick=\"checkSelf(this,'_mn_')\"></td>\r\n\t\t</tr>\r\n\r\n\t";
	}
}
echo "\t\t</table>\r\n\t\t</td>\r\n\t</tr>\r\n\r\n\t<tr class=\"tableline2\">\r\n\t\t<td><input type=\"radio\" name=\"radio_report\" id=\"radio_ca_report\"  value=\"_ca_\" onclick=\"checkRadio()\">省份</td>\r\n\t\t<td>&nbsp;</td>\r\n\t\t<td>&nbsp;</td>\r\n\t\t<td><input type=\"checkbox\" value=\"1\" id=\"_ca_\"\r\n\t\tonclick=\"checkBox('_ca_')\" disabled=\"none\">全选</td>\r\n\t</tr>\r\n\r\n\t<tr id=\"table_ca_tr\" style=\"display:none\">\r\n\t\t<td colspan=\"4\">\r\n\t\t<table border=\"0\" width=\"";
echo "100%\" cellspacing=\"0\"  cellpadding=\"0\">\r\n";
if ( is_array( $arrayDataCA ) )
{
	while ( list( $key, $var ) = each( $arrayDataMN ) )
	{
		$fieldname = $var['FIELD_NAME'];
		if ( $fieldname == "" )
		{
			$fieldname = "未知";
		}
		$fieldvalue = $var['FIELD_VALUE'];
		if ( $key % 2 == 0 )
		{
			$trclass = "tableline1";
		}
		else
		{
			$trclass = "tableline2";
		}
		echo "\t\t<tr class=\"";
		echo $trclass;
		echo "\">\r\n\t\t\t<td width=\"30%\">&nbsp;</td>\r\n\t\t\t<td width=\"30%\">";
		echo $fieldname;
		echo "<input type=\"hidden\" value=\"";
		echo $fieldname;
		echo "\" id=\"field_name_ca_";
		echo $key;
		echo "\"></td>\r\n\t\t\t<td width=\"20%\">";
		echo $fieldvalue;
		echo "<input type=\"hidden\" value=\"";
		echo $fieldvalue;
		echo "\" id=\"field_value_ca_";
		echo $key;
		echo "\"></td>\r\n\t\t\t<td><input type=\"checkbox\" value=\"1\" id=\"field_check_ca_";
		echo $key;
		echo "\" onclick=\"checkSelf(this,'_ca_')\"></td>\r\n\t\t</tr>\r\n\r\n\t";
	}
}
echo "\t\t</table>\r\n\t\t</td>\r\n\t</tr>\r\n\r\n</form>\r\n</table>\r\n<br>\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\"  cellpadding=\"2\">\r\n\t<tr class=\"tableline2\">\r\n\t\t<td>说明：</td>\r\n\t</tr>\r\n\t<tr class=\"tableline1\">\r\n\t\t<td>&nbsp;&nbsp;&nbsp;&nbsp;流程表单字段对应的值是搜索结果所有数据的累加。\r\n</td>\r\n\t</tr>\r\n\t<tr class=\"tableline1\">\r\n\t\t<td>&nbsp;&nbsp;&nbsp;&nbsp;此处统计只针对数值统计，如果值是字符，此处统计值以0标识。</td>\r\n\t</tr";
echo ">\r\n\t<tr class=\"tableline1\">\r\n\t\t<td>&nbsp;&nbsp;&nbsp;&nbsp;流程表单字段对应的值是0，此处统计值仍以0标识。</td>\r\n\t</tr>\r\n</table>\r\n</body>\r\n</html>\r\n";
echo "<s";
echo "cript language=\"JavaScript\">\r\nvar formname\t\t= \"fieldform\";\r\nvar objForm\t\t\t= document.forms[formname];\r\nvar bgColor         = \"#d6d6d6\";\r\nfunction checkRadio(){\r\n\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\ttrStyle.backgroundColor = \"\";\r\n\t\t\tobjForm.elemen";
echo "ts[i].checked = false;\r\n\t\t}\r\n\t\tif (objForm.elements[i].type == \"radio\"){\r\n\t\t\tvar objRadio = objForm.elements[i];\r\n\t\t\tvar type = objRadio.value;\r\n\t\t\tvar objThisAllItem = document.getElementById(type);\r\n\t\t\tvar objTable = document.getElementById(\"table\"+type+\"tr\");\r\n\t\t\tif(objRadio.checked == true){\r\n\r\n\t\t\t\tobjThisAllItem.disabled = \"\";\r\n\t\t\t\tobjTable.style.display = \"\";\r\n\t\t\t}\r\n\t\t\telse{\r\n\t\t\t\t\r\n\t\t\t\tvar o";
echo "bjThisAllItem = document.getElementById(type);\r\n\t\t\t\tvar trPaStyle = objThisAllItem.parentElement.parentElement.style;\r\n\t\t\t\t\r\n\t\t\t\ttrPaStyle.backgroundColor = \"\";\r\n\r\n\t\t\t\tobjThisAllItem.disabled = \"none\";\r\n\t\t\t\tobjTable.style.display = \"none\";\r\n\r\n\r\n\t\t\t\r\n\t\t\t}\r\n\t\t}\r\n\t}\r\n\r\n\r\n\r\n}\r\n\r\nfunction checkSelf(obj,type){\r\n\tvar trStyle = obj.parentElement.parentElement.style;\r\n\tvar objThisAllItem = document.getElem";
echo "entById(type);\r\n\tvar trPaStyle = objThisAllItem.parentElement.parentElement.style;\r\n\ttrStyle.backgroundColor = bgColor;\r\n\tif(obj.checked == false){\r\n\t\tobjThisAllItem.checked = false;\r\n\t\ttrStyle.backgroundColor = \"\";\r\n\t\ttrPaStyle.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";
echo "\n\t\t\tvar trStyle = objForm.elements[i].parentElement.parentElement.style;\r\n\t\t\t\r\n\t\t\tif(type == \"all\"){\r\n\t\t\t\tif (objAllcheckid.checked == true){\r\n\t\t\t\t\tobjForm.elements[i].checked = true;\r\n\t\t\t\t\ttrStyle.backgroundColor = bgColor;\r\n\t\t\t\t}\r\n\t\t\t\telse{\r\n\t\t\t\t\tobjForm.elements[i].checked = false;\r\n\t\t\t\t\ttrStyle.backgroundColor = \"\";\r\n\t\t\t\t}\r\n\t\t\t}\r\n\r\n\t\t\telse{\r\n\t\t\t\tvar objThisAllItem = document.getElementById(typ";
echo "e);\r\n\t\t\t\tvar elementid = objForm.elements[i].id\r\n\t\t\t\tif(elementid.indexOf(type) != -1){\r\n\t\t\t\t\tif (objThisAllItem.checked == true){\r\n\t\t\t\t\t\tobjForm.elements[i].checked = true;\r\n\t\t\t\t\t\ttrStyle.backgroundColor = bgColor;\r\n\t\t\t\t\t}\r\n\t\t\t\t\telse{\r\n\t\t\t\t\t\tobjForm.elements[i].checked = false;\r\n\t\t\t\t\t\ttrStyle.backgroundColor = \"\";\r\n\t\t\t\t\t}\r\n\t\t\t\t}\r\n\t\t\t}\r\n\t\t}\r\n    }\r\n}\r\n\r\n</script>\r\n";
?>
⌨️ 快捷键说明

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