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