From ee1d39f11b9483b64a88029f1755a6e7166fea15 Mon Sep 17 00:00:00 2001 From: yujian <yujian@163.com> Date: 星期日, 26 四月 2020 16:49:21 +0800 Subject: [PATCH] 等级显示问题 --- fanli/src/main/java/com/yeshi/fanli/dao/dynamic/GoodsEvaluateDao.java | 54 +++++++++++++++++++++++++++++++++++++++++++++++++----- 1 files changed, 49 insertions(+), 5 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 cfc5860..cf9bf9b 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,36 @@ 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); + } + + + + /** + * 鍒犻櫎 + * @param record + */ + public void remove(GoodsEvaluate record) { + if (record == null) { + return; + } + mongoTemplate.remove(record); + } + + + + /** * 鏍规嵁id鏌ヨ鏁版嵁 * @@ -110,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); } @@ -157,9 +186,24 @@ Query query = new Query(); query.addCriteria(Criteria.where("dynamicType").is(1)); query.addCriteria(Criteria.where("state").is(1)); - query.addCriteria(Criteria.where("goods.goodsId").is(goodsId)); - query.addCriteria(Criteria.where("goods.goodsType").is(goodsType)); + query.addCriteria(Criteria.where("imgList.goods.goodsId").is(goodsId)); + query.addCriteria(Criteria.where("imgList.goods.goodsType").is(goodsType)); return mongoTemplate.find(query, GoodsEvaluate.class); } + + /** + * 鏌ヨ鏈夋晥 + * @param start + * @param count + * @param key + * @return + */ + public List<GoodsEvaluate> queryOverdue() { + Date now = new Date(); + Query query = new Query(); + query.addCriteria(Criteria.where("endTime").lte(now)); + query.with(new Sort(Sort.Direction.ASC,"createTime")); + return mongoTemplate.find(query, GoodsEvaluate.class); + } } -- Gitblit v1.8.0