$ingredients_sum = array(); $recettes = array(); // nombre de personnes par recette foreach ($T['recettes'] as $r) { $recettes[$r['id']] = $r['personnes']; } // cumul des ingredients foreach ($ingredients as $i) { convertir_personnes($i['mesure'], $recettes[$i['id_recette']], $PANIER[$i['id_recette']]); convertir_mesure($i['mesure'], $i['unite']); if (!isset($ingredients_sum[$i['id_ingredient']][$i['unite']])) { $ingredients_sum[$i['id_ingredient']][$i['unite']] = 0; } $ingredients_sum[$i['id_ingredient']][$i['unite']] += $i['mesure']; } $T['all_ingredients'] = get_ingredients(); $T['ingredients'] = $ingredients_sum; } else { $recettes = MySQL::query('SELECT id, dir, parent, titre, note, duree, personnes FROM ' . DB_PREF . 'recettes ORDER BY titre ASC'); // LIMIT 0,5'); $childs = array(); $T['recettes'] = array(); foreach ($recettes as $r) { // si a parent, dans les enfants, sinon, a la racine if ($r['parent']) { $childs[$r['id']] = $r; } else { $T['recettes'][$r['id']] = $r; } } foreach ($childs as $id => $r) {
$T['js_file'] = 'ingredients'; $T['jquery'] = true; // del si del ou suppression de toutes les personnes au moins if ($js && !empty($_GET['del']) && ($id = (int) $_GET['del'])) { if (MySQL::getRow('SELECT id FROM ' . DB_PREF . 'ingredients WHERE id = :1', $id)) { if ($used = MySQL::query('SELECT id FROM ' . DB_PREF . 'details WHERE id_ingredient = :1', $id)) { if (isset($_GET['force'])) { // array des trucs a suppr $todel = array(); foreach ($used as $u) { $todel[] = $u['id']; } MySQL::query('DELETE FROM ' . DB_PREF . 'details WHERE id IN (' . implode(',', $todel) . ')'); MySQL::query('DELETE FROM ' . DB_PREF . 'ingredients WHERE id = :1', $id); $T['js_out'] = 'ok'; } else { $T['js_out'] = 'used'; } } else { MySQL::query('DELETE FROM ' . DB_PREF . 'ingredients WHERE id = :1', $id); $T['js_out'] = 'ok'; } } else { $T['js_out'] = 'ko'; } } elseif ($js && !empty($_GET['add']) && !MySQL::getRow('SELECT id FROM ' . DB_PREF . 'ingredients WHERE nom = :1', $_GET['add'])) { MySQL::insertRow(DB_PREF . 'ingredients', array('nom' => $_GET['add'])); $T['js_out'] = MySQL::insertId(); } elseif (!$js) { $T['ingredients'] = get_ingredients(); }