src/main/resources/mapper/modules/MallGoodsCategoryMapper.xml | ●●●●● patch | view | raw | blame | history |
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>