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) { "use strict"; var psuid = ""; const TaskType = ["", "入库", "出库", "移库"]; var page = { init: function () { $("#EndTimeBegin").val(today()); $("#EndTimeEnd").val(today()); 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 = ''; } console.log(queryJson); queryJson["TaskType"] = $("#TaskType").val(); queryJson["BusType"] = $("#BusType").lrselectGet(); queryJson["EndTimeBegin"] = $("#EndTimeBegin").val(); queryJson["EndTimeEnd"] = $("#EndTimeEnd").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(), TaskType: "100" }) }); }); $('#BusType').lrselect({ url: top.$.rootUrl + '/SXManager/Enums/SxTaskBusTypeDescList', maxHeight: 180, allowSearch: false }); for (let j = 0; j < TaskType.length; j++) { if (TaskType[j] == '') { $("#TaskType").append($("")); } else { $("#TaskType").append($("")); } } $("#TaskType").append($("")); $("#TaskType").append($("")); // 刷新 $('#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["EndTimeBegin"] = $("#EndTimeBegin").val(); query["EndTimeEnd"] = $("#EndTimeEnd").val(); query["TaskType"] = $("#TaskType").val(); query["BusType"] = $("#BusType").lrselectGet(); 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/Statisticsreport/ExportHourTaskExcel', param: { fileName: "导出任务小时报表", queryJson: queryJson, exportField: JSON.stringify(data) } }); }); }, btn: ['导出Excel', '关闭'] }); }); }, // 初始化列表 initGird: function () { $('#gridtable').jfGrid({ url: top.$.rootUrl + '/SXManager/Statisticsreport/GetHourTaskPageList', headData: [ { label: "日期", name: "TaskDate", width: 90, align: "left", sortname:"TaskDate"}, { label: "类型", name: "TypeName", width: 70, align: "left", }, { label: "0时", name: "A0", width: 45, align: "left", }, { label: "1时", name: "A1", width: 45, align: "left", }, { label: "2时", name: "A2", width: 45, align: "left", }, { label: "3时", name: "A3", width: 45, align: "left", }, { label: "4时", name: "A4", width: 45, align: "left", }, { label: "5时", name: "A5", width: 45, align: "left", }, { label: "6时", name: "A6", width: 45, align: "left", }, { label: "7时", name: "A7", width: 45, align: "left", }, { label: "8时", name: "A8", width: 45, align: "left", }, { label: "9时", name: "A9", width: 45, align: "left", }, { label: "10时", name: "A10", width: 45, align: "left", }, { label: "11时", name: "A11", width: 45, align: "left", }, { label: "12时", name: "A12", width: 45, align: "left", }, { label: "13时", name: "A13", width: 45, align: "left", }, { label: "14时", name: "A14", width: 45, align: "left", }, { label: "15时", name: "A15", width: 45, align: "left", }, { label: "16时", name: "A16", width: 45, align: "left", }, { label: "17时", name: "A17", width: 45, align: "left", }, { label: "18时", name: "A18", width: 45, align: "left", }, { label: "19时", name: "A19", width: 45, align: "left", }, { label: "20时", name: "A20", width: 45, align: "left", }, { label: "21时", name: "A21", width: 45, align: "left", }, { label: "22时", name: "A22", width: 45, align: "left", }, { label: "23时", name: "A23", width: 45, align: "left", }, { label: "合计", name: "Total", width: 55, align: "left", }, ], mainId: 'TaskDate', footerrow: true, isPage: true, reloadSelected: true, autowWidth: true, sidx: 'TaskDate', sord: 'DESC', onRenderComplete: function (data) { }, }); page.search({ queryJson: JSON.stringify({ keyword: $('#txt_Keyword').val(), TaskType:"100" }) }); }, search: function (param) { $('#gridtable').jfGridSet('reload', param); } }; refreshGirdData = function () { $('#gridtable').jfGridSet('reload'); }; page.init(); function today() { var today = new Date(); var h = today.getFullYear(); var m = today.getMonth() + 1; var d = today.getDate(); var hh = today.getHours(); var mm = today.getMinutes(); var ss = today.getSeconds(); m = m < 10 ? "0" + m : m; d = d < 10 ? "0" + d : d; hh = hh < 10 ? "0" + hh : hh; mm = mm < 10 ? "0" + mm : mm; ss = ss < 10 ? "0" + ss : ss; return h + "-" + m + "-" + d + " " + hh + ":" + mm + ":" + ss; } }