花城-智慧社区
parent: 8de92cca | 补丁 | 提交 | show whitespace
yanghui
2022-12-05 769c9e2fc072e65c72df41d8726b7e252566700a 
#feat ,,
1个文件已修改
20 ■■■■■ 已修改文件
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComPbMemberMapper.xml 20 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComPbMemberMapper.xml


@@ -59,25 +59,25 @@


    </select>


    <select id="statisticsPbMemberType"


            resultType="com.panzhihua.common.model.vos.partybuilding.ComPbMemberTypeVO">


        SELECT count(1) count_num, 'tjdc' as count_name FROM com_pb_member WHERE  find_in_set('统计调查',specialty_name)


        SELECT count(1) count_num, '统计调查' as count_name FROM com_pb_member WHERE  find_in_set('统计调查',specialty_name)


        UNION ALL


        SELECT count(1) count_num, 'flyz' as count_name FROM com_pb_member WHERE  find_in_set('法律援助',specialty_name)


        SELECT count(1) count_num, '法律援助' as count_name FROM com_pb_member WHERE  find_in_set('法律援助',specialty_name)


        UNION ALL


        SELECT count(1) count_num, 'zyhd' as count_name FROM com_pb_member WHERE  find_in_set('志愿活动',specialty_name)


        SELECT count(1) count_num, '志愿活动' as count_name FROM com_pb_member WHERE  find_in_set('志愿活动',specialty_name)


        UNION ALL


        SELECT count(1) count_num, 'zlay' as count_name FROM com_pb_member WHERE  find_in_set('尊老爱幼',specialty_name)


        SELECT count(1) count_num, '尊老爱幼' as count_name FROM com_pb_member WHERE  find_in_set('尊老爱幼',specialty_name)


        UNION ALL


        SELECT count(1) count_num, 'xjxj' as count_name FROM com_pb_member WHERE  find_in_set('宣讲宣教',specialty_name)


        SELECT count(1) count_num, '宣讲宣教' as count_name FROM com_pb_member WHERE  find_in_set('宣讲宣教',specialty_name)


        UNION ALL


        SELECT count(1) count_num, 'xlga' as count_name FROM com_pb_member WHERE  find_in_set('心理关爱',specialty_name)


        SELECT count(1) count_num, '心理关爱' as count_name FROM com_pb_member WHERE  find_in_set('心理关爱',specialty_name)


        UNION ALL


        SELECT count(1) count_num, 'sswx' as count_name FROM com_pb_member WHERE  find_in_set('设施维修',specialty_name)


        SELECT count(1) count_num, '设施维修' as count_name FROM com_pb_member WHERE  find_in_set('设施维修',specialty_name)


        UNION ALL


        SELECT count(1) count_num, 'qt' as count_name FROM com_pb_member WHERE  find_in_set('其他',specialty_name)


        SELECT count(1) count_num, '其他' as count_name FROM com_pb_member WHERE  find_in_set('其他',specialty_name)


    </select>


    <select id="selectUnitByNatureName" resultType="com.panzhihua.common.model.vos.partybuilding.ComPbMemberTypeVO">


        SELECT count(1) count_num,'qsydw' as count_name FROM com_pb_check_unit WHERE nature_name = '企事业单位'


        SELECT count(1) count_num,'企事业单位' as count_name FROM com_pb_check_unit WHERE nature_name = '企事业单位'


         UNION ALL


         SELECT count(1) count_num,'jgdw' as count_name FROM com_pb_check_unit WHERE nature_name = '机关单位'


         SELECT count(1) count_num,'机关单位' as count_name FROM com_pb_check_unit WHERE nature_name = '机关单位'


    </select>


</mapper>