| | |
| | | |
| | | public interface MallGoodsCategoryMapper extends BaseMapper<MallGoodsCategory> { |
| | | |
| | | IPage<MallGoodsCategory> selectCategoryList(Page<MallGoodsCategory> page, @Param("record")MallGoodsCategory mallGoodsCategory); |
| | | IPage<MallGoodsCategory> selectCategoryListInPage(Page<MallGoodsCategory> page, @Param("record")MallGoodsCategory mallGoodsCategory); |
| | | |
| | | List<MallGoodsCategory> selectCategoryByName(@Param("name")String name); |
| | | |
| | |
| | | @Override |
| | | public IPage<MallGoodsCategory> getCategoryList(MallGoodsCategory mallGoodsCategory, QueryRequest request) { |
| | | Page<MallGoodsCategory> page = new Page<>(request.getPageNum(), request.getPageSize()); |
| | | IPage<MallGoodsCategory> mallGoodsCategorys = this.baseMapper.selectCategoryList(page, mallGoodsCategory); |
| | | IPage<MallGoodsCategory> mallGoodsCategorys = this.baseMapper.selectCategoryListInPage(page, mallGoodsCategory); |
| | | return mallGoodsCategorys; |
| | | } |
| | | |
| | |
| | | }else{ |
| | | goodsCategory.setParentIds(mallGoodsCategory.getParentId()+","); |
| | | } |
| | | }else{ |
| | | goodsCategory.setParentId(0L); |
| | | } |
| | | mallGoodsCategoryMapper.insert(goodsCategory); |
| | | return new FebsResponse().success(); |
| | |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="cc.mrbird.febs.mall.mapper.MallGoodsCategoryMapper"> |
| | | |
| | | <select id="selectCategoryList" resultType="cc.mrbird.febs.mall.entity.MallGoodsCategory"> |
| | | <select id="selectCategoryListInPage" resultType="cc.mrbird.febs.mall.entity.MallGoodsCategory"> |
| | | SELECT m.name,b.name parentName |
| | | FROM mall_goods_category m |
| | | left join mall_goods_category b on m.parent_id = b.id |