| | |
|---|
| | | ceae.phone, |
|---|
| | | ceae.`name`, |
|---|
| | | ceae.id_card, |
|---|
| | | case when caea.sex = 1 then '男' when caea.sex = 2 then '女' end |
|---|
| | | ceae.sex, |
|---|
| | | case when su.sex = 1 then '男' when su.sex = 2 then '女' end |
|---|
| | | sex, |
|---|
| | | ceae.birthday, |
|---|
| | | case when caea.personnel_category = 1 then '80-89周岁' when caea.personnel_category = 2 then '90-99周岁' when caea.personnel_category = 3 then '100周岁（含）以上' end |
|---|
| | | ceae.personnel_category, |
|---|
| | | case when ceae.personnel_category = 1 then '80-89周岁' when ceae.personnel_category = 2 then '90-99周岁' when ceae.personnel_category = 3 then '100周岁（含）以上' end |
|---|
| | | personnel_category, |
|---|
| | | cear.address, |
|---|
| | | case when caea.is_alive = 1 then '是' when caea.is_alive = 2 then '否' end |
|---|
| | | ceae.is_alive, |
|---|
| | | case when caea.auth_method = 1 then '视频认证' when caea.auth_method = 2 then '人脸认证' when caea.auth_method = 3 then '线下认证' end |
|---|
| | | cear.auth_method, |
|---|
| | | case when ceae.is_alive = 1 then '是' when ceae.is_alive = 2 then '否' end |
|---|
| | | is_alive, |
|---|
| | | case when cear.auth_method = 1 then '视频认证' when cear.auth_method = 2 then '人脸认证' when cear.auth_method = 3 then '线下认证' end |
|---|
| | | auth_method, |
|---|
| | | cear.auth_period, |
|---|
| | | cear.auth_video, |
|---|
| | | cear.auth_date, |
|---|
| | | cear.mark, |
|---|
| | | case when caea.approval_status = 1 then '待审核' when caea.approval_status = 2 then '驳回' when caea.approval_status = 3 then '通过' end |
|---|
| | | cear.approval_status, |
|---|
| | | case when cear.approval_status = 1 then '待审核' when cear.approval_status = 2 then '驳回' when cear.approval_status = 3 then '通过' end |
|---|
| | | approval_status, |
|---|
| | | cear.approver_id, |
|---|
| | | su1.`name` as approverName, |
|---|
| | | cear.approval_date, |
|---|
