12345678910111213141516171819202122232425262728 |
- # -*- coding: utf-8 -*-
- from openerp import tools, models, api
- from openerp.osv import osv, fields
- class product_stock_line(osv.osv):
- _name = "product.stock.line"
- _description = "product.stock.line"
- _auto = False
- _columns = {
- 'product_id': fields.many2one('product.product','product'),
- 'product_qty': fields.float(string='Cantidad', readonly=True),
- 'partner_id' : fields.many2one('res.partner',string='Partner'),
- }
- _order = 'id asc'
- def init(self, cr):
- tools.sql.drop_view_if_exists(cr, 'product_stock_line')
- cr.execute("""
- CREATE OR REPLACE VIEW product_stock_line as (
- SELECT row_number() over (ORDER BY po.partner_id)as id,
- pol.product_id as product_id,
- sum(pol.qty) as product_qty,
- po.partner_id as partner_id
- FROM pos_order_line pol
- inner join pos_order po on(po.id = pol.order_id)
- GROUP BY pol.product_id, po.partner_id)
- """)
|