ru.bgcrm.plugin.fias.dao

Class FiasDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.plugin.fias.dao.FiasDAO

public class FiasDAO
extends CommonDAO

Field Summary

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_LEFT_JOIN, SQL_LIMIT, 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
FiasDAO(java.sql.Connection con)

Method Summary

Methods

Modifier and Type	Method and Description
void	addHouseLinks(java.lang.String fiasStreetId, java.lang.Integer crmCityId)
void	addStreetLink(java.lang.Integer crmStreetId, java.lang.String fiasStreetId)
void	copyPostalCode(java.util.List<java.lang.Integer> fiasHouseIds)
void	copyStreetTitle(java.lang.String streetId)
void	delHouseLink(java.lang.String fiasHouseId)
void	delStreetLink(java.lang.String fiasStreetId)
java.lang.String	getFiasStreetPostalCode(java.lang.String fiasStreetId)
static FiasHouse	getHouseFromRs(java.sql.ResultSet rs)
java.util.List<java.lang.Integer>	getLinkHouseIdList(java.lang.String fiasStreetId)
java.util.List<CrmHouse>	getNotLinkHouseList(SearchResult<CrmHouse> searchResult, java.lang.String fiasStreetId, java.lang.String indexTerm, java.lang.Integer streetSide)
static FiasStreet	getStreetFromRs(java.sql.ResultSet rs)
void	manualSetPostalCode(java.util.Set<java.lang.Integer> crmHouseIds, java.lang.String postalCode)
java.util.List<java.lang.String>	recommendedPostalCodeList(java.lang.String fiasStreetId)
void	searchAddressStreetByTerm(SearchResult<AddressItem> searchResult, int cityId, java.lang.String titleTerm)
void	searchFiasHouseByTerm(SearchResult<FiasHouse> searchResult, java.lang.String streetId, java.lang.String indexTerm, java.lang.Integer cityId, java.lang.Integer streetSide)
void	searchFiasStreetByTerm(SearchResult<FiasStreet> searchResult, java.lang.String titleTerm, java.lang.Integer cityId, boolean hasLink)
void	searchSimilarStreet(SearchResult<FiasStreet> searchResult, java.lang.String title, java.lang.Integer cityId)

Methods inherited from class ru.bgcrm.dao.CommonDAO

addLikeSql, convertDateToSqlDate, convertDateToTimestamp, deleteById, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, updateColumn, updateIds, updateIds

Methods inherited from class java.lang.Object

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

Constructor Detail

FiasDAO

public FiasDAO(java.sql.Connection con)

Method Detail

searchFiasStreetByTerm

public void searchFiasStreetByTerm(SearchResult<FiasStreet> searchResult,
                          java.lang.String titleTerm,
                          java.lang.Integer cityId,
                          boolean hasLink)
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

searchSimilarStreet

public void searchSimilarStreet(SearchResult<FiasStreet> searchResult,
                       java.lang.String title,
                       java.lang.Integer cityId)
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

addStreetLink

public void addStreetLink(java.lang.Integer crmStreetId,
                 java.lang.String fiasStreetId)
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

addHouseLinks

public void addHouseLinks(java.lang.String fiasStreetId,
                 java.lang.Integer crmCityId)
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getLinkHouseIdList

public java.util.List<java.lang.Integer> getLinkHouseIdList(java.lang.String fiasStreetId)
                                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getNotLinkHouseList

public java.util.List<CrmHouse> getNotLinkHouseList(SearchResult<CrmHouse> searchResult,
                                           java.lang.String fiasStreetId,
                                           java.lang.String indexTerm,
                                           java.lang.Integer streetSide)
                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

getFiasStreetPostalCode

public java.lang.String getFiasStreetPostalCode(java.lang.String fiasStreetId)
                                         throws java.sql.SQLException

Throws:

java.sql.SQLException

recommendedPostalCodeList

public java.util.List<java.lang.String> recommendedPostalCodeList(java.lang.String fiasStreetId)
                                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getStreetFromRs

public static FiasStreet getStreetFromRs(java.sql.ResultSet rs)
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

searchAddressStreetByTerm

public void searchAddressStreetByTerm(SearchResult<AddressItem> searchResult,
                             int cityId,
                             java.lang.String titleTerm)
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

searchFiasHouseByTerm

public void searchFiasHouseByTerm(SearchResult<FiasHouse> searchResult,
                         java.lang.String streetId,
                         java.lang.String indexTerm,
                         java.lang.Integer cityId,
                         java.lang.Integer streetSide)
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getHouseFromRs

public static FiasHouse getHouseFromRs(java.sql.ResultSet rs)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

copyPostalCode

public void copyPostalCode(java.util.List<java.lang.Integer> fiasHouseIds)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

copyStreetTitle

public void copyStreetTitle(java.lang.String streetId)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

manualSetPostalCode

public void manualSetPostalCode(java.util.Set<java.lang.Integer> crmHouseIds,
                       java.lang.String postalCode)
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

delStreetLink

public void delStreetLink(java.lang.String fiasStreetId)
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

delHouseLink

public void delHouseLink(java.lang.String fiasHouseId)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException