Package 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	Description
ShiftDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
void	addCallboardTask(int process_id, int group, int team, int graph, Date date)
void	deleteCallboardTask(int process_id)
void	deleteCallboardTask(int process_id, int group, int team, int graph, Date date)
void	deleteShift(int id)
void	deleteWorkShift(int graphId, int groupId, int userId, Date date)
List<WorkShift>	findSameWorkShift(WorkShift workShift)
Map<Integer,Shift>	getAllShiftMap()
Map<Integer,Map<Integer,Set<Date>>>	getAvailableDateForShift(CallboardConfig.Callboard callboard, Map<Integer,List<Integer>> groupWithUsersMap, Date fromDate, Date toDate)
List<CallboardTask>	getDateTaskList(Date date)
Map<Date,Set<WorkShift>>	getMonthlyWorkShift(int userId, Date dateFrom, Date dateTo)
Map<Date,Set<WorkShift>>	getMonthWorkShift(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(ResultSet rs)
List<Shift>	getShiftList(int category)
List<Shift>	getShiftList(Set<Integer> shiftIds)
Map<Integer,Integer>	getShiftOrder(int graphId, int groupId)
Map<Integer,Map<Date,WorkShift>>	getUserShifts(CallboardConfig.Callboard callboard, Date fromDate, Date toDate)
List<WorkShift>	getUsersWorkShift(int graphId, int shiftId, Date dateFrom, Date dateTo, List<Integer> userIds)
WorkShift	getWorkShift(int graphId, int groupId, int userId, Date date)
Map<Integer,List<WorkShift>>	getWorkShift(CallboardConfig.Callboard callboard, Date fromDate, Date toDate, Map<Integer,List<Integer>> groupWithUsersSet)
List<WorkShift>	getWorkShifts(int graphId, Date dateFrom, Date dateTo)
Set<WorkShift>	getWorkShiftSetFor(Date date, int userId)
boolean	isTimeOccupied(int group, int team, int graph, 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, Map<Integer,Integer> orderMap)
void	updateWorkShift(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

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

ShiftDAO

public ShiftDAO(Connection con)

Method Details

searchShift

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

Throws:

BGException

getShiftList

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

Throws:

BGException

getShiftList

public List<Shift> getShiftList(Set<Integer> shiftIds)
                         throws BGException

Throws:

BGException

getAllShiftMap

public Map<Integer,Shift> getAllShiftMap()
                                  throws BGException

Throws:

BGException

getShiftFromRs

public static Shift getShiftFromRs(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 List<WorkShift> getWorkShifts(int graphId,
 Date dateFrom,
 Date dateTo)
                              throws BGException

Throws:

BGException

getWorkShift

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

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

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

getUserShifts

public Map<Integer,Map<Date,WorkShift>> getUserShifts(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

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

Throws:

BGException

getMonthWorkShift

public Map<Date,Set<WorkShift>> getMonthWorkShift(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,
 Date date)
                     throws BGException

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

public void deleteCallboardTask(int process_id)
                         throws BGException

Throws:

BGException

isTimeOccupied

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

Throws:

BGException

getDateTaskList

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

Throws:

BGException

findSameWorkShift

public List<WorkShift> findSameWorkShift(WorkShift workShift)
                                  throws BGException

Throws:

BGException

updateShiftOrder

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

Throws:

BGException

getShiftOrder

public Map<Integer,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 List<WorkShift> getUsersWorkShift(int graphId,
 int shiftId,
 Date dateFrom,
 Date dateTo,
 List<Integer> userIds)
                                  throws BGException

Throws:

BGException