| | |
| | | package com.yeshi.fanli.dao.mybatis.lable; |
| | | |
| | | import java.util.List; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import com.yeshi.fanli.dao.BaseMapper; |
| | | import com.yeshi.fanli.entity.bus.lable.LabelGoods; |
| | | |
| | | |
| | | |
| | | public interface LabelGoodsMapper extends BaseMapper<LabelGoods>{ |
| | | |
| | | /** |
| | | * 批量插入 |
| | | * @param list |
| | | * @return |
| | | */ |
| | | int insertBatch(List<LabelGoods> list); |
| | | |
| | | /** |
| | | * 判断是否已贴过标签 |
| | | * @param title |
| | | * @param startTime |
| | | * @return |
| | | */ |
| | | Long getRelationNum( @Param("labelId") Long labelId); |
| | | |
| | | /** |
| | | * 批量删除 |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | int deleteBatchByPrimaryKey(long[] ids); |
| | | |
| | | |
| | | /** |
| | | * 删除商品多个标签 |
| | | */ |
| | | void deleteByAuctionIdAndLabIDs(@Param("auctionId")Long auctionId, @Param("list") List<Long> list); |
| | | |
| | | |
| | | |
| | | /** |
| | | * 批量删除 |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | int deleteBatchByPK(List<Long> list); |
| | | |
| | | |
| | | /** |
| | | * 判断是否已贴过标签 |
| | | * @param title |
| | | * @param startTime |
| | | * @return |
| | | */ |
| | | Long isExistence(@Param("goodsId") Long goodsId, @Param("labelId") Long labelId); |
| | | |
| | | /** |
| | | * 查询商品当前是否包含 9k9类目 |
| | | * @param title |
| | | * @param list |
| | | * @return |
| | | */ |
| | | List<LabelGoods> listQuery9k9Class(@Param("gid") Long title, @Param("list") List<Long> list); |
| | | |
| | | |
| | | |
| | | /** |
| | | * 查询商品对应标签 |
| | | * @param goodsId |
| | | * @return |
| | | */ |
| | | int getCountByGoodsId(@Param("goodsId") Long goodsId); |
| | | |
| | | |
| | | /** |
| | | * 查询商品对应标签 -- 分页 |
| | | * @param record |
| | | * @return |
| | | */ |
| | | List<LabelGoods> queryByGoodsId(@Param("start") int start, @Param("count") int count, @Param("goodsId") Long record); |
| | | |
| | | int getCountQueryByGoodsId(@Param("goodsId") Long record); |
| | | |
| | | |
| | | /** |
| | | * 根据商品id删除标签 |
| | | * @param goodsId |
| | | * @return |
| | | */ |
| | | int deleteByGoodsId(Long goodsId); |
| | | |
| | | |
| | | int deleteBatchByGoodsId(List<Long> list); |
| | | |
| | | |
| | | /** |
| | | * 根据标签id批量删除 |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | int deleteByLabId(Long labId); |
| | | |
| | | /** |
| | | * 批量删除 |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | |
| | | int deleteByGoodsIdAndLabId(Long goodsId, Long labId); |
| | | |
| | | |
| | | /** |
| | | * 查询所有数据+条件 |
| | | * @param start |
| | | * @param count |
| | | * @param goodsId |
| | | * @param labIds |
| | | * @return |
| | | */ |
| | | List<LabelGoods> listQuery(@Param("start") long start, @Param("count") int count, |
| | | @Param("labIds") List<Long> labIds); |
| | | |
| | | long countQuery(@Param("labIds") List<Long> labIds); |
| | | |
| | | |
| | | package com.yeshi.fanli.dao.mybatis.lable;
|
| | |
|
| | | import java.util.List;
|
| | |
|
| | | import org.apache.ibatis.annotations.Param;
|
| | |
|
| | | import com.yeshi.fanli.dao.BaseMapper;
|
| | | import com.yeshi.fanli.entity.bus.lable.LabelGoods;
|
| | |
|
| | | |
| | |
|
| | | public interface LabelGoodsMapper extends BaseMapper<LabelGoods>{
|
| | |
|
| | | /**
|
| | | * 批量插入
|
| | | * @param list
|
| | | * @return
|
| | | */
|
| | | int insertBatch(List<LabelGoods> list);
|
| | | |
| | | /**
|
| | | * 判断是否已贴过标签
|
| | | * @param title
|
| | | * @param startTime
|
| | | * @return
|
| | | */
|
| | | Long getRelationNum( @Param("labelId") Long labelId);
|
| | | |
| | | /**
|
| | | * 批量删除
|
| | | * @param ids
|
| | | * @return
|
| | | */
|
| | | int deleteBatchByPrimaryKey(long[] ids);
|
| | | |
| | | |
| | | /**
|
| | | * 删除商品多个标签
|
| | | */
|
| | | void deleteByAuctionIdAndLabIDs(@Param("auctionId")Long auctionId, @Param("list") List<Long> list);
|
| | | |
| | | |
| | | |
| | | /**
|
| | | * 批量删除
|
| | | * @param ids
|
| | | * @return
|
| | | */
|
| | | int deleteBatchByPK(List<Long> list);
|
| | | |
| | | |
| | | /**
|
| | | * 判断是否已贴过标签
|
| | | * @param title
|
| | | * @param startTime
|
| | | * @return
|
| | | */
|
| | | Long isExistence(@Param("goodsId") Long goodsId, @Param("labelId") Long labelId);
|
| | | |
| | | /**
|
| | | * 查询商品当前是否包含 9k9类目
|
| | | * @param title
|
| | | * @param list
|
| | | * @return
|
| | | */
|
| | | List<LabelGoods> listQuery9k9Class(@Param("gid") Long title, @Param("list") List<Long> list);
|
| | | |
| | | |
| | | |
| | | /**
|
| | | * 查询商品对应标签
|
| | | * @param goodsId
|
| | | * @return
|
| | | */
|
| | | int getCountByGoodsId(@Param("goodsId") Long goodsId);
|
| | | |
| | | |
| | | /**
|
| | | * 查询商品对应标签 -- 分页
|
| | | * @param record
|
| | | * @return
|
| | | */
|
| | | List<LabelGoods> queryByGoodsId(@Param("start") int start, @Param("count") int count, @Param("goodsId") Long record);
|
| | | |
| | | int getCountQueryByGoodsId(@Param("goodsId") Long record);
|
| | | |
| | | |
| | | /**
|
| | | * 根据商品id删除标签
|
| | | * @param goodsId
|
| | | * @return
|
| | | */
|
| | | int deleteByGoodsId(Long goodsId);
|
| | | |
| | | |
| | | int deleteBatchByGoodsId(List<Long> list);
|
| | | |
| | | |
| | | /**
|
| | | * 根据标签id批量删除
|
| | | * @param ids
|
| | | * @return
|
| | | */
|
| | | int deleteByLabId(Long labId);
|
| | | |
| | | /**
|
| | | * 批量删除
|
| | | * @param ids
|
| | | * @return
|
| | | */
|
| | | |
| | | int deleteByGoodsIdAndLabId(Long goodsId, Long labId);
|
| | | |
| | | |
| | | /**
|
| | | * 查询所有数据+条件
|
| | | * @param start
|
| | | * @param count
|
| | | * @param goodsId
|
| | | * @param labIds
|
| | | * @return
|
| | | */
|
| | | List<LabelGoods> listQuery(@Param("start") long start, @Param("count") int count, |
| | | @Param("labIds") List<Long> labIds);
|
| | | |
| | | long countQuery(@Param("labIds") List<Long> labIds);
|
| | | |
| | | |
| | | } |