[dev] Proposal for Resource booking extension for Kronolith

[Stephane Pointu]

Hi all,

Below is our proposal for implementing resources management in Horde.
It will be based on Kronolith.

The principle:
When creating/editing an event, the user will be allowed to select a
resource to be added to the event. If the resource is available, it will
be booked (for recurrent events, only the 1st occurence is checked). If
not, the user will be allowed to update the event to match a period
where the resource is available, or remove the resource from the event.
A view link is added next to each resource for the user to be able to
view the free-busy information for the resource.

Optionnally, for recurrent events, we can ask the users to confirm their
next booking just after the previous event to make sure a booked
resource is really used. The resource will be freed if the user does not
confirm after x days.

Optionnaly again, old bookings can be deleted automatically after a
defined period of 1 month, 3 months, 6 months, 1 year.


Database table to be created:
events_resources
+ event_id -> Taken from events table
  resources_names
  event_date -> confirmed booking
  next_event_date -> next event to be confirmed

Below are 2 screenshots that will help to better understand our proposal.

Please comment on this.

Regards,

-- 
Stephane Pointu
Purple Labs S.A.
stephane.pointu at purplelabs.com
http://www.purplelabs.com/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: display_admin.png
Type: image/png
Size: 10321 bytes
Desc: not available
Url : http://lists.horde.org/archives/dev/attachments/20070419/cfb77f99/attachment-0002.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: display_form.png
Type: image/png
Size: 8482 bytes
Desc: not available
Url : http://lists.horde.org/archives/dev/attachments/20070419/cfb77f99/attachment-0003.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 252 bytes
Desc: OpenPGP digital signature
Url : http://lists.horde.org/archives/dev/attachments/20070419/cfb77f99/attachment-0001.bin