Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

How to populate a one2many field from another one2many field?

one2many python2.7 openerp7 openerp7.0

2 Odpowiedzi

7262 Widoki

Anirudh Lou

I have this situation w/c i don't know what to do about it. The case is this: In class sale_order I have this definition:

...
'sched_lines' : fields.one2many('schedule.schedule','Schedule'),
'factor_lines' : fields.one2many('sale.order.factor','Factor'),

So does, in class account_invoice i also have this definition:

...
'sched_lines' : fields.one2many('schedule.schedule','Schedule'),
'factor_lines' : fields.one2many('sale.order.factor','Factor'),

Back to class sale_order i override the method manual_invoice ,

        ...
        for sale_order in self.browse(cr,uid,ids,context=context):
            _logger.info("\n\t\t\tFACTOR LINES IN SALE ORDER ... %s"%(str(sale_order.factor_lines)))
            _logger.info("\n\t\t\tHISTORY IN SALE ORDER ... %s"%(str(sale_order.sched_lines)))
            inv_id = self.pool.get('account.invoice').search(cr,uid,[('id','in',[new_inv_ids]),('origin','=',sale_order.name)])
            
            factor_list = self.pool.get('sale.order.factor').search(cr,uid,[('invoice_id','=',inv_id[0])])
            _logger.info("\n\t\t\tfactor_list...%s"%(str(factor_list)))
            factor_lines1 = [factors.id for factors in self.pool.get('sale.order.factor').browse(cr,uid,factor_list,context=context)]
            _logger.info("\n\t\t\tfactor_lines1...%s"%(str(factor_lines1)))
            
            # cr.execute('select id from sale_order_factor where invoice_id = %s', (tuple(inv_id)))
            #---------------- factor_lines1 = map(lambda x: x[0], cr.fetchall())
            # factor_lines1 = [(1,0,[factors.id for factors in sale_order.factor_lines])]
            #--- _logger.info("\n\t\t\tfactor_lines1...%s"%(str(factor_lines1)))
            
            self.pool.get('account.invoice').write(cr,uid,inv_id,{
                                                                  'sched_lines': [(6,0,[sched.id for sched in sale_order.sched_lines])],
                                                                  'factor_lines': [(6,0,[factor.id for factor in sale_order.factor_lines])],#factor_lines1
                                                                  }

what i can't understand is that this statement "[(6,0,[factor.id for factor in sale_order.factor_lines])]" does not work. When i view the invoice it has not populated. It's source, that is the factor_lines in sale_order, is not empty. While this statement "[(6,0,[sched.id for sched in sale_order.sched_lines])]" works fine. What's inside in sched_lines from sale_order is being carried fine. Does anyone can point out what's the missing, if there is any, in my code? I am really stuck in this.

Any help is very much appreciated.

Anil Kesariya

Najlepsza odpowiedź

Hi Anirudh Lou,

Wrong syntax followed,

Here is the solution : (Add Many2one field in both the relational model which is being used as one2many

_name = 'your.model.name'
'sched_lines' : fields.one2many('schedule.schedule','current_model_id', 'Schedule') 

'factor_lines' : fields.one2many('sale.order.factor', 'current_model_id','Factor'),

#instead of current_model_id you can write your own model name where fields are defined.

Than add many2one fields:

class sale_order_factor(models.Model):

    _name = 'sale.order.factor'  

    current_model_id = fields.Many2one('your.model.name', "Main Current Model")

#same as for other one2many field.

Hope this will help

Rgds,

Anil

Anirudh Lou

Autor

Yeah, thanks a lot. I also noticed it when i opened my project in inspecting what are my fields difinitions. Thanks again. :)

Anirudh Lou

Autor

Okay, I got it there is nothing wrong about the code. The mistake is on my declaration of

 'factor_lines' : fields.one2many('sale.order.factor','Factor'),

Instead of pointing it to it's counter part (many2one) in class sale_order_factor. It point to different class. By the way, i forgot that my declaration above is not correctly set as seen on the body part of this question, perhaps typo error.

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
How to get an id of a parent class (many2one) from its child class (one2many)? Rozwiązane one2many python2.7 openerp7	1 sie 15	8144
How to hide create button in tree view for all users except one group? Rozwiązane openerp7 openerp7.0	2 mar 24	12544
Dynamically created filter for tree view Rozwiązane openerp7 openerp7.0	2 sie 21	14502
How to identify machine on which openerp is opened? Rozwiązane openerp7 openerp7.0	5 sie 20	8529
Print multiple custom reports in one file from tree view openerp7 openerp7.0	1 gru 19	6088

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!