Class ShiftDAO

    • Constructor Detail

      • ShiftDAO

        public ShiftDAO​(java.sql.Connection con)
    • Method Detail

      • getShiftList

        public java.util.List<Shift> getShiftList​(java.util.Set<java.lang.Integer> shiftIds)
                                           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​(int graphId,
                                                                                                                  java.util.Date fromDate,
                                                                                                                  java.util.Date toDate)
                                                                                                           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
      • 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
      • 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