AnsweredAssumed Answered

Sport League Manager with Fixture/Schedule Generator... Script Help

Question asked by adhutchinson on Jul 24, 2013
Latest reply on Jul 27, 2013 by adhutchinson

Title

Sport League Manager with Fixture/Schedule Generator... Script Help

Post

      

     I am trying to build a League Manager Application for my Local Field Hockey Association.

     There are a total of 11 different leagues, based on Gender/Age Group/etc.

     I got some help from another Forum, and below is the script that did most of what I required.

set error capture [ on ]
#the layout you're on is Leagues
set variable [ $hometeamIDs; Value:List ( teams | list::ID ) ]
set variable [ $awayteamIDs; Value:List ( teams | list::ID ) ]
set variable [ $leagueID; Value:leagues::ID ]
set variable [ $numberofteams; Value:ValueCount ( $hometeamIDs ) ]
set variable [ $count_outer; Value:1 ]
#
Go to layout [ “matches” (matches) ]
#
Loop
     set variable [ $currenthome; Value:GetValue ( $hometeamIDs ; $count_outer ) ]
     set variable [ $count_inner; Value:1 ]
           #
           Loop
             set variable [ $currentaway; Waarde:GetValue ( $awayteamIDs ; $count_inner ) ]
             If [ $currentaway ≠ $currenthome ]
              New record/request
              set field [ matches::hometeamID; $currenthome ]
              set field [ matches::AwayteamID; $currentaway ] 
              set field  [ matches::leagueID; $leagueID ]
            End If
           Exit Loop If [ $count_inner ≥ $numberofteams ]
           set variable [ $count_inner; Value:$count_inner + 1 ]
           End Loop
           #
     Exit Loop If [ $count_outer ≥ $numberofteams ]
     set variable [ $count_outer; Value:$count_outer + 1
End Loop
#
Go to lay-out [ original layout ]
#
#

      

     But!!  This script creates a full Home & Away Schedule for all of the games in the League's fixture, without game dates or time... Which leaves me with three problems

     1) The fixtures are created so that is cycles through the teams, creating all of that teams home fixtures then moving on.  This leads to the problems in #2 & #3

     2) I need to automate the dates from a Field called Start Date. Games are held weekly and take place on the same day, every Round/Week.  Each Team is only allowed one game per Round/Week.

     3) Some competitions are too big to host a full Home & Away Schedule, we are limited to between 20-28 weeks of play, inc. playoffs, so the larger competitions would only play every other team once.

     For an even number of teams (say 16) this would mean an odd number of games (n_total=15), in which case, half the teams would play more than half of their games at home (n_home=8; n_away=7; n_total=15) and vice-versa (n_home=7; n_away=8; n_total=15)

      

Outcomes