From d485687a5c6d3b3d91db56354d77d81b02197712 Mon Sep 17 00:00:00 2001
From: fuliqi <fuliqi@qq.com>
Date: 星期二, 18 六月 2024 16:13:02 +0800
Subject: [PATCH] 教学资源

---
 src/main/resources/mapper/EducationResourceMapper.xml                         |   22 +++++++++++-----------
 src/main/java/com/ycl/jxkg/domain/entity/EducationResource.java               |    4 ++--
 src/main/java/com/ycl/jxkg/domain/vo/admin/education/EducationResourceVO.java |    6 +++---
 3 files changed, 16 insertions(+), 16 deletions(-)

diff --git a/src/main/java/com/ycl/jxkg/domain/entity/EducationResource.java b/src/main/java/com/ycl/jxkg/domain/entity/EducationResource.java
index ea6b7dc..153170b 100644
--- a/src/main/java/com/ycl/jxkg/domain/entity/EducationResource.java
+++ b/src/main/java/com/ycl/jxkg/domain/entity/EducationResource.java
@@ -20,8 +20,8 @@
     /** 鏂囦欢鍦板潃 */
     private String contentUrl;
 
-    /** 鎵�灞炲垎绫� */
-    private Integer belongType;
+    /** 鎵�灞炲绉� */
+    private Integer subjectId;
 
     /** 涓婚绠�浠� */
     private String introduction;
diff --git a/src/main/java/com/ycl/jxkg/domain/vo/admin/education/EducationResourceVO.java b/src/main/java/com/ycl/jxkg/domain/vo/admin/education/EducationResourceVO.java
index 6f6333e..18f4f6e 100644
--- a/src/main/java/com/ycl/jxkg/domain/vo/admin/education/EducationResourceVO.java
+++ b/src/main/java/com/ycl/jxkg/domain/vo/admin/education/EducationResourceVO.java
@@ -30,9 +30,9 @@
     private UploadFile contentUrl;
     private String contentUrlString;
 
-    /** 鎵�灞炲垎绫� */
-    @NotNull(message = "璇烽�夋嫨鍒嗙被")
-    private Integer belongType;
+    /** 鎵�灞炲绉� */
+    @NotNull(message = "璇烽�夋嫨瀛︾")
+    private Integer subjectId;
 
     private String typeName;
 
diff --git a/src/main/resources/mapper/EducationResourceMapper.xml b/src/main/resources/mapper/EducationResourceMapper.xml
index 86c3488..bd383cc 100644
--- a/src/main/resources/mapper/EducationResourceMapper.xml
+++ b/src/main/resources/mapper/EducationResourceMapper.xml
@@ -9,7 +9,7 @@
             ter.id,
             ter.content_type,
             ter.content_url as contentUrlString,
-            ter.belong_type,
+            ter.subject_id,
             ter.introduction,
             ter.create_time,
             ter.update_time,
@@ -17,14 +17,14 @@
             ts.name as typeName
         FROM
         t_education_resource ter
-                INNER JOIN t_subject ts ON ts.id = ter.belong_type
+                INNER JOIN t_subject ts ON ts.id = ter.subject_id
         <where>
             AND ter.deleted = 0
             <if test="query.introduction != null and query.introduction != ''">
                 AND ter.introduction like concat('%', #{query.subject}, '%')
             </if>
-            <if test="query.belongType != null">
-                AND ts.id = #{query.belongType}
+            <if test="query.subjectId != null">
+                AND ts.id = #{query.subjectId}
             </if>
         </where>
         ORDER BY
@@ -36,21 +36,21 @@
             ter.id,
             ter.content_type,
             ter.content_url as contentUrlString,
-            ter.belong_type,
+            ter.subject_id,
             ter.introduction,
             ter.create_time,
             ter.update_time,
             ter.attachment as attachmentString
         FROM
             t_education_resource ter
-                INNER JOIN t_subject ts ON ts.id = tos.belong_type
+                INNER JOIN t_subject ts ON ts.id = ter.subject_id
         <where>
             AND ter.deleted = 0
             <if test="query.introduction != null and query.introduction != ''">
                 AND ter.introduction like concat('%', #{query.subject}, '%')
             </if>
-            <if test="query.belongType != null">
-                AND ts.id = #{query.belongType}
+            <if test="query.subjectId != null">
+                AND ts.id = #{query.subjectId}
             </if>
         </where>
         ORDER BY
@@ -58,9 +58,9 @@
     </select>
 
     <insert id="add" keyColumn="id" useGeneratedKeys="true">
-        INSERT INTO t_education_resource(content_type, content_url, belong_type, introduction, create_time, update_time,
+        INSERT INTO t_education_resource(content_type, content_url, subject_id, introduction, create_time, update_time,
                                    attachment)
-            value (#{form.contentType}, #{form.contentUrl}, #{form.belongType}, #{form.introduction}, #{form.createTime}, #{form.updateTime}, #{form.attachment})
+            value (#{form.contentType}, #{form.contentUrl}, #{form.subjectId}, #{form.introduction}, #{form.createTime}, #{form.updateTime}, #{form.attachment})
     </insert>
 
     <update id="update">
@@ -69,7 +69,7 @@
         <set>
             <if test="form.contentType != null and form.contentType != ''">content_type = #{form.contentType},</if>
             <if test="form.contentUrl != null and form.contentUrl != ''">content_url = #{form.contentUrl},</if>
-            <if test="form.belongType != null">belong_type = #{form.belongType},</if>
+            <if test="form.subjectId != null">subject_id = #{form.subjectId},</if>
             <if test="form.introduction != null and form.introduction != ''">introduction = #{form.introduction},</if>
             <if test="form.updateTime != null">update_time = #{form.updateTime},</if>
             attachment = #{form.attachment}

--
Gitblit v1.8.0