Parts Implemented by Umut Can Ozyar¶
Sponsorships¶
The sponsorships data is stored in the database. Using the navigation bar located at the top of the front page sponsorships table can be accessed.
This table displays the sponsorships data in the database.
Several alterations can be made by the user to change the way the data is displayed on the table. The amount of entries desired to be shown can be changed from the drop down list located at the top left of the table. The selected number corresponds to the amount of rows displayed by the table. In case the selected number exceeds the amount of sponsorships data, only the existing data will be displayed with no empty rows.
There are also page control buttons located at the bottom right side of the table. These buttons are used to navigate through different table pages if perchance there are more data in the database than the amount selected to be shown.
The ordering of the data throughout the table can be changed by clicking on the sort buttons located at each table header. This feature allows user to sort the data depending on various attributes of the table in descending or ascending order.
If there is no data in the database about sponsorships, “No data available in table” message is displayed on the table to notify the user.
The manage button located on top of the table directs to user to the manager of the sponsorship table. This page is limited for registered users only. Guest users will be notified to login using the login button located at the top right side of the page.
Manager page allows user to add new data, update existing data or delete existing data.
Add Sponsorship¶
“Add New Data” button allows the user to add a new sponsorship for league, team and person entities in any combination. Then a modal for adding new data will appear. This modal contains several fields corresponding to different attributes of the table.
First input field is for the name of the sponsor. The second field brings out a calender for sponsorship start date selection. Third field is for selecting the sponsored league. Fourth field is for selecting the sponsored team and the last field is for the sponsored person. Some of the last three fields can be left blank as a sponsor doesn’t have to sponsor a league, a team and a person at the same time. After the necessary fields are filled submit button is used to add the data to the table.
Some of these fields like the name and the start date cannot be left blank and will warn the user if submit button is clicked without filling these fields.
Alerts will appear on top of the table to notify the user about the outcome of the add operation. This can either be a success message with a green background which means that data is added to the database successfully or it can be a failure message with a red background which means that a problem has occurred and the operation is unsuccessful.
Update Sponsorship¶
“Update Selected Row” button allows the user to update a sponsorship entity on the table. If a row is not selected or multiple rows are selected, an error message notifies the user to select a single row.
If a single row is selected a modal for updating data will appear. This modal contains several fields corresponding to different attributes of the table filled with the existing data.
Several attributes can be updated using this modal at the same time. Some fields like the name and start date will still be required to be filled. Submit button will update the data on the database.
Please refer to Add Sponsorship for more detail about the fields and all encountered alerts.
Delete Sponsorship¶
“Delete Selected Row(s)” button allows the user to delete sponsorship entities from the table. At least one row has to be selected to perform this operation.
Team Statistics¶
The team statistics data is stored in the database. Using the navigation bar located at the top of the front page team statistics table can be accessed. This table displays the sponsorships data in the database.
The manage button located on top of the table directs to user to the manager of the team statistics table. This page is limited for registered users only. Manager page allows user to add new data, update existing data or delete existing data.
Add Team Statistics¶
“Add New Data” button allows the user to add team statistics for an existing team. Then a modal for adding new data will appear. This modal contains several fields corresponding to different attributes of the table. Wins, draws and losses are automatically calculated according to the matches data.
First input field is a drop down menu for team selection. The rest of the fields are inputs for batting runs, batting hits, pitching saves respectively. After the necessary fields are filled submit button is used to add the data to the table.
Please refer to Add Sponsorship for instructions about validation or alerts, and Sponsorships for navigation.
Update Team Statistics¶
“Update Selected Row” button allows the user to update a team statistics entity on the table. If a row is not selected or multiple rows are selected, an error message notifies the user to select a single row.
If a single row is selected a modal for updating data will appear. This modal contains several fields corresponding to different attributes of the table filled with the existing data.
Several attributes can be updated using this modal at the same time. Some fields like hits, runs and saves date will still be required to be filled. Submit button will update the data on the database.
Please refer to Add Team Statistics for more detail about the fields and Add Sponsorship for all encountered alerts.
Delete Team Statistics¶
“Delete Selected Row(s)” button allows the user to delete team statistics entities from the table. At least one row has to be selected to perform this operation.
Stadiums¶
The stadium data is stored in the database. Using the navigation bar located at the top of the front page stadiums table can be accessed. This table displays the stadiums data in the database.
The manage button located on top of the table directs to user to the manager of the stadium table. This page is limited for registered users only. Manager page allows user to add new data, update existing data or delete existing data.
Add Stadium¶
“Add New Data” button allows the user to add a new stadium for an existing team. Then a modal for adding new data will appear. This modal contains several fields corresponding to different attributes of the table.
First input field is the name of the stadium. Second input field is a drop down menu for team selection. Third input field is another drop down menu for location selection which indicates the city the stadium is located in. The last field is a numerical value representing the capacity of the stadium. After the necessary fields are filled submit button is used to add the data to the table.
Please refer to Add Sponsorship for instructions about validation or alerts, and Sponsorships for navigation.
Update Stadium¶
“Update Selected Row” button allows the user to update a stadium entity on the table. If a row is not selected or multiple rows are selected, an error message notifies the user to select a single row.
If a single row is selected a modal for updating data will appear. This modal contains several fields corresponding to different attributes of the table filled with the existing data.
- Several attributes can be updated using this modal at the same time. None of the fields can be left blank. Submit button
- will update the data on the database.
Please refer to Add Stadium for more detail about the fields and Add Sponsorship for all encountered alerts.
Delete Stadium¶
“Delete Selected Row(s)” button allows the user to delete stadium entities from the table. At least one row has to be selected to perform this operation.