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

2 votes132 views1 answer
Ionic install font
CSS
27 votes138 views3 answers
Hide in css
CSS
13 votes149 views1 answer
Baclgroud image css
CSS
0 vote135 views2 answers
CSS Or Selector
CSS
222 votes291 views6 answers
Bootstrap CSS CDN
CSS
0 vote131 views1 answer
Put light shadow around div
CSS
63 votes141 views6 answers
Text shadow
CSS
1 vote128 views1 answer
Restful url to update status
CSS
5 votes242 views2 answers
Materialize css cdn
CSS Materialize
164 votes187 views4 answers
Html head css link
CSS