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 votes199 views1 answer
Transform:translateX()
CSS
0 vote205 views1 answer
How to create wave like border
CSS
0 vote220 views1 answer
Can we block onclick of button using css
CSS
0 vote191 views1 answer
Change disbled button background pyqt5
CSS
8 votes186 views3 answers
Background image fill div
CSS
0 vote201 views1 answer
Align icon center div
CSS
0 vote202 views1 answer
Decroation of title using css
CSS
0 vote189 views1 answer
Css last 3 childs
CSS
4 votes261 views2 answers
Javafx change button background color
CSS
0 vote238 views2 answers
Icon inside a circle css
CSS