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

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

    controller: 'money-report-paydetail',
    viewModel: 'money-report-paydetail',
    viewName: 'money-report-paydetail',

    groupField: 'groupfield',
    groupHeaderTpl: '{[values.rows[0].data.pd_vendname]} ({[values.rows[0].data.pd_currency]})',
    listUrl: '/api/money/report/payDetail',
    defaultCondition: null,
    reportTitle: '应付账款明细表',
    QueryWidth:0.25,
    allowPaging: false,

    //筛选：供应商、日期（必填）
    searchItems: [ {
        xtype: 'vendorDbfindTrigger',
        name: 'pd_vendname',
        emptyText:'请输入供应商名称',
        columnWidth: 0.25
    }, {
        xtype: 'conmonthfield',
        name: 'pd_ym',
        fieldLabel: '期间',
        columnWidth: 0.5
    }],

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

    reportColumns: [{
        text: '单据日期',
        xtype: 'datecolumn',
        dataIndex: 'pd_date',
        width: 110
    }, {
        text: '单号',
        dataIndex: 'pd_code',
        width: 150
    }, {
        text: '业务类型',
        dataIndex: 'pd_kind',
        width: 100
    },{
        text: '采购员',
        dataIndex: 'pd_buyername',
        width: 80
    }, {
        text: '币别',
        dataIndex: 'pd_currency',
        align:'center',
        width: 65
    },{
        text: '汇率',
        dataIndex: 'pd_rate',
        align:'center',
        width: 65,
        renderer: function (v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 6, false);
        }
    },{
        text: '增加应付(元)',
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        dataIndex: 'pd_addpay',
        width: 120,
        renderer : function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        },
        summaryType: 'sum',
        disableMySummary:true,
        summaryRenderer: function(v) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        },
    },{
        hidden:true,
        text: '增加应付(本位币)(元)',
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        dataIndex: 'pd_addpay_cr',
        width: 160,
        renderer : function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        },
        summaryLabel: '增加应付(本位币)',
        summaryType: 'customize_sum',
        summaryRenderer: function(v) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        },
        mySummaryRenderer: function(grid, column, datas) {
            return grid.store.sum(column.dataIndex)
        }
    }, {
        text: '增加预付(元)',
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        dataIndex: 'pd_addpre',
        width: 120,
        renderer : function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        },
        summaryType: 'sum',
        disableMySummary:true,
        summaryRenderer: function(v) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        }
    },{
        hidden:true,
        text: '增加预付(本位币)(元)',
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        dataIndex: 'pd_addpre_cr',
        width: 160,
        renderer : function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        },
        summaryLabel: '增加预付(本位币)',
        summaryType: 'customize_sum',
        summaryRenderer: function(v) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        },
        mySummaryRenderer: function(grid, column, datas) {
            return grid.store.sum(column.dataIndex)
        }
    }, {
        text: '应付余额(元)',
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        dataIndex: 'pd_remain',
        width: 120,
        renderer : function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        },
        summaryType: 'customize_last',
        disableMySummary:true,
        summaryRenderer: function(v) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        }
    },{
        hidden:true,
        text: '应付余额(本位币)',
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        dataIndex: 'pd_remain_cr',
        width: 160,
        renderer : function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        },
        summaryLabel: '应付余额(本位币)',
        summaryType: 'customize_sum',
        summaryRenderer: function(v) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        },
        mySummaryRenderer: function(grid, column, datas) {
            let sum = 0;
            Ext.each(grid.store.data.items,function(rec,index){
                if((index+1)<grid.store.data.items.length){
                    //校验是否变更了数据
                    let nowGroup = rec.get('groupfield')
                    let nextGroup = grid.store.data.items[index+1].get('groupfield')
                    if(nowGroup!=nextGroup){
                        sum+=rec.get('pd_remain')*rec.get('pd_rate')
                    }
                }else{
                    sum+=rec.get('pd_remain')*rec.get('pd_rate')
                }
            });
            return saas.util.BaseUtil.numberFormat(sum, 2, true);
        }
    }, {
        dataIndex: '',
        flex: 1
    }]
});