php mysql Developer

**ABC Corp. Coaching Database Project** **Overview** ABC Corp. provides coaching services to their clients through lessons that are delivered. Each coach manages their lessons, and upon completion of a lesson they need to track the details of the lesson, the attendees and the billing information. **Goal** Create a web-based system for coaches to enter the information about lessons delivered, including the details of the lesson, the attendees and the billing information. Also, create a report that management can use to view the information about coaches and lessons, as well as the billing information. Please anticipate that each client will enter thousands of transactions each year, and therefore the reports should still run quickly should they select a 5 year range. ## Deliverables **ABC Corp. Coaching Database Project** **Overview** ABC Corp. provides coaching services to their clients through lessons that are delivered. Each coach manages their lessons, and upon completion of a lesson they need to track the details of the lesson, the attendees and the billing information. **Goal** Create a web-based system for coaches to enter the information about lessons delivered, including the details of the lesson, the attendees and the billing information. Also, create a report that management can use to view the information about coaches and lessons, as well as the billing information. Please anticipate that each client will enter thousands of transactions each year, and therefore the reports should still run quickly should they select a 5 year range. **Technical notes** Please use the Zend framework with an Object Oriented LAMP setup using the MVC architecture to create the software. We will need access to the source code. Please post the site to your server that we may test on, or send us the source code so we may view it locally. ** Scope/TimeLine** Project completion date: October 21, 2011 Please submit a proposal outlining your project plan and detailing the number of hours that would be billed based on the specifications listed in this posting. Important Notes: ? Not every detail is provided, please use common sense to propose solutions for anything you're unsure about. For example, the increments for duration of the lesson / class is not specified, so you could include increments of every 5 min, or whatever you think is logical. ? For now, there is no need to worry about deleting and editing incorrectly entered transactions. Assume that anything that is not in scope will be completed in future projects (There is an opportunity for full-time employment). However, ensure that you include all functionality that allows you to successfully demonstrate all of the specifications requested in this project. **Specifications:** Main Screens:** ** These are the main screens that are in scope for this project: 1. Enter Lesson Details: A screen for coaches to enter the details of the lessons (Design attached) 2. View Lesson Transaction List: For coaches and management to view the list of lessons entered (Coaches can only see their own lessons, management can see all lessons in the system). This page should have the button/link to enter a new Lesson on it. 3. Reports Page: For coaches and management to run reports (Coaches can run only reports for themselves, management can run reports for all coaches or any individual coach). The only report in scope for this project is a basic report, allowing management to select a date range to run a report on the lessons inputted. (Design attached) Please see screenshot. 4. System Settings/Configuration: For managing system settings. System settings that are in scope for this project are: Categories and Types (see Fields/Details for specifications) Fields/Parameters: These are the fields and parameters that are in scope for this project: 1. Category: Drop down selection of lesson category (such as: piano, tennis, computer programming, cricket etc?). The list of categories is managed in the System Settings. *This field is mandatory * 2. Type: Drop down selection of type of lesson (such as: private, semi-private, group). The list of types is managed in the System Settings. *This field is optional * 3. Date: Date of the lesson (Day, Month, Year) Click a calendar to select the date. *This field is mandatory * 4. Duration: Drop down selection of how long the lesson was, in hours and minutes. *This field is mandatory * 5. Instructor: Text field to enter instructor who ran the lesson. The field should auto-fill and be validated against known instructors in the system. For this project, you will need to include 25 random instructors in the system for these fields to be validated and auto-filled with, in the future instructors will be populated from user management screens that are not in the scope of this project. *This field is mandatory * *6. * Participant: Set of fields to enter participants who took the lesson. These fields should auto-fill and be validated against known participants in the system. For this project, please add 25 random participants in the system for these fields to be validated and auto-filled with, in the future participants will be populated from participant management screens that are not in the scope of this project. *This field is mandatory * 7. Fee: Number field to enter corresponding amount to be charged for each participant (please see screenshot). Any amount can be entered. * This field is mandatory * 8. Notes: small area for notes *This field is optional* **Screenshots** A sample design is attached of the main screen and a report, feel free to alter the design if you wish. **Questions** You can email us at anytime?