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 }] });