Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-41021

Date/Time screens for Signup events: confirmed and waitlisted

    Details

    • Type: Feature Request
    • Status: CLOSED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 20.0 [Tentative]
    • Fix Version/s: 19.0, 20.0 [Tentative]
    • Component/s: Signup
    • Labels:
      None
    • 19 status:
      Resolved
    • Test Plan:
      Hide
      1. Go to any site as an instructor and go to the Signup tool
      2. Create a new Meeting
      3. Add members to the "Participant" and "Wait" lists in any time slot. -> The members are added with the date and time
      4. Enter to the same site as a student and go to the Signup tool
      5. Sign up to any timeslot of the Meeting in the participant list -> The student is in the participant list without showing date or time
      6. Sign up to another timeslot of the Meeting in the wait list -> The student is in the wait list without showing date or time
      7. Enter again as the instructor to the same site and go to Signup tool
      8. Enter to the Meeting -> The student is in the 2 lists with the respective dates and times
      9. Remove students from the participant list until the application moves one student from the wait list to the participant list -> The student is now in the participant list but with the current date and time
      Show
      Go to any site as an instructor and go to the Signup tool Create a new Meeting Add members to the "Participant" and "Wait" lists in any time slot. -> The members are added with the date and time Enter to the same site as a student and go to the Signup tool Sign up to any timeslot of the Meeting in the participant list -> The student is in the participant list without showing date or time Sign up to another timeslot of the Meeting in the wait list -> The student is in the wait list without showing date or time Enter again as the instructor to the same site and go to Signup tool Enter to the Meeting -> The student is in the 2 lists with the respective dates and times Remove students from the participant list until the application moves one student from the wait list to the participant list -> The student is now in the participant list but with the current date and time

      Description

      On several occasions we have received petitions from our instructors demanding a way to know the order in which the students have signed up to the events, as well as the date and hour.

      After some research, we discovered that, with the database structure we have at this moment, this isn't possible (see attached snapshots showing the database model of the tables involved).
      Currently there are no columns to store the date signup up, nor, if the student removes their sign-up from the event, there is no record for this either, the row is just deleted.

      Allowing instructors to access these details would be a great improvement for this tool.

      Taking all the information stated above into account, we consider that at least we would need to make the following changes:

      • Add one column to the tables "SIGNUP_TS_ATTENDEES" y "SIGNUP_TS_WAITINGLIST" to store the "INSCRIPTION_DATE".
      • Modify the tool to add this attibute to the respective class, to add the logic needed to admin this information and to modify the Hibernate mapping.
      • Add the date of inscription in the list of attendes and in the waiting list. keeping current orders (attendees by name and waiting lists by order of suscription).
      • Add  the date of inscription in the Excel files exported. 

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  adrianmticarum Adrian Martinez
                  Reporter:
                  adrianmticarum Adrian Martinez
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code