Changeset f7acd52 for app/Http

Timestamp:

04/22/24 20:14:54 (7 months ago)

Author:

bube-ristovska <ristovska725@…>

Branches:

main

Children:

249bf91

Parents:

5d9dd4e

Message:

Initial changes in database

File:

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

app/Http/Controllers/CrimeCaseController.php

@@ -33 +33 @@
         $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]);
+
+
         $victims=[];
         $witness=[];
+        $evidence_id = [];
+        $evidence = [];
+        foreach ($statements as $statement) {
+            $evidence_id = DB::select('select * from mentions_evidence where s_id=:s_id;',['s_id'=> $statement->s_id]);
+            if (!empty($evidence_id)) { // Check if $evidence_id is not empty
+                $evidence_id[] = $evidence_id[0];
+            }
+        }
+         $evidence_id=collect($evidence_id)->unique();
+        foreach ($evidence_id as $e) {
+            $evidence = DB::select('select * from evidence where e_id=:e_id;',['e_id'=> $e->e_id]);
+            $evidence[] = $evidence[0];
+        }
         foreach ($statements as $st){
             $victim=DB::select('select * from people where pe_id=:pe_id;',['pe_id'=> $st->victim_pe_id]);