From 8b25dae4f4481a72a1adbb09a6628f2e001f45b1 Mon Sep 17 00:00:00 2001 From: yujian <yujian@163.com> Date: 星期三, 29 四月 2020 16:25:46 +0800 Subject: [PATCH] 动态自动删除过期 --- fanli/src/main/java/com/yeshi/fanli/dao/dynamic/GoodsEvaluateDao.java | 35 ++++++++++++++++++++++++++++++++--- 1 files changed, 32 insertions(+), 3 deletions(-) diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/dynamic/GoodsEvaluateDao.java b/fanli/src/main/java/com/yeshi/fanli/dao/dynamic/GoodsEvaluateDao.java index d6cfbb6..5f8832e 100644 --- a/fanli/src/main/java/com/yeshi/fanli/dao/dynamic/GoodsEvaluateDao.java +++ b/fanli/src/main/java/com/yeshi/fanli/dao/dynamic/GoodsEvaluateDao.java @@ -10,10 +10,9 @@ import org.springframework.data.mongodb.core.MongoTemplate; import org.springframework.data.mongodb.core.query.Criteria; import org.springframework.data.mongodb.core.query.Query; +import org.springframework.data.mongodb.core.query.Update; import org.springframework.stereotype.Repository; -import com.mongodb.BasicDBObject; -import com.mongodb.QueryOperators; import com.yeshi.fanli.entity.dynamic.GoodsEvaluate; import com.yeshi.fanli.util.StringUtil; @@ -35,6 +34,21 @@ mongoTemplate.save(record); } + + /** + * 鐘舵�佸垏鎹� + * + * @param record + */ + public void updateSatate(String id, int state) { + Query query = new Query(); + query.addCriteria(Criteria.where("id").is(id)); + + Update update = Update.update("state", state); + mongoTemplate.updateMulti(query, update, GoodsEvaluate.class); + } + + /** * 鍒犻櫎 @@ -125,7 +139,7 @@ query.addCriteria(Criteria.where("startTime").lte(now)); query.addCriteria(Criteria.where("endTime").gte(now)); query.skip(start).limit(count); - query.with(new Sort(Sort.Direction.DESC,"weight")).with(new Sort(Sort.Direction.DESC,"createTime")); + query.with(new Sort(Sort.Direction.DESC,"weight")).with(new Sort(Sort.Direction.DESC,"startTime")); return mongoTemplate.find(query, GoodsEvaluate.class); } @@ -192,4 +206,19 @@ query.with(new Sort(Sort.Direction.ASC,"createTime")); return mongoTemplate.find(query, GoodsEvaluate.class); } + + + /** + * 鏌ヨ鏈夋晥 + * @param start + * @param count + * @param key + * @return + */ + public List<GoodsEvaluate> removeDownGoods() { + Query query = new Query(); + query.addCriteria(Criteria.where("type").is("single")); + query.addCriteria(Criteria.where("goods.state").is(1)); + return mongoTemplate.find(query, GoodsEvaluate.class); + } } -- Gitblit v1.8.0