From ff265ba53df1d9e89ae2d4258007cd2e02811f8c Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期四, 17 七月 2025 18:16:06 +0800
Subject: [PATCH] Merge branch 'master' of http://120.76.84.145:10101/gitblit/r/java/mx_charging_pile into dev

---
 ruoyi-service/ruoyi-integration/src/main/java/com/ruoyi/integration/mongodb/service/impl/TransactionRecordServiceImpl.java |   32 ++++++++++++++++++++++++++++++++
 1 files changed, 32 insertions(+), 0 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 a98c22b..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.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