blob: 21655d2b88ab342fcea64366c97fcb2feecbdf2e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Cache;
use App\Cocktail;
use App\Ingredient;
use App\Libraries\Helper;
class CocktailController extends Controller
{
public function index()
{
if ( Cache::has('cocktail_count') ) {
$cocktail_count= Cache::get('cocktail_count');
} else {
$cocktails = new Cocktail;
$cocktail_count = $cocktails->count();
Cache::put('cocktail_count', $cocktail_count, 6000); // 100 minutes
}
return view('cocktail_index', [ "cocktail_count" => $cocktail_count ]);
}
public function search(Request $request) {
$ingredients = $request->input("i");
$cocktails = new Cocktail;
foreach($ingredients as $q) {
$q = Helper::escapeLike($q);
$q = "%".$q."%";
$cocktails = $cocktails->where(function($query) use ($q){
$query->whereHas("getIngredients", function ($query) use ($q){
$query->where('name', 'like', $q);
});
});
}
$count = $cocktails->count();
$search_phrase = "";
foreach(array_filter($ingredients) as $term) {
if ( $search_phrase != "" )
$search_phrase = $search_phrase . " und ";
$search_phrase = $search_phrase . ucwords($term);
}
$search_phrase = rtrim($search_phrase, " und ");
return view('cocktail_list', [ "cocktails" => $cocktails, "count" => $count, "search_terms" => array_filter($ingredients), "search_phrase" => $search_phrase ]);
}
}
|
