Top 10 customers odoo

query = "select sum(s.amount_total) as total , s.partner_id,
c.name from sale_order as s inner join res_partner as c 
on s.partner_id =c.id  group by s.partner_id,c.name
order by total desc"
//this will return the sum of amount_total group by custmer name ,
//you need to put this value inside the  self.env.cr.execute(query)

Similar codes

0 vote296 views1 answer
Css avoid line break in span
CSS
0 vote349 views2 answers
Ihr seid alle dumabtu
CSS
0 vote309 views1 answer
Css media query gist
CSS
14 votes280 views2 answers
How to add css in flask app
CSS
0 vote276 views1 answer
Grape change status code
CSS
0 vote274 views1 answer
Html invisible hr
CSS
0 vote291 views2 answers
Cut word css
CSS
0 vote302 views1 answer
Css 4 3 ratio
CSS
3 votes268 views2 answers
Css onclick change color
CSS
0 vote261 views2 answers
Gray scale css
CSS