Changeset 2bd3041 for app

Timestamp:

02/16/24 12:49:16 (10 months ago)

Author:

bube-ristovska <ristovska725@…>

Branches:

main

Children:

5d9dd4e

Parents:

7e9dadd

Message:

Added involved people

File:

• app/Http/Controllers/CrimeCaseController.php (modified) (2 diffs)

app/Http/Controllers/CrimeCaseController.php

@@ -34 +34 @@
         $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]);
+        $victims=[];
+        $witness=[];
+        foreach ($statements as $st){
+            $victim=DB::select('select * from people where pe_id=:pe_id;',['pe_id'=> $st->victim_pe_id]);
+            $victims[] = $victim[0];
+        }
+        foreach ($statements as $st){
+            $witnes=DB::select('select * from people where pe_id=:pe_id;',['pe_id'=> $st->witness_pe_id]);
+            $witness[] = $witnes[0];
+        }
+
         return view('case', [
             'case' => $case[0],
@@ -39 +50 @@
             'statements'=>$statements,
             'evidence'=>$evidence,
+            'victims'=> $victims,
+            'witness'=> $witness
         ]);
+
     }
 }