saas-platform/frontend/saas-web/app/model/report/SaleProfit.js

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_ordertotal*pi_rate', type: 'float' ,
            convert: function(v, rec) {
                return Number(saas.util.BaseUtil.numberFormat((rec.get('pd_ordertotal') || 0.0), 2, false));
            },
            depends: ['pd_ordertotal']
            /* convert: function(v, rec) {
                var t = (rec.get('pd_ordertotal') || 0.0) * (rec.get('pi_rate') || 1.0);
                return Number(saas.util.BaseUtil.numberFormat(t, 2, false));
            },
            depends: ['pd_ordertotal', 'pi_rate'] */
        },//价税合计本位币
        { name: 'pd_price', type: 'float' },//成本单价
        { name: 'pd_total', type: 'float' },
        { name: 'pd_profit', 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_outqty') || 0.0);
                return Number(saas.util.BaseUtil.numberFormat(t, 2, false));
            },
            depends: ['pd_sendprice', 'pi_rate','pd_taxrate','pd_price','pd_outqty']
        },//毛利润(元) = ( (含税单价 * 汇率) / (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' }
    ],
});