var refreshGirdData; var logbegin = ''; var logend = ''; var StartTimeBegin = ''; var StartTimeend = ''; var EndTimeBegin = ''; var EndTimeend = ''; var bootstrap = function ($, learun) { "use strict"; var psuid = ""; var page = { init: function () { page.initGird(); page.bind(); }, bind: function () { $('#multiple_condition_query').lrMultipleQuery(function (queryJson) { // 调用后台查询 // queryJson 查询条件 var date = $('#lr_search_date_datesearch').html(); if (date == '') { logbegin = ''; logend = ''; } var starttime = $('#lr_search_date_StartTime').html(); if (starttime == '') { StartTimeBegin = ''; StartTimeend = ''; } var endtime = $('#lr_search_date_EndTime').html(); if (endtime == '') { EndTimeBegin = ''; EndTimeend = ''; } //queryJson["AddTimeFrom"] = logbegin; //queryJson["AddTimeTo"] = logend; queryJson["ID"] = $("#ID").val(); queryJson["BarCode"] = $("#BarCode").val(); queryJson["MaterialCode"] = $("#MaterialCode").val(); queryJson["AddrFrom"] = $("#AddrFrom").val(); queryJson["AddrTo"] = $("#AddrTo").val(); queryJson["AddrNext"] = $("#AddrNext").val(); queryJson["WmsTask"] = $("#WmsTask").val(); queryJson["AgvTaskID"] = $("#AgvTaskID").val(); queryJson["AddTimeFrom"] = $("#AddTimeFrom").val(); queryJson["AddTimeTo"] = $("#AddTimeTo").val(); queryJson["StartTimeBegin"] = $("#StartTimeBegin").val(); queryJson["StartTimeEnd"] = $("#StartTimeEnd").val(); queryJson["EndTimeBegin"] = $("#EndTimeBegin").val(); queryJson["EndTimeEnd"] = $("#EndTimeEnd").val(); //queryJson["StartTimeBegin"] = StartTimeBegin; //queryJson["StartTimeEnd"] = StartTimeend; //queryJson["EndTimeBegin"] = EndTimeBegin; //queryJson["EndTimeEnd"] = EndTimeend; queryJson["Type"] = $("#Type").lrselectGet(); queryJson["Status"] = $("#Status").lrselectGet(); /* queryJson["OutType"] = $("#OutType").lrselectGet();*/ queryJson["BusType"] = $("#BusType").lrselectGet(); queryJson["Tunnel"] = $("#Tunnel").val(); queryJson["Floor"] = $("#Floor").val(); queryJson["Device"] = $("#Device").val(); queryJson["WorkBench"] = $("#WorkBench").val(); queryJson["WarehouseCode"] = $("#WarehouseId").lrselectGet(); queryJson["Grade"] = $("#Grade").val(); queryJson["MatCode"] = $("#MatCode").val(); page.search({ queryJson: JSON.stringify(queryJson) }); }, 250); // 查询 $('#btn_Search').on('click', function () { var keyword = $('#txt_Keyword').val(); page.search({ queryJson: JSON.stringify({ keyword: $('#txt_Keyword').val() }) }); }); // 刷新 $('#lr_refresh').on('click', function () { location.reload(); }); // 导出数据 $('#lr_exportnow').on('click', function () { var subsuid = ""; if (psuid == "") { psuid = $('#gridtable').attr('id'); } else if (psuid != "") { var t = $('#' + psuid).attr('id'); if (t == undefined) psuid = $('#gridtable').attr('id'); } var mainGridId = $('#gridtable').attr('id'); learun.layerForm({ id: "ExcelExportForm", title: '导出Excel数据', url: top.$.rootUrl + '/Utility/ExcelExportForm?mainGridId=' + mainGridId + '&gridId=' + psuid + '&filename=' + encodeURI(encodeURI("历史任务")), width: 500, height: 380, callBack: function (id) { return top[id].acceptClick(); }, btn: ['导出Excel', '关闭'] }); }); //导出 $('#lr_exportall').on('click', function () { //var where = $("#queryWhere").val(); var query = $('#multiple_condition_query').lrGetFormData(); query["ID"] = $("#ID").val(); query["BarCode"] = $("#BarCode").val(); query["MaterialCode"] = $("#MaterialCode").val(); query["AddrFrom"] = $("#AddrFrom").val(); query["AddrTo"] = $("#AddrTo").val(); query["AddrNext"] = $("#AddrNext").val(); query["WmsTask"] = $("#WmsTask").val(); query["AgvTaskID"] = $("#AgvTaskID").val(); query["AddTimeFrom"] = $("#AddTimeFrom").val(); query["AddTimeTo"] = $("#AddTimeTo").val(); query["StartTimeBegin"] = $("#StartTimeBegin").val(); query["StartTimeEnd"] = $("#StartTimeEnd").val(); query["EndTimeBegin"] = $("#EndTimeBegin").val(); query["EndTimeEnd"] = $("#EndTimeEnd").val(); query["Type"] = $("#Type").lrselectGet(); query["Status"] = $("#Status").lrselectGet(); /* query["OutType"] = $("#OutType").lrselectGet();*/ query["BusType"] = $("#BusType").lrselectGet(); query["Tunnel"] = $("#Tunnel").val(); query["Floor"] = $("#Floor").val(); query["Device"] = $("#Device").val(); query["WorkBench"] = $("#WorkBench").val(); query["WarehouseCode"] = $("#WarehouseId").lrselectGet(); query["Grade"] = $("#Grade").val(); query["MatCode"] = $("#MatCode").val(); query["keyword"] = $('#txt_Keyword').val(); var queryJson = JSON.stringify(query); learun.layerForm({ id: "ExcelExportForm", title: '导出Excel数据', // url: top.$.rootUrl + '/Utility/ExcelExportForm?mainGridId=' + mainGridId + '&gridId=' + psuid + '&filename=' + encodeURI(encodeURI("库存")), url: top.$.rootUrl + '/Utility/ExcelExportColumn?gridId=' + $('#gridtable').attr('id') + '&subgridId=', width: 500, height: 380, callBack: function (id) { return top[id].acceptClick(function (data) { learun.download({ method: "POST", url: '/FJManager/Tasks/ExportExcel', param: { fileName: "导出历史任务", queryJson: queryJson, exportField: JSON.stringify(data) } }); }); }, btn: ['导出Excel', '关闭'] }); }); $('.datetime').each(function () { $(this).lrdatetime({ dfdata: [ { name: '今天', begin: function () { return learun.getDate('yyyy-MM-dd 00:00:00') }, end: function () { return learun.getDate('yyyy-MM-dd 23:59:59') } }, { 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') } }, { 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') } }, { 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') } }, ], // 月 mShow: false, premShow: false, // 季度 jShow: false, prejShow: false, // 年 ysShow: false, yxShow: false, preyShow: false, yShow: false, // 默认 dfvalue: 'all', selectfn: function (begin, end) { let id = $(this).attr('id'); if (id == 'datesearch') { logbegin = begin; logend = end; } else if (id == 'StartTime') { StartTimeBegin = begin; StartTimeend = end; } else if (id == 'EndTime') { EndTimeBegin = begin; EndTimeend = end; } } }); }); $('#WarehouseId').lrselect({ url: top.$.rootUrl + '/FJManager/BaseWarehouse/GetSelectWarehouseCodeNameList', maxHeight: 180, allowSearch: false }); $('#Type').lrselect({ url: top.$.rootUrl + '/FJManager/Enums/GetTaskTypeList', maxHeight: 180, allowSearch: false }); $('#Status').lrselect({ url: top.$.rootUrl + '/FJManager/Enums/GetTaskStatusList', maxHeight: 180, allowSearch: false }); $('#OutType').lrselect({ url: top.$.rootUrl + '/FJManager/Enums/GetAutoManualOutTypeList', maxHeight: 180, allowSearch: false }); $('#BusType').lrselect({ url: top.$.rootUrl + '/FJManager/Enums/GetTaskBusTypeList', maxHeight: 180, allowSearch: false }); }, // 初始化列表 initGird: function () { $('#gridtable').jfGrid({ url: top.$.rootUrl + '/FJManager/Tasks/GetPageList', headData: [ { label: "仓库", name: "WarehouseCode", width: 80, align: "left" }, { label: "任务号", name: "ID", width: 140, align: "left" }, { label: "工字轮编码", name: "BarCode", width: 120, align: "left" }, { label: "生产单号", name: "WorkOrder", width: 120, align: "left" }, /*{ label: "货物大小", name: "GoodsType", width: 90, align: "left" },*/ { label: "任务类型", name: "TypeName", width: 90, align: "left", sortname: "Type" }, { label: "任务状态", name: "StatusName", width: 90, align: "left", sortname: "Status" }, { label: "AGV任务号", name: "AgvTaskID", width: 110, align: "left" }, { label: "起始地址", name: "AddrFrom", width: 100, align: "left" }, { label: "目标地址", name: "AddrTo", width: 100, align: "left" }, { label: "下一个地址", name: "AddrNext", width: 100, align: "left" }, { label: "机台号", name: "WorkBench", width: 120, align: "left" }, { label: "业务类型", name: "BusType", width: 130, align: "left", sortname: "BusType" }, { label: "巷道", name: "Tunnel", width: 50, align: "left" }, { label: "楼层", name: "Floor", width: 50, align: "left" }, { label: "设备", name: "Device", width: 60, align: "left" }, { label: "重量", name: "Weight", width: 110, align: "left" }, { label: "产品编码", name: "MaterialCode", width: 120, align: "left" }, { label: "物料编码", name: "MatCode", width: 110, align: "left" }, { label: "库存编码", name: "InvBarCode", width: 110, align: "left" }, { label: "高度", name: "Height", width: 110, align: "left" }, { label: "等级", name: "Grade", width: 110, align: "left" }, { label: "优先级", name: "Priority", width: 80, align: "left" }, { label: "手动处理备注", name: "ManualRemarks", width: 150, align: "left" }, { label: "产品长度", name: "Length", width: 90, align: "left" }, { label: "手/自动", name: "OutTypeName", width: 115, align: "left", sortname: "OutType" }, { label: "堆垛机放货站台", name: "SrmStation", width: 95, align: "left" }, { label: "开始时间", name: "StartTime", width: 130, align: "left" }, { label: "结束时间", name: "EndTime", width: 130, align: "left" }, //{ label: "码垛单号", name: "DocID", width: 150, align: "left" }, {label: "跺型编号", name: "PalletType", width: 150, align: "left"}, { label: "码垛工位", name: "ProdLine", width: 150, align: "left" }, { label: "满盘数量", name: "FullQty", width: 150, align: "left" }, //{ label: "高度", name: "Height", width: 150, align: "left" }, { label: "WMS任务号", name: "WmsTask", width: 120, align: "left" }, { label: "任务组ID", name: "TaskGroupKey", width: 150, align: "left" }, { label: "更新状态", name: "UploadedName", width: 90, align: "left", sortname: "Uploaded" }, { label: "改手盘标记", name: "IsSurplus", width: 80, align: "left" , formatter: function (cellvalue) { if (cellvalue == true) { return ''; } else { return ''; } } }, { label: "返工标记", name: "IsRework", width: 80, align: "left", formatter: function (cellvalue) { if (cellvalue == true) { return ''; } else { return ''; } } }, { label: "快投标记", name: "IsFast", width: 80, align: "left", formatter: function (cellvalue) { if (cellvalue == true) { return ''; } else { return ''; } } }, { label: "仓库编码", name: "WarehouseCode", width: 110, align: "left" }, { label: "创建时间", name: "AddTime", width: 130, align: "left" }, { label: "更新时间", name: "EditTime", width: 130, align: "left" }, { label: "创建用户", name: "AddWho", width: 110, align: "left" }, { label: "更新用户", name: "EditWho", width: 110, align: "left" }, ], mainId: 'ID', isPage: true, reloadSelected: true, sidx: 'AddTime', sord: 'DESC', isSubGrid: true, // 是否有子表 subGridExpanded: function (subid, rowdata) { psuid = subid; $('#' + subid).jfGrid({ url: top.$.rootUrl + '/FJManager/Tasks/GetTaskItem', headData: [ { label: '任务号', name: 'ParentTaskCode', index: 'ParentTaskCode', width: 140, align: 'left' }, { label: '当前位置', name: 'CurPoint', width: 210, align: "left" }, { label: '下个位置', name: 'NextPoint', width: 190, align: "left" }, { label: '描述', name: 'Desc', width: 360, align: "left" }, { label: "创建时间", name: "AddTime", width: 215, align: "left" }, { label: "创建用户", name: "AddWho", width: 110, align: "left" }, ] }); $('#' + subid).jfGridSet('reloadSon', { taskid: rowdata.ID, adddate: rowdata.AddTime }); }, }); page.search({ queryJson: JSON.stringify({ keyword: $('#txt_Keyword').val() }) }); }, search: function (param) { $('#gridtable').jfGridSet('reload', param); } }; refreshGirdData = function () { $('#gridtable').jfGridSet('reload'); }; page.init(); }