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 vote189 views1 answer
Animation clip path
CSS
0 vote284 views1 answer
Nokogiri xml diff
CSS
1 vote172 views1 answer
Get second child div css
CSS
0 vote179 views1 answer
CSS BODY AND PRE
CSS
61 votes183 views5 answers
Css paragraph ellipsis
CSS
13 votes238 views1 answer
Remove style from link
CSS
3 votes174 views1 answer
How to set text to middle in div
CSS
0 vote218 views1 answer
Not let user select in css
CSS
1 vote220 views1 answer
How to disable margin collapsing
CSS
1 vote188 views1 answer
Sideways linear gradient
CSS