党委修改

findyguo

2021-03-03 8bb0a52f33f71836c015e9a28b26fc8e35b3f5a7

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

@@ -30,30 +30,15 @@
//            "</script>")
    @Select("<script> " +
            "SELECT\n" +
            "mr.id,\n" +
            "m.NAME,\n" +
            "u.phone,\n" +
            "'党员' politicalOutlook,\n"+
            "m.photo_path,\n" +
            "*,\n" +            
            "TIMESTAMPDIFF(\n" +
            "YEAR,\n" +
            "m.employment_time,\n" +
            "DATE_FORMAT( NOW(), '%Y-%m-%d' )) partyAge,\n" +
            "r.role_name ,\n" +
            "mr.role_id \n"+
            "t.birth_time,\n" +
            "DATE_FORMAT( NOW(), '%Y-%m-%d' )) age\n" +            
            "FROM\n" +
            "com_pb_member_role mr\n" +
            "JOIN com_pb_member m ON mr.member_id = m.id\n" +
            "JOIN sys_role r ON mr.role_id = r.role_id \n" +
            "LEFT JOIN sys_user u ON m.id_card = u.id_card\n" +
            "com_pb_member_role t\n" +
            "WHERE\n" +
            "mr.community_id = #{partyCommitteeVO.communityId} \n" +
            "<if test='partyCommitteeVO.name != null and partyCommitteeVO.name.trim() != &quot;&quot;'>" +
            "AND m.`name` like concat(#{partyCommitteeVO.name},'%')  \n" +
            " </if> " +
            "<if test='partyCommitteeVO.roleId != null and partyCommitteeVO.roleId != 0'>" +
            "AND r.role_id =#{partyCommitteeVO.roleId}" +
            " </if> " +
            "t.community_id = #{partyCommitteeVO.communityId} \n" +
            "</script>")
    IPage<PartyCommitteeVO> pagePartyOrganization(Page page, @Param("partyCommitteeVO") PartyCommitteeVO partyCommitteeVO);
}