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:'pi_vendname',
    listUrl: '/api/money/report/payDetail',
    defaultCondition: null,
    reportTitle: '应付账款明细表',
    QueryWidth:0.25,
    //筛选：供应商、日期（必填）
    searchItems: [ {
        xtype: 'vendorDbfindTrigger',
        name: 'pi_vendname',
        fieldLabel: '供应商名称',
        columnWidth: 0.25
    }, {
        xtype: 'condatefield',
        name: 'pb_date',
        fieldLabel: '单据日期',
        columnWidth: 0.5
    }],

    reportColumns: [
        {
            text: 'id',
            dataIndex: 'pi_id',
            hidden: true
        }, {
            text: '单号',
            dataIndex: 'pi_inoutno',
            width: 150
        },{
            text:'供应商编号',
            dataIndex:'pi_vendcode',
            width: 150
        },{
            text:'供应商名称',
            width: 200,
            dataIndex:'pi_vendname'
        }, {
            text: '单据类型',
            dataIndex: 'pi_class',
            width: 110
        }, {
            text: '单据日期',
            xtype: 'datecolumn',
            dataIndex: 'pb_date',
            width: 110
        }, {
            text: '采购员',
            dataIndex: 'pu_buyercode',
            width: 110
        },{
            text: '期初应付余额',
            xtype: 'numbercolumn',
            dataIndex: 've_beginapamount',
            xtype: 'numbercolumn',
            width: 110,
            renderer : function(v) {
                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',
            summaryRenderer: function(v) {
                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);
            }
        }, {
            text: '本期付款金额',
            xtype: 'numbercolumn',
            dataIndex: 'pb_pdamount',
            xtype: 'numbercolumn',
            width: 110,
            renderer : function(v) {
                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',
            summaryRenderer: function(v) {
                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);
            }
        }, {
            text: '应付余额',
            xtype: 'numbercolumn',
            dataIndex: 'mustpay',
            xtype: 'numbercolumn',
            width: 110,
            renderer : function(v) {
                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',
            summaryRenderer: function(v) {
                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);
            }
        }, {
            text: '应付日期',
            xtype: 'datecolumn',
            dataIndex: 'mustdate',
            width: 110
        }, {
            text: '单据总金额',
            xtype: 'numbercolumn',
            width: 110,
            dataIndex: 'pi_total',
            xtype: 'numbercolumn',
            renderer : function(v) {
                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',
            summaryRenderer: function(v) {
                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);
            }
        }, {
            text: '备注',
            dataIndex: 'pi_remark',
            width: 250
        }]
});