Today i started with the whole match reconstruction. At least, my initial assumption right now is that the whole setup I have done inside the matches itself is eventually going to by myself in the head.
Currently I am having different states for a match for team1 and team2. From a query perspective it works if its limited. However, since the states have alot of impact on what the outcome of a match is going to be it will eventually start into one complicated mess.
In the new setup I have split the match up into 2 different tables. First you have the match, and next you have the team status. This team status is defined by the following parameters:
- Match Id
- Team Id
- Team Side (attack / defend)
- Match Status (accepted/declined the match)
- Match Score Accepted (accepted / declined the scores)
- Match Rescheduled (accepted / declined rescheduling)
From a query point of view it makes it easier for fetching the information. Even while its just another table.
Currently I have fixed the inserts (I am still inserting the old columns inside the matches, however eventually they will be phased out). I only need to fix the view match page where I am gathering the information from the new matchteam table. But... that should not take that long I think.
What else I need to change:
- pending matches on the team control panel
- pending matches notifications on the toolbar (footer)
- function getPendingMatchesCaptain2 is obsolete now
Update: And by now this all got sorted out. So this should hopefully make further developments on the match status a little bit more easy to implement.
Geen opmerkingen:
Een reactie posten