Package scheduler.Dao

Class daoReports

  • public class daoReports
extends java.lang.Object
    Class to manage all report level DAO functions

    • Constructor Summary

      Constructors 
      Constructor Description
      daoReports()  

    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static javafx.collections.ObservableList<Appointment> appointmentByContactDAO​(int ContactID)
      Returns a list of appointments associated with a specific Contact.
      static int returnNumberOfAppointmentsThisWeekDAO()
      Returns the sum of appointments that's start time falls in the next 7 calendar days.
      static int returnNumberOfAppointmentsTodayDAO()
      Returns the sum of appointments that have start times that fall between the current time, and the end of the current business day.
      static int returnNumberOfAppointmentsTomorrowDAO()
      Returns the number of appointments that are scheduled for the next business day.
      static javafx.collections.ObservableList<Type> returnTypeAggregatesDAO​(java.lang.String month)
      Returns the number of appointments sorted by Type of appointment.

      • Methods inherited from class java.lang.Object

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

    • Constructor Detail

      • daoReports

        public daoReports()

    • Method Detail

      • returnTypeAggregatesDAO

        public static javafx.collections.ObservableList<Type> returnTypeAggregatesDAO​(java.lang.String month)
        Returns the number of appointments sorted by Type of appointment. Result is returned as an Observable list of "Type" objects, which consist of The type description string, and the the aggregate number of appointments of that type.
        Parameters:
        month - , String representing the month being reported on
        Returns:
        Observable list, Type objects

      • appointmentByContactDAO

        public static javafx.collections.ObservableList<Appointment> appointmentByContactDAO​(int ContactID)
        Returns a list of appointments associated with a specific Contact.
        Parameters:
        ContactID - Integer, ID of the desired contact.
        Returns:
        An Observable list of appointments associated with the contact. List will be empty if there are no associated appointments.

      • returnNumberOfAppointmentsTodayDAO

        public static int returnNumberOfAppointmentsTodayDAO()
        Returns the sum of appointments that have start times that fall between the current time, and the end of the current business day.
        Returns:
        Integer, number of appointments left in the business day.

      • returnNumberOfAppointmentsTomorrowDAO

        public static int returnNumberOfAppointmentsTomorrowDAO()
        Returns the number of appointments that are scheduled for the next business day.
        Returns:
        Integer, sum of appointments.

      • returnNumberOfAppointmentsThisWeekDAO

        public static int returnNumberOfAppointmentsThisWeekDAO()
        Returns the sum of appointments that's start time falls in the next 7 calendar days.
        Returns:
        Integer, number of appointments.