Class PropertyRepository

java.lang.Object

com.maplander.backend.repository.RepositoryBase<Property,Long>

com.maplander.backend.repository.PropertyRepository

public class PropertyRepository
extends RepositoryBase<Property,Long>

Field Summary

Fields inherited from class com.maplander.backend.repository.RepositoryBase

sessionFactory

Constructor Summary

Constructors

Constructor	Description
PropertyRepository(org.hibernate.SessionFactory sessionFactory)

Method Summary

Modifier and Type	Method	Description
Long	countBotProperties(org.hibernate.Session session, FiltersBigQuery filter)
Long	countByFilters(org.hibernate.Session session, BrandTypeEnum brand, Long officeId, Boolean isRoV, StatusTypeEnum status)
Long	countByOfficeId(Long officeId, org.hibernate.Session session)
Long	countByStatusAndOfficeId(Long officeId, StatusTypeEnum status, org.hibernate.Session session)
Long	countByUserIdAndStatus(Long userId, StatusTypeEnum status, org.hibernate.Session session)
List<Object[]>	countGroupedByStatusAndOfficeId(Long officeId, org.hibernate.Session session)
List<Object[]>	countGroupedByStatusAndUserId(Long userId, org.hibernate.Session session)
Long	countWithColonyPath(org.hibernate.Session session, FiltersBigQuery filter, String stateName, String municipalyName, String colonyName, int level)
Long	countWithDynamicFilters(org.hibernate.Session session, FiltersBigQuery filter)
Long	countWithDynamicFiltersAsLite(org.hibernate.Session session, FiltersBigQuery filter)
List<Property>	findAllPaginated(org.hibernate.Session session, int limit, int offset)
List<Property>	findArchivedByOfficeId(Long officeId, Integer limit, Integer offset, org.hibernate.Session session)
List<PropertyLiteBot>	findBotProperties(org.hibernate.Session session, FiltersBigQuery filter, Integer limit, Integer offset)
List<Property>	findByIds(List<Long> ids, org.hibernate.Session session)
List<Property>	findByOfficeId(Long officeId, org.hibernate.Session session)
Optional<Property>	findBySkuAndOfficeId(String sku, Long officeId, org.hibernate.Session session)
List<Property>	findByStatusAndOffice(StatusTypeEnum status, Long officeId, org.hibernate.Session session)
List<PropertyDashBoard>	findDashboardProperties(org.hibernate.Session session, FiltersBigQuery filter, Integer limit, Integer offset)
Set<Long>	findIdsByIds(List<Long> ids, org.hibernate.Session session)
Map<Long,String>	findImagesByIds(List<Long> ids, org.hibernate.Session session)
Map<Long,Property>	findMapByIds(List<Long> ids, org.hibernate.Session session)
List<SQLPlaces>	findPlacesByWord(PropertyTypeEnum type, OfferingTypeEnum offering, String word, Integer limit, Integer offset, org.hibernate.Session session)
List<SQLPlaces>	findPlacesByWordInOffice(PropertyTypeEnum type, OfferingTypeEnum offering, Long officeId, String word, org.hibernate.Session session)
List<SQLPlaces>	findPlacesByWordInUser(PropertyTypeEnum type, OfferingTypeEnum offering, Long userId, String word, org.hibernate.Session session)
List<Object[]>	findPlacesByWordPolygon(PropertyTypeEnum type, OfferingTypeEnum offering, String word, String countryCode, org.hibernate.Session session)
List<Object[]>	findPlacesByWordPolygonOrdered(PropertyTypeEnum type, OfferingTypeEnum offering, String word, String countryCode, org.hibernate.Session session)
List<SQLPlaces>	findPlacesByWordSoundex(PropertyTypeEnum type, OfferingTypeEnum offering, String word, org.hibernate.Session session)
List<SQLPlaces>	findPlacesByWordSP(String word, org.hibernate.Session session)
List<PropertyUserLite>	findPropertyUserLite(org.hibernate.Session session, FiltersBigQuery filter, Integer limit, Integer offset)
List<PropertyLite>	findSharedLiteByIdsAndFilters(List<Long> ids, Filter filter, Integer limit, Integer offset, org.hibernate.Session session)
List<SQLTopPlaces>	findTopPlaces(org.hibernate.Session session)
List<Property>	findWithClassification(org.hibernate.Session session, FiltersBigQuery filter, Integer limit, Integer offset)
List<PropertyLiteResult>	findWithClassificationAsLite(org.hibernate.Session session, FiltersBigQuery filter, Integer limit, Integer offset)
List<PropertyLiteResult>	findWithColonyPathAsLite(org.hibernate.Session session, FiltersBigQuery filter, String stateName, String municipalyName, String colonyName, int level, Integer limit, Integer offset)
List<Property>	findWithDynamicFilters(org.hibernate.Session session, FiltersBigQuery filter, Integer limit, Integer offset, OrderTypeEnum orderTypeEnum, Boolean orderAsc)
List<PropertyLiteResult>	findWithDynamicFiltersAsLite(org.hibernate.Session session, FiltersBigQuery filter, Integer limit, Integer offset, OrderTypeEnum orderTypeEnum, Boolean orderAsc)
List<PropertyLiteResult>	findWithDynamicFiltersAsLiteBQ(org.hibernate.Session session, FiltersBigQuery filter, Integer limit, Integer offset, OrderTypeEnum orderTypeEnum, Boolean orderAsc)
List<PropertyLiteResult>	findWithDynamicFiltersAsLitePolygonId(org.hibernate.Session session, FiltersBigQuery filter, Integer limit, Integer offset, OrderTypeEnum orderTypeEnum, Boolean orderAsc)
List<PropertyLite>	getPropertiesByPath(String state_name, String municipaly_name, String colony_name, Integer level, String tipo_oferta, String tipo_propiedad, Integer bathrooms, Integer bedrooms, int lim, int cur, org.hibernate.Session session)
List<PropertyPreview>	getPropertiesPreviewByPath(ColonyLocation colonyLocation, int lmt, int cur, int bedFinal, int bathFinal, org.hibernate.Session session)
List<Long>	listIdsToExpire(org.hibernate.Session session)
List<PropertyLiteMap>	queryLiteWithFilters(FiltersBigQuery filter, org.hibernate.Session session)
Integer	queryTotalPropertyWithFilters(FiltersBigQuery filter, org.hibernate.Session session)
PreviewPlaces	searchPreviewPlaces(LocationTypeEnum locationType, OfferingTypeEnum offering, PropertyTypeEnum type, String state, String municipality, org.hibernate.Session session)
List<PropertyLite>	searchPropertiesByColony(OfferingTypeEnum offering, PropertyTypeEnum type, String state, String municipality, String colony, int lim, int cur, org.hibernate.Session session)
List<PropertyLite>	searchPropertyLiteForSite(LocationTypeEnum locationType, OfferingTypeEnum offering, PropertyTypeEnum type, Integer total, String state, String municipality, String colony, org.hibernate.Session session)
List<SQLResults>	searchStock(LocationTypeEnum locationType, OfferingTypeEnum offering, PropertyTypeEnum type, String state, String municipality, org.hibernate.Session session)
List<SQLResults>	searchStockPlaces(LocationTypeEnum locationType, OfferingTypeEnum offering, PropertyTypeEnum type, String state, String municipality, org.hibernate.Session session)
List<SQLResults>	searchStockWithFilters(FiltersBigQuery filter, org.hibernate.Session session)

Methods inherited from class com.maplander.backend.repository.RepositoryBase

currentSession, delete, delete, deleteAll, deleteAll, deleteAll, deleteAllById, deleteAllById, deleteById, deleteById, deleteById, existsById, findAll, findAll, findById, findById, save, save, saveAll

Methods inherited from class java.lang.Object

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

Constructor Details

PropertyRepository

public PropertyRepository(org.hibernate.SessionFactory sessionFactory)

Method Details

findByStatusAndOffice

public List<Property> findByStatusAndOffice(StatusTypeEnum status,
 Long officeId,
 org.hibernate.Session session)

findBySkuAndOfficeId

public Optional<Property> findBySkuAndOfficeId(String sku,
 Long officeId,
 org.hibernate.Session session)

findArchivedByOfficeId

public List<Property> findArchivedByOfficeId(Long officeId,
 Integer limit,
 Integer offset,
 org.hibernate.Session session)

findByOfficeId

public List<Property> findByOfficeId(Long officeId,
 org.hibernate.Session session)

findAllPaginated

public List<Property> findAllPaginated(org.hibernate.Session session,
 int limit,
 int offset)

countByStatusAndOfficeId

public Long countByStatusAndOfficeId(Long officeId,
 StatusTypeEnum status,
 org.hibernate.Session session)

countByUserIdAndStatus

public Long countByUserIdAndStatus(Long userId,
 StatusTypeEnum status,
 org.hibernate.Session session)

listIdsToExpire

public List<Long> listIdsToExpire(org.hibernate.Session session)

countGroupedByStatusAndOfficeId

public List<Object[]> countGroupedByStatusAndOfficeId(Long officeId,
 org.hibernate.Session session)

countGroupedByStatusAndUserId

public List<Object[]> countGroupedByStatusAndUserId(Long userId,
 org.hibernate.Session session)

countByOfficeId

public Long countByOfficeId(Long officeId,
 org.hibernate.Session session)

countByFilters

public Long countByFilters(org.hibernate.Session session,
 BrandTypeEnum brand,
 Long officeId,
 Boolean isRoV,
 StatusTypeEnum status)

countWithDynamicFilters

public Long countWithDynamicFilters(org.hibernate.Session session,
 FiltersBigQuery filter)

findWithDynamicFilters

public List<Property> findWithDynamicFilters(org.hibernate.Session session,
 FiltersBigQuery filter,
 Integer limit,
 Integer offset,
 OrderTypeEnum orderTypeEnum,
 Boolean orderAsc)

findWithDynamicFiltersAsLite

public List<PropertyLiteResult> findWithDynamicFiltersAsLite(org.hibernate.Session session,
 FiltersBigQuery filter,
 Integer limit,
 Integer offset,
 OrderTypeEnum orderTypeEnum,
 Boolean orderAsc)

findWithDynamicFiltersAsLiteBQ

public List<PropertyLiteResult> findWithDynamicFiltersAsLiteBQ(org.hibernate.Session session,
 FiltersBigQuery filter,
 Integer limit,
 Integer offset,
 OrderTypeEnum orderTypeEnum,
 Boolean orderAsc)

findWithDynamicFiltersAsLitePolygonId

public List<PropertyLiteResult> findWithDynamicFiltersAsLitePolygonId(org.hibernate.Session session,
 FiltersBigQuery filter,
 Integer limit,
 Integer offset,
 OrderTypeEnum orderTypeEnum,
 Boolean orderAsc)

countWithDynamicFiltersAsLite

public Long countWithDynamicFiltersAsLite(org.hibernate.Session session,
 FiltersBigQuery filter)

findBotProperties

public List<PropertyLiteBot> findBotProperties(org.hibernate.Session session,
 FiltersBigQuery filter,
 Integer limit,
 Integer offset)

countBotProperties

public Long countBotProperties(org.hibernate.Session session,
 FiltersBigQuery filter)

findPropertyUserLite

public List<PropertyUserLite> findPropertyUserLite(org.hibernate.Session session,
 FiltersBigQuery filter,
 Integer limit,
 Integer offset)

findDashboardProperties

public List<PropertyDashBoard> findDashboardProperties(org.hibernate.Session session,
 FiltersBigQuery filter,
 Integer limit,
 Integer offset)

findWithClassification

public List<Property> findWithClassification(org.hibernate.Session session,
 FiltersBigQuery filter,
 Integer limit,
 Integer offset)

findWithClassificationAsLite

public List<PropertyLiteResult> findWithClassificationAsLite(org.hibernate.Session session,
 FiltersBigQuery filter,
 Integer limit,
 Integer offset)

findPlacesByWordInOffice

public List<SQLPlaces> findPlacesByWordInOffice(PropertyTypeEnum type,
 OfferingTypeEnum offering,
 Long officeId,
 String word,
 org.hibernate.Session session)

findPlacesByWordInUser

public List<SQLPlaces> findPlacesByWordInUser(PropertyTypeEnum type,
 OfferingTypeEnum offering,
 Long userId,
 String word,
 org.hibernate.Session session)

findPlacesByWord

public List<SQLPlaces> findPlacesByWord(PropertyTypeEnum type,
 OfferingTypeEnum offering,
 String word,
 Integer limit,
 Integer offset,
 org.hibernate.Session session)

findPlacesByWordSP

public List<SQLPlaces> findPlacesByWordSP(String word,
 org.hibernate.Session session)

findPlacesByWordSoundex

public List<SQLPlaces> findPlacesByWordSoundex(PropertyTypeEnum type,
 OfferingTypeEnum offering,
 String word,
 org.hibernate.Session session)

findPlacesByWordPolygon

public List<Object[]> findPlacesByWordPolygon(PropertyTypeEnum type,
 OfferingTypeEnum offering,
 String word,
 String countryCode,
 org.hibernate.Session session)

findPlacesByWordPolygonOrdered

public List<Object[]> findPlacesByWordPolygonOrdered(PropertyTypeEnum type,
 OfferingTypeEnum offering,
 String word,
 String countryCode,
 org.hibernate.Session session)

findImagesByIds

public Map<Long,String> findImagesByIds(List<Long> ids,
 org.hibernate.Session session)

findByIds

public List<Property> findByIds(List<Long> ids,
 org.hibernate.Session session)

findMapByIds

public Map<Long,Property> findMapByIds(List<Long> ids,
 org.hibernate.Session session)

findSharedLiteByIdsAndFilters

public List<PropertyLite> findSharedLiteByIdsAndFilters(List<Long> ids,
 Filter filter,
 Integer limit,
 Integer offset,
 org.hibernate.Session session)

findTopPlaces

public List<SQLTopPlaces> findTopPlaces(org.hibernate.Session session)

findIdsByIds

public Set<Long> findIdsByIds(List<Long> ids,
 org.hibernate.Session session)

searchStockPlaces

public List<SQLResults> searchStockPlaces(LocationTypeEnum locationType,
 OfferingTypeEnum offering,
 PropertyTypeEnum type,
 String state,
 String municipality,
 org.hibernate.Session session)

searchStock

public List<SQLResults> searchStock(LocationTypeEnum locationType,
 OfferingTypeEnum offering,
 PropertyTypeEnum type,
 String state,
 String municipality,
 org.hibernate.Session session)

searchStockWithFilters

public List<SQLResults> searchStockWithFilters(FiltersBigQuery filter,
 org.hibernate.Session session)

searchPropertyLiteForSite

public List<PropertyLite> searchPropertyLiteForSite(LocationTypeEnum locationType,
 OfferingTypeEnum offering,
 PropertyTypeEnum type,
 Integer total,
 String state,
 String municipality,
 String colony,
 org.hibernate.Session session)

queryTotalPropertyWithFilters

public Integer queryTotalPropertyWithFilters(FiltersBigQuery filter,
 org.hibernate.Session session)

queryLiteWithFilters

public List<PropertyLiteMap> queryLiteWithFilters(FiltersBigQuery filter,
 org.hibernate.Session session)

getPropertiesByPath

public List<PropertyLite> getPropertiesByPath(String state_name,
 String municipaly_name,
 String colony_name,
 Integer level,
 String tipo_oferta,
 String tipo_propiedad,
 Integer bathrooms,
 Integer bedrooms,
 int lim,
 int cur,
 org.hibernate.Session session)

getPropertiesPreviewByPath

public List<PropertyPreview> getPropertiesPreviewByPath(ColonyLocation colonyLocation,
 int lmt,
 int cur,
 int bedFinal,
 int bathFinal,
 org.hibernate.Session session)

searchPreviewPlaces

public PreviewPlaces searchPreviewPlaces(LocationTypeEnum locationType,
 OfferingTypeEnum offering,
 PropertyTypeEnum type,
 String state,
 String municipality,
 org.hibernate.Session session)

searchPropertiesByColony

public List<PropertyLite> searchPropertiesByColony(OfferingTypeEnum offering,
 PropertyTypeEnum type,
 String state,
 String municipality,
 String colony,
 int lim,
 int cur,
 org.hibernate.Session session)

findWithColonyPathAsLite

public List<PropertyLiteResult> findWithColonyPathAsLite(org.hibernate.Session session,
 FiltersBigQuery filter,
 String stateName,
 String municipalyName,
 String colonyName,
 int level,
 Integer limit,
 Integer offset)

countWithColonyPath

public Long countWithColonyPath(org.hibernate.Session session,
 FiltersBigQuery filter,
 String stateName,
 String municipalyName,
 String colonyName,
 int level)