Index.js 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325
  1. var refreshGirdData;
  2. var logbegin = '';
  3. var logend = '';
  4. var StartTimeBegin = '';
  5. var StartTimeend = '';
  6. var EndTimeBegin = '';
  7. var EndTimeend = '';
  8. var bootstrap = function ($, learun) {
  9. "use strict";
  10. var psuid = "";
  11. var page = {
  12. init: function () {
  13. page.initGird();
  14. page.bind();
  15. },
  16. bind: function () {
  17. $('#multiple_condition_query').lrMultipleQuery(function (queryJson) {
  18. // 调用后台查询
  19. // queryJson 查询条件
  20. var date = $('#lr_search_date_datesearch').html();
  21. if (date == '') {
  22. logbegin = '';
  23. logend = '';
  24. }
  25. var starttime = $('#lr_search_date_StartTime').html();
  26. if (starttime == '') {
  27. StartTimeBegin = '';
  28. StartTimeend = '';
  29. }
  30. var endtime = $('#lr_search_date_EndTime').html();
  31. if (endtime == '') {
  32. EndTimeBegin = '';
  33. EndTimeend = '';
  34. }
  35. //queryJson["AddTimeFrom"] = logbegin;
  36. //queryJson["AddTimeTo"] = logend;
  37. queryJson["ID"] = $("#ID").val();
  38. queryJson["BarCode"] = $("#BarCode").val();
  39. queryJson["MaterialCode"] = $("#MaterialCode").val();
  40. queryJson["AddrFrom"] = $("#AddrFrom").val();
  41. queryJson["AddrTo"] = $("#AddrTo").val();
  42. queryJson["AddrNext"] = $("#AddrNext").val();
  43. //queryJson["WmsTask"] = $("#WmsTask").val();
  44. //queryJson["AgvTaskID"] = $("#AgvTaskID").val();
  45. //queryJson["StartTimeBegin"] = StartTimeBegin;
  46. //queryJson["StartTimeEnd"] = StartTimeend;
  47. //queryJson["EndTimeBegin"] = EndTimeBegin;
  48. //queryJson["EndTimeEnd"] = EndTimeend;
  49. queryJson["AddTimeFrom"] = $("#AddTimeFrom").val();
  50. queryJson["AddTimeTo"] = $("#AddTimeTo").val();
  51. queryJson["StartTimeBegin"] = $("#StartTimeBegin").val();
  52. queryJson["StartTimeEnd"] = $("#StartTimeEnd").val();
  53. queryJson["EndTimeBegin"] = $("#EndTimeBegin").val();
  54. queryJson["EndTimeEnd"] = $("#EndTimeEnd").val();
  55. queryJson["Type"] = $("#Type").lrselectGet();
  56. queryJson["Status"] = $("#Status").lrselectGet();
  57. queryJson["OutType"] = $("#OutType").lrselectGet();
  58. queryJson["BusType"] = $("#BusType").lrselectGet();
  59. queryJson["Tunnel"] = $("#Tunnel").val();
  60. //queryJson["Floor"] = $("#Floor").val();
  61. queryJson["Device"] = $("#Device").val();
  62. queryJson["TaskGroupKey"] = $("#TaskGroupKey").val();
  63. page.search({ queryJson: JSON.stringify(queryJson) });
  64. }, 250);
  65. // 查询
  66. $('#btn_Search').on('click', function () {
  67. var keyword = $('#txt_Keyword').val();
  68. page.search({ queryJson: JSON.stringify({ keyword: $('#txt_Keyword').val() }) });
  69. });
  70. // 刷新
  71. $('#lr_refresh').on('click', function () {
  72. location.reload();
  73. });
  74. // 导出数据
  75. $('#lr_exportnow').on('click', function () {
  76. var subsuid = "";
  77. if (psuid == "") {
  78. psuid = $('#gridtable').attr('id');
  79. }
  80. else if (psuid != "") {
  81. var t = $('#' + psuid).attr('id');
  82. if (t == undefined)
  83. psuid = $('#gridtable').attr('id');
  84. }
  85. var mainGridId = $('#gridtable').attr('id');
  86. learun.layerForm({
  87. id: "ExcelExportForm",
  88. title: '导出Excel数据',
  89. url: top.$.rootUrl + '/Utility/ExcelExportForm?mainGridId=' + mainGridId + '&gridId=' + psuid + '&filename=' + encodeURI(encodeURI("历史任务")),
  90. width: 500,
  91. height: 380,
  92. callBack: function (id) {
  93. return top[id].acceptClick();
  94. },
  95. btn: ['导出Excel', '关闭']
  96. });
  97. });
  98. //导出
  99. $('#lr_exportall').on('click', function () {
  100. //var where = $("#queryWhere").val();
  101. var query = $('#multiple_condition_query').lrGetFormData();
  102. query["ID"] = $("#ID").val();
  103. query["BarCode"] = $("#BarCode").val();
  104. query["MaterialCode"] = $("#MaterialCode").val();
  105. query["AddrFrom"] = $("#AddrFrom").val();
  106. query["AddrTo"] = $("#AddrTo").val();
  107. query["AddrNext"] = $("#AddrNext").val();
  108. query["AddTimeFrom"] = $("#AddTimeFrom").val();
  109. query["AddTimeTo"] = $("#AddTimeTo").val();
  110. query["StartTimeBegin"] = $("#StartTimeBegin").val();
  111. query["StartTimeEnd"] = $("#StartTimeEnd").val();
  112. query["EndTimeBegin"] = $("#EndTimeBegin").val();
  113. query["EndTimeEnd"] = $("#EndTimeEnd").val();
  114. query["Type"] = $("#Type").lrselectGet();
  115. query["Status"] = $("#Status").lrselectGet();
  116. query["OutType"] = $("#OutType").lrselectGet();
  117. query["BusType"] = $("#BusType").lrselectGet();
  118. query["Tunnel"] = $("#Tunnel").val();
  119. query["Device"] = $("#Device").val();
  120. query["TaskGroupKey"] = $("#TaskGroupKey").val();
  121. query["keyword"] = $('#txt_Keyword').val();
  122. var queryJson = JSON.stringify(query);
  123. learun.layerForm({
  124. id: "ExcelExportForm",
  125. title: '导出Excel数据',
  126. // url: top.$.rootUrl + '/Utility/ExcelExportForm?mainGridId=' + mainGridId + '&gridId=' + psuid + '&filename=' + encodeURI(encodeURI("库存")),
  127. url: top.$.rootUrl + '/Utility/ExcelExportColumn?gridId=' + $('#gridtable').attr('id') + '&subgridId=',
  128. width: 500,
  129. height: 380,
  130. callBack: function (id) {
  131. return top[id].acceptClick(function (data) {
  132. learun.download({
  133. method: "POST",
  134. url: '/CPManager/Tasks/ExportExcel',
  135. param: {
  136. fileName: "导出历史任务",
  137. queryJson: queryJson,
  138. exportField: JSON.stringify(data)
  139. }
  140. });
  141. });
  142. },
  143. btn: ['导出Excel', '关闭']
  144. });
  145. });
  146. $('.datetime').each(function () {
  147. $(this).lrdatetime({
  148. dfdata: [
  149. { name: '今天', begin: function () { return learun.getDate('yyyy-MM-dd 00:00:00') }, end: function () { return learun.getDate('yyyy-MM-dd 23:59:59') } },
  150. { name: '近7天', begin: function () { return learun.getDate('yyyy-MM-dd 00:00:00', 'd', -6) }, end: function () { return learun.getDate('yyyy-MM-dd 23:59:59') } },
  151. { name: '近1个月', begin: function () { return learun.getDate('yyyy-MM-dd 00:00:00', 'm', -1) }, end: function () { return learun.getDate('yyyy-MM-dd 23:59:59') } },
  152. { name: '近3个月', begin: function () { return learun.getDate('yyyy-MM-dd 00:00:00', 'm', -3) }, end: function () { return learun.getDate('yyyy-MM-dd 23:59:59') } },
  153. ],
  154. // 月
  155. mShow: false,
  156. premShow: false,
  157. // 季度
  158. jShow: false,
  159. prejShow: false,
  160. // 年
  161. ysShow: false,
  162. yxShow: false,
  163. preyShow: false,
  164. yShow: false,
  165. // 默认
  166. dfvalue: 'all',
  167. selectfn: function (begin, end) {
  168. let id = $(this).attr('id');
  169. if (id == 'datesearch') {
  170. logbegin = begin;
  171. logend = end;
  172. }
  173. else if (id == 'StartTime') {
  174. StartTimeBegin = begin;
  175. StartTimeend = end;
  176. }
  177. else if (id == 'EndTime') {
  178. EndTimeBegin = begin;
  179. EndTimeend = end;
  180. }
  181. }
  182. });
  183. });
  184. $('#Type').lrselect({
  185. url: top.$.rootUrl + '/CPManager/Enums/GetTaskTypeList',
  186. maxHeight: 180,
  187. allowSearch: false
  188. });
  189. $('#Status').lrselect({
  190. url: top.$.rootUrl + '/CPManager/Enums/GetTaskStatusList',
  191. maxHeight: 180,
  192. allowSearch: false
  193. });
  194. $('#OutType').lrselect({
  195. url: top.$.rootUrl + '/CPManager/Enums/GetAutoManualOutTypeList',
  196. maxHeight: 180,
  197. allowSearch: false
  198. });
  199. $('#BusType').lrselect({
  200. url: top.$.rootUrl + '/CPManager/Enums/GetTaskBusTypeList',
  201. maxHeight: 180,
  202. allowSearch: false
  203. });
  204. },
  205. // 初始化列表
  206. initGird: function () {
  207. $('#gridtable').jfGrid({
  208. url: top.$.rootUrl + '/CPManager/Tasks/GetPageList',
  209. headData: [
  210. { label: "任务号", name: "ID", width: 140, align: "left" },
  211. { label: "托盘码", name: "BarCode", width: 120, align: "left" },
  212. { label: "箱号", name: "TaskGroupKey", width: 90, align: "left" },
  213. { label: "任务类型", name: "TypeName", width: 90, align: "left", sortname: "Type" },
  214. { label: "任务状态", name: "StatusName", width: 90, align: "left", sortname: "Status" },
  215. { label: "起始地址", name: "AddrFrom", width: 100, align: "left" },
  216. { label: "目标地址", name: "AddrTo", width: 100, align: "left" },
  217. { label: "下一个地址", name: "AddrNext", width: 100, align: "left" },
  218. { label: "业务类型", name: "BusType", width: 130, align: "left", sortname: "BusType" },
  219. { label: "巷道", name: "Tunnel", width: 50, align: "left" },
  220. { label: "设备", name: "Device", width: 60, align: "left" },
  221. { label: "重量", name: "Weight", width: 110, align: "left" },
  222. { label: "产品编码", name: "MaterialCode", width: 120, align: "left" },
  223. { label: "物料编码", name: "MatCode", width: 110, align: "left" },
  224. { label: "库存编码", name: "InvBarCode", width: 110, align: "left" },
  225. { label: "高度", name: "Height", width: 110, align: "left" },
  226. { label: "等级", name: "Grade", width: 110, align: "left" },
  227. { label: "优先级", name: "Priority", width: 80, align: "left" },
  228. { label: "手动处理备注", name: "ManualRemarks", width: 150, align: "left" },
  229. { label: "产品长度", name: "Length", width: 90, align: "left" },
  230. { label: "手/自动", name: "OutTypeName", width: 115, align: "left", sortname: "OutType" },
  231. { label: "堆垛机放货站台", name: "SrmStation", width: 95, align: "left" },
  232. { label: "开始时间", name: "StartTime", width: 130, align: "left" },
  233. { label: "结束时间", name: "EndTime", width: 130, align: "left" },
  234. //{ label: "码垛单号", name: "DocID", width: 150, align: "left" },
  235. //{ label: "码垛托盘类型", name: "PalletType", width: 150, align: "left" },
  236. //{ label: "码垛工位", name: "ProdLine", width: 150, align: "left" },
  237. //{ label: "满盘数量", name: "FullQty", width: 150, align: "left" },
  238. //{ label: "高度", name: "Height", width: 150, align: "left" },
  239. //{ label: "WMS任务号", name: "WmsTask", width: 120, align: "left" },
  240. { label: "更新状态", name: "UploadedName", width: 90, align: "left", sortname: "Uploaded" },
  241. {
  242. label: "改手盘标记", name: "IsSurplus", width: 80, align: "left"
  243. , formatter: function (cellvalue) {
  244. if (cellvalue == true) {
  245. return '<span class=\"label label-success\" >是</span>';
  246. } else {
  247. return '<span class=\"label label-default\" >否</span>';
  248. }
  249. }
  250. },
  251. {
  252. label: "返工标记", name: "IsRework", width: 80, align: "left", formatter: function (cellvalue) {
  253. if (cellvalue == true) {
  254. return '<span class=\"label label-success\" >是</span>';
  255. } else {
  256. return '<span class=\"label label-default\" >否</span>';
  257. }
  258. }
  259. },
  260. {
  261. label: "快投标记", name: "IsFast", width: 80, align: "left", formatter: function (cellvalue) {
  262. if (cellvalue == true) {
  263. return '<span class=\"label label-success\" >是</span>';
  264. } else {
  265. return '<span class=\"label label-default\" >否</span>';
  266. }
  267. }
  268. },
  269. { label: "机台号", name: "WorkBench", width: 120, align: "left" },
  270. { label: "仓库编码", name: "WarehouseCode", width: 110, align: "left" },
  271. { label: "创建时间", name: "AddTime", width: 130, align: "left" },
  272. { label: "更新时间", name: "EditTime", width: 130, align: "left" },
  273. { label: "创建用户", name: "AddWho", width: 110, align: "left" },
  274. { label: "更新用户", name: "EditWho", width: 110, align: "left" },
  275. ],
  276. mainId: 'ID',
  277. isPage: true,
  278. reloadSelected: true,
  279. sidx: 'AddTime',
  280. sord: 'DESC',
  281. isSubGrid: true, // 是否有子表
  282. subGridExpanded: function (subid, rowdata) {
  283. psuid = subid;
  284. $('#' + subid).jfGrid({
  285. url: top.$.rootUrl + '/CPManager/Tasks/GetTaskItem',
  286. headData: [
  287. { label: '任务号', name: 'ParentTaskCode', index: 'ParentTaskCode', width: 140, align: 'left' },
  288. { label: '当前位置', name: 'CurPoint', width: 210, align: "left" },
  289. { label: '下个位置', name: 'NextPoint', width: 190, align: "left" },
  290. { label: '描述', name: 'Desc', width: 360, align: "left" },
  291. { label: "创建时间", name: "AddTime", width: 215, align: "left" },
  292. { label: "创建用户", name: "AddWho", width: 110, align: "left" },
  293. ]
  294. });
  295. $('#' + subid).jfGridSet('reloadSon', { taskid: rowdata.ID, adddate: rowdata.AddTime });
  296. },
  297. });
  298. page.search({ queryJson: JSON.stringify({ keyword: $('#txt_Keyword').val() }) });
  299. },
  300. search: function (param) {
  301. $('#gridtable').jfGridSet('reload', param);
  302. }
  303. };
  304. refreshGirdData = function () {
  305. $('#gridtable').jfGridSet('reload');
  306. };
  307. page.init();
  308. }