Kuldeep Joshi(OpenERP) has proposed merging
lp:~openerp-dev/openobject-addons/trunk-partner-address-cleaning-report-kjo
into lp:~openerp-dev/openobject-addons/trunk-partner-address-cleaning.
Requested reviews:
Bhumika (OpenERP) (sbh-openerp)
For more details, see:
https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-partner-address-cleaning-report-kjo/+merge/98146
remove the res.partner.address from report_intrastat,crm_partner_assign and
base_contact
--
https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-partner-address-cleaning-report-kjo/+merge/98146
Your team OpenERP R&D Team is subscribed to branch
lp:~openerp-dev/openobject-addons/trunk-partner-address-cleaning.
=== modified file 'base_contact/base_contact.py'
--- base_contact/base_contact.py 2012-02-15 13:22:13 +0000
+++ base_contact/base_contact.py 2012-03-19 05:26:35 +0000
@@ -42,12 +42,12 @@
'title': fields.many2one('res.partner.title','Title', domain=[('domain','=','contact')]),
'website': fields.char('Website', size=120),
'lang_id': fields.many2one('res.lang', 'Language'),
- 'job_ids': fields.one2many('res.partner.address', 'contact_id', 'Functions and Addresses'),
+ 'job_ids': fields.one2many('res.partner', 'contact_id', 'Functions and Addresses'),
'country_id': fields.many2one('res.country','Nationality'),
'birthdate': fields.char('Birthdate', size=64),
'active': fields.boolean('Active', help="If the active field is set to False,\
it will allow you to hide the partner contact without removing it."),
- 'partner_id': fields.related('job_ids', 'partner_id', type='many2one',\
+ 'partner_id': fields.related('job_ids', 'parent_id', type='many2one',\
relation='res.partner', string='Main Employer'),
'function': fields.related('job_ids', 'function', type='char', \
string='Main Function'),
@@ -103,9 +103,9 @@
SELECT
id,COALESCE(name, '/'),COALESCE(name, '/'),title,true,email,mobile,birthdate
FROM
- res_partner_address""")
- cr.execute("alter table res_partner_address add contact_id int references res_partner_contact")
- cr.execute("update res_partner_address set contact_id=id")
+ res_partner""")
+ cr.execute("alter table res_partner add contact_id int references res_partner_contact")
+ cr.execute("update res_partner set contact_id=id")
cr.execute("select setval('res_partner_contact_id_seq', (select max(id)+1 from res_partner_contact))")
res_partner_contact()
@@ -121,8 +121,8 @@
'state_id': fields.many2one("res.country.state", 'Fed. State', domain="[('country_id','=',country_id)]"),
'country_id': fields.many2one('res.country', 'Country'),
'company_id': fields.many2one('res.company', 'Company',select=1),
- 'job_ids': fields.one2many('res.partner.address', 'location_id', 'Contacts'),
- 'partner_id': fields.related('job_ids', 'partner_id', type='many2one',\
+ 'job_ids': fields.one2many('res.partner', 'location_id', 'Contacts'),
+ 'partner_id': fields.related('job_ids', 'parent_id', type='many2one',\
relation='res.partner', string='Main Partner'),
}
_defaults = {
@@ -147,10 +147,10 @@
id,street,street2,zip,city,
state_id,country_id,company_id
FROM
- res_partner_address""")
- cr.execute("alter table res_partner_address add location_id int references res_partner_location")
- cr.execute("update res_partner_address set location_id=id")
- cr.execute("select setval('res_partner_location_id_seq', (select max(id)+1 from res_partner_address))")
+ res_partner""")
+ cr.execute("alter table res_partner add location_id int references res_partner_location")
+ cr.execute("update res_partner set location_id=id")
+ cr.execute("select setval('res_partner_location_id_seq', (select max(id)+1 from res_partner))")
def name_get(self, cr, uid, ids, context=None):
result = {}
@@ -170,9 +170,9 @@
def _default_location_id(self, cr, uid, context=None):
if context is None:
context = {}
- if not context.get('default_partner_id',False):
+ if not context.get('default_parent_id',False):
return False
- ids = self.pool.get('res.partner.location').search(cr, uid, [('partner_id','=',context['default_partner_id'])], context=context)
+ ids = self.pool.get('res.partner.location').search(cr, uid, [('parent_id','=',context['default_parent_id'])], context=context)
return ids and ids[0] or False
def onchange_location_id(self,cr, uid, ids, location_id=False, context={}):
@@ -227,8 +227,8 @@
result = {}
for rec in self.browse(cr,uid, ids, context=context):
res = []
- if rec.partner_id:
- res.append(rec.partner_id.name_get()[0][1])
+ if rec.parent_id:
+ res.append(rec.parent_id.name_get()[0][1])
if rec.contact_id and rec.contact_id.name:
res.append(rec.contact_id.name)
if rec.location_id:
=== modified file 'base_contact/base_contact_view.xml'
--- base_contact/base_contact_view.xml 2012-01-31 13:36:57 +0000
+++ base_contact/base_contact_view.xml 2012-03-19 05:26:35 +0000
@@ -50,8 +50,8 @@
</group>
<field name="job_ids" colspan="4" nolabel="1" mode="tree,form">
<form string="Functions and Addresses">
- <field name="partner_id" />
- <field name="location_id" domain="[('partner_id', '=', partner_id)]"/>
+ <field name="parent_id" />
+ <field name="location_id" domain="[('partner_id', '=', parent_id)]"/>
<field name="function" />
<separator string="Professional Info" colspan="4"/>
<field name="phone"/>
@@ -135,10 +135,10 @@
<field name="inherit_id" ref="base.view_partner_form"/>
<field name="type">form</field>
<field name="arch" type="xml">
- <separator string="Postal Address" position="after">
+ <separator string="Address" position="after">
<field name="location_id" on_change="onchange_location_id(location_id)" domain="[('partner_id', '=', parent.id)]"/>
</separator>
- <xpath expr="//field[@string='Contact Name']" position="replace">
+ <xpath expr="//field[@name='name']" position="replace">
<field name="contact_id"/>
</xpath>
<field name="title" position="replace"/>
=== modified file 'base_contact/security/ir.model.access.csv'
--- base_contact/security/ir.model.access.csv 2012-01-31 13:36:57 +0000
+++ base_contact/security/ir.model.access.csv 2012-03-19 05:26:35 +0000
@@ -3,5 +3,5 @@
"access_res_partner_contact_all","res.partner.contact all","model_res_partner_contact","base.group_user",1,0,0,0
"access_res_partner_location","res.partner.location","model_res_partner_location","base.group_user",1,0,0,0
"access_res_partner_location_sale_salesman","res.partner.location","model_res_partner_location","base.group_sale_salesman",1,1,1,0
-"access_res_partner_address_sale_salesman","res.partner.address.user","base.model_res_partner_address","base.group_sale_salesman",1,1,1,0
+"access_res_partner_sale_salesman","res.partner.user","base.model_res_partner","base.group_sale_salesman",1,1,1,0
"access_group_sale_salesman","res.partner.contact.sale.salesman","model_res_partner_contact","base.group_sale_salesman",1,1,1,0
=== modified file 'crm_partner_assign/report/crm_partner_report.py'
--- crm_partner_assign/report/crm_partner_report.py 2012-03-06 13:48:46 +0000
+++ crm_partner_assign/report/crm_partner_report.py 2012-03-19 05:26:35 +0000
@@ -51,7 +51,7 @@
SELECT
coalesce(i.id, p.id - 1000000000) as id,
p.id as partner_id,
- (SELECT country_id FROM res_partner a WHERE a.partner_id=p.id AND country_id is not null limit 1) as country_id,
+ (SELECT country_id FROM res_partner a WHERE a.parent_id=p.id AND country_id is not null limit 1) as country_id,
p.grade_id,
p.activation,
p.date_review,
=== modified file 'report_intrastat/report_intrastat.py'
--- report_intrastat/report_intrastat.py 2011-12-19 16:54:40 +0000
+++ report_intrastat/report_intrastat.py 2012-03-19 05:26:35 +0000
@@ -112,9 +112,9 @@
left join product_uom uom on uom.id=inv_line.uos_id
left join product_uom puom on puom.id = pt.uom_id
left join report_intrastat_code intrastat on pt.intrastat_id = intrastat.id
- left join (res_partner_address inv_address
+ left join (res_partner inv_address
left join res_country inv_country on (inv_country.id = inv_address.country_id))
- on (inv_address.id = inv.address_invoice_id)
+ on (inv_address.id = inv.partner_id)
where
inv.state in ('open','paid')
_______________________________________________
Mailing list: https://launchpad.net/~openerp-dev-gtk
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-dev-gtk
More help : https://help.launchpad.net/ListHelp