议题添加字段

lin

2024-03-22 3f3d27114d4d372d465a45a06a8e6966260ac1a0

议题添加字段

 src/main/java/org/springblade/modules/discuss/entity/TopicsEntity.java

@@ -120,5 +120,11 @@
    @ApiModelProperty(value = "文章id", example = "")
    @TableField("article_id")
    private Integer articleId;

    /** 最多可选数量 */
    @ApiModelProperty(value = "最多可选数量", example = "")
    @TableField("option_number")
    private Integer optionNumber;

}


 src/main/java/org/springblade/modules/discuss/mapper/TopicsMapper.xml

@@ -65,7 +65,9 @@
            public_discuss_id,
            parent_id,
            level,
            selected
            selected,
            article_id,
            option_number
        from
            jczz_topics
    </sql>
@@ -75,20 +77,7 @@

    <select id="selectTopicsList" parameterType="org.springblade.modules.discuss.dto.TopicsDTO" resultMap="TopicsDTOResult">
        SELECT
        jt.id,
        jt.discuss_content,
        jt.option_range,
        jt.sort,
        jt.option_content,
        jt.option_detail,
        jt.number,
        jt.create_time,
        jt.update_time,
        jt.delete_flag,
        jt.public_discuss_id,
        jt.parent_id,
        jt.article_id,
        jt.LEVEL,
        jt.*,
        ( SELECT jut.selected FROM jczz_user_topics jut WHERE jut.article_id = jt.article_id AND jut.user_id = #{userId}
        limit 1
        ) selected