Prevents results with empty urls when the crawler had no time to short it. (website)

3 files changed, 3 insertions, 3 deletions

diff --git a/site/app/Http/Controllers/FeedController.php b/site/app/Http/Controllers/FeedController.php
index 3fac630..f8b3da6 100644
--- a/site/app/Http/Controllers/FeedController.php
+++ b/site/app/Http/Controllers/FeedController.php
@@ -61,7 +61,7 @@ class FeedController extends Controller {
 	    if ( "search" == $view_name ) {
 		$query = Input::get("q");
 		$q = "%" . Utility::escapeLike($query) . "%";
-	    	$data = DB::table('all_view')->where('name', 'like', $q)->orWhere('spirit_type', 'like', $q)->orderBy($sort_by, $order_by)->limit(20)->get();
+	    	$data = DB::table('all_view')->whereNotNull('url')->where('name', 'like', $q)->orWhere('spirit_type', 'like', $q)->orderBy($sort_by, $order_by)->limit(20)->get();
 	    } else {
 	    	$data = DB::table($view_name . '_view')->orderBy($sort_by, $order_by)->limit(20)->get();
 	    }
diff --git a/site/app/Http/Controllers/OfferController.php b/site/app/Http/Controllers/OfferController.php
index 7ffbd96..c05cd0e 100644
--- a/site/app/Http/Controllers/OfferController.php
+++ b/site/app/Http/Controllers/OfferController.php
@@ -57,7 +57,7 @@ class OfferController extends Controller {
 	     * Database query
 	     */
 	    $view_name = \Request::route()->getName();
-	    $data = DB::table($view_name . '_view')->orderBy($sort_by, $order_by)->simplePaginate(20);
+	    $data = DB::table($view_name . '_view')->whereNotNull('url')->orderBy($sort_by, $order_by)->simplePaginate(20);
 
 	    $rss_feed = "/" . $view_name . "/feed/";
 	    $query_string = "";
diff --git a/site/app/Http/Controllers/SearchController.php b/site/app/Http/Controllers/SearchController.php
index 2587d9b..a0ea2fc 100644
--- a/site/app/Http/Controllers/SearchController.php
+++ b/site/app/Http/Controllers/SearchController.php
@@ -56,7 +56,7 @@ class SearchController extends Controller {
 
 		$query = Input::get("q");
 		$q = "%" . Utility::escapeLike($query) . "%";
-	    	$data = DB::table('all_view')->where('name', 'like', $q)->orWhere('spirit_type', 'like', $q)->orderBy($sort_by, $order_by)->simplePaginate(20);
+	    	$data = DB::table('all_view')->whereNotNull('url')->where('name', 'like', $q)->orWhere('spirit_type', 'like', $q)->orderBy($sort_by, $order_by)->simplePaginate(20);
 		#$data = DB::table('whisky_view')->orderBy('procent', 'DESC')->limit(100)->simplePaginate(20);
 		#var_dump($data); exit;