File "statistiques02.php"
Full Path: /home/analogde/www/CGI/MASSAGE_TEST/statistiques02.php
File size: 18.33 KB
MIME-type: text/x-php
Charset: utf-8
<?php
session_start ();
include('database.php');
DB_connexion();
//error_reporting(0);
if (!isset($_SESSION['nom']) && !isset($_SESSION['password']))
{
header("Location: login.php");
}
header( 'content-type: text/html; charset=utf-8' );
/*
//$mois = 2;
$mois = $_GET['mois'];
//$annee = date('Y'); //maintenant on peut choisir l'année
//$table = "reservation" .$annee;
$table = $_SESSION['table_reservation'];
$table = $_SESSION['table_reservation'] = "reservation" .$_SESSION['year'] ."_v3";
echo $table;
//+++++++++++++++ COURTE +++++++++++++++++++++++";
$sql = "SELECT * FROM " .$table ." WHERE mois ='$mois' and formule = 'courte' and mode ='actif' ";
mysqli_query($connexion, "SET NAMES 'utf8'");
$result = mysqli_query($connexion, $sql );
if(!$result)
{ die('Impossible d\'exécuter la requête :' . mysql_error());
}
$n = mysqli_num_rows($result);
$tab_client_courte = array();
if($n != 0)
{
while ($datas = mysqli_fetch_assoc ($result))
{
$seance1 = $datas['seance1'];
$seance2 = $datas['seance2'];
$seance3 = $datas['seance3'];
$seance4 = $datas['seance4'];
$seance5 = $datas['seance5'];
$seance6 = $datas['seance6'];
$seance7 = $datas['seance7'];
$seance8 = $datas['seance8'];
if(strlen($seance1) !=0 && $seance1 != "unselect" && $seance1 != "creneau ouvert" && $seance1 != "creneau fermer")
{ $tab_client_courte[] = $seance1;
}
if(strlen($seance2) !=0 && $seance2 != "unselect" && $seance2 != "creneau ouvert" && $seance2 != "creneau fermer")
{ $tab_client_courte[] = $seance2;
}
if(strlen($seance3) !=0 && $seance3 != "unselect" && $seance3 != "creneau ouvert" && $seance3 != "creneau fermer")
{ $tab_client_courte[] = $seance3;
}
if(strlen($seance4) !=0 && $seance4 != "unselect" && $seance4 != "creneau ouvert" && $seance4 != "creneau fermer")
{ $tab_client_courte[] = $seance4;
}
if(strlen($seance5) !=0 && $seance5 != "unselect" && $seance5 != "creneau ouvert" && $seance5 != "creneau fermer")
{ $tab_client_courte[] = $seance5;
}
if(strlen($seance6) !=0 && $seance6 != "unselect" && $seance6 != "creneau ouvert" && $seance6 != "creneau fermer")
{ $tab_client_courte[] = $seance6;
}
if(strlen($seance7) !=0 && $seance7 != "unselect" && $seance7 != "creneau ouvert" && $seance7 != "creneau fermer")
{ $tab_client_courte[] = $seance7;
}
if(strlen($seance8) !=0 && $seance8 != "unselect" && $seance8 != "creneau ouvert" && $seance8 != "creneau fermer")
{ $tab_client_courte[] = $seance8;
}
//echo '<pre>';
//print_r($datas);
}
//echo "20min";
//echo '<br>';
//echo '<pre>';
//print_r($tab_client_courte);
//print_r(array_count_values($tab_client_courte));
$tab_courte = array_count_values($tab_client_courte);
}
//"+++++++++++++++ LONGUE +++++++++++++++++++++++";
$sql = "SELECT * FROM " .$table ." WHERE mois ='$mois' and formule = 'longue' and mode ='actif' ";
mysqli_query($connexion, "SET NAMES 'utf8'");
$result = mysqli_query($connexion, $sql );
if(!$result)
{ die('Impossible d\'exécuter la requête :' . mysql_error());
}
$tab_client_longue = array();
while ($datas = mysqli_fetch_assoc ($result))
{
$seance1 = $datas['seance1'];
$seance2 = $datas['seance2'];
$seance3 = $datas['seance3'];
$seance4 = $datas['seance4'];
$seance5 = $datas['seance5'];
$seance6 = $datas['seance6'];
$seance7 = $datas['seance7'];
$seance8 = $datas['seance8'];
if(strlen($seance1) !=0 && $seance1 != "unselect" && $seance1 != "creneau ouvert" && $seance1 != "creneau fermer")
{ $tab_client_longue[] = $seance1;
}
if(strlen($seance2) !=0 && $seance2 != "unselect" && $seance2 != "creneau ouvert" && $seance2 != "creneau fermer")
{ $tab_client_longue[] = $seance2;
}
if(strlen($seance3) !=0 && $seance3 != "unselect" && $seance3 != "creneau ouvert" && $seance3 != "creneau fermer")
{ $tab_client_longue[] = $seance3;
}
if(strlen($seance4) !=0 && $seance4 != "unselect" && $seance4 != "creneau ouvert" && $seance4 != "creneau fermer")
{ $tab_client_longue[] = $seance4;
}
if(strlen($seance5) !=0 && $seance5 != "unselect" && $seance5 != "creneau ouvert" && $seance5 != "creneau fermer")
{ $tab_client_longue[] = $seance5;
}
if(strlen($seance6) !=0 && $seance6 != "unselect" && $seance6 != "creneau ouvert" && $seance6 != "creneau fermer")
{ $tab_client_longue[] = $seance6;
}
if(strlen($seance7) !=0 && $seance7 != "unselect" && $seance7 != "creneau ouvert" && $seance7 != "creneau fermer")
{ $tab_client_longue[] = $seance7;
}
if(strlen($seance8) !=0 && $seance8 != "unselect" && $seance8 != "creneau ouvert" && $seance8 != "creneau fermer")
{ $tab_client_longue[] = $seance8;
}
//echo '<pre>';
//print_r($datas);
}
//echo "30min";
//echo '<br>';
//echo '<pre>';
//print_r($tab_client_longue);
//print_r(array_count_values($tab_client_longue));
$tab_longue = array_count_values($tab_client_longue);
//echo "********************";
//echo '<pre>';
//print_r($tab_courte);
//echo '<pre>';
//print_r($tab_longue);
*/
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<style>
.titre {
margin-left:50px;
margin-top:50px;
font-size: 26px;
}
}
</style>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Espace réservation</title>
<link rel="stylesheet" href="menu_style.css" type="text/css">
<div id='cssmenu'>
<ul>
<li><a href='home.php'><span>Home</span></a></li>
<li><a href='selection_planning_mois.php'><span>Planning</span></a></li>
<li><a href='selection_gestion_mois.php'><span>Gestion</span></a></li>
<li class='active'><a href='selection_statistique_mois.php'><span>Statistiques</span></a></li>
<?php
if($_SESSION['nom'] == "admin")
{
echo '<li><a href="deplacer_un_rendezvous_admin.php"><span>Déplacer</span></a></li>';
echo '<li><a href="configuration.php"><span>Configuration</span></a></li>';
}
else
{
echo '<li><a href="deplacer_un_rendezvous_user.php"><span>Déplacer</span></a></li>';
}
?>
<li><a href='change_password.php'><span>Changer password</span></a></li>
<li><a href='logout.php'><span>Déconnexion</span></a></li>
<li><a href='#'><span><?php echo $_SESSION['nom'] .' ' .$_SESSION['prenom'] .' connecté' ?></span></a></li>
<li><a href='#'><span><?php echo $_SESSION['year']; ?></span></a></li>
</ul>
</div>
<br>
<br>
<br>
</head>
<?php
//$mois = 2;
$mois = $_GET['mois'];
//$annee = date('Y'); //maintenant on peut choisir l'année
//$table = "reservation" .$annee;
//$table = $_SESSION['table_reservation'];
$table = $_SESSION['table_reservation'] = "reservation" .$_SESSION['year'] ."_v3";
// echo $table;
if(!(mysqli_query($connexion, "SELECT * FROM $table")))
{
//$str = 'Arnold a dit : "I\'ll be back"';
echo "<div class ='titre' id ='titre'>";
$str = " La database " .$_SESSION['year'] ." n'existe pas encore !";
die($str);
echo "</div>";
}
//+++++++++++++++ COURTE +++++++++++++++++++++++";
$sql = "SELECT * FROM " .$table ." WHERE mois ='$mois' and formule = 'courte' and mode ='actif' ";
mysqli_query($connexion, "SET NAMES 'utf8'");
$result = mysqli_query($connexion, $sql );
if(!$result)
{ die('Impossible d\'exécuter la requête :' . mysql_error());
}
$n = mysqli_num_rows($result);
$tab_client_courte = array();
if($n != 0)
{
while ($datas = mysqli_fetch_assoc ($result))
{
$seance1 = $datas['seance1'];
$seance2 = $datas['seance2'];
$seance3 = $datas['seance3'];
$seance4 = $datas['seance4'];
$seance5 = $datas['seance5'];
$seance6 = $datas['seance6'];
$seance7 = $datas['seance7'];
$seance8 = $datas['seance8'];
if(strlen($seance1) !=0 && $seance1 != "unselect" && $seance1 != "creneau ouvert" && $seance1 != "creneau fermer")
{ $tab_client_courte[] = $seance1;
}
if(strlen($seance2) !=0 && $seance2 != "unselect" && $seance2 != "creneau ouvert" && $seance2 != "creneau fermer")
{ $tab_client_courte[] = $seance2;
}
if(strlen($seance3) !=0 && $seance3 != "unselect" && $seance3 != "creneau ouvert" && $seance3 != "creneau fermer")
{ $tab_client_courte[] = $seance3;
}
if(strlen($seance4) !=0 && $seance4 != "unselect" && $seance4 != "creneau ouvert" && $seance4 != "creneau fermer")
{ $tab_client_courte[] = $seance4;
}
if(strlen($seance5) !=0 && $seance5 != "unselect" && $seance5 != "creneau ouvert" && $seance5 != "creneau fermer")
{ $tab_client_courte[] = $seance5;
}
if(strlen($seance6) !=0 && $seance6 != "unselect" && $seance6 != "creneau ouvert" && $seance6 != "creneau fermer")
{ $tab_client_courte[] = $seance6;
}
if(strlen($seance7) !=0 && $seance7 != "unselect" && $seance7 != "creneau ouvert" && $seance7 != "creneau fermer")
{ $tab_client_courte[] = $seance7;
}
if(strlen($seance8) !=0 && $seance8 != "unselect" && $seance8 != "creneau ouvert" && $seance8 != "creneau fermer")
{ $tab_client_courte[] = $seance8;
}
//echo '<pre>';
//print_r($datas);
}
//echo "20min";
//echo '<br>';
//echo '<pre>';
//print_r($tab_client_courte);
//print_r(array_count_values($tab_client_courte));
$tab_courte = array_count_values($tab_client_courte);
}
//"+++++++++++++++ LONGUE +++++++++++++++++++++++";
$sql = "SELECT * FROM " .$table ." WHERE mois ='$mois' and formule = 'longue' and mode ='actif' ";
mysqli_query($connexion, "SET NAMES 'utf8'");
$result = mysqli_query($connexion, $sql );
if(!$result)
{ die('Impossible d\'exécuter la requête :' . mysql_error());
}
$tab_client_longue = array();
while ($datas = mysqli_fetch_assoc ($result))
{
$seance1 = $datas['seance1'];
$seance2 = $datas['seance2'];
$seance3 = $datas['seance3'];
$seance4 = $datas['seance4'];
$seance5 = $datas['seance5'];
$seance6 = $datas['seance6'];
$seance7 = $datas['seance7'];
$seance8 = $datas['seance8'];
if(strlen($seance1) !=0 && $seance1 != "unselect" && $seance1 != "creneau ouvert" && $seance1 != "creneau fermer")
{ $tab_client_longue[] = $seance1;
}
if(strlen($seance2) !=0 && $seance2 != "unselect" && $seance2 != "creneau ouvert" && $seance2 != "creneau fermer")
{ $tab_client_longue[] = $seance2;
}
if(strlen($seance3) !=0 && $seance3 != "unselect" && $seance3 != "creneau ouvert" && $seance3 != "creneau fermer")
{ $tab_client_longue[] = $seance3;
}
if(strlen($seance4) !=0 && $seance4 != "unselect" && $seance4 != "creneau ouvert" && $seance4 != "creneau fermer")
{ $tab_client_longue[] = $seance4;
}
if(strlen($seance5) !=0 && $seance5 != "unselect" && $seance5 != "creneau ouvert" && $seance5 != "creneau fermer")
{ $tab_client_longue[] = $seance5;
}
if(strlen($seance6) !=0 && $seance6 != "unselect" && $seance6 != "creneau ouvert" && $seance6 != "creneau fermer")
{ $tab_client_longue[] = $seance6;
}
if(strlen($seance7) !=0 && $seance7 != "unselect" && $seance7 != "creneau ouvert" && $seance7 != "creneau fermer")
{ $tab_client_longue[] = $seance7;
}
if(strlen($seance8) !=0 && $seance8 != "unselect" && $seance8 != "creneau ouvert" && $seance8 != "creneau fermer")
{ $tab_client_longue[] = $seance8;
}
//echo '<pre>';
//print_r($datas);
}
//echo "30min";
//echo '<br>';
//echo '<pre>';
//print_r($tab_client_longue);
//print_r(array_count_values($tab_client_longue));
$tab_longue = array_count_values($tab_client_longue);
//echo "********************";
//echo '<pre>';
//print_r($tab_courte);
//echo '<pre>';
//print_r($tab_longue);
/***********************/
$annee = $_SESSION['year'];
$nbre_enregistrements = count($tab_client_courte) + count($tab_client_longue);
if($nbre_enregistrements != 0)
{
$sql = 'SELECT * FROM client';
mysqli_query($connexion, "SET NAMES 'utf8'");
$result = mysqli_query($connexion, $sql );
$tab_nom = array();
$tab_prenom = array();
$tab_clients = array();
$ptr = 0;
while ($data = mysqli_fetch_assoc ($result))
{
if(strlen($data['prenom']) != 0)
{
$tab_nom[$ptr] = $data['nom'];
$tab_prenom[$ptr] = $data['prenom'];
$ptr = $ptr + 1;
}
}
for( $i=0; $i < count($tab_nom) ; $i++)
{
$tab_clients[$i] = $tab_nom[$i] . " " .$tab_prenom[$i];
}
//echo '<pre>';
//print_r($tab_clients);
$shop = array( array("rose", 1.25 , 15),
array("daisy", 0.75 , 25),
array("orchid", 1.15 , 7)
);
$store_statistiques = array();
$cpt = 0;
for( $i=0; $i < count($tab_nom) ; $i++)
{
// les 2 existes
if(array_key_exists($tab_clients[$i] , $tab_courte) && array_key_exists($tab_clients[$i] , $tab_longue) )
{
//echo $tab_clients[$i] ."-". $tab_courte[$tab_clients[$i]] ."-". $tab_longue[$tab_clients[$i]];
//echo "<br>";
$store_statistiques[$cpt] = $tab_clients[$i] ."-". $tab_courte[$tab_clients[$i]] ."-". $tab_longue[$tab_clients[$i]];
$cpt = $cpt + 1;
}
// seulement court
if(array_key_exists($tab_clients[$i] , $tab_courte) && !array_key_exists($tab_clients[$i] , $tab_longue) )
{
//echo $tab_clients[$i] ."-". $tab_courte[$tab_clients[$i]] ."-0";
//echo "<br>";
$store_statistiques[$cpt] = $tab_clients[$i] ."-". $tab_courte[$tab_clients[$i]] ."-0";
$cpt = $cpt + 1;
}
// seulement long
if( !array_key_exists($tab_clients[$i] , $tab_courte) && array_key_exists($tab_clients[$i] , $tab_longue) )
{
//echo $tab_clients[$i] ."-0". $tab_longue[$tab_clients[$i]];
//echo "<br>";
$store_statistiques[$cpt] = $tab_clients[$i] ."-0-". $tab_longue[$tab_clients[$i]];
$cpt = $cpt + 1;
}
}
/// et içi
//echo '<pre>';
//print_r($store_statistiques);
// bug si on a aucunes reservation de 20 min
/* [0] => CANNENTERRE_CONSEIL Stéphanie-1-1
[1] => CLEMENS Julien-2-0
[2] => DELPY Patrice-03 // manque le tiret
[3] => KBAIER Anissa-1-0
[4] => LE_MEN Bérangère-2-0
[5] => ORGE Laurence-1-0
[6] => WEISS Aurore-2-0
*/
echo ucfirst($mois) ." " .$annee;
echo '<br><br>';
?>
<body>
<div id="list">
<table align="left" bgcolor="#d5d5d5" border="0" cellpadding="5" cellspacing="1" width="100%">
<tbody>
<tr bgcolor="#f1f3f5">
<th class="center" width="1%">Id</th>
<th align="center" width="5%">Utilisateur</th>
<th align="center" width="5%">30Min</th>
<th align="center" width="3%">Subventionné</th>
<th align="center" width="3%">Personnel</th>
<th align="center" width="5%">20Min</th>
<th align="center" width="3%">Subventionné</th>
<th align="center" width="3%">Personnel</th>
<th align="center" width="3%">Somme</th>
</tr>
<?php
$tarif_CE_20min = $_SESSION['tarifCE']; // 5
$tarif_plein_20min = $_SESSION['tarifnormal']; // 10.0;
$tarif_CE_30min = $_SESSION['tarif30']; // 20.0;
$tarif_plein_30min = $_SESSION['tarif30']; //20.0;
//$_SESSION['tarifCE']
//$_SESSION['tarifnormal']
//$_SESSION['tarif30']
$cpt_courte = 0;
$cpt_longue = 0;
$benefice = 0;
$cpt_longue_subvention = 0;
$cpt_courte_subvention = 0;
$cpt_longue_perso = 0;
$cpt_courte_perso = 0;
for( $i=0; $i < count($store_statistiques) ; $i++)
{
echo '<tr>';
$indice = $i + 1;
echo '<td align="center">' .$indice .'</td>';
$store_statistiques[$i];
$pieces = explode("-", $store_statistiques[$i]);
$courte = $pieces[1];
$longue = $pieces[2];
$cpt_courte = $cpt_courte + $courte;
$cpt_longue = $cpt_longue + $longue;
echo '<td align="center">' .$pieces[0] .'</td>'; // client
echo '<td align="center">' .$longue .'</td>'; // nombre de sceance de 30min
if($longue == 0 )
{
echo '<td align="center">0</td>'; // Subvention
echo '<td align="center">0</td>'; // Personnel
$total_longue = 0;
}
if($longue != 0 )
{
echo '<td align="center">1</td>'; // Subvention
$perso_longue = $longue - 1;
$total_longue = $perso_longue * $tarif_plein_30min + $tarif_CE_30min;
echo '<td align="center">' .$perso_longue .'</td>'; // Personnel
$cpt_longue_perso = $cpt_longue_perso + $perso_longue;
$cpt_longue_subvention = $cpt_longue_subvention + 1;
}
echo '<td align="center">' .$courte .'</td>'; // nombre de sceance de 30min
if($courte == 0 )
{
echo '<td align="center">0</td>'; // Subvention
echo '<td align="center">0</td>'; // Personnel
$total_courte = 0;
}
if($courte != 0 )
{
echo '<td align="center">1</td>'; // Subvention
$perso_courte = $courte - 1;
$total_courte = $perso_courte * $tarif_plein_20min + $tarif_CE_20min ;
echo '<td align="center">' .$perso_courte .'</td>'; // Personnel
$cpt_courte_perso = $cpt_courte_perso + $perso_courte;
$cpt_courte_subvention = $cpt_courte_subvention + 1;
}
//$euro = "€";
//$total_somme = $total_longue + $total_courte + $euro; // " &euro";
$total_somme = $total_longue + $total_courte ;
$benefice = $benefice + $total_somme;
echo '<td align="center">' .$total_somme .'</td>'; // Somme
}
//echo '<tr>';
echo '<tr bgcolor="#f1f3f5">';
echo '<td align="center"></td>';
echo '<td align="center">' . count($store_statistiques) . " clients" .'</td>'; // Somme
echo '<td align="center">' .$cpt_longue .'</td>'; // Somme
echo '<td align="center">' .$cpt_longue_subvention .'</td>'; // cpt_longue_subvention
echo '<td align="center">' .$cpt_longue_perso .'</td>'; // cpt_longue_subvention
echo '<td align="center">' .$cpt_courte .'</td>'; // Somme
echo '<td align="center">' .$cpt_courte_subvention .'</td>'; // cpt_longue_subvention
echo '<td align="center">' .$cpt_courte_perso .'</td>'; // cpt_longue_subvention
echo '<td align="center">' .$benefice .'</td>'; // Somme
// echo '<td align="center">' .$total_courte .' euros' .'</td>';
?>
<!--
</tr> -->
</tbody>
</table>
</div>
<?php
}
else { echo "Aucunes entrées en " .ucfirst($mois) ;
echo '<br><br>';
}
?>
</body>
</html>