<?php
if(basename(__FILE__) == basename($_SERVER['PHP_SELF'])){exit();}
global $config;
require_once 'config/class/class.database.php';
$db = new database();

header("Content-type: text/csv");
header("Content-Disposition: attachment; filename=semimarathon-".$config['smib_annee_encours'].".csv");
header("Pragma: no-cache");
header("Expires: 0");
date_default_timezone_set('Africa/Algiers');

//=> Filters
echo 'ID;Dossard;Nom;Prenom;Sexe;Naissance;Categorie;Course;Pays;telephone';
echo "\n";
echo "\n";

$req = "
 SELECT 
 A.id, A.nom, A.prenom, A.sex, A.datnes, A.teln_1, A.tel_country, B.course, B.dossard, B.ageage, B.catego, C.nom_en_gb AS pays, D.nom as wilaia_nm 
 FROM member A 
 INNER JOIN member_particip B ON B.membre=A.id AND B.dossard>0 
 LEFT JOIN ad_pays C ON C.id=A.payspy 
 LEFT JOIN ad_ville D ON D.id=A.wilaya 
 WHERE B.annee=2021 ORDER BY B.dossard
";
$nbr=0;
$req = "
 SELECT 
 A.id, A.nom, A.prenom, A.sex, A.datnes, A.teln_1, A.tel_country, B.course, B.dossard, B.ageage, B.catego, C.nom_en_gb AS pays 
 FROM member A 
 INNER JOIN member_particip B ON B.membre=A.id  
 LEFT JOIN ad_pays C ON C.id=A.payspy 
 WHERE B.annee=".$config['smib_annee_encours']."
";
$arg = array();
$donnees = $db->select($req, $arg, true);
foreach ($donnees as $x => $donnee) {
 $nbr++;
 echo ';';
 echo $donnee['dossard'].';';
 echo $donnee['nom'].';';
 echo $donnee['prenom'].';';
 echo (($donnee['sex']==1)?'M':'F').';';
 echo date('d-m-Y', $donnee['datnes']).';';
 echo $donnee['catego'].';';
 echo (($donnee['course']==1)?'21km':'7km').';';
 echo $donnee['pays'].';';
 echo '('.$donnee['tel_country'].') '.$donnee['teln_1'].';';
 echo "\n";
}