修改大屏查询无数据

lidongdong

2023-03-01 75352d76e8790788626abb49a26cb4689f171c0b

修改大屏查询无数据

 springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbMemberRoleDAO.java

@@ -31,6 +31,12 @@
    IPage<PartyCommitteeVO> pagePartyOrganization(Page page,
        @Param("partyCommitteeVO") PartyCommitteeVO partyCommitteeVO);



    IPage<com.panzhihua.common.model.vos.partybuilding.PartyCommitteeVO> pagePartyOrganizations(Page page,
                                                  @Param("partyCommitteeVO") com.panzhihua.common.model.vos.partybuilding.PartyCommitteeVO partyCommitteeVO);


    @Select("select * from sys_user where phone=#{phone} AND app_id = #{appid} and type=1")
    SysUserVO getSysUserByPhone(@Param("phone") String phone, @Param("appid") String appid);


 springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/impl/ComPbMemberServiceImpl.java

@@ -301,7 +301,22 @@

    @Override
    public R pagePartyCommittee(PartyCommitteeVO partyCommitteeVO) {
        return null;
        Page page = new Page<>();
        Long pageNum = partyCommitteeVO.getPageNum();
        Long pageSize = partyCommitteeVO.getPageSize();
        if (null == pageNum || 0 == pageNum) {
            pageNum = 1l;
        }
        if (null == pageSize || 0 == pageSize) {
            pageSize = 10l;
        }
        page.setSize(pageSize);
        page.setCurrent(pageNum);
        IPage<PartyCommitteeVO> iPage = comPbMemberRoleDAO.pagePartyOrganizations(page, partyCommitteeVO);
        iPage.getRecords().forEach(record -> {
            record.setPhone(SensitiveUtil.desensitizedPhoneNumber(record.getPhone()));
        });
        return R.ok(iPage);
    }

//    /**

 springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/ComPbMemberRoleDOMapper.xml

@@ -75,4 +75,35 @@
        order by cpmr.create_at desc
    </select>



    <select id="pagePartyOrganizations" resultType="com.panzhihua.common.model.vos.partybuilding.PartyCommitteeVO">
        select cpmr.id,cpmr.community_id,cpmr.`name`,cpmr.id_card,cpmr.org_id,cpmr.check_unit_id
        , cpmr.phone,cpmr.is_reg,cpmr.sex,cpmr.birth_time,cpmr.position,cpmr.position_two
        , cpmr.job_responsibilities,cpmr.photo_path,cpmr.type,cpmr.join_time,cpmr.employment_time
        , cpmr.create_at,cpmr.update_at,cpmr.function,cpmr.specialty_category,cpmr.specialty_name
        ,YEAR (now()) - YEAR (substring(cpmr.id_card, 7, 8)) age,cpo.`name` as orgName,cpcu.`name` as checkUnitName
        from com_pb_member_role as cpmr
        left join com_pb_org as cpo on cpo.id = cpmr.org_id
        left join com_pb_check_unit as cpcu on cpcu.id = cpmr.check_unit_id
        <where>
            <if test="partyCommitteeVO.communityId != null">
                and cpmr.community_id = #{partyCommitteeVO.communityId}
            </if>
            <if test="partyCommitteeVO.type != null">
                and cpmr.type = #{partyCommitteeVO.type}
            </if>
            <if test="partyCommitteeVO.sex != null">
                and cpmr.sex = #{partyCommitteeVO.sex}
            </if>
            <if test="partyCommitteeVO.keyWord != null and partyCommitteeVO.keyWord != ''">
                and (cpmr.name like concat (#{partyCommitteeVO.keyWord},'%') or
                cpmr.phone like concat (#{partyCommitteeVO.keyWord},'%') or
                cpmr.id_card = #{partyCommitteeVO.keyWord}
                )
            </if>
        </where>
        order by cpmr.create_at desc
    </select>

</mapper>