修改

whyclxw

2024-07-01 0ce771b4a4ff5897dc91bb1b84a4561781b00ca5

 src/main/java/com/whyc/service/CKPowerDevSignalSetLogService.java

@@ -1,6 +1,12 @@
package com.whyc.service;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.whyc.dto.Response;
import com.whyc.mapper.CKPowerDevSignalSetLogMapper;
import com.whyc.pojo.db_ckpwrdev_data_rt.CKPowerDevBreakerControlLog;
import com.whyc.pojo.db_ckpwrdev_data_rt.CKPowerDevSignalSetLog;
import org.springframework.stereotype.Service;

@@ -16,4 +22,36 @@
    public void addBatch(List<CKPowerDevSignalSetLog> logList) {
        mapper.insertBatchSomeColumn(logList);
    }

    public Response getPage(CKPowerDevSignalSetLog param) {
        Integer pageNum = param.getPageNum();
        Integer pageSize = param.getPageSize();
        PageHelper.startPage(pageNum,pageSize);
        QueryWrapper<CKPowerDevSignalSetLog> query = Wrappers.query();

        if(param.getDevType()!=null){
            query.eq("dev_type",param.getDevType());
        }
        if(param.getParamCn()!=null){
            query.eq("param_cn",param.getParamCn());
        }
        if(param.getStartTime()!=null){
            query.ge("create_day",param.getStartTime());
        }
        if(param.getEndTime()!=null){
            query.le("create_day",param.getEndTime());
        }
        query.orderByDesc("id");
        List<CKPowerDevSignalSetLog> list = mapper.selectList(query);
        PageInfo<CKPowerDevSignalSetLog> pageInfo = new PageInfo<>(list);
        return new Response().set(1,pageInfo);
    }

    public Response getList(String param, String dayTime) {
        QueryWrapper<CKPowerDevSignalSetLog> query = Wrappers.query();
        query.eq("param",param);
        query.eq("create_day",dayTime);
        List<CKPowerDevSignalSetLog> list = mapper.selectList(query);
        return new Response().set(1,list);
    }
}