$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();
}
