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;
|
}
|
}
|
