<?php                                                                                                                                                                                                                
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Helpers\CryptoHelper;

use Illuminate\Support\Facades\DB;
use App\Http\Controllers\Controller;

class IndexController extends Controller {
    /**
     * Shows the index page.
     *
     * @return Response
     */
    public function showPage(Request $request) {
  

	    $views = array("whisky", "wodka", "gin", "rum", "misc");
	    $query = "";

	    foreach($views as $view) {
		if ($query != "") {
			$query .= " UNION ";
		} 
		# subquery to get procent, because cheap spirits don't look good
		$query .= "(SELECT name, image_url, spirit_type, spirit_type AS url, spirit_type AS angebotsname, original_price, discounted_price, (SELECT MAX(procent) FROM " . $view . "_view) as procent, '' AS linktext FROM ". $view ."_view WHERE original_price > 19.98 ORDER BY procent DESC LIMIT 1)";
	    }

	    $data = DB::select($query);

	    $count = DB::select("SELECT count(*) as count FROM all_view")[0];
		#$data = DB::table('whisky_view')->orderBy('procent', 'DESC')->limit(100)->simplePaginate(20);

        return view('index', ['data' => $data, 'views' => $views, 'hits' => $count]);
    }
}