From 25f83d7e36573da46bade5f54315797aa9c9e6cb Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期一, 26 五月 2025 14:34:51 +0800
Subject: [PATCH] add:增加影视作品分类
---
src/main/resources/mapper/film/FilmCategoryMapper.xml | 70 +++++++++++++++++++++++++++++++++++
src/main/java/com/mzl/flower/dto/response/film/FilmCategoryDTO.java | 40 ++++++++++++++++++++
2 files changed, 110 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/mzl/flower/dto/response/film/FilmCategoryDTO.java b/src/main/java/com/mzl/flower/dto/response/film/FilmCategoryDTO.java
new file mode 100644
index 0000000..5fdaafa
--- /dev/null
+++ b/src/main/java/com/mzl/flower/dto/response/film/FilmCategoryDTO.java
@@ -0,0 +1,40 @@
+package com.mzl.flower.dto.response.film;
+
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+@Data
+public class FilmCategoryDTO {
+ @ApiModelProperty(value = "分类ID")
+ private Long id;
+
+ @ApiModelProperty(value = "分类名称")
+ private String name;
+
+ @ApiModelProperty(value = "父分类ID")
+ private Long parentId;
+
+ @ApiModelProperty(value = "父分类名称")
+ private String parentName;
+
+ @ApiModelProperty(value = "分类类型")
+ private String type;
+
+ @ApiModelProperty(value = "分类编码")
+ private String code;
+
+ @ApiModelProperty(value = "排序")
+ private Integer sortBy;
+
+ @ApiModelProperty(value = "分类图标")
+ private String imageUrl;
+
+ @ApiModelProperty(value = "是否显示")
+ private Boolean shown;
+
+ @ApiModelProperty(value = "级别限制")
+ private String levelLimit;
+
+ @ApiModelProperty(value = "子分类数量")
+ private Integer childrenCount;
+}
\ No newline at end of file
diff --git a/src/main/resources/mapper/film/FilmCategoryMapper.xml b/src/main/resources/mapper/film/FilmCategoryMapper.xml
new file mode 100644
index 0000000..94b190c
--- /dev/null
+++ b/src/main/resources/mapper/film/FilmCategoryMapper.xml
@@ -0,0 +1,70 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.mzl.flower.mapper.film.FilmCategoryMapper">
+
+ <resultMap id="BaseResultMap" type="com.mzl.flower.entity.film.FilmCategory">
+ <id column="id" property="id"/>
+ <result column="name" property="name"/>
+ <result column="parent_id" property="parentId"/>
+ <result column="parent_name" property="parentName"/>
+ <result column="image_url" property="imageUrl"/>
+ <result column="sort_by" property="sortBy"/>
+ <result column="shown" property="shown"/>
+ <result column="level_limit" property="levelLimit"/>
+ <result column="create_by" property="createdBy"/>
+ <result column="create_time" property="createdTime"/>
+ <result column="update_by" property="updatedBy"/>
+ <result column="update_time" property="updatedTime"/>
+ <result column="deleted" property="deleted"/>
+ </resultMap>
+
+ <sql id="Base_Column_List">
+ c.id, c.name, c.parent_id, c.parent_name, c.image_url, c.sort_by, c.shown, c.level_limit,
+ c.create_by, c.create_time, c.update_by, c.update_time, c.deleted
+ </sql>
+
+ <select id="selectCategoryList" resultType="com.mzl.flower.dto.response.film.FilmCategoryTreeDTO">
+ SELECT
+ <include refid="Base_Column_List"/>,
+ (SELECT COUNT(1) FROM t_film_category f WHERE f.parent_id = c.id AND f.deleted = 0) childrenCount
+ FROM t_film_category c
+ WHERE c.deleted = 0
+ <if test="name != null and name != ''">
+ AND (
+ c.name LIKE CONCAT('%', #{name}, '%')
+ OR EXISTS (
+ SELECT 1 FROM t_film_category sc
+ WHERE sc.parent_id = c.id
+ AND sc.name LIKE CONCAT('%', #{name}, '%')
+ AND sc.deleted = 0
+ )
+ )
+ </if>
+ <if test="parentId != null">
+ AND c.parent_id = #{parentId}
+ </if>
+ <if test="shown != null">
+ AND c.shown = #{shown}
+ </if>
+ ORDER BY c.sort_by ASC, c.create_time DESC
+ </select>
+
+ <select id="selectTreeList" resultType="com.mzl.flower.dto.response.film.FilmCategoryTreeDTO">
+ SELECT
+ <include refid="Base_Column_List"/>,
+ (SELECT COUNT(1) FROM t_film_category f WHERE f.parent_id = c.id AND f.deleted = 0) childrenCount
+ FROM t_film_category c
+ WHERE c.deleted = 0
+ <if test="name != null and name != ''">
+ AND c.name LIKE CONCAT('%', #{name}, '%')
+ </if>
+ <if test="parentId != null">
+ AND c.parent_id = #{parentId}
+ </if>
+ <if test="shown != null">
+ AND c.shown = #{shown}
+ </if>
+ ORDER BY c.sort_by ASC, c.create_time DESC
+ </select>
+
+</mapper>
\ No newline at end of file
--
Gitblit v1.9.3