#3 Some suggested changes for booking many resources at once
Some suggestions for improvements for reservations and
also some other suggestions we would like to use, at
the City Learning Centre in Bristol..
1. An ability in the reservation page to reserve other
resources at the same time. So say a classroom was
being reserved, it would be good to be able to reserve
equipment resources and staff under the same
reservation(possibly using drop down boxes). So a user
would have to reserve the room, and then select the
next resource tab and then reserve a piece of
equipment. Would be good so resources couldn't be
double booked.
2. Also an ability to set fields in a reservation for a
class for Year number and subject (i.e English). The
subject selection might already be implemented with the
activity selection. but renaming might be helpful.
3. In the reservation page. We would like it if we had
a field where we could fill in how many people would be
attending the reservation. For us this would be a class
size.
4. An ability to have limited resources like laptops so
they can't be double booked. I think this might be
achieved with resource types but not 100% sure. Perhaps
this is not the best method of having limited
indentical resources.
5. At the CLC we need to record how many sessions a day
we have. So each reservation would be a session and we
would need a method to store the number of sessions.
This might be achieveable from a script that would do
several queries to the mySQL database and total up the
number of sessions between two set dates.
6. we need a method of extracting the recorded data so
we can produce termly reports. Perhaps we could do this
just by accessing the tables directly and extracting
the required data. Or perhaps a method of creating
statistics generated by looking at paticular fields
(i.e classes booked out for a certain year group,
between 2 dates).
If any of these requests arn't clear to you, then
please do reply back to me. I know alot is listed, but
these modifications would be extremely useful. Perhaps
if someone had some design documention, that would be
useful to us as well.
thanks, Adam
Logged In: NO
1. This one has been requested already, albeit in a more
automated form, and is already on the books - with something
like a special activity type that books several resources
without the user having to do it manually.
2. Not every user of the booking system is in education, and
I would like to keep things as widely applicable as
possible. However, it shouldn't be too difficult to
modify/customise the booking system to suit your specific needs.
3. This one is not as specific as the others, and could be
included in the main system.
4. With small amounts of resources (e.g. 10 digital cameras)
we have just set up a resource group dedicated to that
resource, and listed each resource individually. I agree
that it's not the best solution, but it works provided the
limited number of resources is not too large.
5. You are correct about being able to access the database
to find this out, take a look at tbl_reservations in the
database. There is also another table that will give you the
amount of bookings made as opposed to individual sessions in
the case of block bookings. This may or may not be more
helpful in your case.
6. If the reports are very customised/specific, it would
probably be easiest to access the database directly and get
the data that way. If you have any queries about the format
of the tables, I'll be happy to help.
Logged In: YES
user_id=170362
Sorry - forgot to log in. That last post was by me.