<?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 (!$member->ismembre()) header("Location: ".$config['app_url']."login-connexion");
?>

<?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="static-wrapper">


 <div class="fixture-hero ticketing">
 <div class="fixture-hero__bg fixed-hero-bg">
 <div class="hero-photo">
 <picture class="hero-photo__picture-element js-lazy-picture loaded">
 <img src="<?php echo $config['app_url'] ?>sources/image/artiles/1.jpg?width=1200&amp;height=525" data-image-src="<?php echo $config['app_url'] ?>sources/image/artiles/1.jpg?width=1200&amp;height=525" alt="estadi bg vip" class="hero-photo__image poly-object-fit">
 </picture>
 </div>
 </div>
 <div class="fixture-hero__content">
 <img src="<?php echo $config['app_url'] ?>sources/image/basic/semi-marathon-bejaia-footer.png" alt="<?php echo $config['app_name'] ?> logo" class="fixture-hero__competition-logo">
 <span class="fixture-hero__name visually-hidden"></span>
 <div class="fixture-hero__stage-container">
 <div class="fixture-hero__stage">La <?php echo date('Y')-2006; ?>ème édition</div>
 <div class="fixture-hero__stage-location">Béjaia</div>
 </div>
 <div class="fixture-hero__date"><?php
 if (time() < $config['smib_dapart_timestp']) echo $config['smib_dapart_date'];
 else if (time() < $config['smib_finish_timestp']) echo 'EN COURS';
 else echo 'FINIE';
 ?></div>
 <div class="fixture-info">
 <a href="javascript:;" class="fixture-info__link">
 <div class="fixture-info__time-container">
 <div class="fixture-info__time-explainer">Départ
 <span class="js-fixture-kickoff-zone"></span>
 </div>
 <div class="fixture-info__time js-fixture-kickoff"><?php echo $config['smib_dapart_heure'] ?></div>
 </div>
 </a>
 </div>
 <div class="countdown " data-widget="countdown">
 <div class="countdown__content countdown__content--no-sponsor">
 <div class="countdown__title-container">
 <span class="countdown__title">Compte-à-rebours avant le départ</span>
 </div>
 </div>
<?php 
 $date1 = time();
 $date2 = $config['smib_dapart_timestp'];
 if ($date2>$date1) {
 $diff = abs($date2 - $date1);
 $days = floor($diff / (60*60*24));
 $hours = floor(($diff - $days*60*60*24) / (60*60));
 $minutes = floor(($diff - $days*60*60*24 - $hours*60*60)/ 60);  
 $seconds = floor(($diff - $days*60*60*24 - $hours*60*60 - $minutes*60));  
 } else $days = $hours = $minutes = $seconds = 0;  
?> 
 <div class="countdown__clock js-countdown-clock">
 <div class="countdown__clock-item days">
 <div class="countdown__count">
 <span class="countdown__value js-countdown-days"><?php echo $days;?></span>
 <span class="countdown__separator">:</span>
 </div>
 <div class="countdown__count-label">jours</div>
 </div>
 <div class="countdown__clock-item hours">
 <div class="countdown__count">
 <span class="countdown__value js-countdown-hours"><?php echo $hours;?></span>
 <span class="countdown__separator">:</span>
 </div>
 <div class="countdown__count-label">h</div>
 </div>
 <div class="countdown__clock-item minutes">
 <div class="countdown__count">
 <span class="countdown__value js-countdown-minutes"><?php echo $minutes;?></span>
 <span class="countdown__separator">:</span>
 </div>
 <div class="countdown__count-label">min</div>
 </div>
 <div class="countdown__clock-item seconds">
 <div class="countdown__count">
 <span class="countdown__value js-countdown-seconds"><?php echo $seconds;?></span>
 </div>
 <div class="countdown__count-label">sec</div>
 </div>
 </div>
 </div>
 <div class="fixture-ticketing">
 <div class="fixture-cta">
<?php
 $req = "SELECT id, uniq_y, valide, dossard, time_course, classement, diplome_code FROM member_particip WHERE membre=:id AND annee=:annee AND removed=0;";
 $arg = array('id'=>$_SESSION['id'], 'annee'=>$config['smib_annee_encours']);
 $donnee = $db->select($req, $arg, false);
 if ($config['smib_encours_finie']==1) {
 if ($donnee['valide']==1 && $donnee['dossard']>0 && $donnee['time_course']>0 && $donnee['classement']>0) {
?>
 <div class="fixture-tickets__container">
 <a href="<?php echo $config['app_url'] ?>attestation-de-participation/<?php echo $donnee['diplome_code'];?>/<?php echo $config['smib_annee_encours'];?>" class="fixture-cta__tickets button button--vip-tickets-on-light" target="_blank"> IMPRIMER VOTRE ATTESTATION  </a>
 <div class="fixture-tickets__price-container">
 <span class="fixture-tickets__price-label">ATTESTATION DE PARTICIPATION</span>
 </div>
 </div>
<?php 
 }
 } elseif ($config['smib_encours_finie']==0) {
 $req = "SELECT datnes FROM member WHERE id=:id AND removed=0;";
 $arg = array('id'=>$_SESSION['id']);
 $infos = $db->select($req, $arg, false);
 $ageage = date('Y', time()) - date('Y', $infos['datnes']);
 if (empty($donnee) && $ageage>=14) {
 if ($config['smib_control_opa']==0 && !in_array($_SESSION['id'], $config['smib_not_run'])) {
?>
 <div class="fixture-tickets__container">
 <a href="<?php echo $config['app_url'] ?>participation-smib" class="fixture-cta__tickets button button--standard-tickets"> PARTICIPER </a>
 <div class="fixture-tickets__price-container">
 <span class="fixture-tickets__price-label">VOULEZ-VOUS PARTICIPER</span>
 </div>
 </div>
<?php }} elseif ($ageage>=14) {?>
 <div class="fixture-tickets__container">
 <a href="<?php echo $config['app_url'] ?>participation-smib" class="fixture-cta__tickets button button--standard-tickets"> VOTRE PARTICIPATION </a>
 <div class="fixture-tickets__price-container">
 <span class="fixture-tickets__price-label">VOUS ÊTES DEJA INSCRIT</span>
 </div>
 </div>
 <div class="fixture-tickets__container fixture-tickets__container--group">
 <a href="<?php echo $config['app_url'] ?>courir-en-groupe" rel="noopener" class="fixture-cta__tickets button button--group-tickets">
 <span>GROUPES</span>
 </a>
 <div class="fixture-tickets__price-container">
 <span class="fixture-tickets__price-label">Participer en groupe</span>
 </div>
 </div>
<?php 
 }
 }
?>

 <div class="fixture-tickets__container">
 <a href="<?php echo $config['app_url'] ?>modifier-profil" class="fixture-cta__tickets button button--standard-tickets"> 
 MODIFIER LE PROFIL 
 </a>
 <div class="fixture-tickets__price-container">
 <span class="fixture-tickets__price-label">Modifier vos données</span>
 </div>
 </div>


 </div>
 </div>
<?php
 if (empty($donnee)) {
?>
 <div class="fixture-hero__date red__colorado">VOUS N'AVEZ PAS PARTICIP&Eacute;</div>
<?php } else {
 if ($donnee['dossard']>0) {
?>
 <div class="fixture-hero__date red__colorado">VOTRE DOSSARD: <?php echo $donnee['dossard'];?></div>
<?php
 } else {
?>
 <div class="fixture-hero__date red__colorado">VOTRE IDENTIFIANT UNIQUE: <?php echo $donnee['uniq_y'];?></div>
<?php
 }
}
?>
 </div>
 </div>


 <div class="ticket-info-bar ticket-info-bar--header">
 <div class="ticket-info-bar__wrapper">
 <div class="ticket-info-bar__item">
 <img type="image/svg+xml" src="<?php echo $config['app_url'] ?>sources/image/svg/success.svg" width="24" height="24"/>
 <div class="ticket-info-bar__content">
 <div class="ticket-info-bar__title">Une seule inscription</div>
 </div>
 </div>
 <div class="ticket-info-bar__item">
 <img type="image/svg+xml" src="<?php echo $config['app_url'] ?>sources/image/svg/success.svg" width="24" height="24"/>
 <div class="ticket-info-bar__content">
 <div class="ticket-info-bar__title">Historique de participations</div>
 </div>
 </div>
 <div class="ticket-info-bar__item">
 <img type="image/svg+xml" src="<?php echo $config['app_url'] ?>sources/image/svg/success.svg" width="24" height="24"/>
 <div class="ticket-info-bar__content">
 <div class="ticket-info-bar__title">Contact permanent avec nous</div>
 </div>
 </div>
 <div class="ticket-info-bar__item">
 <img type="image/svg+xml" src="<?php echo $config['app_url'] ?>sources/image/svg/success.svg" width="24" height="24"/>
 <div class="ticket-info-bar__content">
 <div class="ticket-info-bar__title">Facilité d'utilisation</div>
 </div>
 </div>
 </div>
 </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>Participations</h1>
 </div>
 </div>
<?php
 $req = "SELECT oldest_verif FROM member WHERE id=:id;";
 $arg = array('id'=>$_SESSION['id']);
 $donnee = $db->select($req, $arg, false);
 if ($donnee['oldest_verif']==0) {

 $req = "SELECT id FROM participant WHERE (nomnom=:nom_a AND prenom=:nom_b) OR nomnom=:nom_c OR prenom=:nom_d;";
 $arg = array(
 'nom_a'=>$_SESSION['lastname'], 
 'nom_b'=>$_SESSION['firstname'], 
 'nom_c'=>$_SESSION['firstname'].' '.$_SESSION['lastname'], 
 'nom_d'=>$_SESSION['lastname'].' '.$_SESSION['firstname']
 );
 $donnees = $db->select($req, $arg, true);
 foreach ($donnees as $x => $donnee) {
 $req = "UPDATE participant SET membre=:moi WHERE id=:id";
 $arg = array('moi'=>$_SESSION['id'], 'id'=>$donnee['id']);
 $execute = $db->execute($req, $arg);
 }
 $req = "UPDATE member SET oldest_verif=1 WHERE id=:id";
 $arg = array('id'=>$_SESSION['id']);
 $execute = $db->execute($req, $arg);
 }
?>
 <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"></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">Votre historique de participations</div>
 <div class="standings-pane-header__season-info-container">
 <span class="standings-pane-header__season-info js-season-info">Depuis 2007 </span>
 <span class="standings-pane-header__match-week-info js-match-week-info">Jusqu'a <?php echo date('Y');?></span>
 </div>
 </div>
 </div>

 <table class="standings-league__table standings-table">
 <thead class="standings-table__head">
 <tr>
<?php 
 $tablaxa=array(
 array('Classement', 'N° Dossard', '', 'Pays', 'Ville', 'Nom & Prénom', 'Date de Naissance', 'Sexe', 'Course', 'Temps', 'Année'), 
 array('Cls', 'N°', '', 'Pys', 'Vil', 'Nom', 'Naiss', 'Sex', 'Crs', 'Tps', 'An')
 );
 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 
 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;
 }
/*=====================
// 2019 et après
============================*/


/*=====================
// 2018 et avant
============================*/
/*

*/
 $req = "
 SELECT 
 A.course, A.catego, A.annee, A.dossart, A.time_7_km, A.time_21_km, 
 B.nom, B.prenom, B.datnes, B.sex, B.payspy, B.wilaya, B.wily_v, B.comune, 
 C.alpha2 AS pays_ico, C.nom_en_gb, C.nom_fr_fr, D.nom AS ville_s, 
 ((SELECT COUNT(*) FROM participant WHERE annee=A.annee AND course=A.course AND sexxxx=A.sexxxx AND dossart>0 AND ((course=1 AND time_21_km>0) OR (course=2 AND time_7_km>0)) AND ((course=1 AND time_21_km<A.time_21_km) OR (course=2 AND time_7_km<A.time_7_km)))+1) AS classement
 FROM participant A 
 INNER JOIN member B ON B.id=:id 
 LEFT JOIN ad_pays C ON C.id=B.payspy 
 LEFT JOIN ad_ville D ON D.id=B.wilaya 
 WHERE A.membre=:id AND A.dossart>0 AND ((A.course=1 AND A.time_21_km>0) OR (A.course=2 AND A.time_7_km>0)) ORDER BY A.annee DESC;
 ";
 $arg = array('id'=>$_SESSION['id']);
 $donnees = $db->select($req, $arg, true);
 foreach ($donnees as $x => $donnee) {
 echo '
 <tr class="table-standings-row">
 <td class="position-row'.(($donnee['classement']<4)?' position-row--champions-league':(($donnee['classement']<6)?' position-row--europa-league':'')).'">
 <span class="position-row__number">'.$donnee['classement'].'</span>
 <div class="position-row__direction "></div>
 </td>
 <td class="table-stat-row table-stat-row--points"> '.$donnee['dossart'].' </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"> '.$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['course']==1)?'21Km':'7Km').' </td>
 <td class="table-stat-row table-stat-row--points"> '.(($donnee['course']==1)?sectotime($donnee['time_21_km']):sectotime($donnee['time_7_km'])).' </td>
 <td class="table-stat-row table-stat-row--points"> '.$donnee['annee'].' </td>
 <td class="standings-table__gap-filler"></td>
 </tr>
 ';
 }
?>
 </tbody>
 </table>

 </section>
 </div>

 </section>
 </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' => "Profil | Semi Marathon International de Béjaia", 
 'description' => "Votre profil du Semi Marathon International de la ville de Béjaia", 
 'keywords' => array("SMIB", "Semi Marathon", "Semi Marathon de Béjaia", "Semi Marathon International de Béjaia", "Semi Marathon International de la ville de Béjaia", "Se connecter", "Connexion au Semi Marathon", "Connexion au Semi Marathon de Béjaia", "Connexion au Semi Marathon International de Béjaia", "Connexion au Semi Marathon International de la ville de Béjaia", "Course a pied", "Course a pieds", "Course à pied", "Course à pieds", "Course a pieds 21 km", "Course a pieds 7km", "Course a pieds hommes femmes", "Course a pieds algérie"), 
 'facebook_integration' => false, 
 'google_maps_callback' => ''
)]); } ?>