後台-商品屬性

@TableField(exist = false)
@JsonInclude(JsonInclude.Include.NON_EMPTY)
private List<CategoryEntity> children;

@RequestMapping("/info/{attrGroupId}")
public R info(@PathVariable("attrGroupId") Long attrGroupId) {
    AttrGroupEntity attrGroup = attrGroupService.getById(attrGroupId);
    Long catelogId = attrGroup.getCatelogId();
    // 找出商品屬性所在的路徑(電器-大家電-電視)
    Long[] path = categoryService.findCatalogPath(catelogId);
    attrGroup.setCatalogPath(path);

    return R.ok().put("attrGroup", attrGroup);
}

 /**
     * 找出商品屬性所在的路徑(電器-大家電-電視)
     *
     * @param catelogId
     * @return
     */
    @Override
    public Long[] findCatalogPath(Long catelogId) {
        List<Long> paths = new ArrayList<>();
        List<Long> parentPath = findParentPath(catelogId, paths);
        // 找的是從子出發，所以還要逆轉
        Collections.reverse(parentPath);
        return parentPath.toArray(new Long[parentPath.size()]);
    }

    /**
     * 找出所有父path
     *
     * @param catelogId
     * @param paths
     * @return
     */
    private List<Long> findParentPath(Long catelogId, List<Long> paths) {
        // 先放進當前的
        paths.add(catelogId);
        CategoryEntity byId = this.getById(catelogId);
        if (byId.getParentCid() != 0) {
            // 遞歸搜
            findParentPath(byId.getParentCid(), paths);
        }
        return paths;
    }

public PageUtils queryPage(Map<String, Object> params) {
    // 模糊查詢
    String key = (String) params.get("key");
    QueryWrapper<BrandEntity> qw = new QueryWrapper<>();
    if (!StringUtils.isEmpty(key)) {
        qw.and((obj) -> {
            obj.eq("brand_id", key).or().like("name", key);
        });
    }
    IPage<BrandEntity> page = this.page(
            new Query<BrandEntity>().getPage(params), qw);

    return new PageUtils(page);
}

@Configuration
@EnableTransactionManagement
@MapperScan(basePackages = "yozi.mall.**.dao")
public class MyBatisPlusConfig {

    /**
     * 插件集合
     */
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        // 插件
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        // 分頁插件
        PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor(DbType.MYSQL);
        // 添加分頁插件
        interceptor.addInnerInterceptor(paginationInnerInterceptor);
        return interceptor;
    }
}

/**
 * 從品牌獲取關聯品項列表
 */
@GetMapping("/catelog/list")
public R catelogList(@RequestParam("brandId") Long brandId) {
    List<CategoryBrandRelationEntity> data =
            categoryBrandRelationService.list(new QueryWrapper<CategoryBrandRelationEntity>().eq("brand_id",
                    brandId));

    return R.ok().put("data", data);
}

    /**
     * 冗餘的品牌名、品項名更新
     *
     * @param brand
     */
    @Override
    public void updateDetail(BrandEntity brand) {
        // 先更新自己
        this.updateById(brand);
        // 如果有更動品牌名
        if (!StringUtils.isEmpty(brand.getName())) {
            // 更新資料庫表中所有舊的品牌名
            categoryBrandRelationService.updateBrand(brand.getBrandId(), brand.getName());
        }
        // TODO 更新其他關聯

    }

public void updateBrand(Long brandId, String name) {
    CategoryBrandRelationEntity categoryBrandRelationEntity = new CategoryBrandRelationEntity();
    categoryBrandRelationEntity.setBrandId(brandId);
    categoryBrandRelationEntity.setBrandName(name);
    // 更新資料庫表中所有舊的品牌名
    this.update(categoryBrandRelationEntity, new UpdateWrapper<CategoryBrandRelationEntity>()
            .eq("brand_id", brandId));

}

@Override
public void updateCascade(CategoryEntity category) {
    this.updateById(category);
    categoryBrandRelationService.updateCategory(category.getCatId(),category.getName() );
}

<update id="updateCategory">
    UPDATE pms_category_brand_relation
    SET catelog_name= #{name}
    WHERE catelog_id = #{catId}
</update>

@Mapper
public interface CategoryBrandRelationDao extends BaseMapper<CategoryBrandRelationEntity> {
    void updateCategory(@Param("catId") Long catId, @Param("name") String name);
}

// MyBatisPlusConfig
@Configuration
@EnableTransactionManagement
@MapperScan(basePackages = "yozi.mall.**.dao")
public class MyBatisPlusConfig {

// CategoryServiceImpl
@Transactional
@Override
public void updateCascade(CategoryEntity category) {

// BrandServiceImpl
@Transactional
@Override
public void updateDetail(BrandEntity brand) {

@Transactional
@Override
public void saveAttr(AttrVo attr) {
    // 先保存基本資料
    AttrEntity attrEntity = new AttrEntity();
    BeanUtils.copyProperties(attr, attrEntity);
    this.save(attrEntity);
    // 保存關聯關係
    AttrAttrgroupRelationEntity relationEntity = new AttrAttrgroupRelationEntity();
    relationEntity.setAttrGroupId(attr.getAttrGroupId());
    relationEntity.setAttrId(attrEntity.getAttrId());
    relationDao.insert(relationEntity);
}

/**
 * 規格參數列表
 */
@GetMapping("/base/list/{catelogId}")
//@RequiresPermissions("product:attr:list")
public R baseAttrList(@RequestParam Map<String, Object> params,
                      @PathVariable("catelogId") Long catelogId) {
    PageUtils page = attrService.queryBasePageCatelogId(params, catelogId);

    return R.ok().put("page", page);
}

@Override
public PageUtils queryBasePageCatelogId(Map<String, Object> params, Long catelogId) {
    QueryWrapper<AttrEntity> qw = new QueryWrapper<>();
    // 指定三級分類
    if (catelogId != 0) {
        qw.eq("catelog_id", catelogId);
    }
    // 有查詢條件
    String key = (String) params.get("key");
    if (!StringUtils.isEmpty(key)) {
        qw.and((obj) -> {
            obj.eq("attr_id", key).or().like("attr_name", key);
        });
    }
    IPage<AttrEntity> page = this.page(
            new Query<AttrEntity>().getPage(params), qw);
    // 到這邊查完Attr基本訊息，把頁數總數那些啥的用PageUtils封裝起來
    PageUtils pageUtils = new PageUtils(page);

    // 但是內容物還沒完，將查到的紀錄一筆筆拿出來，找他們的catelogName與groupName
    List<AttrEntity> records = page.getRecords();

    // 流式，把一筆筆資料當水流，過完管道就處理完了
    List<AttrRespVo> respVos = records.stream().map(attrEntity -> {
        // 抓出裡面的attrEntity，拷貝到AttrRespVo上
        AttrRespVo attrRespVo = new AttrRespVo();
        BeanUtils.copyProperties(attrEntity, attrRespVo);
        // 去關聯表拿relationEntity，用來找到AttrGroupId，注意是selectOne
        AttrAttrgroupRelationEntity relationEntity =
                relationDao.selectOne(new QueryWrapper<AttrAttrgroupRelationEntity>().eq("attr_id",
                        attrEntity.getAttrId()));
        // 拿到groupName分組名: 主體、螢幕等
        if (relationEntity != null) {
            AttrGroupEntity attrGroupEntity = attrGroupDao.selectById(relationEntity.getAttrGroupId());
            attrRespVo.setGroupName(attrGroupEntity.getAttrGroupName());
        }
        // 拿到catelogName分類名(電器-大家電-"電視")
        CategoryEntity categoryEntity = categoryDao.selectById(attrEntity.getCatelogId());
        if (categoryEntity != null) {
            attrRespVo.setCatelogName(categoryEntity.getName());
        }
        return attrRespVo;
    }).collect(Collectors.toList()); // 接起處理完的流，裝到List<AttrRespVo> respVos

    // 把多賦好2個屬性的list塞回去
    pageUtils.setList(respVos);
    return pageUtils;
}

@RequestMapping("/info/{attrId}")
//@RequiresPermissions("product:attr:info")
public R info(@PathVariable("attrId") Long attrId) {
    // AttrEntity attr = attrService.getById(attrId);
    AttrRespVo respVo = attrService.getInfoById(attrId);
    return R.ok().put("attr", respVo);
}

/**
 * 屬性詳情(給修改回顯用)
 *
 * @param attrId
 * @return
 */
@Override
public AttrRespVo getInfoById(Long attrId) {
    AttrEntity attrEntity = this.getById(attrId);
    AttrRespVo attrRespVo = new AttrRespVo();
    BeanUtils.copyProperties(attrEntity, attrRespVo);

    // 去關聯表拿relationEntity，用來找到AttrGroupId，注意是selectOne
    AttrAttrgroupRelationEntity relationEntity =
            relationDao.selectOne(new QueryWrapper<AttrAttrgroupRelationEntity>().eq("attr_id",
                    attrEntity.getAttrId()));
    // 拿到groupName分組名: 主體、螢幕等
    if (relationEntity != null) {
        attrRespVo.setAttrGroupId(relationEntity.getAttrGroupId());
        AttrGroupEntity attrGroupEntity = attrGroupDao.selectById(relationEntity.getAttrGroupId());
        if (attrGroupEntity != null) {
            attrRespVo.setGroupName(attrGroupEntity.getAttrGroupName());
        }
    }
    // 完整分類路徑，之前寫過的
    Long catelogId = attrEntity.getCatelogId();
    Long[] catalogPath = categoryService.findCatalogPath(catelogId);
    attrRespVo.setCatelogPath(catalogPath);
    // 自己的三級分類名
    CategoryEntity categoryEntity = categoryDao.selectById(catelogId);
    if (categoryEntity != null) {
        attrRespVo.setCatelogName(categoryEntity.getName());
    }

    return attrRespVo;
}

@Transactional
@Override
public void updateAttr(AttrVo attr) {
    // 先更新基本資料
    AttrEntity attrEntity = new AttrEntity();
    BeanUtils.copyProperties(attr, attrEntity);
    this.updateById(attrEntity);

    // 保存關聯關係
    AttrAttrgroupRelationEntity relationEntity = new AttrAttrgroupRelationEntity();
    relationEntity.setAttrGroupId(attr.getAttrGroupId());
    relationEntity.setAttrId(attr.getAttrId());
    // 先判斷本來有無值
    Long count = relationDao.selectCount(new QueryWrapper<AttrAttrgroupRelationEntity>().eq(
            "attr_id",
            attr.getAttrId()));
    if (count > 0) {
        // 更新
        relationDao.update(relationEntity, new UpdateWrapper<AttrAttrgroupRelationEntity>().eq("attr_id",
                attr.getAttrId()));
    } else {
        // 新增
        relationDao.insert(relationEntity);
    }
}