<?php
 if(basename(__FILE__) == basename($_SERVER['PHP_SELF'])){exit();}
 global $config;
 require_once 'config/class/class.database.php';
 $db = new database();

 require_once 'config/class/class.memberspace.php';
 $member = new member_space();

 if(!empty($_GET['p']) && filter_var($_GET['p'], FILTER_VALIDATE_INT)!==false) $page = $_GET['p']; else $page = 1;
 $maxshow = 50;
 $years = array(2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2021);
 $sexes = array('hommes', 'femmes');
 $courses = array('21km', '7km');
 $cats = array(
 2007 => array('hommes'=>array(),'femmes'=>array()), 
 2008 => array('hommes'=>array(1,2,3,4),'femmes'=>array(1,2,3)), 
 2009 => array('hommes'=>array(1,2,3,4,5),'femmes'=>array(1,2,3)), 
 2010 => array('hommes'=>array(1,2,3,4,5),'femmes'=>array(1,2,3)), 
 2011 => array('hommes'=>array(1,2,3,4,5),'femmes'=>array(1,2,3)), 
 2012 => array('hommes'=>array(1,2,3,4,5,6,7),'femmes'=>array(1,2,3)), 
 2013 => array('hommes'=>array(1,2,3,4,5,6,7),'femmes'=>array(1,2,3)), 
 2014 => array('hommes'=>array(1,2,3,4,5,6,7),'femmes'=>array(1,2,3)), 
 2015 => array('hommes'=>array(1,2,3,4,5,6,7),'femmes'=>array(1,2,3)), 
 2016 => array('hommes'=>array(1,2,3,4,5,6),'femmes'=>array(1,2,3)), 
 2017 => array('hommes'=>array(1,2,3,4,5,6),'femmes'=>array(1,2,3)), 
 2018 => array('hommes'=>array(1,2,3,4,5,6),'femmes'=>array(1,2,3)), 
 2019 => array('hommes'=>array(1,2,3,4,5,6),'femmes'=>array(1,2,3)), 
 2019 => array('hommes'=>array(1,2,3,4,5,6),'femmes'=>array(1,2,3))
 );
 if (!empty($_GET['y']) && in_array($_GET['y'], $years)) $__y=$_GET['y']; else $__y=$config['smib_annee_encours']-1;
 if (!empty($_GET['s']) && in_array($_GET['s'], $sexes)) $__s=$_GET['s']; else $__s='hommes';
 if (!empty($_GET['k']) && in_array($_GET['k'], $courses)) $__k=$_GET['k']; else $__k='21km';
 if ($__k=='7km' && !in_array($__y, array(2013, 2014, 2015, 2016, 2017, 2019,2021))) $__k='21km';
 if (!empty($_GET['c']) && in_array($_GET['c'], $cats[$__y][$__s])) $__c=$_GET['c']; else $__c=0;
?>


<?php $_shouldextend[1]=1; ?>


<?php $this->startSection('wisra_basic_content'); ?>
 @parentXYZABC

 
<div class="body-content js-body-content blue-body">
 <main id="main">
 <div class="standings-background-hero">
 <picture class="standings-background-hero__pattern left js-lazy-picture loaded">
 <img src="<?php echo $config['app_url'] ?>sources/image/basic/stripes-left.png" data-image-src="<?php echo $config['app_url'] ?>sources/image/basic/stripes-left.png" alt="Standings Background Pattern">
 </picture>
 <picture class="standings-background-hero__pattern right js-lazy-picture loaded">
 <img src="<?php echo $config['app_url'] ?>sources/image/basic/stripes-right.png" data-image-src="<?php echo $config['app_url'] ?>sources/image/basic/stripes-right.png" alt="Standings Background Pattern">
 </picture>
 </div>
 <div class="u-main-gradient">
 <div class="wrapper">
 <div class="col-12">
 <section class="standings">
 <div class="standings__header">
 <div class="standings-header">
 <h1> Résultats </h1>
<?php if ($config['smib_resulta_provz']==1 && $__y==$config['smib_annee_encours']) { ?>
 <span class="provisultats">RESULTATS PROVISOIRES</span>
<?php } ?>
 </div>
 </div>

 <div class="standings__content js-standings-content">
 <section class="standings-league js-standings-pane">

 <div class="standings-league__header standings-pane-header">
 <div class="standings-pane-header__spacer">
<?php if ($__y>2018) { ?>
 <form method="post">
 <input class="user-form__input" id="searchbydossard" name="searchbydossard" type="text" placeholder="Recherche de dossard" value="<?php echo !empty($_POST['searchbydossard'])?$_POST['searchbydossard']:''?>">
 </form>
<?php } ?>
 </div>
 <div class="standings-pane-header__info">
 <img src="<?php echo $config['app_url'] ?>sources/image/basic/semi-marathon-bejaia-footer.png" alt="<?php echo $config['app_name'] ?> logo" class="standings-pane-header__competition-logo">
 </div>
 <span class="standings-pane-header__name visually-hidden"></span>
 <div class="standings-pane-header__time-info">
 <div class="standings-pane-header__last-updated"> 
 <?php echo ($__c==0) ? 'Pas de catégorie' : 'Catégorie '.$__c ; ?> : <?php echo ucfirst($__s); ?> 
 </div>
 <div class="standings-pane-header__season-info-container">
 <span class="standings-pane-header__season-info js-season-info"> Année <?php echo $__y; ?> </span>
 <span class="standings-pane-header__match-week-info js-match-week-info"> Course <?php echo $__k; ?> </span>
 </div>
 </div>
 </div>

 <table class="standings-league__table standings-table">
 <thead class="standings-table__head">
 <tr>
<?php 
 $headras=array(
 'HA' => array(
 array('Classement', 'N° Dossard', 'Nom & Prénom', 'Année de Naissance', 'Ville', 'Temps'), array('Cls', 'N°', 'Nom', 'Année', 'Ville', 'Temps')), 
 'HB' => array(
 array('Classement', 'N° Dossard', 'Nom & Prénom', 'Année de Naissance', 'Sexe', 'Catégorie', 'Ville', 'Temps'), 
 array('Cls', 'N°', 'Nom', 'Année', 'Sexe', 'Ctg', 'Ville', 'Temps')), 
 'HC' => array(
 array('Classement', 'N° Dossard', 'Pays', 'Ville', 'Nom & Prénom', 'Date de Naissance', 'Sexe', 'Catégorie', 'Temps'), 
 array('Cls', 'N°', 'Pays', 'Ville', 'Nom', 'Naiss', 'Sexe', 'Ctg', 'Temps')), 
 'HD' => array(
 array('Classement', 'N° Dossard', '', 'Pays', 'Ville', 'Nom & Prénom', 'Date de Naissance', 'Sexe', 'Catégorie', 'Temps'), 
 array('Cls', 'N°', '', 'Pays', 'Ville', 'Nom', 'Naiss', 'Sexe', 'Ctg', 'Temps'))
 );
 $affecta=array(2007=>'HA', 2008=>'HB', 2009=>'HB', 2010=>'HB', 2011=>'HB', 2012=>'HB', 2013=>'HB', 2014=>'HB', 2015=>'HB', 2016=>'HC', 2017=>'HC', 2018=>'HB', 2019=>'HB');
 $tablaxa = ($__y>2018) ? $headras['HD'] : $headras[$affecta[$__y]] ;
 foreach ($tablaxa[0] as $x => $value) {
 echo '
 <th class="table-head" scope="col">
 <span class="table-head__heading">'.$value.'</span>
 <span class="table-head__heading--short">'.$tablaxa[1][$x].'</span>
 </th>
 ';
 }

?>
 <th class="standings-table__gap-filler"></th>
 </tr>
 </thead>
 <tbody class="standings-table__body">
<?php
 $pages_nbr = 1;
 $biginselect = ($page-1) * $maxshow;
 $cls = $biginselect;
 $annee = $__y;
 $course = ($__k=='21km') ? 1 : 2 ;
 $sexxxx = ($__s=='hommes') ? 1 : 0 ;
 $catego = $__c;

 function sectotime($sec) {
 $timo='';
 $hr=floor($sec/3600);
 if ($hr>0) $timo.=$hr.':';
 $sec=$sec-$hr*3600;
 $mn=floor($sec/60);
 if ($mn>0) $timo.=(($mn<9)?'0':'').$mn.':'; else $timo.='00:';
 $sec=$sec-$mn*60;
 if ($sec>0) $timo.=(($sec<9)?'0':'').$sec; else $timo.='00';
 return $timo;
 }

 if ($__y>2018) {

 if(!empty($_POST['searchbydossard']) && filter_var($_POST['searchbydossard'], FILTER_VALIDATE_INT)!==false) $search = $_POST['searchbydossard']; else $search = 0;

 if ($search==0) {
 $req = "
 SELECT COUNT(*) AS nbr FROM member A 
 LEFT JOIN ad_pays B ON B.id=A.payspy 
 LEFT JOIN ad_ville C ON C.id=A.wilaya 
 LEFT JOIN member_particip D ON D.membre=A.id 
 WHERE D.time_course>0 AND D.annee=:annee AND D.course=:course AND A.sex=:sexxxx ".(($__c>0 && $__k=='21km')?"AND D.catego=:catego ":"")."
 ORDER BY D.time_course;
 ";
 if ($__c>0 && $__k=='21km') $arg = compact('annee', 'course', 'sexxxx', 'catego');
 else $arg = compact('annee', 'course', 'sexxxx');
 $donnee = $db->select($req, $arg, false);
 $pages_nbr = ceil($donnee['nbr']/$maxshow);

 $req = "
 SELECT 
 A.*, B.alpha2 AS pays_ico, B.nom_fr_fr, B.nom_en_gb, C.nom AS ville_s, 
 D.classement, D.time_course, D.dossard, D.catego 
 FROM member A 
 LEFT JOIN ad_pays B ON B.id=A.payspy 
 LEFT JOIN ad_ville C ON C.id=A.wilaya 
 LEFT JOIN member_particip D ON D.membre=A.id 
 WHERE D.time_course>0 AND D.annee=:annee AND D.course=:course AND A.sex=:sexxxx ".(($__c>0 && $__k=='21km')?"AND D.catego=:catego ":"")."
 ORDER BY D.classement LIMIT ".$biginselect.",".$maxshow.";
 ";
 if ($__c>0 && $__k=='21km') $arg = compact('annee', 'course', 'sexxxx', 'catego');
 else $arg = compact('annee', 'course', 'sexxxx');
 $donnees = $db->select($req, $arg, true);
 } else {
 $pages_nbr = 1;
 $req = "
 SELECT 
 A.*, B.alpha2 AS pays_ico, B.nom_fr_fr, B.nom_en_gb, C.nom AS ville_s, 
 D.classement, D.time_course, D.dossard, D.catego 
 FROM member A 
 LEFT JOIN ad_pays B ON B.id=A.payspy 
 LEFT JOIN ad_ville C ON C.id=A.wilaya 
 LEFT JOIN member_particip D ON D.membre=A.id 
 WHERE D.time_course>0 AND D.dossard=:search;
 ";
 $arg = compact('search');
 $donnees = $db->select($req, $arg, true);
 }

 foreach ($donnees as $x => $donnee) {
 $cls++;
 if (!empty($_SESSION['id']) && !empty($_SESSION['prenom']) && !empty($_SESSION['nom'])) {
 $barco = ($donnee['membre']==$_SESSION['id'] || $donnee['nom']==$_SESSION['prenom'].' '.$_SESSION['nom'] || $donnee['nom']==$_SESSION['nom'].' '.$_SESSION['prenom']) ? ' table-standings-row--barca' : '';
 } else $barco = '';
 echo '
 <tr class="table-standings-row'.$barco.'">
 <td class="position-row'.(($cls<4)?' position-row--champions-league':(($cls<6)?' position-row--europa-league':'')).'">
 <span class="position-row__number">'.(($__c>0 && $__k=='21km' && $search==0)?$cls:$donnee['classement']).'</span>
 <div class="position-row__direction "></div>
 </td>
 <td class="table-stat-row table-stat-row--points"> '.$donnee['dossard'].' </td>
 <td class="badge-row" scope="row">
 <span class="badge-row__badge" title="'.$donnee['nom_fr_fr'].'">
 <span class="visually-hidden">'.$donnee['nom_fr_fr'].'</span>
 <img src="'.$config['app_url'].'sources/image/svg/flags/'.strtolower($donnee['pays_ico']).'.svg"  width="30" height="30" alt="'.$donnee['nom_en_gb'].'">
 </span>
 </td>
 <td class="table-stat-row"> '.utf8_encode($donnee['nom_en_gb']).' </td>
 <td class="table-stat-row"> '.(($donnee['payspy']==4)?utf8_encode($donnee['ville_s']):utf8_encode($donnee['wily_v'])).' </td>
 <td class="team-row" scope="row">
 <div class="team-row__name-container">
 <span class="team-row__name">'.utf8_encode($donnee['prenom'].' '.$donnee['nom']).'</span>
 <span class="team-row__name--short"></span>
 </div>
 </td>
 <td class="table-stat-row "> '.(($donnee['datnes']>0)?date('d/m/Y', $donnee['datnes']):'/').' </td>
 <td class="table-stat-row "> '.(($donnee['sex']==1)?'H':'F').' </td>
 <td class="table-stat-row "> '.(($donnee['catego']>0)?$donnee['catego']:'/').' </td>
 <td class="table-stat-row table-stat-row--points"> '.sectotime($donnee['time_course']).' </td>
 <td class="standings-table__gap-filler"></td>
 </tr>
 ';
 }

 } else {
 if ($__y==2007) {
 $req = "SELECT * FROM participant WHERE annee=:annee ORDER BY time_21_km;";
 $arg = compact('annee');
 $donnees = $db->select($req, $arg, true);
 foreach ($donnees as $x => $donnee) {
 $cls++;
 if (!empty($_SESSION['id']) && !empty($_SESSION['firstname']) && !empty($_SESSION['lastname'])) {
 $barco = ($donnee['membre']==$_SESSION['id'] || $donnee['nomnom']==$_SESSION['firstname'].' '.$_SESSION['lastname'] || $donnee['nomnom']==$_SESSION['lastname'].' '.$_SESSION['firstname']) ? ' table-standings-row--barca' : '';
 } else $barco = '';
 echo '
 <tr class="table-standings-row'.$barco.'">
 <td class="position-row'.(($cls<4)?' position-row--champions-league':(($cls<6)?' position-row--europa-league':'')).'">
 <span class="position-row__number">'.$cls.'</span>
 <div class="position-row__direction "></div>
 </td>
 <td class="table-stat-row table-stat-row--points"> '.$donnee['dossart'].' </td>
 <td class="team-row" scope="row">
 <div class="team-row__name-container">
 <span class="team-row__name">'.utf8_encode($donnee['prenom'].' '.$donnee['nomnom']).'</span>
 <span class="team-row__name--short"></span>
 </div>
 </td>
 <td class="table-stat-row "> '.date('Y', $donnee['datnes']).' </td>
 <td class="table-stat-row "> '.utf8_encode($donnee['wily_v']).' </td>
 <td class="table-stat-row table-stat-row--points"> '.sectotime($donnee['time_21_km']).' </td>
 <td class="standings-table__gap-filler"></td>
 </tr>
 ';
 }
 } elseif ($__y==2016 || $__y==2017) {
 if ($sexxxx==0) $sexxxx=2; 
 $req = "SELECT COUNT(*) AS nbr FROM participant WHERE ((course=1 AND time_21_km>0) OR (course=2 AND time_7_km>0)) AND annee=:annee AND course=:course AND sexxxx=:sexxxx ".(($__c>0 && $__k=='21km')?"AND catego=:catego ":"").";";
 if ($__c>0 && $__k=='21km') $arg = compact('annee', 'course', 'sexxxx', 'catego');
 else $arg = compact('annee', 'course', 'sexxxx');
 $donnee = $db->select($req, $arg, false);
 $pages_nbr = ceil($donnee['nbr']/$maxshow);


 $req = "
 SELECT A.*, B.nom AS pays_s, C.nom AS ville_s FROM participant A 
 LEFT JOIN adex_pays B ON B.id=A.payspy 
 LEFT JOIN ad_ville C ON C.id=A.wilaya 
 WHERE ((A.course=1 AND A.time_21_km>0) OR (A.course=2 AND A.time_7_km>0)) AND A.annee=:annee AND A.course=:course AND A.sexxxx=:sexxxx ".(($__c>0 && $__k=='21km')?"AND A.catego=:catego ":"")."
 ORDER BY ".(($__k=='21km')?"A.time_21_km":"A.time_7_km")." LIMIT ".$biginselect.",".$maxshow.";
 ";
 if ($__c>0 && $__k=='21km') $arg = compact('annee', 'course', 'sexxxx', 'catego');
 else $arg = compact('annee', 'course', 'sexxxx');
 $donnees = $db->select($req, $arg, true);
 foreach ($donnees as $x => $donnee) {
 $cls++;
 if (!empty($_SESSION['id']) && !empty($_SESSION['firstname']) && !empty($_SESSION['lastname'])) {
 $barco = ($donnee['membre']==$_SESSION['id'] || $donnee['nomnom']==$_SESSION['firstname'].' '.$_SESSION['lastname'] || $donnee['nomnom']==$_SESSION['lastname'].' '.$_SESSION['firstname']) ? ' table-standings-row--barca' : '';
 } else $barco = '';
 echo '
 <tr class="table-standings-row'.$barco.'">
 <td class="position-row'.(($cls<4)?' position-row--champions-league':(($cls<6)?' position-row--europa-league':'')).'">
 <span class="position-row__number">'.$cls.'</span>
 <div class="position-row__direction "></div>
 </td>
 <td class="table-stat-row table-stat-row--points"> '.$donnee['dossart'].' </td>
 <td class="table-stat-row"> '.utf8_encode($donnee['pays_s']).' </td>
 <td class="table-stat-row"> '.(($donnee['payspy']==4)?utf8_encode($donnee['ville_s']):utf8_encode($donnee['wily_v'])).' </td>
 <td class="team-row" scope="row">
 <div class="team-row__name-container">
 <span class="team-row__name">'.utf8_encode($donnee['prenom'].' '.$donnee['nomnom']).'</span>
 <span class="team-row__name--short"></span>
 </div>
 </td>
 <td class="table-stat-row "> '.(($donnee['datnes']>0)?date('d/m/Y', $donnee['datnes']):'/').' </td>
 <td class="table-stat-row "> '.(($donnee['sexxxx']==1)?'H':'F').' </td>
 <td class="table-stat-row "> '.(($donnee['catego']>0)?$donnee['catego']:'/').' </td>
 <td class="table-stat-row table-stat-row--points"> '.sectotime($donnee['time_21_km']).' </td>
 <td class="standings-table__gap-filler"></td>
 </tr>
 ';
 }
 } else {
 $req = "SELECT COUNT(*) AS nbr FROM participant WHERE annee=:annee AND course=:course AND sexxxx=:sexxxx ".(($__c>0 && $__k=='21km')?"AND catego=:catego ":"").";";
 if ($__c>0 && $__k=='21km') $arg = compact('annee', 'course', 'sexxxx', 'catego');
 else $arg = compact('annee', 'course', 'sexxxx');
 $donnee = $db->select($req, $arg, false);
 $pages_nbr = ceil($donnee['nbr']/$maxshow);

 $req = "
 SELECT A.* FROM participant A 
 WHERE A.annee=:annee AND A.course=:course AND A.sexxxx=:sexxxx ".(($__c>0 && $__k=='21km')?"AND A.catego=:catego ":"")."
 ORDER BY ".(($__k=='21km')?"A.time_21_km":"A.time_7_km")." LIMIT ".$biginselect.",".$maxshow.";
 ";
 if ($__c>0 && $__k=='21km') $arg = compact('annee', 'course', 'sexxxx', 'catego');
 else $arg = compact('annee', 'course', 'sexxxx');
 $donnees = $db->select($req, $arg, true);
 foreach ($donnees as $x => $donnee) {
 $cls++;
 if (!empty($_SESSION['id']) && !empty($_SESSION['firstname']) && !empty($_SESSION['lastname'])) {
 $barco = ($donnee['membre']==$_SESSION['id'] || $donnee['nomnom']==$_SESSION['firstname'].' '.$_SESSION['lastname'] || $donnee['nomnom']==$_SESSION['lastname'].' '.$_SESSION['firstname']) ? ' table-standings-row--barca' : '';
 } else $barco = '';
 echo '
 <tr class="table-standings-row'.$barco.'">
 <td class="position-row'.(($cls<4)?' position-row--champions-league':(($cls<6)?' position-row--europa-league':'')).'">
 <span class="position-row__number">'.$cls.'</span>
 <div class="position-row__direction "></div>
 </td>
 <td class="table-stat-row table-stat-row--points"> '.$donnee['dossart'].' </td>
 <td class="team-row" scope="row">
 <div class="team-row__name-container">
 <span class="team-row__name">'.utf8_encode($donnee['prenom'].' '.$donnee['nomnom']).'</span>
 <span class="team-row__name--short"></span>
 </div>
 </td>
 <td class="table-stat-row "> '.(($donnee['datnes']>0)?date('Y', $donnee['datnes']):'/').' </td>
 <td class="table-stat-row "> '.(($donnee['sexxxx']==1)?'H':'F').' </td>
 <td class="table-stat-row "> '.(($donnee['catego']>0)?$donnee['catego']:'/').' </td>
 <td class="table-stat-row "> '.utf8_encode($donnee['wily_v']).' </td>
 <td class="table-stat-row table-stat-row--points"> '.sectotime($donnee['time_21_km']).' </td>
 <td class="standings-table__gap-filler"></td>
 </tr>
 ';
 }
 }
 }
?>
 </tbody>
 </table>
 </section>
 </div>
 </section>
 <div class="pagination__bar">
<?php if ($pages_nbr>1) {

 if ($pages_nbr<6) {$pg_a=1;$pg_b=$pages_nbr;}
 elseif ($pages_nbr>5 && $page<5) {$pg_a=1;$pg_b=5;}
 elseif ($page>($pages_nbr-5)) {$pg_a=$pages_nbr-4;$pg_b=$pages_nbr;}
 else {$pg_a=$page-2;$pg_b=$page+2;}

 for ($i=$pg_a; $i <= $pg_b; $i++) { 
 echo '<a href="'.(($i==$page)?'javascript:;':'?p='.$i).'" class="pagination__link">'.$i.'</a>';
 }
}?>
 </div>
 </div>
 </div>
 </div>
 </main>
</div>

<?php include_once("sources/include/sponsors.php");?>

<?php $this->stopSection(); ?>

<?php /*-------------------------------------- Put here your additional CSS files for this page --------------------------------------*/ ?>
<?php $this->startSection('wisra_css_content'); ?>
 
<?php $this->stopSection(); ?>

<?php /*-------------------------------------- Put here your additional JS files  for this page --------------------------------------*/ ?>
<?php $this->startSection('wisra_js_content'); ?>
 
<?php $this->stopSection(); ?>
<?php if (@$_shouldextend[1]) { echo $this->runChild('layout', ['page_data' => array(
 'plugins' => array(), 
 'title' => "Résultats ".$__y." | Semi Marathon International de Béjaia", 
 'description' => "Résultats ".$__y.", Semi Marathon International de la ville de Béjaia: course 21km, 7km et 3km pour enfants, handisports. organisé par l'Athlétic Méditerranéen Club Béjaia AMCB chaque année, a la vile de Béjaia - Algérie", 
 'keywords' => array("Résultats".$__y, "Résultats ".$__y." Semi Marathon Bejaia", "Semi Marathon International de la ville de Béjaia", "Semi Marathon International de Béjaia", "Semi Marathon Béjaia", "SemiMarathon Béjaia", "Demi Marathon Béjaia", "Semi Marathon International Bejaia", "Semi", "Marathon", "Semi-Marathon", "International", "Semi-Marathon International", "Béjaia", "Semi-Marathon International Béjaia", "course 21km", "course 7km", "course 3km", "course enfants", "course handisports", "Athlétic Méditerranéen Club Béjaia", "Athlétic Club", "Athlétic Club Béjaia",  "Athlétic Méditerranéen Club Béjaia", "AMCB", "la vile de Béjaia", "Algérie", "Béjaia Algérie"), 
 'facebook_integration' => false, 
 'google_maps_callback' => '', 
 'secondary_name' => 'results', 
 'secondary_year' => $__y, 
 'secondary_sexe' => $__s, 
 'secondary_course' => $__k, 
 'secondary_cat' => $__c, 
 'filters_result' => 1, 
 'filters_header' => 1, 
 'filter_link' => 'resultats'
)]); } ?>