Summary Table

Categories Total Count
PII 0
URL 0
DNS 0
EKL 0
IP 0
PORT 0
VsID 0
CF 0
AI 0
VPD 0
PL 0
Other 0

File Content

/*
* BillingCodeRepository.java
* Copyright (c) 2017 Veterans Affairs.
*/
package gov.va.oneconsult.seoc.api.repository;

import java.util.Set;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import org.springframework.data.repository.query.Param;

import gov.va.oneconsult.seoc.api.model.BillingCode;

/**
* @author AbleVets
*/
public interface BillingCodeRepository extends CrudRepository<BillingCode, Integer>
{

@Query("SELECT bc FROM BillingCode bc where (bc.deactivated is null or bc.deactivated=false)")
Set<BillingCode> findAllBillingCodes();

@Query("SELECT bc FROM BillingCode bc WHERE LOWER(bc.billingCode) like LOWER(CONCAT('%',:billingcode,'%')) and (bc.deactivated is null or bc.deactivated=false)")
Set<BillingCode> fetchBybillingCode(@Param("billingcode") String billingCode);

Set<BillingCode> findByBillingCode(String billingCode);

@Query("SELECT bc FROM BillingCode bc where (bc.deactivated is null or bc.deactivated=false) and bc.billingCode in :billingcodes order by bc.id")
Set<BillingCode> findBillingCodesFromList(@Param("billingcodes") Set<String> billingCodes);

}