carList.jsp 6.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136
  1. <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
  2. <%@include file="/context/mytags.jsp" %>
  3. <t:base type="jquery,easyui,tools,DatePicker"></t:base>
  4. <body style="overflow-y: hidden" scroll="no">
  5. <div id="mainlist" class="easyui-layout" fit="true">
  6. <div region="center" style="padding:0px;border:0px">
  7. <t:datagrid name="carList" checkbox="false" pagination="true" fitColumns="true"
  8. sortOrder="desc" title="车辆计划完成情况统计" autoLoadData="false" idField="id"
  9. actionUrl="" fit="true">
  10. <t:dgCol title="排班id" field="id" hidden="true" width="120"></t:dgCol>
  11. <t:dgCol title="车牌号" field="plate" width="120"></t:dgCol>
  12. <t:dgCol title="作业人员" field="userId" dictionary="t_s_base_user,id,realname" width="120"></t:dgCol>
  13. <t:dgCol title="车辆类型" field="type" width="80"></t:dgCol>
  14. <t:dgCol title="当日作业频次" field="schedule_count" width="100"></t:dgCol>
  15. <t:dgCol title="当日计划完成率" field="done_count" formatterjs="countDone" width="100"></t:dgCol>
  16. <t:dgCol title="当月作业频次" field="monthCount" width="100"></t:dgCol>
  17. <t:dgCol title="当月计划完成率" field="monthDoneCount" formatterjs="countMonthDone" width="100"></t:dgCol>
  18. <t:dgCol title="本季度作业频次" field="quarterCount" width="120"></t:dgCol>
  19. <t:dgCol title="本季度计划完成率" field="quarterDoneCount" formatterjs="countQuarterDone" width="120"></t:dgCol>
  20. <t:dgCol title="信息接收人" field="receiver" dictionary="t_s_base_user,id,realname" width="100"></t:dgCol>
  21. <t:dgCol title="作业日期" field="schedule_date" width="80"></t:dgCol>
  22. </t:datagrid>
  23. <div style="padding: 3px; height: 65px;">
  24. <div style="width: 250px;float: left;">
  25. <span style="vertical-align:middle;display:-moz-inline-box;display:inline-block;width: 80px;text-align:right;" title="车牌号">
  26. 车牌号:
  27. </span>
  28. <input type="text" name="plate" id="plate" style="width: 160px; height: 24px;" class="text">
  29. </div>
  30. <div style="width: 250px;float: left;">
  31. <span style="vertical-align:middle;display:-moz-inline-box;display:inline-block;width: 80px;text-align:right;" title="车辆类型">
  32. 车辆类型:
  33. </span>
  34. <t:dictSelect field="type" id="type" dictTable="t_s_type" dictField="typecode" dictText="typename" dictCondition=" where typegroupid = '2c9358a86dbeda88016dbee52d0f0031'"/>
  35. </div>
  36. <div style="width: 550px;float: left;">
  37. <span style="vertical-align:middle;display:-moz-inline-box;display:inline-block;width: 80px;text-align:right;" title="作业日期">
  38. 作业日期:
  39. </span>
  40. <input type="text" name="start" id="start" style="width: 160px; height: 24px;" class="Wdate" onFocus="WdatePicker({dateFmt:'yyyy-MM-dd'})">
  41. ~
  42. <input type="text" name="end" id="end" style="width: 160px; height: 24px;" class="Wdate" onFocus="WdatePicker({dateFmt:'yyyy-MM-dd'})">
  43. </div>
  44. <br>
  45. <div style="width: 200px">
  46. <a href="#" class="easyui-linkbutton" iconCls="icon-put" onclick="excelExport();" style="float: left;">导出</a>
  47. <a href="#" class="easyui-linkbutton" iconCls="icon-search" onclick="detail('查看','carScheduleController.do?detail&queryType=car','carList','100%','100%');" style="float: left;">查看</a>
  48. </div>
  49. <div style="width: 200px;float: right;">
  50. <a href="#" class="easyui-linkbutton" iconCls="icon-reload" onclick="clearSearch();" style="float: right;"><t:mutiLang langKey="重置"/></a>
  51. <a href="#" class="easyui-linkbutton" iconCls="icon-search" onclick="getResult();" style="float: right;"><t:mutiLang langKey="common.query"/></a>
  52. </div>
  53. </div>
  54. </div>
  55. </div>
  56. </body>
  57. <script type="text/javascript">
  58. function check() {
  59. $(".l-btn.l-btn-plain").each(function(index, ele){
  60. ele.onclick = function(){
  61. getResult();
  62. }
  63. });
  64. }
  65. $(function () {
  66. getResult();
  67. });
  68. function clearSearch() {
  69. $('#plate').val("");
  70. $('#type').val("");
  71. $('#start').val("");
  72. $('#end').val("");
  73. getResult();
  74. }
  75. function getResult() {
  76. var options = $("#carList").datagrid("getPager").data("pagination").options;
  77. var curr = options.pageNumber;
  78. var size = options.pageSize;
  79. $.ajax({
  80. url:"carScheduleController.do?carListDatagrid&_functionId=${_functionId}",
  81. data:{
  82. pageNum:curr,
  83. pageSize:size,
  84. plate:$('#plate').val(),
  85. type:$('#type').val(),
  86. start:$('#start').val(),
  87. end:$('#end').val()
  88. },
  89. type:"post",
  90. success:function(data){
  91. if(data){
  92. $("#carList").datagrid({
  93. data:data,
  94. loadFilter:function(data){
  95. return {
  96. rows: data.records,
  97. total: data.total
  98. }
  99. },
  100. onBeforeLoad:function(val){
  101. return false;
  102. }
  103. });
  104. check();
  105. }
  106. }
  107. });
  108. }
  109. function countDone(value,row,index) {
  110. if(row['schedule_count'] == '0'){
  111. return '0%';
  112. }
  113. return Math.round(value/row['schedule_count']) + '%';
  114. }
  115. function countMonthDone(value,row,index) {
  116. if(row['monthCount'] == '0'){
  117. return '0%';
  118. }
  119. return Math.round(value/row['monthCount']) + '%';
  120. }
  121. function countQuarterDone(value,row,index) {
  122. if(row['quarterCount'] == '0'){
  123. return '0%';
  124. }
  125. return Math.round(value/row['quarterCount']) + '%';
  126. }
  127. function excelExport() {
  128. JeecgExcelExport("carScheduleController.do?carExcelExport","carList");
  129. }
  130. </script>