package com.yssh.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.yssh.entity.Yssh2dreli;
import com.yssh.entity.Yssh3dreli;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author lishijia
 * @ClassName Yssh3dreliMapper
 * @Description TODO
 * @date 2022/12/3 21:37
 * @Version 1.0
 */
@Mapper
public interface Yssh3dreliMapper extends BaseMapper<Yssh3dreli> {

    List<Yssh3dreli> query(@Param("name") String name);
    List<Yssh3dreli> getAll();


    /**
     * 创建3维热力表接口
     * @param tableName 表名称
     */
    public int  create3dreliTable(@Param("tableName") String tableName);

    /**
     * 删除3维热力表接口
     * @param tableName 表名称
     */
    public int  drop3dreliTable(@Param("tableName") String tableName);


    /**
     * 批量新增3维热力记录
     *
     * @param yssh3dreli 3维热力记录
     * @return 结果
     */
    public int batchInsert3dreliData(@Param("tableName") String tableName, @Param("list") List<Yssh3dreli> yssh3dreli);

    /**
     * 批量新增2维热力记录
     *
     * @param yssh2drelis 2维热力记录
     * @return 结果
     */
    public int batchInsert2dreliData(@Param("tableName") String tableName, @Param("list") List<Yssh2dreli> yssh2drelis);

    /**
     * 查询3维热力表接口
     * @param tableName 表名称
     */
    public List<Yssh3dreli> query3data(@Param("time") String time, @Param("tableName") String tableName);

    public List<Yssh3dreli> thrDDataQuery(@Param("tableName") String endOfTime);
    public List<Yssh3dreli> thrDDataQuery01(@Param("name") String name,@Param("tableName") String endOfTime);

    public List<Yssh3dreli> thrDDataQuery1(@Param("tableName") String tableName, @Param("startTime") String startTime, @Param("endOfTime") String endOfTime);
    public List<Yssh3dreli> thrDDataQuery11(@Param("name") String name, @Param("tableName") String tableName, @Param("startTime") String startTime, @Param("endOfTime") String endOfTime);

    public List<Yssh3dreli> thrDDataQuery2(@Param("tableName") String tableName, @Param("startTime") String startTime);

    public List<Yssh3dreli> thrDDataQuery3(@Param("tableName") String tableName, @Param("endOfTime") String endOfTime);
}