Ext.define('saas.model.report.SaleProfit', { extend: 'saas.model.Base', fields: [ { name: 'id', type: 'int' }, { name: 'pi_date', type: 'date' }, { name: 'sa_custname', type: 'string' }, { name: 'sa_seller', type: 'string' }, { name: 'pd_inoutno', type: 'string' }, { name: 'pr_code', type: 'string' }, { name: 'pr_brand', type: 'string' }, { name: 'pr_detail', type: 'string' }, { name: 'pr_orispeccode', type: 'string' }, { name: 'pr_spec', type: 'string' }, { name: 'pd_outqty', type: 'float' }, { name: 'pr_unit', type: 'string' }, { name: 'pd_netprice', type: 'float' }, { name: 'pd_sendprice', type: 'float' },//含税单价 { name: 'pd_nettotal', type: 'float' }, { name: 'pd_taxrate', type: 'int' },//税率 { name: 'pd_ordertotal-pd_nettotal', type: 'float', convert: function(v, rec) { var t = (rec.get('pd_ordertotal') || 0.0) - (rec.get('pd_nettotal') || 0.0); return Number(saas.util.BaseUtil.numberFormat(t, 2, false)); }, depends: ['pd_ordertotal', 'pd_nettotal'] }, { name: 'pd_ordertotal', type: 'float' },//价税合计 { name: 'pd_price', type: 'float' },//成本单价 { name: 'pd_total', type: 'float' }, { name: 'pd_profit', type: 'float' }, { name: 'pd_profit*pi_rate', type: 'float' , convert: function(v, rec) { return Number(saas.util.BaseUtil.numberFormat((rec.get('pd_profit') || 0.0), 2, false)); }, depends: ['pd_profit'] },//毛利润(元) = ( (含税单价 * 汇率) / (1+税率%) - 成本单价 ) * 数量 { name: 'pd_profitpresent', type: 'float', convert: function(v, rec) { var t = ( (((rec.get('pd_sendprice') || 0.0) * (rec.get('pi_rate') || 1.0) / (1 + (rec.get('pd_taxrate') || 0.0)/100 )) - (rec.get('pd_price') || 0.0)) / (((rec.get('pd_sendprice') || 0.0) * (rec.get('pi_rate') || 1.0) / (1 + (rec.get('pd_taxrate') || 0.0)/100 ))) ) * 100; return Number(saas.util.BaseUtil.numberFormat(t, 2, false)); }, depends: ['pd_sendprice', 'pi_rate','pd_taxrate','pd_price'] },//毛利润率 = ( (含税单价*汇率/(1+税率%) - 成本单价) / (含税单价*汇率/(1+税率%)) ) * 100 { name: 'pd_remark', type: 'string' }, { name: 'pi_currency', type: 'string' }, { name: 'pi_rate', type: 'float' } ], });