Package 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	Description
static final int	LOAD_LEVEL_CITY
static final int	LOAD_LEVEL_COUNTRY
static final int	LOAD_LEVEL_HOUSE
static final int	LOAD_LEVEL_STREET
static final 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	Description
AddressDAO(Connection con)

Method Summary

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

buildPlaceholders, deleteById, execute, execute, execute, executeBatch, 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 Details

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 Details

AddressDAO

public AddressDAO(Connection con)

Method Details

searchAddressCountryList

public void searchAddressCountryList(SearchResult<AddressCountry> searchResult,
 String title)
                              throws SQLException

Throws:

SQLException

getAddressCountry

public AddressCountry getAddressCountry(int id)
                                 throws SQLException

Throws:

SQLException

searchAddressAgglomerationList

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

Throws:

SQLException

getAgglomerationByCity

@Nullable
public @Nullable AddressAgglomeration getAgglomerationByCity(int cityId)

getAddressCityAgglomeration

@Deprecated
public AddressAgglomeration getAddressCityAgglomeration(int cityId)
                                                 throws SQLException

Deprecated.

Throws:

SQLException

See Also:

• getAgglomerationByCity(int)

searchAddressCityList

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

Throws:

SQLException

getAddressCity

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

Throws:

SQLException

searchAddressAreaList

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

Throws:

SQLException

searchAddressAreaList

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

Throws:

SQLException

getAddressArea

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

Throws:

SQLException

searchAddressQuarterList

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

Throws:

SQLException

searchAddressQuarterList

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

Throws:

SQLException

searchAddressQuarterList

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

getAddressQuarter

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

Throws:

SQLException

searchAddressStreetList

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

Throws:

SQLException

searchAddressStreetList

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

Throws:

SQLException

searchAddressStreetList

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

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

Throws:

SQLException

getAddressStreet

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

Throws:

SQLException

searchFullAddressList

public List<String> searchFullAddressList(String title)
                                   throws SQLException

Throws:

SQLException

getAgglomerationByHouseId

@Nullable
public @Nullable AddressAgglomeration getAgglomerationByHouseId(int houseId)
                                                         throws BGException

Throws:

BGException

searchAddressHouseList

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

Throws:

SQLException

searchAddressHouseList

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

Throws:

SQLException

searchAddressHouseList

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

Throws:

SQLException

getAddressHouse

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

Throws:

BGException

addHouseSelectQueryJoins

public void addHouseSelectQueryJoins(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 PreparedStatement checkItem(int id,
 String table,
 String title)
                            throws SQLException,
BGMessageException

Throws:

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 SQLException

Throws:

SQLException

updateLastUpdateColumn

public void updateLastUpdateColumn(int id)
                            throws SQLException

Throws:

SQLException

deleteAddressHouse

public void deleteAddressHouse(int id)
                        throws BGException

Throws:

BGException

getAddressHouseFromRs

public static AddressHouse getAddressHouseFromRs(ResultSet rs,
 String prefix,
 int loadLevel)
                                          throws SQLException

Throws:

SQLException

getAddressItemFromRs

public static AddressItem getAddressItemFromRs(ResultSet rs,
 String prefix)
                                        throws SQLException

Throws:

SQLException

getAddressSubjectAreaFromRs

public static AddressSubjectArea getAddressSubjectAreaFromRs(ResultSet rs,
 String prefix)
                                                      throws SQLException

Throws:

SQLException

getAddressSubjectFromRs

public static AddressSubject getAddressSubjectFromRs(ResultSet rs,
 String prefix)
                                              throws SQLException

Throws:

SQLException

getAddressCountryFromRs

public static AddressCountry getAddressCountryFromRs(ResultSet rs,
 String prefix)
                                              throws SQLException

Throws:

SQLException

getAddressAgglomerationFromRs

public static AddressAgglomeration getAddressAgglomerationFromRs(ResultSet rs,
 String prefix)
                                                          throws SQLException

Throws:

SQLException

getAddressCityFromRs

public static AddressCity getAddressCityFromRs(ResultSet rs,
 String prefix)
                                        throws SQLException

Throws:

SQLException

getUpdatedCountries

public List<AddressCountry> getUpdatedCountries(long time,
 List<Integer> countriesId)
                                         throws SQLException

Throws:

SQLException

getUpdatedCities

public List<AddressCity> getUpdatedCities(long time,
 List<Integer> citiesId)
                                   throws SQLException

Throws:

SQLException

getUpdatedHouses

public List<AddressHouse> getUpdatedHouses(long time,
 List<Integer> citiesId)
                                    throws SQLException

Throws:

SQLException

getUpdatedAreas

public List<AddressItem> getUpdatedAreas(long time,
 List<Integer> citiesId)
                                  throws SQLException

Throws:

SQLException

getUpdatedQuarters

public List<AddressItem> getUpdatedQuarters(long time,
 List<Integer> citiesId)
                                     throws SQLException

Throws:

SQLException

getUpdatedStreets

public List<AddressItem> getUpdatedStreets(long time,
 List<Integer> citiesId)
                                    throws SQLException

Throws:

SQLException

getCountryIdByCityId

public List<Integer> getCountryIdByCityId(List<Integer> countryIds)
                                   throws SQLException

Throws:

SQLException

getAddressStreetsBySubstring

public List<AddressItem> getAddressStreetsBySubstring(String streetTitleLike,
 List<Integer> cityIds)
                                               throws SQLException

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

Parameters:

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

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

Returns:

Throws:

SQLException

getCityIdByAddress

public int getCityIdByAddress(String address)
                       throws SQLException

Throws:

SQLException

getHouseIdsByStreetAndHouse

public List<Integer> getHouseIdsByStreetAndHouse(int streetId,
 String house,
 List<Integer> cityIds)
                                          throws SQLException

Throws:

SQLException

getCitiesByAgglomeration

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

Throws:

BGException

getCityIdsByAgglomerationId

public Set<Integer> getCityIdsByAgglomerationId(int agglomerationId)
                                         throws SQLException

Throws:

SQLException

getCityTitle

public String getCityTitle(int cityId)
                    throws BGException

Throws:

BGException

getCitiesList

public List<IdTitle> getCitiesList()
                            throws BGException

Throws:

BGException

getCitiesMap

public Map<Integer,String> getCitiesMap()
                                 throws BGException

Throws:

BGException

getQuartersList

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

Throws:

BGException

getQuartersInCitiesMap

public Map<Integer,List<IdTitle>> getQuartersInCitiesMap()
                                                  throws BGException

Throws:

BGException

getSegmentsList

public List<String> getSegmentsList(int cityId)
                             throws BGException

Throws:

BGException

getSegmentsInCitiesMap

public Map<IdTitle,List<String>> getSegmentsInCitiesMap(List<Integer> cityIds)
                                                 throws BGException

Throws:

BGException

getHouseListByTerm

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

Throws:

BGException