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 vote230 views1 answer
Faire rectangle qui prend toute la largeur css
CSS
0 vote208 views1 answer
Copy html css from website
CSS
3 votes204 views1 answer
Import font sass
CSS
0 vote218 views1 answer
Create a specific form size and center in css
CSS
5 votes229 views3 answers
Bootstrap 4 classes list with description pdf
CSS
0 vote242 views1 answer
Css make all text center
CSS
1 vote198 views1 answer
Div nebeneinander
CSS
3 votes210 views2 answers
How to make border for letters in css
CSS
0 vote215 views2 answers
How to change jumbotron size
CSS