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.2,
    autoLoad:false,
    //筛选：客户、日期（必填）
    searchItems: [ {
        xtype: 'customerDbfindTrigger',
        name: 'pi_custname',
        fieldLabel: '客户名称',
        columnWidth: 0.2,
        allowBlank:false,
    }, {
        xtype: 'monthdatefield',
        name: 'ym',
        fieldLabel: '期初日期',
        columnWidth: 0.2
    }, {
        xtype: 'condatefield',
        name: 'pi_date',
        fieldLabel: '单据日期',
        columnWidth: 0.4
    }],

    reportColumns: [
        {
            text: 'id',
            dataIndex: 'pi_id',
            hidden: true
        }, {
            text: '单号',
            dataIndex: 'pi_inoutno',
            width: 150
        }, {
            text: '单据类型',
            dataIndex: 'pi_class',
            width: 110
        }, {
            text: '单据日期',
            dataIndex: 'pi_date',
            xtype: 'datecolumn',
            width: 110
        }, {
            text: '序号',
            dataIndex: 'pd_pdno',
            xtype: 'numbercolumn',
            width: 80
        },{
            text: '物料编号',
            width: 150,
            dataIndex: 'pr_code'
        }, {
            text: '物料名称',
            dataIndex: 'pr_detail',
            width: 200
        }, {
            text: '物料规格',
            dataIndex: 'pr_spec',
            width: 150
        }, {
            text: '单位',
            dataIndex: 'pd_unit',
            width: 80
        }, {
            text: '数量',
            xtype: 'numbercolumn',
            dataIndex: 'qty',
            xtype: 'numbercolumn',
            width: 110
        }, {
            text: '单价',
            dataIndex: 'pd_orderprice',
            xtype: 'numbercolumn',
            width: 110
        }, {
            text: '税率',
            dataIndex: 'pd_taxrate',
            xtype: 'numbercolumn',
            width: 80
        }, {
            text: '金额',
            xtype: 'numbercolumn',
            width: 110,
            dataIndex: 'pd_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: '不含税单价',
            width: 110,
            dataIndex: 'pd_netprice',
            xtype: 'numbercolumn'
        }, {
            text: '不含税金额',
            width: 110,
            xtype: 'numbercolumn',
            dataIndex: 'pd_nettotal',
            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: 'pd_remark',
            width: 250
        }, {
            text: '期初应付',
            dataIndex: 'beginamount',
            hidden: true,
            width: 0,
            summaryType: 'cus',
        }, {
            text: '本期发生',
            dataIndex: 'nowamount',
            hidden: true,
            width: 0,
            summaryType: 'cus',
        }, {
            text: '本期付款',
            dataIndex: 'nowpay',
            hidden: true,
            width: 0,
            summaryType: 'cus',
        }, {
            text: '本期结余',
            dataIndex: 'nowbalance',
            hidden: true,
            width: 0,
            summaryType: 'cus',
        }],
        applyParams: function(p) {
            var me = this,
            viewModel = me.getViewModel(),
            formData = viewModel.get('form'),
            ym = formData.ym;
    
            return Ext.Object.merge(p, {
                ym: ym
            });
        }
});