I'm making a project to help manage a "schedule for events taking place occupying a finite resource".. For example if a client is managing hotel rooms and rentals.
They will need to enter via http, and reports must be generated to present online to anybody enquiring to hold an envent (rent a room, throw a party in a church.. etc)

Calendar::Schedule is fab, but how would I stop overlapping?

Solution 1..

I have a simple module to interact with a timeslots table in an open dbi handle.

In the timeslots section is recorded the id of the timeslot, the id of the event(who what, beyond scope here), the start time, and end time.

I've been thinking that I'd use unix time for defining a "time bloc", start and end.
With funny leap year etc situations.. will time xxxxxxxxxx always translate to a specific date?

Maybe managing a schedule via start and end times is not the most sensible approach, what about start time and duration?

Solution 2?

My other thought is interfacing with an application that already tracks a calendar schedule type of organization.. Like mozilla sunbird? What else could I look into interfacing to?

update:

Actually, I could use Calendar::Schedule simply to render, and I could enter in the data from a sql csv, etc table, and have time conflict managed on the side.
I would have to convert unix time or something else to register events with Calendar::Schedule

In reply to (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.