/** * 应收总账 */ Ext.define('saas.view.money.report.TotalRecDetail', { extend: 'saas.view.core.report.ReportPanel', xtype: 'monry-report-totalrecdetail', controller: 'money-report-totalrecdetail', viewModel: 'money-report-totalrecdetail', viewName: 'money-report-totalrecdetail', groupField: null, listUrl: '/api/money/report/custormonthdetails', // listUrl: 'http://192.168.253.139:8560/api/money/report/custormonthdetails', defaultCondition: null, reportTitle: '应收总账', QueryWidth: 0.35, allowPaging: false, searchItems: [{ xtype: 'textfield', name: 'cm_custcode', emptyText: '客户编号/名称', columnWidth: 0.25, getCondition: function (v) { return "(upper(cm_custcode) like '%" + v.toUpperCase() + "%' or upper(cm_custname) like '%" + v.toUpperCase() + "%')"; }, }, { xtype: 'conmonthfield', fieldLabel: '期间', name: 'cm_yearmonth', columnWidth: 0.4 }], reportColumns: [{ text: '客户编号', dataIndex: 'cm_custcode', width: 190 }, { text: '客户名称', dataIndex: 'cm_custname', width: 210, }, { text: '期初预收', dataIndex: 'cm_beginpreamount', 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: 'cm_beginamount', 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: '本期应收', xtype: 'numbercolumn', exportFormat: 'Amount', dataIndex: 'cm_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', exportFormat: 'Amount', dataIndex: 'cm_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: '预收余额', xtype: 'numbercolumn', exportFormat: 'Amount', dataIndex: 'cm_endpreamount', 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: 'cm_endamount', 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); }, 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 }] });