芝麻web文件管理V1.00

编辑当前文件:/home/asmplong/www/ancien-site-2019/extract.php

<?php
$bdd = new PDO('mysql:host=localhost;dbname=asmplongeedb2;charset=utf8', 'root', '');

function pgSoir ($moisTexte, $moisChiffre) {
//PG soir
	$PgSoir = $bdd->query('SELECT * FROM events WHERE event_date >= "2017-'.$moisChiffre.'-01 00:00:00" AND event_date <= "2017-'.$moisChiffre.'-31 23:59:59" AND event_type = (1 | 2)');
	echo 'nbr de plong�e du soir en '.$moisTexte.' : '.count($PgSoir);

while ($donnees = $PgSoir->fetch()) {
		$nbrParticipantPgSoir = $bdd->query('SELECT * FROM inscriptions WHERE inscription_id_event = '.$donnees[event_id].'');
		$lieuPgSoir1 = $bdd->query('SELECT site_nom FROM sites WHERE site_id = '.$donnees[event_lieu_1].'');
		$lieuPgSoir2 = $bdd->query('SELECT site_nom FROM sites WHERE site_id = '.$donnees[event_lieu_2].'');
		$lieuPgSoir = $lieuPgSoir1.' et '.$lieuPgSoir2;
		if (empty($lieuPgSoir2)) {
			$lieuPgSoir = $lieuPgSoir1;
		}

echo 'Le '.$donnees['event_date'].' ---- nbr participant : '.count($nbrParticipantPgSoir).' -- lieu : '.$lieuPgSoir.';
	}

//PG weekend
	$PgWeekend = $bdd->query('SELECT * FROM events WHERE event_date >= "2017-'.$moisChiffre.'-01 00:00:00" AND event_date <= "2017-'.$moisChiffre.'-31 23:59:59" AND event_type = (3 | 4 | 5 | 7 | 9)');
	echo 'nbr de plong�e week-end en '.$moisTexte.' : '.count($PgWeekend);
	
	while ($donnees1 = $PgWeekend->fetch()) {
		$nbrParticipantPgWeekend = $bdd->query('SELECT * FROM inscriptions WHERE inscription_id_event = '.$donnees1[event_id].'');
		$lieuPgWeekend1 = $bdd->query('SELECT site_nom FROM sites WHERE site_id = '.$donnees1[event_lieu_1].'');
		$lieuPgWeekend2 = $bdd->query('SELECT site_nom FROM sites WHERE site_id = '.$donnees1[event_lieu_2].'');
		$lieuPgWeekend = $lieuPgWeekend1.' et '.$lieuPgWeekend2;
		if (empty($lieuPgWeekend2)) {
			$lieuPgWeekend = $lieuPgWeekend1;
		}

echo 'Le '.$donnees1['event_date'].' ---- nbr participant : '.count($nbrParticipantPgWeekend).' -- lieu : '.$lieuPgWeekend.';
	}

//PG bapteme
	$Pgbapt = $bdd->query('SELECT * FROM events WHERE event_date >= "2017-'.$moisChiffre.'-01 00:00:00" AND event_date <= "2017-'.$moisChiffre.'-31 23:59:59" AND event_type = 6');
	echo 'nbr de plong�e Bapt�me en '.$moisTexte.' : '.count($Pgbapt);
	
	while ($donnees2 = $Pgbapt->fetch()) {
		$nbrParticipantPgbapt = $bdd->query('SELECT * FROM inscriptions WHERE inscription_id_event = '.$donnees2[event_id].'');
		$lieuPgbapt1 = $bdd->query('SELECT site_nom FROM sites WHERE site_id = '.$donnees2[event_lieu_1].'');
		$lieuPgbapt2 = $bdd->query('SELECT site_nom FROM sites WHERE site_id = '.$donnees2[event_lieu_2].'');
		$lieuPgbapt = $lieuPgbapt1.' et '.$lieuPgbapt2;
		if (empty($lieuPgbapt2)) {
			$lieuPgbapt = $lieuPgbapt1;
		}

echo 'Le '.$donnees2['event_date'].' ---- nbr participant : '.count($nbrParticipantPgbapt).' -- lieu : '.$lieuPgbapt.';
	}

// Evenement divers
	$Pgdivers = $bdd->query('SELECT * FROM events WHERE event_date >= "2017-'.$moisChiffre.'-01 00:00:00" AND event_date <= "2017-'.$moisChiffre.'-31 23:59:59" AND event_type = 8');
	echo 'nbr de plong�e Bapt�me en '.$moisTexte.' : '.count($Pgdivers);
	
	while ($donnees3 = $Pgdivers->fetch()) {
		$nbrParticipantPgdivers = $bdd->query('SELECT * FROM inscriptions WHERE inscription_id_event = '.$donnees3[event_id].'');
		$lieuPgdivers1 = $bdd->query('SELECT site_nom FROM sites WHERE site_id = '.$donnees3[event_lieu_1].'');
		$lieuPgdivers2 = $bdd->query('SELECT site_nom FROM sites WHERE site_id = '.$donnees3[event_lieu_2].'');
		$lieuPgdivers = $lieuPgdivers1.' et '.$lieuPgdivers2;
		if (empty($lieuPgdivers2)) {
			$lieuPgdivers = $lieuPgdivers1;
		}

echo 'Le '.$donnees3['event_date'].' ---- titre : '.$donnees3['event_titre'].' -- nbr participant : '.count($nbrParticipantPgdivers).' -- lieu : '.$lieuPgdivers.';
	}
}

$mois = [
	'janvier' => '01',
	'fevrier' => '02',
	'mars' => '03',
	'avril' => '04',
	'mai' => '05',
	'juin' => '06',
	'juillet' => '07',
	'aout' => '08',
	'septembre' => '09',
	'octobre' => '10',
	'novembre' => '11',
	'decembre' => '12'];

foreach($mois as $key => $value) {
	pgSoir ($key, $value);
}