Class GeopoliticalRepository

java.lang.Object

com.maplander.backend.repository.RepositoryBase<ProvinciaPA,Integer>

com.maplander.backend.repository.GeopoliticalRepository

public class GeopoliticalRepository
extends RepositoryBase<ProvinciaPA,Integer>

Field Summary

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

sessionFactory

Constructor Summary

Constructors

Constructor	Description
GeopoliticalRepository(org.hibernate.SessionFactory sessionFactory)

Method Summary

Modifier and Type	Method	Description
ColonyLocation	getColonyByPath(String path, org.hibernate.Session session)
List<LocationSitemapOT>	getLocationsByPath(String path, org.hibernate.Session session)
List<SearchLocation>	getLocationSearch(String location, Integer level, org.hibernate.Session session)
NamesSpaces	getNamesWithURL(String state, String municipality, String colony, OfferingTypeEnum offering, PropertyTypeEnum type, org.hibernate.Session session)
List<LocationSitemap>	getOfferingsByPath(String path, org.hibernate.Session session)
SQLResultWord	getPlacesByWord(PropertyTypeEnum type, OfferingTypeEnum offering, String word, org.hibernate.Session session)
SQLResultWord	getPlacesByWordAndOfficeId(PropertyTypeEnum type, OfferingTypeEnum offering, StatusTypeEnum status, String word, Long officeId, org.hibernate.Session session)
List<LocationSitemap>	getTypesByPath(String path, org.hibernate.Session session)
List<Object[]>	listBarrios(String provincia, String distrito, String corregimiento, String localidad, org.hibernate.Session session)
List<Object[]>	listCorregimiento(String provincia, String distrito, org.hibernate.Session session)
List<Object[]>	listDistrito(String provincia, org.hibernate.Session session)
List<Object[]>	listProvincia(org.hibernate.Session session)
List<Object[]>	querySearchBarriosSoundex(String word, Integer limit, org.hibernate.Session session)
List<SQLResults>	searchColonyByMunicipality(OfferingTypeEnum offering, PropertyTypeEnum type, String state, String municipality, org.hibernate.Session session)
List<SQLResults>	searchColonyByMunicipalityWithFilters(FiltersBigQuery filter, org.hibernate.Session session)
SQLResultsMC	searchMunicipalityAndColonyByState(OfferingTypeEnum offering, PropertyTypeEnum type, String state, org.hibernate.Session session)
List<SQLResults>	searchMunicipalityByState(OfferingTypeEnum offering, PropertyTypeEnum type, String state, org.hibernate.Session session)
List<SQLResults>	searchMunicipalityByStateWithFilters(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

GeopoliticalRepository

public GeopoliticalRepository(org.hibernate.SessionFactory sessionFactory)

Method Details

listProvincia

public List<Object[]> listProvincia(org.hibernate.Session session)

listDistrito

public List<Object[]> listDistrito(String provincia,
 org.hibernate.Session session)

listCorregimiento

public List<Object[]> listCorregimiento(String provincia,
 String distrito,
 org.hibernate.Session session)

listBarrios

public List<Object[]> listBarrios(String provincia,
 String distrito,
 String corregimiento,
 String localidad,
 org.hibernate.Session session)

querySearchBarriosSoundex

public List<Object[]> querySearchBarriosSoundex(String word,
 Integer limit,
 org.hibernate.Session session)

searchMunicipalityByState

public List<SQLResults> searchMunicipalityByState(OfferingTypeEnum offering,
 PropertyTypeEnum type,
 String state,
 org.hibernate.Session session)

searchColonyByMunicipality

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

searchMunicipalityAndColonyByState

public SQLResultsMC searchMunicipalityAndColonyByState(OfferingTypeEnum offering,
 PropertyTypeEnum type,
 String state,
 org.hibernate.Session session)

searchMunicipalityByStateWithFilters

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

searchColonyByMunicipalityWithFilters

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

getNamesWithURL

public NamesSpaces getNamesWithURL(String state,
 String municipality,
 String colony,
 OfferingTypeEnum offering,
 PropertyTypeEnum type,
 org.hibernate.Session session)

getPlacesByWord

public SQLResultWord getPlacesByWord(PropertyTypeEnum type,
 OfferingTypeEnum offering,
 String word,
 org.hibernate.Session session)

getPlacesByWordAndOfficeId

public SQLResultWord getPlacesByWordAndOfficeId(PropertyTypeEnum type,
 OfferingTypeEnum offering,
 StatusTypeEnum status,
 String word,
 Long officeId,
 org.hibernate.Session session)

getColonyByPath

public ColonyLocation getColonyByPath(String path,
 org.hibernate.Session session)

getOfferingsByPath

public List<LocationSitemap> getOfferingsByPath(String path,
 org.hibernate.Session session)

getTypesByPath

public List<LocationSitemap> getTypesByPath(String path,
 org.hibernate.Session session)

getLocationsByPath

public List<LocationSitemapOT> getLocationsByPath(String path,
 org.hibernate.Session session)

getLocationSearch

public List<SearchLocation> getLocationSearch(String location,
 Integer level,
 org.hibernate.Session session)