def get_resignation_reason(): """ : return : 离职原因:str """ result = '' employee_id = record.employee_id.id sql = '''select ir_translation.value,resignation_reason.name from employee_resignation left join resignation_reason on resignation_reason.id = employee_resignation.resignation_reason left join ir_translation on resignation_reason.id=ir_translation.res_id and ir_translation.name = 'resignation.reason,name' and ir_translation.lang= 'zh_CN' where employee_resignation.resignation_reason is not null and employee_resignation.active=True and employee_resignation.employee_id = {0} order by employee_resignation.id desc limit 1 '''.format(employee_id) env.cr.execute(sql) query = env.cr.fetchone() return query[0] if query else '' result = get_resignation_reason()