HourTaskIndex.js 9.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216
  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. console.log(queryJson);
  43. queryJson["TaskType"] = $("#TaskType").val();
  44. queryJson["BusType"] = $("#BusType").lrselectGet();
  45. queryJson["EndTimeBegin"] = $("#EndTimeBegin").val();
  46. queryJson["EndTimeEnd"] = $("#EndTimeEnd").val();
  47. page.search({ queryJson: JSON.stringify(queryJson) });
  48. }, 250);
  49. // 查询
  50. $('#btn_Search').on('click', function () {
  51. var keyword = $('#txt_Keyword').val();
  52. page.search({ queryJson: JSON.stringify({ keyword: $('#txt_Keyword').val(), TaskType: "100" }) });
  53. });
  54. // 刷新
  55. $('#lr_refresh').on('click', function () {
  56. location.reload();
  57. });
  58. $('#BusType').lrselect({
  59. url: top.$.rootUrl + '/CPManager/Enums/GetTaskBusTypeList',
  60. maxHeight: 180,
  61. allowSearch: false
  62. });
  63. for (let j = 0; j < TaskType.length; j++) {
  64. if (TaskType[j] == '' && j==0) {
  65. $("#TaskType").append($("<option value='101'>请选择</option>"));
  66. }
  67. else if (TaskType[j] == '') {
  68. continue;
  69. }
  70. else {
  71. $("#TaskType").append($("<option value='" + j + "'>" + TaskType[j] + "</option>"));
  72. }
  73. }
  74. $("#TaskType").append($("<option value='99'>按类型分组</option>"));
  75. $("#TaskType").append($("<option value='100'>不按类型分组</option>"));
  76. // 导出数据
  77. $('#lr_exportnow').on('click', function () {
  78. var subsuid = "";
  79. if (psuid == "") {
  80. psuid = $('#gridtable').attr('id');
  81. }
  82. else if (psuid != "") {
  83. var t = $('#' + psuid).attr('id');
  84. if (t == undefined)
  85. psuid = $('#gridtable').attr('id');
  86. }
  87. var mainGridId = $('#gridtable').attr('id');
  88. learun.layerForm({
  89. id: "ExcelExportForm",
  90. title: '导出Excel数据',
  91. url: top.$.rootUrl + '/Utility/ExcelExportForm?mainGridId=' + mainGridId + '&gridId=' + psuid + '&filename=' + encodeURI(encodeURI("导出任务小时报表")),
  92. width: 500,
  93. height: 380,
  94. callBack: function (id) {
  95. return top[id].acceptClick();
  96. },
  97. btn: ['导出Excel', '关闭']
  98. });
  99. });
  100. $('#lr_exportall').on('click', function () {
  101. //var where = $("#queryWhere").val();
  102. var query = $('#multiple_condition_query').lrGetFormData();
  103. query["EndTimeBegin"] = $("#EndTimeBegin").val();
  104. query["EndTimeEnd"] = $("#EndTimeEnd").val();
  105. query["TaskType"] = $("#TaskType").val();
  106. query["BusType"] = $("#BusType").lrselectGet();
  107. query["keyword"] = $('#txt_Keyword').val();
  108. var queryJson = JSON.stringify(query);
  109. learun.layerForm({
  110. id: "ExcelExportForm",
  111. title: '导出Excel数据',
  112. // url: top.$.rootUrl + '/Utility/ExcelExportForm?mainGridId=' + mainGridId + '&gridId=' + psuid + '&filename=' + encodeURI(encodeURI("库存")),
  113. url: top.$.rootUrl + '/Utility/ExcelExportColumn?gridId=' + $('#gridtable').attr('id') + '&subgridId=',
  114. width: 500,
  115. height: 380,
  116. callBack: function (id) {
  117. return top[id].acceptClick(function (data) {
  118. learun.download({
  119. method: "POST",
  120. url: '/CPManager/Statisticsreport/ExportHourTaskExcel',
  121. param: {
  122. fileName: "导出任务小时报表",
  123. queryJson: queryJson,
  124. exportField: JSON.stringify(data)
  125. }
  126. });
  127. });
  128. },
  129. btn: ['导出Excel', '关闭']
  130. });
  131. });
  132. },
  133. // 初始化列表
  134. initGird: function () {
  135. $('#gridtable').jfGrid({
  136. url: top.$.rootUrl + '/CPManager/Statisticsreport/GetHourTaskPageList',
  137. headData: [
  138. { label: "日期", name: "TaskDate", width: 90, align: "left" },
  139. { label: "类型", name: "TypeName", width: 70, align: "left", },
  140. { label: "0时", name: "A0", width: 45, align: "left", },
  141. { label: "1时", name: "A1", width: 45, align: "left", },
  142. { label: "2时", name: "A2", width: 45, align: "left", },
  143. { label: "3时", name: "A3", width: 45, align: "left", },
  144. { label: "4时", name: "A4", width: 45, align: "left", },
  145. { label: "5时", name: "A5", width: 45, align: "left", },
  146. { label: "6时", name: "A6", width: 45, align: "left", },
  147. { label: "7时", name: "A7", width: 45, align: "left", },
  148. { label: "8时", name: "A8", width: 45, align: "left", },
  149. { label: "9时", name: "A9", width: 45, align: "left", },
  150. { label: "10时", name: "A10", width: 45, align: "left", },
  151. { label: "11时", name: "A11", width: 45, align: "left", },
  152. { label: "12时", name: "A12", width: 45, align: "left", },
  153. { label: "13时", name: "A13", width: 45, align: "left", },
  154. { label: "14时", name: "A14", width: 45, align: "left", },
  155. { label: "15时", name: "A15", width: 45, align: "left", },
  156. { label: "16时", name: "A16", width: 45, align: "left", },
  157. { label: "17时", name: "A17", width: 45, align: "left", },
  158. { label: "18时", name: "A18", width: 45, align: "left", },
  159. { label: "19时", name: "A19", width: 45, align: "left", },
  160. { label: "20时", name: "A20", width: 45, align: "left", },
  161. { label: "21时", name: "A21", width: 45, align: "left", },
  162. { label: "22时", name: "A22", width: 45, align: "left", },
  163. { label: "23时", name: "A23", width: 45, align: "left", },
  164. { label: "合计", name: "Total", width: 55, align: "left", },
  165. ],
  166. mainId: 'TaskDate',
  167. footerrow: true,
  168. isPage: true,
  169. reloadSelected: true,
  170. autowWidth: true,
  171. sidx: 'TaskDate',
  172. sord: 'DESC',
  173. onRenderComplete: function (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. }