标签报事+通知公告

linwe

2023-11-12 8d8c7da4e91028fc877f101dcd244bef3e18c197

标签报事+通知公告

 src/main/java/org/springblade/modules/article/mapper/ArticleMapper.xml

@@ -52,30 +52,32 @@
    </select>

    <select id="selectArticlePageByApp" resultMap="noticeResultMap">
        select id,
               title,
               type,
               url,
               video_url,
               source_id,
               source_name,
               article_type,
               recommend,
               publish,
        iscomment,
        view_number,
        create_time,
        update_time,
        update_user,
        create_user,
        is_deleted
        from jczz_article
        where is_deleted = 0
        and publish = 1
        select ja.id,
        ja.title,
        ja.type,
        ja.url,
        ja.video_url,
        ja.source_id,
        ja.source_name,
        ja.article_type,
        ja.recommend,
        ja.publish,
        ja.iscomment,
        ja.view_number,
        ja.create_time,
        ja.update_time,
        ja.update_user,
        ja.create_user,
        ja.is_deleted,
        bdb.dict_value dictValue
        from jczz_article ja LEFT JOIN blade_dict_biz bdb on ja.article_type = bdb.dict_key
        where ja.is_deleted = 0
        and ja.publish = 1
        and bdb.parent_id = '1722966265111248897'
        <if test="article.articleType != null and article.articleType != ''">
          and  article_type = #{article.articleType}
          and  ja.article_type = #{article.articleType}
        </if>
        order by create_time desc
        order by ja.create_time desc
    </select>

    <!--查询资讯分页列表信息-->

 src/main/java/org/springblade/modules/article/vo/ArticleVO.java

@@ -62,4 +62,6 @@

    private Long userId;

    private String dictValue;

}