|
From: Todd O. <to...@da...> - 2001-03-06 21:35:58
|
__Multiple Organizations If we want to make phpwebsite scale to have multiple organizations in the same database, then we need to add an additional field to each table such as "ouid" (organizational unit id) ["oid" is reserved for object id in Postgres]. The primary key for each table would need to be changed to (cid, ouid) instead of (cid) alone. To prevent ouid guessing or spoofing, the user access control list (ACL) would have to be consulted for each page access, which should be done anyway. __Calendar plug-in I like Simon's simple mode calendar idea. I also think a repeating event item should be provided with "skip" dates such as every Monday from 2 pm to 4 pm EXCEPT for fifth Mondays (which occur once quarterly). phpmycalendar and phpgroupware have good interfaces; it may be better to start with one of these and recode from there instead of the existing calendar. Matt, are you working on this one yourself? It would also be nice to allow for an event/entry to link off-site or on-site for additional information. Extending on Richard's suggestion, I think each user should be allowed a default filter of their choosing, say only electrical engineering and mechanical engineering design deadlines, but everything else is out. They could then select to also add structural deadlines. I'd like to know the group's thoughts about having a see all BUT category logic or ONLY category logic. What happens when you've selected to see only categories B & C and someone then adds D; does it show up on your calendar? If not, then how do you know there's been one added? __Plug-in Table names Has their been any consideration given to a plug-in table naming convention? I suggest plug-in name, underscore, table name like calendar_events and calendar_categories. --Todd |