ru.bgcrm.dao.work

Class SegmentDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.work.SegmentDAO

public class SegmentDAO
extends CommonDAO

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SegmentDAO.Purpose

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

Method Summary

Modifier and Type	Method and Description
void	deleteSegments(int graphId, int groupId, int userId, java.util.Date dt)
void	fillIntervals(java.util.List<WorkInterval> intervals, java.util.List<PonoProcess> processes)
java.util.List<PonoProcess>	filterProcesses(java.util.List<PonoProcess> processes, java.util.List<CitySegment> segments)
java.util.List<PonoProcess>	filterProcessesByCity(java.util.List<PonoProcess> processes, int cityId)
java.util.List<PonoProcess>	filterProcessesByDate(java.util.List<PonoProcess> processes, java.util.Date dt)
java.util.Map<SegmentKey,java.util.List<WorkInterval>>	getAllIntervalsMap(java.util.Date dateFrom, java.util.Date dateTo)
java.util.List<PonoProcess>	getAllPonoProcesses(SegmentDAO.Purpose purpose, java.util.Date dateFrom, java.util.Date dateTo)
java.util.Map<SegmentKey,java.util.List<CitySegment>>	getAllSegmentsMap(java.util.Date dateFrom, java.util.Date dateTo)
java.util.Date	getLastOpWorkDate()
java.util.Date	getLastOpWorkDateInCity(int cityId, java.lang.String segment)
java.util.Map<java.lang.Integer,java.util.Date>	getLastOpWorkDatesInCities()
java.util.Map<CitySegment,java.util.Date>	getLastOpWorkDatesInCitySegments()
java.util.List<IdTitle>	getPonoCityIdTitles(java.util.Date dateFrom, java.util.Date dateTo, int groupId)
java.util.List<WorkInterval>	getPonoIntervalsNewConnection(int cityId, java.lang.String segment)
java.util.List<WorkInterval>	getPonoIntervalsStatEpp(int cityId, java.util.Date dateFrom, java.util.Date dateTo)
java.util.List<CitySegment>	getPonoWorkCitySegments(int cityId, java.util.Date dateFrom, java.util.Date dateTo)
java.util.List<CitySegment>	getPonoWorkCitySegments(int cityId, java.lang.String segment, java.util.Date dateFrom, java.util.Date dateTo)
java.util.List<SegmentKey>	getSegmentKeyList(java.util.Map<SegmentKey,java.util.List<CitySegment>> allSegmentMap, int cityId, java.util.Date dt)
java.util.Map<SegmentKey,java.util.Map<java.lang.Integer,java.util.List<java.lang.String>>>	getSegmentMap(java.util.Date dateFrom, java.util.Date dateTo)
java.util.Map<SegmentKey,java.util.Map<java.lang.String,java.lang.String>>	getSegmentsCellsDataMap(java.util.Date dateFrom, java.util.Date dateTo)
java.util.List<CitySegment>	getWorkersArea(java.util.Map<SegmentKey,java.util.List<CitySegment>> allSegmentMap, java.util.List<SegmentKey> segmentKeyList)
java.util.List<WorkInterval>	getWorkersIntervals(java.util.Map<SegmentKey,java.util.List<WorkInterval>> allIntervalsMap, java.util.List<SegmentKey> segmentKeyList)
void	insertSegment(Segment segment)
boolean	isOpInCity(int cityId, java.lang.String segment)
java.util.List<CitySegment>	parseCitySegments(java.lang.String url)
java.util.List<PonoProcess>	tailProcesses(java.util.List<PonoProcess> processes, java.util.Date dt)

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

SegmentDAO

public SegmentDAO(java.sql.Connection con)

Method Detail

getSegmentsCellsDataMap

public java.util.Map<SegmentKey,java.util.Map<java.lang.String,java.lang.String>> getSegmentsCellsDataMap(java.util.Date dateFrom,
                                                                                                          java.util.Date dateTo)
                                                                                                   throws BGException

Throws:

BGException

getSegmentMap

public java.util.Map<SegmentKey,java.util.Map<java.lang.Integer,java.util.List<java.lang.String>>> getSegmentMap(java.util.Date dateFrom,
                                                                                                                 java.util.Date dateTo)
                                                                                                          throws BGException

Throws:

BGException

deleteSegments

public void deleteSegments(int graphId,
                           int groupId,
                           int userId,
                           java.util.Date dt)
                    throws BGException

Throws:

BGException

insertSegment

public void insertSegment(Segment segment)
                   throws BGException

Throws:

BGException

parseCitySegments

public java.util.List<CitySegment> parseCitySegments(java.lang.String url)

getPonoCityIdTitles

public java.util.List<IdTitle> getPonoCityIdTitles(java.util.Date dateFrom,
                                                   java.util.Date dateTo,
                                                   int groupId)
                                            throws BGException

Throws:

BGException

isOpInCity

public boolean isOpInCity(int cityId,
                          java.lang.String segment)
                   throws BGException

Throws:

BGException

getAllPonoProcesses

public java.util.List<PonoProcess> getAllPonoProcesses(SegmentDAO.Purpose purpose,
                                                       java.util.Date dateFrom,
                                                       java.util.Date dateTo)
                                                throws BGException

Throws:

BGException

getPonoWorkCitySegments

public java.util.List<CitySegment> getPonoWorkCitySegments(int cityId,
                                                           java.util.Date dateFrom,
                                                           java.util.Date dateTo)
                                                    throws BGException

Throws:

BGException

getPonoWorkCitySegments

public java.util.List<CitySegment> getPonoWorkCitySegments(int cityId,
                                                           java.lang.String segment,
                                                           java.util.Date dateFrom,
                                                           java.util.Date dateTo)
                                                    throws BGException

Throws:

BGException

filterProcesses

public java.util.List<PonoProcess> filterProcesses(java.util.List<PonoProcess> processes,
                                                   java.util.List<CitySegment> segments)
                                            throws BGException

Throws:

BGException

getPonoIntervalsStatEpp

public java.util.List<WorkInterval> getPonoIntervalsStatEpp(int cityId,
                                                            java.util.Date dateFrom,
                                                            java.util.Date dateTo)
                                                     throws BGException

Throws:

BGException

getPonoIntervalsNewConnection

public java.util.List<WorkInterval> getPonoIntervalsNewConnection(int cityId,
                                                                  java.lang.String segment)
                                                           throws BGException

Throws:

BGException

fillIntervals

public void fillIntervals(java.util.List<WorkInterval> intervals,
                          java.util.List<PonoProcess> processes)
                   throws BGException

Throws:

BGException

getLastOpWorkDateInCity

public java.util.Date getLastOpWorkDateInCity(int cityId,
                                              java.lang.String segment)
                                       throws BGException

Throws:

BGException

getLastOpWorkDate

public java.util.Date getLastOpWorkDate()
                                 throws BGException

Throws:

BGException

getLastOpWorkDatesInCities

public java.util.Map<java.lang.Integer,java.util.Date> getLastOpWorkDatesInCities()
                                                                           throws BGException

Throws:

BGException

getLastOpWorkDatesInCitySegments

public java.util.Map<CitySegment,java.util.Date> getLastOpWorkDatesInCitySegments()
                                                                           throws BGException

Throws:

BGException

tailProcesses

public java.util.List<PonoProcess> tailProcesses(java.util.List<PonoProcess> processes,
                                                 java.util.Date dt)
                                          throws BGException

Throws:

BGException

getAllSegmentsMap

public java.util.Map<SegmentKey,java.util.List<CitySegment>> getAllSegmentsMap(java.util.Date dateFrom,
                                                                               java.util.Date dateTo)
                                                                        throws BGException

Throws:

BGException

getSegmentKeyList

public java.util.List<SegmentKey> getSegmentKeyList(java.util.Map<SegmentKey,java.util.List<CitySegment>> allSegmentMap,
                                                    int cityId,
                                                    java.util.Date dt)
                                             throws BGException

Throws:

BGException

getWorkersArea

public java.util.List<CitySegment> getWorkersArea(java.util.Map<SegmentKey,java.util.List<CitySegment>> allSegmentMap,
                                                  java.util.List<SegmentKey> segmentKeyList)
                                           throws BGException

Throws:

BGException

getAllIntervalsMap

public java.util.Map<SegmentKey,java.util.List<WorkInterval>> getAllIntervalsMap(java.util.Date dateFrom,
                                                                                 java.util.Date dateTo)
                                                                          throws BGException

Throws:

BGException

getWorkersIntervals

public java.util.List<WorkInterval> getWorkersIntervals(java.util.Map<SegmentKey,java.util.List<WorkInterval>> allIntervalsMap,
                                                        java.util.List<SegmentKey> segmentKeyList)
                                                 throws BGException

Throws:

BGException

filterProcessesByDate

public java.util.List<PonoProcess> filterProcessesByDate(java.util.List<PonoProcess> processes,
                                                         java.util.Date dt)
                                                  throws BGException

Throws:

BGException

filterProcessesByCity

public java.util.List<PonoProcess> filterProcessesByCity(java.util.List<PonoProcess> processes,
                                                         int cityId)
                                                  throws BGException

Throws:

BGException