current_date = datetime.today().strftime('%Y-%m-%d') records = env ['hr.employee'] .search(cr, 1, [('id','=',25878),('active', '=', True), ('departure_time', '=', current_date), ('work_activity', '=', 'in_service')] ) records = env ['hr.employee'] .search(cr, 1, [('active', '=', True), ('departure_time', '=', current_date), ('work_activity', '=', 'in_service')] ) for record in records: employee = env ['hr.employee'] .browse(cr,1,record) employee.write( {'work_activity':'turn_over'} ) employees = env ['hr.employee'] .search(cr, 1, [('id','=',25878),('departure_time', '!=', False)] ) _logger.info('---------- employees:%s -------' % employees) for employee in employees: employee = env ['hr.employee'] .browse(cr,1,employee) records = env ['employee.withhold.agent.relationship'] .search(cr, 1, [('employee_id','=',employee.id)] ,order='create_date desc',limit=1) _logger.info('-------------------') _logger.info('---------- records:%s -------' % records) for record in records: if record: res = env ['employee.withhold.agent.relationship'] .browse(cr,1,record) _logger.info('-------------------') _logger.info('---------- res:%s -------' % res) if not res.departure_time: _logger.info('-------------------') _logger.info('---------- relation_ids:%s -------' % employee.relation_ids) res.write( {'departure_time':res.employee_id.departure_time} )