importExcelCheck.jsp
3.44 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
83
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<%@ page import="weaver.file.*" %>
<%@ page import="weaver.workflow.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 wfid = Util.null2String(fu.getParameter("wfid"));
String nodeid = Util.null2String(fu.getParameter("nodeid"));
String formid = Util.null2String(fu.getParameter("formid"));
String isbill = Util.null2String(fu.getParameter("isbill"));
String layouttype = Util.null2String(fu.getParameter("layouttype"));
wfinfo.put("wfid",wfid);
wfinfo.put("nodeid",nodeid);
wfinfo.put("formid",formid);
wfinfo.put("isbill",isbill);
wfinfo.put("layouttype",layouttype);
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>
window.parent.import_check_result = check_result;
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 url = "/spa/workflow/static4engine/engine.html#/main/workflowengine/form/formSet/cusFormBatchOperation?formId="+jQuery("#formid").val()+"&dialog=1&isFromMode=0&fromwhere=excelimp&openType=add";
var dlg = new window.top.Dialog();
dlg.currentWindow = window;
dlg.Title = "<%=SystemEnv.getHtmlLabelNames("20839,17998",user.getLanguage()) %>";
dlg.Width = 1100;
dlg.Height = 655;
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="wfid" name="wfid" value="<%=wfid %>" />
<input type="hidden" id="nodeid" name="nodeid" value="<%=nodeid %>" />
<input type="hidden" id="formid" name="formid" value="<%=formid %>" />
<input type="hidden" id="isbill" name="isbill" value="<%=isbill %>" />
<input type="hidden" id="layouttype" name="layouttype" value="<%=layouttype %>" />
</form>
<div id="importing" style="text-align:center;color:#4a6379;line-height:23em;font-size:12pt;diaplay:none;">
正在导入模板，请稍候……
</div>
</body>
</html>