WEBUI/WMS.BZWeb/Areas/KLHCManager/Views/Statisticsreport/BomSetGrpRateIndex.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 = "";
    var page = {
        init: function () {
            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["MatCode"] = $("#MatCode").val();
                queryJson["MatName"] = $("#MatName").val();
                queryJson["Status"] = $("#Status").lrselectGet();
                queryJson["AddTimeFrom"] = $("#AddTimeFrom").val();
                queryJson["AddTimeTo"] = $("#AddTimeTo").val();
                queryJson["StartTimeBegin"] = $("#StartTimeBegin").val();
                queryJson["StartTimeEnd"] = $("#StartTimeEnd").val();
                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() }) });
            });
            // 刷新 
            $('#lr_refresh').on('click', function () {
                location.reload();
            });
            $('#Status').lrselect({
                url: top.$.rootUrl + '/FJManager/Enums/GetTaskStatusList',
                maxHeight: 180,
                allowSearch: false
            });
            //$('.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;
            //            }
            //        }
            //    });
            //});
            // 导出数据
            $('#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["MatCode"] = $("#MatCode").val();
                query["MatName"] = $("#MatName").val();
                query["Status"] = $("#Status").lrselectGet();
                query["AddTimeFrom"] = $("#AddTimeFrom").val();
                query["AddTimeTo"] = $("#AddTimeTo").val();
                query["StartTimeBegin"] = $("#StartTimeBegin").val();
                query["StartTimeEnd"] = $("#StartTimeEnd").val();
                query["EndTimeBegin"] = $("#EndTimeBegin").val();
                query["EndTimeEnd"] = $("#EndTimeEnd").val();

                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: '/FJManager/Statisticsreport/ExportBomSetGrpCurrentMaterialRateExcel',
                                param: {
                                    fileName: "导出跺型当前来料比报表",
                                    queryJson: queryJson,
                                    exportField: JSON.stringify(data)

                                }
                            });
                        });
                    },
                    btn: ['导出Excel', '关闭']
                });



            });
        },
        // 初始化列表 
        initGird: function () {
            $('#gridtable').jfGrid({
                url: top.$.rootUrl + '/FJManager/Statisticsreport/GetBomSetGrpCurrentMaterialRateList',
                headData: [
                    { label: "跺型名称", name: "BomSetName", width: 180, align: "left", sortname: '' },
                    { label: "物料编码", name: "MatCode", width: 160, align: "left"  },
                    { label: "数量", name: "Qty", width: 80, align: "left", sortname: "COUNT(1)" },
                    { label: "占比", name: "RateName", width: 80, align: "left", sortname: "" },
                    { label: "正常占比", name: "NormalRateName", width: 80, align: "left", sortname: "" },
                    { label: "占比差", name: "DiffRateName", width: 80, align: "left", sortname: "" },
                   { label: "数量差", name: "DiffQty", width: 80, align: "left", sortname: "" },
                ],
                mainId: 'SetGrpBomCode',
                isPage: true,
                reloadSelected: true,
                autowWidth: true,
                //sidx: 'AddTime',
                //sord: 'DESC',
                onRenderComplete: function () {
                    var datas = $('#gridtable').jfGridGet("rowdatas");
                    for (var i = 0; i < datas.length; i++) {
                        if (datas[i].DiffRate < 0) {
                           // $('.jfgrid-data-cell').find('[rowindex='+i+'] ').addClass("SelectBG");
                            $('.jfgrid-data-cell[rowindex=' + i + ']').addClass("SelectBG");
                        }
                    }

                
                }
            });
            page.search({ queryJson: JSON.stringify({ keyword: $('#txt_Keyword').val() }) });
        },
        search: function (param) {
            $('#gridtable').jfGridSet('reload', param);
        }
    };
    refreshGirdData = function () {
        $('#gridtable').jfGridSet('reload');
    };
    page.init();
}