Skip to Content
Menu
This question has been flagged
7 Replies
4727 Views

Hi all

i have code like this

class mtc_hr_analytic_timesheet(osv.osv):

    _inherit = 'hr.analytic.timesheet'

    _columns = {

                    'approver' : fields.many2one('res.users','Approver',readonly=True),

    }


i want value in field approver store to my database. but when i use readonly its doesnt work. the value dissapear when i save.

i have use strore=True but its doesnt work.

anyone can help me how to solve this problem??


Thanks before

Avatar
Discard
Author

Can you give an example code of the contents of xyz_id ?

for example, to get the id of the ERP Manager

users_ids = self.pool.get('res.users').search(cr, uid, [])

for _id in users_ids:

if self.pool['res.users'].has_group(cr, _id, 'base.group_erp_manager')

xyz_id = _id

Best Answer

Hey Susi!, Hope this will work for u.. 

samp_cal1=fields.Integer(string="a")

samp_cal2=fields.Integer(string="b")

samp_cal3=fields.Integer(string="c",readonly=True)


@api.onchange('samp_cal1','samp_cal2')

def adding_samp(self):

    self.samp_cal3=self.samp_cal1+self.samp_cal2

@api.model

def create(self,vals):

    if self.samp_cal3:

        vals['samp_cal3']=self.samp_cal1+self.samp_cal2

    res = super(tokenreservation, self).create(vals)

    return res

@api.multi

def write(self,vals):

    if not self.samp_cal3:

        vals['samp_cal3'] = self.samp_cal1+self.samp_cal2

    res = super(tokenreservation, self).write(vals)

    return res

Avatar
Discard
Best Answer

assighn values like this



cr.execute("UPDATE  hr_analytic_timesheet SET approver = %s where id = %s ", (  your value, id of object ))

Avatar
Discard
Best Answer

try to write the value into the field using SQL query

Avatar
Discard
Best Answer

You can update a many2one field, with either an ID or record.

You can’t put any ID or record, a check is made on the relationship to ensure data integrity

Avatar
Discard
Best Answer

 You have to set the value of this field in the create method explicitly

def create(self, cr, uid, val, context=None):
...
val['approve'] = xyz_id # this is the user id you decided that he will do the approval
res = super(you_class, self).create(cr, uid, val, context)
return res





Avatar
Discard
Related Posts Replies Views Activity
1
Oct 24
249
1
Aug 23
12547
1
Aug 23
11053
1
Jul 23
7228
4
Apr 23
8676