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 votes292 views3 answers
How to highlight text in css
CSS
4 votes301 views3 answers
Css moz webkit generator
CSS
0 vote306 views1 answer
Focus in styled component
CSS
86 votes305 views3 answers
Css tekst bold
CSS
2 votes309 views1 answer
How to use bulma in gatsby
CSS
0 vote291 views1 answer
Ubuntu phantomjs wrong paper size
CSS
14 votes312 views2 answers
How to render css in flask
CSS
-1 vote342 views2 answers
Css clip path text
CSS
17 votes292 views2 answers
Rgb green
CSS
0 vote295 views2 answers
Css span to right of div
CSS