[AG-TECH] Automated room booking.

[Ivan R. Judson]

Cool.

Here's how I mucked mrbs to do timezones:

On the index page, have a little javascript that grabs the timezone then
passes it to a second index page that is the actual content page.

It's an icky method, but you can capture the client timezone that way and
keep only UTC/GMT times in the database and transform them on a per client
basis.

--Ivan

> -----Original Message-----
> From: owner-ag-tech at mcs.anl.gov [mailto:owner-ag-tech at mcs.anl.gov]On
> Behalf Of S.Booth
> Sent: Thursday, February 28, 2002 11:08 AM
> To: s.booth at epcc.ed.ac.uk
> Cc: ag-tech at mcs.anl.gov
> Subject: Re: [AG-TECH] Automated room booking.
>
>
> 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
> room.
>
> 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
> look.
>
> 		Stephen
>
> ======================================================================
> |epcc| Dr Stephen P Booth             Project Manager           |epcc|
> |epcc| s.booth at epcc.ed.ac.uk          Phone 0131 650 5746       |epcc|
> ======================================================================
>