Changeset cf84baa for app

Timestamp:

02/08/24 16:15:01 (11 months ago)

Author:

bube-ristovska <ristovska725@…>

Branches:

main

Children:

6dec591

Parents:

6b10b67

Message:

Added querries half done

Location:

app/Http/Controllers

Files:

• OfficerController.php (modified) (2 diffs)
• PeopleController.php (modified) (1 diff)
• SessionsController.php (modified) (1 diff)

app/Http/Controllers/OfficerController.php

@@ -4 +4 @@
 
 use App\Models\Policeman;
+use Illuminate\Contracts\Auth\Authenticatable;
 use Illuminate\Http\Request;
 use Illuminate\Support\Facades\DB;
@@ -21 +22 @@
         return view('register-policeman');
     }
+
+
 }

app/Http/Controllers/PeopleController.php

@@ -4 +4 @@
 
 use Illuminate\Http\Request;
+use Illuminate\Support\Facades\DB;
 
 class PeopleController extends Controller
 {
     function filter(){
-        return view('filter');
+        $peoples = DB::select('select * from people;');
+
+        return view('filter', [
+            'peoples' => $peoples
+        ]);
+    }
+    function filter_post(){
+        $credentials = request()->validate([
+            'embg' => 'required'
+        ]);
+        $embg = $credentials['embg'];
+
+        $peoples = DB::select('SELECT * FROM people WHERE embg ~ :embg', ['embg' =>  '^' . $embg]);
+
+        return view('filter', [
+            'peoples' => $peoples
+        ]);
     }
 }

app/Http/Controllers/SessionsController.php

@@ -3 +3 @@
 namespace App\Http\Controllers;
 
+use App\Models\Officer;
 use Illuminate\Http\Request;
+use Illuminate\Support\Facades\Auth;
+use Illuminate\Support\Facades\DB;
+use Illuminate\Support\Facades\Session;
 
 class SessionsController extends Controller
 {
-    //
+    public function store()
+    {
+
+        $credentials = request()->validate([
+            'badge_no' => 'required',
+            'password' => 'required'
+        ]);
+        $password = $credentials['password'];
+        $badge_no = $credentials['badge_no'];
+        $policeman = true;
+        $exists = DB::select('select * from policeman where badge_no = :badge_no;', ['badge_no' => $badge_no]);
+        $pass = DB::select('select p_password from policeman where badge_no = :badge_no;', ['badge_no' => $badge_no]);
+        if($exists == null) {
+            $exists = DB::select('select * from officer where o_badge_no = :badge_no;', ['badge_no' => $badge_no]);
+            $pass = DB::select('select o_password from officer where o_badge_no = :badge_no;', ['badge_no' => $badge_no]);
+            $policeman = false;
+        }
+        if($exists == null) {
+            return back()->withErrors(['badge_no' => 'Invalid credentials']);
+        }
+
+        foreach ($pass[0] as $key => $val) {
+            $value = $val;
+            break; // Break after the first key-value pair
+        }
+
+
+        if ($value == $password) {
+            // Authentication passed
+            Session::put('badge_no', $badge_no);
+            Session::put('is_policeman', $policeman);
+            return redirect()->intended('/');
+        }
+
+        // Authentication failed
+        return back()->withErrors(['password' => 'Invalid credentials']);
+    }
+
+    public function logout()
+    {
+        Session::forget('badge_no');
+        Session::forget('is_policeman');
+        return redirect('/login');
+    }
 }