Package 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	Description
static enum	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	Description
SegmentDAO(Connection con)

Method Summary

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

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

SegmentDAO

public SegmentDAO(Connection con)

Method Details

getSegmentsCellsDataMap

public Map<SegmentKey,Map<String,String>> getSegmentsCellsDataMap(Date dateFrom,
 Date dateTo)
                                                           throws BGException

Throws:

BGException

getSegmentMap

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

Throws:

BGException

deleteSegments

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

Throws:

BGException

insertSegment

public void insertSegment(Segment segment)
                   throws BGException

Throws:

BGException

parseCitySegments

public List<CitySegment> parseCitySegments(String url)

getPonoCityIdTitles

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

Throws:

BGException

isOpInCity

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

Throws:

BGException

getAllPonoProcesses

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

Throws:

BGException

getPonoWorkCitySegments

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

Throws:

BGException

getPonoWorkCitySegments

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

Throws:

BGException

filterProcesses

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

Throws:

BGException

getPonoIntervalsStatEpp

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

Throws:

BGException

getPonoIntervalsNewConnection

public List<WorkInterval> getPonoIntervalsNewConnection(int cityId,
 String segment)
                                                 throws BGException

Throws:

BGException

fillIntervals

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

Throws:

BGException

getLastOpWorkDateInCity

public Date getLastOpWorkDateInCity(int cityId,
 String segment)
                             throws BGException

Throws:

BGException

getLastOpWorkDate

public Date getLastOpWorkDate()
                       throws BGException

Throws:

BGException

getLastOpWorkDatesInCities

public Map<Integer,Date> getLastOpWorkDatesInCities()
                                             throws BGException

Throws:

BGException

getLastOpWorkDatesInCitySegments

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

Throws:

BGException

tailProcesses

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

Throws:

BGException

getAllSegmentsMap

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

Throws:

BGException

getSegmentKeyList

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

Throws:

BGException

getWorkersArea

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

Throws:

BGException

getAllIntervalsMap

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

Throws:

BGException

getWorkersIntervals

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

Throws:

BGException

filterProcessesByDate

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

Throws:

BGException

filterProcessesByCity

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

Throws:

BGException