谷粒商城P78【平台属性】-＞【规格参数】修改属性（先查询属性详情，再修改）

最新推荐文章于 2024-11-03 11:01:20 发布

爱吃小香葱

最新推荐文章于 2024-11-03 11:01:20 发布

阅读量306

点赞数

分类专栏：谷粒商城踩坑之路！文章标签：接口文档数据更新属性信息数据库操作关联关系

本文链接：https://blog.csdn.net/huhuhutony/article/details/120240678

版权

谷粒商城踩坑之路！专栏收录该内容

47 篇文章 8 订阅

订阅专栏

接口文档：
在这里插入图片描述


   @Override
    public AttrRespVo getAttrInfo(Long attrId) {
        AttrRespVo attrRespVo = new AttrRespVo();
        AttrEntity attrEntity = this.getById(attrId);
        BeanUtils.copyProperties(attrEntity,attrRespVo);
//        attrRespVo.setAttrGroupId();

        AttrAttrgroupRelationEntity relationEntity = relationDao.selectOne(
                        new QueryWrapper<AttrAttrgroupRelationEntity>().eq("attr_id",attrId));
        if (relationEntity != null) {
            attrRespVo.setAttrGroupId(relationEntity.getAttrGroupId());
            AttrGroupEntity attrGroupEntity = attrGroupDao.selectById(relationEntity.getAttrGroupId());
            if (attrGroupEntity != null){
                attrRespVo.setGroupName(attrGroupEntity.getAttrGroupName());
            }
        }
//        attrRespVo.setCatelogPath();

        Long catelogId = attrEntity.getCatelogId();
        Long[] catelogPath = categoryService.findCatelogPath(catelogId);
        attrRespVo.setCatelogPath(catelogPath);
        CategoryEntity categoryEntity = categoryDao.selectById(catelogId);
        if (categoryEntity != null ){
            attrRespVo.setCatelogName(categoryEntity.getName());
        }

        return attrRespVo;
    }

}

测试：
在这里插入图片描述

在这里插入图片描述


    @Transactional
    @Override
    public void updateAttr(AttrVo attrVo) {
        AttrEntity attrEntity = new AttrEntity();
        BeanUtils.copyProperties(attrVo,attrEntity);
        this.updateById(attrEntity);

//        修改关联
        AttrAttrgroupRelationEntity relationEntity = new AttrAttrgroupRelationEntity();
        relationEntity.setAttrGroupId(attrVo.getAttrGroupId());
        relationEntity.setAttrId(attrVo.getAttrId());

        Integer count = relationDao.selectCount(
                new QueryWrapper<AttrAttrgroupRelationEntity>().eq("attr_id",attrVo.getAttrId()));


        if (count > 0){
            relationDao.update(relationEntity,
                    new UpdateWrapper<AttrAttrgroupRelationEntity>().eq("attr_id",attrVo.getAttrId()));

        }else {
            relationDao.insert(relationEntity);
        }