Package 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	Description
AddressDistributionDAO(Connection con)

Method Summary

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

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

Constructor Details

AddressDistributionDAO

public AddressDistributionDAO(Connection con)

Method Details

addHouseToUser

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

Throws:

SQLException

BGException

removeHouse

public void removeHouse(int userId,
 int distrId,
 String[] hid)
                 throws SQLException

Throws:

SQLException

getAllHouses

public List<Map<String,String>> getAllHouses(List<Integer> cityIds)
                                      throws SQLException

Throws:

SQLException

freeUserHouses

public void freeUserHouses(int userId)
                    throws SQLException

Throws:

SQLException

getUserHouses

public List<IdTitle> getUserHouses(int userId,
 String quarterMask,
 String streetMask,
 String houseMask)
                            throws SQLException

Throws:

SQLException

getUndistributedHouses

public List<IdTitle> getUndistributedHouses(int distrId,
 List<Integer> cityIds,
 String quarterMask,
 String streetMask,
 String houseMask)
                                     throws SQLException

Throws:

SQLException

getUndistributedGroups

public List<IdTitle> getUndistributedGroups(int distrId,
 List<Integer> cityIds)
                                     throws BGException

Throws:

BGException

getUserByHouseId

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

Throws:

BGException

addQuarterToGroup

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

Throws:

BGException

getUserQuarters

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

Throws:

BGException

getUserGroupHouses

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

Throws:

BGException

getGroupQuarters

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

Throws:

BGException

getGroupQuarters

public 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,
 Set<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 Map<Integer,Set<Integer>> getGroupQuarterMap(int groupId)
                                             throws BGException

Throws:

BGException