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

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.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, 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
AnalyticDAO(java.sql.Connection con)

Method Summary

Methods

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

Methods inherited from class ru.bgcrm.dao.AddressDAO

addHouseSelectQueryJoins, checkItem, 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

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

Field Detail

TABLE_ANALYTIC_HOUSE_CAPACITY

public static final java.lang.String TABLE_ANALYTIC_HOUSE_CAPACITY

See Also:

Constant Field Values

Constructor Detail

AnalyticDAO

public AnalyticDAO(java.sql.Connection con)

Method Detail

getHouseCapacityList

public java.util.List<HouseCapacity> getHouseCapacityList(java.lang.String name,
                                                 Period period)
                                                   throws java.lang.Exception

Throws:

java.lang.Exception

getHouseCapacityItemList

public java.util.List<HouseCapacityItem> getHouseCapacityItemList(int houseId)
                                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getHouseCapacityItem

public HouseCapacityItem getHouseCapacityItem(int houseId,
                                     java.lang.String serviceType,
                                     java.util.Date date)
                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

updateHouseCapacityItem

public void updateHouseCapacityItem(HouseCapacityItem houseCapacityItem)
                             throws java.sql.SQLException

Throws:

java.sql.SQLException

deleteHouseCapacityItem

public void deleteHouseCapacityItem(int houseId)
                             throws java.sql.SQLException

Throws:

java.sql.SQLException