workattendanceQuery.jsp 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423
  1. <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
  2. <%@ page import="com.runzhixing.bean.CityPlace" %>
  3. <%@ page import="com.runzhixing.bean.CountryPlace" %>
  4. <%@ page import="com.runzhixing.bean.Station" %>
  5. <%@ page import="com.runzhixing.bean.AuthorityRegionPlace" %>
  6. <%@ page import="com.runzhixing.bean.User" %>
  7. <%@ page import="com.runzhixing.constant.Constant" %>
  8. <%
  9. String path = request.getContextPath();
  10. String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
  11. User user = (User)session.getAttribute(Constant.userMark);
  12. List<AuthorityRegionPlace> arplist = user.getPrivilegePlaces1();
  13. List<CityPlace> cplist = new ArrayList<CityPlace>();
  14. List<CountryPlace> cyplist = new ArrayList<CountryPlace>();
  15. List<Station> slist = new ArrayList<Station>();
  16. %>
  17. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  18. <html>
  19. <head>
  20. <base href="<%=basePath%>">
  21. <title>考勤数据查询</title>
  22. <meta http-equiv="pragma" content="no-cache">
  23. <meta http-equiv="cache-control" content="no-cache">
  24. <meta http-equiv="expires" content="0">
  25. <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
  26. <meta http-equiv="description" content="This is my page">
  27. <meta http-equiv="X-UA-Compatible" content="IE=9"/>
  28. <meta http-equiv="X-UA-Compatible" content="IE=10"/>
  29. <link rel="stylesheet" type="text/css" href="css/easyui/themes/default/easyui.css">
  30. <link rel="stylesheet" type="text/css" href="css/easyui/themes/icon.css">
  31. <link rel="stylesheet" type="text/css" href="css/easyui/demo/demo.css">
  32. <script type="text/javascript" src="css/easyui/jquery.min.js"></script>
  33. <script type="text/javascript" src="css/easyui/jquery.easyui.min.js" charset="utf-8"></script>
  34. <script type="text/javascript" src="css/easyui/locale/easyui-lang-zh_CN.js" charset="utf-8"></script>
  35. <link rel="stylesheet" type="text/css" href="css/common/hzbstyle.css">
  36. <script type="text/javascript" src="js/common/area.js"></script>
  37. <style type="text/css">
  38. a:HOVER{
  39. color: red;
  40. text-decoration: none;
  41. }
  42. a{
  43. color: #f08300;
  44. text-decoration: none;
  45. }
  46. </style>
  47. <script type="text/javascript" src="js/easyui/export.js"></script>
  48. <script type="text/javascript">
  49. var grid="";
  50. var exportString="";
  51. var i = 1;//第几页
  52. var sum;//总条数
  53. var pageSize =10;
  54. var totalpage;//总页数
  55. $(document).ready(function(){
  56. fLoadTable();
  57. pageSize = $('#pageSize').val();
  58. selectCountry();
  59. selectstation();
  60. selectjqjandop();
  61. });
  62. function fLoadTable(){
  63. grid=$('#tt').datagrid({
  64. fit: true,//自动大小
  65. title: '',
  66. width: '100%',
  67. height: 580,
  68. toolbar: '#toolbar',
  69. fitColumns: true,
  70. loadMsg:'正在加载, 请稍等 …',
  71. nowrap : true,//设置为true,当数据长度超出列宽时将会自动截取
  72. striped : true,//设置为true将交替显示行背景
  73. collapsible : false,//显示可折叠按钮
  74. singleSelect:true,//为true时只能选择单行
  75. fitColumns:true,//允许表格自动缩放,以适应父容器
  76. rownumbers:true,
  77. pagination:true,//分页控件
  78. columns:[[
  79. {field:'tagUid',title:'标签UID',width:'10%'},
  80. {field:'tagNo',title:'标签编号',width:'10%'},
  81. {field:'operatorNo',title:'操作员编号',width:'10%'},
  82. {field:'operatorName',title:'操作员',width:'10%'},
  83. {field:'startTime',title:'登录时间(上班时间)',width:'19%'},
  84. {field:'regTime',title:'登记时间(下班时间)',width:'19%'},
  85. {field:'gunNo',title:'加气枪编号',width:'10%'},
  86. {field:'machineNo',title:'加气机编号',width:'10%',formatter:function(value,row,index){
  87. if(value==0){
  88. return "上岗";
  89. }else if(value==1){
  90. return "下岗";
  91. }else if(value==null){
  92. return "";
  93. }
  94. }}
  95. ]]
  96. });
  97. }
  98. function fLoadData(page,rows){
  99. if(!$('#station option:selected').text()){
  100. return false;
  101. }
  102. $.messager.progress({
  103. title: '请等待',
  104. msg: '正在加载数据...',
  105. text: '查询中.......'
  106. });
  107. $.ajax({
  108. type:"POST",
  109. contentType: "application/x-www-form-urlencoded; charset=UTF-8",
  110. data:$('#kaoqingform').serialize(),
  111. url:"ajax/kaoqingQuery?page="+page+"&psize="+rows,
  112. success:function (data){
  113. $.messager.progress('close');
  114. var vData = $.parseJSON(data);
  115. sum = vData.total;
  116. if(sum==0){
  117. show("没有查询到相关信息!!!");
  118. }
  119. totalpage = Math.ceil(sum/rows);
  120. $('#tt').datagrid('loadData', vData); //将数据绑定到datagrid
  121. var p = $('#tt').datagrid('getPager');
  122. $(p).pagination({
  123. pageList: [10,20,30,100,200,400],//可以设置每页记录条数的列表
  124. beforePageText: '第',//页数文本框前显示的汉字
  125. afterPageText: '页 共 {pages} 页',
  126. displayMsg: '当前显示 {from} - {to} 条记录 共 {total} 条记录',
  127. onSelectPage: function (pageNumber, pageSize) {
  128. fLoadData(pageNumber, pageSize);
  129. }
  130. });
  131. }
  132. });
  133. }
  134. function selectCountry(){
  135. var id=document.getElementById("city").value;
  136. var select = document.getElementById("country");
  137. for(var i=select.options.length-1;i>=0;i--) {
  138. select.options.remove(i);
  139. }
  140. $.ajax({
  141. type:"POST",
  142. contentType: "application/x-www-form-urlencoded; charset=UTF-8",
  143. url:"ajax/hiddenCity?cityId="+id,
  144. success:function (data){
  145. var obj=eval("(" + data + ")");
  146. $.each(obj.rows, function(i,item){
  147. select.options.add(new Option(item.name, item.id));
  148. });
  149. }
  150. });
  151. }
  152. function selectCountry1(){
  153. selectCountry();
  154. selectstation();
  155. changeSize();
  156. }
  157. function changeSize(){
  158. fLoadData(1,10);
  159. }
  160. function selectstation(){
  161. var ii=1;
  162. var id=document.getElementById("country").value;
  163. var select = document.getElementById("station");
  164. for(var i=select.options.length-1;i>=0;i--) {
  165. select.options.remove(i);
  166. }
  167. $.ajax({
  168. type:"POST",
  169. contentType: "application/x-www-form-urlencoded; charset=UTF-8",
  170. data:$('#kaoqingform').serialize(),
  171. url:"ajax/hiddenCNGStation?cityId="+id,
  172. success:function (data){
  173. var obj=eval("(" + data + ")");
  174. $.each(obj.rows, function(i,item){
  175. if(ii==1){
  176. if(obj.rows.length>1){
  177. select.options.add(new Option("全部", ""));
  178. }
  179. ii++;
  180. }
  181. select.options.add(new Option(item.name, item.id));
  182. });
  183. }
  184. });
  185. }
  186. function selectstation1(){
  187. selectstation();
  188. changeSize();
  189. }
  190. function show(message) {
  191. $.messager.show({
  192. title: '提示信息',
  193. msg: message,
  194. timeout: 2000,
  195. showType: 'slide'
  196. });
  197. }
  198. function selectjqjandop(){
  199. selectjqj();
  200. selectoperatorNo();
  201. }
  202. function selectjqj(){
  203. var ii=1;
  204. var id=document.getElementById("station").value;
  205. var select = document.getElementById("jqj");
  206. for(var i=select.options.length-1;i>=0;i--) {
  207. select.options.remove(i);
  208. }
  209. $.ajax({
  210. type:"POST",
  211. contentType: "application/x-www-form-urlencoded; charset=UTF-8",
  212. url:"ajax/hiddenjqj?stationId="+id,
  213. success:function (data){
  214. var obj=eval("(" + data + ")");
  215. $.each(obj.rows, function(i,item){
  216. if(ii==1){
  217. select.options.add(new Option("全部", ""));
  218. ii++;
  219. }
  220. select.options.add(new Option(item.manu+item.type, item.machineNo));
  221. });
  222. }
  223. });
  224. }
  225. function selectoperatorNo(){
  226. var ii=1;
  227. var id=document.getElementById("station").value;
  228. var select = document.getElementById("operatorNo");
  229. for(var i=select.options.length-1;i>=0;i--) {
  230. select.options.remove(i);
  231. }
  232. $.ajax({
  233. type:"POST",
  234. contentType: "application/x-www-form-urlencoded; charset=UTF-8",
  235. url:"ajax/hiddenoperatorNo?stationId="+id,
  236. success:function (data){
  237. var obj=eval("(" + data + ")");
  238. $.each(obj.rows, function(i,item){
  239. if(ii==1){
  240. select.options.add(new Option("全部", ""));
  241. ii++;
  242. }
  243. select.options.add(new Option(item.name, item.operatorNo));
  244. });
  245. }
  246. });
  247. }
  248. function expt1(){
  249. expt(grid);
  250. }
  251. function exptSingle(){
  252. if(!grid){
  253. alert("数据为空");
  254. return false;
  255. }else{
  256. expt(grid);
  257. }
  258. }
  259. function exptAll(){
  260. fLoadDataAll(1,5000);
  261. }
  262. function fLoadDataAll(page,rows){
  263. var startTime1 = $('#startTime').datebox('getValue');
  264. var endTime1 = $('#endTime').datebox('getValue');
  265. document.getElementById("pageNumber").innerText = i;
  266. document.getElementById("from").innerText = (page-1)*rows;
  267. document.getElementById("to").innerText = page*rows;
  268. $.messager.progress({
  269. title: '请等待',
  270. msg: '正在加载数据...',
  271. text: '查询中.......'
  272. });
  273. $.ajax({
  274. type:"POST",
  275. contentType: "application/x-www-form-urlencoded; charset=UTF-8",
  276. data:$('#kaoqingform').serialize(),
  277. url:"ajax/fillingDataQuery?page="+page+"&psize="+rows,
  278. success:function (data){
  279. $.messager.progress('close');
  280. var vData = $.parseJSON(data);
  281. sum = vData.total;
  282. if(sum==0){
  283. show("没有查询到相关信息!!!");
  284. }
  285. totalpage = Math.ceil(sum/rows);
  286. document.getElementById("total").innerText = sum;
  287. document.getElementById("totalpage").innerText = totalpage;
  288. var vData = $.parseJSON(data);
  289. $('#tt').datagrid('loadData', vData); //将数据绑定到datagrid
  290. if(!grid){
  291. alert("数据为空");
  292. return false;
  293. }else{
  294. expt(grid);
  295. }
  296. }
  297. });
  298. }
  299. function selectjqjandop22(){
  300. selectjqjandop();
  301. changeSize();
  302. }
  303. function selectoperatorNo22(){
  304. selectoperatorNo();
  305. changeSize();
  306. }
  307. </script>
  308. </head>
  309. <body>
  310. <!-- 查询结果:数据表格 -->
  311. <table id="tt" cellspacing="0" cellpadding="0" >
  312. </table>
  313. <div id="toolbar" style="padding-top: 0px;height: auto;">
  314. <form id="kaoqingform" action="ajax/filling" method="post">
  315. <table>
  316. <tr>
  317. <td>
  318. <span class="hzbspan">操作员:</span>
  319. </td>
  320. <td>
  321. <select name="operatorNo" id ="operatorNo" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan select" >
  322. <option value="">全部</option>&nbsp;&nbsp;
  323. </select>
  324. </td>
  325. <td>
  326. <span class="hzbspan">上岗时间:</span>
  327. </td>
  328. <td>
  329. <input type="text" name="startTime" id="startTime" class="easyui-datebox" style="width: 150px;height: 34px;" class="hzbspan">
  330. </td>
  331. <td>
  332. <span class="hzbspan">下岗时间:</span>
  333. </td>
  334. <td>
  335. <input type="text" name="endTime" id="endTime" class="easyui-datebox" style="width: 150px;height: 34px;" class="hzbspan">
  336. </td>
  337. <td>
  338. <a id="btninfosearch" onclick="changeSize();" class="easyui-linkbutton" icon="icon-search" href="javascript:void(0)" ><span class="hzbspan" style="color: #f08300;font-size: 16px;">查&nbsp;&nbsp;询&nbsp;&nbsp;</span></a>
  339. <a id="btninfosearch" onclick="exptSingle();" class="easyui-linkbutton" icon="icon-save" href="javascript:void(0)" ><span class="hzbspan" style="color: #f08300;font-size: 16px;">导&nbsp;&nbsp;出&nbsp;&nbsp;</span></a>
  340. </td>
  341. </tr>
  342. </table>
  343. <select name="province" style="width: auto;height: 24px;min-width: 100px;display: none;" class="hzbspan">
  344. <%for(AuthorityRegionPlace arp:arplist){
  345. cplist = arp.getCityPlace();
  346. %>
  347. <option value="<%=arp.getId() %>">
  348. <%=arp.getName() %>
  349. </option>
  350. <%} %>
  351. </select>
  352. <select name="city" id="city" style="width: auto;height: 24px;min-width: 100px;display: none;" class="hzbspan" onchange="selectCountry1()">
  353. <%
  354. for(CityPlace cp:cplist){
  355. cyplist = cp.getSubPlaceList();
  356. %>
  357. <option value="<%=cp.getId() %>">
  358. <%=cp.getName() %>
  359. </option>
  360. <%} %>
  361. </select>
  362. <select name="country" id = "country" style="width: auto;height: 24px;min-width: 100px;display: none;" class="hzbspan" onchange="selectstation1();" >
  363. </select>
  364. <select name="station" id ="station" style="width: auto;height: 24px;min-width: 100px;display: none;" class="hzbspan" onchange="selectjqjandop22();" >
  365. <option value="">全部</option>
  366. </select>
  367. <select name="jqj" id ="jqj" style="width: auto;height: 24px;min-width: 100px;display: none;" class="hzbspan" onchange="selectoperatorNo22();" >
  368. <option value="">全部</option>
  369. </select>
  370. </form>
  371. </div>
  372. <div id="dialog2"></div>
  373. </body>
  374. </html>