Changeset 6dec591 for app

Timestamp:

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

Author:

bube-ristovska <ristovska725@…>

Branches:

main

Children:

d9c4096

Parents:

cf84baa

Message:

Cases listing

Location:

app/Http/Controllers

Files:

• CrimeCaseController.php (modified) (1 diff)
• SessionsController.php (modified) (2 diffs)

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(){

app/Http/Controllers/SessionsController.php

@@ -13 +13 @@
     public function store()
     {
-
         $credentials = request()->validate([
             'badge_no' => 'required',
@@ -42 +41 @@
             Session::put('badge_no', $badge_no);
             Session::put('is_policeman', $policeman);
+            Session::put('pe_id', $exists[0]->pe_id);
             return redirect()->intended('/');
         }