Shows total count of offers in index page. (website)

2 files changed, 5 insertions, 3 deletions

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>