package com.gkhy.testFourierSpecialGasMonitor.repository;

import com.gkhy.testFourierSpecialGasMonitor.entity.GasCategoryConfiguration;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.web.bind.annotation.RequestParam;

import java.util.List;

public interface GasCategoryConfigurationRepository extends JpaRepository<GasCategoryConfiguration,Integer>, JpaSpecificationExecutor<GasCategoryConfiguration> {
    @Query(value = "SELECT * FROM gas_category_configuration  WHERE del_flag = 0 AND gas_category_id = :id",nativeQuery = true)
    List<GasCategoryConfiguration> findByGasCategoryId(@Param("id") Integer id);

    @Query(value = "SELECT * FROM gas_category_configuration  WHERE del_flag = 0 AND gas_category_id = :gasCategoryId AND orientation = :orientation",nativeQuery = true)
    GasCategoryConfiguration findByGasCategoryIdAndOrientation(@Param("gasCategoryId") Integer gasCategoryId,@Param("orientation") Integer position);

    @Query(value = "SELECT * FROM gas_category_configuration  WHERE del_flag = 0 AND  orientation = :orientation",nativeQuery = true)
    GasCategoryConfiguration findByOrientation(@Param("orientation") Integer position);
}