Changeset 7e9dadd for app/Http/Controllers/PeopleController.php

Timestamp:

02/12/24 14:17:23 (11 months ago)

Author:

bube-ristovska <ristovska725@…>

Branches:

main

Children:

2bd3041

Parents:

92df8cd

Message:

Finalized phase 5

File:

• app/Http/Controllers/PeopleController.php (modified) (1 diff)

app/Http/Controllers/PeopleController.php

@@ -23 +23 @@
             return view('login');
         }
+//        $credentials = request()->validate([
+//            'embg' => 'required'
+//        ]);
+//        $embg = $credentials['embg'];
+//
+//        $peoples = DB::select('SELECT * FROM people WHERE embg ~ :embg', ['embg' =>  '^' . $embg]);
+
         $credentials = request()->validate([
-            'embg' => 'required'
+            'embg' => 'nullable', // Assuming embg is not always required
+            'gender' => 'nullable',
+            'age' => 'nullable',
         ]);
-        $embg = $credentials['embg'];
+        $query = 'SELECT * FROM people WHERE true';
 
-        $peoples = DB::select('SELECT * FROM people WHERE embg ~ :embg', ['embg' =>  '^' . $embg]);
+        $embg = '^' . $credentials['embg'];
+        if ($credentials['embg']) {
+            $query .= " AND embg LIKE '{$credentials['embg']}%'";
+        }
 
-        return view('filter', [
-            'peoples' => $peoples
-        ]);
+        // Check if $credentials['gender'] is an array and handle accordingly
+        if (isset($credentials['gender']) && (is_array($credentials['gender']) && count($credentials['gender']) > 0)) {
+            $genderConditions = implode(" OR ", array_map(function ($gender) {
+                return "gender = '{$gender}'";
+            }, $credentials['gender']));
+
+            $query .= " AND ({$genderConditions})";
+        } elseif (isset($credentials['gender']) && !is_array($credentials['gender'])) {
+            $query .= " AND gender = '{$credentials['gender']}'";
+        }
+
+        // Check if $credentials['age'] is an array and handle accordingly
+        if (isset($credentials['age']) && is_array($credentials['age']) && count($credentials['age']) > 0) {
+            $ageConditions = [];
+
+            foreach ($credentials['age'] as $ageRange) {
+                // Extract minimum and maximum ages from the range
+                list($minAge, $maxAge) = explode('-', $ageRange);
+
+                // Add condition for the age range
+                $ageConditions[] = "EXTRACT(YEAR FROM AGE(current_date, date_of_birth)) BETWEEN {$minAge} AND {$maxAge}";
+            }
+
+            $query .= " AND (" . implode(" OR ", $ageConditions) . ")";
+        }
+        // Use a raw SQL query with the built conditions
+
+        $peoples = DB::select($query);
+        return view('filter', ['peoples' => $peoples]);
     }
     public function getPerson(Request $request)