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

Fields inherited from class ru.bgcrm.dao.CommonDAO

con, log, SQL_AND, SQL_DELETE, SQL_DELETE_FROM, SQL_DESC, SQL_DISTINCT, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT, SQL_INSERT_IGNORE, SQL_INSERT_INTO, SQL_LEFT_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UNION_ALL, SQL_UPDATE, SQL_VALUES, SQL_WHERE

Constructor Summary

Constructors

Constructor	Description
AnalyticDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
void	deleteHouseCapacityItem(int houseId)
HouseCapacityItem	getHouseCapacityItem(int houseId, String serviceType, Date date)
List<HouseCapacityItem>	getHouseCapacityItemList(int houseId)
List<HouseCapacity>	getHouseCapacityList(String name, Period period)
void	updateHouseCapacityItem(HouseCapacityItem houseCapacityItem)

Methods inherited from class ru.bgcrm.dao.AddressDAO

addHouseSelectQueryJoins, deleteAddressArea, deleteAddressCity, deleteAddressCountry, deleteAddressHouse, deleteAddressQuarter, deleteAddressStreet, getAddressArea, getAddressCity, getAddressCityFromRs, getAddressCountry, getAddressCountryFromRs, getAddressHouse, getAddressHouseFromRs, getAddressItemFromRs, getAddressQuarter, getAddressStreet, getAddressStreetsBySubstring, getCityIdByAddress, getCountryIdByCityId, getHouseIdsByStreetAndHouse, getUpdatedAreas, getUpdatedCities, getUpdatedCountries, getUpdatedHouses, getUpdatedQuarters, getUpdatedStreets, searchAddressAreaList, searchAddressAreaList, searchAddressCityList, searchAddressCountryList, searchAddressHouseList, searchAddressHouseList, searchAddressQuarterList, searchAddressQuarterList, searchAddressStreetList, searchAddressStreetList, updateAddressArea, updateAddressCity, updateAddressCountry, updateAddressHouse, updateAddressQuarter, updateAddressStreet

Methods inherited from class ru.bgcrm.dao.CommonDAO

deleteById, foundRows, getById, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePatternEnd, getLikePatternStart, getLikePatternSub, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, update, updateColumn, updateIds, updateIds, updateOrInsert

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

getHouseCapacityList

public List<HouseCapacity> getHouseCapacityList(String name,
 Period period)
                                         throws Exception

Throws:

Exception

getHouseCapacityItemList

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

Throws:

SQLException

getHouseCapacityItem

public HouseCapacityItem getHouseCapacityItem(int houseId,
 String serviceType,
 Date date)
                                       throws SQLException

Throws:

SQLException

updateHouseCapacityItem

public void updateHouseCapacityItem(HouseCapacityItem houseCapacityItem)
                             throws SQLException

Throws:

SQLException

deleteHouseCapacityItem

public void deleteHouseCapacityItem(int houseId)
                             throws SQLException

Throws:

SQLException