var refreshGirdData; var OneInTimebegin = ''; var OneInTimeend = ''; var ProductTimebegin = ''; var ProductTimeend = ''; var logbegin = ''; var logend = ''; var bootstrap = function ($, learun) { "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["Code"] = $("#Code").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(); }); $('#ContGrpType').lrselect({ url: top.$.rootUrl + '/CPManager/Enums/GetContGrpTypeList', maxHeight: 180, allowSearch: false }); $('#InvStateCode').lrselect({ url: top.$.rootUrl + '/CPManager/Enums/GetInvStateList', maxHeight: 180, 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 query = $('#multiple_condition_query').lrGetFormData(); query["Code"] = $("#Code").val(); query["keyword"] = $('#txt_Keyword').val(); var queryJson = JSON.stringify(query); 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: '/CPManager/report/ExportLocationUsageReportExcel', param: { fileName: "导出货位使用率报表", queryJson: queryJson, exportField: JSON.stringify(data) } }); }); }, btn: ['导出Excel', '关闭'] }); }); }, // 初始化列表 initGird: function () { $('#gridtable').jfGrid({ url: top.$.rootUrl + '/CPManager/Report/GetLocationUsageReportList', headData: [ { label: "仓库名", name: "WarehouseName", width: 130, align: "left" }, { label: "巷道", name: "Tunnel", width: 80, align: "left", }, { label: "巷道入库状态", name: "InStates", width: 120, align: "left", }, { label: "巷道出库状态", name: "OutStates", width: 120, align: "left", }, { label: "总货位", name: "AllLocationTotal", width: 90, align: "left" }, { label: "有效货位", name: "CanUseLocation", width: 90, align: "left" }, { label: "空余货位", name: "SpareLocation", width: 90, align: "left" }, { label: "有料货位", name: "MaterilLocation", width: 90, align: "left" }, { label: "锁定货位", name: "LockLocation", width: 90, align: "left" }, { label: "停用货位", name: "StopLocation", width: 90, align: "left" }, { label: "货位使用率", name: "MaterialUsage", width: 80, align: "left" }, ], mainId: 'Tunnel', footerrow:true, isPage: false, reloadSelected: true, autowWidth: true, sidx: 'Tunnel', sord: 'DESC', onRenderComplete: function (data) { var dataa = data; }, }); page.search({ queryJson: JSON.stringify({ keyword: $('#txt_Keyword').val() }) }); }, search: function (param) { $('#gridtable').jfGridSet('reload', param); } }; refreshGirdData = function () { $('#gridtable').jfGridSet('reload'); }; page.init(); }