📄 index.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/function_page_01.php" );
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\n\r\nfunction showExample(){\r\n\r\n\tvar objDivID = document.getElementById('popupExampleCon');\r\n\tvar objDivPopup = document.getElementById('popupExampleId');\r\n\tvar objOtext = document.getElementById('loadtext');\r\n\r\n var popupX = 0;\r\n var popupY = 0; \r\n contentBox = document.getElementById(\"popupExampleId\");\r\n var o = event.srcElement;\r\n while(o.tagName!=\"BODY\"){\r\n popupX += ";
echo "o.offsetLeft;\r\n\t popupY += o.offsetTop;\r\n\t o = o.offsetParent;\r\n\t}\r\n\r\n\tobjDivPopup.style.left=popupX-100;\r\n\tobjDivPopup.style.top=popupY;\r\n\r\n\tobjDivPopup.style.display=\"\";\r\n\r\n\r\n\tobjOtext.innerHTML = \" 加载图标...\";\r\n\t\r\n\tvar saveGimgIcon = {\r\n\t\tonCreate: function(){\r\n\t\t\tElement.show('loadimgid');\r\n\t\t},\r\n\t\tonComplete: function() {\r\n\t\t\tif(Ajax.activeRequestCount == 0){\r\n\t\t\t\tElement.hide('loadimgi";
echo "d');\r\n\t\t\t}\r\n\t\t}\r\n\t};\r\n\tAjax.Responders.register(saveGimgIcon);\t\r\n\r\n\t\r\n\turl = \"csv_example.php\";\r\n\tqueryString = \"\";\r\n\r\n\tnew Ajax.Request\r\n\t(\r\n\t\turl,\r\n\t\t{\r\n\t\t\tmethod: \"post\",\t\r\n\t\t\tonSuccess : function(resp)\r\n\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\tobjDivID.innerHTML = resp.responseText;\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t},\r\n\t\t\tonFailure : function()\r\n\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\talert(url);\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t},\r\n\t\t\tparameters : queryString\r\n\t\t}\r";
echo "\n\t);\r\n\r\n\t \r\n}\r\n\r\n\r\n\r\n\r\nfunction checkIsCsv(){\r\n\tvar objFile = document.form1.ATTACHMENT;\r\n\tvar allowExt = \".csv|.txt|\";\r\n\tvar thisExt;\r\n\tif (objFile.value != \"\"){\r\n\t\tthisExt = objFile.value.substr(objFile.value.lastIndexOf(\".\")).toLowerCase();\r\n\t\tif (allowExt.indexOf(thisExt+\"|\") == -1){\r\n\t\t\tobjFile.value = \"\";\r\n\t\t\tobjFile.focus();\r\n\t\t\tobjFile.select();\r\n\t\t\treturn false;\r\n\t\t}\r\n\t}\r\n\r\n\tvar file_te";
echo "mp=document.form1.ATTACHMENT.value,file_name;\r\n\tvar Pos;\r\n\tPos=file_temp.lastIndexOf(\"\\\\\");\r\n\tfile_name=file_temp.substring(Pos+1,file_temp.length);\r\n\tdocument.form1.ATTACHMENT_NAME.value=file_name;\r\n\r\n\treturn true;\r\n\r\n}\r\n\r\n\r\n\r\nfunction CheckForm(){\r\n\r\n\tif (document.form1.ATTACHMENT.value == \"\"){\r\n\t\talert(\"请选择文件!\");\r\n\t\treturn false;\r\n\t}\r\n\tif (!checkIsCsv()){\r\n\t\talert(\"文件类型应该是CSV或者TX";
echo "T类型的!\");\r\n\t\treturn false;\r\n\t\r\n\t}\r\n\r\n\treturn (true);\r\n}\r\n\r\nfunction submitForm(){\r\n\tif(CheckForm())\r\n\t\tdocument.form1.submit();\r\n\telse\r\n\t\treturn false;\r\n}\r\n\r\n\r\nfunction loadingImg(f,divid){\r\n\tvar actionUrl = \"img_hrm_report.php\";\r\n\tvar formName = \"reportform\";\r\n\tvar objDivID = document.getElementById(divid);\r\n\tif(objDivID.style.display == ''){\r\n\t\tobjDivID.style.display = 'none';\r\n\t\treturn;\r\n\t}\r";
echo "\n\t\r\n\tvar saveGimg = {\r\n\t\tonCreate: function(){\r\n\t\t\tElement.show('divsave');\r\n\t\t},\r\n\t\tonComplete: function() {\r\n\t\t\tif(Ajax.activeRequestCount == 0){\r\n\t\t\t\tElement.hide('divsave');\r\n\t\t\t}\r\n\t\t}\r\n\t};\r\n\tAjax.Responders.register(saveGimg);\t\r\n\t\r\n\tqueryString = \"f=\" + f;\r\n\tnew Ajax.Request\r\n\t(\r\n\t\tactionUrl,\r\n\t\t{\r\n\t\t\tmethod: \"post\",\t\r\n\t\t\tonSuccess : function(resp)\r\n\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\tobjDivID.style.display = ''";
echo ";\r\n\t\t\t\t\t\t\t\$(divid).innerHTML = resp.responseText;\r\n\t\t\t\t\t\t},\r\n\t\t\tonFailure : function()\r\n\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\t//alert(f);\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t},\r\n\t\t\tparameters : queryString\r\n\t\t}\r\n\t);\r\n\r\n}\r\n\r\n\r\n</script>\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 <tr class=\"tablehead1\">\r\n <td><img src=\"/images/workflow.gif\" align=\"absmiddle\"> 外部数据导入报表</td>\r\n </tr>\r\n <tr class=\"tablehead2\">\r\n <td><BUTTON class=btn onclick=\"submitForm();\"><table><tr valign=mid";
echo "dle ><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 </tr>\r\n</table>\r\n<br>\r\n<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"\" cellpadding=\"5\">\r\n\t<form enctype=\"multipart/form-data\" action=\"do.php\" method=\"post\" name=\"form1\" onSubmit=\"return CheckForm();\">\r\n\t<input type=\"hidden\" name=\"f\" value=\"save\">\r\n\t<tr>\r\n\t\t<td class=\"TableLine2\" width=\"20%\">\r\n\t\t上传文件:\r\n\t\t</td>\r\n\t\t<td class=\"TableLine1\"";
echo "><input type=\"file\" name=\"ATTACHMENT\" size=\"30\" class=\"BigInput\" title=\"选择附件文件\"><input type=\"hidden\" name=\"ATTACHMENT_NAME\" maxlength=\"100\"> 文件类型是CSV或者TXT类型,内容格式请 ";
echo "<s";
echo "pan style=\"color:blue;text-decoration:underline;cursor:hand\" onclick=\"showExample()\">查看范例</span>\r\n\t\t</td>\r\n\t</tr>\r\n\t<tr>\r\n\t\t<td class=\"TableLine2\">\r\n\t\t说明:\r\n\t\t</td>\r\n\t\t<td class=\"TableLine1\">\r\n\t\t<input type=\"text\" name=\"REPORT_DF_NAME\" value=\"\" class=\"BigInput\">\r\n\t\t</td>\r\n\t</tr>\r\n\t</form>\r\n</table>\r\n\r\n<div id=\"popupExampleId\" style=\"display:none;position:absolute\">\r\n\t<div style=\"width:100%;padding:2px\">";
echo "<img src=\"/images/index_i/delete.gif\" class=\"imglink\" onclick=\"Element.hide('popupExampleId')\" title=\"关闭\" align=\"right\"></div>\r\n\t<div id=\"popupExampleCon\">\r\n\t</div>\r\n\t<div id=\"loadimgid\" style=\"width:100px\"><img src=\"/images/loading.gif\" align=\"absmiddle\">";
echo "<s";
echo "pan id=\"loadtext\" style=\"color:#333\"></span></div>\r\n</div>\r\n<br>\r\n<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"\" cellpadding=\"5\">\r\n\t<tr class=\"TableHeader\">\r\n\t\t<td width=\"20%\">说明\r\n\t\t</td>\r\n\t\t<td>文件名\r\n\t\t</td>\r\n\t\t<td>操作\r\n\t\t</td>\r\n\t</tr>\r\n";
$sql = "SELECT * FROM report_define WHERE USER_ID='".$_SESSION['LOGIN_USER_ID']."' ORDER BY REPORT_DF_ID DESC";
$sql = page( $sql, 10 );
$rs = exequery( $connection, $sql );
while ( $row = mysql_fetch_array( $rs ) )
{
$reportdf_id = $row['REPORT_DF_ID'];
$reportdf_name = $row['REPORT_DF_NAME'];
$attachment_name = $row['ATTACHMENT_NAME'];
echo "\r\n\t<tr class=\"tableline2\">\r\n\t\t<td width=\"20%\">\r\n";
echo $reportdf_name;
echo "\t\t</td>\r\n\t\t<td>";
echo $attachment_name;
echo "\t\t</td>\r\n\t\t<td><a href=\"report_attach.php?REPORT_DF_ID=";
echo $reportdf_id;
echo "\">图形分析</a> <a onClick=\"return confirm('您确定删除吗?')\" href=\"do.php?f=del&REPORT_DF_ID=";
echo $reportdf_id;
echo "\">删除</a>\r\n\t\t</td>\r\n\t</tr>\r\n";
}
echo "</table>\r\n<table width=\"100%\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\">\r\n <tr>\r\n <td align=\"right\">";
disp( );
echo "</td>\r\n </tr>\r\n</table>\r\n\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -