ru.bgcrm.dao

Class AddressDistributionDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.AddressDistributionDAO

public class AddressDistributionDAO
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 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 and Description
AddressDistributionDAO(java.sql.Connection con)

Method Summary

Modifier and Type	Method and Description
void	addHouseToUser(AddressDistributionAction.Distribution distr, int userId, java.lang.String[] houseIds)
void	addQuarterToGroup(java.util.Set<java.lang.Integer> quarterSet, int distrId, int groupId)
void	freeUserHouses(int userId)
java.util.List<java.util.Map<java.lang.String,java.lang.String>>	getAllHouses(java.util.List<java.lang.Integer> cityIds)
int	getFlatCount(int userId)
int	getGroupIdByQuarter(int distrId, int quarter)
java.util.Map<java.lang.Integer,java.util.Set<java.lang.Integer>>	getGroupQuarterMap(int groupId)
java.util.List<IdTitle>	getGroupQuarters(int distrId, int groupId)
java.util.List<IdTitle>	getGroupQuarters(int distrId, int groupId, int cityId)
java.util.List<IdTitle>	getUndistributedGroups(int distrId, java.util.List<java.lang.Integer> cityIds)
java.util.List<IdTitle>	getUndistributedHouses(int distrId, java.util.List<java.lang.Integer> cityIds, java.lang.String quarterMask, java.lang.String streetMask, java.lang.String houseMask)
User	getUserByHouseId(int distrId, int houseId)
java.util.List<IdTitleComment>	getUserGroupHouses(int userId)
java.util.List<IdTitle>	getUserHouses(int userId, java.lang.String quarterMask, java.lang.String streetMask, java.lang.String houseMask)
java.util.List<IdTitle>	getUserQuarters(int userId)
void	removeHouse(int userId, int distrId, java.lang.String[] hid)
void	removeQuarters(int distrId)
void	removeQuarters(int distrId, int groupId, java.util.Set<java.lang.Integer> quarters)

Methods inherited from class ru.bgcrm.dao.CommonDAO

deleteById, execute, execute, execute, 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

Constructor Detail

AddressDistributionDAO

public AddressDistributionDAO(java.sql.Connection con)

Method Detail

addHouseToUser

public void addHouseToUser(AddressDistributionAction.Distribution distr,
                           int userId,
                           java.lang.String[] houseIds)
                    throws java.sql.SQLException,
                           BGException

Throws:

java.sql.SQLException

BGException

removeHouse

public void removeHouse(int userId,
                        int distrId,
                        java.lang.String[] hid)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getAllHouses

public java.util.List<java.util.Map<java.lang.String,java.lang.String>> getAllHouses(java.util.List<java.lang.Integer> cityIds)
                                                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

freeUserHouses

public void freeUserHouses(int userId)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

getUserHouses

public java.util.List<IdTitle> getUserHouses(int userId,
                                             java.lang.String quarterMask,
                                             java.lang.String streetMask,
                                             java.lang.String houseMask)
                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getUndistributedHouses

public java.util.List<IdTitle> getUndistributedHouses(int distrId,
                                                      java.util.List<java.lang.Integer> cityIds,
                                                      java.lang.String quarterMask,
                                                      java.lang.String streetMask,
                                                      java.lang.String houseMask)
                                               throws java.sql.SQLException

Throws:

java.sql.SQLException

getUndistributedGroups

public java.util.List<IdTitle> getUndistributedGroups(int distrId,
                                                      java.util.List<java.lang.Integer> cityIds)
                                               throws BGException

Throws:

BGException

getUserByHouseId

public User getUserByHouseId(int distrId,
                             int houseId)
                      throws BGException

Throws:

BGException

addQuarterToGroup

public void addQuarterToGroup(java.util.Set<java.lang.Integer> quarterSet,
                              int distrId,
                              int groupId)
                       throws BGException

Throws:

BGException

getUserQuarters

public java.util.List<IdTitle> getUserQuarters(int userId)
                                        throws BGException

Throws:

BGException

getUserGroupHouses

public java.util.List<IdTitleComment> getUserGroupHouses(int userId)
                                                  throws BGException

Throws:

BGException

getGroupQuarters

public java.util.List<IdTitle> getGroupQuarters(int distrId,
                                                int groupId)
                                         throws BGException

Throws:

BGException

getGroupQuarters

public java.util.List<IdTitle> getGroupQuarters(int distrId,
                                                int groupId,
                                                int cityId)
                                         throws BGException

Throws:

BGException

removeQuarters

public void removeQuarters(int distrId)
                    throws BGException

Throws:

BGException

removeQuarters

public void removeQuarters(int distrId,
                           int groupId,
                           java.util.Set<java.lang.Integer> quarters)
                    throws BGException

Throws:

BGException

getGroupIdByQuarter

public int getGroupIdByQuarter(int distrId,
                               int quarter)
                        throws BGException

Throws:

BGException

getFlatCount

public int getFlatCount(int userId)
                 throws BGException

Throws:

BGException

getGroupQuarterMap

public java.util.Map<java.lang.Integer,java.util.Set<java.lang.Integer>> getGroupQuarterMap(int groupId)
                                                                                     throws BGException

Throws:

BGException