viewStaffReportTable.jsp 7.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174
  1. <%@ page language="java" contentType="text/html;charset=GBK" pageEncoding="GBK"%>
  2. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
  3. <%@ taglib uri="http://fzywtx.com/jsp/yw/yr" prefix="yr"%>
  4. <%@ taglib uri="http://fzywtx.com/jsp/yw/select" prefix="l"%>
  5. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  6. <html>
  7. <head>
  8. <meta http-equiv="Content-Type" content="text/html;charset=GBK">
  9. <title>员工档案表</title>
  10. <link href="${pageContext.request.contextPath}/main.css" rel="stylesheet" type="text/css" />
  11. <link href="${pageContext.request.contextPath }/liger/lib/ligerUI/skins/${sessionScope.css}/css/ligerui-all.css" rel="stylesheet" type="text/css" />
  12. <script src="${pageContext.request.contextPath }/liger/lib/jquery/jquery-1.3.2.min.js" type="text/javascript"></script>
  13. <script src="${pageContext.request.contextPath }/liger/lib/ligerUI/js/core/base.js" type="text/javascript"></script>
  14. <script src="${pageContext.request.contextPath}/liger/lib/ligerUI/js/ligerui.all.js" type="text/javascript"></script>
  15. <script src="${pageContext.request.contextPath}/liger/lib/json2.js" type="text/javascript"></script>
  16. <script type="text/javascript" src="/shares/js/constant.js"></script>
  17. <script type="text/javascript" src="/shares/js/common.js"></script>
  18. <script type="text/javascript" src="/shares/js/yw/hr/common.js"></script>
  19. <script type="text/javascript" src="/shares/datePicker/WdatePicker.js"></script>
  20. <script type="text/javascript">
  21. function initStaff(s){
  22. var columns = [
  23. { display: '工号', name: 'job_number', width: 100},
  24. { display: '姓名', name: 'staff_name', width: 70 },
  25. { display: '性别', name: 'staff_sex', width: 50 },
  26. { display: '工种', name: 'craft_type', width: 70},
  27. { display: '所属部门', name: 'branch_company_name', width: 100},
  28. { display: '岗位', name: 'positionid', width: 70 },
  29. { display: '身份证', name: 'id_number', width: 150 },
  30. { display: '出生年月', name: 'staff_birthday', width: 120 ,render:function(row){
  31. var html = subDate(row.staff_birthday);
  32. return html;
  33. }},
  34. { display: '民族', name: 'ethnic_group', width: 50 },
  35. { display: '婚姻', name: 'marital_status', width: 50 },
  36. { display: '学历', name: 'study_educational_background', width: 50 },
  37. { display: '毕业学校', name: 'study_school_name', width: 120 },
  38. { display: '专业', name: 'study_subject', width: 50 },
  39. { display: '职称', name: 'job_title', width: 50 },
  40. { display: '入职日期', name: 'register_time', width: 120 ,render:function(row){
  41. var html = subDate(row.register_time);
  42. return html;
  43. }},
  44. { display: '联系电话', name: 'self_phone', width: 120 },
  45. { display: '户口所在地', name: 'census_address', width: 180 },
  46. { display: '现住址', name: 'home_address', width: 180 },
  47. { display: '劳动合同日期', name: 'agreement_time', width: 120 }];
  48. grid = $("#staffRecordDiv").ligerGrid({
  49. columns : columns,
  50. fixedCellHeight: false, //是否固定单元格的高度
  51. pageSize:20,
  52. url: 'hrStaffReportAction.do?task=list&time=' + new Date().getTime()+s,
  53. pageParmName: 'p', //页索引参数名,(提交给服务器)
  54. pagesizeParmName: 'pSize', //页记录数参数名,(提交给服务器)
  55. enabledSort: true, //是否允许排序
  56. method:"post",
  57. width: '99%',
  58. height: '99%'
  59. });
  60. }
  61. $(function () {
  62. //所属部门
  63. loadTypeTree("deptBtnR", {
  64. type : "dept",
  65. backId : "hr_dept",
  66. backName : "hr_dept_name",
  67. tab : "1"
  68. });
  69. initStaff();
  70. });
  71. //查询
  72. function queryStaffReportTable(){
  73. var is_dimission=$("#is_dimission").val();
  74. var register_time_start =$("#register_time_start").val();
  75. var register_time_end = $("#register_time_end").val();
  76. var staff_name =$("#staff_name").val();
  77. var hr_dept = $("#hr_dept").val();
  78. var s = "";
  79. if(staff_name !='' && typeof(staff_name) != "undefined"){
  80. s += "&staff_name=" + encodeURI(encodeURI(staff_name));
  81. }
  82. if(hr_dept != '' && typeof(hr_dept) != "undefined"){
  83. s += "&hr_dept=" + hr_dept;
  84. }
  85. if(is_dimission != "" && typeof(is_dimission) != "undefined" ){
  86. s += "&is_dimission=" + is_dimission;
  87. }
  88. if(register_time_start != "" && typeof(register_time_start) != "undefined" ){
  89. s += "&register_time_start=" + register_time_start;
  90. }
  91. if(register_time_end != "" && typeof(register_time_end) != "undefined" ){
  92. s += "&register_time_end=" + register_time_end;
  93. }
  94. if(grid){
  95. grid.set("newPage","1");
  96. }
  97. initStaff(s);
  98. }
  99. //导出员工信息
  100. function exportStaffExcel(){
  101. var is_dimission=$("#is_dimission").val();
  102. var register_time_start =$("#register_time_start").val();
  103. var register_time_end = $("#register_time_end").val();
  104. var staff_name =$("#staff_name").val();
  105. var hr_dept = $("#hr_dept").val();
  106. var s = "";
  107. if(staff_name !='' && typeof(staff_name) != "undefined"){
  108. s += "&staff_name=" + encodeURI(encodeURI(staff_name));
  109. }
  110. if(hr_dept != '' && typeof(hr_dept) != "undefined"){
  111. s += "&hr_dept=" + hr_dept;
  112. }
  113. if(is_dimission != "" && typeof(is_dimission) != "undefined" ){
  114. s += "&is_dimission=" + is_dimission;
  115. }
  116. if(register_time_start != "" && typeof(register_time_start) != "undefined" ){
  117. s += "&register_time_start=" + register_time_start;
  118. }
  119. if(register_time_end != "" && typeof(register_time_end) != "undefined" ){
  120. s += "&register_time_end=" + register_time_end;
  121. }
  122. window.location.href='hrStaffReportAction.do?task=exportStaffExcel'+s;
  123. }
  124. </script>
  125. </head>
  126. <body >
  127. <div class="default_search" style="margin-top:10px;">
  128. <ul calss="list_search">
  129. <li class="title">员工姓名</li>
  130. <li class="text"><input type="text" id="staff_name" name="staff_name" style="width:90px;"/></li>
  131. </ul>
  132. <ul class="list_search">
  133. <li class="title" >部门:</li>
  134. <li class="text" >
  135. <input type="hidden" name="hr_dept" id="hr_dept" value="" />
  136. <input type="text" id="hr_dept_name" name="hr_dept_name" readonly="readonly" style="width:90px;"/>
  137. <input type="button" value="请选择" id="deptBtnR" class="l-button"/>
  138. </li>
  139. </ul>
  140. <ul class="list_search" >
  141. <li class="title">员工状态:</li>
  142. <li class="text" >
  143. <select name="is_dimission" id="is_dimission">
  144. <option value="">==请选择==</option>
  145. <option value="1">在职</option>
  146. <option value="0">离职</option>
  147. </select>
  148. </li>
  149. </ul>
  150. <ul class="list_search" >
  151. <li class="title">入职日期:</li>
  152. <li class="text" >
  153. <input type="text" class="Wdate" name="register_time_start" id="register_time_start" value="${register_time_start }" style="width: 120px !important;margin-top:-2px;" onclick="WdatePicker({dateFmt:'yyyy-MM-dd',maxDate:'#F{$dp.$D(\'register_time_end\',{d:-1})}'})">
  154. <input type="text" class="Wdate" name="register_time_end" id="register_time_end" value="${register_time_end }" style="width: 120px !important;margin-top:-2px;" onclick="WdatePicker({dateFmt:'yyyy-MM-dd',minDate:'#F{$dp.$D(\'register_time_start\',{d:1})}'})">
  155. </li>
  156. </ul>
  157. <ul class="list_search" >
  158. <li class="text" >
  159. <input type="button" class='l-button' name="search" onclick="queryStaffReportTable();" value="查询" style="margin-top:-2px;" />
  160. <input type="button" class="l-button" name="search" onclick="exportStaffExcel();" value="导出Excel" style="margin-top:-2px;"/>
  161. </li>
  162. </ul>
  163. </div>
  164. <div style="clear: both;">
  165. <div id="staffRecordDiv" style="margin: 0; padding: 0"></div>
  166. </div>
  167. </body>
  168. </html>