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