<?
$extcss='';

require ("appheader.php");

$name_en = "FOUR TRAILS MINI 2017";
$name_zh_hant = "迷你四徑 2017";
$currentcat = array(10,14);
$cat_where = " and (FIND_IN_SET('11',cat) or  FIND_IN_SET('15',cat) )";
//$cat_where = "";


$intervalmin = 5;
$intervalsec = 60 * $intervalmin;
$durationhours = 8;	
	
if (getpostval("showall") == "false")
{
	$showall = 0;
} else {
	$showall = 1;
}


//$cat_where = "  ";


if ($_SESSION['lang'] == "zh-hant")
{
$headertitle = "Live Track system - " . $name_zh_hant;
} else {
$headertitle = "Live Track system - " . $name_en ;
}
$headerdescription = "";
$headerimg = "https://livetrack.sportsystem.hk/fourtrailsmini2017c/images/cover1280.png";


require ("header_inline.php");

 /*---------------*/
  
/*
  HONG KONG TRAIL
LANTAU TRAIL
WILSON TRAIL
MACLEHOSE TRAIL
港島徑
鳯凰徑
衛奕信徑
麥理浩徑
*/

$select_gender = "";
$select_group = "";

$select_course = "fourtrailsmini2017d";

//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_summary 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   age_group = " . $select_group  . $cat_where .  " order by bibno";

} else if ($field == "place_gender")
{
	$sql = "select * from ". $table_prefix ."runners where    gender = '" . $select_gender  . "'" . $cat_where .  " order by bibno";
} else {
	$field = "place_course";
	$sql = "select * from ". $table_prefix ."runners where active=1 " .  $cat_where ." order by bibno";
}
//d($sql);
$stmt = $db->prepare($sql);
$stmt->execute();	
$runnerstemp = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($runnerstemp as $temp)
{
		if ($showall)
		{
			$runner[$temp['bibno']] = $temp;
		} else if (array_intersect($currentcat, explode(',',$temp['cat']) ))
		{
			$runner[$temp['bibno']] = $temp;
		}
}


$sql = "SELECT   `bib`, max(`updatetime`) AS latestupdatetime , `response`
    FROM     " . $table_prefix . "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'];
		}
}


//d(sizeof($showresult));
/*-------------------------------------------------------------*/
/*-------------------------------------------------------------*/
/*-------------------------------------------------------------*/
/*-------------------------------------------------------------*/
$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  
	  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  
	su.place_gender is not null and ru.gender = '" . $select_gender . "' order by place_group  ";
}

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  
	 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)
{
	$bib = intval($r['bibno']);
	$result[$bib] = $r;
	//$result[$r['bibno']]['result'][$r['cp_code']] = $r['']
	if (!$runner[$bib])
	{
		//d($r['bibno']);
		$incorrectrunner[] = $bib;
	} else {
	
		$runner[$bib][$r['cp_code']] = $r;
	}
	
	
}

			
/*-------------------------------------------------------------*/
/*-------------------------------------------------------------*/


/*---------------------------------------
summary
----------------------*/

$totalrunner = sizeof($runner);
//SELECT count(*) FROM `fourtrailsmini2017a_runners` WHERE FIND_IN_SET('9',cat) or  FIND_IN_SET('13',cat)
//$totalrunner = 1060;

$totalcheckin = 0;
foreach ($runner as $r) {
	if ($r['CHECKIN'] || ($r['MIDPOINT']) || ($r['FINISH']) )
		$totalcheckin++;
}

$totalmidpoint = 0;
foreach ($runner as $r) {
	if ($r['MIDPOINT'])
		$totalmidpoint++;
}


$totalfinish = 0;
foreach ($runner as $r) {
	if ($r['FINISH'])
		$totalfinish++;
}


//d($totalrunner);
//d($totalcheckin);
//d($totalfinish);
//d($totalmidpoint);


$checkinprecent = floor(($totalcheckin/$totalrunner) * 100);
$midpointprecent = floor(($totalmidpoint/$totalcheckin) * 100);
$finishprecent = floor(($totalfinish/$totalcheckin) * 100);
/*
d($checkinprecent);
d($midpointprecent);
d($finishprecent);
*/
if ($midpointprecent > 100) $midpointprecent = 100;
if ($finishprecent > 100) $finishprecent = 100;
if ($checkinprecent > 100) $checkinprecent = 100;

/*-------------------------------------------------------------*/

if ($field == "place_group")
{
$arrivechartwhere = " and su.place_group is not null and su.group = " . $select_group  ;
}

if ($field == "place_gender")
{
$arrivechartwhere = " and su.place_gender is not null and ru.gender = '" . $select_gender  . "'" ;
}

if ($field == "place_course")
{
$arrivechartwhere = " and su.place_course is not null  ";
}


$sql = '
		SELECT  (FLOOR( duration/' . $intervalsec  . ' ) * ' . $intervalsec  . ') AS timerange, cp_code, point, course_code,  COUNT(*) as c FROM
				' . $table_prefix . 'trackrecord_summary  su left join  '. $table_prefix . 'runners  ru on su.bibno = ru.bibno
				
				where cp_code is not null ' . $arrivechartwhere . '
				
				GROUP BY timerange,point,course_code
		';

//d($sql);
$stmt = $db->prepare($sql);
$stmt->execute();	
$rs = $stmt->fetchAll(PDO::FETCH_ASSOC);

//d($rs);

foreach ($rs as $r)
{
	$arrivechart[$r['cp_code']][$r['timerange']]  = $r['c'];

}

//d($arrivechart);


for ($x=0; $x<=60*60*$durationhours; $x=$x+$intervalsec)
{
	$chartlabel[] = Duration($x, false, false);
	
	$chartdata['MIDPOINT'][$x] = $arrivechart['MIDPOINT'][$x];
	$chartdata['FINISH'][$x] = $arrivechart['FINISH'][$x];
	

}
//d($chartdata);


//d($trackrecordsummary);


function cmp($a, $b)
{
global $field;


	if ( !$a['FINISH'][$field] && !$b['FINISH'][$field] 
			&& !$a['MIDPOINT'][$field] && !$b['MIDPOINT'][$field]
			&& !$a['CHECKIN'][$field] && !$b['CHECKIN'][$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 ($a['MIDPOINT'][$field] && $b['MIDPOINT'][$field]) 
		return intcmp($a['MIDPOINT'][$field], $b['MIDPOINT'][$field]);
		
	
	if ($a['MIDPOINT'][$field] && !$b['MIDPOINT'][$field])
		return -1;
		
	if (!$a['MIDPOINT'][$field] && $b['MIDPOINT'][$field])
		return 1;
	
		
	if (!$b['CHECKIN'][$field]) return -1;
	if (!$a['CHECKIN'][$field]) return 1;

	if ($a['CHECKIN'][$field] || $b['CHECKIN'][$field]) 
		return intcmp($a['CHECKIN'][$field], $b['CHECKIN'][$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']);
}
//d($runner);

uasort($runner, "cmp");

//array_orderby($runner, ['FINISH'][$field], SORT_NATURAL , SORT_STRING               );

//d($runner);

/*-------------------------------------------------------------
 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'] = '***';
		
		}
	}
/*-------------------------------------------------------------*/						
	

?>
                <!-- 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>
				 
				
                <section class="content">
        
			
					<div class="row">
						<div class="col-6 col-md-3">
							<a href="/fourtrailsmini2017/" style="margin:2px;" class="btn btn-outline-success btn-block">
								系列總排名<br>Series overall
							</a>
						</div>
						<div class="col-6 col-md-3">
							<a href="/fourtrailsmini2017b/" style="margin:2px;" class="btn btn-outline-success btn-block">
								鳯凰徑<br>LANTAU TRAIL
							</a>
						</div>
						<div class="col-6 col-md-3">
							<a href="/fourtrailsmini2017c/" style="margin:2px;" class="btn btn-outline-success btn-block">
								衛奕信徑<br>WILSON TRAIL
							</a>
						</div>
						<div class="col-6 col-md-3">
							<a href="/fourtrailsmini2017d/" style="margin:2px;" class="btn btn-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-block" ';
								$currentlistingtitle = i18n_text("Overall Ranking");
								} else {
								echo 'class="btn btn-outline-primary  btn-block" ';
								
								}
								
								echo ' href="index.html">';
								echo i18n_text("Overall Ranking");
								
							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" ';
								$currentlistingtitle = i18n_text("Male Group");
								} 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" ';
								$currentlistingtitle = i18n_text("Female Group");
								} 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" ';
								$currentlistingtitle = i18n_field( $group, "name");
								} 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 pt-5    ">
						<div class=" p-3 col-lg-4 col-md-4 col-xs-12 ">
							
							<img src="set-timer-button.png" style="max-height:60px;float: left;">
							<?
							
							echo  i18n_text('Start') . ': ';
							?>
							<div class="text-primary"  style="font-size:1.5em; font-weight:bold"><?echo $starttime;?></div>
							
						</div>
						

						<div class=" p-3 col-lg-4 col-md-4 col-xs-12 " >
							
							<img src="temperature_icon.png" style="max-height:60px;float: left;">
							<?echo i18n_text('Temperature')?>
							<div class="text-primary"  style="font-size:1.5em; font-weight:bold">21.1 - 23.5 °C</div>
							
						</div>
						
						<div class=" p-3 col-lg-4 col-md-4 col-xs-12">
							<img src="relative_humidity_icon.png" style="max-height:60px;float: left;">
							<?echo i18n_text('Relative Humidity')?>
						
							<div class="text-primary" style="font-size:1.5em; font-weight:bold">76 - 96 %</div>
						
						</div>
						

					</div>
					  		  
			
				<?
				if ($incorrectrunner) {
				?>
				<!--
				<div> Alert: 
						<?
						foreach ($incorrectrunner as $r)
						{
							echo $r;
							echo ' ';
						}
						?>
					</div> 
				-->
				<?
				}
				//d($runner);
				?>	
				
				<div class="row  mt-5 mb-5 ml-1 mr-1">
				  	<div class="col-lg-12 col-md-12 col-xs-12">
						<h1 class=" text-center h2"><?echo i18n_text('Result Listing');?> <strong><?echo  $currentlistingtitle;?></strong></h1>
					</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 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");
								//echo '</th>';
								//echo '<th>';
								//echo i18n_text("Check Point") . " 1";
								//echo '</th>';								
								echo '<th>';
								echo i18n_text("Finish");
								echo '</th>';
								echo '<th>';
								
								echo '</th>';								
							echo '</tr>';	
								
								
							foreach ($runner as $r)
							{
									//d($r);


								if (array_intersect($currentcat, explode(',',$r['cat']) ))
								{
									$warning  = true;
								} else {
									$warning  = false;
								}

								if ($warning)
								{
									echo '<tr class="ResultTableRow">';
								} else {
									//echo '<tr class="ResultTableRow" style="color:#999999;background:#ffffc2;">';
									echo '<tr class="ResultTableRow">';
								}
								
								
									echo '<td>';
									if (!$r['FINISH'][$field] && !$r['MIDPOINT'][$field] && !$r['CHECKIN'][$field])
									 {
									 echo "DNS";
									 }
									
									if (!$r['FINISH'][$field] && ($r['MIDPOINT'][$field] || $r['CHECKIN'][$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']) . ')';
									 /*
									 if ( $r['CHECKIN']['recorddatetime'])
									 {
									 echo '<div style="font-size:0.6em;">';
									 echo i18n_text("Check In") . ":" ;
									 echo $r['CHECKIN']['recorddatetime'];
									 echo '</div>';
									 }
									 */
									
									//$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'];
									}
									if ($r['START'][$field]) {
										echo ' (' . $r['START'][$field] . ')';
										echo '</div>';
									}
									
									echo '</td>';
									
									*/
									
									/*
									echo '<td nowrap>';
									
									
									if($r['MIDPOINT']['duration'])
									{
										echo Duration($r['MIDPOINT']['duration'], false, true);
										 echo '<div style="font-size:0.6em;">';
										echo $r['MIDPOINT']['recorddatetime'];
										echo '</div>';
									}
									if ($r['MIDPOINT'][$field]) {
										//echo '(' . $r['MIDPOINT'][$field] . ')';
										
									}
									
									echo '</td>';								
									*/
									echo '<td nowrap>';
									
									
									if($r['FINISH']['duration'])
									{
										echo Duration($r['FINISH']['duration'], false, true);
										 echo '<div style="font-size:0.6em;">';
										echo $r['FINISH']['recorddatetime'];
										echo '</div>';
									}
									
									
									if ($r['FINISH'][$field]) {
										//echo ' (' . $r['FINISH'][$field] . ')';
										//echo '</div>';
									}
									echo '</td>';	
									echo '<td nowrap>';								
									if ($r['FINISH']['place_course'])
									{
										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 Ranking") . ":";
										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['age_group']],'name');
										echo ' ';
										echo i18n_text("Ranking") . ":";
										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("Ranking") . ":";
										echo '</td>';
										echo '<td class="text-center">';
										echo $r['FINISH']['place_gender'];
										echo '</td>';
										echo '</tr>';
									
										
										echo '</table>';
									}
									
									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;
}


?>