OccurredExpenseBatchLogGroup.jsp
5.32 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
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
<%@page import="org.apache.commons.lang.StringEscapeUtils"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ taglib uri="/WEB-INF/weaver.tld" prefix="wea"%><!--added by xwj for td2023 on 2005-05-20-->
<%@ include file="/systeminfo/init_wev8.jsp" %>
<%@ page import="weaver.general.GCONST" %>
<%@ page import="weaver.general.IsGovProj" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="UserDefaultManager" class="weaver.docs.tools.UserDefaultManager" scope="session" />
<HTML><HEAD>
<LINK href="/css/Weaver_wev8.css" type=text/css rel=STYLESHEET>
<script language="javascript" src="/js/weaver_wev8.js"></script>
<script language="javascript" src="/fna/js/e8Common_wev8.js?r=3"></script>
</head>
<%
String userid=""+user.getUID();
boolean canEdit = HrmUserVarify.checkUserRight("FnaOccurredExpenseImport:Add",user);
if(!canEdit){
response.sendRedirect("/notice/noright.jsp") ;
return ;
}
int isgoveproj = Util.getIntValue(IsGovProj.getPath(),0);//0:非政务系统，1：政务系统
String imagefilename = "/images/hdDOC_wev8.gif";
String titlename = SystemEnv.getHtmlLabelName(131406,user.getLanguage());//财务报表权限设置
String needfav ="1";
String needhelp ="";
String nameQuery = Util.null2String(request.getParameter("nameQuery")).trim();
%>
<BODY>
<%@ include file="/systeminfo/TopTitle_wev8.jsp" %>
<%@ include file="/systeminfo/RightClickMenuConent_wev8.jsp" %>
<div class="zDialog_div_content">
<jsp:include page="/systeminfo/commonTabHead.jsp">
<jsp:param name="mouldID" value="fna"/>
<jsp:param name="navName" value="<%=SystemEnv.getHtmlLabelName(24835,user.getLanguage()) %>"/>
</jsp:include>
<form id=form2 name=form2 method=post action="//fna/budget/fnaSynDataInner.jsp">
<table id="topTitle" cellpadding="0" cellspacing="0">
<tr>
<td>
</td>
<td class="rightSearchSpan" style="text-align:right; width:500px!important">
<span title="<%=SystemEnv.getHtmlLabelName(23036,user.getLanguage()) %>" class="cornerMenu"></span><!-- 菜单 -->
</td>
</tr>
</table>
<!-- advanced search -->
<div class="advancedSearchDiv" id="advancedSearchDiv">
</div>
<%
String tableString = "";
String sqlCore = " select a.batchGuid, a.creater, a.createdate, a.createtime, count(*) cnt \n" +
" from fnaLogOccurredExpenseBatch a \n" +
" GROUP BY a.batchGuid, a.creater, a.createdate, a.createtime ";
String backfields = " t1.batchGuid, t1.creater, t1.createdate, t1.createtime, t1.cnt ";
String fromSql = " from ("+sqlCore+") t1 ";
String sqlWhere = "";
String orderby = " t1.createdate, t1.createtime ";
String sqlprimarykey = "t1.batchGuid";
//out.println("select "+backfields+fromSql+sqlWhere);
tableString =" <table pagesize=\"13\" tabletype=\"none\" >"+
" <sql backfields=\""+Util.toHtmlForSplitPage(backfields)+"\" sqlform=\""+Util.toHtmlForSplitPage(fromSql)+"\" "+
" sqlwhere=\""+Util.toHtmlForSplitPage(sqlWhere)+"\" sqlorderby=\""+Util.toHtmlForSplitPage(orderby)+"\" "+
" sqlprimarykey=\""+Util.toHtmlForSplitPage(sqlprimarykey)+"\" sqlsortway=\"desc\" sqlisdistinct=\"true\" />"+
" <head>";
tableString+=" <col width=\"30%\" text=\""+SystemEnv.getHtmlLabelName(99,user.getLanguage())+"\" column=\"creater\" "+//操作者
" transmethod=\"weaver.hrm.resource.ResourceComInfo.getLastname\" />";
tableString+=" <col width=\"20%\" text=\""+SystemEnv.getHtmlLabelName(27420,user.getLanguage())+"\" column=\"createdate\" />";//导入日期
tableString+=" <col width=\"20%\" text=\""+SystemEnv.getHtmlLabelName(20515,user.getLanguage())+"\" column=\"createtime\" />";//导入时间
tableString+=" <col width=\"20%\" text=\""+SystemEnv.getHtmlLabelName(2109,user.getLanguage())+"\" column=\"cnt\" />";//记录数
tableString+=" </head>";
tableString+=" <operates>";
tableString+=" <operate href=\"javascript:viewLogInfo();\" text=\""+SystemEnv.getHtmlLabelName(83110,user.getLanguage())+"\" index=\"1\"/>";//查看详情
tableString+=" </operates>";
tableString+="</table>";
%>
<wea:SplitPageTag tableString='<%=tableString%>' mode="run" />
</form>
<jsp:include page="/systeminfo/commonTabFoot.jsp"></jsp:include>
</div>
<div id="zDialog_div_bottom" class="zDialog_div_bottom">
<wea:layout needImportDefaultJsAndCss="false">
<wea:group context="" attributes="{'groupDisplay':'none'}">
<wea:item type="toolbar">
<input class="zd_btn_cancle" type="button" id="btnClose" onclick="doClose();"
value="<%=SystemEnv.getHtmlLabelName(309,user.getLanguage())%>"/><!-- 取消 -->
</wea:item>
</wea:group>
</wea:layout>
</div>
<%@ include file="/systeminfo/RightClickMenu_wev8.jsp" %>
</body>
<script language="javascript">
var _Label33574 = "<%=SystemEnv.getHtmlLabelName(33574,user.getLanguage()) %>";//正在处理数据，请不要离开该页面，请稍等...
//页面初始化事件
jQuery(document).ready(function(){
resizeDialog(document);
});
//关闭
function doClose(){
var dialog = parent.getDialog(window);
dialog.closeByHand();
}
//快速（高级）搜索事件
function onBtnSearchClick(from_advSubmit){
form2.submit();
}
function viewLogInfo(batchGuid){
_fnaOpenDialog("/fna/batch/OccurredExpenseBatchLogInfo.jsp?batchGuid="+batchGuid,
"<%=SystemEnv.getHtmlLabelName(83110,user.getLanguage()) %>", 800, 600);
}
</script>
</html>