<?
$extcss='';

require ("appheader.php");


if ($_SESSION['lang'] == "zh-hant")
{ 
$headertitle = "Live Track system - 烈日落山賽 2017 - 扯旗山";
} else {
$headertitle = "Live Track system - TRAILS OF FIRE – DOWNHILL CHALLENGE  -  VICTORIA PEAK";
}
$headerdescription = "";
$headerimg = "https://livetrack.sportsystem.hk/trails-of-fire-2017a/images/trails-of-fire-1280.jpg";


require ("header_inline.php");

 /*---------------*/
  

  



$select_gender = "";
$select_group = "";

$select_course = "TRAILSOFFIRE2017B";

//if (intval($_GET['course']))
//{
//	$select_course = $_GET['course'];
//}

if (intval($_GET['group']))
{
	$select_group = $_GET['group'];
}

if (intval($_GET['gender']) == 1)
{
	$select_gender = "M";
}
if (intval($_GET['gender']) == 2)
{
	$select_gender = "F";
}

if ($select_group)
{
$field = 'place_group';
} 

if ($select_gender)
{
$field = 'place_gender';
} 



$sql = "select * from ". $table_prefix ."course";
$stmt = $db->prepare($sql);
$stmt->execute();	
$coursestemp = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($coursestemp as $temp)
{
		$courses[$temp['code']] = $temp;
}

$current_course = $courses[$select_course];
//d($courses);
//d($select_course);

$sql = "select * from ". $table_prefix ."runner_groups";
$stmt = $db->prepare($sql);
$stmt->execute();	
$runner_groupstemp = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($runner_groupstemp as $temp)
{
		$runner_groups[$temp['id']] = $temp;
}



$sql = "select cp_code,count(bibno) as c from ". $table_prefix ."trackrecord_final where  cp_code is not null group by cp_code";
//d($sql);
$stmt = $db->prepare($sql);
$stmt->execute();	
$overall = $stmt->fetchAll(PDO::FETCH_ASSOC);


if ($field == "place_group")
{
	$sql = "select * from ". $table_prefix ."runners where   find_in_set(6,cat) and  age_group = " . $select_group  . " order by bibno";
	$stmt = $db->prepare($sql);
	$stmt->execute();	
	$runnerstemp = $stmt->fetchAll(PDO::FETCH_ASSOC);
	foreach ($runnerstemp as $temp)
	{
			$runner[$temp['bibno']] = $temp;
	}
} else if ($field == "place_gender")
{
	$sql = "select * from ". $table_prefix ."runners where   find_in_set(6,cat) and  gender = '" . $select_gender  . "' order by bibno";
	
	$stmt = $db->prepare($sql);
	$stmt->execute();	
	$runnerstemp = $stmt->fetchAll(PDO::FETCH_ASSOC);
	foreach ($runnerstemp as $temp)
	{
			$runner[$temp['bibno']] = $temp;
	}
} else {

	$field = "place_course";
	
	$sql = "select * from ". $table_prefix ."runners where  find_in_set(6,cat) order by bibno";
	
	$stmt = $db->prepare($sql);
	$stmt->execute();	
	$runnerstemp = $stmt->fetchAll(PDO::FETCH_ASSOC);
	foreach ($runnerstemp as $temp)
	{
			$runner[$temp['bibno']] = $temp;
	}


}
//d($runner);
//exit();


//d($trackrecordarray);
/*-------------------------------------------------------------*/
/*-------------------------------------------------------------*/
/*-------------------------------------------------------------*/
/*-------------------------------------------------------------*/
$starttime = $current_course['startdatetime'];
//$starttime = "2017-01-20 08:30";


if ($field == "place_group")
{
$sql = "select * from ". $table_prefix ."trackrecord_summary su left join  ". $table_prefix . "runners  ru on su.bibno = ru.bibno where  
	find_in_set(6,cat) and su.place_group is not null and su.group = " . $select_group . " order by place_group  ";
}

if ($field == "place_gender")
{
$sql = "select * from ". $table_prefix ."trackrecord_summary su left join  ". $table_prefix . "runners  ru on su.bibno = ru.bibno where  
	find_in_set(6,cat) and  su.place_gender is not null and ru.gender = '" . $select_gender . "' order by place_gender  ";
}

if ($field == "place_course")
{
$sql = "select su.* from ". $table_prefix ."trackrecord_summary su left join  ". $table_prefix . "runners  ru on su.bibno = ru.bibno where  
	find_in_set(6,cat) and  su.place_course is not null order by place_course  ";
}


//d($sql);
$stmt = $db->prepare($sql);
$stmt->execute();	
$resulttemp = $stmt->fetchAll(PDO::FETCH_ASSOC);
//d($resulttemp);
foreach ($resulttemp as $r)
{
	$result[$r['bibno']] = $r;
	//$result[$r['bibno']]['result'][$r['cp_code']] = $r['']
	
	
	$runner[$r['bibno']][$r['cp_code']] = $r;

}
						
//d($runner);
/*-------------------------------------------------------------*/
/*-------------------------------------------------------------*/
/*-------------------------------------------------------------*/
/*-------------------------------------------------------------*/


//d($trackrecordsummary);



function cmp($a, $b)
{
global $field;





	if ( !$a['FINISH'][$field] && !$b['FINISH'][$field] && !$a['MIDPOINT'][$field] && !$b['MIDPOINT'][$field])
	{
		 return intcmp($a['bibno'], $b['bibno']);
	}
	

	if ($a['FINISH'][$field] && $b['FINISH'][$field])
		return intcmp($a['FINISH'][$field], $b['FINISH'][$field]);
		
	if ($a['FINISH'][$field] && !$b['FINISH'][$field])
		return -1;
		
	if (!$a['FINISH'][$field] && $b['FINISH'][$field])
		return 1;
	
	
	if (!$b['MIDPOINT'][$field]) return -1;
	if (!$a['MIDPOINT'][$field]) return 1;

	if ($a['MIDPOINT'][$field] || $b['MIDPOINT'][$field]) 
		return intcmp($a['MIDPOINT'][$field], $b['MIDPOINT'][$field]);

	/*
	
	if (!$b['CHECKIN'][$field]) return -1;
	if (!$a['CHECKIN'][$field]) return 1;
	
	if ($a['CHECKIN'][$field] || $b['CHECKIN'][$field]) 
		return strcmp($a['CHECKIN'][$field], $b['CHECKIN'][$field]);
		
	*/

	
	
	
    return intcmp($a['bibno'], $b['bibno']);
}


usort($runner, "cmp");

//array_orderby($runner, ['FINISH'][$field], SORT_NATURAL , SORT_STRING               );



?>
                <!-- Main content -->
				
				  <h3>
				    
					 
					 <?
					 
					 
						if ($_SESSION['lang'] == "zh-hant")
						{
						$title = "烈日落山賽 2017 - 扯旗山";
						} else {
						$title = "TRAILS OF FIRE – DOWNHILL CHALLENGE  -  VICTORIA PEAK";
						}
						
						echo $title;


?>
				  </h3>
				 
				 <a href="http://livetrack.sportsystem.hk/trails-of-fire-2017">總成績 Overall result </a> |
				  <a href="http://livetrack.sportsystem.hk/trails-of-fire-2017a">大帽山 TAI MO SHAN  </a> |
				  <a href="http://livetrack.sportsystem.hk/trails-of-fire-2017b">扯旗山 VICTORIA PEAK </a>
				
				
                <section class="content">
        
		
		
		
        			<div class="row">
						
						
							<?
							/*
							foreach ($courses  as $course)
							{
								echo '<a style="margin:10px;min-width:150px;" ';
								if ($course['code'] == $select_course ) 
								{
								echo 'class="btn-large btn btn-primary "';
								} else {
								echo 'class="btn-large btn btn-default"';
								}
								
								echo ' href="index.html?course=' . $course['code'] . '">';
								echo i18n_field( $course, "name");
								echo '</a>';
							}
							
						*/
						
						
						
							//echo '<a style="margin:5px;min-width:150px;" ';
							echo '<div class="col-6 col-md-3 ">  ';
							echo '<a style="margin:2px;" ';
								if (!$select_gender && !$select_group) 
								{
								echo 'class="btn btn-primary  btn-block" ';
								} else {
								echo 'class="btn btn-outline-primary  btn-block" ';
								}
								
								echo ' href="index.html">';
								echo i18n_text("Overall Rank");
							echo '</a>';
							echo '</div>';
						
							//echo '<a style="margin:5px;min-width:150px;" ';
							echo '<div class="col-6 col-md-3 ">  ';
							echo '<a style="margin:2px;" ';
						
								if ($select_gender == "M") 
								{
								echo 'class=" btn btn-primary  btn-block" ';
								} else {
								echo 'class=" btn btn-outline-primary  btn-block" ';
								}
								
								echo ' href="index.html?gender=1">';
								echo i18n_text("Male Group");
							echo '</a>';
							echo '</div>';							
							
							
							//echo '<a style="margin:5px;min-width:150px;" ';
							echo '<div class="col-6 col-md-3 ">  ';
							echo '<a style="margin:2px;" ';
						
								if ($select_gender == "F") 
								{
								echo 'class=" btn btn-primary  btn-block" ';
								} else {
								echo 'class=" btn btn-outline-primary  btn-block" ';
								}
								
								echo ' href="index.html?gender=2">';
								echo i18n_text("Female Group");
							echo '</a>';
							echo '</div>';						
						
						foreach ($runner_groups  as $group)
							{
							//echo '<a style="margin:5px;" ';
							echo '<div class="col-6 col-md-3 ">  ';
							echo '<a style="margin:2px"';
						
								if ($group['id'] == $select_group ) 
								{
								echo 'class=" btn btn-primary btn-block" ';
								} else {
								echo 'class=" btn btn-outline-primary btn-block " ';
								}
								
								echo ' href="index.html?group=' . $group['id'] . '">';
								echo i18n_field( $group, "name");
								echo '</a>';
							echo '</div>';								
							}
							?>
							
						</div>
					<div class="row" >
							<div class="p-3 col-lg-12 col-md-12 col-xs-12">
							<?
							//echo  i18n_text('Start Time') . ':';
							//echo $starttime;
							// echo " &nbsp&nbsp&nbsp&nbsp ";
							
							foreach ($overall as $ov)
							{
							// echo $ov['cp_code'] . ':' . $ov['c'];
							
							// echo " &nbsp&nbsp&nbsp&nbsp ";
							}
							
							
							?>
						</div>
					</div>
					  		  
				
				
				
				
				
				
				
				
				
				  <div class="row">
				  	<div class="col-lg-12 col-md-12 col-xs-12">
				  		<table class="table">
				  	
							<?
							
							//d($current_course);
							
							echo '<tr>';
								echo '<th>';
								echo i18n_text("Place");
								echo '</th>';
								echo '<th>';
								echo 'BIB';
								echo '</th>';
								echo '<th>';
								echo i18n_text("Name");
								echo '</th>';
								echo '<th>';
								echo i18n_text("Start Time");
								echo '</th>';
										
								echo '<th>';
								echo i18n_text("Finish");
								echo '</th>';																
							echo '</tr>';	
								
								
							
							foreach ($runner as $r)
							{
								
							echo '<tr>';
								echo '<td>';
								if (!$r['FINISH'][$field] && !$r['MIDPOINT'][$field] && !$r['START'][$field])
								 {
								 echo "DNS";
								 }
								
								if (!$r['FINISH'][$field] && ($r['MIDPOINT'][$field] || $r['START'][$field]))
								 {
								 //echo "DNF";
								 }
								
								
								echo $r['FINISH'][$field];
								
								
								echo '</td>';
								echo '<td>';
								echo $r['bibno'];
								echo '</td>';
								echo '<td >';
								
								echo displayFirstLastname($r['firstname'], $r['lastname']);
								if ($r['nameonbadge'])
								 echo ' (' . trim($r['nameonbadge']) . ')';
								
								
								
								//$cats = explode(",", $r['cat']);
								//if (!in_array(2,$cats))
								//echo 'xxxxxxxxxxx';
								
								
								echo '</td>';
								
								
								echo '<td>';
								
								
							
								
								//if($r['START']['duration'])
								//{
									//echo Duration($r['START']['duration'], false, true);
									//echo '<div style="font-size:9px">';
									echo $r['START']['recorddatetime'];
									echo '<br nowrap>';
									if ($r['START']['recorddatetime'] && !$r['FINISH']['duration'] )
									{
									$starttonow = MyDateDifference_sec($r['START']['recorddatetime'], date('Y-m-d H:i:s'));
									echo '<div style="font-size:9px">Started: ';
									echo Duration($starttonow, false, true);
									echo '</div>';
									}
									
								//}
								if ($r['START'][$field]) {
									echo ' (' . $r['START'][$field] . ')';
									//echo '</div>';
								}
								
								echo '</td>';
								
																					
															echo '<td nowrap>';
								
								
								
								if($r['FINISH']['duration'])
								{
									if ( $r['FINISH']['duration'] != 9999999)
									{
									echo Duration($r['FINISH']['duration'], false, true);
									}
									echo '<div style="font-size:9px">';
									echo $r['FINISH']['recorddatetime'];
									echo '</div>';
								}
								
								
								if ($r['FINISH'][$field]) {
									//echo ' (' . $r['FINISH'][$field] . ')';
									//echo '</div>';
								}
								echo '</td>';																
							echo '</tr>';								
							
							//d($r);
							}
							
							
							
							?>
						</table>	
				   </div>
				    </div>
	 
		
		
	
		
		
                </section>
		
					

<script>
var select_course;
var select_gender;
var select_group;
	  


$( document ).ready(function() {
	  

	  
});
			
			
			
			
			
			
</script>	


<?
require ("footer.php");


function intcmp($a,$b) {
    if((int)$a == (int)$b)return 0;
    if((int)$a  > (int)$b)return 1;
    if((int)$a  < (int)$b)return -1;
}



?>