Simple Calendar
-----------------
SUMMARY
=======
This is supposed to be a simple calendar program that will be used to keep track of where sales agents will be throughout the year. The calendar will be a simple table rather than a rows + columns display of a calendar.
DETAILS
=======
Information to be saved on each person includes the following:
User - People who use the system
----
id int, autoincrement, PK
email varchar(120) unique
password varchar(30)
firstname varchar(75)
lastname varchar(75)
cell varchar(75)
title varchar(75)
EventType - type of events on the user's calendar
---------
id int, autoincrement, PK
name varchar(30)
EX: vacation, travel day, headquarters, other
There will be an administrator account.
- The admin can create other users.
- The admin or users can add events
Each user will have their own calendar. The calendar will contain information on where each person will for the calendar year.
The user will login ([login to view URL]) with their email address and password. After login, they will see a list of the dates of the the current month with events listed if any. This will be a simple table with the date in the first column and event in the 2nd column.
The user can go to the previous/next month or even the previous/next year. There will be a link to form to add where they are going to be for any given date or date range. The start/end date in the form should use a DHTML calendar to select the date.
On the form there will be an event drop down menu where the...
[2000 character limit, see specifications file for the rest of the info]
## Deliverables
1) Complete and fully-functional working program(s) as well as complete source code of all work done. Source code must have comments explaining what was done. SQL script to create necessary tables and populate the tables.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) Using FTP, the program should be setup and tested on the server.
b) Need a 90 day period of support in case any bugs are found.
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).
* * *This broadcast message was sent to all bidders on Saturday Mar 11, 2006 12:26:47 PM:
Hello All,
I have put together a file called [login to view URL] (that is part of the [login to view URL] file attached to the bid request) that contains the questions asked by various people and the answers.
This will help clarify the project.
I am waiting for some of you to confirm the development language.
Thanks,
SM
* * *This broadcast message was sent to all bidders on Saturday Mar 11, 2006 12:30:27 PM:
Hello All,
I have put together a file called [login to view URL] (that is part of the [login to view URL] file attached to the bid request) that contains the questions asked by various people and the answers.
This will help clarify the project.
I am waiting for some of you to confirm the development language.
Thanks,
SM
## Platform
Server
-------
Windows 2003
Language
---------
Coldfusion MX 7
Database
---------
SQL Server 2000
ODBC
------
Coldfusion DSN to SQL Server DB