Package ru.bgcrm.dao

Class AnalyticDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.AddressDAO

ru.bgcrm.dao.AnalyticDAO

public class AnalyticDAO
extends AddressDAO

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 String	TABLE_ANALYTIC_HOUSE_CAPACITY

Fields inherited from class ru.bgcrm.dao.AddressDAO

LOAD_LEVEL_CITY, LOAD_LEVEL_COUNTRY, LOAD_LEVEL_HOUSE, LOAD_LEVEL_STREET, 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
AnalyticDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
void	deleteHouseCapacityItem(int houseId)
List<HouseCapacityItem>	getHouseCapacityItemList(int houseId)
void	updateHouseCapacityItem(HouseCapacityItem houseCapacityItem)

Methods inherited from class ru.bgcrm.dao.AddressDAO

addHouseSelectQueryJoins, checkItem, deleteAddressArea, deleteAddressCity, deleteAddressCountry, deleteAddressHouse, deleteAddressQuarter, deleteAddressStreet, getAddressAgglomerationFromRs, getAddressArea, getAddressCity, getAddressCityAgglomeration, getAddressCityFromRs, getAddressCountry, getAddressCountryFromRs, getAddressHouse, getAddressHouseFromRs, getAddressItemFromRs, getAddressQuarter, getAddressStreet, getAddressStreetsBySubstring, getAddressSubjectAreaFromRs, getAddressSubjectFromRs, getAgglomerationByCity, getAgglomerationByHouseId, getCitiesByAgglomeration, getCitiesList, getCitiesMap, getCityIdByAddress, getCityIdsByAgglomerationId, getCityTitle, getCountryIdByCityId, getHouseIdsByStreetAndHouse, getHouseListByTerm, getQuartersInCitiesMap, getQuartersList, getSegmentsInCitiesMap, getSegmentsList, getUpdatedAreas, getUpdatedCities, getUpdatedCountries, getUpdatedHouses, getUpdatedQuarters, getUpdatedStreets, searchAddressAgglomerationList, searchAddressAreaList, searchAddressAreaList, searchAddressCityList, searchAddressCountryList, searchAddressHouseList, searchAddressHouseList, searchAddressHouseList, searchAddressQuarterList, searchAddressQuarterList, searchAddressQuarterList, searchAddressStreetList, searchAddressStreetList, searchAddressStreetList, searchFullAddressList, updateAddressArea, updateAddressCity, updateAddressCityAgglomeration, updateAddressCountry, updateAddressHouse, updateAddressQuarter, updateAddressStreet, updateLastUpdateColumn

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

TABLE_ANALYTIC_HOUSE_CAPACITY

public static final String TABLE_ANALYTIC_HOUSE_CAPACITY

See Also:

• Constant Field Values

Constructor Details

AnalyticDAO

public AnalyticDAO(Connection con)

Method Details

getHouseCapacityItemList

public List<HouseCapacityItem> getHouseCapacityItemList(int houseId)
                                                 throws SQLException

Throws:

SQLException

updateHouseCapacityItem

public void updateHouseCapacityItem(HouseCapacityItem houseCapacityItem)
                             throws SQLException

Throws:

SQLException

deleteHouseCapacityItem

public void deleteHouseCapacityItem(int houseId)
                             throws SQLException

Throws:

SQLException