From 790d073559bfc15e9d1130fb9d51e9d673985cc7 Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期五, 13 六月 2025 13:45:47 +0800
Subject: [PATCH] add: 评论开发
---
src/main/java/com/mzl/flower/service/film/impl/FilmWorksServiceImpl.java | 4 ++++
src/main/resources/mapper/film/FilmWorksMapper.xml | 3 +++
src/main/java/com/mzl/flower/constant/Constants.java | 16 ++++++++++++++++
src/main/java/com/mzl/flower/dto/request/film/FilmWorksQueryDTO.java | 2 ++
4 files changed, 25 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/mzl/flower/constant/Constants.java b/src/main/java/com/mzl/flower/constant/Constants.java
index eabbd54..3f5e67b 100644
--- a/src/main/java/com/mzl/flower/constant/Constants.java
+++ b/src/main/java/com/mzl/flower/constant/Constants.java
@@ -755,5 +755,21 @@
}
+ public enum FILM_CATEGORY {
+ all("全部"), war("战争");
+
+ FILM_CATEGORY(String desc) {
+ this.desc = desc;
+ }
+
+ private String desc;
+
+ public String getDesc() {
+ return desc;
+ }
+ }
+
+
+
}
diff --git a/src/main/java/com/mzl/flower/dto/request/film/FilmWorksQueryDTO.java b/src/main/java/com/mzl/flower/dto/request/film/FilmWorksQueryDTO.java
index 97df9f6..d506906 100644
--- a/src/main/java/com/mzl/flower/dto/request/film/FilmWorksQueryDTO.java
+++ b/src/main/java/com/mzl/flower/dto/request/film/FilmWorksQueryDTO.java
@@ -47,6 +47,8 @@
private Integer id;
+ private String category;
+
}
diff --git a/src/main/java/com/mzl/flower/service/film/impl/FilmWorksServiceImpl.java b/src/main/java/com/mzl/flower/service/film/impl/FilmWorksServiceImpl.java
index 7c7b4e4..6abea29 100644
--- a/src/main/java/com/mzl/flower/service/film/impl/FilmWorksServiceImpl.java
+++ b/src/main/java/com/mzl/flower/service/film/impl/FilmWorksServiceImpl.java
@@ -87,6 +87,10 @@
if(StringUtils.isNotBlank(dto.getCreateDateEndStr())){
dto.setCreateDateEnd(DateUtils.dateToLocalDateTime(dto.getCreateDateEndStr(),false));
}
+ if (!StringUtils.isEmpty(dto.getCategory()) && Constants.FILM_CATEGORY.all.getDesc().equals(dto.getCategory())) {
+ //当时全部的时时候值设置为空，表示查询全部
+ dto.setCategory(null);
+ }
//todo 这里的用户ID可能为空，用户存在不登录的情况下访问，传null
try {
diff --git a/src/main/resources/mapper/film/FilmWorksMapper.xml b/src/main/resources/mapper/film/FilmWorksMapper.xml
index 3c4b493..fdcdac5 100644
--- a/src/main/resources/mapper/film/FilmWorksMapper.xml
+++ b/src/main/resources/mapper/film/FilmWorksMapper.xml
@@ -72,6 +72,9 @@
<if test="dto.classify != null and dto.classify != ''">
AND t.classify = #{dto.classify}
</if>
+ <if test="dto.category != null and dto.category != ''">
+ AND t.keywords LIKE CONCAT('%', #{dto.category}, '%')
+ </if>
<if test="dto.createDateBegin != null">
<![CDATA[
AND t.create_time >= #{dto.createDateBegin}
--
Gitblit v1.9.3