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 vote223 views1 answer
Not let user select in css
CSS
0 vote191 views1 answer
Css chamfered corner
CSS
1 vote191 views1 answer
Prefix in css
CSS
0 vote189 views1 answer
Two background css
CSS
0 vote189 views1 answer
Css ripple effect
CSS
0 vote182 views1 answer
How to use class form scss reactjs
CSS
2 votes183 views1 answer
How many pixels is h1 text html
CSS
1 vote175 views1 answer
Restful url to update status
CSS
0 vote186 views1 answer
Colored button link
CSS
1 vote179 views1 answer
Code changes to Hostgator not being reflected
CSS