I require the design of a basic messaging platform for use by a school. It should be capable of sending both emails and SMS messages using the clickatell SMTP gateway. Due to internal timelines, the following roadmap needs to be adhered to: The emailing interface needs completed with 10 days with development of the SMS component commencing after this is fully functioning. SEE DELIVERABLES BELOW FOR REQUIRMENTS
It should have the following features: Email - WYSIWYG HTML editor for newsletter body. - Attachment support (more than one attachment per message) - Template Support - ie some templates can be stored and then chosen when sending a message. - Parent First Name, Parent Last Name, placeholders fields. - Sending of Email messages by individual student, or group - more than one group can be selected. SMS - Parent First Name, Parent Last Name, placeholders fields. - Sending of SMS messages by individual student, or group - more than one group can be selected. Other Admin Functions - Archiving of sent emails and SMS - When sending by student, the list should be filterable based on year level or class. All lists should be sorted by last name. - Upload Families CSV, Upload Students CSV, edit student/family details. - Groups editor - Groups have the fields "Long Name" for display in system and "Short Name" for use in CSV files etc. The system will manage users based on two levels, families and students. Each student is assigned to a family. Family Fields: Family Code (the unique identifier), Parent/Guardian 1 First Name, Parent/Guardian 1 Last Name, Parent/Guardian 1 Email Address, Parent/Guardian 2 Mobile Number (10 digits - must start with 04) Student Fields Family Code (to link it to the family), First Name, Last Name, Class, Group Short Name (more than group can be selected - this needs to be facilitated for in the CSV upload) The idea behind this is that when a message is sent it will be sent to both parents/guardians but if the parent has more than one student they will only receive the message once. Additionally if the student is a member of more than one group and the messages is sent to multiple groups, the parents should still only receive the message one. - No user frontend is required, only an administrator back end. 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).
must be compatible with ie 6