Package ru.bgcrm.dao.work
Class ShiftDAO
java.lang.Object
ru.bgcrm.dao.CommonDAO
ru.bgcrm.dao.work.ShiftDAO
-
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 -
Method Summary
Modifier and TypeMethodDescriptionvoidaddCallboardTask(int process_id, int group, int team, int graph, Date date) voiddeleteCallboardTask(int process_id) voiddeleteCallboardTask(int process_id, int group, int team, int graph, Date date) voiddeleteShift(int id) voiddeleteWorkShift(int graphId, int groupId, int userId, Date date) findSameWorkShift(WorkShift workShift) getAvailableDateForShift(CallboardConfig.Callboard callboard, Map<Integer, List<Integer>> groupWithUsersMap, Date fromDate, Date toDate) getDateTaskList(Date date) getMonthlyWorkShift(int userId, Date dateFrom, Date dateTo) getMonthWorkShift(Date date, int groupId) intgetSameWorkTypeShiftCount(int workTypeId, int workShiftId, int time_from, int time_to) getShift(int id) getShift(int id, int category) static ShiftgetShiftList(int category) getShiftList(Set<Integer> shiftIds) getShiftOrder(int graphId, int groupId) getUserShifts(CallboardConfig.Callboard callboard, Date fromDate, Date toDate) getUsersWorkShift(int graphId, int shiftId, Date dateFrom, Date dateTo, List<Integer> userIds) getWorkShift(int graphId, int groupId, int userId, Date date) getWorkShift(CallboardConfig.Callboard callboard, Date fromDate, Date toDate, Map<Integer, List<Integer>> groupWithUsersSet) getWorkShifts(int graphId, Date dateFrom, Date dateTo) getWorkShiftSetFor(Date date, int userId) booleanisTimeOccupied(int group, int team, int graph, Date date) voidsearchShift(SearchResult<Shift> searchResult, int category) voidsetDynamicShiftTime(int workShiftId, int timeBegin, int timeEnd) voidupdateShift(Shift shift) voidupdateShiftOrder(int graphId, int groupId, Map<Integer, Integer> orderMap) voidupdateWorkShift(WorkShift workShift) 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
-
ShiftDAO
-
-
Method Details
-
searchShift
- Throws:
BGException
-
getShiftList
- Throws:
BGException
-
getShiftList
- Throws:
BGException
-
getAllShiftMap
- Throws:
BGException
-
getShiftFromRs
- Throws:
BGException
-
getShift
- Throws:
BGException
-
getShift
- Throws:
BGException
-
deleteShift
- Throws:
BGException
-
updateShift
- Throws:
BGException
-
getWorkShifts
- Throws:
BGException
-
getWorkShift
- Throws:
BGException
-
getWorkShift
public Map<Integer,List<WorkShift>> getWorkShift(CallboardConfig.Callboard callboard, Date fromDate, Date toDate, Map<Integer, List<Integer>> groupWithUsersSet) throws BGException- Throws:
BGException
-
getAvailableDateForShift
-
getUserShifts
public Map<Integer,Map<Date, getUserShiftsWorkShift>> (CallboardConfig.Callboard callboard, Date fromDate, Date toDate) throws BGException - Throws:
BGException
-
getMonthlyWorkShift
public Map<Date,Set<WorkShift>> getMonthlyWorkShift(int userId, Date dateFrom, Date dateTo) throws BGException - Throws:
BGException
-
getWorkShiftSetFor
- Throws:
BGException
-
getMonthWorkShift
- Throws:
BGException
-
updateWorkShift
- Throws:
BGException
-
deleteWorkShift
- Throws:
BGException
-
addCallboardTask
public void addCallboardTask(int process_id, int group, int team, int graph, Date date) throws BGException - Throws:
BGException
-
deleteCallboardTask
public void deleteCallboardTask(int process_id, int group, int team, int graph, Date date) throws BGException - Throws:
BGException
-
deleteCallboardTask
- Throws:
BGException
-
isTimeOccupied
- Throws:
BGException
-
getDateTaskList
- Throws:
BGException
-
findSameWorkShift
- Throws:
BGException
-
updateShiftOrder
public void updateShiftOrder(int graphId, int groupId, Map<Integer, Integer> orderMap) throws BGException- Throws:
BGException
-
getShiftOrder
- Throws:
BGException
-
setDynamicShiftTime
- Throws:
BGException
-
getSameWorkTypeShiftCount
public int getSameWorkTypeShiftCount(int workTypeId, int workShiftId, int time_from, int time_to) throws BGException - Throws:
BGException
-
getUsersWorkShift
public List<WorkShift> getUsersWorkShift(int graphId, int shiftId, Date dateFrom, Date dateTo, List<Integer> userIds) throws BGException - Throws:
BGException
-