importExcelCheck.jsp
3.31 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<%@ include file="/formmode/checkright4setting.jsp" %>
<%@ page import="weaver.file.*" %>
<%@ page import="weaver.formmode.exceldesign.TemplateOperation" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<%
FileUpload fu = new FileUpload(request, false, false, "filesystem/exceldesign/excelimp");
int fileid = Util.getIntValue(fu.uploadFiles("filename"),-1);
String sql = "select filerealpath,isaesencrypt,aescode from imagefile where imagefileid = "+fileid;
rs.executeSql(sql);
String excelFilePath= "";
if(rs.next()){
excelFilePath = rs.getString("filerealpath");
}
Map<String,String> wfinfo = new HashMap<String,String>();
String modeid = Util.null2String(fu.getParameter("modeid"));
String formid = Util.null2String(fu.getParameter("formid"));
String layoutid = Util.null2String(fu.getParameter("layoutid"));
String layouttype = Util.null2String(fu.getParameter("layouttype"));
String isdefault = Util.null2String(fu.getParameter("isdefault"));
wfinfo.put("modeid",modeid);
wfinfo.put("formid",formid);
wfinfo.put("layoutid",layoutid);
wfinfo.put("layouttype",layouttype);
wfinfo.put("isdefault",isdefault);
wfinfo.put("userid", String.valueOf(user.getUID()));
wfinfo.put("language", String.valueOf(user.getLanguage()));
TemplateOperation templateOperation = new TemplateOperation(excelFilePath, wfinfo);
String check_result = templateOperation.checkTemplate();
out.println("<script>var check_result = '"+check_result+"';</script>");
%>
<html>
<head>
<script>
var dialog = parent.getDialog(window);
jQuery(document).ready(function(){
if(check_result==''){ //字段验证通过，直接submit到导入页面
jQuery("#importing").css("display","");
document.impExcelForm.submit();
}else{
var needclose = true;
var url = "/workflow/form/addfieldbatch.jsp?formid="+jQuery("#formid").val()+"&dialog=1&isFromMode=0&fromwhere=excelimp";
var dlg = new window.top.Dialog();
dlg.currentWindow = window;
dlg.Title = "<%=SystemEnv.getHtmlLabelNames("20839,17998",user.getLanguage()) %>";
dlg.Width = 1020;
dlg.Height = 580;
dlg.Modal = true;
dlg.URL = url;
dlg.callbackfun = function(paramobj, result){
if(result == "nextImport"){
needclose = false;
jQuery("#importing").css("display","");
document.impExcelForm.submit();
}
}
dlg.closeHandle = function(){
if(needclose)
dialog.close();
}
dlg.show();
}
});
</script>
</head>
<body style="background-color:#efefef">
<form id="impExcelForm" name="impExcelForm" action="importExcelSubmit.jsp" method="post">
<input type="hidden" id="excelFilePath" name="excelFilePath" value="<%=excelFilePath %>" />
<input type="hidden" id="modeid" name="modeid" value="<%=modeid %>" />
<input type="hidden" id="formid" name="formid" value="<%=formid %>" />
<input type="hidden" id="layoutid" name="layoutid" value="<%=layoutid %>" />
<input type="hidden" id="layouttype" name="layouttype" value="<%=layouttype %>" />
<input type="hidden" id="isdefault" name="isdefault" value="<%=isdefault %>" />
</form>
<div id="importing" style="text-align:center;color:#4a6379;line-height:23em;font-size:12pt;diaplay:none;">
<%=SystemEnv.getHtmlLabelName(128059,user.getLanguage())%>
</div>
</body>
</html>