Changeset 7e9dadd for app/Http/Controllers/OfficerController.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/OfficerController.php (modified) (2 diffs)

app/Http/Controllers/OfficerController.php

@@ -17 +17 @@
             return view('login');
         }
-        $results = DB::select('select * from policeman join people on policeman.pe_id = people.pe_id;');
+        if(Session::get('is_policeman')){
+            $police_station = DB::select('select * from police_station where p_id=:p_id;',['p_id'=>  Session::get('p_id')]);
+        } else {
+            $police_station = DB::select('select * from police_station where pe_id=:pe_id;',['pe_id'=>  Session::get('pe_id')]);
+        }
+        $results = DB::select('select * from policeman join people on policeman.pe_id = people.pe_id where p_id=:p_id;',['p_id'=>  $police_station[0]->p_id]);
+//        $results = DB::select('select * from policeman join people on policeman.pe_id = people.pe_id;');
+
         return view('employees', [
-            'employees' => $results
+            'employees' => $results,
+            'p_address'=>$police_station[0]->p_address
         ]);
     }
@@ -36 +44 @@
         ]);
 
+
+        $police_station = DB::select('select * from police_station where pe_id=:pe_id;',['pe_id'=>  Session::get('pe_id')]);
+
         $pe_id = DB::select('select pe_id from people where embg = :embg;', ['embg' => $policeman["embg"]]);
-        DB::insert('INSERT INTO policeman (pe_id, badge_no, p_date_of_employment, rank, p_id, p_password) VALUES (?, ?, ?, ?, ?, ?)', [$pe_id[0]->pe_id, $policeman["badge_no"], Carbon::now()->format('Y-m-d'), $policeman["rank"], $policeSTATION,$policeman["password"]]);
-        return view('register-policeman');
+        DB::insert('INSERT INTO policeman (pe_id, badge_no, p_date_of_employment, rank, p_id, p_password) VALUES (?, ?, ?, ?, ?, ?)', [$pe_id[0]->pe_id, $policeman["badge_no"], Carbon::now()->format('Y-m-d'), $policeman["rank"], $police_station[0]->p_id,$policeman["password"]]);
+        return redirect()->back()->with('message',"Додадено");
     }