WEBUI/WMS.BZWeb/Areas/SXManager/Views/Statisticsreport/HourTaskIndex.js

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($("<option value='101'>请选择</option>"));
                } 
                else {
                    $("#TaskType").append($("<option value='"+j+"'>" + TaskType[j] + "</option>"));
                }
            }
            $("#TaskType").append($("<option value='99'>按类型分组</option>"));
            $("#TaskType").append($("<option value='100'>不按类型分组</option>"));
            // 刷新 
            $('#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;
    }
}