modify

Helius

2020-12-23 f2b2542fcdef43d06999982fe7a85c91dd70c060

modify

 zq-erp/src/main/java/com/matrix/system/app/action/ApiOrderAction.java

@@ -44,7 +44,6 @@

        ShoppingGoodsCategory category = new ShoppingGoodsCategory();
        category.setShopId(user.getShopId());
        category.setName("家居产品");
        return AjaxResult.buildSuccessInstance(shoppingGoodsCategoryService.findChildNodesByName(category));
    }


 zq-erp/src/main/resources/mybatis/mapper/hive/ShoppingGoodsCategoryDao.xml

@@ -211,7 +211,10 @@

    <select id="selectChildNodesByName" resultMap="ShoppingGoodsCategoryMap">
        select * from shopping_goods_category a
        inner join shopping_goods_category b on a.parent_id=b.id and b.name=#{record.name} and b.parent_id=0
        inner join shopping_goods_category b on a.parent_id=b.id and b.parent_id=0
        <if test="record.name != null and record.name != ''">
            and b.name=#{record.name}
        </if>
        <where>
            <if test="record.shopId != null">
                and a.shop_id=#{record.shopId}