| | |
|---|
| | | </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 t.type = 1 and caar.is_volunteer = 1 THEN '志愿者' WHEN t.type = 1 and caar.is_volunteer = 0 THEN '居民' WHEN t.type=2 THEN '居民' ELSE '党员' END identity, |
|---|
| | | CASE WHEN t.type = 1 and a.is_volunteer = 1 THEN '志愿者' WHEN t.type = 1 and a.is_volunteer = 0 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 |
|---|
