isadmin()) header("Location: ".$config['app_url']."admin-login");
if (!empty($_SESSION['aid']) && $_SESSION['aid']>90) header("Location: ".$config['app_url']."special-adm");
if ($_SESSION['aid']>3) header("Location: ".$config['app_url']."admin-lista");
?>
startSection('wisra_basic_content'); ?>
@parentXYZABC
Les statistiques par année
Chargement des statistiques :
type: Tout
$value) {
echo '
'.$value.''.$headras[1][$x].'
';
}
?>
2007; $i--) {
if ($i!=2020 && $i>2018) {
$req = "SELECT
(SELECT COUNT(*) FROM member A INNER JOIN member_particip B ON B.membre=A.id WHERE B.annee=:i AND A.sex=1 AND B.course=1 AND B.dossard>0) AS total_h,
(SELECT COUNT(*) FROM member A INNER JOIN member_particip B ON B.membre=A.id WHERE B.annee=:i AND A.sex=0 AND B.course=1 AND B.dossard>0) AS total_f,
(SELECT COUNT(*) FROM member A INNER JOIN member_particip B ON B.membre=A.id WHERE B.annee=:i AND B.course=1 AND B.dossard>0) AS total;
";
$arg = compact('i');
$donnee = $db->select($req, $arg, false);
if ($donnee['total']>0) $j++;
$total_h+=$donnee['total_h'];
$total_f+=$donnee['total_f'];
$total+=$donnee['total'];
if ($donnee['total']>0) {
?>
0) AS total_h,
(SELECT COUNT(*) FROM participant WHERE annee=:i AND course=1 AND sexxxx!=1 AND dossart>0) AS total_f,
(SELECT COUNT(*) FROM participant WHERE annee=:i AND course=1 AND dossart>0) AS total;
";
$arg = compact('i');
$donnee = $db->select($req, $arg, false);
$j++;
$total_h+=$donnee['total_h'];
$total_f+=$donnee['total_f'];
$total+=$donnee['total'];
?>
