excel_upload.jsp 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165
  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/icon.css" type="text/css"></link>
  16. <link rel="stylesheet" type="text/css"
  17. href="plug-in/accordion/css/accordion.css">
  18. <link rel="stylesheet" type="text/css"
  19. href="plug-in/accordion/css/icons.css">
  20. <script type="text/javascript"
  21. src="plug-in/easyui/jquery.easyui.min.1.3.2.js"></script>
  22. <script type="text/javascript" src="plug-in/easyui/locale/zh-cn.js"></script>
  23. <script type="text/javascript" src="plug-in/tools/syUtil.js"></script>
  24. <script type="text/javascript"
  25. src="plug-in/easyui/extends/datagrid-scrollview.js"></script>
  26. <link rel="stylesheet" href="plug-in/tools/css/metrole/common.css"
  27. type="text/css"></link>
  28. <link rel="stylesheet" href="plug-in/ace/css/font-awesome.css"
  29. type="text/css"></link>
  30. <script type="text/javascript"
  31. src="plug-in/lhgDialog/lhgdialog.min.js?skin=metrole"></script>
  32. <script type="text/javascript" src="plug-in/ace/js/bootstrap-tab.js"></script>
  33. <script type="text/javascript" src="plug-in/layer/layer.js"></script>
  34. <script type="text/javascript" src="plug-in/tools/curdtools_zh-cn.js"></script>
  35. <script type="text/javascript"
  36. src="plug-in/tools/common_workflow_zh-cn.js"></script>
  37. <script type="text/javascript"
  38. src="plug-in/tools/common_method_zh-cn.js"></script>
  39. <script type="text/javascript" src="plug-in/tools/easyuiextend.js"></script>
  40. <script type="text/javascript"
  41. src="plug-in/jquery-plugs/hftable/jquery-hftable.js"></script>
  42. <script type="text/javascript" src="plug-in/tools/json2.js"></script>
  43. <style>
  44. .loading{width:95px;height:7px;font-size:7px;margin:5px auto;background:url(/images/loading.gif) no-repeat}
  45. </style>
  46. </head>
  47. <body style="overflow-y: hidden" scroll="no">
  48. <div id="content">
  49. <!-- <div id="wrapper"> -->
  50. <div class="loading upload-icon" style="display:none;position: absolute;left: 150px;top: 50%"></div>
  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. function upload() {
  63. postData();
  64. }
  65. function cancel() {
  66. }
  67. </script>
  68. <span id="file_uploadspan">
  69. <input type="file" id="file" multiple="multiple" onchange="handleFile()">
  70. </span>
  71. </div>
  72. <div class="form" id="filediv" ></div>
  73. <script type="text/javascript">
  74. $(function(){
  75. $("#filediv").attr("style","height:300px;overflow:auto;width: 97%;");
  76. $("#filediv").parent("td").attr("style","width: 650px; height: 400px;");
  77. });
  78. </script>
  79. <%-- </fieldset>--%>
  80. </form>
  81. </div>
  82. <!-- </div> -->
  83. </div>
  84. <script type="text/javascript">
  85. var formData,fs;
  86. function handleFile() {
  87. formData = new FormData(),
  88. fs = $("#file")[0].files;
  89. let max_size = 1024 * 1024 * 30;
  90. for (let i = 0; i < fs.length; i++) {
  91. let d = fs[0]
  92. if(d.size <= max_size){ //文件必须小于30M
  93. if(/.(xls|XLS|xlsx|XLSX)$/.test(d.name)){ //文件必须为文档
  94. formData.append("files", fs[i]); //文件上传处理
  95. }else{
  96. alert('上传文件必须是XLS!')
  97. return false
  98. }
  99. }else{
  100. alert('上传文件过大!')
  101. return false
  102. }
  103. }
  104. // var formData = new FormData();
  105. // formData.append("photo",$("#photo")[0].files[0]);
  106. // formData.append("service",'App.Passion.UploadFile');
  107. // formData.append("token",token);
  108. }
  109. function postData() {
  110. let $icon = $(".upload-icon");
  111. $icon.show();
  112. $.ajax({
  113. url:'/personnelBaseArchivesManageController.do?importExcel&sessionId=6DE43FF347ED6C4AFD93375CC8716FC9', /*接口域名地址*/
  114. type:'post',
  115. data: formData,
  116. contentType: false,
  117. processData: false,
  118. success:function(res){
  119. //{"success":true,"msg":"文件导入失败!","obj":null,"attributes":null,"jsonStr":"{\"msg\":\"文件导入失败!\",\"success\":true}"}
  120. W.tip(res.msg);
  121. $icon.hide();
  122. if(res.success){
  123. W.reloadTable();
  124. windowapi.close();
  125. }else{
  126. console.log(res);
  127. }
  128. }
  129. })
  130. }
  131. function zhaohual(d) {
  132. // console.log(d);
  133. if(d.success==false){
  134. if(d.msg=="导入模板错误"){
  135. layer.alert(d.msg);
  136. }else if(d.msg=="文件导入失败,请查看日志" || d.msg=="导入模板数据错误"){
  137. layer.alert(d.msg);
  138. // window.location.href="export/template/员工基本档案列表.xls";
  139. var downsrc = d.obj;
  140. location.href = downsrc;
  141. }else{
  142. layer.alert(d.msg);
  143. }
  144. }
  145. }
  146. </script>
  147. </body>
  148. </html>