Junior Sports Team Manager Website

Junior Sports Team Manager Website Objective: To create a website for sports team administrators to keep contact details, subscription payments and attendance records up to date. Initial phase will be to provide a one off installation on a linux server using php and mySQL. Must be built in such a way as to allow easy addition of extra features (to be decided) in the future with all code annotated for easy reference. The website must provide for full functionality on desktop and mobile environments. Outline of structure (this is open to suggestions - just my initial thoughts). Admin Area Manage Users Name* Surname* Parent Name(s) - add as many as needed Contact Details* Medical Conditions Email Tel* Username* Password* User access level (select)* Status (Active/Non-active) Group - Player or Coach Siblings (select from list of users - may be more than one) Manage Teams Team Name Add/remove coaches Add/remove players Manage Finances Set Subscription Rate - Sibling discount (value) - Reg Fee (included in total rate) Categories (select - Reg Fee, Subs, Tournaments) (used for filtering only) View Payments (shows total due/outstanding) - by team - by individuals View Events View either game or training attendances - By team - By player Games to include - Attendance/non attendance, goal, assist, clean sheet, MoM, capt Training to include - Attendance/non attendance Manage User Level 1 - Admin - Super User (View and Edit all elements of admin or any other inputs) 2 - Staff - View and edit - Teams and Players 3 - Coach - View and Edit - Players payments, event set-up and input 4 - Player - View payments, their own event record Manage Seasons Add/edit seasons Archive season - only Super User! Writes all data to the archive for that season. Any actions after this will be applied to the next season. (Should highlight outstanding due payments before allowing continue - if allowed, any oustanding payments are moved to the next season and show as such on the players record). View Archive - shows all the records above per season Manage Club Add club logo Contact Details - tel, address, bank details Note: All changes and updates to be logged by username. Report viewable by Super User (report listed as: Username, Change, Date) ‘Public’Area Only accessible by input of username and password - access level sets what is viewable Players View Name Contact Tel Contact Details Event Record Games - Possible Attendances & Actual, Goals, Assists, Clean Sheets, MoM Training - Possible Attendances & Actual Subs Detail Paid - With Filters (Reg Fee, Subs, Tournament) List of all payments made with date, who took payment (coach/staff), payment type: Cash, Cheque, Bank Trans Outstanding (including outstanding from previous seasons) Coaches contacts - shows names and tel for each coach allocated to their team Coaches View (shows only players in the same team as they are allocated to) Overview Shows subs due by full team and value outstanding Players List of all players in team - link to players view as above Events Add new event - Game - Add ‘date, opposition, H/A (after initial screen it shows a table with click boxes under columns: Attendance/non attendance, goal, assist, clean sheet, MoM, capt) - Training - Add ‘date’ (after initial screen it shows a table with click boxes under columns: Attendance/non attendance) Edit event Shows list of events and allows coach to update inputs Add payment Select player from list and add: Value , note (auto adds date), payment type: As player view Staff View Teams Shows all teams and then as above Add/remove players from teams Add/edit player contact details Coaches View/add/edit coach contact details View archive - listed as above per season Add payment (as above). Finally: Base on an existing admin theme. You should also use the phrase - When Sunday Comes in the first line of your proposal. This is a personal project so be nice with costs!