var refreshGirdData; var OneInTimebegin = ''; var OneInTimeend = ''; var ProductTimebegin = ''; var ProductTimeend = ''; var logbegin = ''; var logend = ''; var StartTimeBegin = ''; var StartTimeend = ''; var EndTimeBegin = ''; var EndTimeend = ''; 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 starttime = $('#lr_search_date_StartTime').html(); if (starttime == '') { StartTimeBegin = ''; StartTimeend = ''; } var endtime = $('#lr_search_date_EndTime').html(); if (endtime == '') { EndTimeBegin = ''; EndTimeend = ''; } console.log(queryJson); queryJson["AddTimeFrom"] = logbegin; queryJson["AddTimeTo"] = logend; queryJson["ContGrpBarCode"] = $("#ContGrpBarCode").val(); queryJson["MatCode"] = $("#MatCode").val(); queryJson["RFIDBarCode"] = $("#RFIDBarCode").val(); queryJson["MatName"] = $("#MatName").val(); queryJson["CellCode"] = $("#CellCode").val(); queryJson["Tunnel"] = $("#Tunnel").val(); queryJson["InvBarCode"] = $("#InvBarCode").val(); queryJson["StartTimeBegin"] = StartTimeBegin; queryJson["StartTimeEnd"] = StartTimeend; queryJson["EndTimeBegin"] = EndTimeBegin; queryJson["EndTimeEnd"] = EndTimeend; queryJson["IsSurplus"] = $("#IsSurplus").lrselectGet(); queryJson["IsRework"] = $("#IsRework").lrselectGet(); queryJson["IsFast"] = $("#IsFast").lrselectGet(); queryJson["IsFail"] = $("#IsFail").lrselectGet(); queryJson["IsBack"] = $("#IsBack").lrselectGet(); 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(); }); $('.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; } } }); }); $('#ContGrpType').lrselect({ url: top.$.rootUrl + '/FJManager/Enums/GetContGrpTypeList', maxHeight: 180, allowSearch: false }); $('#InvStateCode').lrselect({ url: top.$.rootUrl + '/FJManager/Enums/GetInvStateList', maxHeight: 180, allowSearch: false }); $('#WarehouseId').lrselect({ url: top.$.rootUrl + '/FJManager/BaseWarehouse/GetSelectWarehouseNameListByType?typenum=1', maxHeight: 180, allowSearch: false }); $('#IsSurplus').lrselect({ url: top.$.rootUrl + '/FJManager/Enums/YesNoList', maxHeight: 60, allowSearch: false }); $('#IsRework').lrselect({ url: top.$.rootUrl + '/FJManager/Enums/YesNoList', maxHeight: 60, allowSearch: false }); $('#IsFast').lrselect({ url: top.$.rootUrl + '/FJManager/Enums/YesNoList', maxHeight: 60, allowSearch: false }); $('#IsFail').lrselect({ url: top.$.rootUrl + '/FJManager/Enums/YesNoList', maxHeight: 60, allowSearch: false }); $('#IsBack').lrselect({ url: top.$.rootUrl + '/FJManager/Enums/YesNoList', maxHeight: 60, allowSearch: false }); // 导出数据 $('#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 queryJson = $('#multiple_condition_query').lrGetFormData(); queryJson["AddTimeFrom"] = logbegin; queryJson["AddTimeTo"] = logend; queryJson["ContGrpBarCode"] = $("#ContGrpBarCode").val(); queryJson["MatCode"] = $("#MatCode").val(); queryJson["RFIDBarCode"] = $("#RFIDBarCode").val(); queryJson["MatName"] = $("#MatName").val(); queryJson["CellCode"] = $("#CellCode").val(); queryJson["Tunnel"] = $("#Tunnel").val(); queryJson["InvBarCode"] = $("#InvBarCode").val(); queryJson["StartTimeBegin"] = StartTimeBegin; queryJson["StartTimeEnd"] = StartTimeend; queryJson["EndTimeBegin"] = EndTimeBegin; queryJson["EndTimeEnd"] = EndTimeend; queryJson["IsSurplus"] = $("#IsSurplus").lrselectGet(); queryJson["IsRework"] = $("#IsRework").lrselectGet(); queryJson["IsFast"] = $("#IsFast").lrselectGet(); queryJson["IsFail"] = $("#IsFail").lrselectGet(); queryJson["IsBack"] = $("#IsBack").lrselectGet(); queryJson["keyword"] = $('#txt_Keyword').val(); var query = JSON.stringify(queryJson); learun.layerForm({ id: "ExcelExportForm", title: '导出物料出入库报表', // 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/report/ExportExcel', param: { fileName: "导出物料出入库报表", queryJson: query, exportField: JSON.stringify(data) } }); }); }, btn: ['导出Excel', '关闭'] }); }); }, // 初始化列表 initGird: function () { $('#gridtable').jfGrid({ url: top.$.rootUrl + '/FJManager/Report/GetPageList', headData: [ { label: "仓库", name: "WarehouseName", width: 110, align: "left" }, { label: "容器条码", name: "ContGrpBarCode", width: 120, align: "left" }, { label: "操作状态", name: "InvStateName", width: 80, align: "left", sortname: "InvStateCode" }, { label: "材料号", name: "InvBarCode", width: 110, align: "left" }, { label: "货位号", name: "Code", width: 110, align: "left" }, { label: "巷道号", name: "Tunnel", width: 80, align: "left" }, { label: "物料编码", name: "MatCode", width: 120, align: "left" }, { label: "物料名称", name: "MatName", width: 120, align: "left" }, { label: "备注", name: "Memo", width: 130, align: "left" }, { label: "RFID条码", name: "RFIDBarCode", width: 120, align: "left" }, { label: "库存状态", name: "ExecStateCode", width: 80, align: "left", formatter: function (cellvalue) { if (cellvalue == "InvState_Normal") { return '正常'; } if (cellvalue == "InvState_Lock") { return '锁定'; } } }, { label: "长度", name: "LengthQty", width: 80, align: "left" }, { label: "生产时间", name: "ProductTime", width: 130, align: "left" }, { label: "创建时间", name: "AddTime", width: 130, align: "left" }, { label: "修改时间", name: "EditTime", width: 130, align: "left" }, { label: "开始时间", name: "StartTime", width: 130, align: "left" }, { label: "结束时间", name: "EndTime", width: 130, align: "left" }, { 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: "IsBack", width: 80, align: "left", formatter: function (cellvalue) { if (cellvalue == true) { return ''; } else { return ''; } } }, { label: "异常原因", name: "FailReason", width: 80, align: "left" }, { label: "退料原因", name: "BackReason", width: 80, align: "left" }, { label: "客户编码", name: "CustCode", width: 80, align: "left" }, { label: "客户名称", name: "CustName", width: 80, align: "left" }, { label: "执行单据号", name: "ExecDocsNo", width: 80, align: "left" }, { label: "执行单据行号", name: "ExecDocsRowNo", width: 80, align: "left" }, { label: "执行单据类型", name: "ExecDocsTypeCode", width: 80, align: "left" }, { label: "入库单据号", name: "InDocsNo", width: 80, align: "left" }, { label: "生产机台号", name: "ProductMachCode", 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: "SuppCode", width: 80, align: "left" }, { label: "供应商名称", name: "SuppName", width: 80, 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(); }