ru.bgcrm.dao

Class AddressDistributionDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.AddressDistributionDAO

public class AddressDistributionDAO
extends CommonDAO

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_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
AddressDistributionDAO(java.sql.Connection con)

Method Summary

Methods

Modifier and Type	Method and Description
void	addHouseToUser(ru.bgcrm.struts.action.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	getGroupIdByQuarter(int distrId, int quarter)
java.util.List<IdTitle>	getGroupQuarters(int distrId, int groupId)
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<IdTitle>	getUserHouses(int userId, java.lang.String quarterMask, java.lang.String streetMask, java.lang.String houseMask)
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

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

Constructor Detail

AddressDistributionDAO

public AddressDistributionDAO(java.sql.Connection con)

Method Detail

addHouseToUser

public void addHouseToUser(ru.bgcrm.struts.action.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

getGroupQuarters

public java.util.List<IdTitle> getGroupQuarters(int distrId,
                                       int groupId)
                                         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