WEBUI/WMS.BZWeb/Areas/SXManager/Views/Report/Index.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) {
    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["BoxBarCode"] = $("#BoxBarCode").val();
                queryJson["MatName"] = $("#MatName").val();
                queryJson["Code"] = $("#Code").val();
                queryJson["Tunnel"] = $("#Tunnel").val();
                queryJson["InvBarCode"] = $("#InvBarCode").val();

                queryJson["InDocsNo"] = $("#InDocsNo").val();
                queryJson["ProductMachCode"] = $("#ProductMachCode").val();
                queryJson["ExecDocsNo"] = $("#ExecDocsNo").val();
                queryJson["InvStateCode"] = $("#InvStateCode").lrselectGet();

                queryJson["StartTimeBegin"] = $("#StartTimeBegin").val();
                queryJson["StartTimeEnd"] = $("#StartTimeEnd").val();
                queryJson["EndTimeBegin"] = $("#EndTimeBegin").val();
                queryJson["EndTimeEnd"] = $("#EndTimeEnd").val();

                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 + '/SXManager/Enums/GetContGrpTypeList',
                maxHeight: 180,
                allowSearch: false
            });
            $('#InvStateCode').lrselect({
                url: top.$.rootUrl + '/SXManager/Enums/GetInvStateList',
                maxHeight: 180,
                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
            });
            $('#IsBack').lrselect({
                url: top.$.rootUrl + '/SXManager/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["BoxBarCode"] = $("#BoxBarCode").val();
                queryJson["MatName"] = $("#MatName").val();
                queryJson["Code"] = $("#Code").val();
                queryJson["Tunnel"] = $("#Tunnel").val();
                queryJson["InvBarCode"] = $("#InvBarCode").val();

                queryJson["InDocsNo"] = $("#InDocsNo").val();
                queryJson["ProductMachCode"] = $("#ProductMachCode").val();
                queryJson["ExecDocsNo"] = $("#ExecDocsNo").val();
                queryJson["InvStateCode"] = $("#InvStateCode").lrselectGet();

                queryJson["StartTimeBegin"] = $("#StartTimeBegin").val();
                queryJson["StartTimeEnd"] = $("#StartTimeEnd").val();
                queryJson["EndTimeBegin"] = $("#EndTimeBegin").val();
                queryJson["EndTimeEnd"] = $("#EndTimeEnd").val();

                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: '/SXManager/report/ExportExcel',
                                param: {
                                    fileName: "导出物料出入库报表",
                                    queryJson: query,
                                    exportField: JSON.stringify(data)

                                }
                            });
                        });
                    },
                    btn: ['导出Excel', '关闭']
                });
            });
        },
        // 初始化列表 
        initGird: function () {
            $('#gridtable').jfGrid({
                url: top.$.rootUrl + '/SXManager/Report/GetPageList',
                headData: [

                    { 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: "BoxBarCode", width: 120, align: "left" },
                    {
                        label: "库存状态", name: "ExecStateCode", width: 80, align: "left", formatter: function (cellvalue) {
                            if (cellvalue == "InvState_Normal") {
                                return '<span class=\"label label-success\"  >正常</span>';
                            }
                            if (cellvalue == "InvState_Lock") {
                                return '<span class=\"label  label-default\" >锁定</span>';
                            }
                        }
                    },
                    { label: "箱重", name: "HuTotalWt", width: 80, align: "left" },
                    { label: "备注", name: "Memo", width: 130, align: "left" },
                    { 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 '<span class=\"label label-success\"  >是</span>';
                            } else {
                                return '<span class=\"label  label-default\" >否</span>';
                            }
                        }
                    },
                    {
                        label: "是否异常", name: "IsFail", width: 80, align: "left", formatter: function (cellvalue) {
                            if (cellvalue == true) {
                                return '<span class=\"label label-success\"  >是</span>';
                            } else {
                                return '<span class=\"label  label-default\" >否</span>';
                            }
                        }
                    },
                    {
                        label: "是否退料", name: "IsBack", width: 80, align: "left", formatter: function (cellvalue) {
                            if (cellvalue == true) {
                                return '<span class=\"label label-success\"  >是</span>';
                            } else {
                                return '<span class=\"label  label-default\" >否</span>';
                            }
                        }
                    },
                    { 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: "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();
}