<?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->isadmin()) header("Location: ".$config['app_url']."admin-login");
 if ($_SESSION['aid']<90) header("Location: ".$config['app_url']."admin-list");

 $selectiz = array(
 '21km-hommes' => array('c'=>1, 'ct'=>'21km', 's'=>1, 'st'=>'Hommes', 'tt'=>'21km Hommes', 'file'=>'participo-h-21km'), 
 '21km-femmes' => array('c'=>1, 'ct'=>'21km', 's'=>0, 'st'=>'Femmes', 'tt'=>'21km Femmes', 'file'=>'participo-f-21km'), 
 '7km-hommes' => array('c'=>2, 'ct'=>'7km', 's'=>1, 'st'=>'Hommes', 'tt'=>'7km Hommes', 'file'=>'participo-h-7km'), 
 '7km-femmes' => array('c'=>2, 'ct'=>'7km', 's'=>0, 'st'=>'Femmes', 'tt'=>'7km Femmes', 'file'=>'participo-f-7km')
 );
 if (!empty($_GET['s']) && in_array($_GET['s'], array_keys($selectiz))) $__s = $_GET['s']; else $__s = '21km-hommes';
 if (!empty($_GET['__c'])) $__c = $_GET['__c']; else $__c = 0;
 $data2uz = $selectiz[$__s];

?>

<?php $_shouldextend[1]=1; ?>


<?php $this->startSection('wisra_basic_content'); ?>
 @parentXYZABC

<div class="body-content js-body-content blue-body">
 <main id="main" class="violiii">
 <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/admin/stripes-left.png" data-image-src="<?php echo $config['app_url'] ?>sources/image/admin/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/admin/stripes-right.png" data-image-src="<?php echo $config['app_url'] ?>sources/image/admin/stripes-right.png" alt="Standings Background Pattern">
 </picture>
 <img src="<?php echo $config['app_url'] ?>sources/image/<?php echo $_SESSION['aid'] ?>.svg" class="special-ico">
 </div>
 <div class="u-main-gradient admin-blocks">
 <div class="wrapper">
 <div class="col-12">
 <section class="standings">
 <div class="standings__header">
 <div class="standings-header admin">
 <div class="fixture-result-list__month-full">
 Liste <span>complète</span>
 </div>
 </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">
 <input type="hidden" id="selectedcountry" value="<?php echo $__c?>">
 <select id="getdata-pays" class="user-form__input user-form__select">
 <option value="0"<?php echo ($__c==0)?' selected':''?>>Pays (Tout)</option>
<?php
 $req = "
 SELECT COUNT(*) AS nbr, B.payspy, C.nom_fr_fr FROM member_particip A 
 INNER JOIN member B ON B.id=A.membre INNER JOIN ad_pays C ON C.id=B.payspy WHERE A.annee=:an 
 GROUP BY B.payspy ORDER BY nbr DESC
 ";
 $arg = array('an'=>$config['smib_annee_encours']);
 $donnees = $db->select($req, $arg, true);
 foreach ($donnees as $key => $donnee) echo '<option value="'.$donnee['payspy'].'"'.(($__c==$donnee['payspy'])?' selected':'').'>'.utf8_encode($donnee['nom_fr_fr']).' ('.$donnee['nbr'].')</option>';
?>
 </select>
 </div>
 <div class="standings-pane-header__info"></div>
 <span class="standings-pane-header__name visually-hidden"></span>
 <div class="standings-pane-header__time-info">
 <div class="standings-pane-header__last-updated"> 
 Chargement de liste : <?php echo $config['smib_annee_encours'];?>
 </div>
 <div class="standings-pane-header__season-info-container">
 <span class="standings-pane-header__season-info js-season-info"> All </span>
 <span class="standings-pane-header__match-week-info js-match-week-info"> H/F </span>
 </div>
 </div>
 </div>
 <hr/>
 <table class="standings-league__table standings-table" id="table">
 <thead class="standings-table__head">
 <tr>
<?php 
 $headras = array(
 array('ID', 'Prénom', 'Nom', 'Sexe', 'Date naissance', 'Telephone', 'Pays'), 
 array('ID', 'Prénom', 'Nom', 'Sexe', 'Date naissance', 'Telephone', 'Pays')
 );
 foreach ($headras[0] as $x => $value) {
 echo '
 <th class="table-head" scope="col">
 <span class="table-head__heading">'.$value.'</span>
 <span class="table-head__heading--short">'.$headras[1][$x].'</span>
 </th>
 ';
 }
?>
 </tr>
 </thead>
 <tbody class="standings-table__body"></tbody>
 </table>
 <hr/>
 <p>
 En cas de problème ou d'urgence, veuillez contacter l'informaticien directement sur le numéro <strong>0556 06 96 07</strong>
 </p>
 </section>
 </div>
 </section>
 </div>
 </div>
 </div>
 </main>
</div>

<?php $this->stopSection(); ?>

<?php /*------------------------- Put here your additional CSS files for this page -------------------------*/ ?>
<?php $this->startSection('wisra_css_content'); ?>
<link href="<?php echo $config['app_url'];?>sources/plugin/toastr/toastr.min.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" href="<?php echo $config['app_url']?>sources/plugin/fancybox/jquery.fancybox.min.css" />
<style type="text/css">
img.special-ico {
 position: absolute;
 left: 50%;
 top: 73px;
 height: 121px;
 margin-left: -60px;
}
</style>
<link rel="stylesheet" type="text/css" href="<?php echo $config['app_url'];?>sources/plugin/tomytable/css/tomytable.min.css">
<link rel="stylesheet" type="text/css" href="<?php echo $config['app_url'];?>sources/plugin/tomytable/font/tomytable/css/tomytable.css">
<?php $this->stopSection(); ?>

<?php /*------------------------- Put here your additional JS files  for this page -------------------------*/ ?>
<?php $this->startSection('wisra_js_content'); ?>
<script src="<?php echo $config['app_url'];?>sources/plugin/tomytable/js/tomytable.js"></script>
<script src="<?php echo $config['app_url'];?>sources/plugin/toastr/toastr.min.js"></script>
<script src="<?php echo $config['app_url'];?>sources/plugin/b-table/datatables.min.js"></script>
<script src="<?php echo $config['app_url']?>sources/plugin/fancybox/jquery.fancybox.min.js"></script>
<script src="<?php echo $config['app_url'];?>sources/script/admin.js"></script>
<script type="text/javascript">
 var access_col = 'participo-specoal';

 $('#table tbody').on( 'click', 'a.fixture-cta__barca-video.button.button--stroke.button--dark', function () {
 var ths=$(this), data=table.row( ths.parents('tr') ).data(), id=data[10], val=$('#editcurrentload').val();
 if (val==0) loadtoedit(id);
 });
 $('#getdata-pays').change(function(){var vl=$(this).val();location.replace('?s=<?php echo $__s;?>&__c='+vl);});

</script>
<?php $this->stopSection(); ?>
<?php if (@$_shouldextend[1]) { echo $this->runChild('layout', ['page_data' => array(
 'plugins' => array(), 
 'title' => "SMIB | Spécial", 
 'description' => "SMIB | Spécial", 
 'keywords' => array("SMIB | Spécial"), 
 'facebook_integration' => false, 
 'google_maps_callback' => '', 
 'admin_interface' => 1
)]); } ?>