Changeset 249bf91 for app

Timestamp:

06/05/24 13:35:43 (5 months ago)

Author:

bube-ristovska <ristovska725@…>

Branches:

main

Children:

768f473

Parents:

f7acd52

Message:

New feature - details for employee

Location:

app/Http/Controllers

Files:

• CrimeCaseController.php (modified) (1 diff)
• OfficerController.php (modified) (1 diff)
• SessionsController.php (modified) (1 diff)

app/Http/Controllers/CrimeCaseController.php

@@ -28 +28 @@
         ]);
 
+    }
+    function register_statement(){
+        return view('register-statement');
+    }
+    function register_statement_post()
+    {
+       //TODO: so kiki i bojan vodete se po logikata na add policeman
+    }
+    function finished_cases(){
+
+        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')]);
+        }
+
+        $cases = DB::select('select * from crime_case where p_id=:p_id and c_status=\'Z\';', ['p_id' => $police_station[0]->p_id]);
+
+        return view('archive', [
+            'cases' => $cases,
+            'p_address'=>$police_station[0]->p_address
+        ]);
     }
     function case($wildcard){

app/Http/Controllers/OfficerController.php

@@ -31 +31 @@
     }
 
+    function show($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')]);
+        }
+        $result = DB::select('select * from policeman join people on policeman.pe_id = people.pe_id where p_id=:p_id and people.pe_id=:pe_id;',['p_id'=>  $police_station[0]->p_id, 'pe_id' => $id]);
+        $cases = DB::select('select * from statements where pe_id=:pe_id;',['pe_id' => $id]);
+
+        return view('employee', [
+            'employee' => $result[0],
+            'p_address'=>$police_station[0]->p_address,
+            'cases' => $cases
+        ]);
+    }
+
     function register()
     {

app/Http/Controllers/SessionsController.php

@@ -42 +42 @@
             Session::put('is_policeman', $policeman);
             if($policeman){
-                Session::put('p_id', $exists[0]->p_id);
+                Session::put('pe_id', $exists[0]->p_id);
             } else {
                 Session::put('pe_id', $exists[0]->pe_id);