require "bracket_manager.pm";

sub print_update_tournament_score_form{
    my $event_id       = shift;
  	my $tournament_id  = shift;

    my %event_info            =    get_event_info($event_id);
	  my %teamsa                = get_league_teams($event_info{"League_ID"});
	  my %tournament_event_info = get_tournament_event_info($tournament_id);
	  my $home_team = "";
	  my $away_team = "";
	  foreach $key (keys %teamsa){
      $teams{$teamsa{$key}} = $key;
    }
	    

	if ($event_info{"Home_Team"} == 0) {
		$home_team = $tournament_event_info{"ALT_TOP_BRACKET"};
	}else{
        $home_team = $teams{$event_info{"Home_Team"}};
	}

	if ($event_info{"Away_Team"} == 0) {
		$away_team = $tournament_event_info{"ALT_BOTTOM_BRACKET"};
	}else{
        $away_team = $teams{$event_info{"Away_Team"}};
	}

    my $home_score     = $event_info{"Home_Score"};
    my $away_score     = $event_info{"Away_Score"};

if($home_score == -1){
    $home_score = "";
}
if($away_score == -1){
    $away_score = "";
}

print <<__HTML__;
    <script>
		function IsInteger(s) {
	        for (var i = 0; i < s.length; i++) {
		        var c = s.charAt(i);
		        if (!((c >= "0") && (c <= "9"))) {
			        return false;
		        }
	        }
	        return true;
        }


        function validate_score_form(){
          var homeScore = document.getElementById('home_score');
          var awayScore = document.getElementById('away_score');
		  if((IsInteger(homeScore.value))&&(IsInteger(awayScore.value))){
		  }else{
		      alert("You must enter a valid score for both teams!"); 
              return;
		  }


          if((homeScore.value < 0)||(awayScore.value < 0)||(homeScore.value == "")||(awayScore.value == "")){ 
              alert("You must enter a valid score for both teams!"); 
              return;
          } 

        document.score.submit();
        }
		function reset_score_form(){
			var okToReset = confirm("Are you sure you would like to reset this game score?");
            if(okToReset){
                var homeScore = document.getElementById('home_score');
                var awayScore = document.getElementById('away_score');
                var resetScore = document.getElementById('reset_scores');
			    resetScore.value = 1;	
                document.score.submit();
		    }else{
			    return false;
            }
        }

        </script>
    <center>
    <FORM NAME=score METHOD ="get" ACTION="update_score2.pl" ENCTYPE="multipart/form-data">
        <input type=hidden name=event_id value=$event_id> 
        <input type=hidden name=tournament_id value=$tournament_id> 
        <input type=hidden name=league_id value=$league_id> 
        <input type=hidden name=org_id value=$org_id> 
        <input type=hidden name=reset_scores id=reset_scores value=0> 
	<table style='border-collapse:collapse;border:1px solid black' cellpadding=3 cellspacing=0 width=200>
		<tr>


	    <td  id=cal_events_head colspan=2><center><b>Update Scores</b></center></td>
		</tr><tr>
        <td id=cal_events3 align=right>$home_team</td>
		<td id=cal_events3> 
			<input type=text id=home_score name=home_score value="$home_score" size=3> 
		</td>




		</tr><tr>

        <td id=cal_events3 align=right>$away_team</td>
		<td id=cal_events3> 
			<input type=text id=away_score name=away_score value="$away_score" size=3> 
		</td>

			
		</tr>

		<tr>
	        <td  id=cal_events_head colspan=2><center>
		    <input class=input type=button id=SUBMIT name=SUBMIT value=SUBMIT onClick=validate_score_form();> &nbsp;&nbsp;&nbsp;&nbsp;
		    <input class=input type=button id=CANCEL name=CANCEL value=CANCEL onClick=window.close();>
		</center></td>
		</tr>
__HTML__
    if(($home_score != '')&&($away_score != '')){
            print <<__HTML__;
		<tr> <td id=cal_events3 colspan=2> &nbsp; </td> </tr>
		<tr>
	        <td  id=cal_events_head colspan=2><center>
			<input class=input type=button id='RESET GAME SCORES' name='RESET GAME SCORES' value='RESET GAME SCORES' onClick=reset_score_form();> 
		</center></td>
		</tr>
__HTML__
    }
	
    print <<__HTML__;
	</table>
    </center>
__HTML__

}
sub print_update_score_form{
    my $event_id       = shift;
    my $year           = shift;
    my $month          = shift;
    my $filter         = shift;
    my %event_info     = get_event_info($event_id);
    my %teamsa         = get_league_teams($event_info{"League_ID"});
    my $league_id      = $event_info{"League_ID"};	  
    my $org_id         = $event_info{"Org_ID"}; 
    my $home_team      = "";
    my $away_team      = "";
	foreach $key (keys %teamsa){
      $teams{$teamsa{$key}} = $key;
    }

	%team_event_info = get_team_event_info_by_event_id($event_id);
	if($event_info{"Home_Team"} == 0){
	    $home_team = $team_event_info{"ALT_HOME_TEAM"};
	}else{
        $home_team = $teams{$event_info{"Home_Team"}};
	}
	if($event_info{"Away_Team"} == 0){
	    $away_team = $team_event_info{"ALT_AWAY_TEAM"};
	}else{
	    $away_team = $teams{$event_info{"Away_Team"}};
	}
    my $home_score     = $event_info{"Home_Score"};
    my $away_score     = $event_info{"Away_Score"};
	my $notes          = $event_info{"Notes"};
	$notes             =~ s/<br>/\n/g;
	#$notes             =~ s/^GAME HIGHLIGHTS - //g;
if($home_score == -1){
    $home_score = "";
}
if($away_score == -1){
    $away_score = "";
}
my $checked = "CHECKED";
my $starter_notes = "GAME HIGHLIGHTS - ";
if(($home_score != '')&&($away_score != '')){
    if($notes eq ""){
        $checked = ""; 
        $starter_notes = "";
	}else{
        $starter_notes = $notes;
	}
}

print <<__HTML__;
    <script>
		function IsInteger(s) {
	        for (var i = 0; i < s.length; i++) {
		        var c = s.charAt(i);
		        if (!((c >= "0") && (c <= "9"))) {
			        return false;
		        }
	        }
	        return true;
        }


        function validate_score_form(){
          var homeScore = document.getElementById('home_score');
          var awayScore = document.getElementById('away_score');
		  if((IsInteger(homeScore.value))&&(IsInteger(awayScore.value))){
		  }else{
		      alert("You must enter a valid score for both teams!"); 
              return;
		  }


          if((homeScore.value < 0)||(awayScore.value < 0)||(homeScore.value == "")||(awayScore.value == "")){ 
              alert("You must enter a valid score for both teams!"); 
              return;
          } 

        document.score.submit();
        }
		function reset_score_form(){
			var okToReset = confirm("Are you sure you would like to reset this game score?");
            if(okToReset){
                var homeScore = document.getElementById('home_score');
                var awayScore = document.getElementById('away_score');
                var resetScore = document.getElementById('reset_scores');
			    resetScore.value = 1;	
                document.score.submit();
		    }else{
			    return false;
            }
        }

		function updateNotes(){
            var highlightsEl = document.getElementById('game_highlights');
            var notesEl      = document.getElementById('notes');
			if(highlightsEl.checked == 1){
			    notesEl.value = "GAME HIGHLIGHTS - ";
				notesEl.disabled = false;
			}else{
			    notesEl.value = "";
				notesEl.disabled = true;
			}
	    }

        </script>
    <center>
    <FORM NAME=score METHOD ="get" ACTION="update_score2.pl" ENCTYPE="multipart/form-data">
        <input type=hidden name=event_id value=$event_id> 
        <input type=hidden name=org_id value=$org_id> 
        <input type=hidden name=league_id value=$league_id> 
         <input type=hidden name=year value=$year> 
         <input type=hidden name=month value=$month> 
         <input type=hidden name=filter value=$filter> 
         <input type=hidden name=reset_scores id=reset_scores value=0> 
        
	<table style='border-collapse:collapse;border:1px solid black' cellpadding=3 cellspacing=0 width=200>
		<tr>
	    <td  id=cal_events_head colspan=2><center><b>Update Scores</b></center></td>
		</tr><tr>
        <td id=cal_events3 align=right>$away_team</td>
		<td id=cal_events3> 
			<input type=text id=away_score name=away_score value="$away_score" size=3> 
		</td>
		</tr><tr>
        <td id=cal_events3 align=right>$home_team</td>
		<td id=cal_events3> 
			<input type=text id=home_score name=home_score value="$home_score" size=3> 
		</td></tr>
    
		<tr><td id=cal_events_head colspan=2><center><input type=checkbox id=game_highlights name=game_highlights onChange=updateNotes(); $checked><b>Enter Game Highlights/Notes</b></td></tr>
		<tr><td id=cal_events3 colspan=2>
    
    <textarea class=input rows=7 cols=35 id=notes name=notes>$starter_notes</textarea>
    </td></tr>
		<tr>
	        <td  id=cal_events_head colspan=2><center>
		    <input class=input type=button id=SUBMIT name=SUBMIT value=SUBMIT onClick=validate_score_form();> &nbsp;&nbsp;&nbsp;&nbsp;
		    <input class=input type=button id=CANCEL name=CANCEL value=CANCEL onClick=window.close();>
		</center></td>
		</tr>
__HTML__
        if(($home_score != '')&&($away_score != '')){
            print <<__HTML__;
		<tr> <td id=cal_events3 colspan=2> &nbsp; </td> </tr>
		<tr>
	        <td  id=cal_events_head colspan=2><center>
			<input class=input type=button id='RESET GAME SCORES' name='RESET GAME SCORES' value='RESET GAME SCORES' onClick=reset_score_form();> 
		</center></td>
		</tr>
__HTML__

		}

print <<__HTML__;
	</table>
    </center>
__HTML__

}
sub get_event_info{
  my $event_id = shift;
  my %return_hash = ();
  $dbh = get_dbh(); 
  # prepare and execute query
  $query = "SELECT * FROM Calendar_Events WHERE `Key` = $event_id";
  $sth = $dbh->prepare($query);
  $sth->execute();

  # assign fields to variables
  $sth->bind_columns(\$ID, \$Org_ID, \$League_ID,
                     \$Team_ID, \$Start_Date, \$End_Date,
                     \$Event_Type, \$Home_Team, \$Home_Score,
                     \$Away_Team, \$Away_Score, \$Desc,
                     \$Location, \$Other_Location, \$Notes,
                     \$Status);

  while($sth->fetch()) {
      $return_hash{"ID"}             = $ID;
      $return_hash{"Org_ID"}         = $Org_ID;
      $return_hash{"League_ID"}      = $League_ID;
      $return_hash{"Team_ID"}        = $Team_ID;
      $return_hash{"Start_Date"}     = $Start_Date;
      $return_hash{"End_Date"}       = $End_Date;
      $return_hash{"Event_Type"}     = $Event_Type;
      $return_hash{"Home_Team"}      = $Home_Team;
      $return_hash{"Home_Score"}     = $Home_Score;
      $return_hash{"Away_Team"}      = $Away_Team;
      $return_hash{"Away_Score"}     = $Away_Score;
      $return_hash{"Desc"}           = $Desc;
      $return_hash{"Location"}       = $Location;
      $return_hash{"Other_Location"} = $Other_Location;
      $return_hash{"Notes"}          = $Notes;
  }

  $sth->finish();
  # disconnect from database
  $dbh->disconnect;
  return %return_hash;

}

sub print_calendar_update_event_form{
    my $event_id     = shift;
    my %event_info   = get_event_info($event_id);
	my $update_notes = $event_info{"Notes"};
	my $use_other    = 1;
    $update_notes    =~ s/<br>/\n/g;
    @hours = (1,2,3,4,5,6,7,8,9,10,11,12);
    @min   = ("00","15","30","45");
    @ampm  = ("AM", "PM");
    ($current_sdate, $current_stime) = split(/\s+/, $event_info{"Start_Date"});
    ($current_shour, $current_smin, $current_sampm) = convert_time_to_display($current_stime);
    ($current_edate, $current_etime) = split(/\s+/, $event_info{"End_Date"});
    ($current_ehour, $current_emin, $current_eampm) = convert_time_to_display($current_etime);
    $current_sdate = convert_date_to_display($current_sdate);

    %event_types  = get_event_types();
    %locations    = get_locations($event_info{"Org_ID"});
    %teams        = get_league_teams($event_info{"League_ID"});

    #$locations{"Other"} = 0;

print <<__HTML__;

    <style>
        .image_link a{
                 text-decoration : none;
        }
    </style>

    <script>

        function validate_form(){
          var eventType    = document.getElementById('event_type');
          var eventName    = document.getElementById('event_name');
          var homeTeam     = document.getElementById('home_team');
          var visitingTeam = document.getElementById('visiting_team');
          var dateEle      = document.getElementById('date');
          var location     = document.getElementById('location');
          var other        = document.getElementById('other');
  
          if(eventType.value == 1){ //1 = League Event
              if(eventName.value == ""){
                  alert("You must enter a value for Event Name when entering a League Event"); 
                  return;
              }
          } 
          if(eventType.value == 4){ // 4 = Game
              if(homeTeam.value == visitingTeam.value){
                  alert("Home Team can not be the same as Visiting Team"); 
                  return;
              }
          } 
          if(dateEle.value == ""){
              alert("You must enter a Date by selecting selecting the calendar"); 
              return;
          }
          if(location.value == 0){ //0 = Other 
              if(other.value == ""){
                  alert("You must enter a value for Other when you select Other as the Location"); 
                  return;
              }
          } 
          document.event.submit();
        }
        function open_calendar() {
          var _x = 300;
          var _y = 200;
          cal_window=window.open('print_cal.pl?form=event&input_name=date', 'cal', 'width=175,height=150,left=' + _x + ',top=' + _y);
          return true;
        }

        function add_other_location(){
               var locationElement = document.getElementById('location');
              
               if(locationElement.value == 0){
                   enable_field("other");
               }else{
                   disable_field("other");
               }
               //getMousePosition();
        }

        function disable_field(element){
               currentElement = document.getElementById(element);
			   currentElement.value = "";
               currentElement.disabled=true;
               currentElement.style.backgroundColor="CCCCCC";
        }
        function enable_field(element){
               currentElement = document.getElementById(element);
               currentElement.disabled=false;
               currentElement.style.backgroundColor="white";
        }
        function update_fields(){
           var eventTypeElement = document.getElementById('event_type');
           
           if(eventTypeElement.value == 4){ //4=Game
               disable_field("event_name");
               enable_field("home_team");
               enable_field("visiting_team");
           }else if(eventTypeElement.value == 2){ //2=Practice
               disable_field("event_name");
               enable_field("home_team");
               disable_field("visiting_team");
           }else if(eventTypeElement.value == 3){ //3 = Preseason Game
               disable_field("event_name");
               enable_field("home_team");
               enable_field("visiting_team");
           }else if(eventTypeElement.value == 1){ // 1 = League Event
               enable_field("event_name");
               disable_field("home_team");
               disable_field("visiting_team");
           }
           //alert(eventTypeElement.value); 
        }
        //add_other_location();
        //update_fields();
        </script>
__HTML__

print <<__HTML__;
    <center>
    <FORM NAME=event METHOD ="get" ACTION="update_event2.pl" ENCTYPE="multipart/form-data">
    <input type=hidden name=event_id value=$event_id> 
    <input type=hidden name=org_id value=$org_id>
    <input type=hidden name=league_id value=$league_id>       
    <table  style='border-collapse:collapse;border:1px solid black' cellpadding=3 cellspacing=0>
    <tr><td align=center colspan=2 id=cal_events_head><b>Calendar Event</b></td></tr>

    <tr><td align=right id=cal_events3>
    Event&#160Type
    </td><td align=left id=cal_events3>
    <select class=input width=500 id=event_type name=event_type onChange=update_fields();>
__HTML__
    
    foreach $key (sort keys %event_types){
        chomp;
        #########################################
        ##  Use the event_info has to see which 
        ##  event_type was selected 
        #########################################
        if($event_types{$key} eq $event_info{"Event_Type"}){
            print "<option value='$event_types{$key}' SELECTED>$key</option>\n";
        }else{
            print "<option value='$event_types{$key}' >$key</option>\n";
        }
    }
    
print <<__HTML__;
    </select>
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Event&#160Name
    </td><td align=left id=cal_events3>
    <input class=input type=text columns=24 id=event_name name=event_name value="$event_info{"Desc"}">
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Home&#160Team
    </td><td align=left id=cal_events3>
__HTML__
    
    print "<select class=input id=home_team name=home_team>\n";
    foreach $key (sort keys %teams){
        #########################################
        ##  Use the event_info has to see which 
        ##  team was selected 
        #########################################
        if($teams{$key} eq $event_info{"Home_Team"}){
            print "<option value='$teams{$key}' SELECTED>$key</option>\n";
        }else{
            print "<option value='$teams{$key}'>$key</option>\n";
        }
    }
    print "</select>\n";
    
print <<__HTML__;
    
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Visiting&#160Team
    </td><td align=left id=cal_events3>
__HTML__
    
    print "<select class=input id=visiting_team name=visiting_team>\n";
    foreach $key (sort keys %teams){
        #########################################
        ##  Use the event_info has to see which 
        ##  team was selected 
        #########################################
        if($teams{$key} eq $event_info{"Away_Team"}){
            print "<option value='$teams{$key}' SELECTED>$key</option>\n";
        }else{
            print "<option value='$teams{$key}'>$key</option>\n";
        }
    }
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Date
    </td><td align=left id=cal_events3>
    <input class=input type=text id=date name=date READONLY value=$current_sdate>
    <a href="#" id=image_link onClick="open_calendar()";><img src="../images/calendar.gif" border=0 align=top alt="Click to insert Date"></a>
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Start&#160Time
    </td><td align=left id=cal_events3>
__HTML__
    
    print "<select class=input id=st_hour name=st_hour>\n";
    foreach(@hours){
        chomp;
        #########################################
        ##  Use the current hour has to see which 
        ##  hour was selected 
        #########################################
        if($_ eq $current_shour){
            print "<option value='$_' SELECTED>$_</option>\n";
        }else{
            print "<option value='$_'>$_</option>\n";
        }
    }
    print "</select>\n";
    
    print "<select class=input id=st_min name=st_min>\n";
    foreach(@min){
        chomp;
        #########################################
        ##  Use the current min has to see which 
        ##  min was selected 
        #########################################
        if($_ eq $current_smin){
            print "<option value='$_' SELECTED>$_</option>\n";
        }else{
            print "<option value='$_'>$_</option>\n";
        }
    }
    print "</select>\n";
    print "<select class=input id=st_ampm name=st_ampm>\n";
    foreach(@ampm){
        chomp;
        #########################################
        ##  Use the current ampm has to see which 
        ##  ampm was selected 
        #########################################
        if($_ eq $current_sampm){
            print "<option value='$_' SELECTED>$_</option>\n";
        }else{
            print "<option value='$_'>$_</option>\n";
        }
    }
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    End&#160Time
    </td><td align=left id=cal_events3>
__HTML__
    
    print "<select class=input id=et_hour name=et_hour>\n";
    foreach(@hours){
        chomp;
        #########################################
        ##  Use the current hour has to see which 
        ##  hour was selected 
        #########################################
        if($_ eq $current_ehour){
            print "<option value='$_' SELECTED>$_</option>\n";
        }else{
            print "<option value='$_'>$_</option>\n";
        }
    }
    print "</select>\n";
    
    print "<select class=input id=et_min name=et_min>\n";
    foreach(@min){
        chomp;
        #########################################
        ##  Use the current hour has to see which 
        ##  hour was selected 
        #########################################
        if($_ eq $current_emin){
            print "<option value='$_' SELECTED>$_</option>\n";
        }else{
            print "<option value='$_'>$_</option>\n";
        }
    }
    print "</select>\n";
    print "<select class=input id=et_ampm name=et_ampm>\n";
    foreach(@ampm){
        chomp;
        #########################################
        ##  Use the current hour has to see which 
        ##  hour was selected 
        #########################################
        if($_ eq $current_eampm){
            print "<option value='$_' SELECTED>$_</option>\n";
        }else{
            print "<option value='$_'>$_</option>\n";
        }
    }
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
    
    
    <tr><td align=right id=cal_events3>
    Location
    </td><td align=left id=cal_events3>
    <select class=input id=location name=location onChange=add_other_location();>
__HTML__

    foreach $key (sort keys %locations){
        #########################################
        ##  Use the event_info has to see which 
        ##  location was selected 
        #########################################
        #print "$locations{$key} eq $event_info{\"Location\"}<br>\n";
        if($locations{$key} eq $event_info{"Location"}){
            print "<option value='$locations{$key}' SELECTED>$key</option>\n";
			$use_other = 0;
        }else{
            print "<option value='$locations{$key}' >$key</option>\n";
        }
    }
	if($use_other == 1){
        print "<option value='0' SELECTED >Other</option>\n";   
	}else{
	    print "<option value='0' >Other</option>\n"; 
	}
print <<__HTML__;
    </select>
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Other
    </td><td align=left id=cal_events3>
    <input class=input type=text id=other name=other value="$event_info{"Other_Location"}">
    </td></tr>

    <tr><td align=right id=cal_events3>
    Notes
    </td><td align=left id=cal_events3>
    <textarea class=input rows=3 id=notes name=notes>$update_notes</textarea>
    </td></tr>
    
    <tr><td id=cal_events3 colspan=2 align=center>
    <input class=input type=button id=SUBMIT name=SUBMIT value=SUBMIT onClick=validate_form();>
    </td></tr>
    

    </table>
	</center>
__HTML__

    print "<script> add_other_location();\n update_fields();\n </script>\n";

}

sub print_calendar_update_tournament_event_form{
    my $event_id     = shift;
    my %event_info   = get_event_info($event_id);
	my $update_notes = $event_info{"Notes"};
    $update_notes    =~ s/<br>/\n/g;
    @hours = (1,2,3,4,5,6,7,8,9,10,11,12);
    @min   = ("00","15","30","45");
    @ampm  = ("AM", "PM");
    ($current_sdate, $current_stime) = split(/\s+/, $event_info{"Start_Date"});
    ($current_shour, $current_smin, $current_sampm) = convert_time_to_display($current_stime);
    ($current_edate, $current_etime) = split(/\s+/, $event_info{"End_Date"});
    ($current_ehour, $current_emin, $current_eampm) = convert_time_to_display($current_etime);
    $current_sdate = convert_date_to_display($current_sdate);

    %event_types  = get_event_types();
    %locations    = get_locations($event_info{"Org_ID"});
    %teams        = get_league_teams($event_info{"League_ID"});

    $locations{"Other"} = 0;

print <<__HTML__;

    <style>
        .image_link a{
                 text-decoration : none;
        }
    </style>

    <script>

        function validate_form(){
          var eventType    = document.getElementById('event_type');
          var eventName    = document.getElementById('event_name');
          var homeTeam     = document.getElementById('home_team');
          var visitingTeam = document.getElementById('visiting_team');
          var dateEle      = document.getElementById('date');
          var location     = document.getElementById('location');
          var other        = document.getElementById('other');
  
          if(eventType.value == 1){ //1 = League Event
              if(eventName.value == ""){
                  alert("You must enter a value for Event Name when entering a League Event"); 
                  return;
              }
          } 
          if(eventType.value == 4){ // 4 = Game
              if(homeTeam.value == visitingTeam.value){
                  alert("Home Team can not be the same as Visiting Team"); 
                  return;
              }
          } 
          if(dateEle.value == ""){
              alert("You must enter a Date by selecting selecting the calendar"); 
              return;
          }
          if(location.value == 0){ //0 = Other 
              if(other.value == ""){
                  alert("You must enter a value for Other when you select Other as the Location"); 
                  return;
              }
          } 
          document.event.submit();
        }
        function open_calendar() {
          var _x = 300;
          var _y = 200;
          cal_window=window.open('print_cal.pl?form=event&input_name=date', 'cal', 'width=175,height=150,left=' + _x + ',top=' + _y);
          return true;
        }

        function add_other_location(){
               var locationElement = document.getElementById('location');
              
               if(locationElement.value == 0){
                   enable_field("other");
               }else{
                   disable_field("other");
               }
               //getMousePosition();
        }

        function disable_field(element){
               currentElement = document.getElementById(element);
			   
               currentElement.disabled=true;
               currentElement.style.backgroundColor="CCCCCC";
        }
        function enable_field(element){
               currentElement = document.getElementById(element);
               currentElement.disabled=false;
               currentElement.style.backgroundColor="white";
        }
        function update_fields(){
           var eventTypeElement = document.getElementById('event_type');
           
           if(eventTypeElement.value == 4){ //4=Game
               disable_field("event_name");
               enable_field("home_team");
               enable_field("visiting_team");
           }else if(eventTypeElement.value == 2){ //2=Practice
               disable_field("event_name");
               enable_field("home_team");
               disable_field("visiting_team");
           }else if(eventTypeElement.value == 3){ //3 = Preseason Game
               disable_field("event_name");
               enable_field("home_team");
               enable_field("visiting_team");
           }else if(eventTypeElement.value == 1){ // 1 = League Event
               enable_field("event_name");
               disable_field("home_team");
               disable_field("visiting_team");
           }
           //alert(eventTypeElement.value); 
        }
        //add_other_location();
        //update_fields();
        </script>
__HTML__

print <<__HTML__;

    <FORM NAME=event METHOD ="get" ACTION="update_event2.pl" ENCTYPE="multipart/form-data">
    <input type=hidden name=event_id value=$event_id>
    <input type=hidden name=org_id value=$org_id>          
    <table bgcolor=c27c4f style='border-collapse:collapse;border:1px solid black' cellpadding=0>
    <tr><td align=center colspan=2 class=form_header>Calendar Event</td></tr>
    <tr><td>
    <table bgcolor=f6a472 border=0>
    <tr><td align=right class=form_font>
    Event Type2
    </td><td align=left>
    <select class=input width=500 id=event_type name=event_type onChange=update_fields();>
__HTML__
    
    foreach $key (sort keys %event_types){
        chomp;
        #########################################
        ##  Use the event_info has to see which 
        ##  event_type was selected 
        #########################################
        if($event_types{$key} eq $event_info{"Event_Type"}){
            print "<option value='$event_types{$key}' SELECTED>$key</option>\n";
        }else{
            print "<option value='$event_types{$key}' >$key</option>\n";
        }
    }
    
print <<__HTML__;
    </select>
    </td></tr>
    
    <tr><td align=right class=form_font>
    Event Name
    </td><td align=left>
    <input class=input type=text columns=24 id=event_name name=event_name value="$event_info{"Desc"}">
    </td></tr>
    
    <tr><td align=right class=form_font>
    Home Team
    </td><td align=left>
__HTML__
    
    print "<select class=input id=home_team name=home_team>\n";
    foreach $key (sort keys %teams){
        #########################################
        ##  Use the event_info has to see which 
        ##  team was selected 
        #########################################
        if($teams{$key} eq $event_info{"Home_Team"}){
            print "<option value='$teams{$key}' SELECTED>$key</option>\n";
        }else{
            print "<option value='$teams{$key}'>$key</option>\n";
        }
    }
    print "</select>\n";
    
print <<__HTML__;
    
    </td></tr>
    
    <tr><td align=right class=form_font>
    Visiting Team
    </td><td align=left>
__HTML__
    
    print "<select class=input id=visiting_team name=visiting_team>\n";
    foreach $key (sort keys %teams){
        #########################################
        ##  Use the event_info has to see which 
        ##  team was selected 
        #########################################
        if($teams{$key} eq $event_info{"Away_Team"}){
            print "<option value='$teams{$key}' SELECTED>$key</option>\n";
        }else{
            print "<option value='$teams{$key}'>$key</option>\n";
        }
    }
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
    
    <tr><td align=right class=form_font>
    Date
    </td><td align=left>
    <input class=input type=text id=date name=date READONLY value=$current_sdate>
    <a href="#" id=image_link onClick="open_calendar()";><img src="../images/calendar.gif" border=0 align=top alt="Click to insert Date"></a>
    </td></tr>
    
    <tr><td align=right class=form_font>
    Start Time
    </td><td align=left>
__HTML__
    
    print "<select class=input id=st_hour name=st_hour>\n";
    foreach(@hours){
        chomp;
        #########################################
        ##  Use the current hour has to see which 
        ##  hour was selected 
        #########################################
        if($_ eq $current_shour){
            print "<option value='$_' SELECTED>$_</option>\n";
        }else{
            print "<option value='$_'>$_</option>\n";
        }
    }
    print "</select>\n";
    
    print "<select class=input id=st_min name=st_min>\n";
    foreach(@min){
        chomp;
        #########################################
        ##  Use the current min has to see which 
        ##  min was selected 
        #########################################
        if($_ eq $current_smin){
            print "<option value='$_' SELECTED>$_</option>\n";
        }else{
            print "<option value='$_'>$_</option>\n";
        }
    }
    print "</select>\n";
    print "<select class=input id=st_ampm name=st_ampm>\n";
    foreach(@ampm){
        chomp;
        #########################################
        ##  Use the current ampm has to see which 
        ##  ampm was selected 
        #########################################
        if($_ eq $current_sampm){
            print "<option value='$_' SELECTED>$_</option>\n";
        }else{
            print "<option value='$_'>$_</option>\n";
        }
    }
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
    
    <tr><td align=right class=form_font>
    End Time
    </td><td align=left>
__HTML__
    
    print "<select class=input id=et_hour name=et_hour>\n";
    foreach(@hours){
        chomp;
        #########################################
        ##  Use the current hour has to see which 
        ##  hour was selected 
        #########################################
        if($_ eq $current_ehour){
            print "<option value='$_' SELECTED>$_</option>\n";
        }else{
            print "<option value='$_'>$_</option>\n";
        }
    }
    print "</select>\n";
    
    print "<select class=input id=et_min name=et_min>\n";
    foreach(@min){
        chomp;
        #########################################
        ##  Use the current hour has to see which 
        ##  hour was selected 
        #########################################
        if($_ eq $current_emin){
            print "<option value='$_' SELECTED>$_</option>\n";
        }else{
            print "<option value='$_'>$_</option>\n";
        }
    }
    print "</select>\n";
    print "<select class=input id=et_ampm name=et_ampm>\n";
    foreach(@ampm){
        chomp;
        #########################################
        ##  Use the current hour has to see which 
        ##  hour was selected 
        #########################################
        if($_ eq $current_eampm){
            print "<option value='$_' SELECTED>$_</option>\n";
        }else{
            print "<option value='$_'>$_</option>\n";
        }
    }
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
    
    
    <tr><td align=right class=form_font>
    Location
    </td><td align=left>
    <select class=input id=location name=location onChange=add_other_location();>
__HTML__

    foreach $key (sort keys %locations){
        #########################################
        ##  Use the event_info has to see which 
        ##  location was selected 
        #########################################
        #print "$locations{$key} eq $event_info{\"Location\"}<br>\n";
        if($locations{$key} eq $event_info{"Location"}){
            print "<option value='$locations{$key}' SELECTED>$key</option>\n";
        }else{
            print "<option value='$locations{$key}' >$key</option>\n";
        }
    }
    
print <<__HTML__;
    </select>
    </td></tr>
    
    <tr><td align=right class=form_font>
    Other
    </td><td align=left>
    <input class=input type=text id=other name=other value="$event_info{"Other_Location"}">
    </td></tr>

    <tr><td align=right class=form_font>
    Notes
    </td><td align=left>
    <textarea class=input rows=3 id=notes name=notes>$update_notes</textarea>
    </td></tr>
    
    <tr><td class=form_font colspan=2 align=center>
    <input class=input type=button id=SUBMIT name=SUBMIT value=SUBMIT onClick=validate_form();>
    </td></tr>
    
    </table>
    </td></tr>
    </table>
__HTML__

    print "<script> add_other_location();\n update_fields();\n </script>\n";

}



#################################################################
## Print the Update Form
#################################################################

sub print_calendar_event_form{
    my $org_id    = shift;
    my $league_id = shift;

    @hours = (1,2,3,4,5,6,7,8,9,10,11,12);
    @min   = (00,15,30,45);
    @ampm  = ("AM", "PM");

    %event_types  = get_event_types();
    %locations    = get_locations($org_id);
    %teams        = get_league_teams($league_id);



    #$locations{"Other"} = 0;

print <<__HTML__;

    <style>
        .image_link a{
                 text-decoration : none;
        }
    </style>

    <script>

        function validate_form(){
          var eventType    = document.getElementById('event_type');
          var eventName    = document.getElementById('event_name');
          var homeTeam     = document.getElementById('home_team');
          var visitingTeam = document.getElementById('visiting_team');
          var dateEle      = document.getElementById('date');
          var location     = document.getElementById('location');
          var other        = document.getElementById('other');
  
          if(eventType.value == 1){ //1 = League Event
              if(eventName.value == ""){
                  alert("You must enter a value for Event Name when entering a League Event"); 
                  return;
              }
          } 
          if(eventType.value == 4){ // 4 = Game
              if(homeTeam.value == visitingTeam.value){
                  alert("Home Team can not be the same as Visiting Team"); 
                  return;
              }
          } 
          if(dateEle.value == ""){
              alert("You must enter a Date by selecting selecting the calendar"); 
              return;
          }
          if(location.value == 0){ //0 = Other 
              if(other.value == ""){
                  alert("You must enter a value for Other when you select Other as the Location"); 
                  return;
              }
          } 
          document.event.submit();
        }
        function open_calendar() {
          var _x = 300;
          var _y = 200;
          cal_window=window.open('print_cal.pl?form=event&input_name=date', 'cal', 'width=175,height=150,left=' + _x + ',top=' + _y);
          return true;
        }

        function add_other_location(){
               var locationElement = document.getElementById('location');
              
               if(locationElement.value == 0){
                   enable_field("other");
               }else{
                   disable_field("other");
               }
               //getMousePosition();
        }

        function disable_field(element){
               currentElement = document.getElementById(element);
			   currentElement.value = "";
               currentElement.disabled=true;
               currentElement.style.backgroundColor="CCCCCC";
        }
        function enable_field(element){
               currentElement = document.getElementById(element);
               currentElement.disabled=false;
               currentElement.style.backgroundColor="white";
        }
        function update_fields(){
           var eventTypeElement = document.getElementById('event_type');
           
           if(eventTypeElement.value == 4){ //4=Game
               disable_field("event_name");
               enable_field("home_team");
               enable_field("visiting_team");
           }else if(eventTypeElement.value == 2){ //2=Practice
               disable_field("event_name");
               enable_field("home_team");
               disable_field("visiting_team");
           }else if(eventTypeElement.value == 3){ //3 = Preseason Game
               disable_field("event_name");
               enable_field("home_team");
               enable_field("visiting_team");
           }else if(eventTypeElement.value == 1){ // 1 = League Event
               enable_field("event_name");
               disable_field("home_team");
               disable_field("visiting_team");
           }
           //alert(eventTypeElement.value); 
        }
        //add_other_location();
        //update_fields();
        </script>
__HTML__

print <<__HTML__;
    <center>
    <FORM NAME=event METHOD ="get" ACTION="insert_event2.pl" ENCTYPE="multipart/form-data">
    <input type=hidden name=org_id value=$org_id>
    <input type=hidden name=league_id value=$league_id>
    <table style='border-collapse:collapse;border:1px solid black' cellpadding=3 cellspacing=0>
    <tr><td align=center colspan=2 id=cal_events_head><b>Calendar Event</b></td></tr>

    <tr><td align=right id=cal_events3>
    Event&#160Type
    </td><td align=left id=cal_events3>
    <select class=input width=500 id=event_type name=event_type onChange=update_fields();>
__HTML__
    
    foreach $key (sort keys %event_types){
        chomp;
        print "<option value='$event_types{$key}' >$key</option>\n";
    }
    
print <<__HTML__;
    </select>
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Event&#160Name
    </td><td align=left id=cal_events3>
    <input class=input type=text columns=24 id=event_name name=event_name >
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Home&#160Team
    </td><td align=left id=cal_events3>
__HTML__
    
    print "<select class=input id=home_team name=home_team>\n";
    foreach $key (sort keys %teams){
        print "<option value='$teams{$key}' >$key</option>\n";
    }
    print "</select>\n";
    
print <<__HTML__;
    
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Visiting&#160Team
    </td><td align=left id=cal_events3>
__HTML__
    
    print "<select class=input id=visiting_team name=visiting_team>\n";
    foreach $key (sort keys %teams){
        print "<option value='$teams{$key}' >$key</option>\n";
    }
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Date
    </td><td align=left id=cal_events3>
    <input class=input type=text id=date name=date READONLY>
    <a href="#" id=image_link onClick="open_calendar()";><img src="../images/calendar.gif" border=0 align=top alt="Click to insert Date"></a>
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Start&#160Time
    </td><td align=left id=cal_events3>
__HTML__
    
    print "<select class=input id=st_hour name=st_hour>\n";
    foreach(@hours){
        chomp;
        print "<option value='$_' >$_</option>\n";
    }
    print "</select>\n";
    
    print "<select class=input id=st_min name=st_min>\n";
    foreach(@min){
        chomp;
        print "<option value='$_' >$_</option>\n";
    }
    print "</select>\n";
    print "<select class=input id=st_ampm name=st_ampm>\n";
    foreach(@ampm){
        chomp;
        print "<option value='$_' >$_</option>\n";
    }
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    End&#160Time
    </td><td align=left id=cal_events3>
__HTML__
    
    print "<select class=input id=et_hour name=et_hour>\n";
    foreach(@hours){
        chomp;
        print "<option value='$_' >$_</option>\n";
    }
    print "</select>\n";
    
    print "<select class=input id=et_min name=et_min>\n";
    foreach(@min){
        chomp;
        print "<option value='$_' >$_</option>\n";
    }
    print "</select>\n";
    print "<select class=input id=et_ampm name=et_ampm>\n";
    foreach(@ampm){
        chomp;
        print "<option value='$_' >$_</option>\n";
    }
    print "</select>\n";
    
print <<__HTML__;
    </td></tr>
    
    
    <tr><td align=right id=cal_events3>
    Location
    </td><td align=left id=cal_events3>
    <select class=input id=location name=location onChange=add_other_location();>
__HTML__

    foreach $key (sort keys %locations){
        print "<option value='$locations{$key}' >$key</option>\n";
    }
	print "<option value='0' >Other</option>\n";
    
print <<__HTML__;
    </select>
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Other
    </td><td align=left id=cal_events3>
    <input class=input type=text id=other name=other>
    </td></tr>

    <tr><td align=right id=cal_events3>
    Notes
    </td><td align=left id=cal_events3>
    <textarea class=input rows=3 id=notes name=notes></textarea>
    </td></tr>
    
    <tr><td id=cal_events3 colspan=2 align=center>
    <input class=input type=button id=SUBMIT name=SUBMIT value=SUBMIT onClick=validate_form();>
    </td></tr>
    

    </table>
__HTML__

    print "<script> add_other_location();\n update_fields();\n </script>\n";

}

#################################################################
## Print the Update Form
#################################################################

sub print_calendar_event_form_with_fields{
    my $org_id    = shift;
    my $league_id = shift;

    @hours = (1,2,3,4,5,6,7,8,9,10,11,12);
    @min   = (00,15,30,45);
    @ampm  = ("AM", "PM");

    %event_types  = get_event_types();
    %locations    = get_locations($org_id);
    %teams        = get_league_teams($league_id);



    #$locations{"Other"} = 0;

$html = <<__HTML__;
<html><head>
<title>Ordinary CGI demo</title>
<script type="text/javascript" src="../jscripts/datebinding.js"></script>

</head>
__HTML__

#print_style();

$html = <<__HTML__;
	<BODY bgcolor=white>
    <style>
        .image_link a{
                 text-decoration : none;
        }
    </style>

    <script>

        function validate_form(){
          var eventType    = document.getElementById('event_type');
          var eventName    = document.getElementById('event_name');
          var homeTeam     = document.getElementById('home_team');
          var visitingTeam = document.getElementById('visiting_team');
          var dateEle      = document.getElementById('date');
          var location     = document.getElementById('location');
          var other        = document.getElementById('other');
  
          if(eventType.value == 1){ //1 = League Event
              if(eventName.value == ""){
                  alert("You must enter a value for Event Name when entering a League Event"); 
                  return;
              }
          } 
          if(eventType.value == 4){ // 4 = Game
              if(homeTeam.value == visitingTeam.value){
                  alert("Home Team can not be the same as Visiting Team"); 
                  return;
              }
          } 
          if(dateEle.value == ""){
              alert("You must enter a Date by selecting selecting the calendar"); 
              return;
          }
          if(location.value == 0){ //0 = Other 
              if(other.value == ""){
                  alert("You must enter a value for Other when you select Other as the Location"); 
                  return;
              }
          } 
          document.event.submit();
        }
        function open_calendar() {
          var _x = 300;
          var _y = 200;
          cal_window=window.open('print_cal.pl?form=event&input_name=date', 'cal', 'width=175,height=150,left=' + _x + ',top=' + _y);
          return true;
        }

        function add_other_location(){
               var locationElement = document.getElementById('location');
              
               if(locationElement.value == 0){
                   enable_field("other");
               }else{
                   disable_field("other");
               }
               //getMousePosition();
        }

        function disable_field(element){
               currentElement = document.getElementById(element);
			   currentElement.value = "";
               currentElement.disabled=true;
               currentElement.style.backgroundColor="CCCCCC";
        }
        function enable_field(element){
               currentElement = document.getElementById(element);
               currentElement.disabled=false;
               currentElement.style.backgroundColor="white";
        }
        function update_fields(){
           var eventTypeElement = document.getElementById('event_type');
           
           if(eventTypeElement.value == 4){ //4=Game
               disable_field("event_name");
               enable_field("home_team");
               enable_field("visiting_team");
           }else if(eventTypeElement.value == 2){ //2=Practice
               disable_field("event_name");
               enable_field("home_team");
               disable_field("visiting_team");
           }else if(eventTypeElement.value == 3){ //3 = Preseason Game
               disable_field("event_name");
               enable_field("home_team");
               enable_field("visiting_team");
           }else if(eventTypeElement.value == 1){ // 1 = League Event
               enable_field("event_name");
               disable_field("home_team");
               disable_field("visiting_team");
           }
           //alert(eventTypeElement.value); 
        }
        //add_other_location();
        //update_fields();
        </script>
__HTML__

$html .= <<__HTML__;
    <center>
    <FORM NAME=event METHOD ="get" ACTION="insert_event2.pl" ENCTYPE="multipart/form-data">
    <input type=hidden name=org_id value=$org_id>
    <input type=hidden name=league_id value=$league_id>
	<table><tr><td>
    <table style='border-collapse:collapse;border:1px solid black' cellpadding=3 cellspacing=0>
    <tr><td align=center colspan=2 id=cal_events_head><b>Calendar Event</b></td></tr>

    <tr><td align=right id=cal_events3>
    Event&#160Type
    </td><td align=left id=cal_events3>
    <select class=input width=500 id=event_type name=event_type onChange=update_fields();>
__HTML__
    
    foreach $key (sort keys %event_types){
        chomp;
        $html .= "<option value='$event_types{$key}' >$key</option>\n";
    }
    
$html .= <<__HTML__;
    </select>
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Event&#160Name
    </td><td align=left id=cal_events3>
    <input class=input type=text columns=24 id=event_name name=event_name >
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Home&#160Team
    </td><td align=left id=cal_events3>
__HTML__
    
    $html .= "<select class=input id=home_team name=home_team>\n";
    foreach $key (sort keys %teams){
        $html .= "<option value='$teams{$key}' >$key</option>\n";
    }
    $html .= "</select>\n";
    
$html .= <<__HTML__;
    
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Visiting&#160Team
    </td><td align=left id=cal_events3>
__HTML__
    
    $html .= "<select class=input id=visiting_team name=visiting_team>\n";
    foreach $key (sort keys %teams){
        $html .= "<option value='$teams{$key}' >$key</option>\n";
    }
    $html .= "</select>\n";
    
$html .= <<__HTML__;
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Date
    </td><td align=left id=cal_events3>
    <input class=input type=text id=date name=date READONLY>
    <a href="#" id=image_link onClick="open_calendar()";><img src="../images/calendar.gif" border=0 align=top alt="Click to insert Date"></a>
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Start&#160Time
    </td><td align=left id=cal_events3>
__HTML__
    
    $html .= "<select class=input id=st_hour name=st_hour>\n";
    foreach(@hours){
        chomp;
        $html .= "<option value='$_' >$_</option>\n";
    }
    $html .= "</select>\n";
    
    $html .= "<select class=input id=st_min name=st_min>\n";
    foreach(@min){
        chomp;
        $html .= "<option value='$_' >$_</option>\n";
    }
    $html .= "</select>\n";
    $html .= "<select class=input id=st_ampm name=st_ampm>\n";
    foreach(@ampm){
        chomp;
        $html .= "<option value='$_' >$_</option>\n";
    }
    $html .= "</select>\n";
    
$html .= <<__HTML__;
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    End&#160Time
    </td><td align=left id=cal_events3>
__HTML__
    
    $html .= "<select class=input id=et_hour name=et_hour>\n";
    foreach(@hours){
        chomp;
        $html .= "<option value='$_' >$_</option>\n";
    }
    $html .= "</select>\n";
    
    $html .= "<select class=input id=et_min name=et_min>\n";
    foreach(@min){
        chomp;
        $html .= "<option value='$_' >$_</option>\n";
    }
    $html .= "</select>\n";
    $html .= "<select class=input id=et_ampm name=et_ampm>\n";
    foreach(@ampm){
        chomp;
        $html .= "<option value='$_' >$_</option>\n";
    }
    $html .= "</select>\n";
    
$html .= <<__HTML__;
    </td></tr>
    
    
    <tr><td align=right id=cal_events3>
    Location
    </td><td align=left id=cal_events3>
    <select class=input id=location name=location onChange=add_other_location();>
__HTML__

    foreach $key (sort keys %locations){
        $html .= "<option value='$locations{$key}' >$key</option>\n";
    }
	$html .= "<option value='0' >Other</option>\n";
    
$html .= <<__HTML__;
    </select>
    </td></tr>
    
    <tr><td align=right id=cal_events3>
    Other
    </td><td align=left id=cal_events3>
    <input class=input type=text id=other name=other>
    </td></tr>

    <tr><td align=right id=cal_events3>
    Notes
    </td><td align=left id=cal_events3>
    <textarea class=input rows=3 id=notes name=notes></textarea>
    </td></tr>
    
    <tr><td id=cal_events3 colspan=2 align=center>
    <input class=input type=button id=SUBMIT name=SUBMIT value=SUBMIT onClick=validate_form();>
    </td></tr>
    

    </table>
	</td><td>
		<em id="rollingcal"></em>
        <table style='border-collapse:collapse;border:1px solid black' cellpadding=3 cellspacing=0>
    <tr><td align=center colspan=2 id=cal_events_head><b>Calendar Event</b></td></tr>

    <tr><td align=right id=cal_events3>
    Event&#160Type
    </td><td align=left id=cal_events3>
    </td></tr></table>
	</td></tr>
	</table>
__HTML__

    $html .= "<script> add_other_location();\n update_fields();\n </script>\n";
    return $html;
}


sub get_org_teams{
    my $org_id = shift;
    my $dbh = get_dbh(); 
	my $League_ID = "";
	my $Team_Name = "";
	my $Division_ID = "";

    # prepare and execute query
    my $query = "SELECT a.`Key`, a.`League_ID`, a.`Team_Name`, a.`Division_ID` FROM `Team_Info` a, `League_Info` b WHERE a.`League_ID`=b.`Key` AND b.`ORG_ID`=$org_id ORDER BY Team_Name ASC";
    #print "$query<br>\n";
	my $sth = $dbh->prepare($query);
    my %return_hash;
    my $ID;
    my $event_type;
    $sth->execute();

    # assign fields to variables
    $sth->bind_columns(\$ID, \$League_ID, \$Team_Name, \$Division_ID);

    # output name list to the browser
    while($sth->fetch()) {
       $return_hash{$ID} = $Team_Name;
    }

    $sth->finish();
    # disconnect from database
    $dbh->disconnect;
    return %return_hash;
}

sub get_league_teams{
    my $league_id = shift;
    my $dbh = get_dbh(); 

    # prepare and execute query
    my $query = "SELECT * FROM Team_Info WHERE League_ID=$league_id ORDER BY Team_Name ASC";
    #print "$query<br>\n";
	my $sth = $dbh->prepare($query);
    my %return_hash;
    my $ID;
    my $event_type;
    $sth->execute();

    # assign fields to variables
    $sth->bind_columns(\$ID, \$League_ID, \$Team_Name, \$Division_ID, \$Status);

    # output name list to the browser
    while($sth->fetch()) {
       $return_hash{$Team_Name} = $ID;
    }

    $sth->finish();
    # disconnect from database
    $dbh->disconnect;
    return %return_hash;
}

sub get_league_teams_w_division{
    my $league_id = shift;
    my $dbh = get_dbh(); 
	my %return_hash = ();

    # prepare and execute query
    my $query = "SELECT * FROM Team_Info WHERE League_ID=$league_id ORDER BY Team_Name ASC";
    my $sth = $dbh->prepare($query);
    my @return_array = ();
    my $ID;
    my $event_type;
    $sth->execute();

    # assign fields to variables
    $sth->bind_columns(\$ID, \$League_ID, \$team_name, \$Division_ID, \$Status);

    # output name list to the browser
    while($sth->fetch()) {
       $return_hash{$team_name}{$team_name} = $ID;
       $return_hash{$team_name}{"Division_ID"} = $Division_ID;
    }

    $sth->finish();
    # disconnect from database
    $dbh->disconnect;
    return %return_hash;
}

sub get_event_types{
    my $dbh = get_dbh(); 

    # prepare and execute query
    my $query = "SELECT * FROM event_type WHERE 1 ORDER BY event_type ASC";
    my $sth = $dbh->prepare($query);
    my %return_hash = ();
    my $ID;
    my $event_type;
    $sth->execute();

    # assign fields to variables
    $sth->bind_columns(\$ID, \$event_type);

    # output name list to the browser
    while($sth->fetch()) {
       $return_hash{$event_type} = $ID;
    }

    $sth->finish();
    # disconnect from database
    $dbh->disconnect;
    return %return_hash;
}

sub get_locations_old{
    my $Org_ID = shift;
    my $dbh = get_dbh(); 

    # prepare and execute query
    my $query = "SELECT * FROM Location_Info WHERE Org_ID = $Org_ID AND Archived = 0 ORDER BY Location ASC";
    my $sth = $dbh->prepare($query);
    my %return_hash = ();
    my $ID;
    my $Location;
    $sth->execute();

    # assign fields to variables
    $sth->bind_columns(\$ID, \$Org_ID, \$Location, \$Address, \$Address_Link, \$Directions, \$Order, \$Archived);

    # output name list to the browser
    while($sth->fetch()) {
       $return_hash{$Location} = $ID;
    }

    $sth->finish();
    # disconnect from database
    $dbh->disconnect;
    return %return_hash;
}

sub get_subscriber_locations{
    my $Org_ID = shift;
    my $dbh = get_dbh(); 

    # prepare and execute query
    my $query = "SELECT a.`Key`, a.`Location` FROM Location_Info a, Location_Subscriber_Link b WHERE b.`Org_ID` = '$Org_ID' AND a.`Key` = b.`Location_ID` AND a.`Archived` = 0 ORDER BY a.`Location` ASC";
    my $sth = $dbh->prepare($query);
    my %return_hash = ();
    my $ID;
    my $Location;
    $sth->execute();

    # assign fields to variables
    $sth->bind_columns(\$ID, \$Location);

    # output name list to the browser
    while($sth->fetch()) {
       $return_hash{$Location} = $ID;
    }

    $sth->finish();
    # disconnect from database
    $dbh->disconnect;
    return %return_hash;
}
############################################
# Get All Independent Teams and Leagues for ORG
############################################
sub get_leagues_and_independent_teams_by_org_b{
    my $org_id = shift;
    my $dbh = get_dbh(); 

    # prepare and execute query
    #my $query = "SELECT `Key`, `League_Name` FROM League_Info WHERE `Org_ID` = '$org_id'";
    my $query = "SELECT `League_ID`, `Menu_Name` FROM Menu_Info WHERE `Org_ID` = '$org_id' AND (`Menu_Type` = 'league' OR `Menu_Type` = 'team')";
    #print "SELECT: $query<br>\n";
    my $sth = $dbh->prepare($query);
    my %return_hash = ();
    my $ID;
    
    $sth->execute();

    # assign fields to variables
    $sth->bind_columns(\$ID, \$League_Name);
    
    # output name list to the browser
    while($sth->fetch()) {
       $return_hash{$League_Name} = $ID;
    }

    $sth->finish();
    # disconnect from database
    $dbh->disconnect;
    return %return_hash;
}
sub get_leagues_that_subscribe_to_locations{
    my $Org_ID = shift; 
    my %orgs_that_subscribe_to_locations = get_orgs_that_subscribed_to_locations($Org_ID);
	my %leagues_that_subscribe = ();
	foreach my $subscribe_org (keys %orgs_that_subscribe_to_locations) {
		my $subscribe_org_short = get_org_short($subscribe_org);
		my %leagues_in_org = get_leagues_and_independent_teams_by_org_b($subscribe_org);
            foreach my $league (sort keys %leagues_in_org) {
			    $leagues_that_subscribe{"$subscribe_org_short, $league"} = $leagues_in_org{$league};
			}
	}
	return %leagues_that_subscribe;

}
sub get_orgs_that_subscribed_to_locations{
    my $Org_ID = shift;
    my $dbh = get_dbh(); 

    # prepare and execute query
    my $query = "SELECT DISTINCT(a.`Org_ID`) FROM `Location_Subscriber_Link` a, `Location_Info` b WHERE a.`Location_id` = b.`Key` AND b.`Org_ID` = '$org_id'";
    my $sth = $dbh->prepare($query);
    my %return_hash = ();
    my $ID;
    my $Location;
    $sth->execute();

    # assign fields to variables
    $sth->bind_columns(\$ORG_ID);

    # output name list to the browser
    while($sth->fetch()) {
       $return_hash{$ORG_ID} = 1;
    }

    $sth->finish();
    # disconnect from database
    $dbh->disconnect;
    return %return_hash;
}
sub get_locations{
    my $Org_ID = shift;
    my $dbh = get_dbh(); 

    ######################################3
	# Get This Org Locations
	#######################################
    # prepare and execute query
    my $query = "SELECT * FROM Location_Info WHERE Org_ID = $Org_ID AND Archived = 0 ORDER BY Location ASC";
    my $sth = $dbh->prepare($query);
    my %return_hash = ();
    my $ID;
    my $Location;
    $sth->execute();

    # assign fields to variables
    $sth->bind_columns(\$ID, \$Org_ID, \$Location, \$Address, \$Address_Link, \$Directions, \$Order, \$Archived);

    # output name list to the browser
    while($sth->fetch()) {
       $return_hash{$Location} = $ID;
    }

    $sth->finish();

    ######################################3
	# Get Subscriber Locations 
	# Note Subscriber will overwrite regular
	#######################################
    # prepare and execute query
    $query = "SELECT a.`Key`, a.`Location` FROM Location_Info a, Location_Subscriber_Link b WHERE b.`Org_ID` = '$Org_ID' AND a.`Key` = b.`Location_ID` AND a.`Archived` = 0 ORDER BY a.`Location` ASC";
    $sth = $dbh->prepare($query);

    $ID = "";
    $Location = "";
    $sth->execute();

    # assign fields to variables
    $sth->bind_columns(\$ID, \$Location);

    # output name list to the browser
    while($sth->fetch()) {
       $return_hash{$Location} = $ID;
    }

    $sth->finish();
    # disconnect from database
    $dbh->disconnect;
    return %return_hash;
}

######################################3
# Get Locations with link
# Note: These include archives
#######################################
sub get_locations_with_link_no_archive{
    my $Org_ID = shift;
    my $dbh = get_dbh(); 

    # prepare and execute query
    my $query = "SELECT * FROM Location_Info WHERE Org_ID = $Org_ID AND Archived = 0 ORDER BY Location ASC";
    my $sth = $dbh->prepare($query);
    my %return_hash = ();
    my $ID;
    my $Location;
    $sth->execute();

    # assign fields to variables
    $sth->bind_columns(\$ID, \$Org_ID, \$Location, \$Address, \$Address_Link, \$Directions, \$Order, \$Archived);

    # output name list to the browser
    while($sth->fetch()) {
       $return_hash{$ID}{"Location"} = $Location;
	   $return_hash{$ID}{"LINK"}     = $Address_Link;
	   $return_hash{$ID}{"ORG_ID"}   = $Org_ID;
    }

    $sth->finish();


    ######################################3
	# Get Subscriber Locations 
	# Note Subscriber will overwrite regular
	#######################################
    # prepare and execute query
    $query = "SELECT a.`Key`, a.`Location`, a.`Address_Link`, a.`Org_ID` FROM Location_Info a, Location_Subscriber_Link b WHERE b.`Org_ID` = '$Org_ID' AND a.`Key` = b.`Location_ID` AND a.`Archived` = 0 ORDER BY a.`Location` ASC";
    $sth = $dbh->prepare($query);

    $ID = "";
    $Location = "";
    $sth->execute();

    # assign fields to variables
    $sth->bind_columns(\$ID, \$Location, \$Address_Link, \$Org_ID);

    # output name list to the browser
    while($sth->fetch()) {
       $return_hash{$ID}{"Location"} = $Location;
	   $return_hash{$ID}{"LINK"}     = $Address_Link;
	   $return_hash{$ID}{"ORG_ID"}   = $Org_ID;
    }

    $sth->finish();
    # disconnect from database
    $dbh->disconnect;
    return %return_hash;
}


######################################3
# Get Locations with link
# Note: These include archives
#######################################
sub get_locations_with_link{
    my $Org_ID = shift;
    my $dbh = get_dbh(); 

    # prepare and execute query
    my $query = "SELECT * FROM Location_Info WHERE Org_ID = $Org_ID ORDER BY Location ASC";
    my $sth = $dbh->prepare($query);
    my %return_hash = ();
    my $ID;
    my $Location;
    $sth->execute();

    # assign fields to variables
    $sth->bind_columns(\$ID, \$Org_ID, \$Location, \$Address, \$Address_Link, \$Directions, \$Order, \$Archived);

    # output name list to the browser
    while($sth->fetch()) {
       $return_hash{$ID}{"Location"} = $Location;
	   $return_hash{$ID}{"LINK"}     = $Address_Link;
	   $return_hash{$ID}{"ORG_ID"}   = $Org_ID;
    }

    $sth->finish();


    ######################################3
	# Get Subscriber Locations 
	# Note Subscriber will overwrite regular
	#######################################
    # prepare and execute query
    #my $query = "SELECT a.`Key`, a.`Location`, a.`Address_Link`, a.`Org_ID` FROM Location_Info a, Location_Subscriber_Link b WHERE b.`Org_ID` = '$Org_ID' AND a.`Key` = b.`Location_ID` AND a.`Archived` = 0 ORDER BY a.`Location` ASC";
    $query = "SELECT a.`Key`, a.`Location`, a.`Address_Link`, a.`Org_ID` FROM Location_Info a, Location_Subscriber_Link b WHERE b.`Org_ID` = '$Org_ID' AND a.`Key` = b.`Location_ID` ORDER BY a.`Location` ASC";
    $sth = $dbh->prepare($query);

    $ID = "";
    $Location = "";
    $sth->execute();

    # assign fields to variables
    $sth->bind_columns(\$ID, \$Location, \$Address_Link, \$Org_ID);

    # output name list to the browser
    while($sth->fetch()) {
       $return_hash{$ID}{"Location"} = $Location;
	   $return_hash{$ID}{"LINK"}     = $Address_Link;
	   $return_hash{$ID}{"ORG_ID"}   = $Org_ID;
    }

    $sth->finish();
    # disconnect from database
    $dbh->disconnect;
    return %return_hash;
}


sub get_locations_with_link_old{
    my $Org_ID = shift;
    my $dbh = get_dbh(); 

    # prepare and execute query
    my $query = "SELECT * FROM Location_Info WHERE Org_ID = $Org_ID ORDER BY Location ASC";
    my $sth = $dbh->prepare($query);
    my %return_hash = ();
    my $ID;
    my $Location;
    $sth->execute();

    # assign fields to variables
    $sth->bind_columns(\$ID, \$Org_ID, \$Location, \$Address, \$Address_Link, \$Directions, \$Order, \$Archived);

    # output name list to the browser
    while($sth->fetch()) {
       $return_hash{$ID}{"Location"} = $Location;
	   $return_hash{$ID}{"LINK"}     = $Address_Link;
    }

    $sth->finish();
    # disconnect from database
    $dbh->disconnect;
    return %return_hash;
}

sub print_start_header{
my $title = shift;
print <<__HTML__;
Content-type: text/html

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<HTML>

<HEAD><TITLE>$title</TITLE>

</HEAD>
__HTML__

}
#############################################
# Convert Time for Database Entry
#############################################
sub convert_time{
    my $hour = shift;
    my $min  = shift;
    my $ampm = lc(shift);

    ##########################################
    # If ampm = pm add 12 hours for 24 hour time
    # unless its noon.
    ##########################################
    if($ampm eq "pm"){ 
        if($hour != 12){
            $hour = $hour + 12;
        }
    ##########################################
    # If 12 am, hours = 0
    ##########################################
    }else{
        if($hour == 12){
            $hour = 0;
        }
    }
    $hour = sprintf("%02d", $hour);
    $min  = sprintf("%02d", $min);
     
    my $return_string = $hour . ":" . $min . ":00";
    return $return_string;
}


sub convert_date{
    my $old_date = shift;
    my ($month, $day, $year) = split(/\//,$old_date);
    $month = sprintf("%02d", $month);
    $day   = sprintf("%02d", $day);
    my $return_string = $year . "-" . $month . "-" . $day;
    return $return_string;
}
sub convert_date_to_display{
    my $old_date = shift;
    my ($year, $month, $day) = split(/-/,$old_date);
    $month = sprintf("%1d", $month);
    $day   = sprintf("%1d", $day);
    my $return_string = $month . "/" . $day . "/" . $year;
    return $return_string;
}
sub convert_time_to_display{
    my $time = shift;
    my $hour;
    my $min;
    my $sec;
    my $ampm;
    my @return_array = ();
    ($hour, $min, $sec) = split(/:/,$time);
    if($hour > 12){
        $hour = $hour - 12;
        $ampm = "PM";
    }elsif($hour == 0){
        $hour = 12; 
        $ampm = "AM";
    }elsif($hour == 12){
        $ampm = "PM";
    }else{
        $ampm = "AM";
    } 
    $hour = sprintf("%1d", $hour);
    #$min  = sprintf("%1d", $min);
     
    push(@return_array, $hour);
    push(@return_array, $min);
    push(@return_array, $ampm);
    
    #return ($hour, min, $ampm);
    return @return_array;
}



1;