java/mx_charging_pile.git

New file
			@@ -0,0 +1,68 @@
			package com.ruoyi.jianguan.mongodb.service.impl;

			import com.ruoyi.common.core.utils.StringUtils;
			import com.ruoyi.integration.api.model.TimingSetting;
			import com.ruoyi.integration.api.model.TransactionRecord;
			import com.ruoyi.jianguan.constant.IotConstant;
			import com.ruoyi.jianguan.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.util.Date;
			import java.util.List;
			import java.util.Objects;

			@Service
			public class TransactionRecordServiceImpl implements TransactionRecordService {
			@Autowired
			private MongoTemplate mongoTemplate;
			@Override
			public int create(TransactionRecord transactionRecord) {
			mongoTemplate.save(transactionRecord);
			return IotConstant.SUCCESS;
			}

			@Override
			public TransactionRecord findById(String id) {
			return mongoTemplate.findById(id, TransactionRecord.class);
			}

			@Override
			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 List<TransactionRecord> getRangeTimeData(Date startTime, Date endTime) {
			Query query = new Query();
			// 根据时间范围查询
			if (Objects.nonNull(startTime) && Objects.nonNull(endTime)) {
			query.addCriteria(Criteria.where("create_time").gte(startTime).lte(endTime));
			}
			List<TransactionRecord> list = mongoTemplate.find(
			query.with(Sort.by(Sort.Order.desc("create_time")))
			, TransactionRecord.class);
			return list;
			}
			}