MediaMate

Currently the reservation system could use some improvement.

Users can resevere a movie that is currently out. However, there is no notification of when the movie they reserved comes back in so they can actually borrow it. Additionally, without manual checks there is no way for an administrator to know that a recently returned movie is requested/reserved by another user.

Beyond all of this, the system does not allow multiple people to reserve the movie. If it is already reserved there is nothing you can do. Perhaps some sort of FIFO reservation system. So multiple people can request the same movie and notifications for them will trigger in order.

These notifications need to be automated. There are several potential hook points that can be used. For instance when a movie is returned an immediate check can be made to see if anyone has the movie reserved. If they do, display a notice to the user returning the movie (if they are an administrator) and/or send an e-mail to the admin/user that the movie is now available (possibly include a link to the movie).

When an administrator logs in, alert them of any pending reservations where the movies are currently available. This list should be grouped by reserving user. As should any reservation listing.