I have the following problem:
I have started work on an OpenERP module used for quality control, and one requirement for it to work is having linked quality parameters. Each parameter record has a field called 'formula' where I should be able to calculate the value for the parameter based on a dependent parameter.
For example, if I have a 'weight' parameter and a 'tolerance' parameter, I would like to have a 'foreign substance' parameter, where I would calculate the values for the 'foreign substance' parameter through the formula field, for instance 'weight'/'tolerance'.
The formula field would contain text that would be executed as Python code.
My question is, how would I indicate to the 'foreign substance' parameter that it should take into account the values of the other two when calculating its values?
Best regards, Stjepan
Use a function field, and have it pull the values of those other fields as well as the formula text? You'd have to be able to parse the formula text to replace the variables with the object references. Or, state that the syntax is
Once you're in the function calculating the 'foreign substance' field, make sure the object name is obj:
from openerp.tools import safe_eval objs = self.pool.get('quality.control').browse(cr, uid, ids) for obj in objs: foreign_substance = safe_eval(obj.formula)
There are more functions in safe_eval.py that you probably want to look into, just to make sure that nobody breaks your system with a bad formula.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 5/16/13, 10:33 AM|
|Seen: 1169 times|
|Last updated: 3/16/15, 8:10 AM|