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 vote183 views5 answers
Css math functions simplifier
CSS
14 votes268 views4 answers
Text align left bootstrap
CSS Bootstrap
0 vote160 views1 answer
Z index div over cursor
CSS
-1 vote175 views2 answers
How to use before pseudo class in css
CSS
21 votes193 views5 answers
How to open a file in vscode from terminal
CSS
17 votes223 views2 answers
Css grid center elements inside div
CSS
111 votes218 views6 answers
Media query css
CSS
-1 vote175 views2 answers
Add sass to react
CSS
0 vote171 views1 answer
Background Image Accessibility concerns
CSS
1 vote186 views1 answer
Css make background visible in text
CSS