HrmScheduleDiffOutDetail.jsp
5.35 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<!-- modified by wcd 2014-07-25 [E7 to E8] -->
<%@ include file="/hrm/header.jsp" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="DepartmentComInfo" class="weaver.hrm.company.DepartmentComInfo" scope="page"/>
<jsp:useBean id="HrmScheduleDiffUtil" class="weaver.hrm.report.schedulediff1512.HrmScheduleDiffUtil" scope="page"/>
<jsp:useBean id="ResourceComInfo" class="weaver.hrm.resource.ResourceComInfo" scope="page"/>
<%
String fromDate = Util.null2String(request.getParameter("fromDate"));
String toDate = Util.null2String(request.getParameter("toDate"));
String validDate = Util.null2String(request.getParameter("validDate"));
if(validDate.length()>0){
String[] arrayValidDate = validDate.split(",");
validDate = "";
for(String _dt : arrayValidDate){
validDate +=(validDate.length()>0?",":"")+"'"+_dt+"'";
}
}
int subCompanyId = Util.getIntValue(request.getParameter("subCompanyId"),0);
int departmentId = Util.getIntValue(request.getParameter("departmentId"),0);
String resourceId = strUtil.vString(request.getParameter("resourceId"));
//安全检查
//查询的开始日期和结束日期必须有值且长度为10
if(fromDate==null||fromDate.trim().equals("")||fromDate.length()!=10
||toDate==null||toDate.trim().equals("")||toDate.length()!=10){
return;
}
//非考勤管理员只能看到自己的记录
if(!HrmUserVarify.checkUserRight("BohaiInsuranceScheduleReport:View", user)){
resourceId = String.valueOf(user.getUID());
}
String imagefilename = "/images/hdReport_wev8.gif";
String titlename = SystemEnv.getHtmlLabelName(179,user.getLanguage())+"："+SystemEnv.getHtmlLabelName(16559,user.getLanguage())+"—"+SystemEnv.getHtmlLabelName(20094,user.getLanguage());
String needfav ="1";
String needhelp ="";
String isDialog = Util.null2String(request.getParameter("isdialog"));
%>
<html>
<head>
<LINK href="/css/Weaver_wev8.css" type=text/css rel=STYLESHEET>
<SCRIPT language="javascript" src="/js/weaver_wev8.js"></script>
<script type="text/javascript">
var dialog = parent.parent.getDialog(parent);
function exportExcel(){
document.getElementById("excels").src = "HrmScheduleDiffReportExcel.jsp?cmd=HrmScheduleDiffOutDetail&tnum=20094&fromDate=<%=fromDate%>&toDate=<%=toDate%>&resourceId=<%=resourceId%>&departmentId=<%=departmentId%>&subCompanyId=<%=subCompanyId%>";
}
</script>
</head>
<body>
<%if("1".equals(isDialog)){ %>
<div class="zDialog_div_content">
<%} %>
<%@ include file="/systeminfo/TopTitle_wev8.jsp" %>
<%@ include file="/systeminfo/RightClickMenuConent_wev8.jsp" %>
<%
RCMenu += "{"+SystemEnv.getHtmlLabelName(28343,user.getLanguage())+",javascript:exportExcel(),_self} " ;
RCMenuHeight += RCMenuHeightStep ;
%>
<%@ include file="/systeminfo/RightClickMenu_wev8.jsp" %>
<table id="topTitle" cellpadding="0" cellspacing="0">
<tr>
<td></td>
<td class="rightSearchSpan" style="text-align:right;">
<input type="button" class="e8_btn_top" onclick="exportExcel();" value="<%=SystemEnv.getHtmlLabelName(28343,user.getLanguage())%>"></input>
<span title="<%=SystemEnv.getHtmlLabelName(23036,user.getLanguage())%>" class="cornerMenu"></span>
</td>
</tr>
</table>
<%
String tableString=""+
"<table datasource=\"weaver.hrm.report.schedulediff1512.HrmScheduleDiffOtherManager.getScheduleList\" sourceparams=\"fromDate:"+fromDate+"+toDate:"+toDate+"+subCompanyId:"+subCompanyId+"+departmentId:"+departmentId+"+resourceId:"+resourceId+"+type:2\" pageId=\""+Constants.HRM_Q_001+"\" pagesize=\""+PageIdConst.getPageSize(Constants.HRM_Q_001,user.getUID(),Constants.HRM)+"\" tabletype=\"none\">"+
"<sql backfields=\"*\" sqlform=\"temp\" sqlorderby=\"id\" sqlprimarykey=\"id\" sqlsortway=\"desc\" />"+
"<head>"+
" <col width=\"15%\" text=\""+SystemEnv.getHtmlLabelName(124,user.getLanguage())+"\" column=\"departmentName\" orderkey=\"departmentName\" />"+
" <col width=\"15%\" text=\""+SystemEnv.getHtmlLabelName(413,user.getLanguage())+"\" column=\"resourceName\" orderkey=\"resourceName\" />"+
" <col width=\"20%\" text=\""+SystemEnv.getHtmlLabelName(742,user.getLanguage())+"\" column=\"startTime\" orderkey=\"startTime\" />"+
" <col width=\"20%\" text=\""+SystemEnv.getHtmlLabelName(743,user.getLanguage())+"\" column=\"endTime\" orderkey=\"endTime\" />"+
" <col width=\"15%\" text=\""+SystemEnv.getHtmlLabelName(15378,user.getLanguage())+"\" column=\"status\" orderkey=\"status\" />"+
" <col width=\"15%\" text=\""+SystemEnv.getHtmlLabelName(20096,user.getLanguage())+"\" column=\"days\" orderkey=\"days\" />"+
"</head>"+
"</table>";
%>
<wea:SplitPageTag isShowTopInfo="false" tableString='<%=tableString%>' mode="run" />
<%if("1".equals(isDialog)){ %>
</div>
<div id="zDialog_div_bottom" class="zDialog_div_bottom">
<wea:layout type="2col">
<wea:group context="">
<wea:item type="toolbar">
<input type="button" value="<%=SystemEnv.getHtmlLabelName(309,user.getLanguage())%>" class="e8_btn_cancel" onclick="dialog.close();">
</wea:item>
</wea:group>
</wea:layout>
</div>
<script type="text/javascript">
jQuery(document).ready(function(){
resizeDialog(document);
});
</script>
<%} %>
<iframe name="excels" id="excels" src="" style="display:none" ></iframe>
</body>
</html>