saas-platform/frontend/saas-web/app/view/money/report/CustomerCheck.js

Ext.define('saas.view.money.report.CustomerCheckCheck', {
    extend: 'saas.view.core.report.ReportPanel',
    xtype: 'monry-report-customercheck',

    controller: 'money-report-customercheck',
    viewModel: 'money-report-customercheck',

    viewName: 'money-report-customercheck',

    // groupField: 'pi_custname',
    listUrl: '/api/money/report/customercheck',
    defaultCondition: null,
    reportTitle: '客户对账单',
    QueryWidth: 0.4,
    autoLoad: false,
    allowCust: true,
    
    //筛选：客户、日期（必填）
    searchItems: [{
        xtype: 'customerDbfindTrigger',
        name: 'pi_custname',
        emptyText: '请输入客户名称',
        columnWidth: 0.2,
        listeners: {
            beforequery: function(f) {
                return !!f.value;
            },
            change: 'pi_custname_change'
        }
    }, {
        xtype: 'condatefield',
        name: 'pi_date',
        fieldLabel: '日期',
        columnWidth: 0.4
    }],

    reportModel: 'saas.model.report.CustomerCheck',

    reportColumns: [{
        text: '单据日期',
        dataIndex: 'pi_date',
        xtype: 'datecolumn',
        width: 110
    }, {
        text: '单号',
        dataIndex: 'pi_inoutno',
        width: 150
    }, {
        text: '业务类型',
        align: 'center',
        dataIndex: 'pi_class',
        width: 100
    }, {
        text: '序号',
        align: 'center',
        dataIndex: 'pd_pdno',
        exportFormat: 'Integer',
        xtype: 'numbercolumn',
        width: 65
    }, {
        text: '物料编号',
        width: 150,
        dataIndex: 'pr_code'
    }, {
        text: '品牌',
        dataIndex: 'pr_brand',
        width: 100
    }, {
        text: '物料名称',
        dataIndex: 'pr_detail',
        width: 150
    }, {
        text: '型号',
        dataIndex: 'pr_orispeccode',
        width: 200
    }, {
        text: '规格',
        dataIndex: 'pr_spec',
        width: 200
    }, {
        text: '数量',
        xtype: 'numbercolumn',
        exportFormat: 'Quantity',
        dataIndex: 'qty',
        width: 110,
        renderer: function(v) {
            return saas.util.BaseUtil.numberFormat(v, 3, false);
        }
    }, {
        text: '单位',
        dataIndex: 'pd_unit',
        width: 65
    }, {
        text: '单价(元)',
        dataIndex: 'pd_netprice',
        exportFormat: 'Price',
        xtype: 'numbercolumn',
        width: 120,
        renderer: function(v) {
            return saas.util.BaseUtil.numberFormat(v, 4, true);
        }
    }, {
        text: '含税单价(元)',
        dataIndex: 'pd_sendprice',
        exportFormat: 'Price',
        xtype: 'numbercolumn',
        width: 120,
        renderer: function(v) {
            return saas.util.BaseUtil.numberFormat(v, 4, true);
        }
    }, {
        text: '金额(元)',
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        width: 120,
        dataIndex: 'pd_nettotal',
        renderer : function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        },
    }, {
        text: '税率(%)',
        dataIndex: 'pd_taxrate',
        exportFormat: 'Integer',
        xtype: 'numbercolumn',
        width: 80,
        renderer: function(v) {
            return saas.util.BaseUtil.numberFormat(v, 2, false);
        }
    }, {
        text: '税额(元)',
        width: 120,
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        dataIndex: 'pd_ordertotal-pd_nettotal',
        renderer : function(v, m, r) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
            var format = '0,000.' + xr.join('');
            return Ext.util.Format.number(v, format);
        },
        summaryType: 'sum',
        summaryLabel: '税额',
        summaryRenderer: function(v) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        }
    }, {
        text: '价税合计(元)',
        width: 120,
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        dataIndex: 'pd_ordertotal',
        renderer : function(v, m, r) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
            var format = '0,000.' + xr.join('');
            return Ext.util.Format.number(v, format);
        },
        // summaryType: 'sum',
        // summaryLabel: '价税合计(本位币)',
        // summaryRenderer: function(v) {
        //     return saas.util.BaseUtil.numberFormat(v, 2, true);
        // }
    },{
        text: '币别',
        dataIndex: 'pi_currency',
        width: 80
    },{
        text: '汇率',
        dataIndex: 'pi_rate',
        exportFormat: 'Integer',
        xtype: 'numbercolumn',
        width: 100,
        renderer: function(v) {
            return saas.util.BaseUtil.numberFormat(v, 4, false);
        }
    },{
        text: '价税合计(本位币)',
        width: 140,
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        dataIndex: 'pi_mytotal',
        renderer : function(v, m, r) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
            var format = '0,000.' + xr.join('');
            return Ext.util.Format.number(v, format);
        },
        summaryType: 'sum',
        summaryLabel: '价税合计(本位币)',
        summaryRenderer: function(v,m,r) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        }
    }],

    listeners: {
        afterrender: function(panel) {
            panel.setLoadButtonDisabled(true);
        },
        beforequery: function(panel) {
            var form = panel.items.items[0];
            var values = form.getValues();
            var pi_custname = values.pi_custname;

            if(!pi_custname) {
                saas.util.BaseUtil.showErrorToast('请先选择【<span style="color: red;">客户名称</span>】');
                return false;
            }
            return true;
        }
    },

    setLoadButtonDisabled: function (disabled) {
        var panel = this,
            grid = panel.down('grid'),
            p = grid.down('pagingtoolbar'),
            bs = p.query('button'),
            loadButton = Ext.Array.findBy(bs, function (b) {
                return b.iconCls == 'x-tbar-loading';
            });

        if (loadButton) {
            loadButton.setDisabled(disabled);
        }
    },

    applyParams: function (p) {
        var me = this,
            viewModel = me.getViewModel(),
            formData = viewModel.get('form'),
            ym = formData.ym;

        return Ext.Object.merge(p, {
            ym: ym
        });
    }
});