跳至內容
此問題已被標幟
salessearchbrowsercomission
1 回覆
4996 瀏覽次數
頭像
Pankaj Moolrajani

I am trying to calculate comission for salesperson.
Calculation:
If current sales amount is greater than the previous sales amount for the same customer:
then comission=0.50*amount_total
else:
comission = 0.0

But i am missing something, not getting exact results. please guide.

def _calculate_comission(self, cr, uid, ids, field_names, args, context=None):
    res={}
    comission=0.00

    for order in self.browse(cr, uid, ids):
        for record in self.browse(cr, uid, self.search(cr, uid, [('user_id','=',order.user_id.id)], limit=1)):
            if order.amount_total > record.amount_total:
                comission = 0.50*order.amount_total
頭像
捨棄
頭像
Dhinesh
最佳答案

Hi, Try this...

def _comission_calculate(self, cr, uid, ids, context=None):
        if ids[0]==1:
            return False
        else:
            comission=0.00
            result= cr.execute('select id from dbname where id<%s order by id desc limit 1', (ids[0],))
            result = cr.dictfetchall()
            previous_id = result[0]['id']
            previous = self.browse(cr, uid, previous_id)
            previous_amount = previous.total
            for current in self.browse(cr, uid, ids):
                current_amount = current.total
            if current_amount > previous_amount:
                comission = 0.50 * current_amount
        return comission
頭像
捨棄
相關帖文 回覆 瀏覽次數 活動
How to use browse() to show values from different table ? 已解決
inheritance search browser
頭像
頭像
2
7月 20
11305
help or guidance on ORM Metodos ODOO V8
search browser class
頭像
0
8月 16
3118
How can i keep the product search in odoo sales open to select multiple products 已解決
sales product search Quotes
頭像
頭像
頭像
頭像
4
8月 24
1203
Sales comission for Odoo 17
sales comission odoo v17
頭像
頭像
1
4月 24
3627
Sales comission for Odoo 17
sales point_of_sale spreadsheets comission v17
頭像
0
1月 24
69