Adds landing page. (site)

3 files changed, 205 insertions, 0 deletions

diff --git a/site/app/Http/Controllers/FKIndexController.php b/site/app/Http/Controllers/FKIndexController.php
new file mode 100644
index 0000000..92e6866
--- /dev/null
+++ b/site/app/Http/Controllers/FKIndexController.php
@@ -0,0 +1,40 @@
+<?php                                                                                                                                                                                                                
+namespace App\Http\Controllers;
+use Illuminate\Http\Request;
+use App\Helpers\CryptoHelper;
+
+use Illuminate\Support\Facades\DB;
+use App\Http\Controllers\Controller;
+
+class FKIndexController 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, (SELECT MAX(procent) FROM " . $view . "_view) as procent, '' AS linktext FROM ". $view ."_view WHERE original_price > 19.98 AND shop != \"Drankdozijn\" ORDER BY procent DESC LIMIT 1)";
+		$query .= "(SELECT name, image_url, spirit_type, spirit_type AS url, spirit_type AS angebotsname, (SELECT MAX(procent) FROM " . $view . "_view) as procent, '' AS linktext FROM ". $view ."_view WHERE original_price > 19.98 ORDER BY procent DESC LIMIT 1)";
+	    }
+		$query .= " UNION (SELECT 'Alle Angebote' as name, 'https://angebote.fuselkoenig.de/img/feed-icon-gray.jpg' as image_url, 'RSS-Feeds' as spirit_type, 'feeds' AS url, 'RSS-Feeds' AS angebotsname, (SELECT MAX(procent) FROM all_view) as procent, 'Zu den RSS-Feeds' AS linktext FROM all_view 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);
+
+	    #$views[] = "rss-feeds";
+
+        return view('fk-index', ['data' => $data, 'views' => $views, 'hits' => $count]);
+    }
+} 
diff --git a/site/resources/views/fk-index.blade.php b/site/resources/views/fk-index.blade.php
new file mode 100644
index 0000000..029f00b
--- /dev/null
+++ b/site/resources/views/fk-index.blade.php
@@ -0,0 +1,164 @@
+@extends('layouts.fk-base')
+
+@section('header')
+Angebote
+@endsection
+
+@section('content')
+<div class="container">
+<main class="site-main" id="main">
+	<div class="container">
+		<nav class="breadcrumbs" typeof="BreadcrumbList" vocab="https://schema.org/" aria-label="breadcrumb">
+		    <ol class="breadcrumb">
+			<!-- Breadcrumb NavXT 6.2.1 -->
+<li class="home breadcrumb-item"><span property="itemListElement" typeof="ListItem"><a property="item" typeof="WebPage" title="Gehe zur Startseite: Fuselkönig.de" href="https://www.fuselkoenig.de" class="home"><span property="name">Startseite</span></a><meta property="position" content="1"></span></li>
+<li class="archive taxonomy type current-item breadcrumb-item active" aria-current="page"><span property="itemListElement" typeof="ListItem"><span property="name">Angebote</span><meta property="position" content="2"></span></li>
+		    </ol>
+		</nav>
+	</div>
+
+<header class="page-header">
+	<div class="card taxonomy-card">
+		<div class="card-body">
+			<h1 class="card-title page-title">Finde jetzt den besten Deal!</h1>
+			<p class="lead my-3">
+			Du suchst einen neuen Gin, Whisky oder Rum? <em>We've got you covered.</em> <br><br>Suche und finde jetzt dein Lieblingsdrink unter {{$hits->count }} verschiedenen Sonderangeboten. Täglich neue Schnäppchen im Bereich Spirituosen & Co.</p>
+		</div>
+	</div>
+<!--
+-->
+</header><!-- .page-header -->
+<!--
+	<div class="col-md-12 px-0 mb-2">
+	<form action="/angebote/search">
+	  <div class="form-group">
+	    <label for=""></label>
+	    <input type="text" class="form-control" name="q" id="front_search_form" aria-describedby="suchform-help" placeholder="Hier nach der gewünschten Spirituose suchen...">
+	    <small id="front_search_help" class="form-text">Suche zum Beispiel nach Glenfiddich oder Champagner.</small>
+	  </div>
+	  <button type="submit" class="btn btn-secondary">Suchen</button>
+	</form>
+	</div>
+-->
+
+
+<?php 
+
+if ( empty($data) ) {
+	/* Keine Angebote */
+?>
+<div class="alert alert-error">
+	<h4 class="alert-heading">Keine Angebote</h4>
+	Momentan liegen keine Angebote vor. Probieren Sie es später noch einmal.
+</div>
+<?php 
+	/* Ende Keine Angebote */
+} else {
+	/* Liste Angebote */
+
+	$count = 0;
+
+	foreach( $data as $offer) {
+
+
+		if ($offer->spirit_type == "RSS-Feeds") {
+			#$offer->angebotsname = "dem " . $offer->angebotsname;
+		} else if ( !in_array(strtolower($offer->spirit_type), $views) ) {
+			$offer->url = "misc";
+			$offer->angebotsname = "weiteren Angeboten";
+			$offer->linktext = "Weitere günstige Angebote entdecken und bis zu " . $offer->procent . "% sparen.";
+			$offer->spirit_type = "Verschiedenes";
+		} else {
+			$offer->url = lcfirst($offer->url) ;
+			$offer->angebotsname = "den " . $offer->angebotsname . "-Angeboten";
+			$offer->linktext = "Finde den günstigsten ". $offer->spirit_type ." und spare bis zu " . $offer->procent . "%.";
+		}
+
+		if ( $count % 2 == 0) {
+?>
+ <div class="row mb-2">
+<?php
+		}
+		if ( "RSS-Feeds" != $offer->spirit_type ) {
+
+?>
+<div class="col-md-6 col-sm-12" id="{{ $offer->name }}">
+	<div class="card">
+      <div class="row ">
+        <div class="col-md-4">
+	    <div class="card-header-dp-none">
+		<p><strong>
+		<span style="visibility: hidden;">
+		{{ ucfirst($offer->spirit_type) }} <span class="float-right">{{ $offer->name}}</span>
+		</span>
+		</strong></p>
+	    </div>
+	    <div class="card-img-overlay card-img-overlay-badge" >
+	    <p class="card-text float-right rounded off-badge"  >{{ $offer->procent}} %</p>
+            </div>
+	<a href="/angebote/{{ $offer->url }}">
+	    <img src="{{ $offer->image_url }}" class="card-img img-fluid mx-auto d-block">
+	</a>
+          </div>
+          <div class="col-md-8 px-10">
+	    <div class="card-header">
+		<p><strong>
+		<a style="color: inherit;" href="/angebote/search?q={{ ucfirst($offer->spirit_type) }}" title="Alle {{ ucfirst($offer->spirit_type) }} anzeigen">{{ ucfirst($offer->spirit_type) }}</a>
+		</strong></p>
+	    </div>
+            <div class="card-block card-body px-3">
+
+			<a class="text-dark card-link" href="/angebote/{{ $offer->url }}">
+				<h3 class="card-title">Hier geht es zu {{ $offer->angebotsname }}</h3>
+				<p>{{ $offer->linktext }}</p>
+			</a>
+			<!--p class="card-text ">Bis zu <span class="bg-danger rounded off-badge off-badge-small">{{ $offer->procent}}%</span> sparen!</p-->
+
+            </div>
+          </div>
+
+        </div>
+      </div>
+</div>
+	
+<?php
+		}
+		if ( $count % 2 == 1) {
+?>
+ </div>
+<?php
+		}
+
+		$count++;
+
+}
+
+	// schließt den row div wieder bei ungerade anzahl
+	if ( $count % 2 == 1) {
+?>
+ </div>
+<?php
+	}
+}
+?>
+
+    </div>
+</main>
+    </div>
+@endsection
+
+
+@section('scripts')
+<script>
+$(".js-link-replacement").hover(function(){
+	$(this).css( 'cursor', 'pointer' );
+},
+function(){
+	$(this).css( 'cursor', 'inherit');
+});
+
+$(".js-link-replacement").click(function(){
+	window.location.href = $(this).data("href");
+});
+</script>
+@endsection
diff --git a/site/routes/web.php b/site/routes/web.php
index d61d32b..11d921d 100644
--- a/site/routes/web.php
+++ b/site/routes/web.php
@@ -20,6 +20,7 @@ Route::get('/rum', 'OfferController@showPage')->name('rum');
 Route::get('/misc', 'OfferController@showPage')->name('misc');
 Route::get('/all', 'OfferController@showPage')->name('all');
 
+Route::get('/angebote/', 'FKIndexController@showPage')->name('whisky');
 Route::get('/angebote/whisky', 'FKOfferController@showPage')->name('whisky');
 Route::get('/angebote/wodka', 'FKOfferController@showPage')->name('wodka');
 Route::get('/angebote/gin', 'FKOfferController@showPage')->name('gin');