Class BQueryProperty

java.lang.Object

com.maplander.backend.utils.bquery.BQueryProperty

public class BQueryProperty
extends Object

Constructor Summary

Constructors

Constructor	Description
BQueryProperty()

Method Summary

Modifier and Type	Method	Description
static void	buildDeleteByUserId(Long userId)
static StringBuilder	buildQuery(FiltersBigQuery filter, boolean agent)
static StringBuilder	buildQueryClasificationJoin(FiltersBigQuery filter)
static StringBuilder	buildQueryColonyLocation(FiltersBigQuery filter, String state_name, String municipaly_name, String colony_name, Integer level, boolean agent)
static StringBuilder	buildQueryDeletePropertyByOffice(Long officeId)
static String	buildQueryInterested(Integer limit, Integer cursor, Long clientId)
static StringBuilder	buildQueryPolygonId(FiltersBigQuery filter, boolean agent)
static StringBuilder	buildQueryPropertyDashBoard(FiltersBigQuery filter, String sku)
static StringBuilder	buildQueryPropertyLite(FiltersBigQuery filter)
static StringBuilder	buildQueryPropertyLiteClasificationJoin(FiltersBigQuery filter)
static StringBuilder	buildQueryPropertyLiteColonyLocation(FiltersBigQuery filter, String state_name, String municipaly_name, String colony_name, Integer level)
static StringBuilder	buildQueryPropertyLitePolygonId(FiltersBigQuery filter)
static String	buildQueryPropertyToExpire()
static StringBuilder	buildQuerySizeProperty()
static StringBuilder	buildQuerySKU(String sku)
static StringBuilder	buildQueryTotal(FiltersBigQuery filter)
static StringBuilder	buildQueryTotalPropertiesByUser(Long userId, StatusTypeEnum status)
static StringBuilder	buildQueryUpdatePropertyByOffice(Long officeId, StatusTypeEnum status)
static List<PropertyLite>	listInterested(String query)
static int	totalByStatusAndOfficeId(Long officeId, StatusTypeEnum status)
static int	totalByStatusAndUserId(Long userId, StatusTypeEnum status)

Methods inherited from class java.lang.Object

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

Constructor Details

BQueryProperty

public BQueryProperty()

Method Details

buildQuery

public static StringBuilder buildQuery(FiltersBigQuery filter,
 boolean agent)

buildQueryPolygonId

public static StringBuilder buildQueryPolygonId(FiltersBigQuery filter,
 boolean agent)

buildQueryColonyLocation

public static StringBuilder buildQueryColonyLocation(FiltersBigQuery filter,
 String state_name,
 String municipaly_name,
 String colony_name,
 Integer level,
 boolean agent)

buildQuerySKU

public static StringBuilder buildQuerySKU(String sku)

buildQueryClasificationJoin

public static StringBuilder buildQueryClasificationJoin(FiltersBigQuery filter)

buildQueryPropertyLiteClasificationJoin

public static StringBuilder buildQueryPropertyLiteClasificationJoin(FiltersBigQuery filter)

buildQueryPropertyLite

public static StringBuilder buildQueryPropertyLite(FiltersBigQuery filter)

buildQueryPropertyLitePolygonId

public static StringBuilder buildQueryPropertyLitePolygonId(FiltersBigQuery filter)

buildQueryPropertyLiteColonyLocation

public static StringBuilder buildQueryPropertyLiteColonyLocation(FiltersBigQuery filter,
 String state_name,
 String municipaly_name,
 String colony_name,
 Integer level)

buildQueryPropertyDashBoard

public static StringBuilder buildQueryPropertyDashBoard(FiltersBigQuery filter,
 String sku)

buildQueryTotal

public static StringBuilder buildQueryTotal(FiltersBigQuery filter)

buildQueryTotalPropertiesByUser

public static StringBuilder buildQueryTotalPropertiesByUser(Long userId,
 StatusTypeEnum status)

buildQueryPropertyToExpire

public static String buildQueryPropertyToExpire()

buildQueryInterested

public static String buildQueryInterested(Integer limit,
 Integer cursor,
 Long clientId)

listInterested

public static List<PropertyLite> listInterested(String query)

buildDeleteByUserId

public static void buildDeleteByUserId(Long userId)

totalByStatusAndOfficeId

public static int totalByStatusAndOfficeId(Long officeId,
 StatusTypeEnum status)

totalByStatusAndUserId

public static int totalByStatusAndUserId(Long userId,
 StatusTypeEnum status)

buildQueryDeletePropertyByOffice

public static StringBuilder buildQueryDeletePropertyByOffice(Long officeId)

buildQueryUpdatePropertyByOffice

public static StringBuilder buildQueryUpdatePropertyByOffice(Long officeId,
 StatusTypeEnum status)

buildQuerySizeProperty

public static StringBuilder buildQuerySizeProperty()