Package es.kukenan.smartfi.microservice.contracts.repository

Class BackofficeSubsystemRepository

java.lang.Object

es.kukenan.smartfi.microservice.contracts.repository.BackofficeSubsystemRepository

@Component
public class BackofficeSubsystemRepository
extends Object

Repository that holds the queries to retrieve BackofficeSubsystems.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
private static class	BackofficeSubsystemRepository.BackofficeSubsystemRowMapper	Mapper class to extract BackofficeSubsystems from query.

Field Summary

Fields

Modifier and Type	Field	Description
private static final String	EXISTS_CONTRACT_NULL	Query to exists contract is null in product table.
private static final String	FIND_BY_SUBSYSTEMS	Query to find all subsystems that have, at least, one product registered, ordering by back office and filtering by subtypes.
private static final String	FIND_BY_TYPE	Query to find all subsystems that have, at least, one product registered, ordering by back office and filtering by types.
private static final String	FIND_BY_USERID_AND_CONTRACTID	Query to find all subsystems that have, at least, one product registered, grouping by back office and filtering by user.
private static final String	FINISH_CHARACTER	Params clause finish character.
private org.springframework.jdbc.core.JdbcTemplate	jdbcTemplate	JdbcTemplate to query the database.
private static final String	PARAM	Param to add in the query.
private static final String	PATTERN	Pattern to replace in the query.
private static final String	SEPARATOR	Params query separator.
private static final String	START_CHARACTER	Params clause start character.

Constructor Summary

Constructors

Constructor	Description
BackofficeSubsystemRepository()

Method Summary

Modifier and Type	Method	Description
private String	createRealParamsNumber(List<Integer> params)
List<BackofficeSubsystems>	existsContractIsNull(String userId)	Find all subsystems that have, at least, one product registered, grouping by back office and filtering by user.
List<BackofficeSubsystems>	findBySubtypes(List<Integer> subtypes)	Find all subsystems that have, at least, one product registered, grouping by back office and filtering by subtypes.
List<BackofficeSubsystems>	findByType(Integer typeId)	Find all subsystems that have, at least, one product registered, grouping by back office and filtering by type.
List<BackofficeSubsystems>	findByUserIdAndContractId(String userId, String contractId)	Find all subsystems that have, at least, one product registered, grouping by back office and filtering by user.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

PATTERN

private static final String PATTERN

Pattern to replace in the query.

See Also:

• Constant Field Values

PARAM

private static final String PARAM

Param to add in the query.

See Also:

• Constant Field Values

SEPARATOR

private static final String SEPARATOR

Params query separator.

See Also:

• Constant Field Values

START_CHARACTER

private static final String START_CHARACTER

Params clause start character.

See Also:

• Constant Field Values

FINISH_CHARACTER

private static final String FINISH_CHARACTER

Params clause finish character.

See Also:

• Constant Field Values

FIND_BY_USERID_AND_CONTRACTID

private static final String FIND_BY_USERID_AND_CONTRACTID

Query to find all subsystems that have, at least, one product registered, grouping by back office and filtering by user.

See Also:

• Constant Field Values

EXISTS_CONTRACT_NULL

private static final String EXISTS_CONTRACT_NULL

Query to exists contract is null in product table.

See Also:

• Constant Field Values

FIND_BY_SUBSYSTEMS

private static final String FIND_BY_SUBSYSTEMS

Query to find all subsystems that have, at least, one product registered, ordering by back office and filtering by subtypes.

See Also:

• Constant Field Values

FIND_BY_TYPE

private static final String FIND_BY_TYPE

Query to find all subsystems that have, at least, one product registered, ordering by back office and filtering by types.

See Also:

• Constant Field Values

jdbcTemplate

@Autowired
private org.springframework.jdbc.core.JdbcTemplate jdbcTemplate

JdbcTemplate to query the database.

Constructor Details

BackofficeSubsystemRepository

public BackofficeSubsystemRepository()

Method Details

findByUserIdAndContractId

public List<BackofficeSubsystems> findByUserIdAndContractId(String userId,
 String contractId)

Find all subsystems that have, at least, one product registered, grouping by back office and filtering by user.

Parameters:

userId - user identifier.

contractId - contract identifier.

Returns:

back office subsystems.

existsContractIsNull

public List<BackofficeSubsystems> existsContractIsNull(String userId)

Find all subsystems that have, at least, one product registered, grouping by back office and filtering by user.

Parameters:

userId - user identifier.

Returns:

back office subsystems.

findBySubtypes

public List<BackofficeSubsystems> findBySubtypes(List<Integer> subtypes)

Find all subsystems that have, at least, one product registered, grouping by back office and filtering by subtypes.

Parameters:

subtypes - subtypes list to filter.

Returns:

back office subsystems.

findByType

public List<BackofficeSubsystems> findByType(Integer typeId)

Find all subsystems that have, at least, one product registered, grouping by back office and filtering by type.

Parameters:

typeId - type to filter.

Returns:

back office subsystems.

createRealParamsNumber

private String createRealParamsNumber(List<Integer> params)