var refreshGirdData; var OneInTimebegin = ''; var OneInTimeend = ''; var ProductTimebegin = ''; var ProductTimeend = ''; var logbegin = ''; var logend = ''; var bootstrap = function ($, learun) { var psuid = ""; "use strict"; var page = { init: function () { page.initGird(); page.bind(); }, bind: function () { $('#multiple_condition_query').lrMultipleQuery(function (queryJson) { // 调用后台查询 // queryJson 查询条件 var oneintime = $('#lr_search_date_OneInTime').html(); if (oneintime == '') { OneInTimebegin = ''; OneInTimeend = ''; } var producttime = $('#lr_search_date_ProductTime').html(); if (producttime == '') { ProductTimebegin = ''; ProductTimeend = ''; } console.log(queryJson); queryJson["MatCode"] = $("#MatCode").val(); queryJson["MatName"] = $("#MatName").val(); queryJson["BoxBarCode"] = $("#BoxBarCode").val(); queryJson["InvBarCode"] = $("#InvBarCode").val(); queryJson["PutRow"] = $("#PutRow").val(); queryJson["PutCol"] = $("#PutCol").val(); queryJson["PutLayer"] = $("#PutLayer").val(); queryJson["OneInTimeBegin"] = $("#OneInTimebegin").val(); queryJson["OneInTimeEnd"] = $("#OneInTimeend").val(); queryJson["ProductTimeBegin"] = $("#ProductTimebegin").val(); queryJson["ProductTimeEnd"] = $("#ProductTimeend").val(); queryJson["Grade"] = $("#Grade").val(); queryJson["DoseNo"] = $("#DoseNo").val(); queryJson["ContGrpType"] = $("#ContGrpType").lrselectGet(); queryJson["InvStateCode"] = $("#InvStateCode").lrselectGet(); queryJson["IsSurplus"] = $("#IsSurplus").lrselectGet(); queryJson["IsRework"] = $("#IsRework").lrselectGet(); queryJson["IsFast"] = $("#IsFast").lrselectGet(); queryJson["IsFail"] = $("#IsFail").lrselectGet(); queryJson["IsBlack"] = $("#IsBlack").lrselectGet(); queryJson["ExecStateCode"] = $("#ExecStateCode").lrselectGet(); queryJson["WbGroupCode"] = $("#WbGroupCode").val(); queryJson["SolderCount"] = $("#SolderCount").val(); queryJson["HoldTime"] = $("#HoldTime").val(); queryJson["IsControlpanel"] = $("#IsControlpanel").lrselectGet(); queryJson["IsTorsChk"] = $("#IsTorsChk").lrselectGet(); queryJson["IsCore"] = $("#IsCore").lrselectGet(); queryJson["TorsChkQty"] = $("#TorsChkQty").lrselectGet(); queryJson["Wind"] = $("#Wind").val(); page.search({ queryJson: JSON.stringify(queryJson) }); }, 250); // 查询 $('#btn_Search').on('click', function () { var keyword = $('#txt_Keyword').val(); page.search({ queryJson: JSON.stringify({ keyword: keyword }) }); }); // 刷新 $('#lr_refresh').on('click', function () { location.reload(); }); //$('#lr_pass').on('click', function () { // var postData = $('#gridtable').jfGridGet("rowdata"); // if (postData.length == 0) { // learun.alert.error('未选择行!'); // return false; // } // learun.layerConfirm('是否确认放行该箱号!', function (res) { // if (res) { // learun.postForm(top.$.rootUrl + '/SXManager/BillInvflowHistory/UpdatePassStates', { ids: JSON.stringify(postData.map((item) => item.Id)) }, function () { // refreshGirdData(); // }); // } // }); //}); // 导出数据 $('#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 query = $('#multiple_condition_query').lrGetFormData(); // query["Btime"] = logbegin; // query["Etime"] = logend; // query["keyword"] = $('#txt_Keyword').val(); // var queryJson = JSON.stringify(query); // if ($('#jfgrid_head_' + psuid).length == 0) { // learun.alert.warning('请任意展开一行子表'); // return false; // } // learun.layerForm({ // id: "ExcelExportColumn", // title: '导出Excel数据', // url: top.$.rootUrl + '/Utility/ExcelExportColumn?gridId=' + $('#gridtable').attr('id') + '&subgridId=' + psuid, // width: 600, // height: 480, // callBack: function (id) { // return top[id].acceptClick(function (data) { // learun.download({ // method: "POST", // url: top.$.rootUrl + '/TaskManager/EquipmentTask_Dis/ExportExcel', // param: { // fileName: encodeURI("WCS历史任务"), // queryJson: queryJson, // exportField: JSON.stringify(data) // } // }); // }); // }, // btn: ['导出Excel', '关闭'] // }); //}); //导出 $('#lr_exportall').on('click', function () { //var where = $("#queryWhere").val(); var query = $('#multiple_condition_query').lrGetFormData(); query["MatCode"] = $("#MatCode").val(); query["MatName"] = $("#MatName").val(); query["BoxBarCode"] = $("#BoxBarCode").val(); query["InvBarCode"] = $("#InvBarCode").val(); query["PutRow"] = $("#PutRow").val(); query["PutCol"] = $("#PutCol").val(); query["PutLayer"] = $("#PutLayer").val(); query["OneInTimeBegin"] = $("#OneInTimebegin").val(); query["OneInTimeEnd"] = $("#OneInTimeend").val(); query["ProductTimeBegin"] = $("#ProductTimebegin").val(); query["ProductTimeEnd"] = $("#ProductTimeend").val(); query["Grade"] = $("#Grade").val(); query["DoseNo"] = $("#DoseNo").val(); query["ContGrpType"] = $("#ContGrpType").lrselectGet(); query["InvStateCode"] = $("#InvStateCode").lrselectGet(); query["IsSurplus"] = $("#IsSurplus").lrselectGet(); query["IsRework"] = $("#IsRework").lrselectGet(); query["IsFast"] = $("#IsFast").lrselectGet(); query["IsFail"] = $("#IsFail").lrselectGet(); query["IsBlack"] = $("#IsBlack").lrselectGet(); query["ExecStateCode"] = $("#ExecStateCode").lrselectGet(); query["WbGroupCode"] = $("#WbGroupCode").val(); query["SolderCount"] = $("#SolderCount").val(); query["HoldTime"] = $("#HoldTime").val(); query["IsControlpanel"] = $("#IsControlpanel").lrselectGet(); query["IsTorsChk"] = $("#IsTorsChk").lrselectGet(); query["IsCore"] = $("#IsCore").lrselectGet(); query["TorsChkQty"] = $("#TorsChkQty").lrselectGet(); query["Wind"] = $("#Wind").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: '/SXManager/BillInvflowHistory/ExportExcel', param: { fileName: "导出流水历史报表", queryJson: queryJson, exportField: JSON.stringify(data) } }); }); }, btn: ['导出Excel', '关闭'] }); }); $('#OneInTime').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) { OneInTimebegin = begin; OneInTimeend = end; } }); $('#ProductTime').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) { ProductTimebegin = begin; ProductTimeend = end; } }); $('#ContGrpType').lrselect({ url: top.$.rootUrl + '/SXManager/Enums/GetContGrpTypeList', maxHeight: 180, allowSearch: false }); $('#InvStateCode').lrselect({ url: top.$.rootUrl + '/SXManager/Enums/GetInvStateList', maxHeight: 180, allowSearch: false }); $('#ExecStateCode').lrselect({ url: top.$.rootUrl + '/SXManager/Enums/InvLockStateList', maxHeight: 60, allowSearch: false }); $('#IsSurplus').lrselect({ url: top.$.rootUrl + '/SXManager/Enums/YesNoList', maxHeight: 60, allowSearch: false }); $('#IsRework').lrselect({ url: top.$.rootUrl + '/SXManager/Enums/YesNoList', maxHeight: 60, allowSearch: false }); $('#IsFast').lrselect({ url: top.$.rootUrl + '/SXManager/Enums/YesNoList', maxHeight: 60, allowSearch: false }); $('#IsFail').lrselect({ url: top.$.rootUrl + '/SXManager/Enums/YesNoList', maxHeight: 60, allowSearch: false }); $('#IsBlack').lrselect({ url: top.$.rootUrl + '/SXManager/Enums/YesNoList', maxHeight: 60, allowSearch: false }); $('#IsControlpanel').lrselect({ url: top.$.rootUrl + '/SXManager/Enums/YesNoList', maxHeight: 60, allowSearch: false }); $('#IsTorsChk').lrselect({ url: top.$.rootUrl + '/SXManager/Enums/YesNoList', maxHeight: 60, allowSearch: false }); $('#IsCore').lrselect({ url: top.$.rootUrl + '/SXManager/Enums/YesNoList', maxHeight: 60, allowSearch: false }); $('#IsTimeOut').lrselect({ url: top.$.rootUrl + '/SXManager/Enums/YesNoList', maxHeight: 60, allowSearch: false }); $('#TorsChkQty').lrselect({ url: top.$.rootUrl + '/SXManager/Enums/YesNoList', maxHeight: 60, allowSearch: false }); }, // 初始化列表 initGird: function () { $('#gridtable').jfGrid({ url: top.$.rootUrl + '/SXManager/BillInvflowHistory/GetPageList', headData: [ { label: "容器条码", name: "ContGrpBarCode", width: 130, align: "left" }, { label: "库存类型", name: "ContGrpTypeName", width: 60, align: "left", sortname: "ContGrpType" }, { label: "材料号", name: "InvBarCode", width: 110, align: "left" }, { label: "库存状态", name: "InvStateName", width: 80, align: "left", sortname: "InvStateCode" }, //{ label: "巷道", name: "Tunnel", width: 50, align: "left" }, //{ label: "货位号", name: "Code", width: 100, align: "left" }, //{ // label: "货位状态", name: "CellState", width: 80, align: "left" // , formatter: function (cellvalue) { // if (cellvalue == 0) { // return '启用'; // } else { // return '禁用'; // } // } //}, { label: "箱号", name: "BoxBarCode", width: 120, align: "left" }, { label: "SKU", name: "SkuCode", width: 80, align: "left" }, { label: "机台组", name: "WbGroupCode", width: 80, align: "left" }, { label: "工字轮类型", name: "HWTypeCode", width: 90, align: "left" }, { label: "焊点数量", name: "SolderCount", width: 90, align: "left" }, { label: "静止时长", name: "HoldTime", width: 90, align: "left" }, { label: "是否控制盘", name: "IsControlpanel", width: 90, align: "left", formatter: function (cellvalue) { if (cellvalue == true) { return ''; } else { return ''; } } }, { label: "是否需要扭转", name: "IsTorsChk", width: 90, align: "left", formatter: function (cellvalue) { if (cellvalue == true) { return ''; } else { return ''; } } }, { label: "是否芯股", name: "IsCore", width: 90, align: "left", formatter: function (cellvalue) { if (cellvalue == true) { return ''; } else { return ''; } } }, { label: "预锁单号", name: "SalesDoc", width: 120, align: "left" }, { label: "行", name: "PutRow", width: 40, align: "left" }, { label: "列", name: "PutCol", width: 40, align: "left" }, { label: "层", name: "PutLayer", width: 40, align: "left" }, { label: "首次入库时间", name: "OneInTime", width: 130, align: "left" }, learun.jfFormatter.col_DateTime("生产时间", "ProductTime"), { label: "物料编码", name: "MatCode", width: 110, align: "left" }, { label: "物料名称", name: "MatName", width: 80, align: "left" }, { label: "总重量", name: "TolWQty", width: 80, align: "left" }, { label: "净重", name: "NetWQty", width: 80, align: "left" }, { label: "皮重", name: "TareWQty", width: 80, align: "left" }, { label: "长度", name: "LengthQty", width: 80, align: "left" }, { label: "是否余料", name: "IsSurplus", width: 80, align: "left" , formatter: function (cellvalue) { if (cellvalue == true) { return ''; } else { return ''; } } }, { label: "是否黑盘", name: "IsBlack", 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: "IsFail", width: 80, align: "left", formatter: function (cellvalue) { if (cellvalue == true) { return ''; } else { return ''; } } }, { label: "是否锁定", name: "ExecStateCode", width: 80, align: "left" , formatter: function (cellvalue) { if (cellvalue == "InvState_Normal") { return ''; } else { return ''; } } }, { label: "是否已扭转", name: "TorsChkQty", width: 80, align: "left" , formatter: function (cellvalue) { if (cellvalue == true) { return ''; } else { return ''; } } }, { label: "预锁库存", name: "PreStock", width: 120, align: "left" }, { label: "绕向", name: "Wind", width: 120, align: "left" }, { label: "异常原因", name: "FailReason", width: 80, align: "left" }, { label: "等级", name: "Grade", width: 80, align: "left" }, { label: "退料原因", name: "BackReason", width: 80, align: "left" }, { label: "工序订单号", name: "ProcessDocsCode", width: 120, align: "left" }, { label: "生产机台号", name: "ProductMachCode", width: 80, align: "left" }, { label: "产线编号", name: "ProductLineNo", width: 80, align: "left" }, { label: "入库单号", name: "InDocsNo", width: 120, align: "left" }, { label: "入库单行号", name: "InDocsRowNo", width: 120, align: "left" }, { label: "扭转检测弓高", name: "TorsChkChord", width: 80, align: "left" }, { label: "弓高是否合格", name: "TorsChkChordIsGood", width: 80, align: "left" }, { label: "扭转检测平直度", name: "TorsChkFlatness", width: 80, align: "left" }, { label: "平直度是否合格", name: "TorsChkFlatnessIsGood", width: 80, align: "left" }, { label: "扭转机台工位", name: "TorsChkStation", width: 80, align: "left" }, { label: "扭转值是否合格", name: "TorsChkValueIsGood", width: 80, align: "left" }, { label: "创建时间", name: "AddTime", width: 130, align: "left" }, { label: "更新时间", name: "EditTime", width: 130, align: "left" }, ], mainId: 'Id', isPage: true, reloadSelected: true, autowWidth: true, sidx: 'AddTime', sord: 'DESC', }); page.search({ queryJson: JSON.stringify({ keyword: $('#txt_Keyword').val() }) }); }, search: function (param) { $('#gridtable').jfGridSet('reload', param); } }; refreshGirdData = function () { $('#gridtable').jfGridSet('reload'); }; page.init(); }