From 5c1ad67d5e254881fddf4eda5b1ba21cccaae859 Mon Sep 17 00:00:00 2001
From: Louis Jeckel <louis.jeckel@outlook.cm>
Date: Thu, 17 Sep 2020 16:26:43 +0200
Subject: [PATCH] filter by orga

---
 app/Nova/Filters/FilterByOrganization.php | 45 +++++++++++++++++++++++
 app/Nova/User.php                         |  5 ++-
 2 files changed, 49 insertions(+), 1 deletion(-)
 create mode 100644 app/Nova/Filters/FilterByOrganization.php

diff --git a/app/Nova/Filters/FilterByOrganization.php b/app/Nova/Filters/FilterByOrganization.php
new file mode 100644
index 0000000..a79b785
--- /dev/null
+++ b/app/Nova/Filters/FilterByOrganization.php
@@ -0,0 +1,45 @@
+<?php
+
+namespace App\Nova\Filters;
+
+use App\Organization;
+use Illuminate\Http\Request;
+use Laravel\Nova\Filters\Filter;
+
+class FilterByOrganization extends Filter
+{
+    /**
+     * The filter's component.
+     *
+     * @var string
+     */
+    public $component = 'select-filter';
+
+    /**
+     * Apply the filter to the given query.
+     *
+     * @param  \Illuminate\Http\Request  $request
+     * @param  \Illuminate\Database\Eloquent\Builder  $query
+     * @param  mixed  $value
+     * @return \Illuminate\Database\Eloquent\Builder
+     */
+    public function apply(Request $request, $query, $value)
+    {
+        return $query->where('organization_id', $value);
+    }
+
+    /**
+     * Get the filter's available options.
+     *
+     * @param  \Illuminate\Http\Request  $request
+     * @return array
+     */
+    public function options(Request $request)
+    {
+        return Organization::query()
+            ->whereHas('members')
+            ->orderBy('name')
+            ->pluck('id', 'name')
+            ->toArray();
+    }
+}
diff --git a/app/Nova/User.php b/app/Nova/User.php
index 61e7715..fc7c934 100644
--- a/app/Nova/User.php
+++ b/app/Nova/User.php
@@ -7,6 +7,7 @@ use App\Nova\Actions\SendNotification;
 use App\Nova\Actions\StartTrial;
 use App\Nova\Actions\ValidateAddress;
 use App\Nova\Actions\VerifyEmail;
+use App\Nova\Filters\FilterByOrganization;
 use App\Nova\Lenses\FailedMailgun;
 use App\Nova\Lenses\MailgunStatus;
 use App\Nova\Lenses\NonDeliverableAddresses;
@@ -146,7 +147,9 @@ class User extends Resource
      */
     public function filters(Request $request)
     {
-        return [];
+        return [
+            new FilterByOrganization
+        ];
     }
 
     /**
-- 
2.39.5