20220902

xiaoyong931011

2022-09-23 14bb69110fc779feb53c0f2fe4623a24467d4422

 src/main/java/cc/mrbird/febs/mall/mapper/MallGoodsMapper.java

@@ -1,23 +1,55 @@
package cc.mrbird.febs.mall.mapper;

import cc.mrbird.febs.mall.dto.MallGoodsQueryDto;
import cc.mrbird.febs.mall.entity.DataDictionaryCustom;
import cc.mrbird.febs.mall.entity.MallGoods;
import cc.mrbird.febs.mall.vo.AdminMallGoodsVo;
import cc.mrbird.febs.mall.vo.MallGoodsListVo;
import cc.mrbird.febs.mall.entity.MallGoodsComment;
import cc.mrbird.febs.mall.vo.*;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.Date;
import java.util.List;
import java.util.Map;

public interface MallGoodsMapper extends BaseMapper<MallGoods> {

    IPage<MallGoodsListVo> selectMallGoodsListQueryInPage(@Param("record") MallGoodsQueryDto queryDto, Page<MallGoodsListVo> page);

    MallGoods selectGoodsDetailById(@Param("id") Long id);

    IPage<AdminMallGoodsVo> selectMallGoodsInPage(Page<AdminMallGoodsVo> page, @Param("record")MallGoods mallGoods);

    Integer selectMallGoodsCountByGoodsName(@Param("goodsName")String goodsName);

    Integer selectMallGoodsCountByGoodsNameAndGoodId(@Param("goodsName")String goodsName,@Param("id")Long id);

    Integer selectMallGoodsCountByGoodsNo(@Param("goodsNo")String goodsNo);

    Integer selectMallGoodsCountByGoodsNoAndGoodId(@Param("goodsNo")String goodsNo,@Param("id")Long id);

    AdminMailGoodsDetailVo selectMallGoodsInfoById(@Param("id")long id);

    Map<String, BigDecimal> selectGoodsStockAndVolume(@Param("id") Long id);

    List<MallGoods> selectMallGoodsByCategaryId(@Param("categaryId")Long id);

    AdminMailGoodsUpdateVo getMallGoodsUpdateInfoById(@Param("id")long id);

    List<AdminMallGoodsTreeVo> getAllGoodsTree();

    List<MallGoods> selectOrderGoodsList(@Param("memberId") Long memberId, @Param("date") Date date);

    IPage<MallGoodsCommentVo> selectMallGoodsCommentListQueryInPage(Page<MallGoodsCommentVo> page,  @Param("record")MallGoodsComment mallGoodsComment);

    IPage<DataDictionaryCustom> getDeliveryHomeListInPage(Page<DataDictionaryCustom> page, @Param("record")AdminHomeDeliverySettingVo adminHomeDeliverySettingVo);

    MallGoodsCommentVo findMallGoodsCommentLevelByGoodsId(@Param("id")Long id);

    Integer upDateStockAndVolumeByGoodsId(@Param("id")Long id,@Param("cnt")Integer cnt);

    Integer updateStockAndVolumeByGoodsId(@Param("id")Long id,@Param("cnt")Integer cnt);
}