Index.js 18 KB

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