Reviewers: ,
Please review this at http://codereview.tryton.org/153003/
Affected files:
M product.py
Index: product.py
===================================================================
--- a/product.py
+++ b/product.py
@@ -21,20 +21,23 @@
def table_query(self):
property_obj = Pool().get('ir.property')
+ field_obj = Pool().get('ir.model.field')
return ('SELECT ' \
- 'MAX(__id) AS id, ' \
- 'MAX(create_uid) AS create_uid, ' \
- 'MAX(create_date) AS create_date, ' \
- 'MAX(write_uid) AS write_uid, ' \
- 'MAX(write_date) AS write_date, ' \
- 'COALESCE(write_date, create_date) AS date, ' \
- 'CAST(TRIM(\',\' FROM SUBSTRING(res FROM \',.*\')) AS
INTEGER) ' \
+ 'MAX(h.__id) AS id, ' \
+ 'MAX(h.create_uid) AS create_uid, ' \
+ 'MAX(h.create_date) AS create_date, ' \
+ 'MAX(h.write_uid) AS write_uid, ' \
+ 'MAX(h.write_date) AS write_date, ' \
+ 'COALESCE(h.write_date, h.create_date) AS date, ' \
+ 'CAST(TRIM(\',\' FROM SUBSTRING(h.res FROM \',.*\'))
AS INTEGER) ' \
'AS template, ' \
- 'CAST(TRIM(\',\' FROM value) AS NUMERIC) AS
cost_price ' \
- 'FROM "' + property_obj._table + '__history" ' \
- 'WHERE name = \'cost_price\' ' \
- 'AND res LIKE \'product.template,%%\' ' \
- 'GROUP BY id, COALESCE(write_date, create_date), res,
value',
+ 'CAST(TRIM(\',\' FROM h.value) AS NUMERIC) AS
cost_price ' \
+ 'FROM "' + property_obj._table + '__history" h, ' \
+ '"' + field_obj._table + '" f ' \
+ 'WHERE f.name = \'cost_price\' ' \
+ 'AND h.res LIKE \'product.template,%%\' ' \
+ 'AND f.id = h.field ' \
+ 'GROUP BY h.id, COALESCE(h.write_date, h.create_date),
h.res, h.value',
[])
ProductCostHistory()
--
[email protected] mailing list
