<?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']); }