From dd89c6608b213bfa72f5c1cb77d33f805b2b3bfa Mon Sep 17 00:00:00 2001
From: horus
Date: Tue, 20 Feb 2018 17:46:16 +0100
Subject: Shows total count of offers in index page. (website)

---
 site/app/Http/Controllers/IndexController.php | 4 +++-
 site/resources/views/index.blade.php          | 4 ++--
 2 files changed, 5 insertions(+), 3 deletions(-)

(limited to 'site')

diff --git a/site/app/Http/Controllers/IndexController.php b/site/app/Http/Controllers/IndexController.php
index 7b5ced4..b82d2cd 100644
--- a/site/app/Http/Controllers/IndexController.php
+++ b/site/app/Http/Controllers/IndexController.php
@@ -27,8 +27,10 @@ class IndexController extends Controller {
 	    }
 
 	    $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]);
+        return view('index', ['data' => $data, 'views' => $views, 'hits' => $count]);
     }
 } 
diff --git a/site/resources/views/index.blade.php b/site/resources/views/index.blade.php
index 729d62b..578c667 100644
--- a/site/resources/views/index.blade.php
+++ b/site/resources/views/index.blade.php
@@ -7,9 +7,9 @@ Angebote
 @section('content')
     <div class="container">
       <div class="jumbotron p-3 p-md-5 text-white rounded bg-dark">
-        <div class="col-md-6 px-0">
+        <div class="col-md-7 px-0">
           <h1 class="display-4 font-italic">Sonderangebote</h1>
-          <p class="lead my-3">Finde immer die günstigsten Angebote im Bereich Spirituosen. Regelmäßig neue Schnäppchen.</p>
+          <p class="lead my-3">Finde immer die günstigsten Angebote im Bereich Spirituosen. Regelmäßig neue Schnäppchen. ({{$hits->count}} Angebote)</p>
           <!--p class="lead mb-0"><a href="/about" class="text-white font-weight-bold">Erfahre mehr...</a></p-->
         </div>
       </div>
-- 
cgit v1.2.3