HourTaskIndex.js 9.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214
  1. var refreshGirdData;
  2. var OneInTimebegin = '';
  3. var OneInTimeend = '';
  4. var ProductTimebegin = '';
  5. var ProductTimeend = '';
  6. var logbegin = '';
  7. var logend = '';
  8. var StartTimeBegin = '';
  9. var StartTimeend = '';
  10. var EndTimeBegin = '';
  11. var EndTimeend = '';
  12. var bootstrap = function ($, learun) {
  13. "use strict";
  14. var psuid = "";
  15. const TaskType = ["", "入库", "出库", "移库", "", "输送"];
  16. var page = {
  17. init: function () {
  18. $("#EndTimeBegin").val(today());
  19. $("#EndTimeEnd").val(today());
  20. page.initGird();
  21. page.bind();
  22. },
  23. bind: function () {
  24. $('#multiple_condition_query').lrMultipleQuery(function (queryJson) {
  25. // 调用后台查询
  26. // queryJson 查询条件
  27. var date = $('#lr_search_date_datesearch').html();
  28. if (date == '') {
  29. logbegin = '';
  30. logend = '';
  31. }
  32. var starttime = $('#lr_search_date_StartTime').html();
  33. if (starttime == '') {
  34. StartTimeBegin = '';
  35. StartTimeend = '';
  36. }
  37. var endtime = $('#lr_search_date_EndTime').html();
  38. if (endtime == '') {
  39. EndTimeBegin = '';
  40. EndTimeend = '';
  41. }
  42. queryJson["TaskType"] = $("#TaskType").val();
  43. queryJson["BusType"] = $("#BusType").lrselectGet();
  44. queryJson["EndTimeBegin"] = $("#EndTimeBegin").val();
  45. queryJson["EndTimeEnd"] = $("#EndTimeEnd").val();
  46. page.search({ queryJson: JSON.stringify(queryJson) });
  47. }, 250);
  48. // 查询
  49. $('#btn_Search').on('click', function () {
  50. var keyword = $('#txt_Keyword').val();
  51. page.search({ queryJson: JSON.stringify({ keyword: $('#txt_Keyword').val(), TaskType: "100" }) });
  52. });
  53. // 刷新
  54. $('#lr_refresh').on('click', function () {
  55. location.reload();
  56. });
  57. $('#BusType').lrselect({
  58. url: top.$.rootUrl + '/HJManager/Enums/GetTaskBusTypeList',
  59. maxHeight: 180,
  60. allowSearch: false
  61. });
  62. for (let j = 0; j < TaskType.length; j++) {
  63. if (TaskType[j] == '' && j == 0) {
  64. $("#TaskType").append($("<option value='101'>请选择</option>"));
  65. }
  66. else if (TaskType[j] == '') {
  67. continue;
  68. }
  69. else {
  70. $("#TaskType").append($("<option value='" + j + "'>" + TaskType[j] + "</option>"));
  71. }
  72. }
  73. $("#TaskType").append($("<option value='99'>按类型分组</option>"));
  74. $("#TaskType").append($("<option value='100'>不按类型分组</option>"));
  75. // 导出数据
  76. $('#lr_exportnow').on('click', function () {
  77. var subsuid = "";
  78. if (psuid == "") {
  79. psuid = $('#gridtable').attr('id');
  80. }
  81. else if (psuid != "") {
  82. var t = $('#' + psuid).attr('id');
  83. if (t == undefined)
  84. psuid = $('#gridtable').attr('id');
  85. }
  86. var mainGridId = $('#gridtable').attr('id');
  87. learun.layerForm({
  88. id: "ExcelExportForm",
  89. title: '导出Excel数据',
  90. url: top.$.rootUrl + '/Utility/ExcelExportForm?mainGridId=' + mainGridId + '&gridId=' + psuid + '&filename=' + encodeURI(encodeURI("导出任务小时报表")),
  91. width: 500,
  92. height: 380,
  93. callBack: function (id) {
  94. return top[id].acceptClick();
  95. },
  96. btn: ['导出Excel', '关闭']
  97. });
  98. });
  99. $('#lr_exportall').on('click', function () {
  100. //var where = $("#queryWhere").val();
  101. var query = $('#multiple_condition_query').lrGetFormData();
  102. query["EndTimeBegin"] = $("#EndTimeBegin").val();
  103. query["EndTimeEnd"] = $("#EndTimeEnd").val();
  104. query["TaskType"] = $("#TaskType").val();
  105. query["BusType"] = $("#BusType").lrselectGet();
  106. query["keyword"] = $('#txt_Keyword').val();
  107. var queryJson = JSON.stringify(query);
  108. learun.layerForm({
  109. id: "ExcelExportForm",
  110. title: '导出Excel数据',
  111. // url: top.$.rootUrl + '/Utility/ExcelExportForm?mainGridId=' + mainGridId + '&gridId=' + psuid + '&filename=' + encodeURI(encodeURI("库存")),
  112. url: top.$.rootUrl + '/Utility/ExcelExportColumn?gridId=' + $('#gridtable').attr('id') + '&subgridId=',
  113. width: 500,
  114. height: 380,
  115. callBack: function (id) {
  116. return top[id].acceptClick(function (data) {
  117. learun.download({
  118. method: "POST",
  119. url: '/HJManager/Statisticsreport/ExportHourTaskExcel',
  120. param: {
  121. fileName: "导出任务小时报表",
  122. queryJson: queryJson,
  123. exportField: JSON.stringify(data)
  124. }
  125. });
  126. });
  127. },
  128. btn: ['导出Excel', '关闭']
  129. });
  130. });
  131. },
  132. // 初始化列表
  133. initGird: function () {
  134. $('#gridtable').jfGrid({
  135. url: top.$.rootUrl + '/HJManager/Statisticsreport/GetHourTaskPageList',
  136. headData: [
  137. { label: "日期", name: "TaskDate", width: 90, align: "left" },
  138. { label: "类型", name: "TypeName", width: 70, align: "left", },
  139. { label: "0时", name: "A0", width: 45, align: "left", },
  140. { label: "1时", name: "A1", width: 45, align: "left", },
  141. { label: "2时", name: "A2", width: 45, align: "left", },
  142. { label: "3时", name: "A3", width: 45, align: "left", },
  143. { label: "4时", name: "A4", width: 45, align: "left", },
  144. { label: "5时", name: "A5", width: 45, align: "left", },
  145. { label: "6时", name: "A6", width: 45, align: "left", },
  146. { label: "7时", name: "A7", width: 45, align: "left", },
  147. { label: "8时", name: "A8", width: 45, align: "left", },
  148. { label: "9时", name: "A9", width: 45, align: "left", },
  149. { label: "10时", name: "A10", width: 45, align: "left", },
  150. { label: "11时", name: "A11", width: 45, align: "left", },
  151. { label: "12时", name: "A12", width: 45, align: "left", },
  152. { label: "13时", name: "A13", width: 45, align: "left", },
  153. { label: "14时", name: "A14", width: 45, align: "left", },
  154. { label: "15时", name: "A15", width: 45, align: "left", },
  155. { label: "16时", name: "A16", width: 45, align: "left", },
  156. { label: "17时", name: "A17", width: 45, align: "left", },
  157. { label: "18时", name: "A18", width: 45, align: "left", },
  158. { label: "19时", name: "A19", width: 45, align: "left", },
  159. { label: "20时", name: "A20", width: 45, align: "left", },
  160. { label: "21时", name: "A21", width: 45, align: "left", },
  161. { label: "22时", name: "A22", width: 45, align: "left", },
  162. { label: "23时", name: "A23", width: 45, align: "left", },
  163. { label: "合计", name: "Total", width: 55, align: "left", },
  164. ],
  165. mainId: 'TaskDate',
  166. footerrow: true,
  167. isPage: true,
  168. reloadSelected: true,
  169. autowWidth: true,
  170. sidx: 'TaskDate',
  171. sord: 'DESC',
  172. onRenderComplete: function (data) {
  173. var dataa = data;
  174. },
  175. });
  176. page.search({ queryJson: JSON.stringify({ keyword: $('#txt_Keyword').val(), TaskType: "100" }) });
  177. },
  178. search: function (param) {
  179. $('#gridtable').jfGridSet('reload', param);
  180. }
  181. };
  182. refreshGirdData = function () {
  183. $('#gridtable').jfGridSet('reload');
  184. };
  185. page.init();
  186. function today() {
  187. var today = new Date();
  188. var h = today.getFullYear();
  189. var m = today.getMonth() + 1;
  190. var d = today.getDate();
  191. var hh = today.getHours();
  192. var mm = today.getMinutes();
  193. var ss = today.getSeconds();
  194. m = m < 10 ? "0" + m : m;
  195. d = d < 10 ? "0" + d : d;
  196. hh = hh < 10 ? "0" + hh : hh;
  197. mm = mm < 10 ? "0" + mm : mm;
  198. ss = ss < 10 ? "0" + ss : ss;
  199. return h + "-" + m + "-" + d + " " + hh + ":" + mm + ":" + ss;
  200. }
  201. }