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.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);
|
|
void updateCarriageRuleId(@Param("id")Long id);
|
|
void updateCarriageAmount(@Param("id")Long id);
|
}
|
