/** * Remove the specified resource from storage. * * * @return \Illuminate\Http\Response */ public function recipe_list() { if (\Input::has('searchRecipes')) { $mode = \Input::get('searchRecipes'); $term = \Input::get('searchQuery'); if (!empty($mode)) { switch ($mode) { case 1: $recipes = \App\Recipe::where('name', 'Like', '%' . $term . '%')->with('ingredients')->get(); break; case 2: $recipes = \App\Recipe::whereHas('ingredients', function ($q) use($term) { $q->where('name', 'like', '%' . $term . '%'); })->with('ingredients')->get(); break; case 3: $recipes = \App\Recipe::where('cooking_time', '<=', $term)->with('ingredients')->get(); break; } } } else { $recipes = \App\Recipe::take(3)->with('ingredients')->get(); } return $recipes->toJson(); }
public function getIndex(Request $request) { // Get all the books "owned" by the current logged in users // Sort in descending order by id $recipes = \App\Recipe::where('user_id', '=', \Auth::id())->orderBy('id', 'DESC')->get(); return view('recipes.index')->with('recipes', $recipes); }
public function search(Request $request) { $name = $request->input('name'); if (!$name) { return response("Please specify a search field", 400); } $results = Recipe::where('name', 'ILIKE', '%' . $name . '%')->get(); return $results; }
/** * Run the database seeds. * * @return void */ public function run() { $recipes = ['Vegetable Samosa' => ['dryFruits', 'vegetables', 'spices', 'oil', 'paneer'], 'Thandai' => ['milk', 'cream', 'dryFruits'], 'Paneer Masala' => ['milk', 'cream', 'dryFruits', 'paneer'], 'Daal Makhni' => ['cream', 'spices'], 'Faluda Malai Kulfi' => ['dryFruits', 'milk', 'cream'], 'Boondi Raita' => ['yogurt', 'vegetables', 'dryFruits'], 'Garlic Naan' => ['flour', 'yogurt', 'oil']]; foreach ($recipes as $recipe_name => $specifics) { $recipe = \App\Recipe::where('recipe_name', 'like', $recipe_name)->first(); foreach ($specifics as $specificName) { $specific = \App\Specific::where('name', 'LIKE', $specificName)->first(); $recipe->specifics()->save($specific); } } }
/** * Run the database seeds. * * @return void */ public function run() { $recipes = ['baked potatoes with wild mushroom ragù' => ['potatoTest'], 'Buttermilk, Cornmeal Pancakes with Corn Salsa' => ['cornTest'], 'Thai Basil Eggplant' => ['eggplantTest']]; foreach ($recipes as $title => $ingredients) { $recipe = \App\Recipe::where('title', 'like', $title)->first(); foreach ($ingredients as $ingredient) { $ingredientName = \App\Ingredient::where('name', 'LIKE', $ingredient)->first(); $recipe->ingredients()->save($ingredientName); } } }
public function postDelete(Request $request, $id) { $recipe = Recipe::where('id', $id)->first(); if ($recipe != null) { $recipe->delete(); $msg = "Рецепт \"" . $recipe->name . "\" удален."; return redirect('admin/recipe')->with('msg', $msg); } else { $msg = "Рецепта с id = " . $id . " не существует."; return redirect('admin/recipe')->with('msg', $msg); } }
/** * Apply a photo to the referenced recipe. * * @param integer $id * @param Request $request */ public function addPhoto($id, Request $request) { // validate the request object // and compare this against the photo // and only allow these mime types $this->validate($request, ['photo' => 'required|mimes:jpg,jpeg,png,bmp']); // grab the uploaded file instance $file = $request->file('photo'); // set up a defualt name $name = time() . $file->getClientOriginalName(); // move the file to new location, pass in variable for name $file->move('recipes/photos', $name); // find the current recipe $recipe = Recipe::where('id', '=', $id)->first(); // link current recipe to photo // and create a new photo (where the directory path is this) $recipe->photos()->create(['path' => "/recipes/photos/{$name}"]); }
public function search(Request $request) { $token = $request->get('token'); $recipes = Recipe::where('name', 'LIKE', '%' . $token . '%')->orWhere('category', 'LIKE', '%' . $token . '%')->orWhere('recipe', 'LIKE', '%' . $token . '%')->orWhere('author', 'LIKE', '%' . $token . '%')->orderBy('category')->orderBy('name')->paginate(env('RECIPE_PAGINATION_MAX')); return view('recipes.index')->with('recipes', $recipes); }
public function browseMyRecipes() { $recipes = \App\Recipe::where('user_id', '=', \Auth::id())->orderBy('title')->get(); return view('show')->with('recipes', $recipes); }
public function search(Request $request) { //validate user input. $rules = ['search' => 'min:3|required']; $messages = ['search.min' => 'Devi inserire almeno 3 caratteri da cercare!', 'search.required' => 'Devi inserire almeno 3 caratteri da cercare!']; $validator = Validator::make($request->all(), $rules, $messages); $errors = $validator->errors(); if ($validator->fails()) { return redirect()->route('recipes')->withErrors($errors); } //queries $recipesMatches = \App\Recipe::where('title', 'like', '%' . $request->search . '%')->orWhere('procedure', 'like', '%' . $request->search . '%')->get(); $usersMatches = \App\User::where('name', 'like', '%' . $request->search . '%')->orWhere('email', 'like', '%' . $request->search . '%')->get(); $ingredientsMatches = \App\Ingredient::where('name', 'like', '%' . $request->search . '%')->get(); $searchInput = $request->search; //highlight what we have found! foreach ($ingredientsMatches as $ingredient) { if (stripos($ingredient->name, $searchInput) !== false) { $ingredient->name = substr_replace($ingredient->name, '<b class="highlight">' . $searchInput . '</b>', stripos($ingredient->name, $searchInput), strlen($searchInput)); } } foreach ($recipesMatches as $recipe) { if (stripos($recipe->title, $searchInput) !== false) { $recipe->title = substr_replace($recipe->title, '<b class="highlight">' . $searchInput . '</b>', stripos($recipe->title, $searchInput), strlen($searchInput)); } if (stripos($recipe->procedure, $searchInput) !== false) { $recipe->procedure = substr_replace($recipe->procedure, '<b class="highlight">' . $searchInput . '</b>', stripos($recipe->procedure, $searchInput), strlen($searchInput)); } } foreach ($usersMatches as $user) { if (stripos($user->name, $searchInput) !== false) { $user->name = substr_replace($user->name, '<b class="highlight">' . $searchInput . '</b>', stripos($user->name, $searchInput), strlen($searchInput)); } if (stripos($user->email, $searchInput) !== false) { $user->email = substr_replace($user->email, '<b class="highlight">' . $searchInput . '</b>', stripos($user->email, $searchInput), strlen($searchInput)); } } return view('results', ['ingredientsMatches' => $ingredientsMatches, 'recipesMatches' => $recipesMatches, 'usersMatches' => $usersMatches, 'searchInput' => $request->search]); }
public function getDelete($id) { $beer = \App\Beer::find($id); $recipe = \App\Recipe::where('beer_id', $id)->get(); foreach ($recipe as $item) { $item->delete(); } $beer->delete(); \Session::flash('flash_message', $beer->name . ' was deleted.'); return redirect('/beer'); }
public function getRecipes(Request $request, $subcategory = null) { if ($subcategory == null) { if (null != $request->input('id')) { $recipe = Recipe::where('id', $request->input('id'))->first(); if ($recipe == null) { return redirect('recipes'); } return view('home.recipe')->with('recipe', $recipe); } $categories = Category::where('parent_id', null)->where('type', 1)->paginate(6); //->get(); return view('home.categories')->with(['categories' => $categories, 'pageTitle' => 'Рецепты']); } else { $parent = Category::where('table_name', $subcategory)->first(); if ($parent == null) { return redirect('recipes'); } if ($parent->final == 0) { $categories = Category::where('parent_id', $parent->id)->paginate(6); //->get(); return view('home.categories')->with(['categories' => $categories, 'pageTitle' => $parent->name]); } else { $recipes = Recipe::where('category_id', $parent->id)->paginate(6); //->get(); return view('home.recipes')->with(['recipes' => $recipes, 'pageTitle' => $parent->name]); } } }
public function postDelete(Request $request, $id) { $category = Category::find($id); if ($category != null) { if ($category->final == 1 && $category->type == 0) { Schema::drop($category->table_name); Product::where('category_id', $category->id)->delete(); } elseif ($category->final == 1 && $category->type == 1) { Recipe::where('category_id', $category->id)->delete(); } else { $sub_categories = Category::where('parent_id', $category->id)->get(); if (count($sub_categories) > 0) { $msg = "Нельзя удалить категорию \"" . $category->name . "\", так как она содержит другие подкатегории."; return redirect('admin/category?type=' . $category->type)->with('msg', $msg); } } $category->delete(); $msg = "Категория \"" . $category->name . "\" удалена."; return redirect('admin/category?type=' . $category->type)->with('msg', $msg); } else { $msg = "Категории с id = " . $id . " не существует."; return redirect('admin/category')->with('msg', $msg); } }