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 vote369 views1 answer
Border radius circle button
CSS
1 vote375 views4 answers
CSS Grid Display
CSS
1 vote351 views1 answer
Stop anchor tag scroll to top of page
CSS
0 vote323 views1 answer
Css invert text color
CSS
0 vote341 views2 answers
Sass variables across files
CSS
0 vote344 views2 answers
Css how to stop screen from left and right
CSS
29 votes327 views3 answers
Green hex code
CSS
3 votes358 views1 answer
Diable focus button css
CSS
1 vote376 views1 answer
Jquery css multiple line
CSS
0 vote350 views1 answer
After certain width how make ontent center and add margin auto both side
CSS