ru.bgcrm.dao.work

Class ShiftDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.work.ShiftDAO

public class ShiftDAO
extends CommonDAO

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

Constructor and Description
ShiftDAO(java.sql.Connection con)

Method Summary

Modifier and Type	Method and Description
void	addCallboardTask(int process_id, int group, int team, int graph, java.util.Date date)
void	deleteCallboardTask(int process_id)
void	deleteCallboardTask(int process_id, int group, int team, int graph, java.util.Date date)
void	deleteShift(int id)
void	deleteWorkShift(int graphId, int groupId, int userId, java.util.Date date)
java.util.List<WorkShift>	findSameWorkShift(WorkShift workShift)
java.util.Map<java.lang.Integer,Shift>	getAllShiftMap()
java.util.Map<java.lang.Integer,java.util.Map<java.lang.Integer,java.util.Set<java.util.Date>>>	getAvailableDateForShift(CallboardConfig.Callboard callboard, java.util.Map<java.lang.Integer,java.util.List<java.lang.Integer>> groupWithUsersMap, java.util.Date fromDate, java.util.Date toDate)
java.util.List<CallboardTask>	getDateTaskList(java.util.Date date)
java.util.Map<java.util.Date,java.util.Set<WorkShift>>	getMonthlyWorkShift(int userId, java.util.Date dateFrom, java.util.Date dateTo)
java.util.Map<java.util.Date,java.util.Set<WorkShift>>	getMonthWorkShift(java.util.Date date, int groupId)
int	getSameWorkTypeShiftCount(int workTypeId, int workShiftId, int time_from, int time_to)
Shift	getShift(int id)
Shift	getShift(int id, int category)
static Shift	getShiftFromRs(java.sql.ResultSet rs)
java.util.List<Shift>	getShiftList(int category)
java.util.List<Shift>	getShiftList(java.util.Set<java.lang.Integer> shiftIds)
java.util.Map<java.lang.Integer,java.lang.Integer>	getShiftOrder(int graphId, int groupId)
java.util.Map<java.lang.Integer,java.util.Map<java.util.Date,WorkShift>>	getUserShifts(CallboardConfig.Callboard callboard, java.util.Date fromDate, java.util.Date toDate)
java.util.List<WorkShift>	getUsersWorkShift(int graphId, int shiftId, java.util.Date dateFrom, java.util.Date dateTo, java.util.List<java.lang.Integer> userIds)
java.util.Map<java.lang.Integer,java.util.List<WorkShift>>	getWorkShift(CallboardConfig.Callboard callboard, java.util.Date fromDate, java.util.Date toDate, java.util.Map<java.lang.Integer,java.util.List<java.lang.Integer>> groupWithUsersSet)
WorkShift	getWorkShift(int graphId, int groupId, int userId, java.util.Date date)
java.util.List<WorkShift>	getWorkShifts(int graphId, java.util.Date dateFrom, java.util.Date dateTo)
java.util.Set<WorkShift>	getWorkShiftSetFor(java.util.Date date, int userId)
boolean	isTimeOccupied(int group, int team, int graph, java.util.Date date)
void	searchShift(SearchResult<Shift> searchResult, int category)
void	setDynamicShiftTime(int workShiftId, int timeBegin, int timeEnd)
void	updateShift(Shift shift)
void	updateShiftOrder(int graphId, int groupId, java.util.Map<java.lang.Integer,java.lang.Integer> orderMap)
void	updateWorkShift(WorkShift workShift)

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

ShiftDAO

public ShiftDAO(java.sql.Connection con)

Method Detail

searchShift

public void searchShift(SearchResult<Shift> searchResult,
                        int category)
                 throws BGException

Throws:

BGException

getShiftList

public java.util.List<Shift> getShiftList(int category)
                                   throws BGException

Throws:

BGException

getShiftList

public java.util.List<Shift> getShiftList(java.util.Set<java.lang.Integer> shiftIds)
                                   throws BGException

Throws:

BGException

getAllShiftMap

public java.util.Map<java.lang.Integer,Shift> getAllShiftMap()
                                                      throws BGException

Throws:

BGException

getShiftFromRs

public static Shift getShiftFromRs(java.sql.ResultSet rs)
                            throws BGException

Throws:

BGException

getShift

public Shift getShift(int id,
                      int category)
               throws BGException

Throws:

BGException

getShift

public Shift getShift(int id)
               throws BGException

Throws:

BGException

deleteShift

public void deleteShift(int id)
                 throws BGException

Throws:

BGException

updateShift

public void updateShift(Shift shift)
                 throws BGException

Throws:

BGException

getWorkShifts

public java.util.List<WorkShift> getWorkShifts(int graphId,
                                               java.util.Date dateFrom,
                                               java.util.Date dateTo)
                                        throws BGException

Throws:

BGException

getWorkShift

public WorkShift getWorkShift(int graphId,
                              int groupId,
                              int userId,
                              java.util.Date date)
                       throws BGException

Throws:

BGException

getWorkShift

public java.util.Map<java.lang.Integer,java.util.List<WorkShift>> getWorkShift(CallboardConfig.Callboard callboard,
                                                                               java.util.Date fromDate,
                                                                               java.util.Date toDate,
                                                                               java.util.Map<java.lang.Integer,java.util.List<java.lang.Integer>> groupWithUsersSet)
                                                                        throws BGException

Throws:

BGException

getAvailableDateForShift

public java.util.Map<java.lang.Integer,java.util.Map<java.lang.Integer,java.util.Set<java.util.Date>>> getAvailableDateForShift(CallboardConfig.Callboard callboard,
                                                                                                                                java.util.Map<java.lang.Integer,java.util.List<java.lang.Integer>> groupWithUsersMap,
                                                                                                                                java.util.Date fromDate,
                                                                                                                                java.util.Date toDate)

getUserShifts

public java.util.Map<java.lang.Integer,java.util.Map<java.util.Date,WorkShift>> getUserShifts(CallboardConfig.Callboard callboard,
                                                                                              java.util.Date fromDate,
                                                                                              java.util.Date toDate)
                                                                                       throws BGException

Throws:

BGException

getMonthlyWorkShift

public java.util.Map<java.util.Date,java.util.Set<WorkShift>> getMonthlyWorkShift(int userId,
                                                                                  java.util.Date dateFrom,
                                                                                  java.util.Date dateTo)
                                                                           throws BGException

Throws:

BGException

getWorkShiftSetFor

public java.util.Set<WorkShift> getWorkShiftSetFor(java.util.Date date,
                                                   int userId)
                                            throws BGException

Throws:

BGException

getMonthWorkShift

public java.util.Map<java.util.Date,java.util.Set<WorkShift>> getMonthWorkShift(java.util.Date date,
                                                                                int groupId)
                                                                         throws BGException

Throws:

BGException

updateWorkShift

public void updateWorkShift(WorkShift workShift)
                     throws BGException

Throws:

BGException

deleteWorkShift

public void deleteWorkShift(int graphId,
                            int groupId,
                            int userId,
                            java.util.Date date)
                     throws BGException

Throws:

BGException

addCallboardTask

public void addCallboardTask(int process_id,
                             int group,
                             int team,
                             int graph,
                             java.util.Date date)
                      throws BGException

Throws:

BGException

deleteCallboardTask

public void deleteCallboardTask(int process_id,
                                int group,
                                int team,
                                int graph,
                                java.util.Date date)
                         throws BGException

Throws:

BGException

deleteCallboardTask

public void deleteCallboardTask(int process_id)
                         throws BGException

Throws:

BGException

isTimeOccupied

public boolean isTimeOccupied(int group,
                              int team,
                              int graph,
                              java.util.Date date)
                       throws BGException

Throws:

BGException

getDateTaskList

public java.util.List<CallboardTask> getDateTaskList(java.util.Date date)
                                              throws BGException

Throws:

BGException

findSameWorkShift

public java.util.List<WorkShift> findSameWorkShift(WorkShift workShift)
                                            throws BGException

Throws:

BGException

updateShiftOrder

public void updateShiftOrder(int graphId,
                             int groupId,
                             java.util.Map<java.lang.Integer,java.lang.Integer> orderMap)
                      throws BGException

Throws:

BGException

getShiftOrder

public java.util.Map<java.lang.Integer,java.lang.Integer> getShiftOrder(int graphId,
                                                                        int groupId)
                                                                 throws BGException

Throws:

BGException

setDynamicShiftTime

public void setDynamicShiftTime(int workShiftId,
                                int timeBegin,
                                int timeEnd)
                         throws BGException

Throws:

BGException

getSameWorkTypeShiftCount

public int getSameWorkTypeShiftCount(int workTypeId,
                                     int workShiftId,
                                     int time_from,
                                     int time_to)
                              throws BGException

Throws:

BGException

getUsersWorkShift

public java.util.List<WorkShift> getUsersWorkShift(int graphId,
                                                   int shiftId,
                                                   java.util.Date dateFrom,
                                                   java.util.Date dateTo,
                                                   java.util.List<java.lang.Integer> userIds)
                                            throws BGException

Throws:

BGException