Package es.kukenan.smartfi.microservice.smartficore.repository

Interface ContractStateRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<ContractState,String>, org.springframework.data.jpa.repository.JpaRepository<ContractState,String>, org.springframework.data.repository.PagingAndSortingRepository<ContractState,String>, org.springframework.data.repository.query.QueryByExampleExecutor<ContractState>, org.springframework.data.repository.Repository<ContractState,String>

@Repository
public interface ContractStateRepository
extends org.springframework.data.jpa.repository.JpaRepository<ContractState,String>

Repository for queries for Contract State.

Method Summary

Modifier and Type	Method	Description
List<ContractState>	findAllByProduct(String product)	Find Contract states by Product.
List<ContractState>	findAllByProductAndActive(String product, Boolean active)	Find group of contract states by Product.
List<ContractState>	findContractStateByGroup(String group)	Find Contract State for group.
List<ContractState>	findContractStateByGroupAndProduct(String group, String product)	Find Contract State for group and Product.
List<ContractState>	findContractStateByName(String name)	Find Contract State by Name.
ContractState	findContractStateByNameAndProduct(String name, String product)	Find Contract State by Name and Product.
List<ContractState>	findContractStateByNameList(List<String> name)	Find Contract State by List of names.
List<ContractState>	findContractStateByNameListAndProduct(List<String> name, String product)	Find Contract State by List of names and Product.
List<ContractState>	findContractStateByNotInNameList(List<String> name)	Find Contract State not in a List of names.
List<ContractState>	findContractStateByNotInNameListAndProduct(List<String> name, String product)	Find Contract State not in a List of names and Product.

Methods inherited from interface org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, save

Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getById, getOne, getReferenceById, saveAll, saveAllAndFlush, saveAndFlush

Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findBy, findOne

Method Details

findAllByProduct

List<ContractState> findAllByProduct(String product)

Find Contract states by Product.

Parameters:

product - contract state product.

Returns:

ContractState list.

findAllByProductAndActive

List<ContractState> findAllByProductAndActive(String product,
 Boolean active)

Find group of contract states by Product.

Parameters:

product - contract state product.

active - active state group.

Returns:

ContractState list.

findContractStateByNameAndProduct

ContractState findContractStateByNameAndProduct(String name,
 String product)

Find Contract State by Name and Product.

Parameters:

name - contract state name.

product - contract state product.

Returns:

ContractState object.

findContractStateByName

List<ContractState> findContractStateByName(String name)

Find Contract State by Name.

Parameters:

name - contract state name.

Returns:

ContractState object list.

findContractStateByNameListAndProduct

@Query("SELECT cs FROM ContractState cs WHERE cs.name in :name AND cs.product = :product")
List<ContractState> findContractStateByNameListAndProduct(@Param("name")
 List<String> name,
 @Param("product")
 String product)

Find Contract State by List of names and Product.

Parameters:

name - list of contract state name.

product - contract state product.

Returns:

ContractState object list.

findContractStateByNotInNameListAndProduct

@Query("SELECT cs FROM ContractState cs WHERE cs.name not in :name AND cs.product = :product")
List<ContractState> findContractStateByNotInNameListAndProduct(@Param("name")
 List<String> name,
 @Param("product")
 String product)

Find Contract State not in a List of names and Product.

Parameters:

name - list of contract state name.

product - contract state product.

Returns:

ContractState object list.

findContractStateByNameList

@Query("SELECT cs FROM ContractState cs WHERE cs.name in :name")
List<ContractState> findContractStateByNameList(@Param("name")
 List<String> name)

Find Contract State by List of names.

Parameters:

name - list of contract state name.

Returns:

ContractState object list.

findContractStateByNotInNameList

@Query("SELECT cs FROM ContractState cs WHERE cs.name not in :name")
List<ContractState> findContractStateByNotInNameList(@Param("name")
 List<String> name)

Find Contract State not in a List of names.

Parameters:

name - list of contract state name.

Returns:

ContractState object list.

findContractStateByGroup

@Query("SELECT cs FROM ContractState cs WHERE cs.group = :group")
List<ContractState> findContractStateByGroup(@Param("group")
 String group)

Find Contract State for group.

Parameters:

group - list of contract state name.

Returns:

ContractState object list.

findContractStateByGroupAndProduct

@Query("SELECT cs FROM ContractState cs WHERE cs.group = :group AND cs.product = :product")
List<ContractState> findContractStateByGroupAndProduct(@Param("group")
 String group,
 @Param("product")
 String product)

Find Contract State for group and Product.

Parameters:

group - list of contract state name.

product - contract state product.

Returns:

ContractState object list.