| | |
|---|
| | | com_act_act_sign AS caas4 |
|---|
| | | LEFT JOIN com_act_activity AS caa4 ON caa4.id = caas4.activity_id |
|---|
| | | WHERE |
|---|
| | | caas4.`status` = 1 and (caas4.type = 1 or caas4.type = 3) |
|---|
| | | caas4.`status` = 1 and (caa4.type = 1 or caa4.type = 3) |
|---|
| | | AND caas4.user_id IN ( SELECT t1.user_id FROM com_pb_member t left join sys_user t1 on t.id_card=t1.id_card WHERE audit_result = 1 AND t.community_id = #{communityId} AND t1.type=1 |
|---|
| | | <if test="orgIds != null and orgIds.size > 0"> |
|---|
| | | AND org_id in |
|---|
| | |
|---|
| | | com_act_act_sign as caas5 |
|---|
| | | left join com_act_activity as caa5 on caa5.id = caas5.activity_id |
|---|
| | | WHERE |
|---|
| | | caas5.`status` = 1 and (caas5.type = 1 or caas5.type = 3) |
|---|
| | | caas5.`status` = 1 and (caa5.type = 1 or caa5.type = 3) |
|---|
| | | AND caas5.user_id IN ( SELECT t1.user_id FROM com_pb_member t left join sys_user t1 on t.id_card=t1.id_card WHERE audit_result = 1 AND t.community_id = #{communityId} AND t1.type=1 |
|---|
| | | <if test="orgIds != null and orgIds.size > 0"> |
|---|
| | | AND org_id in |
|---|
