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).
Parent Name(s) - add as many as needed
User access level (select)*
Group - Player or Coach
Siblings (select from list of users - may be more than one)
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 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
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
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)
Only accessible by input of username and password - access level sets what is viewable
Games - Possible Attendances & Actual, Goals, Assists, Clean Sheets, MoM
Training - Possible Attendances & Actual
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)
Shows subs due by full team and value outstanding
List of all players in team - link to players view as above
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)
Shows list of events and allows coach to update inputs
Select player from list and add: Value , note (auto adds date), payment type: As player view
Shows all teams and then as above
Add/remove players from teams
Add/edit player contact details
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!