WEBUI/WMS.BZWeb/Areas/FJManager/Views/Report/StockKeepReportIndex.js

var refreshGirdData;
var OneInTimebegin = '';
var OneInTimeend = '';
var ProductTimebegin = '';
var ProductTimeend = '';
var logbegin = '';
var logend = '';

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 查询条件                 

            }, 250);
            // 查询
            $('#btn_Search').on('click', function () {
                var keyword = $('#txt_Keyword').val();

                page.search({ queryJson: JSON.stringify({ keyword: keyword }) });
            });
            // 刷新 
            $('#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 queryJson = $('#multiple_condition_query').lrGetFormData();


                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: '/FJManager/report/ExportStockKeepReportExcel',
                                param: {
                                    fileName: "导出库龄报表",
                                    queryJson: query,
                                    exportField: JSON.stringify(data)

                                }
                            });
                        });
                    },
                    btn: ['导出Excel', '关闭']
                });
            });
        },
        // 初始化列表 
        initGird: function () {
            $('#gridtable').jfGrid({
                url: top.$.rootUrl + '/FJManager/Report/GetStockKeepReportList',
                headData: [
                    { label: "物料编码", name: "MatCode", width: 210, align: "left" },
                    { label: "物料名称", name: "MatName", width: 220, align: "left" },
                    { label: "0-7天", name: "StockKeepTime7", width: 100, align: "left", sortname:"SUM(( CASE  WHEN ((DATEDIFF(Day,[EditTime],getdate()) >= 0 ) AND (DATEDIFF(Day,[EditTime],getdate()) <= 7 )) THEN 1  ELSE 0 END ))"},
                    { label: "7-15天", name: "StockKeepTime15", width: 100, align: "left", sortname: "SUM(( CASE  WHEN ((DATEDIFF(Day,[EditTime],getdate()) > 7 ) AND (DATEDIFF(Day,[EditTime],getdate()) <= 15 )) THEN 1  ELSE 0 END ))" },
                    { label: "15-30天", name: "StockKeepTime30", width: 100, align: "left", sortname: "SUM(( CASE  WHEN ((DATEDIFF(Day,[EditTime],getdate()) > 15 ) AND (DATEDIFF(Day,[EditTime],getdate()) <= 30 )) THEN 1  ELSE 0 END ))" },
                    { label: "30天以上", name: "StockKeepTime31", width: 100, align: "left", sortname: "SUM(( CASE  WHEN (DATEDIFF(Day,[EditTime],getdate()) > 30 ) THEN 1  ELSE 0 END )) " },
                ],
                mainId: 'MatCode',
                isPage: true,
                reloadSelected: true,
                autowWidth: true,
                sidx: 'MatCode',
                sord: 'ASC',
            });
            page.search({ queryJson: JSON.stringify({ keyword: $('#txt_Keyword').val() }) });
        },
        search: function (param) {

            $('#gridtable').jfGridSet('reload', param);
        }
    };
    refreshGirdData = function () {
        $('#gridtable').jfGridSet('reload');
    };
    page.init();
}