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 votes272 views3 answers
Import image css
CSS
0 vote309 views1 answer
Mvc dynamic css
CSS
0 vote297 views1 answer
Css check if class as color white
CSS
0 vote286 views1 answer
Comentarios en archivo scss
CSS
0 vote328 views1 answer
Css() multiple
CSS
0 vote287 views1 answer
How to add css using nativeelement in angular
CSS
4 votes318 views3 answers
Mobile tablet desktop media queries
CSS
1 vote280 views2 answers
Css input border radius focus
CSS
0 vote309 views2 answers
Scrolling banner
CSS
2 votes293 views5 answers
Tailwind css margin auto
CSS