Please enable JavaScript.

Coggle requires JavaScript to display documents.

iTrain - Coggle Diagram

- - - - Show information regarding upcoming training session
      - Show number of training sessions student has attended during the term for each of their sports so far
    - - Show a table of all training sessions attended to in said month and year. .
      - Student selects month and year
    - - Student selects grade, team (letter), week
      - Show a table of all training session available in that week for that team (comprised of year and letter)
  - - - Show information such as what teams they are covering for the week and their respective sports
        
        Show their upcoming training session that they are checking in for
    - - Show a table displaying information such as the date and time the training session is on, the location and what team they are covering for + the respective sport. .
        
        Roster for the next week will uploaded near the start of the current week to notify officials early, giving them enough time to clear their schedule or give a call about unavailability
    - - Select the date for the NA, specify the time range that you are unavailable for by inputting start time and end time or select 'Can not work at all today'. There will be an option for 'I Can work today' if the official wants to go back and remove the unavailability. Official then submits availability for that day.
        
        Official's will only be able to submit availabilities for the days in the week after next week. This gives the admin time to assign officials to each
    - - Provide select menu to allow user to select the training session they are covering. Training sessions displayed are the assigned to the official and are starting in 5mins or are going to start today.
        
        Provide success/error messages such as unrecognised student to inform user of any mistakes or completed processes
    - - Provide select menu which contains the official's teams as options
        
        Display table containing student name, if they attended, and if so, at what time they attended. If there is no training session on that day then display '[team name] had no training sessions on that day'
  - - - Pick a team and a table will appear showing each player's attendance tally within a summary period (week/term/semester)
    - - Managing team names and team members
        
        tables containing all the teams with remove buttons. Rows can be clicked which takes user to a page containing a table which showcases the team members of the team the user clicked
        
        Input to enter in team name and activity or enter in student email to create a new team or enlist a student
    - - User inputs student email and table appears with student's teams and how many training sessions they attended for the semester
    - - tables containing all training sessions. Filter by activity then select team then table shows training sessions for that team. Only training sessions that are yet to happen can be removed/edited. Past ones can not be touched.
    - - Query Engine
- - - - MeekroDB has a perfect security track record. No bugs relating to security or SQL injection have ever been discovered.
  - - - Terrace Images are free to use
- - - - Saying 'Error with username or password' is safer
  - - - Check if scode/username aligns with any usernames in database
        
        Check if hashed password under that username in DB is the same as the hashed inputted password
        
        If username and password aligns with a stored user - allow access to user-level specific features of the system
  - - - Display all training session, attendee (student names). Display by team and time period (week, term, semester)
    - - Insert training session details into database
    - - Insert Official details into database
    - - Select an event and select available organizers (based on datetimes in NA table) to take attends for that event. Add orgid under the eid of the selected event
    - - Admins type up name into search box and the respective email will appear for the admin to select
  - - - Select Event and scan barcode
        
        Insert event, time attended, scode, and organizer ID into database
        
        Student can only be scanned for attendance once
        
        User can be a registered user, or they cannot, and still be recorded for attendance. Must check if scode is in database, however.
        
        Events that can be selected by the official are the ones that the admin has assigned to them
        
        Time window of -5mins start of training session and end of training session
    - - Choose date and specify time range of unavailablity
      - Insert NA (datetime) into database under official's id
    - - Official specifies sport and team. List all training sessions currently made for the team of that sport. Select the training session they wish to view attendances for. List all students assigned to that team and sport and show whether or not they attended that specific training session.
      - Also provide a tally fore each student on training session selection page?
    - - Get training ids for which the logged in official's id is assigned to. Retrieve the training session id information such as start time and the team and sport they are covering, location etc.
  - - - Retrieve all the training sessions for term for the team the student is assigned to from database
    - - If scode exists and the scode does not have a corresponding password, the password is put into the database for scode password column
    - - Student specifies a certain date/week. Retrieve all training session attendances during that week