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

/**
 * 应付总账
 */
Ext.define('saas.view.money.report.TotalPayDetail', {
    extend: 'saas.view.core.report.ReportPanel',
    xtype: 'monry-report-totalpaydetail',

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

    viewName: 'money-report-totalpaydetail',

    groupField: null,
    listUrl: '/api/money/report/vendormonthdetails',
    // listUrl: 'http://192.168.253.139:8560/api/money/report/vendormonthdetails',
    defaultCondition: null,
    reportTitle: '应付总账',
    QueryWidth: 0.35,
    allowPaging: false,

    searchItems: [{
        xtype: 'textfield',
        name: 'vm_vendcode',
        emptyText: '供应商编号/名称',
        columnWidth: 0.25,
        getCondition: function (v) {
            return "(upper(vm_vendcode) like '%" + v.toUpperCase() + "%' or upper(vm_vendname) like '%" + v.toUpperCase() + "%')";
        },
    }, {
        xtype: 'conmonthfield',
        fieldLabel: '期间',
        name: 'vm_yearmonth',
        columnWidth: 0.4
    }],

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

    reportColumns: [{
        text: '期间',
        dataIndex: 'vm_yearmonth',
        width: 80,
    }, {
        text: '供应商名称',
        dataIndex: 'vm_vendname',
        width: 200,
    }, {
        text: '期初',
        columns: [{
            text: '预付',
            xtype: 'numbercolumn',
            exportFormat: 'Amount',
            dataIndex: 'vm_beginpreamount',
            width: 120,
            renderer: function (v) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            }
        }, {
            text: '应付',
            xtype: 'numbercolumn',
            exportFormat: 'Amount',
            dataIndex: 'vm_beginamount',
            width: 120,
            renderer: function (v) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            }
        }]
    }, {
        text: '本期',
        columns: [{
            text: '预付',
            xtype: 'numbercolumn',
            exportFormat: 'Amount',
            dataIndex: 'vm_nowpreamount',
            width: 120,
            renderer: function (v) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            }
        }, {
            text: '应付',
            xtype: 'numbercolumn',
            exportFormat: 'Amount',
            dataIndex: 'vm_nowamount',
            width: 120,
            renderer: function (v) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            }
        }, {
            text: '核销',
            xtype: 'numbercolumn',
            exportFormat: 'Amount',
            dataIndex: 'vm_nowpayamount',
            width: 120,
            renderer: function (v) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            } 
        }]
    }, {
        text: '期末',
        columns: [{
            text: '预付',
            dataIndex: 'vm_endpreamount',
            exportFormat: 'Amount',
            xtype: 'numbercolumn',
            width: 120,
            renderer: function (v) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            },
            summaryType: 'sum',
            summaryRenderer: function (v) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            }
        }, {
            text: '应付',
            dataIndex: 'vm_endamount',
            exportFormat: 'Amount',
            xtype: 'numbercolumn',
            width: 120,
            renderer: function (v) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            },
            summaryType: 'sum',
            summaryRenderer: function (v) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            }
        }]
    }, {
        text: '应付余额(元)',
        dataIndex: 'vm_endamount-vm_endpreamount',
        exportFormat: 'Amount',
        xtype: 'numbercolumn',
        width: 120,
        renderer: function (v) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        },
        summaryType: 'sum',
        summaryRenderer: function (v) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        }
    }, {
        dataIndex: '',
        flex: 1
    }]
});