From 91f6d758402918e7c3c951f57a93724dbef1fd91 Mon Sep 17 00:00:00 2001
From: KKSU <15274802129@163.com>
Date: Thu, 21 Dec 2023 11:08:19 +0800
Subject: [PATCH] 富文本框输入版本变化

---
 src/main/resources/mapper/modules/MallGoodsCategoryMapper.xml |   20 ++++++++------------
 1 files changed, 8 insertions(+), 12 deletions(-)

diff --git a/src/main/resources/mapper/modules/MallGoodsCategoryMapper.xml b/src/main/resources/mapper/modules/MallGoodsCategoryMapper.xml
index f551b23..42fce55 100644
--- a/src/main/resources/mapper/modules/MallGoodsCategoryMapper.xml
+++ b/src/main/resources/mapper/modules/MallGoodsCategoryMapper.xml
@@ -99,18 +99,14 @@
 
 
     <select id="selectAllCategoryListByIsApp" resultMap="mallGoodsCategoryVoMap">
-        select
+        SELECT
             a.id,
-            a.name,
-            a.image,
-            a.parent_id,
-            b.id child_id,
-            b.name child_name,
-            b.parent_id child_parent_id
-        from mall_goods_category a
-                 left join mall_goods_category b on a.id=b.parent_id
-        where a.parent_id = 0
-        and a.is_app = #{isApp}
-        order by a.index_num asc
+            a. NAME,
+            a.image
+        FROM
+            mall_goods_category a
+        WHERE a.is_app = #{isApp}
+        ORDER BY
+            a.index_num ASC
     </select>
 </mapper>
\ No newline at end of file

--
Gitblit v1.9.1