Changeset 6dec591

Timestamp:

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

Author:

bube-ristovska <ristovska725@…>

Branches:

main

Children:

d9c4096

Parents:

cf84baa

Message:

Cases listing

Files:

• app/Http/Controllers/CrimeCaseController.php (modified) (1 diff)
• app/Http/Controllers/SessionsController.php (modified) (2 diffs)
• resources/views/cases.blade.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(){

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('/');
         }

resources/views/cases.blade.php

@@ -153 +153 @@
                         </thead>
                         <tbody class="text-gray-700">
-                        <tr>
-                            <td class="text-left py-3 px-4"><a class="hover:text-blue-500" href="/namehere">Подморница</a></td>
-                            <td class="w-1/3 text-left py-3 px-4">2023-11-27</td>
-                            <td class="w-1/3 text-left py-3 px-4">A</td>
-                            <td class="w-1/3 text-left py-3 px-4">Кире Петков</td>
-                        </tr>
-                        <tr>
-                            <td class="text-left py-3 px-4"><a class="hover:text-blue-500" href="/namehere">Хакери</a></td>
-                            <td class="w-1/3 text-left py-3 px-4">2011-03-03</td>
-                            <td class="w-1/3 text-left py-3 px-4">Z</td>
-                            <td class="w-1/3 text-left py-3 px-4">Петко Кирев</td>
-                        </tr>
-                        <tr>
-                            <td class="text-left py-3 px-4"><a class="hover:text-blue-500" href="/namehere">Тероризам</a></td>
-                            <td class="w-1/3 text-left py-3 px-4">2016-02-01</td>
-                            <td class="w-1/3 text-left py-3 px-4">A</td>
-                            <td class="w-1/3 text-left py-3 px-4">Наташа Илиева</td>
-                        </tr>
-                        <tr>
-                            <td class="text-left py-3 px-4"><a class="hover:text-blue-500" href="/namehere">Киднапирање</a></td>
-                            <td class="w-1/3 text-left py-3 px-4">2022-08-27</td>
-                            <td class="w-1/3 text-left py-3 px-4">A</td>
-                            <td class="w-1/3 text-left py-3 px-4">Наташа Илиева</td>
-                        </tr>
+                        @foreach($cases as $case)
+                            <tr>
+                                <td class="text-left py-3 px-4"><a class="hover:text-blue-500" href="/case/{{$case->c_id}}">{{$case->c_name}}</a></td>
+                                <td class="w-1/3 text-left py-3 px-4">{{$case->opening_date}}</td>
+                                <td class="w-1/3 text-left py-3 px-4">{{$case->c_status}}</td>
+                                <td class="w-1/3 text-left py-3 px-4">{{$case->p_id}}</td>
+                            </tr>
+                        @endforeach
+
+
                         </tbody>
                     </table>