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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
|
<?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");
if ( ! isset($ingredients) || empty($ingredients) ) {
$ingredients = array( $request->input("q") );
}
$excludes = $request->input("i_ex");
if ( ! isset($excludes) || empty($excludes) ) {
$excludes = array();
}
$cocktails = new Cocktail;
foreach($ingredients as $q) {
$q = Helper::escapeLike($q);
$q = "%".$q."%";
if ( ! isset($excludes) || empty($excludes) ) {
$cocktails = $cocktails->where(function($query) use ($q){
$query->whereHas("getIngredients", function ($query) use ($q){
$query->where('name', 'like', $q);
});
});
} else {
foreach($excludes as $ex) {
$ex = Helper::escapeLike($ex);
$ex = "%".$ex."%";
$cocktails = $cocktails->where(function($query) use ($q, $ex){
$query->whereHas("getIngredients", function ($query) use ($q){
$query->where('name', 'like', $q);
})->whereDoesntHave("getIngredients", function ($query) use ($ex){
$query->where('name', 'like', $ex);
});
});
}
}
}
$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 ");
$exclude_phrase = "";
if ( isset($excludes) ) {
foreach(array_filter($excludes) as $term) {
if ( $exclude_phrase != "" )
$exclude_phrase = $exclude_phrase . " und ";
$exclude_phrase = $exclude_phrase . ucwords($term);
}
$exclude_phrase = rtrim($exclude_phrase, " und ");
}
$search_phrase .= " und nicht nach " . $exclude_phrase;
return view('cocktail_list', [ "cocktails" => $cocktails, "count" => $count, "search_terms" => array_filter($ingredients), "search_phrase" => $search_phrase, "exclude_terms" => array_filter($excludes) ]);
}
}
|
