From 8985f0bbcfd8a351eb7a081b3817da57de9ac639 Mon Sep 17 00:00:00 2001 From: Pu Zhibing <393733352@qq.com> Date: 星期三, 16 七月 2025 17:43:58 +0800 Subject: [PATCH] 修改bug --- ruoyi-service/ruoyi-integration/src/main/java/com/ruoyi/integration/mongodb/service/impl/TransactionRecordServiceImpl.java | 36 ++++++++++++++++++++++++++++++++++-- 1 files changed, 34 insertions(+), 2 deletions(-) diff --git a/ruoyi-service/ruoyi-integration/src/main/java/com/ruoyi/integration/mongodb/service/impl/TransactionRecordServiceImpl.java b/ruoyi-service/ruoyi-integration/src/main/java/com/ruoyi/integration/mongodb/service/impl/TransactionRecordServiceImpl.java index d3cdd69..6e3207b 100644 --- a/ruoyi-service/ruoyi-integration/src/main/java/com/ruoyi/integration/mongodb/service/impl/TransactionRecordServiceImpl.java +++ b/ruoyi-service/ruoyi-integration/src/main/java/com/ruoyi/integration/mongodb/service/impl/TransactionRecordServiceImpl.java @@ -1,13 +1,20 @@ package com.ruoyi.integration.mongodb.service.impl; +import com.ruoyi.common.core.utils.StringUtils; +import com.ruoyi.integration.api.model.AcquisitionBillingModeReply; +import com.ruoyi.integration.api.model.UploadRealTimeMonitoringData; import com.ruoyi.integration.iotda.constant.IotConstant; -import com.ruoyi.integration.mongodb.model.TimingSetting; -import com.ruoyi.integration.mongodb.model.TransactionRecord; +import com.ruoyi.integration.api.model.TimingSetting; +import com.ruoyi.integration.api.model.TransactionRecord; import com.ruoyi.integration.mongodb.service.TransactionRecordService; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.data.domain.Sort; 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.stereotype.Service; +import java.time.LocalDateTime; import java.util.List; @Service @@ -29,4 +36,29 @@ public List<TransactionRecord> findAll() { return mongoTemplate.findAll(TransactionRecord.class); } + + /** + * 根据订单流水号查询数据 + * @param code + * @return + */ + @Override + public TransactionRecord findOne(String code) { + Query query = new Query(); + if(StringUtils.isNotEmpty(code)){ + query.addCriteria(Criteria.where("transaction_serial_number").is(code)); + } + List<TransactionRecord> transactionRecords = mongoTemplate.find( + query.with(Sort.by(Sort.Order.desc("create_time"))) + , TransactionRecord.class); + return transactionRecords.size() > 0 ? transactionRecords.get(0) : null; + } + + + @Override + public void taskDelete() { + Query query = new Query(); + query.addCriteria(Criteria.where("create_time").lt(LocalDateTime.now().minusMonths(4))); + mongoTemplate.remove(query, TransactionRecord.class); + } } -- Gitblit v1.7.1