fanRptCostExcel.jsp
4.96 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
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
<%@page import="weaver.fna.report.FnaReport"%>
<%@page import="weaver.fna.general.FnaSplitPageTransmethod"%>
<%@page import="org.apache.commons.lang.StringEscapeUtils"%>
<%@page import="weaver.fna.maintenance.FnaCostCenter"%>
<%@page import="weaver.fna.general.FnaBudgetLeftRuleSet"%>
<%@page import="weaver.fna.maintenance.FnaBudgetInfoComInfo"%>
<%@page import="weaver.file.ExcelRow"%>
<%@page import="weaver.conn.RecordSet"%>
<%@page import="java.text.DecimalFormat"%>
<%@page import="weaver.file.ExcelSheet"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="ExcelFile" class="weaver.file.ExcelFile" scope="session"/>
<%
boolean canview = HrmUserVarify.checkUserRight("TheCostOfQueryStatistics:query",user) ;
if(!canview){
response.sendRedirect("/notice/noright.jsp") ;
return ;
}
FnaSplitPageTransmethod fnaSplitPageTransmethod = new FnaSplitPageTransmethod();
String _guid1 = Util.null2String(request.getParameter("_guid1")).trim();
HashMap<String, String> retHm = FnaReport.getFnaReportShareLevel(_guid1, user.getUID());
boolean isView = "true".equals(retHm.get("isView"));//查看
boolean isEdit = "true".equals(retHm.get("isEdit"));//编辑
boolean isFull = "true".equals(retHm.get("isFull"));//完全控制
if(!isView && !isEdit && !isFull) {
response.sendRedirect("/notice/noright.jsp") ;
return ;
}
String tbName = "";
String rptTbName = "";
rs.executeSql("select * from fnaTmpTbLog where guid1 = '"+StringEscapeUtils.escapeSql(_guid1)+"'");
if(rs.next()){
tbName = Util.null2String(rs.getString("tbName")).trim();
rptTbName = Util.null2String(rs.getString("tbDbName")).trim();
}
ExcelFile.init();
ExcelSheet es = new ExcelSheet();
String sheetname = SystemEnv.getHtmlLabelName(82605, user.getLanguage());//费用查询统计表
ExcelFile.addSheet(sheetname, es);
ExcelRow er = es.newExcelRow();
er.addStringValue(SystemEnv.getHtmlLabelName(15486,user.getLanguage()));//序号
er.addStringValue(SystemEnv.getHtmlLabelName(18748,user.getLanguage()));//预算单位
er.addStringValue(SystemEnv.getHtmlLabelName(1462,user.getLanguage()));//预算科目
er.addStringValue(SystemEnv.getHtmlLabelName(27767,user.getLanguage()));//费用日期
er.addStringValue(SystemEnv.getHtmlLabelName(384754,user.getLanguage()));//预算占用额度
er.addStringValue(SystemEnv.getHtmlLabelName(82606,user.getLanguage()));//费用状态
er.addStringValue(SystemEnv.getHtmlLabelName(384201,user.getLanguage()));//数据来源
er.addStringValue(SystemEnv.getHtmlLabelName(18104,user.getLanguage()));//流程名称
er.addStringValue(SystemEnv.getHtmlLabelName(19502,user.getLanguage()));//流程编号
er.addStringValue(SystemEnv.getHtmlLabelName(882,user.getLanguage()));//创建人
er.addStringValue(SystemEnv.getHtmlLabelName(18564,user.getLanguage()));//当前节点
er.addStringValue(SystemEnv.getHtmlLabelName(19061,user.getLanguage()));//流程状态
String sql = "select * from "+rptTbName+" where guid1 = '"+StringEscapeUtils.escapeSql(_guid1)+"' order by id";
rs.executeSql(sql);
while(rs.next()){
String orderNum = Util.null2String(rs.getString("orderNum"));
String requestmark = Util.null2String(rs.getString("requestmark"));
String requestname = Util.null2String(rs.getString("requestname"));
String orgJsonStr = Util.null2String(rs.getString("orgJsonStr"));
String creater = Util.null2String(rs.getString("creater"));
String crmIds = Util.null2String(rs.getString("crmIds"));
String prjIds = Util.null2String(rs.getString("prjIds"));
String occurdate = Util.null2String(rs.getString("createdate"));
String _amount = Util.null2String(rs.getString("sumAmt"));
String fnaSubjects = Util.null2String(rs.getString("fnaSubjects"));
String fnaDataSources = Util.null2String(rs.getString("fnaDataSources2"));
String feeStatusName = Util.null2String(rs.getString("feeStatusName"));
String currentWfNodeName = Util.null2String(rs.getString("currentWfNodeName"));
String currentWfTypeName = Util.null2String(rs.getString("currentWfTypeName"));
er = es.newExcelRow();
er.addStringValue(orderNum);
er.addStringValue(fnaSplitPageTransmethod.getOrgNameByJsonStr(orgJsonStr, user.getLanguage()+"", "; "));
er.addStringValue(fnaSplitPageTransmethod.getSubjectNames(fnaSubjects));
er.addStringValue(occurdate);
er.addStringValue(fnaSplitPageTransmethod.fmtAmount(_amount));
er.addStringValue(feeStatusName);
er.addStringValue(fnaDataSources);
er.addStringValue(requestname);
er.addStringValue(requestmark);
er.addStringValue(fnaSplitPageTransmethod.getLastName(creater));
er.addStringValue(currentWfNodeName);
er.addStringValue(currentWfTypeName);
}
ExcelFile.setFilename(sheetname);
%>
<iframe id="ExcelOut" name="ExcelOut" border=0 frameborder=no noresize=NORESIZE height="0%" width="0%"></iframe>
<script type="text/javascript">
var iframe_ExcelOut = document.getElementById("ExcelOut");
iframe_ExcelOut.src = "/weaver/weaver.file.ExcelOut";
</script>