Package ru.bgcrm.dao.work
Class SegmentDAO
java.lang.Object
ru.bgcrm.dao.CommonDAO
ru.bgcrm.dao.work.SegmentDAO
-
Nested Class Summary
Nested ClassesNested 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 -
Method Summary
Modifier and TypeMethodDescriptionvoiddeleteSegments(int graphId, int groupId, int userId, Date dt) voidfillIntervals(List<WorkInterval> intervals, List<PonoProcess> processes) filterProcesses(List<PonoProcess> processes, List<CitySegment> segments) filterProcessesByCity(List<PonoProcess> processes, int cityId) filterProcessesByDate(List<PonoProcess> processes, Date dt) getAllIntervalsMap(Date dateFrom, Date dateTo) getAllPonoProcesses(SegmentDAO.Purpose purpose, Date dateFrom, Date dateTo) getAllSegmentsMap(Date dateFrom, Date dateTo) getLastOpWorkDateInCity(int cityId, String segment) getPonoCityIdTitles(Date dateFrom, Date dateTo, int groupId) getPonoIntervalsNewConnection(int cityId, String segment) getPonoIntervalsStatEpp(int cityId, Date dateFrom, Date dateTo) getPonoWorkCitySegments(int cityId, String segment, Date dateFrom, Date dateTo) getPonoWorkCitySegments(int cityId, Date dateFrom, Date dateTo) getSegmentKeyList(Map<SegmentKey, List<CitySegment>> allSegmentMap, int cityId, Date dt) getSegmentMap(Date dateFrom, Date dateTo) getSegmentsCellsDataMap(Date dateFrom, Date dateTo) getWorkersArea(Map<SegmentKey, List<CitySegment>> allSegmentMap, List<SegmentKey> segmentKeyList) getWorkersIntervals(Map<SegmentKey, List<WorkInterval>> allIntervalsMap, List<SegmentKey> segmentKeyList) voidinsertSegment(Segment segment) booleanisOpInCity(int cityId, String segment) parseCitySegments(String url) 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
-
Constructor Details
-
SegmentDAO
-
-
Method Details
-
getSegmentsCellsDataMap
public Map<SegmentKey,Map<String, getSegmentsCellsDataMapString>> (Date dateFrom, Date dateTo) throws BGException - Throws:
BGException
-
getSegmentMap
public Map<SegmentKey,Map<Integer, getSegmentMapList<String>>> (Date dateFrom, Date dateTo) throws BGException - Throws:
BGException
-
deleteSegments
- Throws:
BGException
-
insertSegment
- Throws:
BGException
-
parseCitySegments
-
getPonoCityIdTitles
public List<IdTitle> getPonoCityIdTitles(Date dateFrom, Date dateTo, int groupId) throws BGException - Throws:
BGException
-
isOpInCity
- 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
- Throws:
BGException
-
getLastOpWorkDate
- Throws:
BGException
-
getLastOpWorkDatesInCities
- Throws:
BGException
-
getLastOpWorkDatesInCitySegments
- Throws:
BGException
-
tailProcesses
- 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
-