| | |
| | | caae.evaluate_content, |
| | | su.`name`, |
| | | su.phone, |
| | | CASE WHEN t.type = 1 THEN '志愿者' WHEN t.type=2 THEN '居民' ELSE '党员' END identity |
| | | CASE WHEN t.type = 1 and caae.is_volunteer = 1 THEN '志愿者' WHEN t.type = 1 and caae.is_volunteer = 0 THEN '居民' WHEN t.type=2 THEN '居民' ELSE '党员' END identity |
| | | |
| | | FROM |
| | | com_act_act_evaluate caae |
| | |
| | | su.`name`, |
| | | su.phone, |
| | | su.tags, |
| | | CASE WHEN t.type = 1 THEN '志愿者' WHEN t.type=2 THEN '居民' ELSE '党员' END identity |
| | | CASE WHEN t.type = 1 and caas.is_volunteer = 1 THEN '志愿者' WHEN t.type = 1 and caas.is_volunteer = 0 THEN '居民' WHEN t.type=2 THEN '居民' ELSE '党员' END identity |
| | | |
| | | FROM |
| | | com_act_act_sign caas |