| | |
| | | <if test="communityId != null"> |
| | | and su.community_id=#{communityId} |
| | | </if> |
| | | GROUP BY (caa.sponsor_id) |
| | | having serviceTimes<>'' and serviceTime<>'' and memberName<>'' |
| | | <if test="unitId != null"> |
| | | and caa.check_unit_id=#{unitId} |
| | | </if> |
| | | GROUP BY (caa.sponsor_id) |
| | | having serviceTimes<>'' and serviceTime<>'' and memberName<>'' |
| | | |
| | | order by serviceTime desc |
| | | </select> |
| | | <select id="institutionalPartyMemberActAnalysis" |
| | |
| | | <if test="communityId != null"> |
| | | and su.community_id=#{communityId} |
| | | </if> |
| | | GROUP BY (canc.solve_id) |
| | | having serviceTimes<>'' and serviceTime<>'' and memberName<>'' |
| | | <if test="unitId != null"> |
| | | and cpcu.id=#{unitId} |
| | | </if> |
| | | GROUP BY (canc.solve_id) |
| | | having serviceTimes<>'' and serviceTime<>'' and memberName<>'' |
| | | order by serviceTime desc |
| | | </select> |
| | | <select id="institutionalPartyMemberServiceAnalysisByServicesTimes" |