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]
