# 先设置个默认值
result = ''
a = env.cr.execute
# 获取薪资批次的json_data数据
data = record.get_json_data()
# 取出data中的批次的值
batchId = data.get('batchId', False)
if batchId:
a("""select periods.period_name from batches
left join (select id,coalesce(to_char(salary_month,'YYYYMM'), name) as period_name,
coalesce(to_char(tax_month, 'YYYYMM'), '0')::int new_tax_month,
coalesce(to_char(salary_month,'YYYYMM'),'0')::int new_salary_month from periods) periods
on batches.period_id=periods.id where batches.id=%s""",(batchId,))
res = env.cr.fetchone()
if res:
result = res[0]
Change
High
Page 正在加载
