Changeset 69e9f5d for app

Timestamp:

08/26/24 12:43:09 (3 months ago)

Author:

bube-ristovska <ristovska725@…>

Branches:

main

Children:

092fcda

Parents:

768f473

Message:

Corrected authentication

File:

• app/Http/Controllers/SessionsController.php (modified) (4 diffs)

app/Http/Controllers/SessionsController.php

@@ -19 +19 @@
         $password = $credentials['password'];
         $badge_no = $credentials['badge_no'];
+        // mozhe da se najavi kako policaec i kako officer, znaeme koj e koj po znachkata
+
         $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]);
+        $is_policeman = DB::select('select * from policeman where badge_no = :badge_no;', ['badge_no' => $badge_no]);
+        $is_officer = DB::select('select * from officer where o_badge_no = :badge_no;', ['badge_no' => $badge_no]);
+        if($is_officer==null && $is_policeman==null) {
+            return back()->withErrors(['password' => 'Invalid credentials']);
+        }
+        if($is_officer!=null) {
+            $pass = DB::select('select o_password from officer where o_badge_no = :o_badge_no;', ['o_badge_no' => $badge_no]);
             $policeman = false;
-        }
-        if($exists == null) {
-            return back()->withErrors(['badge_no' => 'Invalid badge_no']);
+        } else {
+            $pass = DB::select('select p_password from policeman where badge_no = :badge_no;', ['badge_no' => $badge_no]);
         }
 
@@ -36 +39 @@
         }
 
-
         if ($value == $password) {
             // Authentication passed
@@ -42 +44 @@
             Session::put('is_policeman', $policeman);
             if($policeman){
-                Session::put('p_id', $exists[0]->p_id);
+                Session::put('pe_id', $is_policeman[0]->pe_id);
             } else {
-                Session::put('pe_id', $exists[0]->pe_id);
+                Session::put('pe_id', $is_officer[0]->pe_id);
             }
             return view('welcome');
@@ -56 +58 @@
     {
         Session::forget('badge_no');
+        Session::forget('p_id');
+        Session::forget('pe_id');
         Session::forget('is_policeman');
         return redirect('/login');