花城 后台分页查询微讲堂新增社区id字段查询

lidongdong

2024-11-07 a051ef0e881cbf33defce258ed21fa5dd3e88220

花城 后台分页查询微讲堂新增社区id字段查询

 springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/ComFmsApi.java

@@ -508,8 +508,13 @@

    @ApiOperation(value = "后台分页查询微讲堂", response = ComFmsClassroomVO.class)
    @PostMapping("/classroom/page")
    public R pageFmsClassroom(@RequestBody @Valid PageFmsClassroomAdminDTO adminDTO) {
    public R pageFmsClassroom(@RequestBody @Valid PageFmsClassroomAdminDTO adminDTO)
    {
        adminDTO.setCommunityId(this.getCommunityId());
        if(adminDTO.getCommunityId()!=null && adminDTO.getCommunityId()!=0)
        {
            adminDTO.setCommunityId(adminDTO.getCommunityId());
        }
        return communityService.pageFmsClassroomAdmin(adminDTO);
    }


 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComFmsClassroomMapper.xml

@@ -38,13 +38,13 @@
        SELECT id, title, scholars, cover, view_num, created_at
        FROM com_fms_classroom
        WHERE community_id = #{adminDTO.communityId}
        <if test="adminDTO.keyword != null and adminDTO.keyword != &quot;&quot;">
        <if test='adminDTO.keyword != null and adminDTO.keyword != "" '>
            AND title LIKE CONCAT('%',#{adminDTO.keyword},'%')
        </if>
        <if test="adminDTO.createdAtBegin != null">
        <if test='adminDTO.createdAtBegin != null and adminDTO.createdAtBegin != "" '>
            AND created_at &gt;= #{adminDTO.createdAtBegin}
        </if>
        <if test="adminDTO.createdAtEnd != null">
        <if test='adminDTO.createdAtEnd != null and adminDTO.createdAtEnd != "" '>
            AND created_at &lt;= #{adminDTO.createdAtEnd}
        </if>
        ORDER BY created_at DESC