Ext.define('saas.view.money.report.VendorCheck', { extend: 'saas.view.core.report.ReportPanel', xtype: 'monry-report-vendorcheck', controller: 'money-report-vendorcheck', viewModel: 'money-report-vendorcheck', viewName: 'money-report-vendorcheck', // groupField: null, listUrl: '/api/money/report/vendorCheck', defaultCondition: null, reportTitle: '供应商对账单', QueryWidth:0.4, autoLoad:false, //筛选:供应商、日期(必填) searchItems: [ { xtype: 'vendorDbfindTrigger', name: 'pi_vendname', fieldLabel: '供应商名称', columnWidth: 0.2, allowBlank:false, listeners: { beforequery: function(f) { return !!f.value; } } }, { // 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_date', xtype:'datecolumn', width: 110 }, { text: '单号', dataIndex: 'pi_inoutno', width: 150 }, { text: '序号', xtype: 'numbercolumn', dataIndex: 'pd_pdno', exportFormat: 'Integer', width: 80 },{ text:'供应商编号', dataIndex:'pi_vendcode', width: 150, hidden:true },{ text:'供应商名称', dataIndex:'pi_vendname', width: 250, hidden:true },{ text: '物料编号', dataIndex: 'pr_code', width: 150 }, { text: '物料名称', dataIndex: 'pr_detail', width: 200 }, { text: '物料规格', dataIndex: 'pr_spec', width: 150 }, { text: '单位', dataIndex: 'pd_unit', width: 80 }, { text: '数量', dataIndex: 'qty', exportFormat: 'Quantity', xtype: 'numbercolumn', width: 110, renderer: function(v) { var arr = (v + '.').split('.'); var xr = (new Array(arr[1].length > 3 ? 3 : arr[1].length)).fill('0'); var format = '0.' + xr.join(''); return Ext.util.Format.number(v, format); } }, { text: '单价', dataIndex: 'pd_orderprice', exportFormat: 'Price', xtype: 'numbercolumn', width: 110, renderer: function(v) { var arr = (v + '.').split('.'); var xr = (new Array(arr[1].length > 8 ? 8 : arr[1].length)).fill('0'); var format = '0,000.' + xr.join(''); return Ext.util.Format.number(v, format); } }, { text: '税率', dataIndex: 'pd_taxrate', exportFormat: 'Integer', xtype: 'numbercolumn', width: 80, renderer: function(v) { return Ext.util.Format.number(v, '0'); } }, { text: '金额', xtype: 'numbercolumn', exportFormat: 'Amount', dataIndex: 'pd_total', 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: '不含税单价', dataIndex: 'pd_netprice', exportFormat: 'Price', xtype: 'numbercolumn', width: 110, renderer: function(v) { var arr = (v + '.').split('.'); var xr = (new Array(arr[1].length > 8 ? 8 : arr[1].length)).fill('0'); var format = '0,000.' + xr.join(''); return Ext.util.Format.number(v, format); } }, { text: '不含税金额', dataIndex: 'pd_nettotal', exportFormat: 'Amount', 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); }, }, { text: '单据类型', dataIndex: 'pi_class', width: 110 }, { 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', }], listeners: { afterrender: function(panel) { panel.setLoadButtonDisabled(true); }, }, setLoadButtonDisabled: function (disabled) { var panel = this, grid = panel.down('grid'), p = grid.down('pagingtoolbar'), bs = p.query('button'), loadButton = Ext.Array.findBy(bs, function (b) { return b.iconCls == 'x-tbar-loading'; }); if (loadButton) { loadButton.setDisabled(disabled); } }, applyParams: function(p) { var me = this, viewModel = me.getViewModel(), formData = viewModel.get('form'), ym = formData.ym; return Ext.Object.merge(p, { ym: ym }); } });