小程序登录以及实名认证模块改版

huanghongfa

2021-08-10 63cdfcdab5b90e25dc468967c5e4ac0315965f02

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoCommentDAO.java

@@ -29,7 +29,8 @@
//            " </if> " +
//            " </where>" +
//            "</script>")
    @Select("select * from (" +
    @Select("<script> " +
            "select * from (" +
            "SELECT \n" +
            "m.id,\n" +
            "m.`comment`,\n" +
@@ -37,16 +38,20 @@
            "e.`nick_name`,\n" +
            "e.image_url url,\n" +
            "m.create_at,\n" +
            "if(u1.id is null,0,1)haveSign,\n" +
            "<if test='comActEasyPhotoCommentDTO.userId != null'>" +
            " if(u1.id is null,0,1)haveSign,\n" +
            "</if> " +
            "COUNT(u.id)num\n" +
            "FROM\n" +
            "com_act_easy_photo_comment m \n" +
            "JOIN sys_user e on m.user_id=e.user_id\n" +
            "LEFT JOIN com_act_easy_photo_comment_user u on m.id=u.easy_photo_comment_id\n" +
            "LEFT JOIN com_act_easy_photo_comment_user u1 on m.id=u1.easy_photo_comment_id and u1.user_id=#{comActEasyPhotoCommentDTO.userId}\n" +
            "<if test='comActEasyPhotoCommentDTO.userId != null'>" +
            " LEFT JOIN com_act_easy_photo_comment_user u1 on m.id=u1.easy_photo_comment_id and u1.user_id=#{comActEasyPhotoCommentDTO.userId}\n" +
            "</if> " +
            "where m.easy_photo_id=#{comActEasyPhotoCommentDTO.id}  " +
            "GROUP BY m.id\n" +
            " )t order by t.num desc, t.create_at DESC ")
            " )t order by t.num desc, t.create_at DESC </script>")
    IPage<ComActEasyPhotoCommentVO> pageComActEasyPhotoComment(Page page, @Param("comActEasyPhotoCommentDTO") PageComActEasyPhotoCommentDTO pageComActEasyPhotoCommentDTO);