101captain
2022-07-08 719ec5c487619d5eda52971e3c09ff0848924bb4
问题清单bug处理
1个文件已修改
9 ■■■■■ 已修改文件
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActNeighborCircleDOMapper.xml 9 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActNeighborCircleDOMapper.xml
@@ -322,11 +322,12 @@
        <if test="communityId != null">
            and su.community_id=#{communityId}
        </if>
        GROUP BY (caa.sponsor_id)
        having serviceTimes&lt;>'' and serviceTime&lt;>'' and memberName&lt;>''
        <if test="unitId != null">
            and caa.check_unit_id=#{unitId}
        </if>
        GROUP BY (caa.sponsor_id)
        having serviceTimes&lt;>'' and serviceTime&lt;>'' and memberName&lt;>''
        order by serviceTime desc
    </select>
    <select id="institutionalPartyMemberActAnalysis"
@@ -347,11 +348,11 @@
        <if test="communityId != null">
            and su.community_id=#{communityId}
        </if>
        GROUP BY (canc.solve_id)
        having serviceTimes&lt;>'' and serviceTime&lt;>'' and memberName&lt;>''
        <if test="unitId != null">
            and cpcu.id=#{unitId}
        </if>
        GROUP BY (canc.solve_id)
        having serviceTimes&lt;>'' and serviceTime&lt;>'' and memberName&lt;>''
        order by serviceTime desc
    </select>
    <select id="institutionalPartyMemberServiceAnalysisByServicesTimes"