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 vote128 views1 answer
Css not working react
CSS
2 votes136 views1 answer
Phone width media query
CSS
1 vote177 views1 answer
Css custom bullet list
CSS
0 vote185 views1 answer
Css column gap flex
CSS
-2 votes305 views3 answers
Box sizing reset
CSS
0 vote217 views1 answer
.txt:hover { text-decoration: underline; }
CSS
1 vote173 views1 answer
Css make background visible in text
CSS
0 vote175 views1 answer
Css diplay grid text truncate
CSS
0 vote183 views1 answer
Make changes to api fetch onclick in react
CSS
1 vote170 views1 answer
React hide scrollbar
CSS