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 1=1 ". $cat_where . " and age_group = " . $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(sizeof($runner)); //exit(); //d($trackrecordarray); /*-------------------------------------------------------------*/ /*-------------------------------------------------------------*/ /*-------------------------------------------------------------*/ /*-------------------------------------------------------------*/ ///$starttime = $current_course['startdatetime']; //$starttime = "2017-01-20 08:30"; if ($field == "place_group") { $sql = "select su.* from ". $table_prefix ."trackrecord_summary 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 ."trackrecord_summary 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 ."trackrecord_summary 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']; //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); 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 ); $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'] = '***'; } } /*-------------------------------------------------------------*/ ?>

總成績 Overall result | 大帽山 TAI MO SHAN | 扯旗山 VICTORIA PEAK */ ?>

總成績 Overall result | 大帽山 TAI MO SHAN | 扯旗山 VICTORIA PEAK */ ?>
系列總排名
Series overall
鳯凰徑
LANTAU TRAIL
衛奕信徑
WILSON TRAIL
麥理浩徑
MACLEHOSE TRAIL
'; echo i18n_field( $course, "name"); echo ''; } */ //echo ' '; echo ''; echo i18n_text("Overall Rank"); echo ''; echo '
'; //echo ' '; echo ''; echo i18n_text("Male Group"); echo ''; echo ''; //echo ' '; echo ''; echo i18n_text("Female Group"); echo ''; echo ''; foreach ($runner_groups as $group) { //echo ' '; echo ''; echo i18n_field( $group, "name"); echo ''; echo ''; } ?>
">
'; echo ''; echo ''; //echo ''; echo ''; //echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; foreach ($runner as $r) { //d($r); if ($r['cat']=="8,9,10,11" or $r['cat']=="12,13,14,15") { echo ''; echo ''; echo ''; /*echo ''; */ echo ''; //echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } //d($r); } ?>
'; echo i18n_text("Place"); echo ''; echo 'BIB'; echo ''; //echo 'Four'; //echo ''; echo i18n_text("Name"); echo ''; //echo "港島徑 HONG KONG TRAIL"; //echo ''; echo "鳯凰徑 LANTAU TRAIL"; echo ''; echo "衛奕信徑 WILSON TRAIL"; echo ''; echo "麥理浩徑 MACLEHOSE TRAIL"; echo ''; echo i18n_text("Total"); echo ''; echo '
'; if (!$r['FINISH']['duration']) { echo "DNF Series"; } if (!$r['FINISH'][$field] && ($r['MIDPOINT'][$field] || $r['START'][$field])) { //echo "DNF"; } echo $r['FINISH'][$field]; echo ''; echo $r['bibno']; echo ''; if ($r['cat']=="8,9,10,11" or $r['cat']=="12,13,14,15") { echo "***"; } echo ''; 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 ''; //if ( $r['FINISH']['dur_a'] != 9999999 && $r['FINISH']['dur_a'] > 0) //echo Duration($r['FINISH']['dur_a'], false, true); //echo ''; //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 ''; //echo $r['FINISH']['dur_b']; if ( $r['FINISH']['dur_c'] != 9999999 && $r['FINISH']['dur_c'] > 0) echo Duration($r['FINISH']['dur_c'], false, true); echo ''; //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 ''; //echo $r['FINISH']['duration']; if ( $r['FINISH']['duration'] != 9999999 && $r['FINISH']['duration'] > 0) echo Duration($r['FINISH']['duration'], false, true); /* if($r['FINISH']['duration']) { if ( $r['FINISH']['duration'] != 9999999) { echo Duration($r['FINISH']['duration'], false, true); } echo '
'; echo $r['FINISH']['recorddatetime']; echo '
'; } if ($r['FINISH'][$field]) { //echo ' (' . $r['FINISH'][$field] . ')'; //echo ''; } */ echo '		'; if ( $r['FINISH']['duration'] != 9999999 && $r['FINISH']['duration'] > 0) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '
'; echo i18n_text("Overall Ranking") . ":"; echo ''; echo $r['FINISH']['place_course']; echo '
'; //echo i18n_text("Cat. Ranking") . ":"; echo i18n_field($runner_groups[$r['age_group']],'name'); echo ' '; echo i18n_text("Ranking") . ":"; echo ''; echo $r['FINISH']['place_group']; echo '
'; //d($r); if ($r['gender'] == "M") { echo i18n_text("Male Group"); } else { echo i18n_text("Female Group"); } echo ' '; echo i18n_text("Ranking") . ":"; echo ''; echo $r['FINISH']['place_gender']; echo '
'; } echo '
(int)$b)return 1; if((int)$a < (int)$b)return -1; } ?>