banner模块

xuhy

2024-02-29 b3dd958fb089c7549373a7bf17a393b547742cc6

banner模块

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TBannerController.java

@@ -1,8 +1,17 @@
package com.ruoyi.web.controller.api;


import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.system.domain.TBanner;
import com.ruoyi.system.domain.TConfig;
import com.ruoyi.system.dto.TBannerDTO;
import com.ruoyi.system.query.TBannerQuery;
import com.ruoyi.system.service.TBannerService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

/**
 * <p>
@@ -12,9 +21,72 @@
 * @author xiaochen
 * @since 2024-02-29
 */
@Api(tags = "banner管理")
@RestController
@RequestMapping("/tBanner")
public class TBannerController {

    private final TBannerService bannerService;

    @Autowired
    public TBannerController(TBannerService bannerService) {
        this.bannerService = bannerService;
    }

    /**
     * 获取banner列表
     */
    @ApiOperation(value = "获取banner分页列表")
    @PostMapping(value = "/pageList")
    public AjaxResult<PageInfo<TBanner>> pageList(@RequestBody TBannerQuery query) {
        return AjaxResult.success(bannerService.pageList(query));
    }

    /**
     * 添加banner
     */
    @ApiOperation(value = "添加banner")
    @PostMapping(value = "/addBanner")
    public AjaxResult addBanner(@RequestBody TBannerDTO dto) {
        return AjaxResult.success(bannerService.save(dto));
    }

    /**
     * 修改banner
     */
    @ApiOperation(value = "修改banner")
    @PostMapping(value = "/updateBanner")
    public AjaxResult updateBanner(@RequestBody TBannerDTO dto) {
        return AjaxResult.success(bannerService.updateById(dto));
    }

    /**
     * 查看banner详情
     */
    @ApiOperation(value = "查看banner详情")
    @GetMapping(value = "/getBannerDetailById")
    public AjaxResult<TBanner> getBannerDetailById(@RequestParam Long id) {
        return AjaxResult.success(bannerService.getById(id));
    }

    /**
     * 删除banner
     */
    @ApiOperation(value = "删除banner")
    @GetMapping(value = "/deleteBannerById")
    public AjaxResult deleteBannerById(@RequestParam Long id) {
        return AjaxResult.success(bannerService.removeById(id));
    }

    /**
     * banner上下架
     */
    @ApiOperation(value = "banner上下架")
    @PostMapping(value = "/upAndDown")
    public AjaxResult upAndDown(@RequestParam Long id,
                                @RequestParam Integer status) {
        return AjaxResult.success(bannerService.upAndDown(id,status));
    }

}


 ruoyi-system/src/main/java/com/ruoyi/system/domain/TBanner.java

@@ -42,7 +42,11 @@
    private String bannerPicture;

    @ApiModelProperty(value = "排序")
    @TableField("bannerSort")
    private Integer bannerSort;
    @TableField("sortBy")
    private Integer sortBy;

    @ApiModelProperty(value = "上下架 1=上架 2=下架")
    @TableField("status")
    private Integer status;

}

 ruoyi-system/src/main/java/com/ruoyi/system/dto/TBannerDTO.java

New file
@@ -0,0 +1,15 @@
package com.ruoyi.system.dto;

import com.ruoyi.system.domain.TBanner;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.io.Serializable;
import java.util.List;

@Data
@ApiModel(value = "banner新增DTO")
public class TBannerDTO extends TBanner {

}

 ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBannerMapper.java

@@ -1,8 +1,13 @@
package com.ruoyi.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.domain.TBanner;
import com.ruoyi.system.query.TBannerQuery;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * <p>
@@ -15,4 +20,11 @@
@Mapper
public interface TBannerMapper extends BaseMapper<TBanner> {

    /**
     * 获取banner分页列表
     * @param query
     * @param pageInfo
     * @return
     */
    List<TBanner> pageList(@Param("query") TBannerQuery query, @Param("pageInfo") PageInfo<TBanner> pageInfo);
}

 ruoyi-system/src/main/java/com/ruoyi/system/query/TBannerQuery.java

New file
@@ -0,0 +1,18 @@
package com.ruoyi.system.query;

import com.ruoyi.common.core.domain.BasePage;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@Data
@ApiModel(value = "banner查询Query")
public class TBannerQuery extends BasePage {

    @ApiModelProperty(value = "banner名称")
    private String bannerName;

    @ApiModelProperty(value = "所在位置 1=首页 2=交易 3=演员")
    private Integer bannerType;

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/TBannerService.java

@@ -1,7 +1,9 @@
package com.ruoyi.system.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.domain.TBanner;
import com.ruoyi.system.query.TBannerQuery;

/**
 * <p>
@@ -13,4 +15,18 @@
 */
public interface TBannerService extends IService<TBanner> {

    /**
     * 获取banner分页列表
     * @param query TBannerQuery
     * @return PageInfo<TBanner>
     */
    PageInfo<TBanner> pageList(TBannerQuery query);

    /**
     * banner上下架
     * @param id id
     * @param status 上下架 1=上架 2=下架
     * @return int
     */
    int upAndDown(Long id, Integer status);
}

 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TBannerServiceImpl.java

@@ -1,10 +1,14 @@
package com.ruoyi.system.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.domain.TBanner;
import com.ruoyi.system.mapper.TBannerMapper;
import com.ruoyi.system.query.TBannerQuery;
import com.ruoyi.system.service.TBannerService;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * <p>
@@ -17,4 +21,18 @@
@Service
public class TBannerServiceImpl extends ServiceImpl<TBannerMapper, TBanner> implements TBannerService {

    @Override
    public PageInfo<TBanner> pageList(TBannerQuery query) {
        PageInfo<TBanner> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());
        List<TBanner> list = this.baseMapper.pageList(query,pageInfo);
        pageInfo.setRecords(list);
        return pageInfo;
    }

    @Override
    public int upAndDown(Long id, Integer status) {
        TBanner banner = this.baseMapper.selectById(id);
        banner.setStatus(status);
        return this.baseMapper.updateById(banner);
    }
}

 ruoyi-system/src/main/resources/mapper/system/TBannerMapper.xml

@@ -8,7 +8,8 @@
        <result column="bannerName" property="bannerName" />
        <result column="bannerType" property="bannerType" />
        <result column="bannerPicture" property="bannerPicture" />
        <result column="bannerSort" property="bannerSort" />
        <result column="sortBy" property="sortBy" />
        <result column="status" property="status" />
        <result column="createTime" property="createTime" />
        <result column="updateTime" property="updateTime" />
        <result column="createBy" property="createBy" />
@@ -18,7 +19,21 @@

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        id, bannerName, bannerType, bannerPicture, bannerSort, createTime, updateTime, createBy, updateBy, isDelete
        id, bannerName, bannerType, bannerPicture, sortBy,status, createTime, updateTime, createBy, updateBy, isDelete
    </sql>
    <select id="pageList" resultType="com.ruoyi.system.domain.TBanner">
        select id, bannerName, bannerType, bannerPicture, sortBy,status, createTime, updateTime, createBy, updateBy, isDelete
        from t_banner
        <where>
            <if test="query.bannerName != null and query.bannerName != ''">
                AND bannerName LIKE concat('%',#{query.bannerName},'%')
            </if>
            <if test="query.bannerType != null">
                AND bannerType = #{query.bannerName}
            </if>
            AND isDelete = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()}
        </where>
        ORDER BY createTime DESC
    </select>

</mapper>