Our site uses php and cakephp to offer daily deals. We need to have a few modifications done. Most of this can be duplicated from existing pages / sql tables and then modifying them to our needs.
1. On [url removed, login to view] (the checkout page) we want to have the user select a dropdown option with a list of schools in the area. The school dropdown will be populated from the database so we will need the following completed for it to function.
2. Add table for schools.
2A. Add fields to schools table. school, district, principal, phone, address, city_id, state, zip, url, city, commission, donation_amount, deals_bought (there may be others you need to add for functionality like school_id etc, these are just the one's I think we'll need.)
3. Add "Schools" section on admin page in backoffice. Preferably right under the companies section.
a. Schools overview page. (a list of all the schools. Similar to the current companies page. We need to be able to select the school to get further info and edit their details)
b. In the html table we would like to have the following fields displayed. school, city, address, phone, commission percentage, donation amount, and deals bought. (The "deals bought" column will show the total # of deals purchased that user's selected to donate to the school)
b. Just like the companies overview page, we need to have an "Add School" so we can add schools, a CSV export option, and a search bar at the top so we can search for schools.
c. "Add school" page with necessary fields to add the school to the database.
d. The commission per school will be calculated using the "deal_commission_percentage" x "discount_amount" x "school percentage"