<?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) ]);
    }
}