后台运费模板功能

xiaoyong931011

2023-02-09 ae99a4a7654a6a3d8fd8343c22c415930f0a18cb

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

@@ -1,15 +1,61 @@
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.entity.MallGoodsCategory;
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);

    List<MallGoodsListVo> selectMallGoodsListQueryNoPage(@Param("record")MallGoodsQueryDto queryDto);

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

    List<MallGoods> selectMallGoodsListQueryByRuleIdAndIsSale(@Param("id")Long id, @Param("isSale")Integer ishotStateYes);
}