/** * 应付总账 */ Ext.define('saas.view.money.report.TotalPayDetail', { extend: 'saas.view.core.report.ReportPanel', xtype: 'monry-report-totalpaydetail', controller: 'money-report-totalpaydetail', viewModel: 'money-report-totalpaydetail', viewName: 'money-report-totalpaydetail', groupField: null, listUrl: '/api/money/report/vendormonthdetails', // listUrl: 'http://192.168.253.139:8560/api/money/report/vendormonthdetails', defaultCondition: null, reportTitle: '应付总账', QueryWidth: 0.35, allowPaging: false, searchItems: [{ xtype: 'textfield', name: 'vm_vendcode', emptyText: '供应商编号/名称', columnWidth: 0.25, getCondition: function(v) { return "(upper(vm_vendcode) like '%"+v.toUpperCase()+"%' or upper(vm_vendname) like '%"+v.toUpperCase()+"%')"; }, }, { xtype: 'conmonthfield', fieldLabel: '期间', name: 'vm_yearmonth', columnWidth: 0.4 }], reportColumns: [{ text: '供应商编号', dataIndex: 'vm_vendcode', width: 200 }, { text: '供应商名称', dataIndex: 'vm_vendname', width: 200, }, { text: '期初预付', xtype: 'numbercolumn', dataIndex: 'vm_beginpreamount', width: 150, 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: '期初应付', xtype: 'numbercolumn', dataIndex: 'vm_beginamount', 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: '本期应付', xtype: 'numbercolumn', dataIndex: 'vm_nowamount', 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: '本期核销', xtype: 'numbercolumn', dataIndex: 'vm_nowpayamount', 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: 'vm_endpreamount', 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: '应付余额', dataIndex: 'vm_endamount', 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); } }, { flex: 1 }] });