Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
3 Odpowiedzi
10762 Widoki

Am trying to prevent selecting of the same value in one2many field, when the 'select an item' button is clicked .For example when trying to select the same product that has been already selected in sale order.

Awatar
Odrzuć
Najlepsza odpowiedź

I have done the same requirement in my project. I restricted duplication of product addition at o2m in sales form. (v7)

sale.py

 def onchange_one2many(self, cr, uid, ids, order_line):

mylist = []

if order_line != []:

    for line in order_line:

        for loop in line:

            if isinstance(loop, dict):

                mylist.append(loop['product_id'])

if len(mylist) != len(set(mylist)):

    raise osv.except_osv(_('Warning'),_('Product Should be Unique'))

return True

.xml

<field name="order_line" on_change="onchange_one2many(order_line)" />

Thanks Rifakat Haradwala

Note: Correct me if anyone has better answer

Awatar
Odrzuć
Najlepsza odpowiedź

you can get the idea by this code .... just get unique ids of each many2one field ...in my case i had 2...


def onchange_line_course(self):

lists_course=self.courselines.mapped('field1.id')
lists_assesment=self.courselines.mapped('field2.id')
for rec in lists_assesment:
for crs in lists_course:
record_count = self.courseline.filtered(lambda rex: rex.course.id == crs and rex.assessment.id == rec)

if len(record_count) >1:
print(cannot select duplicate values


if you have only one many2one filed then only one for loop would be required
Awatar
Odrzuć
Najlepsza odpowiedź

Hi,

Well you need specific development for that. It's not something you could configure.

You need to override write() of the main model and in write() you can iterate on the IDs of o2m field and put a check on the Product if it repeats and raise warning. Write() will be called when you save main form, so you won't be notified while you actually inserting line items. I am not sure onchange of o2m field would help because ID of newly inserted line item is not yet created while you add it, but you can give it onchange(o2m) also try.

Regards,

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
2
maj 19
4148
0
maj 16
4777
1
mar 15
5191
1
mar 23
2245
0
gru 22
2877