Changeset 6dec591 for app/Http/Controllers/CrimeCaseController.php

Timestamp:

02/08/24 16:34:49 (9 months ago)

Author:

bube-ristovska <ristovska725@…>

Branches:

main

Children:

d9c4096

Parents:

cf84baa

Message:

Cases listing

File:

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

app/Http/Controllers/CrimeCaseController.php

@@ -4 +4 @@
 
 use Illuminate\Http\Request;
-
+use Illuminate\Support\Facades\DB;
+use Illuminate\Support\Facades\Session;
 class CrimeCaseController extends Controller
 {
     function cases(){
-        return view('cases');
+
+        $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
+        ]);
+
     }
     function case(){