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