<?
$extcss='';

require ("appheader.php");
$name_en = "FOUR TRAILS MINI 2024";
$name_zh_hant = "迷你四徑 2024";

if ($_SESSION['lang'] == "zh-hant")
{ 
$headertitle = "Live Track system - 迷你四徑 2024 ";
} else {
$headertitle = "Live Track system - FOUR TRAILS MINI 2024";
}
$headerdescription = "";
$headerimg = "https://web.sportsystem.io/fourtrailsmini2020/gallerya/images/4TrailsMiniLogo-tran-800.png";


require ("header_inline.php");

 /*---------------*/
  

$cat_where = " and FIND_IN_SET('353',cat) and FIND_IN_SET('354',cat) and FIND_IN_SET('355',cat) and FIND_IN_SET('356',cat)";

$select_gender = "";
$select_group = "";

$select_course = "fourtrailsmini2024all";


//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 ."membergroups";
$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 ."result_public 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   1=1 ". $cat_where . " and  group_id = " . $select_group  . " order by bibno";
	$stmt = $db->prepare($sql);
	$stmt->execute();	
	$runnerstemp = $stmt->fetchAll(PDO::FETCH_ASSOC);
	foreach ($runnerstemp as $temp)
	{
			//$bibno = str_pad($temp['bibno'] ,3,"0",STR_PAD_LEFT);  
			$bibno = intval($temp['bibno']);
			$runner[$bibno] = $temp;
	}
} else if ($field == "place_gender")
{
	$sql = "select * from ". $table_prefix ."runners where  1=1 ". $cat_where . " and gender = '" . $select_gender  . "' order by bibno";
	
	$stmt = $db->prepare($sql);
	$stmt->execute();	
	$runnerstemp = $stmt->fetchAll(PDO::FETCH_ASSOC);
	foreach ($runnerstemp as $temp)
	{
			//$bibno = str_pad($temp['bibno'] ,3,"0",STR_PAD_LEFT);  
			$bibno = intval($temp['bibno']);
			$runner[$bibno] = $temp;
	}
} else {

	$field = "place_course";
	
	$sql = "select * from ". $table_prefix ."runners where 1=1 ". $cat_where . "  order by bibno";
	
	$stmt = $db->prepare($sql);
	$stmt->execute();	
	$runnerstemp = $stmt->fetchAll(PDO::FETCH_ASSOC);
	foreach ($runnerstemp as $temp)
	{
			//$bibno = str_pad($temp['bibno'] ,3,"0",STR_PAD_LEFT);  
			$bibno = intval($temp['bibno']);
			$runner[$bibno] = $temp;
	}


}

//d($runner);
//exit();


//d($trackrecordarray);
/*-------------------------------------------------------------*/
/*-------------------------------------------------------------*/
/*-------------------------------------------------------------*/
/*-------------------------------------------------------------*/
///$starttime = $current_course['startdatetime'];
//$starttime = "2017-01-20 08:30";


if ($field == "place_group")
{
$sql = "select su.* from ". $table_prefix ."result_public su left join  ". $table_prefix . "runners  ru on convert(su.bibno,unsigned)  = convert(ru.bibno,unsigned)  where  
	 su.place_group is not null and su.group = " . $select_group . " order by place_group  ";
}

if ($field == "place_gender")
{
$sql = "select su.* from ". $table_prefix ."result_public su left join  ". $table_prefix . "runners  ru on  convert(su.bibno,unsigned)  = convert(ru.bibno,unsigned) where  
	  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 ."result_public su left join  ". $table_prefix . "runners  ru on  convert(su.bibno,unsigned)  = convert(ru.bibno,unsigned) where  
	  su.place_course is not null order by place_course  ";
}

//d('xxx');
//d($sql);
$stmt = $db->prepare($sql);
$stmt->execute();	
$resulttemp = $stmt->fetchAll(PDO::FETCH_ASSOC);
//d($resulttemp);
foreach ($resulttemp as $r)
{

	//d($r);
	
	//$bibno = str_pad($r['bibno'] ,3,"0",STR_PAD_LEFT);  
	$bibno = intval($r['bibno']);
	if ($runner[$bibno])
	{
		//if (!$r['duration'] || $r['duration'] == 9999999)
		//{
			
			$runner[$bibno][$r['cp_code']]['dur_a'] = $r['dur_a'];
			$runner[$bibno][$r['cp_code']]['dur_b'] = $r['dur_b'];
			$runner[$bibno][$r['cp_code']]['dur_c'] = $r['dur_c'];
			$runner[$bibno][$r['cp_code']]['dur_d'] = $r['dur_d'];
			
			$runner[$bibno]['uptodatedur'] = $r['uptodatedur'];
			$runner[$bibno]['racecount'] = $r['racecount'];
			$runner[$bibno]['duration'] = $r['duration'];
			
			$runner[$bibno][$r['cp_code']] = $r;
			
			//unset($runner[$bibno]);
		//} else {
		
		//	$result[$bibno] = $r;
			//$result[$r['bibno']]['result'][$r['cp_code']] = $r['']
		//	$runner[$bibno][$r['cp_code']] = $r;
		
		//}
	}

		
}
						
//d($runner);
/*-------------------------------------------------------------*/
/*-------------------------------------------------------------*/
/*-------------------------------------------------------------*/
/*-------------------------------------------------------------*/


//d($trackrecordsummary);


//d($runner);
$runner = array_orderby($runner, 'racecount', SORT_DESC, 'duration', SORT_ASC, 'uptodatedur', SORT_ASC, 'bibno', SORT_ASC);
//usort($runner, "cmp");

//array_orderby($runner, ['FINISH'][$field], SORT_NATURAL , SORT_STRING               );
/*
$sql = "SELECT   `bib`, max(`updatetime`) AS latestupdatetime , `response`
    FROM     fourtrailsmini2017d_resultpublic
    GROUP BY bib";
$stmt = $db->prepare($sql);
$stmt->execute();	
$responsetemp = $stmt->fetchAll(PDO::FETCH_ASSOC);	
//d(sizeof($responsetemp))	;
foreach ($responsetemp as $temp)
{
		if ($temp['response'] == "yes")
		{
			$showresult[]  = $temp['bib'];
		}
}
*/


/*-------------------------------------------------------------
 Mask the reult no show
 ----------------------------------------------------------
foreach ($runner as $r)
	{
		$bib = $r['bibno'];
		
		if ( !in_array($bib, $showresult) )
		{
			$runner[$bib]['nameonbadge'] = '';
			$runner[$bib]['firstname'] = '***';
			$runner[$bib]['lastname'] = '***';
			$runner[$bib]['bibno'] = '***';
		
		}
	}
-----------------------------------------------------------*/		


?>

				  <div class="text-center">
				 <img src="<?echo $headerimg;?>" style="max-height:150px;" >
				 </div>
				
                <!-- Main content -->
				 <h1 class=" text-center h2 pb-4">
				    
					 
					 <?
					 
					 
						if ($_SESSION['lang'] == "zh_hant")
						{
						$title = $name_zh_hant ;
						} else {
						$title = $name_en ;
						}
						
						echo $title;

/*
 <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>
				
				
				*/
?>
				  </h1>
				  <?/*
				  <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">
						<div class="col-6 col-md-3">
							<a href="/fourtrailsmini2024/" style="margin:2px;" class="btn btn-sm btn-success btn-block">
								系列總排名<br>Series overall
							</a>
						</div>
					</div>	
					<div class="row">
					
						<div class="col-6 col-md-3">
							<a href="/fourtrailsmini2024a/" style="margin:2px;" class="btn  btn-sm  btn-outline-success btn-block">
								鳯凰徑<br>LANTAU TRAIL
							</a>
						</div>
						<div class="col-6 col-md-3">
							<a href="/fourtrailsmini2024b/" style="margin:2px;" class="btn  btn-sm  btn-outline-success btn-block">
								港島徑<br>HONG KONG TRAIL
							</a>
						</div>
						
							<div class="col-6 col-md-3">
							<a href="/fourtrailsmini2024c/" style="margin:2px;" class="btn btn-sm  btn-outline-success btn-block">
								衛奕信徑<br>WILSON TRAIL
							</a>
						</div>
						
						
						<div class="col-6 col-md-3">
							<a href="/fourtrailsmini2024d/" style="margin:2px;" class="btn btn-sm  btn-outline-success btn-block">
								麥理浩徑<br>MACLEHOSE TRAIL
							</a>
						</div>
						
					
					</div>
					
					
        			<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-sm   btn-block" ';
								} else {
								echo 'class="btn btn-outline-primary  btn-sm  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-sm  btn-block" ';
								} else {
								echo 'class=" btn btn-outline-primary  btn-sm  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-sm  btn-block" ';
								} else {
								echo 'class=" btn btn-outline-primary btn-sm  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-sm   btn-block" ';
								} else {
								echo 'class=" btn btn-outline-primary btn-sm  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 bg-faded mt-5 mb-5 ml-1 mr-1">
				  	<div class="col-lg-12 col-md-12 col-xs-12">
						<div class="form-group">
						  <label for="usr" class="text-primary"><strong><?echo i18n_text("Search");?>:</strong></label>
						  <input  class="form-control" type="text" id="SearchInput" placeholder="<?echo i18n_text("BIB No./Name");?>">
						</div>
					</div>
				  </div>
				
				
				  <div class="row">
				  	<div class="col-lg-12 col-md-12 col-xs-12">
				  		<table class="table table-striped ResultTable" id="">
				  	
							<?
							
							//d($current_course);
							
							echo '<tr>';
							
								echo '<th>';
								echo '#';
								echo '</th>';
							
								echo '<th>';
								echo i18n_text("Place");
								echo '</th>';
								echo '<th>';
								echo 'BIB';
								echo '</th>';
								//echo '<th>';
								//echo 'Four';
								//echo '</th>';
								echo '<th>';
								echo i18n_text("Name");
								echo '</th>';
							
					
								echo '<th>';
								echo "鳯凰徑 LANTAU TRAIL";
								echo '</th>';
			echo '<th>';
								echo "港島徑 HONG KONG TRAIL";
								echo '</th>';																
								echo '<th>';
								echo "衛奕信徑 WILSON TRAIL";
								echo '</th>';
							
							
								echo '<th>';
								echo "麥理浩徑 MACLEHOSE TRAIL";
								echo '</th>';
								
								
								echo '<th>';
								echo i18n_text("Total");
								echo '</th>';	
								echo '<th>';
								
								echo '</th>';	
								echo '<th>';
								
								echo '</th>';	
								
							echo '</tr>';	
								
								
								$rowcount = 0;
							foreach ($runner as $r)
							{
							
								//d($r);
								$rowcount++;
								
								if (  sizeof(explode(",",$r['cat'])) == 4)
								{
								echo '<tr class="ResultTableRow">';
								
								
								echo '<td>';
								echo $rowcount;
								echo '</td>';
								
								echo '<td>';
								
								
								if (!$r['racecount'] || $r['racecount'] != 4 )
								 {
								 echo "DNF Series";
								 } else {
								
						
								echo $r['FINISH'][$field];
								}
								
								echo '</td>';
								
								echo '<td>';
								echo $r['bibno'];
								echo '</td>';
								
								/*echo '<td>';
								if ($r['cat']=="8,9,10,11" or $r['cat']=="12,13,14,15")
								{
									echo "***";
								}
								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 nowrap>';
								if ( $r['FINISH']['dur_a'] != 9999999 &&  $r['FINISH']['dur_a'] > 0)
								echo Duration($r['FINISH']['dur_a'], false, true);
								echo '</td>';
								
								echo '<td nowrap>';
								
								
								//echo $r['FINISH']['dur_b'];
								if ( $r['FINISH']['dur_b'] != 9999999 &&  $r['FINISH']['dur_b'] > 0)
								echo Duration($r['FINISH']['dur_b'], false, true);
								
								echo '</td>';	

								echo '<td nowrap>';
								
								
								//echo $r['FINISH']['dur_b'];
								$dnftime =  6*60*60 + 35*60 ;//"00:06:35";
								if  ($r['FINISH']['dur_c'] < $dnftime)
								{ 

								
								if ( $r['FINISH']['dur_c'] != 9999999 &&  $r['FINISH']['dur_c'] > 0)
								echo Duration($r['FINISH']['dur_c'], false, true);
								}
								echo '</td>';									
												
								echo '<td nowrap>';
								
								
								//echo $r['FINISH']['dur_b'];
								
								
								    if ( $r['FINISH']['dur_d'] != 9999999 &&  $r['FINISH']['dur_d'] > 0)
								    echo Duration($r['FINISH']['dur_d'], false, true);
								
								
								echo '</td>';									
																							

								echo '<td nowrap>';
								
								//echo $r['FINISH']['duration'];
								//if ( $r['FINISH']['duration'] != 9999999 &&  $r['FINISH']['duration'] > 0)
								//echo Duration($r['FINISH']['duration'], false, true);
								
								
								if ( $r['uptodatedur'] != 9999999 &&  $r['uptodatedur'] > 0)
								echo Duration($r['uptodatedur'], false, true);
								
								/*
								
								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 '<td nowrap>';
								if ( $r['FINISH']['duration'] != 9999999 &&  $r['FINISH']['duration'] > 0)
									{
										echo '<table class="table table-sm table-border " style="background-color:transparent; font-size:12px;">';
										echo '<tr style="background-color:transparent;">';
										echo '<td>';
										echo i18n_text("Overall Rank") . ":";
										echo '</td>';
										echo '<td class="text-center">';
										echo $r['FINISH']['place_course'];
										echo '</td>';
										echo '</tr>';
										echo '<tr style="background-color:transparent;">';
										echo '<td>';
										//echo i18n_text("Cat. Ranking") . ":";
										
										echo i18n_field($runner_groups[$r['group_id']],'name');
										echo ' ';
										echo i18n_text("Rank") . ":";
										echo '</td>';
										echo '<td class="text-center">';
										
										echo $r['FINISH']['place_group'];
										echo '</td>';
										echo '</tr>';
										
										
										echo '<tr style="background-color:transparent;">';
										echo '<td>';
										//d($r);
										if ($r['gender'] == "M")
										{
											echo i18n_text("Male Group");
										} else {
											echo i18n_text("Female Group");
										}
										echo ' ';
										echo i18n_text("Rank") . ":";
										echo '</td>';
										echo '<td class="text-center">';
										echo $r['FINISH']['place_gender'];
										echo '</td>';
										echo '</tr>';
									
										
										echo '</table>';
									}
									echo '</td>';	
									echo '<td>';	
									if ( $r['FINISH']['duration'] != 9999999 &&  $r['FINISH']['duration'] > 0)
									{
										echo '<a target="_blank"  href="cert/' . $r['bibno'] . '">';
										echo '<img src="images/cert.png" style="max-height:50px">';
										echo "<div style='color:#000000;font-size:10px'>" . i18n_text("Download certificate") . "</div>";
										echo '</a>';
									}
									echo '</td>';	
								
								echo '</tr>';								
								}
							//d($r);
							}
							
							
							?>
						</table>	
				   </div>
				    </div>
	 
		
                </section>
		
<script>
var select_course;
var select_gender;
var select_group;
	  

$( document ).ready(function() {

	var $rows = $('.ResultTable .ResultTableRow');
	$('#SearchInput').keyup(function() {
		var val = $.trim($(this).val()).replace(/ +/g, ' ').toLowerCase();
		
		$rows.show().filter(function() {
			var text = $(this).text().replace(/\s+/g, ' ').toLowerCase();
			return !~text.indexOf(val);
		}).hide();
	});
			

});
			
			
</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;
}

function array_orderby()
{
    $args = func_get_args();
    $data = array_shift($args);
    foreach ($args as $n => $field) {
        if (is_string($field)) {
            $tmp = array();
            foreach ($data as $key => $row)
                $tmp[$key] = $row[$field];
            $args[$n] = $tmp;
            }
    }
    $args[] = &$data;
    call_user_func_array('array_multisort', $args);
    return array_pop($args);
}


?>