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);
|
|
|
}
|
