Hi everybody,
I have to work with partners categories. Here is the situation :
I have 3 levels of categories : "Category", "Subcategory" and "Year". "Category" and "Subcategory" are linked but "Year" is independant.
An example : M. Doe was at "School" (category) in "America" (subcategory) in year 2003. But he is currently following a training in this same "School" in "America" in year 2013.
I have two problems :
- how to allow one partner to have several times the same category and subcategory ?
- how to create a new field "Year" which is not linked to the category and subcategory but which must appear in the partner form ? (I think a solution could be to work like "article" in invoice. We can choose many times the same article and we can add other independant data)
I created a new page in the partner form named "Statuts". Now this page shows the module "partner.category". Indeed, I used the following code :
from openerp.osv import fields, osv
class res_partner(osv.osv):
_inherit = 'res.partner'
_order = 'x_nom asc'
_columns = {
'x_nom': fields.char('Nom',size=64),
'x_prenom': fields.char('Prenom',size=64),
'x_category': fields.many2many('res.partner.category','res_partner_category_rel','partner_id','category_id','Statuts'),
'x_date': fields.selection((('2000','2000'), ('2001','2001'), ('2002','2002'), ('2003','2003'), ('2004','2004'), ('2005','2005'), ('2006','2006'), ('2007','2007'), ('2008','2008'), ('2009','2009'), ('2010','2010'), ('2011','2011'), ('2012','2012'), ('2013','2013')),'Annee'),
}
res_partner()
and :
<?xml version="1.0" encoding="utf-8"?>
<openerp>
<data>
<record model="ir.ui.view" id="view_partner_form">
<field name="name">res.partner.form.inherit</field>
<field name="model">res.partner</field>
<field name="type">form</field>
<field name="inherit_id" ref="base.view_partner_form"/>
<field name="arch" type="xml">
<data>
<field name="name" position="after">
<field name="x_nom"/>
</field>
<field name="x_nom" position="after">
<field name="x_prenom"/>
</field>
</data>
</field>
</record>
<record model="ir.ui.view" id="view_partner_form2">
<field name="name">res.partner.form.inherit2</field>
<field name="model">res.partner</field>
<field name="inherit_id" ref="base.view_partner_form"/>
<field name="arch" type="xml">
<notebook position="inside">
<page string="Statuts">
<group>
<field name="x_category" widget="many2many"/>
<field name="x_date" style="width: 30%%"/>
</group>
</page>
</notebook>
</field>
</record>
</data>
</openerp>
Many thanks in advance for your answer.
JMB