We have this one client who is presently managing bookings for event spaces with an excel spreadsheet. This poor man highlights by hand the hours he needs and names them by day, etc. Every time someone wants to book, he looks it up click click click click and hopes that his paper version, computer version, or whatever... is recent. I could export all with some level of error, into a sensitively formatted data set.

A lot of people have already existing calendars. The only stability I have seen is the ical standard .. Mozilla Sunbird is coming out.

With a method that uses the ical standard.. Your gold client, this events organizer.. a beauty salon manager.. would all be able to (if they want) enter the changes in their laptop, and a script could regulalry update the website ical file or records- from their data.

I am thinking my problem separates into two things that could be re-used. One is a table layout for mysql for the ical standard (which I can't see an example of).
The other is a time collission detector.

The tie collission detector could simply be.. if we have unix time 23 through 32 (excuse me).. and an inquiry for time 31-34 was made.. we can simply detect that $requested_start < $last_registered_end Thus a collission is present.

I am using CGI::Application, HTML::Template, and CGI::Session. I was hoping to use Calendar::Schedule, but it's kinda buggy- or super duper unfriendly to develop with.

I'm gonna offer the project up for grabs when done, so nobody has to do this again!!! :) </p

In reply to Re^2: (OT) designing a "per event, resource schedule" manager by leocharre
in thread (OT) designing a "per event, resource schedule" manager by leocharre

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.