ru.bgcrm.dao

Class AddressDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.AddressDAO

Direct Known Subclasses:

AnalyticDAO

public class AddressDAO
extends CommonDAO

Nested Class Summary

Nested classes/interfaces inherited from class ru.bgcrm.dao.CommonDAO

CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T extends Id>

Field Summary

Fields

Modifier and Type	Field and Description
static int	LOAD_LEVEL_CITY
static int	LOAD_LEVEL_COUNTRY
static int	LOAD_LEVEL_HOUSE
static int	LOAD_LEVEL_STREET
static int	PARAM_SUBJECT

Fields inherited from class ru.bgcrm.dao.CommonDAO

con, dateFormat_DDMMYYYY, dateFormat_DDMMYYYY_HHMM, log, SQL_AND, SQL_DELETE, SQL_DESC, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT, SQL_INSERT_IGNORE, SQL_LEFT_JOIN, SQL_LEFT_OUTER_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_OR, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UPDATE, SQL_WHERE

Constructor Summary

Constructors

Constructor and Description
AddressDAO(java.sql.Connection con)

Method Summary

Modifier and Type	Method and Description
void	addHouseSelectQueryJoins(java.lang.StringBuilder query, int loadLevel)
java.sql.PreparedStatement	checkItem(int id, java.lang.String table, java.lang.String title)
void	deleteAddressArea(int id)
void	deleteAddressCity(int id)
void	deleteAddressCountry(int id)
void	deleteAddressHouse(int id)
void	deleteAddressQuarter(int id)
void	deleteAddressStreet(int id)
static AddressAgglomeration	getAddressAgglomerationFromRs(java.sql.ResultSet rs, java.lang.String prefix)
AddressItem	getAddressArea(int id, boolean loadCountryData, boolean loadCityData)
AddressCity	getAddressCity(int id, boolean loadCountryData)
AddressAgglomeration	getAddressCityAgglomeration(int cityId) Deprecated.
static AddressCity	getAddressCityFromRs(java.sql.ResultSet rs, java.lang.String prefix)
AddressCountry	getAddressCountry(int id)
static AddressCountry	getAddressCountryFromRs(java.sql.ResultSet rs, java.lang.String prefix)
AddressHouse	getAddressHouse(int id, boolean loadCountryData, boolean loadCityData, boolean loadStreetData)
static AddressHouse	getAddressHouseFromRs(java.sql.ResultSet rs, java.lang.String prefix, int loadLevel)
static AddressItem	getAddressItemFromRs(java.sql.ResultSet rs, java.lang.String prefix)
AddressItem	getAddressQuarter(int id, boolean loadCountryData, boolean loadCityData)
AddressItem	getAddressStreet(int id, boolean loadCountryData, boolean loadCityData)
java.util.List<AddressItem>	getAddressStreetsBySubstring(java.lang.String streetTitleLike, java.util.List<java.lang.Integer> cityIds) Поиск улиц по подстроке в заданных городах
static AddressSubjectArea	getAddressSubjectAreaFromRs(java.sql.ResultSet rs, java.lang.String prefix)
static AddressSubject	getAddressSubjectFromRs(java.sql.ResultSet rs, java.lang.String prefix)
AddressAgglomeration	getAgglomerationByCity(int cityId)
AddressAgglomeration	getAgglomerationByHouseId(int houseId)
java.util.List<AddressCity>	getCitiesByAgglomeration(int agglomerationId)
java.util.List<IdTitle>	getCitiesList()
java.util.Map<java.lang.Integer,java.lang.String>	getCitiesMap()
int	getCityIdByAddress(java.lang.String address)
java.util.Set<java.lang.Integer>	getCityIdsByAgglomerationId(int agglomerationId)
java.lang.String	getCityTitle(int cityId)
java.util.List<java.lang.Integer>	getCountryIdByCityId(java.util.List<java.lang.Integer> countryIds)
java.util.List<java.lang.Integer>	getHouseIdsByStreetAndHouse(int streetId, java.lang.String house, java.util.List<java.lang.Integer> cityIds)
void	getHouseListByTerm(SearchResult searchResult, java.lang.String term)
java.util.Map<java.lang.Integer,java.util.List<IdTitle>>	getQuartersInCitiesMap()
java.util.List<IdTitle>	getQuartersList(int cityId)
java.util.Map<IdTitle,java.util.List<java.lang.String>>	getSegmentsInCitiesMap(java.util.List<java.lang.Integer> cityIds)
java.util.List<java.lang.String>	getSegmentsList(int cityId)
java.util.List<AddressItem>	getUpdatedAreas(long time, java.util.List<java.lang.Integer> citiesId)
java.util.List<AddressCity>	getUpdatedCities(long time, java.util.List<java.lang.Integer> citiesId)
java.util.List<AddressCountry>	getUpdatedCountries(long time, java.util.List<java.lang.Integer> countriesId)
java.util.List<AddressHouse>	getUpdatedHouses(long time, java.util.List<java.lang.Integer> citiesId)
java.util.List<AddressItem>	getUpdatedQuarters(long time, java.util.List<java.lang.Integer> citiesId)
java.util.List<AddressItem>	getUpdatedStreets(long time, java.util.List<java.lang.Integer> citiesId)
void	searchAddressAgglomerationList(SearchResult<AddressAgglomeration> searchResult)
void	searchAddressAreaList(SearchResult<AddressItem> searchResult, int cityId)
void	searchAddressAreaList(SearchResult<AddressItem> searchResult, int cityId, java.lang.String title, boolean loadCountryData, boolean loadCityData)
void	searchAddressCityList(SearchResult<AddressCity> searchResult, int countryId, java.lang.String title, boolean loadCountryData, java.util.Set<java.lang.Integer> cityIdFilter)
void	searchAddressCountryList(SearchResult<AddressCountry> searchResult, java.lang.String title)
void	searchAddressHouseList(SearchResult<AddressHouse> searchResult, int streetId, java.lang.String housePrefix)
void	searchAddressHouseList(SearchResult<AddressHouse> searchResult, int streetId, java.lang.String house, boolean absolute, boolean loadCountryData, boolean loadCityData, boolean loadStreetData)
void	searchAddressHouseList(SearchResult<AddressHouse> searchResult, java.util.Set<java.lang.Integer> streetIds, java.lang.String house, boolean absolute, boolean loadCountryData, boolean loadCityData, boolean loadStreetData)
void	searchAddressQuarterList(SearchResult<AddressItem> searchResult, int cityId)
void	searchAddressQuarterList(SearchResult<AddressItem> searchResult, int cityId, java.lang.String title, boolean loadCountryData, boolean loadCityData)
void	searchAddressQuarterList(SearchResult<AddressItem> searchResult, java.util.Set<java.lang.Integer> cityIds, java.lang.String title, boolean loadCityData)
void	searchAddressStreetList(SearchResult<AddressItem> searchResult, int cityId)
void	searchAddressStreetList(SearchResult<AddressItem> searchResult, java.util.Set<java.lang.Integer> cityIds, java.lang.String title, boolean loadCountryData, boolean loadCityData)
void	searchAddressStreetList(SearchResult<AddressItem> searchResult, java.util.Set<java.lang.Integer> cityIds, java.lang.String title, boolean loadCountryData, boolean loadCityData, boolean sorted) Ищет адреса с сортировкой
java.util.List<java.lang.String>	searchFullAddressList(java.lang.String title)
void	updateAddressArea(AddressItem addressItem)
void	updateAddressCity(AddressCity addressCity)
void	updateAddressCityAgglomeration(int cityId, int agglomerationId)
void	updateAddressCountry(AddressCountry addressCountry)
void	updateAddressHouse(AddressHouse addressHouse)
void	updateAddressQuarter(AddressItem addressItem)
void	updateAddressStreet(AddressItem addressItem)
void	updateLastUpdateColumn(int id)

Methods inherited from class ru.bgcrm.dao.CommonDAO

deleteById, execute, execute, execute, executeInsert, executeUpdate, getById, getFoundRows, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getLikePatternEnd, getLikePatternStart, getLikePatternSub, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, update, updateColumn, updateIds, updateIds

Methods inherited from class java.lang.Object

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

Field Detail

LOAD_LEVEL_HOUSE

public static final int LOAD_LEVEL_HOUSE

See Also:

Constant Field Values

LOAD_LEVEL_STREET

public static final int LOAD_LEVEL_STREET

See Also:

Constant Field Values

LOAD_LEVEL_CITY

public static final int LOAD_LEVEL_CITY

See Also:

Constant Field Values

LOAD_LEVEL_COUNTRY

public static final int LOAD_LEVEL_COUNTRY

See Also:

Constant Field Values

PARAM_SUBJECT

public static final int PARAM_SUBJECT

See Also:

Constant Field Values

Constructor Detail

AddressDAO

public AddressDAO(java.sql.Connection con)

Method Detail

searchAddressCountryList

public void searchAddressCountryList(SearchResult<AddressCountry> searchResult,
                                     java.lang.String title)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getAddressCountry

public AddressCountry getAddressCountry(int id)
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

searchAddressAgglomerationList

public void searchAddressAgglomerationList(SearchResult<AddressAgglomeration> searchResult)
                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

getAgglomerationByCity

public AddressAgglomeration getAgglomerationByCity(int cityId)

getAddressCityAgglomeration

@Deprecated
public AddressAgglomeration getAddressCityAgglomeration(int cityId)
                                                             throws java.sql.SQLException

Deprecated.

Throws:

java.sql.SQLException

See Also:

getAgglomerationByCity(int)

searchAddressCityList

public void searchAddressCityList(SearchResult<AddressCity> searchResult,
                                  int countryId,
                                  java.lang.String title,
                                  boolean loadCountryData,
                                  java.util.Set<java.lang.Integer> cityIdFilter)
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getAddressCity

public AddressCity getAddressCity(int id,
                                  boolean loadCountryData)
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

searchAddressAreaList

public void searchAddressAreaList(SearchResult<AddressItem> searchResult,
                                  int cityId)
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

searchAddressAreaList

public void searchAddressAreaList(SearchResult<AddressItem> searchResult,
                                  int cityId,
                                  java.lang.String title,
                                  boolean loadCountryData,
                                  boolean loadCityData)
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getAddressArea

public AddressItem getAddressArea(int id,
                                  boolean loadCountryData,
                                  boolean loadCityData)
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

searchAddressQuarterList

public void searchAddressQuarterList(SearchResult<AddressItem> searchResult,
                                     int cityId)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

searchAddressQuarterList

public void searchAddressQuarterList(SearchResult<AddressItem> searchResult,
                                     int cityId,
                                     java.lang.String title,
                                     boolean loadCountryData,
                                     boolean loadCityData)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

searchAddressQuarterList

public void searchAddressQuarterList(SearchResult<AddressItem> searchResult,
                                     java.util.Set<java.lang.Integer> cityIds,
                                     java.lang.String title,
                                     boolean loadCityData)

getAddressQuarter

public AddressItem getAddressQuarter(int id,
                                     boolean loadCountryData,
                                     boolean loadCityData)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

searchAddressStreetList

public void searchAddressStreetList(SearchResult<AddressItem> searchResult,
                                    int cityId)
                             throws java.sql.SQLException

Throws:

java.sql.SQLException

searchAddressStreetList

public void searchAddressStreetList(SearchResult<AddressItem> searchResult,
                                    java.util.Set<java.lang.Integer> cityIds,
                                    java.lang.String title,
                                    boolean loadCountryData,
                                    boolean loadCityData)
                             throws java.sql.SQLException

Throws:

java.sql.SQLException

searchAddressStreetList

public void searchAddressStreetList(SearchResult<AddressItem> searchResult,
                                    java.util.Set<java.lang.Integer> cityIds,
                                    java.lang.String title,
                                    boolean loadCountryData,
                                    boolean loadCityData,
                                    boolean sorted)
                             throws java.sql.SQLException

Ищет адреса с сортировкой

Throws:

java.sql.SQLException

getAddressStreet

public AddressItem getAddressStreet(int id,
                                    boolean loadCountryData,
                                    boolean loadCityData)
                             throws java.sql.SQLException

Throws:

java.sql.SQLException

searchFullAddressList

public java.util.List<java.lang.String> searchFullAddressList(java.lang.String title)
                                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

getAgglomerationByHouseId

public AddressAgglomeration getAgglomerationByHouseId(int houseId)
                                               throws BGException

Throws:

BGException

searchAddressHouseList

public void searchAddressHouseList(SearchResult<AddressHouse> searchResult,
                                   int streetId,
                                   java.lang.String housePrefix)
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

searchAddressHouseList

public void searchAddressHouseList(SearchResult<AddressHouse> searchResult,
                                   int streetId,
                                   java.lang.String house,
                                   boolean absolute,
                                   boolean loadCountryData,
                                   boolean loadCityData,
                                   boolean loadStreetData)
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

searchAddressHouseList

public void searchAddressHouseList(SearchResult<AddressHouse> searchResult,
                                   java.util.Set<java.lang.Integer> streetIds,
                                   java.lang.String house,
                                   boolean absolute,
                                   boolean loadCountryData,
                                   boolean loadCityData,
                                   boolean loadStreetData)
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

getAddressHouse

public AddressHouse getAddressHouse(int id,
                                    boolean loadCountryData,
                                    boolean loadCityData,
                                    boolean loadStreetData)
                             throws BGException

Throws:

BGException

addHouseSelectQueryJoins

public void addHouseSelectQueryJoins(java.lang.StringBuilder query,
                                     int loadLevel)

updateAddressCountry

public void updateAddressCountry(AddressCountry addressCountry)
                          throws BGException

Throws:

BGException

deleteAddressCountry

public void deleteAddressCountry(int id)
                          throws BGException

Throws:

BGException

updateAddressCity

public void updateAddressCity(AddressCity addressCity)
                       throws BGException

Throws:

BGException

updateAddressCityAgglomeration

public void updateAddressCityAgglomeration(int cityId,
                                           int agglomerationId)
                                    throws BGException

Throws:

BGException

deleteAddressCity

public void deleteAddressCity(int id)
                       throws BGException

Throws:

BGException

checkItem

public java.sql.PreparedStatement checkItem(int id,
                                            java.lang.String table,
                                            java.lang.String title)
                                     throws java.sql.SQLException,
                                            BGMessageException

Throws:

java.sql.SQLException

BGMessageException

updateAddressArea

public void updateAddressArea(AddressItem addressItem)
                       throws BGException

Throws:

BGException

updateAddressQuarter

public void updateAddressQuarter(AddressItem addressItem)
                          throws BGException

Throws:

BGException

updateAddressStreet

public void updateAddressStreet(AddressItem addressItem)
                         throws BGException

Throws:

BGException

deleteAddressArea

public void deleteAddressArea(int id)
                       throws BGException

Throws:

BGException

deleteAddressQuarter

public void deleteAddressQuarter(int id)
                          throws BGException

Throws:

BGException

deleteAddressStreet

public void deleteAddressStreet(int id)
                         throws BGException

Throws:

BGException

updateAddressHouse

public void updateAddressHouse(AddressHouse addressHouse)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

updateLastUpdateColumn

public void updateLastUpdateColumn(int id)
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

deleteAddressHouse

public void deleteAddressHouse(int id)
                        throws BGException

Throws:

BGException

getAddressHouseFromRs

public static AddressHouse getAddressHouseFromRs(java.sql.ResultSet rs,
                                                 java.lang.String prefix,
                                                 int loadLevel)
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getAddressItemFromRs

public static AddressItem getAddressItemFromRs(java.sql.ResultSet rs,
                                               java.lang.String prefix)
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getAddressSubjectAreaFromRs

public static AddressSubjectArea getAddressSubjectAreaFromRs(java.sql.ResultSet rs,
                                                             java.lang.String prefix)
                                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getAddressSubjectFromRs

public static AddressSubject getAddressSubjectFromRs(java.sql.ResultSet rs,
                                                     java.lang.String prefix)
                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getAddressCountryFromRs

public static AddressCountry getAddressCountryFromRs(java.sql.ResultSet rs,
                                                     java.lang.String prefix)
                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getAddressAgglomerationFromRs

public static AddressAgglomeration getAddressAgglomerationFromRs(java.sql.ResultSet rs,
                                                                 java.lang.String prefix)
                                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getAddressCityFromRs

public static AddressCity getAddressCityFromRs(java.sql.ResultSet rs,
                                               java.lang.String prefix)
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getUpdatedCountries

public java.util.List<AddressCountry> getUpdatedCountries(long time,
                                                          java.util.List<java.lang.Integer> countriesId)
                                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getUpdatedCities

public java.util.List<AddressCity> getUpdatedCities(long time,
                                                    java.util.List<java.lang.Integer> citiesId)
                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

getUpdatedHouses

public java.util.List<AddressHouse> getUpdatedHouses(long time,
                                                     java.util.List<java.lang.Integer> citiesId)
                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getUpdatedAreas

public java.util.List<AddressItem> getUpdatedAreas(long time,
                                                   java.util.List<java.lang.Integer> citiesId)
                                            throws java.sql.SQLException

Throws:

java.sql.SQLException

getUpdatedQuarters

public java.util.List<AddressItem> getUpdatedQuarters(long time,
                                                      java.util.List<java.lang.Integer> citiesId)
                                               throws java.sql.SQLException

Throws:

java.sql.SQLException

getUpdatedStreets

public java.util.List<AddressItem> getUpdatedStreets(long time,
                                                     java.util.List<java.lang.Integer> citiesId)
                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getCountryIdByCityId

public java.util.List<java.lang.Integer> getCountryIdByCityId(java.util.List<java.lang.Integer> countryIds)
                                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

getAddressStreetsBySubstring

public java.util.List<AddressItem> getAddressStreetsBySubstring(java.lang.String streetTitleLike,
                                                                java.util.List<java.lang.Integer> cityIds)
                                                         throws java.sql.SQLException

Поиск улиц по подстроке в заданных городах

Parameters:

streetTitleLike - подстрока поиска в формате SQL-like

cityIds - список id городов, в которых нужно искать если cityIds == null, то поиск по всем городам (город не задан)

Returns:

Throws:

java.sql.SQLException

getCityIdByAddress

public int getCityIdByAddress(java.lang.String address)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

getHouseIdsByStreetAndHouse

public java.util.List<java.lang.Integer> getHouseIdsByStreetAndHouse(int streetId,
                                                                     java.lang.String house,
                                                                     java.util.List<java.lang.Integer> cityIds)
                                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getCitiesByAgglomeration

public java.util.List<AddressCity> getCitiesByAgglomeration(int agglomerationId)
                                                     throws BGException

Throws:

BGException

getCityIdsByAgglomerationId

public java.util.Set<java.lang.Integer> getCityIdsByAgglomerationId(int agglomerationId)
                                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

getCityTitle

public java.lang.String getCityTitle(int cityId)
                              throws BGException

Throws:

BGException

getCitiesList

public java.util.List<IdTitle> getCitiesList()
                                      throws BGException

Throws:

BGException

getCitiesMap

public java.util.Map<java.lang.Integer,java.lang.String> getCitiesMap()
                                                               throws BGException

Throws:

BGException

getQuartersList

public java.util.List<IdTitle> getQuartersList(int cityId)
                                        throws BGException

Throws:

BGException

getQuartersInCitiesMap

public java.util.Map<java.lang.Integer,java.util.List<IdTitle>> getQuartersInCitiesMap()
                                                                                throws BGException

Throws:

BGException

getSegmentsList

public java.util.List<java.lang.String> getSegmentsList(int cityId)
                                                 throws BGException

Throws:

BGException

getSegmentsInCitiesMap

public java.util.Map<IdTitle,java.util.List<java.lang.String>> getSegmentsInCitiesMap(java.util.List<java.lang.Integer> cityIds)
                                                                               throws BGException

Throws:

BGException

getHouseListByTerm

public void getHouseListByTerm(SearchResult searchResult,
                               java.lang.String term)
                        throws BGException

Throws:

BGException