sis-background/gyee-sample-impala/src/main/java/com/gyee/impala/mapper/slave/WindturbinewindyawMapper.java

package com.gyee.impala.mapper.slave;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.gyee.impala.model.custom.YawValuesVo;
import com.gyee.impala.model.slave.Windturbinewindyaw;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.Date;
import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author chenmh
 * @since 2022-01-05
 */
@Mapper
public interface WindturbinewindyawMapper extends BaseMapper<Windturbinewindyaw> {

    @Select("select windturbineid wtId, sum(\"R-50\") \"Rf50\",\n" +
            "sum(\"R-49\") \"Rf49\",sum(\"R-48\") \"Rf48\",sum(\"R-47\") \"Rf47\",sum(\"R-46\") \"Rf46\",sum(\"R-45\") \"Rf45\",sum(\"R-44\") \"Rf44\",sum(\"R-43\") \"Rf43\",sum(\"R-42\") \"Rf42\",sum(\"R-41\") \"Rf41\",sum(\"R-40\") \"Rf40\",\n" +
            "sum(\"R-39\") \"Rf39\",sum(\"R-38\") \"Rf38\",sum(\"R-37\") \"Rf37\",sum(\"R-36\") \"Rf36\",sum(\"R-35\") \"Rf35\",sum(\"R-34\") \"Rf34\",sum(\"R-33\") \"Rf33\",sum(\"R-32\") \"Rf32\",sum(\"R-31\") \"Rf31\",sum(\"R-30\") \"Rf30\",\n" +
            "sum(\"R-29\") \"Rf29\",sum(\"R-28\") \"Rf28\",sum(\"R-27\") \"Rf27\",sum(\"R-26\") \"Rf26\",sum(\"R-25\") \"Rf25\",sum(\"R-24\") \"Rf24\",sum(\"R-23\") \"Rf23\",sum(\"R-22\") \"Rf22\",sum(\"R-21\") \"Rf21\",sum(\"R-20\") \"Rf20\",\n" +
            "sum(\"R-19\") \"Rf19\",sum(\"R-18\") \"Rf18\",sum(\"R-17\") \"Rf17\",sum(\"R-16\") \"Rf16\",sum(\"R-15\") \"Rf15\",sum(\"R-14\") \"Rf14\",sum(\"R-13\") \"Rf13\",sum(\"R-12\") \"Rf12\",sum(\"R-11\") \"Rf11\",sum(\"R-10\") \"Rf10\",\n" +
            "sum(\"R-9\") \"Rf9\",sum(\"R-8\") \"Rf8\",sum(\"R-7\") \"Rf7\",sum(\"R-6\") \"Rf6\",sum(\"R-5\") \"Rf5\",sum(\"R-4\") \"Rf4\",sum(\"R-3\") \"Rf3\",sum(\"R-2\") \"Rf2\",sum(\"R-1\") \"Rf1\",\n" +
            "sum(\"R0\") \"R0\",sum(\"R1\") \"R1\",sum(\"R2\") \"R2\",sum(\"R3\") \"R3\",sum(\"R4\") \"R4\",sum(\"R5\") \"R5\",sum(\"R6\") \"R6\",sum(\"R7\") \"R7\",sum(\"R8\") \"R8\",sum(\"R9\") \"R9\",\n" +
            "sum(\"R10\") \"R10\",sum(\"R11\") \"R11\",sum(\"R12\") \"R12\",sum(\"R13\") \"R13\",sum(\"R14\") \"R14\",sum(\"R15\") \"R15\", sum(\"R16\") \"R16\",sum(\"R17\") \"R17\",sum(\"R18\") \"R18\",sum(\"R19\") \"R19\",\n" +
            "sum(\"R20\") \"R20\",sum(\"R21\") \"R21\",sum(\"R22\") \"R22\",sum(\"R23\") \"R23\",sum(\"R24\") \"R24\",sum(\"R25\") \"R25\", sum(\"R26\") \"R26\",sum(\"R27\") \"R27\",sum(\"R28\") \"R28\",sum(\"R29\") \"R29\",\n" +
            "sum(\"R30\") \"R30\",sum(\"R31\") \"R31\",sum(\"R32\") \"R32\",sum(\"R33\") \"R33\",sum(\"R34\") \"R34\",sum(\"R35\") \"R35\", sum(\"R36\") \"R36\",sum(\"R37\") \"R37\",sum(\"R38\") \"R38\",sum(\"R39\") \"R39\",\n" +
            "sum(\"R40\") \"R40\",sum(\"R41\") \"R41\",sum(\"R42\") \"R42\",sum(\"R43\") \"R43\",sum(\"R44\") \"R44\",sum(\"R45\") \"R45\", sum(\"R46\") \"R46\",sum(\"R47\") \"R47\",sum(\"R48\") \"R48\",sum(\"R49\") \"R49\",sum(\"R50\") \"R50\" \n" +
            "from WindturbineWindYaw where windturbineid=#{wtId} and recorddate >= #{beginDate} and recorddate <= #{endDate} group by windturbineid")
    List<YawValuesVo> getYawTotalAll(@Param("wtId")String wtId, @Param("beginDate") Date beginDate, @Param("endDate") Date endDate);
}