← Back to branch summary

~mga/openobject-addons/account_india

« back to all changes in this revision

Viewing changes to product_extended/product_extended.py

  • Committer: Fabien Pinckaers
  • Date: 2008-12-14 16:48:05 UTC
  • Revision ID: fp@tinyerp.com-20081214164805-el7vuhu6p54ftv5y
improvements

Show diffs side-by-side

added added

removed removed

Lines of Context:
product_extended/product_extended.py
32
32
    def _last_order(self, cr, uid, ids, name, arg, context):
33
33
        res = {}
34
34
        for supinfo in self.browse(cr, uid, ids):
35
 
            cr.execute("select po.id, max(po.date_approve) from purchase_order as po, purchase_order_line as line where po.id=line.order_id and product_id=%d and partner_id=%d and state='approved' group by po.id", (supinfo.product_id.id, supinfo.name.id,))
 
35
            cr.execute("select po.id, max(po.date_approve) from purchase_order as po, purchase_order_line as line where po.id=line.order_id and product_id=%s and partner_id=%s and state='approved' group by po.id", (supinfo.product_id.id, supinfo.name.id,))
36
36
            record = cr.fetchone()
37
37
            if record:
38
38
                res[supinfo.id] = record[0]
67
67
    def _find_op(self, cr, uid, ids, name, arg, context):
68
68
        res = {}
69
69
        for product_id in ids:
70
 
            cr.execute('SELECT swo.id from stock_warehouse_orderpoint AS swo WHERE product_id=%d', (product_id,))
 
70
            cr.execute('SELECT swo.id from stock_warehouse_orderpoint AS swo WHERE product_id=%s', (product_id,))
71
71
            op_id = cr.fetchone()
72
72
            if op_id:
73
73
                res[product_id] = op_id[0]