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 vote180 views1 answer
Mirror text css
CSS
0 vote186 views1 answer
Fullpage.js change the color of the anchor
CSS
1 vote240 views1 answer
Css div fill whole page
CSS
0 vote194 views1 answer
Daphne vs gunicorn
CSS
28 votes213 views5 answers
Default cursor css
CSS
0 vote219 views1 answer
Textarea resize only horizontal
CSS
2 votes199 views1 answer
Ionic install font
CSS
0 vote205 views1 answer
Restrict css to apply on div
CSS
0 vote190 views1 answer
For loop for increment id of div in jquery
CSS
17 votes240 views2 answers
Css grid center elements inside div
CSS