Skip to Content
This question has been flagged
2 Replies
3566 Views
Avatar
rosey

I have four fields

join - date field

rejoin - date field

date - date field

days - char

<field name="join" on_change="on_change_join(date_join)"/>

<field name="rejoin" on_change="on_change_rejoin(date_rejoin)"/>

<field name="date" />

<field name="days" on_change="on_change_rejoin(days)"/>

 

When we enter join/rejoin date field, it will call the onchange function.

def on_change_join/rejoin(self, cr, uid, ids, join/rejoin, context=None):
          records = self.browse(cr, uid, ids, context=context)
          res = {}
          for r in records:
            
              vacation_due = 0
              format_string =  "%Y-%m-%d"
              if r.join/rejoin:
                  datetime_object = datetime.strptime(r.join/rejoin, format_string).date()
                  print "datetime_object",datetime_object
                  new_date = datetime_object + relativedelta(years=2)
                  print "new_date",new_date
                  new_date_string = datetime.strftime(new_date,format_string)
                  print "new_date_string",new_date_string
              
              
              return {'value': {'date': new_date_string}}

But it doesnt shows clear output. ie, it shows error when i first enter join/rejoin date

Error: return {'value': {'date': new_date_string}}

UnboundLocalError: local variable 'new_date_string' referenced before assignment

 

 

When i enter days, it will sum up with date field. But it also shows error

 

def my_onchange_days(self, cr, uid, ids,days, context=None):

 return {'value': {'date': (datetime.strptime(date,'%Y-%m-%d %H:%M:%S') + relativedelta(days=days)).strftime('%Y-%m-%d %H:%M:%S')}}

 Please help me any one to solve this.

 

 

 

Avatar
Discard
Avatar
Narayanamurthy
Best Answer

Hi rosey, i either of both tho functions you need to check the field value befor doing and calculation on it

def on_change_join/rejoin(self, cr, uid, ids, join/rejoin, context=None):
          records = self.browse(cr, uid, ids, context=context)
          res = {}

          new_date_string = False
          for r in records:
              vacation_due = 0
              format_string =  "%Y-%m-%d"
              if r.join/rejoin:
                  datetime_object = datetime.strptime(r.join/rejoin, format_string).date()
                  print "datetime_object",datetime_object
                  new_date = datetime_object + relativedelta(years=2)
                  print "new_date",new_date
                  new_date_string = datetime.strftime(new_date,format_string)
                  print "new_date_string",new_date_string

       return {'value': {'date': new_date_string}}

And

def my_onchange_days(self, cr, uid, ids,days, context=None):
    res = {}
    if days:
        res['date'] : (datetime.strptime(date,'%Y-%m-%d %H:%M:%S') + relativedelta(days=days)).strftime('%Y-%m-%d %H:%M:%S')}
return {'value': res }

 

 

Avatar
Discard
Dimple

hai, i getting this error while doing this code res['date'] : (datetime.strptime(date,'%Y-%m-%d %H:%M:%S') + ^ relativedelta(days=days)).strftime('%Y-%m-%d %H:%M:%S')} SyntaxError: invalid syntax

Ivan

Did you notice the ^ sign in front of relativedelta that you have pasted?

Avatar
Temur
Best Answer

hi,

for resolve "UnboundLocalError: local variable 'new_date_string' referenced before assignment", try:

def on_change_join/rejoin(self, cr, uid, ids, join/rejoin, context=None):
          records = self.browse(cr, uid, ids, context=context)
          res = {}
          vals = {}
          for r in records:
            
              vacation_due = 0
              format_string =  "%Y-%m-%d"
              if r.join/rejoin:
                  datetime_object = datetime.strptime(r.join/rejoin, format_string).date()
                  print "datetime_object",datetime_object
                  new_date = datetime_object + relativedelta(years=2)
                  print "new_date",new_date
                  new_date_string = datetime.strftime(new_date,format_string)
                  vals['date'] = new_date_string
                  print "new_date_string",new_date_string
              
              
              return {'value': vals}

 

reagards,

Avatar
Discard
Dimple

hai, i tried this code but it didn't returning any value. what will i do to return the value?

Temur
-in this line, why you're passing 'date_rejoin' as parameter in XML? you've another field named "date_rejoin"? if you're trying to pass this same field, then please try instead. I mean that you've to use parameter name exactly as it appears in 'name' paroperty (name="rejoin"...). Same for other fields.
Temur

in this line: field name="rejoin" on_change="on_change_rejoin(date_rejoin) try instead: field name="rejoin" on_change="on_change_rejoin(rejoin) -these parts disappeared from my previous comment, due to xml tags... < >