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 vote193 views0 answer
CSS
4 votes246 views3 answers
.col-6 bootstrap
CSS Bootstrap
0 vote204 views1 answer
Css hero image
CSS
19 votes224 views3 answers
Keyframes
CSS
0 vote229 views1 answer
Generate your tailwind.config.js file
CSS
1 vote225 views1 answer
Detect portrait landscape css
CSS
49 votes304 views5 answers
Css first
CSS
0 vote257 views1 answer
Box shadow css animation
CSS
6 votes232 views4 answers
Backdrop filter css
CSS
1 vote228 views1 answer
Use a local font css
CSS