[AG-TECH] Automated room booking.

S.Booth spb at epcc.ed.ac.uk
Thu Feb 28 11:08:01 CST 2002

On Mon, 11 Feb 2002, S.Booth wrote:

> On Tue, 29 Jan 2002, S.Booth wrote:
> > 
> > The AG framework is potentially very useful for short ad-hoc meetings but
> > the current booking mechanism is not really set up for this. 
> > It would help if any bookings for a venue showed up on the virtual venue
> > page, and even better add booking information to the doors in the lobby
> > so people can see if a room is free before entering. This will help with
> > the newbie problem (speaking as a newbie myself)
> > 
> I'm going to have a go at adding automated room booking to the virual
> venues server. All the hard stuff (authentication, DB access etc) is
> already in the server so it should not be too hard.
> I'm planning something very simple, a booking page that lets you
> view existing booking or select a room, start time and duration. And add
> a listing of todays bookings to the to room descriptions and the room
> entry. 
> If anyone else is working on something similar let me know.

OK I have had a go at this and have something working.

I have attached a tarfile of changes to the vvenue software.
index.php and ag-tables.sql are changed the rest are new files.
you need to apply the changes before configuring the venues as it needs to
create a new database table.

I have simple automated room booking.
You can delete your own bookings by going to the booking form for the day
in question.

Each room page contains a table of the bookings for that day with
currently active bookings in bold.

Each room link also has such a table if there is an active booking in that

There are 2 main problems at the moment
1) old bookings are not deleted automatically.
2) At the moment it all works in a single time-zone as all dates etc are
handled by the database and I have not worked out how to switch the
timezone of displayed times on a request by request  basis.

I'll continue to work on this but I thought I should let people have a


|epcc| Dr Stephen P Booth             Project Manager           |epcc|
|epcc| s.booth at epcc.ed.ac.uk          Phone 0131 650 5746       |epcc|
-------------- next part --------------
A non-text attachment was scrubbed...
Name: release.tar
Type: application/octet-stream
Size: 40960 bytes
URL: <http://lists.mcs.anl.gov/pipermail/ag-tech/attachments/20020228/a2b6d313/attachment.obj>

More information about the ag-tech mailing list