select
a.code 流水号,
b.org_name 组织机构,
b.NAME AS 事项名称,
b.created_at 创建日期,
b.created_by 创建人,
-- a.state 办件状态
CASE
a.state
WHEN '1' THEN
'待预审'
WHEN '2' THEN
'待收件'
WHEN '3' THEN
'待处理'
WHEN '4' THEN
'待审办'
WHEN '5' THEN
'待审查'
WHEN '6' THEN
'待决定'
WHEN '7' THEN
'待补齐补正'
WHEN '9' THEN
'已办结'
WHEN '10' THEN
'预审驳回'
WHEN '11' THEN
'不予受理'
WHEN '12' THEN
'准予许可'
WHEN '13' THEN
'不予许可'
WHEN '14' THEN
'退件办结'
WHEN '16' THEN
'作废办结'
WHEN '19' THEN
'补齐补正不来'
WHEN '22' THEN
'待审核'
WHEN '31' THEN
'退回已处理'
ELSE a.state
END 办件状态
FROM
t_workorder a
INNER JOIN t_workorder_item b ON a.id = b.workorder_id
LEFT JOIN t_post_info t5 ON a.id = t5.workorder_id
WHERE
a.apply_date >= '2020-01-01 00:00:00' AND a.apply_date < '2021-01-01 00:00:00'
AND a.state not in (0,-1,90)
AND source IN('cssg_xd_sxzcxt','cssg_my_csapp','1','cssg_cards')
and b.area_code like '430111%'
order by b.org_name,b.NAME;
当a.state为不同的值时显示不同的文本