| | |
|---|
| | | '未注册' ELSE '已注册' |
|---|
| | | END status |
|---|
| | | from com_pb_member as m |
|---|
| | | LEFT JOIN sys_user u ON m.id_card = u.id_card |
|---|
| | | LEFT JOIN sys_user u ON m.id_card = u.id_card and u.type = 1 |
|---|
| | | LEFT JOIN com_pb_org o ON m.org_id = o.id |
|---|
| | | LEFT JOIN com_pb_check_unit as cpcu ON m.check_unit_id = cpcu.id |
|---|
| | | LEFT JOIN (select t1.user_id,sum(t.duration) as partyTime,sum(t.reward_integral) as partyInterval from com_act_activity t LEFT JOIN com_act_act_regist t1 on t.id = t1.activity_id where t.type = 3 |
|---|
| | |
|---|
| | | com_pb_member AS cpm |
|---|
| | | LEFT JOIN com_pb_check_unit AS cpcu ON cpcu.id = cpm.check_unit_id |
|---|
| | | LEFT JOIN com_pb_org AS cpo ON cpo.id = cpm.org_id |
|---|
| | | LEFT JOIN sys_user t1 on cpm.id_card = t1.id_card |
|---|
| | | LEFT JOIN sys_user t1 on cpm.id_card = t1.id_card and t1.type=1 |
|---|
| | | <where> |
|---|
| | | and cpm.audit_result = 1 |
|---|
| | | <if test="dto.communityId != null"> |
|---|
