<?php
if (empty($_SESSION)) {
session_start();
}
if ($_SESSION) {
$requete = new requete();
$requete->requete_direct('SELECT r.id, r.nom, r.nomComplet, count(idPersonne) as "quantite" FROM (SELECT DISTINCT idPersonne, idRegime FROM v2__tper_reg) t INNER JOIN v2__regime r ON t.idRegime = r.id INNER JOIN v2__personne p ON t.idPersonne = p.id INNER JOIN v2__tournee t ON p.numTournee = t.id WHERE p.actif = true AND t.nom <> "PAS DE TOURNEE" GROUP BY idRegime');
$requete->executer_requete();
$liste = $requete->resultat;
unset($requete);
// var_dump($liste);
if ($liste) {
$nbRegime = count($liste);
$totalRegime = 0;
$retour['resultat'] = '<form action="#" method="post" id="impression" onsubmit="menu_visu(this); return false;"><table><thead><tr><th>Nom</th><th>Nom complet</th><th>Quantité</th></tr></thead><tbody>';
for ($i = 0; $i < $nbRegime; $i++) {
$regime = $liste[$i];
$retour['resultat'] .= '<tr><td>' . $regime['nom'] . '</td><td>' . $regime['nomComplet'] . '</td><td><input type="number" name="nombre[]" data-id="reg_' . $regime['id'] . '" id="nombre[]" value="' . $regime['quantite'] . '" /></td></tr>';
$totalRegime += $regime['quantite'];
}
$retour['resultat'] .= '<tr><th colspan="2">TOTAL</th><th>' . $totalRegime . '</th></tr></tbody></table><p><label for="menuSeul">Menu seulement</label><input type="checkbox" name="menuSeul" id="menuSeul" /></p><input type="submit" value="Imprimer" /></form>';
} else {
$retour['resultat'] = '<p class="erreur">Aucun régime n\'est déclaré.</p>';
}
echo $retour['resultat'];
}
if ($_SESSION) {
$id = is_numeric($_GET['id']) ? $_GET['id'] : 0;
$actif = false;
$corbeille = true;
/**************************/
$requete = new requete();
$requete->select(array('personne' => array('numTournee', 'numPerTou')), 'p');
$requete->where(array('p' => array('id' => $id)));
$requete->executer_requete();
$liste = $requete->resultat;
unset($requete);
$numTournee = $liste[0]['p.numTournee'];
$numPerTou = $liste[0]['p.numPerTou'];
/**************************/
$requete = new requete();
$requete->requete_direct('UPDATE v2__personne SET numPerTou = numPerTou-1 WHERE v2__personne.numTournee = ' . $numTournee . ' AND numPerTou > ' . $numPerTou);
// echo $requete->requete_complete();
$requete->executer_requete();
unset($requete);
/**************************/
$requete = new requete();
$requete->update('personne', array('actif' => $actif, 'corbeille' => $corbeille, 'numTournee' => 1, 'numPerTou' => -1));
$requete->where(array('personne' => array('id' => $id)));
// echo $requete->requete_complete();
$requete->executer_requete();
$erreur = array_merge($erreur, $requete->liste_erreurs);
unset($requete);
/**************************/
echo '<p>Le client a été supprimée.</p>';
include 'listerClients.php';
}
<?php
if (empty($_SESSION)) {
session_start();
}
if ($_SESSION) {
if (file_exists('../../../../fonctions/api.class.php')) {
require_once '../../../../fonctions/api.class.php';
$nombre = empty($_POST['nombre']) ? 5 : $_POST['nombre'];
$requete = new requete();
$requete->requete_direct('SELECT p.id AS "p.id", p.nom AS "p.nom", p.prenom AS "p.prenom", p.adresse AS "p.adresse", p.codePostal AS "p.codePostal", p.ville AS "p.ville", c.id as "c.id", c.lat AS "c.lat", c.lng AS "c.lng", c.formatted_address as "c.formatted_address" FROM v2__personne p LEFT JOIN v2__coordonnees c ON p.adresse = c.adresse AND p.codePostal = c.codePostal AND p.ville = c.ville LIMIT 0, ' . $nombre);
$requete->executer_requete();
$retour['resultat'] = $requete->resultat;
unset($requete);
// $retour['resultat'] = '[{"p.nom":"BECKER","p.prenom":"Yvette","p.adresse":"26 rue Abb\u00e9 Devaux","p.codePostal":"54140","p.ville":"Jarville-la-Malgrange","c.id":"7","c.lat":"48.6712774","c.lng":"6.2031164","c.formatted_address":"26 Rue Abb\u00e9 Devaux, 54140 Jarville-la-Malgrange, France"},{"p.nom":"ARDUINI","p.prenom":"Mme","p.adresse":"4 rue de la madine","p.codePostal":"54520","p.ville":"Laxou","c.id":"8","c.lat":"48.6992925","c.lng":"6.127093899999999","c.formatted_address":"4 Rue de la Madine, 54520 Laxou, France"},{"p.nom":"LAUMONT","p.prenom":"yvette","p.adresse":"15 allee de l\'aire","p.codePostal":"54520","p.ville":"laxou","c.id":"9","c.lat":"48.6967211","c.lng":"6.1241283","c.formatted_address":"15 All\u00e9e de l\'Aire, 54520 Laxou, France"}]';
} else {
$retour['resultat'] = 'erreur importation API';
}
echo json_encode($retour['resultat']);
// echo $retour['resultat'];
}
<?php
if (empty($_SESSION)) {
session_start();
}
$retour['erreur'] = 'Erreur lors de la sauvegarde de la base de données.';
if ($_SESSION) {
if (file_exists('../../../../fonctions/fonctions.php')) {
if (file_exists('../../../../fonctions/api.class.php')) {
if (file_exists('../../../../fonctions/connectBDD.php')) {
require_once '../../../../fonctions/fonctions.php';
require_once '../../../../fonctions/api.class.php';
require_once '../../../../fonctions/connectBDD.php';
$requete = new requete();
$requete->requete_direct('SHOW TABLES');
// echo $requete->requete_complete();
$requete->executer_requete();
$liste = $requete->resultat;
unset($requete);
$nbTables = count($liste);
$temps = date('Y-m-d_H-i-s');
// echo chemin_racine();
$repertoire = chemin_racine() . 'sav/base/' . $temps;
if (!file_exists($repertoire)) {
mkdir($repertoire, 0777, true);
}
for ($i = 0; $i < $nbTables; $i++) {
$table = $liste[$i]["Tables_in_" . $PARAM_nom_bd];
passthru(sprintf('c:/xampp/mysql/bin/mysqldump.exe --opt -h ' . $PARAM_hote . ' -u ' . $PARAM_utilisateur . ' --password='******' ' . $PARAM_nom_bd . ' ' . $table . ' > "' . $repertoire . '/' . $temps . '_' . $table . '.sql"'));
}
function addFolderToZip($dir, $zipArchive, $rep = '.')
$menu .= $menuMIDI['me.nom'] . '<br>' . $menuMIDI['mv.nom'] . '<br>' . $menuMIDI['ml.nom'] . '<br>' . $menuMIDI['mf.nom'] . '<br>' . $menuMIDI['md.nom'];
$menu .= '</td><td>';
$menu .= $menuMIDIremp['me.nom'] . '<br>' . $menuMIDIremp['mv.nom'] . '<br>' . $menuMIDIremp['ml.nom'] . '<br>' . $menuMIDIremp['mf.nom'] . '<br>' . $menuMIDIremp['md.nom'];
$menu .= '</td><td>';
$menu .= $menuSOIR['me.nom'] . '<br>' . $menuSOIR['mv.nom'] . '<br>' . $menuSOIR['ml.nom'] . '<br>' . $menuSOIR['mf.nom'] . '<br>' . $menuSOIR['md.nom'];
$menu .= '</td><td>';
$menu .= $menuSOIRremp['me.nom'] . '<br>' . $menuSOIRremp['mv.nom'] . '<br>' . $menuSOIRremp['ml.nom'] . '<br>' . $menuSOIRremp['mf.nom'] . '<br>' . $menuSOIRremp['md.nom'];
$menu .= '</td>';
$menu .= '</tr>';
}
$menu .= '</tbody></table><div class="page"> </div>';
$tabMenu[$liste['id']] = $menu;
}
/******/
$requete = new requete();
$requete->requete_direct('SELECT t.id as "t.id", t.nom as "t.nom", r.id as "r.id", r.nom as "r.nom", r.nomComplet as "r.nomComplet", count(idPersonne) as "quantite" FROM (SELECT DISTINCT idPersonne, idRegime FROM v2__tper_reg) t INNER JOIN v2__regime r ON t.idRegime = r.id INNER JOIN v2__personne p ON t.idPersonne = p.id INNER JOIN v2__tournee t ON p.numTournee = t.id WHERE t.nom <> "PAS DE TOURNEE" AND p.actif = true GROUP BY numTournee, idRegime');
$requete->executer_requete();
$liste = $requete->resultat;
$tournee = '';
for ($i = 0; $i < count($liste); $i++) {
// if (isset($tempRegime[$liste[$i]['r.id']]) && $liste[$i]['quantite'] != $tempRegime[$liste[$i]['r.id']]){
if (isset($tempRegime[$liste[$i]['r.id']]) && $menuSeul) {
$liste[$i]['quantite'] = $tempRegime[$liste[$i]['r.id']];
}
if ($tournee != $liste[$i]['t.id']) {
$tournee = $liste[$i]['t.id'];
$requete->requete_direct('SELECT DISTINCT CONCAT(p.nom," ",p.prenom) as "p.nom", r.nom as "r.nom" FROM v2__personne p INNER JOIN v2__tper_reg tr ON p.id = tr.idPersonne INNER JOIN v2__regime r ON tr.idRegime = r.id WHERE p.actif = true AND p.numTournee = ' . $tournee . ' ORDER BY p.numTournee, p.numPerTou');
$requete->order(array('p' => array('numTournee', 'numPerTou')));
$requete->executer_requete();
$listeRegime = $requete->resultat;
$nbListeRegime = count($listeRegime);
$requete->executer_requete();
$liste_repas = $requete->resultat;
// var_dump($liste_repas);
unset($requete);
foreach ($liste_repas as $table) {
$temp = $table['numPerTou'];
if (!empty($tableau_tournee[$temp])) {
$nbPains += $table['quantite'];
$tableau_tournee[$temp]['qtePain'] += $table['quantite'];
}
}
}
$tableau_tournee = array();
foreach ($tab_idCalendrier as $typeCalendrier) {
$requete = new requete();
$requete->requete_direct('SELECT p.numPerTou, p.potage FROM v2__personne p INNER JOIN v2__per_reg pr ON p.id = pr.idPersonne LEFT JOIN v2__per_boi pb ON p.id = pb.idPersonne AND pr.idCalendrier = pb.idCalendrier LEFT JOIN v2__per_rem pm ON p.id = pm.idPersonne AND pr.idCalendrier = pm.idCalendrier LEFT JOIN v2__per_sup ps ON p.id = ps.idPersonne AND pr.idCalendrier = ps.idCalendrier INNER JOIN v2__calendrier c ON c.id = pr.idCalendrier WHERE c.annee = "' . date("Y", $dateDeuxJours) . '" AND c.mois = "' . date("m", $dateDeuxJours) . '" AND c.jour = "' . date("d", $dateDeuxJours) . '" AND pr.idCalendrier = "' . $typeCalendrier . '" AND p.numTournee = "' . $tournee . '" AND p.corbeille = false ORDER BY p.numPerTou');
$requete->executer_requete();
$liste_repas = $requete->resultat;
unset($requete);
foreach ($liste_repas as $table) {
$temp = $table['numPerTou'];
if (empty($tableau_tournee[$temp])) {
$nbPotages += $table['potage'];
$tableau_tournee[$temp] = true;
}
}
}
}
$page_recapitulatifChef .= '<table class="tableau_Chef"><thead><tr><th>Nom</th><th>Nombre de personne</th></tr></thead><tbody><tr><th>Pain</th><td>' . $nbPains . '</td></tr><tr><th>Potage</th><td>' . $nbPotages . '</td></tr></tbody></table>';
/***********************/
// echo $page_recapitulatifChef;
$requete = new requete();
$requete->select(array('personne' => array('numTournee', 'numPerTou')), 'p');
$requete->where(array('p' => array('id' => $idPersonne)));
$requete->grand_tableau = false;
// echo $requete->requete_complete().'<br><br>';
$requete->executer_requete();
$liste = $requete->resultat;
unset($requete);
if ($liste) {
if ($ordre == 1) {
$futurNum = $liste['p.numPerTou'] - 1;
} elseif ($ordre == 2) {
$futurNum = $liste['p.numPerTou'] + 1;
}
$requete = new requete();
$requete->requete_direct('UPDATE v2__personne SET numPerTou = ' . $liste['p.numPerTou'] . ' WHERE v2__personne.numTournee = ' . $liste['p.numTournee'] . ' AND numPerTou = ' . $futurNum);
// echo $requete->requete_complete().'<br>';
$requete->executer_requete();
unset($requete);
$requete = new requete();
$requete->requete_direct('UPDATE v2__personne SET numPerTou = ' . $futurNum . ' WHERE v2__personne.id = ' . $idPersonne);
// echo $requete->requete_complete().'<br>';
$requete->executer_requete();
unset($requete);
$retour['resultat'] = true;
}
} else {
$retour['resultat'] = 'erreur importation API';
}
echo json_encode($retour['resultat']);
}
