From a50ee00ba2cf690ceaff43c3b9ea816cc3ff477a Mon Sep 17 00:00:00 2001 From: horus Date: Sat, 11 May 2019 01:13:29 +0200 Subject: Adds landing page. (site) --- site/app/Http/Controllers/FKIndexController.php | 40 ++++++ site/resources/views/fk-index.blade.php | 164 ++++++++++++++++++++++++ site/routes/web.php | 1 + 3 files changed, 205 insertions(+) create mode 100644 site/app/Http/Controllers/FKIndexController.php create mode 100644 site/resources/views/fk-index.blade.php 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 @@ + 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') +
+
+
+ +
+ +
+
+
+

Finde jetzt den besten Deal!

+

+ Du suchst einen neuen Gin, Whisky oder Rum? We've got you covered.

Suche und finde jetzt dein Lieblingsdrink unter {{$hits->count }} verschiedenen Sonderangeboten. Täglich neue Schnäppchen im Bereich Spirituosen & Co.

+
+
+ +
+ + + + +
+

Keine Angebote

+ Momentan liegen keine Angebote vor. Probieren Sie es später noch einmal. +
+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) { +?> +
+spirit_type ) { + +?> +
+
+
+
+
+

+ + {{ ucfirst($offer->spirit_type) }} {{ $offer->name}} + +

+
+
+

{{ $offer->procent}} %

+
+ + + +
+
+
+

+ {{ ucfirst($offer->spirit_type) }} +

+
+
+ + +

Hier geht es zu {{ $offer->angebotsname }}

+

{{ $offer->linktext }}

+ + + +
+
+ +
+
+
+ + +
+ +
+ + + + + +@endsection + + +@section('scripts') + +@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'); -- cgit v1.2.3