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