From b3dd958fb089c7549373a7bf17a393b547742cc6 Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期四, 29 二月 2024 17:22:35 +0800
Subject: [PATCH] banner模块
---
ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TBannerController.java | 76 ++++++++++++++++++
ruoyi-system/src/main/java/com/ruoyi/system/dto/TBannerDTO.java | 15 +++
ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBannerMapper.java | 12 +++
ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TBannerServiceImpl.java | 18 ++++
ruoyi-system/src/main/java/com/ruoyi/system/domain/TBanner.java | 8 +
ruoyi-system/src/main/java/com/ruoyi/system/query/TBannerQuery.java | 18 ++++
ruoyi-system/src/main/resources/mapper/system/TBannerMapper.xml | 19 ++++
ruoyi-system/src/main/java/com/ruoyi/system/service/TBannerService.java | 16 ++++
8 files changed, 176 insertions(+), 6 deletions(-)
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TBannerController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TBannerController.java
index c3b744f..aac770f 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TBannerController.java
+++ b/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));
+ }
+
}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/domain/TBanner.java b/ruoyi-system/src/main/java/com/ruoyi/system/domain/TBanner.java
index 54d6652..627eba0 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/domain/TBanner.java
+++ b/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;
}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/dto/TBannerDTO.java b/ruoyi-system/src/main/java/com/ruoyi/system/dto/TBannerDTO.java
new file mode 100644
index 0000000..2691b51
--- /dev/null
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/dto/TBannerDTO.java
@@ -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 {
+
+}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBannerMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBannerMapper.java
index f58d141..468cacc 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBannerMapper.java
+++ b/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);
}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/query/TBannerQuery.java b/ruoyi-system/src/main/java/com/ruoyi/system/query/TBannerQuery.java
new file mode 100644
index 0000000..41b00d2
--- /dev/null
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/query/TBannerQuery.java
@@ -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;
+
+}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/TBannerService.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/TBannerService.java
index a054e76..60a8f2e 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/TBannerService.java
+++ b/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);
}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TBannerServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TBannerServiceImpl.java
index cee6587..96c9ba1 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TBannerServiceImpl.java
+++ b/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);
+ }
}
diff --git a/ruoyi-system/src/main/resources/mapper/system/TBannerMapper.xml b/ruoyi-system/src/main/resources/mapper/system/TBannerMapper.xml
index c196e04..7ed10b7 100644
--- a/ruoyi-system/src/main/resources/mapper/system/TBannerMapper.xml
+++ b/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>
--
Gitblit v1.7.1