From 6bec7d2a80040fc872e9ae7a2783a103428a036f Mon Sep 17 00:00:00 2001
From: Louis Jeckel <louis.jeckel@outlook.cm>
Date: Mon, 31 Aug 2020 16:10:33 +0200
Subject: [PATCH] filter by activation status

---
 app/Nova/Filters/ActivatedAccounts.php | 42 ++++++++++++++++++++++++++
 app/Nova/Subscriber.php                |  9 ++++++
 2 files changed, 51 insertions(+)
 create mode 100644 app/Nova/Filters/ActivatedAccounts.php

diff --git a/app/Nova/Filters/ActivatedAccounts.php b/app/Nova/Filters/ActivatedAccounts.php
new file mode 100644
index 0000000..85c21bd
--- /dev/null
+++ b/app/Nova/Filters/ActivatedAccounts.php
@@ -0,0 +1,42 @@
+<?php
+
+namespace App\Nova\Filters;
+
+use Illuminate\Http\Request;
+use Laravel\Nova\Filters\BooleanFilter;
+
+class ActivatedAccounts extends BooleanFilter
+{
+    /**
+     * 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)
+    {
+        if($value['reg_complete']) {
+            $query->where('reg_complete', 1);
+        }
+        if($value['not_reg_complete']) {
+            $query->where('reg_complete', 0);
+        }
+        return $query;
+    }
+
+    /**
+     * Get the filter's available options.
+     *
+     * @param  \Illuminate\Http\Request  $request
+     * @return array
+     */
+    public function options(Request $request)
+    {
+        return [
+            'Comptes activés' => 'reg_complete',
+            'Comptes non activés' => 'not_reg_complete'
+        ];
+    }
+}
diff --git a/app/Nova/Subscriber.php b/app/Nova/Subscriber.php
index db301a8..3901448 100644
--- a/app/Nova/Subscriber.php
+++ b/app/Nova/Subscriber.php
@@ -4,6 +4,8 @@
 namespace App\Nova;
 
 
+use App\Nova\Filters\ActivatedAccounts;
+use Illuminate\Http\Request;
 use Laravel\Nova\Http\Requests\NovaRequest;
 
 class Subscriber extends User
@@ -27,4 +29,11 @@ class Subscriber extends User
         return $query->where('type', 0);
     }
 
+    public function filters(Request $request)
+    {
+        return array_merge(parent::filters($request), [
+           new ActivatedAccounts,
+        ]);
+    }
+
 }
-- 
2.39.5