$temps = mktime(0, 0, 0, $dateMois, $dateJour, $dateAnnee); /*********************/ // SELECT COUNT( idMenu ) AS "NbMenu" FROM v2__menu_regime mr RIGHT JOIN v2__menu m ON mr.idMenu = m.id GROUP BY m.id $requete = new requete(); $requete->alias = true; $requete->select(array('menu' => array('id', 'supplement')), 'm'); $requete->select(array('menu_entree' => 'nom'), 'me'); $requete->select(array('menu_viande' => 'nom'), 'mv'); $requete->select(array('menu_legume' => 'nom'), 'ml'); $requete->select(array('menu_fromage' => 'nom'), 'mf'); $requete->select(array('menu_dessert' => 'nom'), 'md'); $requete->select(array('COUNT' => array('menu_regime' => 'idMenu')), 'mr'); $requete->join('menu_regime', 'menu', 'RIGHT'); // $requete->join($type, $type2, 'RIGHT'); $requete->group('m', 'id'); $requete->order('me.nom'); $requete->order('mv.nom'); $requete->order('ml.nom'); $requete->order('mf.nom'); $requete->order('md.nom'); $requete->order('m.supplement'); // echo $requete->requete_complete().'<br><br>'; $requete->executer_requete(); $liste = $requete->resultat; $erreur = array_merge($erreur, $requete->liste_erreurs); unset($requete); if ($liste) { $retour['resultat'] = '<p><a href="?menu=menu&sousmenu=ajouterMenu">Ajouter un nouveau menu</a></p><table><caption>Menus - ' . count($liste) . ' différents</caption><thead><tr><th>Nombre</th><th>Entree</th><th>Viande</th><th>Légume</th><th>Fromage</th><th>Dessert</th><th>Supplément</th><th colspan="2">Action</th></tr></thead><tbody>'; foreach ($liste as $membre) { $retour['resultat'] .= '<tr><td>' . $membre['COUNT(mr.idMenu)'] . '</td><td>' . $membre['me.nom'] . '</td><td>' . $membre['mv.nom'] . '</td><td>' . $membre['ml.nom'] . '</td><td>' . $membre['mf.nom'] . '</td><td>' . $membre['md.nom'] . '</td><td>' . $membre['m.supplement'] . '</td><td><a href="?menu=menu&sousmenu=modifierMenu&id=' . $membre['m.id'] . '">Modifier</a></td><td><a href="?menu=menu&sousmenu=supprimerMenu&id=' . $membre['m.id'] . '">Supprimer</a></td></tr>'; }
$requete_membre->insert('menu', array('idEntree' => $entree, 'idViande' => $viande, 'idLegume' => $legume, 'idFromage' => $fromage, 'idDessert' => $dessert, 'supplement' => $supplement)); // echo $requete_membre->requete_complete().'<br><br>'; $requete_membre->executer_requete(); $erreur = array_merge($erreur, $requete_membre->liste_erreurs); unset($requete_membre); echo '<p>Le menu a bien été créé.</p>'; } else { echo '<p>Un menu identique existe déjà.</p>'; } } else { echo '<form action="?' . $_SERVER['QUERY_STRING'] . '" method="post">'; $type = array('entree', 'viande', 'legume', 'fromage', 'dessert'); foreach ($type as $val) { $requete = new requete(); $requete->select('menu_' . $val, 'm'); $requete->order('nom'); // echo $requete->requete_complete().'<br><br>'; $requete->executer_requete(); $liste = $requete->resultat; unset($requete); $nombre = count($liste); if ($nombre > 0) { echo '<p><label for="' . $val . '">' . $val . ' :</label><select name="' . $val . '" id="' . $val . '">'; for ($i = 0; $i < $nombre; $i++) { echo '<option value="' . $liste[$i]['id'] . '">' . $liste[$i]['nom'] . '</option>'; } echo '</select></p>'; } else { echo '<p>Aucun(e) ' . $val . ' n\'est enregistré(e).</p>'; } }
} $timestampJour = mktime(0, 0, 0, $dateMois, $dateJour, $dateAnnee); /*********************/ if (file_exists('../../../../fonctions/api.class.php')) { include '../../../../fonctions/api.class.php'; } $connectBDD = file_exists('../../../../connectBDD.php') ? '../../../../connectBDD.php' : ''; $liste_personnes = array(); $requete_personnes = new requete(); $requete_personnes->select(array('personne' => array('id', 'nom', 'prenom')), 'p'); $requete_personnes->select(array('per_reg' => array('idRegime', 'quantite', 'quantiteRemp')), 'pr'); $requete_personnes->select(array('regime' => array('nom', 'couleur')), 'r'); $requete_personnes->select(array('tournee' => array('nom')), 't'); $requete_personnes->select(array('calendrier' => array('typeCalendrier')), 'c'); $requete_personnes->where(array('c' => array('annee' => $dateAnnee, 'mois' => $dateMois, 'jour' => $dateJour))); $requete_personnes->order(array('p' => 'numTournee')); $requete_personnes->order(array('p' => 'numPerTou')); // echo $requete_personnes->requete_complete().'<br>'; $requete_personnes->executer_requete(); $resultat = $requete_personnes->resultat; unset($requete_personnes); $liste_menu = array(); $liste_menu_regime = array(); $requete_menu = new requete(); $requete_menu->select(array('regime' => 'nom'), 'r'); $requete_menu->select(array('menu_regime' => 'idRegime'), 'mr'); $requete_menu->select(array('menu' => 'supplement'), 'm'); $requete_menu->select(array('calendrier' => 'typeCalendrier'), 'c'); $requete_menu->select(array('menu_entree' => 'nom'), 'me'); $requete_menu->select(array('menu_viande' => 'nom'), 'mv'); $requete_menu->select(array('menu_legume' => 'nom'), 'ml');
<?php if (empty($_SESSION)) { session_start(); } if ($_SESSION) { if (file_exists('../../../../fonctions/api.class.php')) { require_once '../../../../fonctions/api.class.php'; $idTournee = empty($_POST['idTournee']) ? 0 : $_POST['idTournee']; $requete = new requete(); $requete->select(array('personne' => array('id', 'numPerTou')), 'p'); $requete->where(array('p' => array('numTournee' => $idTournee, 'corbeille' => false))); $requete->order('p.numPerTou'); // echo $requete->requete_complete().'<br><br>'; $requete->executer_requete(); $liste = $requete->resultat; unset($requete); if ($liste) { $nbPersonnes = count($liste); $tab_final = array(); for ($i = 0; $i < $nbPersonnes; $i++) { $requete = new requete(); $requete->update('personne', array('numPerTou' => $i)); $requete->where(array('personne' => array('id' => $liste[$i]['p.id']))); // echo $requete->requete_complete().'<br>'; $requete->executer_requete(); unset($requete); } $retour['resultat'] = true; } } else {
} else { $dateJour++; } } $dateTimestamp = mktime(0, 0, 0, $dateMois, $dateJour, $dateAnnee); $typeCalendrier = array('MIDI', 'SOIR'); /*********************/ $liste_personnes = array(); foreach ($typeCalendrier as $type) { $requete_personnes = new requete(); $requete_personnes->select(array('personne' => array('id', 'nom', 'prenom')), 'p'); $requete_personnes->select(array('SUM' => array('per_reg' => 'quantite')), 'pr'); $requete_personnes->select(array('SUM' => array('per_reg' => 'quantiteRemp')), 'pr'); $requete_personnes->select(array('per_reg' => 'idRegime'), 'pr'); $requete_personnes->where(array('calendrier' => array('annee' => $dateAnnee, 'mois' => $dateMois, 'typeCalendrier' => $type))); $requete_personnes->order(array('p' => 'nom')); $requete_personnes->group('p', 'id'); // echo $requete_personnes->requete_complete().'<br>'; $requete_personnes->executer_requete(); $resultat = $requete_personnes->resultat; foreach ($resultat as $temp) { $liste_personnes[$temp['p.nom'] . ' ' . $temp['p.prenom']][$type] = $temp['SUM(pr.quantite)'] + $temp['SUM(pr.quantiteRemp)']; } } if ($liste_personnes) { echo '<table><thead><tr><th>Nom</th><th>Nombre de repas MIDI</th><th>Nombre de repas SOIR</th></tr></thead><tbody>'; foreach ($liste_personnes as $a => $b) { echo '<tr><td>' . $a . '</td><td>' . (isset($b['MIDI']) ? $b['MIDI'] : 0) . '</td><td>' . (isset($b['SOIR']) ? $b['SOIR'] : 0) . '</td></tr>'; } echo '</tbody></table>'; } else {
} /******/ $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); $tabTemp = array(); for ($k = 0; $k < $nbListeRegime; $k++) { $per = $listeRegime[$k]['p.nom']; $reg = $listeRegime[$k]['r.nom']; if (isset($tabTemp[$per])) { $tabTemp[$per] .= ', ' . $reg; } else { $tabTemp[$per] = $reg; } } if (!$menuSeul) { $retour['resultat'] .= '<h1>' . $liste[$i]['t.nom'] . '</h1><table><thead><tr><th>Nom de la personne</th><th>Régime</th></tr><thead><tbody>';