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

CRM
e-Commerce
Financeiro
Inventário
PoS
Projeto
MRP

All apps

Todas as publicações Pessoas Emblemas

Marcadores (Ver tudo)

odoo accounting v14 pos v15

Sobre este fórum

Ajuda

How to insert current date column in many2many relational table in odoo 8 ?

many2many datetime odoo8.0

3 Respostas

10779 Visualizações

odooPrac

ok, so I've been stuck with this for a while now. I'm trying to create a current date field (date_added) in model stock.location.lock.code.rel (which is a relational model for stock.location.lock.code and stock.location models). My problem is that the table and field gets created in postgres db but its not getting populated and I'm getting error (mentioned below code). My code is below (I'm a beginner in odoo, so please do suggest correct way of doing)

in stock.location class :

class StockLocation(models.Model):

_name = 'stock.location'

_inherit = 'stock.location'

@api.multi

def write(self, vals):

#I've overriden this method because I need to edit a form view and this method will be called when I press save button

now = datetime.now()

current_time = now.strftime('%m/%d/%Y %H:%M:%S')

vals = ({'date_added': current_time, 'active': True})

http.request.env['stock.location.lock.codes.rel'].create(vals)

return super(StockLocation, self).write(vals)

level = fields.Char('Level', size=1, default=None)

position = fields.Char('Position', size=1, default=None)

lock_code_ids = fields.Many2many('stock.location.lock.codes','stock_location_lock_code_rel','location_ids','lock_code_ids','Lock Code to apply', ondelete="cascade", default=None)

not_on_hand = fields.Boolean('not_on_hand', readonly=True, default=False)

class StockLocationLockCodeRel(models.Model):

_name = "stock.location.lock.code.rel"

location_ids = fields.Many2one('stock.location', 'Lock code location', required=True, ondelete="cascade")

lock_code_ids = fields.Many2one('stock.location.lock.codes', 'Lock code', required=True, ondelete="cascade")

active = fields.Boolean('Active', default=True)

date_added = fields.Datetime('Date Added')

id = fields.Char('id')

@api.multi

def create(self, vals):

return super(StockLocationLockCodeRel, self).create(vals)

Now my code for stock.location.lock.codes is :

from openerp import models, fields

class StockLocationLockCodes(models.Model):

_name = 'stock.location.lock.codes'

code = fields.Char('Code', size=2)

name = fields.Char('Name', size=100)

description = fields.Text('Description')

not_on_hand = fields.Boolean('On Hand', default=None)

unavailable = fields.Boolean('Available', default=None)

lock_in = fields.Boolean('Put', default=None)

lock_out = fields.Boolean('Pull', default=None)

active = fields.Boolean('Active', default=None)

show = fields.Boolean('Show in Location', default=None)

location_ids = fields.Many2many('stock.location','stock_location_lock_code_rel','lock_code_ids','location_ids','Lock code location', ondelete="cascade", default=None)

The error on logs is :

Traceback (most recent call last):

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/http.py", line 551, in _handle_exception

return super(JsonRequest, self)._handle_exception(exception)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/http.py", line 588, in dispatch

result = self._call_function(**self.params)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/http.py", line 324, in _call_function

return checked_call(self.db, *args, **kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/service/model.py", line 118, in wrapper

return f(dbname, *args, **kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/http.py", line 321, in checked_call

return self.endpoint(*a, **kw)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/http.py", line 817, in __call__

return self.method(*args, **kw)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/http.py", line 417, in response_wrap

response = f(*args, **kw)

File "/home/rohitupadhyay/git/odoo-IC-32/addons/web/controllers/main.py", line 944, in call_kw

return self._call_kw(model, method, args, kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/addons/web/controllers/main.py", line 936, in _call_kw

return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/api.py", line 268, in wrapper

return old_api(self, *args, **kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/api.py", line 399, in old_api

result = method(recs, *args, **kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/staples-addons/wms_stock/models/stock_location.py", line 167, in write

http.request.env['stock.location.lock.code.rel'].create(vals)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/api.py", line 266, in wrapper

return new_api(self, *args, **kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/staples-addons/wms_stock/models/stock_location.py", line 275, in create

return super(StockLocationLockCodeRel, self).create(vals)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/api.py", line 266, in wrapper

return new_api(self, *args, **kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/models.py", line 4094, in create

record = self.browse(self._create(old_vals))

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/api.py", line 266, in wrapper

return new_api(self, *args, **kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/api.py", line 508, in new_api

result = method(self._model, cr, uid, *args, **old_kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/models.py", line 4232, in _create

tuple([u[2] for u in updates if len(u) > 2])

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/sql_db.py", line 158, in wrapper

return f(self, *args, **kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/sql_db.py", line 234, in execute

res = self._obj.execute(query, params)

ProgrammingError: column "id" of relation "stock_location_lock_code_rel" does not exist

LINE 1: INSERT INTO "stock_location_lock_code_rel" ("id", "active", ...

Deepa Venkatesh

Melhor resposta

First you need the understand of concept of Many2Many relation & its table

A relation table created between 2 objects is just used to store the link of those, ideally it will have 2 fields, i.e ID of respective tables, hence you can not create any column in it.

odooPrac

Autor

thank you deep for your reply, but it is possible to add an extra field in Many2Many relational table. Please see this link :

https://www.odoo.com/forum/help-1/question/can-i-add-a-field-to-many2many-relation-table-30118

Also, there is a many2many relational table in odoo by name "im_chat_session_res_users_rel" which has more than 2 columns. I also looked into its source code before posting this question, but unable to figure out how this has been done. Thanks

John Doe

I used the following in OERP 7, which I believe it very similar to OERP 8 (aka ODOO)

class left_model(osv.osv):
    _name = 'left.model'


    _columns = {
        'rigths': fields.many2many(obj='right.model.id', rel='left_model_right_model_rel', id1='left_model_id', id2='right_model_id', string='Rigths'),
    }

left_model()


class right_model(osv.osv):
    _name = 'right.model'


    _columns = {
        'lefts': fields.many2many(obj='left.model.id', rel='left_model_right_model_rel', id1='right_model_id', id2='left_model_id', string='Lefts'),
    }

right_model()


class center_model(osv.osv):
    _name = 'center.model'
    _table = 'left_model_right_model_rel'  # this should match the rel argument in the other two models OR what ever OERP auto created. 


    _columns = {
        'left_model_id': fields.many2one(obj='left.model.id', string='Left Model ID'),
        'right_model_id': fields.many2one(obj='right.model.id', string='Right Model ID'),
        'new_field': fields.char(string='New Field'),  # this is your new field, customize it to your needs
    }

center_model()

In this example the new field is a char which the original question would have customized to his required type.

Está gostando da discussão? Não fique apenas lendo, participe!

Crie uma conta hoje mesmo para aproveitar os recursos exclusivos e interagir com nossa incrível comunidade!

Publicações relacionadas	Respostas	Visualizações
Datetime in Odoo Resolvido datetime odoo8.0	2 jul. 18	7660
From Datetime to Date Resolvido datetime odoo8.0	1 ago. 15	5053
Add a constraint to a many2many field Resolvido constraint many2many odoo8.0	1 jun. 17	8179
Cannot execute name_create, no _rec_name defined Resolvido many2many name_search many2many_tags odoo8.0	1 jan. 22	11400
How to filter for any day of the week in odoo filter date datetime odoo8.0	0 abr. 18	6531

Esta pergunta foi sinalizada

Está gostando da discussão? Não fique apenas lendo, participe!