| | |
| | | package com.yeshi.fanli.dao.mybatis.goods; |
| | | |
| | | import java.util.List; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import com.yeshi.fanli.dao.BaseMapper; |
| | | import com.yeshi.fanli.entity.goods.CommonGoods; |
| | | |
| | | public interface CommonGoodsMapper extends BaseMapper<CommonGoods> { |
| | | |
| | | /** |
| | | * 根据商品ID查询 |
| | | * @param goodsId |
| | | * @param goodsType |
| | | * @return |
| | | */ |
| | | CommonGoods selectByGoodsIdAndGoodsType(@Param("goodsId") Long goodsId, @Param("goodsType") Integer goodsType); |
| | | |
| | | |
| | | /** |
| | | * 根据店铺id查询 最新5个 |
| | | * @param goodsId |
| | | * @return |
| | | */ |
| | | List<CommonGoods> listBySellerId(@Param("sellerId") Long sellerId, @Param("goodsType") Integer goodsType); |
| | | |
| | | /** |
| | | * 统计店铺商品有券数量 |
| | | * @param sellerId |
| | | * @return |
| | | */ |
| | | long countBySellerIdAndHasCoupon(@Param("sellerId") Long sellerId, @Param("goodsType") Integer goodsType); |
| | | |
| | | |
| | | /** |
| | | * 批量商品id查询商品信息 |
| | | * @param list |
| | | * @return |
| | | */ |
| | | List<CommonGoods> getByListGoodsId(@Param("list") List<Long> list, @Param("goodsType") Integer goodsType); |
| | | |
| | | |
| | | package com.yeshi.fanli.dao.mybatis.goods;
|
| | |
|
| | | import java.util.List;
|
| | |
|
| | | import org.apache.ibatis.annotations.Param;
|
| | |
|
| | | import com.yeshi.fanli.dao.BaseMapper;
|
| | | import com.yeshi.fanli.entity.goods.CommonGoods;
|
| | |
|
| | | public interface CommonGoodsMapper extends BaseMapper<CommonGoods> {
|
| | |
|
| | | /**
|
| | | * 根据商品ID查询
|
| | | * @param goodsId
|
| | | * @param goodsType
|
| | | * @return
|
| | | */
|
| | | CommonGoods selectByGoodsIdAndGoodsType(@Param("goodsId") Long goodsId, @Param("goodsType") Integer goodsType);
|
| | |
|
| | | |
| | | /**
|
| | | * 根据店铺id查询 最新5个
|
| | | * @param goodsId
|
| | | * @return
|
| | | */
|
| | | List<CommonGoods> listBySellerId(@Param("sellerId") Long sellerId, @Param("goodsType") Integer goodsType);
|
| | | |
| | | /**
|
| | | * 统计店铺商品有券数量
|
| | | * @param sellerId
|
| | | * @return
|
| | | */
|
| | | long countBySellerIdAndHasCoupon(@Param("sellerId") Long sellerId, @Param("goodsType") Integer goodsType);
|
| | | |
| | | |
| | | /**
|
| | | * 批量商品id查询商品信息
|
| | | * @param list
|
| | | * @return
|
| | | */
|
| | | List<CommonGoods> getByListGoodsId(@Param("list") List<Long> list, @Param("goodsType") Integer goodsType);
|
| | | |
| | | |
| | | } |