public static function listDrinkIngredients($drink_id)
{
$query = DB::connection()->prepare('SELECT * FROM DrinkIngredient WHERE drink_id = :drink_id');
$query->execute(array($drink_id));
$rows = $query->fetchAll(PDO::FETCH_OBJ);
$ingredients = array();
foreach ($rows as $row) {
$ingredient = new DrinkIngredient();
$ingredient->setAmount($row->amount);
$ingredient->setUnit($row->unit);
$ingredient->setIngredient_id($row->ingredient_id);
$ingredient->setDrink_id($row->drink_id);
$ingredient->setIngredientName($row->ingredient_id);
$ingredients[] = $ingredient;
}
return $ingredients;
}
public static function editIngredients($ingredients, $id, $ingredient_ids, $amounts, $units)
{
$i = 0;
foreach ($ingredients as $ingredient) {
$ingredient = strtolower($ingredient);
if (Ingredient::alreadyInArchive($ingredient) > 0) {
$ingredient_id = Ingredient::alreadyInArchive($ingredient);
$old_ingredient_id = $ingredient_ids[$i];
$newDrinkIngredient = new DrinkIngredient();
$newDrinkIngredient->setIngredient_id($ingredient_id);
$newDrinkIngredient->setDrink_id($id);
$newDrinkIngredient->setAmount($amounts[$i]);
$newDrinkIngredient->setUnit($units[$i]);
$newDrinkIngredient->update($old_ingredient_id);
} else {
$newIngredient = new Ingredient();
$newIngredient->setIngredient_name($ingredient);
$ingredient_id = $newIngredient->save();
$old_ingredient_id = $ingredient_ids[$i];
$newDrinkIngredient = new DrinkIngredient();
$newDrinkIngredient->setIngredient_id($ingredient_id);
$newDrinkIngredient->setDrink_id($id);
$newDrinkIngredient->setAmount($amounts[$i]);
$newDrinkIngredient->setUnit($units[$i]);
$newDrinkIngredient->update($old_ingredient_id);
}
$i++;
}
}
