Class OfficeRepository

java.lang.Object

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

com.maplander.backend.repository.OfficeRepository

public class OfficeRepository
extends RepositoryBase<Office,Long>

Field Summary

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

sessionFactory

Constructor Summary

Constructors

Constructor	Description
OfficeRepository(org.hibernate.SessionFactory sessionFactory)

Method Summary

Modifier and Type	Method	Description
Integer	countAllUsers(org.hibernate.Session session)
int	countOfficeByPolygon(List<com.utils.geo.GeoPt> polygon, String brand, org.hibernate.Session session)
Integer	countOfficeFirgum(String office, org.hibernate.Session session)
Long	countOffices(org.hibernate.Session session)
Integer	countUserFirgum(String user, org.hibernate.Session session)
Long	countUsers(org.hibernate.Session session)
List<OfficeLite>	fetchOfficeLite()
List<AccountLite>	findAccountLite(FilterAccount filter, Integer limit, Integer offset, org.hibernate.Session session)
List<Object[]>	findAccountLiteByOfficeName(String officeName, Integer limit, Integer cursor, org.hibernate.Session session)
List<AccountLite>	findAccountLiteRandom(int size, org.hibernate.Session session)
List<Object[]>	findOfficesByColony(String colonyName, org.hibernate.Session session)
List<Object[]>	findPlacesOfficeByWord(String word, org.hibernate.Session session)
List<Object[]>	getNamesWithURLOffice(String state, String municipality, String colony, org.hibernate.Session session)
List<FirgumUser>	getUserFirgum(Integer limit, Integer cursor, org.hibernate.Session session)
List<Object[]>	queryOfficeByLocation(com.utils.geo.GeoPt location, Double distance, String brand, org.hibernate.Session session)
List<Object[]>	queryOfficeByPolygon(List<com.utils.geo.GeoPt> polygon, String brand, org.hibernate.Session session)
List<Object[]>	queryOfficeByPolygonPaged(List<com.utils.geo.GeoPt> polygon, String brand, Integer limit, Integer cursor, org.hibernate.Session session)
List<Object[]>	queryOfficeLiteMap(String state, String municipality, String colony, Integer limit, Integer cursor, org.hibernate.Session session)
List<Object[]>	querySearchAccountMap(LocationTypeEnum locationType, String state, String municipality, String colony, org.hibernate.Session session)
List<AccountMap>	searchOfficeFirgum(String office, Integer limit, Integer cursor, org.hibernate.Session session)
List<Object[]>	searchOfficeLiteForSite(LocationTypeEnum locationType, String state, String municipality, String colony, org.hibernate.Session session)
List<Object[]>	searchStockOffice(LocationTypeEnum locationType, String state, String municipality, org.hibernate.Session session)
List<FirgumUser>	searchUserFirgum(String user, Integer limit, Integer cursor, 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

OfficeRepository

public OfficeRepository(org.hibernate.SessionFactory sessionFactory)

Method Details

fetchOfficeLite

public List<OfficeLite> fetchOfficeLite()

countOffices

public Long countOffices(org.hibernate.Session session)

countUsers

public Long countUsers(org.hibernate.Session session)

findAccountLiteByOfficeName

public List<Object[]> findAccountLiteByOfficeName(String officeName,
 Integer limit,
 Integer cursor,
 org.hibernate.Session session)

findAccountLite

public List<AccountLite> findAccountLite(FilterAccount filter,
 Integer limit,
 Integer offset,
 org.hibernate.Session session)

findAccountLiteRandom

public List<AccountLite> findAccountLiteRandom(int size,
 org.hibernate.Session session)

findOfficesByColony

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

searchStockOffice

public List<Object[]> searchStockOffice(LocationTypeEnum locationType,
 String state,
 String municipality,
 org.hibernate.Session session)

getNamesWithURLOffice

public List<Object[]> getNamesWithURLOffice(String state,
 String municipality,
 String colony,
 org.hibernate.Session session)

searchOfficeLiteForSite

public List<Object[]> searchOfficeLiteForSite(LocationTypeEnum locationType,
 String state,
 String municipality,
 String colony,
 org.hibernate.Session session)

queryOfficeLiteMap

public List<Object[]> queryOfficeLiteMap(String state,
 String municipality,
 String colony,
 Integer limit,
 Integer cursor,
 org.hibernate.Session session)

findPlacesOfficeByWord

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

queryOfficeByPolygon

public List<Object[]> queryOfficeByPolygon(List<com.utils.geo.GeoPt> polygon,
 String brand,
 org.hibernate.Session session)

queryOfficeByLocation

public List<Object[]> queryOfficeByLocation(com.utils.geo.GeoPt location,
 Double distance,
 String brand,
 org.hibernate.Session session)

querySearchAccountMap

public List<Object[]> querySearchAccountMap(LocationTypeEnum locationType,
 String state,
 String municipality,
 String colony,
 org.hibernate.Session session)

countOfficeByPolygon

public int countOfficeByPolygon(List<com.utils.geo.GeoPt> polygon,
 String brand,
 org.hibernate.Session session)

queryOfficeByPolygonPaged

public List<Object[]> queryOfficeByPolygonPaged(List<com.utils.geo.GeoPt> polygon,
 String brand,
 Integer limit,
 Integer cursor,
 org.hibernate.Session session)

searchUserFirgum

public List<FirgumUser> searchUserFirgum(String user,
 Integer limit,
 Integer cursor,
 org.hibernate.Session session)

countUserFirgum

public Integer countUserFirgum(String user,
 org.hibernate.Session session)

searchOfficeFirgum

public List<AccountMap> searchOfficeFirgum(String office,
 Integer limit,
 Integer cursor,
 org.hibernate.Session session)

countOfficeFirgum

public Integer countOfficeFirgum(String office,
 org.hibernate.Session session)

getUserFirgum

public List<FirgumUser> getUserFirgum(Integer limit,
 Integer cursor,
 org.hibernate.Session session)

countAllUsers

public Integer countAllUsers(org.hibernate.Session session)