| | |
| | | <select id="getSignLists" resultType="com.panzhihua.common.model.vos.community.ComActActSignExcelVO"> |
| | | SELECT |
| | | caas.create_at, |
| | | IF(r.times IS NULL, 0, r.times) AS times, |
| | | caas.times, |
| | | CASE |
| | | WHEN caas.status = 1 THEN |
| | | '已报名' ELSE '已取消' |
| | |
| | | su.`name`, |
| | | su.phone, |
| | | su.tags, |
| | | CASE |
| | | WHEN caas.is_volunteer = 1 THEN |
| | | '志愿者' ELSE '居民' |
| | | END identity |
| | | CASE WHEN t.type = 1 THEN '志愿者' WHEN t.type=2 THEN '居民' ELSE '党员' END identity |
| | | |
| | | FROM |
| | | com_act_act_sign caas |
| | |
| | | </select> |
| | | <select id="listActivitySign" resultType="com.panzhihua.common.model.vos.community.ActivitySignVO"> |
| | | SELECT u.user_id id, u.image_url, u.name, u.nick_name, |
| | | CASE WHEN a.is_volunteer = 1 THEN '志愿者' ELSE '居民' END identity, |
| | | CASE WHEN t.type = 1 THEN '志愿者' WHEN t.type=2 THEN '居民' ELSE '党员' END identity, |
| | | u.phone, u.tags, a.create_at, a.is_volunteer, a.status , a.times, |
| | | a.reason, IF(r.times IS NULL, 0, r.award * r.times) AS award, t.limit |
| | | FROM com_act_act_sign a |