package com.agent.repository.agent;

import com.agent.entity.agent.HawbOtherFeeEntity;
import com.agent.entity.agent.PubFhrEntity;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

import java.util.List;

public interface HawbOtherFeeRepository extends PagingAndSortingRepository<HawbOtherFeeEntity, Long>,
        JpaSpecificationExecutor<HawbOtherFeeEntity> {

    @Query(value = "SELECT * FROM MAKE_HAWB_FEE ORDER BY ID DESC", nativeQuery = true)
    public List<HawbOtherFeeEntity> findAll();

    @Query(value = "SELECT * FROM MAKE_HAWB_FEE WHERE HAWB_ID = ?1 ORDER BY ID DESC", nativeQuery = true)
    public List<HawbOtherFeeEntity> findByHawbId(Long hawbId);
}