From 30d8e227e8d823b6c38c3b9c90ac2df03b63befe Mon Sep 17 00:00:00 2001 From: admin <weikou2014> Date: 星期二, 25 二月 2025 16:41:22 +0800 Subject: [PATCH] 淘宝转链接口更新 --- fanli/src/main/java/com/yeshi/fanli/dao/taobao/TLJBuyGoodsDao.java | 159 ++++++++++++++++++++++++++++++---------------------- 1 files changed, 91 insertions(+), 68 deletions(-) diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/taobao/TLJBuyGoodsDao.java b/fanli/src/main/java/com/yeshi/fanli/dao/taobao/TLJBuyGoodsDao.java index 5bb02f2..38898cc 100644 --- a/fanli/src/main/java/com/yeshi/fanli/dao/taobao/TLJBuyGoodsDao.java +++ b/fanli/src/main/java/com/yeshi/fanli/dao/taobao/TLJBuyGoodsDao.java @@ -1,68 +1,91 @@ -package com.yeshi.fanli.dao.taobao; - -import java.util.List; - -import org.springframework.data.domain.Sort; -import org.springframework.data.mongodb.core.query.Criteria; -import org.springframework.data.mongodb.core.query.Query; -import org.springframework.stereotype.Repository; - -import com.yeshi.fanli.dao.MongodbBaseDao; -import com.yeshi.fanli.entity.taobao.TLJBuyGoods; - -@Repository -public class TLJBuyGoodsDao extends MongodbBaseDao<TLJBuyGoods> { - - - public List<TLJBuyGoods> listByDayOrderByUpdateTime(String day, int page, int pageSize) { - Query query = new Query(); - Criteria ca = Criteria.where("day").is(day); - query.addCriteria(ca); - query.limit(pageSize); - query.skip((page - 1) * pageSize).with(new Sort(Sort.Direction.DESC, "updateTime")); - return mongoTemplate.find(query, TLJBuyGoods.class); - } - - public void deleteByGoodsId(Long goodsId) { - Query query = new Query(); - Criteria ca = Criteria.where("goods.auctionId").is(goodsId); - query.addCriteria(ca); - - List<TLJBuyGoods> list = mongoTemplate.find(query, TLJBuyGoods.class); - if (list == null || list.size() == 0) { - return; - } - - for (TLJBuyGoods TLJBuyGoods : list) { - mongoTemplate.remove(TLJBuyGoods); - } - } - - public List<TLJBuyGoods> listByAuctionId(Long auctionid) { - Query query = new Query(); - Criteria ca = Criteria.where("goods.auctionId").is(auctionid); - query.addCriteria(ca); - return mongoTemplate.find(query, TLJBuyGoods.class); - } - - /** - * 鍑忕孩鍖呬釜鏁� - * - * @param id - */ - public void subHongBaoCount(String id, int count) { - Query query = new Query(); - query.addCriteria(Criteria.where("id").is(id).andOperator(Criteria.where("leftHongBaoCount").gt(count - 1))); - org.springframework.data.mongodb.core.query.Update update = new org.springframework.data.mongodb.core.query.Update(); - update = update.inc("leftHongBaoCount", 0 - count); - mongoTemplate.updateFirst(query, update, TLJBuyGoods.class); - } - - public TLJBuyGoods selectByAuctionIdAndDay(Long auctionId, String day) { - Query query = new Query(); - Criteria ca = Criteria.where("goods.auctionId").is(auctionId).and("day").is(day); - query.addCriteria(ca); - return mongoTemplate.findOne(query, TLJBuyGoods.class); - } - -} +package com.yeshi.fanli.dao.taobao; + +import java.util.List; + +import com.yeshi.fanli.util.taobao.TaoBaoUtil; +import org.springframework.data.domain.Sort; +import org.springframework.data.mongodb.core.query.Criteria; +import org.springframework.data.mongodb.core.query.Query; +import org.springframework.stereotype.Repository; + +import com.yeshi.common.MongodbBaseDao; +import com.yeshi.fanli.entity.taobao.TLJBuyGoods; + +@Repository +public class TLJBuyGoodsDao extends MongodbBaseDao<TLJBuyGoods> { + + public List<TLJBuyGoods> listByDayOrderByUpdateTime(String appKey, String day, int page, int pageSize) { + Query query = new Query(); + Criteria ca = Criteria.where("day").is(day); + if (appKey != null) + ca = ca.and("appKey").is(appKey); + query.addCriteria(ca); + query.limit(pageSize); + query.skip((page - 1) * pageSize).with(new Sort(Sort.Direction.DESC, "updateTime")); + return mongoTemplate.find(query, TLJBuyGoods.class); + } + + public long countByDayAndAppKey(String appKey, String day) { + Query query = new Query(); + Criteria ca = Criteria.where("day").is(day); + if (appKey != null) + ca = ca.and("appKey").is(appKey); + query.addCriteria(ca); + return mongoTemplate.count(query, TLJBuyGoods.class); + } + + public void deleteByGoodsId(String goodsId) { + Query query = new Query(); + Criteria ca = TaoBaoUtil.getAuctionIdEqualCriteria("goods.auctionId",goodsId); + query.addCriteria(ca); + + List<TLJBuyGoods> list = mongoTemplate.find(query, TLJBuyGoods.class); + if (list == null || list.size() == 0) { + return; + } + + for (TLJBuyGoods TLJBuyGoods : list) { + mongoTemplate.remove(TLJBuyGoods); + } + } + + public List<TLJBuyGoods> listByAuctionId(String auctionid) { + Query query = new Query(); + Criteria ca =TaoBaoUtil.getAuctionIdEqualCriteria("goods.auctionId",auctionid); + query.addCriteria(ca); + return mongoTemplate.find(query, TLJBuyGoods.class); + } + + /** + * 鏍规嵁鍟嗗搧ID鍒犻櫎 + * + * @param auctionId + */ + public void deleteByAuctionId(String auctionId) { + Query query = new Query(); + Criteria ca = TaoBaoUtil.getAuctionIdEqualCriteria("goods.auctionId",auctionId) ; + query.addCriteria(ca); + mongoTemplate.findAndRemove(query, TLJBuyGoods.class); + } + + /** + * 鍑忕孩鍖呬釜鏁� + * + * @param id + */ + public void subHongBaoCount(String id, int count) { + Query query = new Query(); + query.addCriteria(Criteria.where("id").is(id).andOperator(Criteria.where("leftHongBaoCount").gt(count - 1))); + org.springframework.data.mongodb.core.query.Update update = new org.springframework.data.mongodb.core.query.Update(); + update = update.inc("leftHongBaoCount", 0 - count); + mongoTemplate.updateFirst(query, update, TLJBuyGoods.class); + } + + public TLJBuyGoods selectByAuctionIdAndDay(String auctionId, String day) { + Query query = new Query(); + Criteria ca = TaoBaoUtil.getAuctionIdEqualCriteria("goods.auctionId",auctionId).and("day").is(day); + query.addCriteria(ca); + return mongoTemplate.findOne(query, TLJBuyGoods.class); + } + +} -- Gitblit v1.8.0