Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- query = """
- SELECT pt.name as product,sl.price_unit as price,sum(sl.qty_invoiced) as quantity from sale_order_line sl
- JOIN sale_order so ON so.id = sl.order_id
- JOIN product_product pp ON pp.id = sl.product_id
- JOIN product_template pt ON pt.id = pp.product_tmpl_id
- WHERE so.date_order >='"""+str(obj.start_date)+"""'
- and so.date_order <= '"""+str(obj.end_date)+"""'
- and so.partner_id ="""+str(obj.customer_id.id)+"""
- and sl.invoice_status = 'invoiced'
- """
- if obj.product_id:
- query +=""" and sl.product_id in """+str(obj.product_id.ids)
- query += """GROUP BY product,price"""
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement