Did you ever consider just storing the exceptions? On Thu, Aug 18, 2011 at 2:22 PM, Jochen Daum <[email protected]> wrote:
> Hi, > > > Just wondering what systems people are using to provide clients with > > appointment scheduling using PHP? Any recommendations? Any pitfalls to > watch > > out for? > > I can't recommend any specific system. I have experience with the > Jevents and JCalPro Joomla components and I can tell you that both > have ludicrous data models. I have also built such a system from > scratch. One of the key issues to look out for is how repeats are > implemented. The usual (Outlook) way of doing this is to store the > repeat and then calculate it on the fly. This has the following > downsides: > - performns badly for 100+ different appointments 3 months out > - what if there are exceptions > - what if your repeat type is not implemented (2nd to last Friday every > month) > > I personally prefer to use calendar tables, i.e. you calculate all > times that the repeat happens and store them in the database. > > Happy to explain our solution over a beer as well. > > HTH, Jochen > > > > > > > > > > All the best, Grant > > > > -- > > NZ PHP Users Group: http://groups.google.com/group/nzphpug > > To post, send email to [email protected] > > To unsubscribe, send email to > > [email protected] > > > > -- > NZ PHP Users Group: http://groups.google.com/group/nzphpug > To post, send email to [email protected] > To unsubscribe, send email to > [email protected] > -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
