| | |
|---|
| | | ,caa.community_id as communityId,cpm.id as memberId,cpm.name as memberName,cpcu.name as belongUnit,ca.name as belongCommunity,cpcu.belong_to |
|---|
| | | FROM `com_act_activity` as caa |
|---|
| | | left join com_act_act_sign as caas on caa.id=caas.activity_id |
|---|
| | | <!--left join com_pb_member as cpm on caas.user_id=cpm.id--> |
|---|
| | | left join com_pb_member as cpm on caa.sponsor_id=cpm.id |
|---|
| | | left join sys_user as su on caa.sponsor_id=su.user_id |
|---|
| | | left join com_pb_check_unit as cpcu on cpm.check_unit_id=cpcu.id |
|---|
| | | left join com_act as ca on cpm.community_id=ca.community_id |
|---|
| | | where caa.sponsor_id<>'' |
|---|
| | |
|---|
| | | and belong_to=#{belongTo} |
|---|
| | | </if> |
|---|
| | | GROUP BY (caa.sponsor_id) |
|---|
| | | having serviceTimes<>'' and serviceTime<>'' |
|---|
| | | having serviceTimes<>'' and serviceTime<>'' and memberName<>'' |
|---|
| | | </select> |
|---|
| | | <select id="institutionalPartyMemberActAnalysis" |
|---|
| | | resultType="com.panzhihua.common.model.vos.neighbor.PartyMemberAnalysisVO"> |
|---|
