Changeset d9c4096 for app/Http/Controllers/CrimeCaseController.php

Timestamp:

02/10/24 17:58:54 (11 months ago)

Author:

bube-ristovska <ristovska725@…>

Branches:

main

Children:

92df8cd

Parents:

6dec591

Message:

Bug with embg

File:

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

app/Http/Controllers/CrimeCaseController.php

@@ -9 +9 @@
 {
     function cases(){
+        if(Session::get('pe_id') == null) {
+            return view('login');
+        }
 
-        $police_station= DB::select('select * from police_station where pe_id=:pe_id;',['pe_id'=> Session::get('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')]);
+        }
+
         $cases = DB::select('select * from crime_case where p_id=:p_id;',['p_id'=> $police_station[0]->p_id]);
 
+
         return view('cases', [
-            'cases' => $cases
+            'cases' => $cases,
+            'p_address'=>$police_station[0]->p_address
         ]);
 
     }
-    function case(){
-        return view('case');
+    function case($wildcard){
+        $case = DB::select('select * from crime_case where c_id=:c_id;',['c_id'=> $wildcard]);
+        $p_address = DB::select('select p_address from police_station where p_id=:p_id;',['p_id'=> $case[0]->p_id]);
+        $statements = DB::select('select * from statements where c_id=:c_id;',['c_id'=> $wildcard]);
+        $evidence = DB::select('select * from evidence_of_case where c_id=:c_id;',['c_id'=> $wildcard]);
+        return view('case', [
+            'case' => $case[0],
+            'p_address'=>$p_address[0]->p_address,
+            'statements'=>$statements,
+            'evidence'=>$evidence,
+        ]);
     }
 }