Art Gallery Signup Calendar

The State of the Art Gallery (SOAG) is a cooperative of painters with around 20 members.. Each member has to sign up for "minding the store" at least 6 hours a month on average. Currently, members email the administrator with the hours they wish to work and the administrator manually enters their wishes on the web page and uploads it (see [login to view URL]). This is really inefficient, error-prone, and frustrating. Need: A calendar web page where each member can log on and enter/edit the hours for which he or she is going to sit at the gallery. The calendar would be public, but editable only by members. An admin would have to add users, as membership in the gallery is a big complicated deal. The site is hosted at [login to view URL] and has capability to use php and mySQL. I'd need this provided in a form I can install or have it installed. Wishlist: 1. Display only days and hours that gallery is open (currently 4 days/week, noon to various times) 2. Offer 1-hr blocks for signup -- checkboxes. radio buttons… 3. Possibility to associate special events with certain times. E.g., if there is an opening on Friday evening 5-8, then those hour-slots could be edited to say "Opening Night" as well as the name of the people signed up to sit. Perhaps only admin could make edits like this. 4. When a member signs up, a confirming email is sent to that member. 5. Would be nice: send a reminder email the day before the person is signed up to sit. 6. Another gallery calendar is the calendar of shows. [login to view URL] I can't really see how this could be integrated into a gallery-wide calendar or what the benefit could be; but maybe someone who really understand info architecture would think it's a good idea. 7. The calendar pages should stay within the site's design. ## Deliverables I need to see a spec or mockup of the calendar before approving the project, and I'm willing to respond to as many questions as needed to get it clear. 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform MySQL version 4.0.15-standard PHP version 4.3.2 PHP info Click to view PERL version 5.6.1 Operating system Linux Apache