ru.bgcrm.dao

Class ShiftDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.ShiftDAO

public class ShiftDAO
extends CommonDAO

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_LEFT_JOIN, SQL_LIMIT, 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

Methods

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.List<CallboardTask>	getDateTaskList(java.util.Date date)
java.util.Map<java.util.Date,java.util.Set<WorkShift>>	getMonthWorkShift(java.util.Date date, int groupId)
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.util.Set<WorkShift>>	getWorkShift(int graphId, java.util.Date fromDate, java.util.Date toDate, java.util.Map<java.lang.Integer,java.util.Set<java.lang.Integer>> groupWithUsersSet)
WorkShift	getWorkShift(int graphId, int groupId, int userId, java.util.Date date)
boolean	isTimeOccupied(int group, int team, int graph, java.util.Date date)
void	searchShift(SearchResult<Shift> searchResult, int category)
void	updateShift(Shift shift)
void	updateWorkShift(WorkShift workShift)

Methods inherited from class ru.bgcrm.dao.CommonDAO

addLikeSql, convertDateToSqlDate, convertDateToTimestamp, deleteById, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, 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

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.Set<WorkShift>> getWorkShift(int graphId,
                                                                     java.util.Date fromDate,
                                                                     java.util.Date toDate,
                                                                     java.util.Map<java.lang.Integer,java.util.Set<java.lang.Integer>> groupWithUsersSet)
                                                                       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