excel_upload_old.jsp 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331
  1. <%@ page language="java" import="java.util.*"
  2. contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
  3. <%@include file="/context/mytags.jsp"%>
  4. <!DOCTYPE html>
  5. <html>
  6. <head>
  7. <title>Excel导入personnelBaseArchivesManageController</title>
  8. <script type="text/javascript" src="plug-in/mutiLang/zh-cn.js"></script>
  9. <script type="text/javascript" src="plug-in/jquery/jquery-1.9.0.js"></script>
  10. <script type="text/javascript" src="plug-in/jquery/jquery.cookie.js"></script>
  11. <script type="text/javascript"
  12. src="plug-in/jquery-plugs/storage/jquery.storageapi.min.js"></script>
  13. <script type="text/javascript" src="plug-in/tools/dataformat.js"></script>
  14. <link id="easyuiTheme" rel="stylesheet"
  15. href="plug-in/easyui/themes/metrole/easyui.css" type="text/css"></link>
  16. <link id="easyuiTheme" rel="stylesheet"
  17. href="plug-in/easyui/themes/metrole/main.css" type="text/css"></link>
  18. <link id="easyuiTheme" rel="stylesheet"
  19. href="plug-in/easyui/themes/metrole/icon.css" type="text/css"></link>
  20. <link rel="stylesheet" type="text/css"
  21. href="plug-in/accordion/css/accordion.css">
  22. <link rel="stylesheet" type="text/css"
  23. href="plug-in/accordion/css/icons.css">
  24. <script type="text/javascript"
  25. src="plug-in/easyui/jquery.easyui.min.1.3.2.js"></script>
  26. <script type="text/javascript" src="plug-in/easyui/locale/zh-cn.js"></script>
  27. <script type="text/javascript" src="plug-in/tools/syUtil.js"></script>
  28. <script type="text/javascript"
  29. src="plug-in/easyui/extends/datagrid-scrollview.js"></script>
  30. <link rel="stylesheet" href="plug-in/tools/css/metrole/common.css"
  31. type="text/css"></link>
  32. <link rel="stylesheet" href="plug-in/ace/css/font-awesome.css"
  33. type="text/css"></link>
  34. <script type="text/javascript"
  35. src="plug-in/lhgDialog/lhgdialog.min.js?skin=metrole"></script>
  36. <script type="text/javascript" src="plug-in/ace/js/bootstrap-tab.js"></script>
  37. <script type="text/javascript" src="plug-in/layer/layer.js"></script>
  38. <script type="text/javascript" src="plug-in/tools/curdtools_zh-cn.js"></script>
  39. <script type="text/javascript"
  40. src="plug-in/tools/common_workflow_zh-cn.js"></script>
  41. <script type="text/javascript"
  42. src="plug-in/tools/common_method_zh-cn.js"></script>
  43. <script type="text/javascript" src="plug-in/tools/easyuiextend.js"></script>
  44. <script type="text/javascript"
  45. src="plug-in/jquery-plugs/hftable/jquery-hftable.js"></script>
  46. <script type="text/javascript" src="plug-in/tools/json2.js"></script>
  47. </head>
  48. <body style="overflow-y: hidden" scroll="no">
  49. <div id="content">
  50. <!-- <div id="wrapper"> -->
  51. <div id="steps">
  52. <form id="formobj" action="null" name="formobj" method="post">
  53. <input type="hidden" id="btn_sub" class="btn_sub" />
  54. <fieldset class="step">
  55. <div class="form" style="width: 97%;">
  56. <link rel="stylesheet" href="plug-in/uploadify/css/uploadify.css"
  57. type="text/css"></link>
  58. <script type="text/javascript"
  59. src="plug-in/uploadify/jquery.uploadify-3.1.js"></script>
  60. <script type="text/javascript" src="plug-in/tools/Map.js"></script>
  61. <script type="text/javascript">
  62. var flag = false;
  63. var fileitem = "";
  64. var fileKey = "";
  65. var serverMsg = "";
  66. var uploadsuccessflag = false;
  67. var m = new Map();
  68. $(function() {
  69. $('#file_upload')
  70. .uploadify(
  71. {
  72. buttonText : '选择要导入的文件',
  73. auto : false,
  74. progressData : 'speed',
  75. multi : true,
  76. height : 25,
  77. overrideEvents : [ 'onDialogClose' ],
  78. fileTypeDesc : '文件格式:',
  79. queueID : 'filediv',
  80. fileTypeExts : '*.xls;*.xlsx',
  81. fileSizeLimit : '15MB',
  82. swf : 'plug-in/uploadify/uploadify.swf',
  83. uploader : 'personnelBaseArchivesManageController.do?importExcel&sessionId=6DE43FF347ED6C4AFD93375CC8716FC9',
  84. onUploadStart : function(
  85. file) {
  86. var documentTitle = $(
  87. '#documentTitle')
  88. .val();
  89. $('#file_upload')
  90. .uploadify(
  91. "settings",
  92. "formData",
  93. {
  94. 'documentTitle' : documentTitle
  95. });
  96. },
  97. onQueueComplete : function(
  98. queueData) {
  99. if (uploadsuccessflag) {
  100. var win = frameElement.api.opener;
  101. win
  102. .reloadTable();
  103. win
  104. .tip(serverMsg);
  105. if ('undefined' != typeof subDlgIndex) {
  106. if (subDlgIndex != null) {
  107. $(
  108. '#infoTable-loading')
  109. .hide();
  110. subDlgIndex
  111. .close();
  112. }
  113. }
  114. frameElement.api
  115. .close();
  116. } else {
  117. }
  118. },
  119. onUploadSuccess : function(
  120. file, data,
  121. response) {
  122. var d = data; // ------ $.parseJSON(data);
  123. zhaohual(d);
  124. uploadsuccessflag = d.success;
  125. serverMsg = d.msg;
  126. if (d.success) {
  127. var win = frameElement.api.opener;
  128. }
  129. },
  130. onFallback : function() {
  131. tip("您未安装FLASH控件,无法上传图片!请安装FLASH控件后再试")
  132. },
  133. onSelectError : function(
  134. file,
  135. errorCode,
  136. errorMsg) {
  137. switch (errorCode) {
  138. case -100:
  139. tip("上传的文件数量已经超出系统限制的"
  140. + $(
  141. '#file_upload')
  142. .uploadify(
  143. 'settings',
  144. 'queueSizeLimit')
  145. + "个文件!");
  146. break;
  147. case -110:
  148. tip("文件 ["
  149. + file.name
  150. + "] 大小超出系统限制的"
  151. + $(
  152. '#file_upload')
  153. .uploadify(
  154. 'settings',
  155. 'fileSizeLimit')
  156. + "大小!");
  157. break;
  158. case -120:
  159. tip("文件 ["
  160. + file.name
  161. + "] 大小异常!");
  162. break;
  163. case -130:
  164. tip("文件 ["
  165. + file.name
  166. + "] 类型不正确!");
  167. break;
  168. }
  169. },
  170. onUploadProgress : function(
  171. file,
  172. bytesUploaded,
  173. bytesTotal,
  174. totalBytesUploaded,
  175. totalBytesTotal) {
  176. }
  177. });
  178. });
  179. function upload() {
  180. $('#file_upload').uploadify('upload', '*');
  181. return flag;
  182. }
  183. function cancel() {
  184. $('#file_upload').uploadify('cancel', '*');
  185. }
  186. </script>
  187. <span id="file_uploadspan"><input type="file" name="fiels"
  188. id="file_upload" /></span>
  189. </div>
  190. <div class="form" id="filediv" ></div>
  191. <script type="text/javascript">
  192. $(function(){
  193. $("#filediv").attr("style","height:300px;overflow:auto;width: 97%;");
  194. $("#filediv").parent("td").attr("style","width: 650px; height: 400px;");
  195. });
  196. </script>
  197. </fieldset>
  198. <link rel="stylesheet"
  199. href="plug-in/Validform/css/metrole/divfrom.css" type="text/css" />
  200. <link rel="stylesheet"
  201. href="plug-in/Validform/css/metrole/style.css" type="text/css" />
  202. <link rel="stylesheet"
  203. href="plug-in/Validform/css/metrole/tablefrom.css" type="text/css" />
  204. <script type="text/javascript"
  205. src="plug-in/Validform/js/Validform_v5.3.1_min_zh-cn.js"></script>
  206. <script type="text/javascript"
  207. src="plug-in/Validform/js/Validform_Datatype_zh-cn.js"></script>
  208. <script type="text/javascript"
  209. src="plug-in/Validform/js/datatype_zh-cn.js"></script>
  210. <script src="plug-in/layer/layer.js"></script>
  211. <script type="text/javascript">
  212. var subDlgIndex = null;
  213. $(function() {
  214. $("#formobj")
  215. .Validform(
  216. {
  217. tiptype : 4,
  218. btnSubmit : "#btn_sub",
  219. btnReset : "#btn_reset",
  220. ajaxPost : true,
  221. tipSweep : false,
  222. beforeSubmit : function(curform) {
  223. var tag = false;
  224. var myflag = upload(curform);
  225. if (myflag) {
  226. subDlgIndex = $
  227. .dialog({
  228. content : '正在加载中',
  229. zIndex : 19910320,
  230. lock : true,
  231. width : 100,
  232. height : 50,
  233. opacity : 0.3,
  234. title : '提示',
  235. cache : false
  236. });
  237. var infoTable = subDlgIndex.DOM.t
  238. .parent()
  239. .parent()
  240. .parent();
  241. infoTable
  242. .parent()
  243. .append(
  244. '<div id="infoTable-loading" style="text-align:center;"><img src="plug-in/layer/skin/default/loading-0.gif"/></div>');
  245. infoTable.css(
  246. 'display',
  247. 'none');
  248. return true;
  249. } else {
  250. return false;
  251. }
  252. },
  253. callback : function(data) {
  254. if (subDlgIndex
  255. && subDlgIndex != null) {
  256. $('#infoTable-loading')
  257. .hide();
  258. subDlgIndex.close();
  259. }
  260. var win = frameElement.api.opener;
  261. if (data.success == true) {
  262. frameElement.api
  263. .close();
  264. win.tip(data.msg);
  265. } else {
  266. if (data.responseText == ''
  267. || data.responseText == undefined) {
  268. $.messager.alert(
  269. '错误',
  270. data.msg);
  271. $.Hidemsg();
  272. } else {
  273. try {
  274. var emsg = data.responseText
  275. .substring(
  276. data.responseText
  277. .indexOf('错误描述'),
  278. data.responseText
  279. .indexOf('错误信息'));
  280. $.messager
  281. .alert(
  282. '错误',
  283. emsg);
  284. $.Hidemsg();
  285. } catch (ex) {
  286. $.messager
  287. .alert(
  288. '错误',
  289. data.responseText
  290. + "");
  291. $.Hidemsg();
  292. }
  293. }
  294. return false;
  295. }
  296. win.reloadTable();
  297. }
  298. });
  299. });
  300. </script>
  301. </form>
  302. </div>
  303. <!-- </div> -->
  304. </div>
  305. <script type="text/javascript">
  306. function zhaohual(d) {
  307. // console.log(d);
  308. if(d.success==false){
  309. if(d.msg=="导入模板错误"){
  310. layer.alert(d.msg);
  311. }else if(d.msg=="文件导入失败,请查看日志" || d.msg=="导入模板数据错误"){
  312. layer.alert(d.msg);
  313. // window.location.href="export/template/员工基本档案列表.xls";
  314. var downsrc = d.obj;
  315. // var downsrc = "tSysFileController/showOrDownByurl.do?dbPath="
  316. // + fileUrl + '&down=1';
  317. // var downsrc = "tSysFileController/aliyunshowOrDownByurl.do?dbPath="
  318. // + fileUrl + '&down=1';
  319. location.href = downsrc;
  320. }else{
  321. layer.alert(d.msg);
  322. }
  323. }
  324. }
  325. </script>
  326. </body>
  327. </html>