Class BQueryWord

java.lang.Object

com.maplander.backend.utils.bquery.BQueryWord

public class BQueryWord
extends Object

Constructor Summary

Constructors

Constructor	Description
BQueryWord()

Method Summary

Modifier and Type	Method	Description
static String	buildUpdateLocationTQuery()
static void	main(String[] args)
static StringBuilder	queryGetPolygonById(String polygonId)
static StringBuilder	queryIdRow(Integer id_row)
static StringBuilder	querySearchLocationOfficeWord(String word)
static StringBuilder	querySearchLocationWord(PropertyTypeEnum type, OfferingTypeEnum offering, String word)
static StringBuilder	querySearchLocationWordInOffice(PropertyTypeEnum type, OfferingTypeEnum offering, String word, Long officeId)
static StringBuilder	querySearchLocationWordInUser(PropertyTypeEnum type, OfferingTypeEnum offering, String word, Long userId)
static StringBuilder	querySearchLocationWordSoundex(PropertyTypeEnum type, OfferingTypeEnum offering, String word)
static StringBuilder	querySearchLocationWordSoundexAndSubstring(PropertyTypeEnum type, OfferingTypeEnum offering, String word)
static StringBuilder	querySearchLocationWordSoundexAndSubstringByOfficeId(PropertyTypeEnum type, OfferingTypeEnum offering, StatusTypeEnum status, String word, Long officeId)
static StringBuilder	querySearchLocationWordSoundexAndSubstringPolygon(PropertyTypeEnum type, OfferingTypeEnum offering, String word)
static StringBuilder	querySearchLocationWordSoundexAndSubstringPolygonMLS(PropertyTypeEnum type, OfferingTypeEnum offering, String word)
static StringBuilder	querySearchLocationWordSP(String word)
static StringBuilder	queryWord(PropertyTypeEnum type, OfferingTypeEnum offering, String word, int level)
static List<List<Double>>	resultPolygonQuery(String query)
static Integer	resultQueryOfficeId(StringBuilder query)
static SQLResultWord	resultQueryPlacesByWord(String query)
static List<com.utils.geo.GeoPt>	resultQueryPolygonByName(Integer level, String state_name, String municipaly_name, String postal_code)
static SQLResultWord	resultQueryWord(String query)
static SQLResultWord	resultQueryWordNOTotal(String query)
static SQLResultWordV2	resultQueryWordV2(String query)
static Integer	totalOfficesOrUsers(boolean office)
static Integer	totalPropertiesByOfficeId(Long officeId)

Methods inherited from class java.lang.Object

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

Constructor Details

BQueryWord

public BQueryWord()

Method Details

queryWord

public static StringBuilder queryWord(PropertyTypeEnum type,
 OfferingTypeEnum offering,
 String word,
 int level)

resultQueryWord

public static SQLResultWord resultQueryWord(String query)

resultQueryPlacesByWord

public static SQLResultWord resultQueryPlacesByWord(String query)

resultQueryWordV2

public static SQLResultWordV2 resultQueryWordV2(String query)

resultPolygonQuery

public static List<List<Double>> resultPolygonQuery(String query)

resultQueryPolygonByName

public static List<com.utils.geo.GeoPt> resultQueryPolygonByName(Integer level,
 String state_name,
 String municipaly_name,
 String postal_code)

resultQueryWordNOTotal

public static SQLResultWord resultQueryWordNOTotal(String query)

querySearchLocationWord

public static StringBuilder querySearchLocationWord(PropertyTypeEnum type,
 OfferingTypeEnum offering,
 String word)

querySearchLocationWordSP

public static StringBuilder querySearchLocationWordSP(String word)

main

public static void main(String[] args)

querySearchLocationWordInOffice

public static StringBuilder querySearchLocationWordInOffice(PropertyTypeEnum type,
 OfferingTypeEnum offering,
 String word,
 Long officeId)

querySearchLocationWordInUser

public static StringBuilder querySearchLocationWordInUser(PropertyTypeEnum type,
 OfferingTypeEnum offering,
 String word,
 Long userId)

querySearchLocationOfficeWord

public static StringBuilder querySearchLocationOfficeWord(String word)

querySearchLocationWordSoundexAndSubstring

public static StringBuilder querySearchLocationWordSoundexAndSubstring(PropertyTypeEnum type,
 OfferingTypeEnum offering,
 String word)

querySearchLocationWordSoundexAndSubstringByOfficeId

public static StringBuilder querySearchLocationWordSoundexAndSubstringByOfficeId(PropertyTypeEnum type,
 OfferingTypeEnum offering,
 StatusTypeEnum status,
 String word,
 Long officeId)

querySearchLocationWordSoundexAndSubstringPolygon

public static StringBuilder querySearchLocationWordSoundexAndSubstringPolygon(PropertyTypeEnum type,
 OfferingTypeEnum offering,
 String word)

querySearchLocationWordSoundexAndSubstringPolygonMLS

public static StringBuilder querySearchLocationWordSoundexAndSubstringPolygonMLS(PropertyTypeEnum type,
 OfferingTypeEnum offering,
 String word)

queryIdRow

public static StringBuilder queryIdRow(Integer id_row)

queryGetPolygonById

public static StringBuilder queryGetPolygonById(String polygonId)

querySearchLocationWordSoundex

public static StringBuilder querySearchLocationWordSoundex(PropertyTypeEnum type,
 OfferingTypeEnum offering,
 String word)

resultQueryOfficeId

public static Integer resultQueryOfficeId(StringBuilder query)

totalPropertiesByOfficeId

public static Integer totalPropertiesByOfficeId(Long officeId)

totalOfficesOrUsers

public static Integer totalOfficesOrUsers(boolean office)

buildUpdateLocationTQuery

public static String buildUpdateLocationTQuery()