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

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

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

    viewName: 'money-report-accountdetails',

    // groupField: null,
    listUrl: '/api/money/report/accountdetails',
    defaultCondition: null,
    reportTitle: '核销对账表',
    QueryWidth: 0.2,
    //筛选：客户/供应商、日期、单据类型（必填）
    searchItems: [{
        name: 'sl_code',
        xtype: 'textfield',
        emptyText: '单号',
        columnWidth: 0.1
    }, {
        xtype: 'multicombo',
        name: 'sl_kind',
        emptyText: '单据类型',
        columnWidth: 0.1,
        datas: [
            ["采购验收单", "采购验收单"],
            ["采购验退单", "采购验退单"],
            ["出货单", "出货单"],
            ["销售退货单", "销售退货单"],
            ["完工入库单", "完工入库单"],
            ["生产领料单", "生产领料单"],
            ["拆件领料单", "拆件领料单"],
            ["其它入库单", "其它入库单"],
            ["其它出库单", "其它出库单"],
            ["调拨单", "调拨单"],
            ["库存初始化", "库存初始化"]
        ]
    }, {
        name: 'date',
        xtype: 'condatefield',
        emptyText: '日期',
        columnWidth: 0.3
    }, {
    //     name: 'pb_code',
    //     xtype: 'textfield',
    //     emptyText: '核销单号',
    //     columnWidth: 0.1
    // }, {
        xtype: "customerDbfindTrigger",
        name: "cu_name",
        emptyText: '客户编号/名称',
        columnWidth: 0.15
    }, {
        xtype: 'vendorDbfindTrigger',
        name: 've_name',
        emptyText: '供应商编号/名称',
        columnWidth: 0.15
    }],
    reportColumns: [{
        text: 'id',
        dataIndex: 'pi_id',
        hidden: true
    }, {
        text: '单据编号',
        dataIndex: 'sl_code',
        width: 150
    }, {
        text: '单据类型',
        dataIndex: 'sl_kind',
        width: 110
    }, {
        text: '单据日期',
        dataIndex: 'date',
        xtype: 'datecolumn',
        width: 110
    }, {
        text: '供应商名称',
        dataIndex: 've_name',
        width: 200
    }, {
        text: '客户名称',
        dataIndex: 'cu_name',
        width: 200
    }, {
        text: '核销单号',
        dataIndex: 'pb_code',
        width: 200
    }, {
        text: '本期核销金额',
        dataIndex: 'sl_amount',
        exportFormat: 'Amount',
        xtype: 'numbercolumn',
        width: 130,
        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);
        }
    }, {
        text: '总金额',
        dataIndex: 'total',
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        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);
        }
    }],
});