跳至内容
菜单
此问题已终结
2 回复
11723 查看

hi,

I am creating a call log module , and i need to automatically get the partner information by the given number ie. the system have to automatically search and fetch the partner and assign it to a field .

Somebody please help me with the python code , my code is :


customer_number = fields.Char(string='Customer Number', track_visiility='onchange', onchange='get_partner()', store=True)
customer_id = fields.Many2one('res.partner', string='Customer', track_visibility='onchange',index=True,
help="Linked partner (optional). Usually created when converting the lead.", store=True)

#--------------------------------------------------
# Api s
#--------------------------------------------------

@api.onchange('customer_number')

def get_partner(self):
if self.customer_number:
partner = self.env['res.partner'].search_read([('self.customer_number', 'ilike', 'self.phone')])
self.customer_id = partner
return self.customer_id
形象
丢弃
最佳答案

Hello,

You need to remove quotes from self.phone and should use search method to find the Parther.

Ex:

self.customer_id = self.env['res.partner'].search(['|', ('phone', 'ilike', self.customer_number), ('mobile', 'ilike', self.customer_number)], limit=1).id


形象
丢弃

Also, the 'self.customer_number' in the search has to be changed to 'phone' or 'mobile'

Thanks for drawing the attention. I corrected the code now.

最佳答案

Hi,

Update the onchange function like this,

@api.onchange('customer_number')
def get_partner(self):
if self.customer_number:
partner = self.env['res.partner'].search([('phone', 'ilike', self.customer_number)], limit=1)
if partner:
self.customer_id = partner.id


Thanks

形象
丢弃
相关帖文 回复 查看 活动
7
7月 19
41888
0
4月 19
3284
0
10月 19
4357
0
8月 18
7017
1
12月 17
3586