Changeset 6b10b67 for app

Timestamp:

01/29/24 13:15:08 (10 months ago)

Author:

bube-ristovska <ristovska725@…>

Branches:

main

Children:

cf84baa

Parents:

75151c6

Message:

Connected database

Location:

app

Files:

• Http/Controllers/CrimeCaseController.php (modified) (1 diff)
• Http/Controllers/OfficerController.php (modified) (2 diffs)
• Models/Accused.php (added)
• Models/AccusedFor.php (added)
• Models/CaseBelongsToTypeOfCrime.php (added)
• Models/CrimeCase.php (added)
• Models/EvidenceOfCase.php (added)
• Models/Officer.php (added)
• Models/PoliceStation.php (added)
• Models/Policeman.php (added)
• Models/SolvedCase.php (added)
• Models/Statement.php (added)
• Models/TypeOfCrime.php (added)
• Models/User.php (deleted)
• Models/Victim.php (added)
• Models/Witness.php (added)

app/Http/Controllers/CrimeCaseController.php

@@ -10 +10 @@
         return view('cases');
     }
+    function case(){
+        return view('case');
+    }
 }

app/Http/Controllers/OfficerController.php

@@ -3 +3 @@
 namespace App\Http\Controllers;
 
+use App\Models\Policeman;
 use Illuminate\Http\Request;
+use Illuminate\Support\Facades\DB;
 
 class OfficerController extends Controller
@@ -9 +11 @@
     function employees()
     {
-        return view('employees');
+        $results = DB::select('select * from policeman join people on policeman.pe_id = people.pe_id;');
+        return view('employees', [
+            'employees' => $results
+        ]);
+    }
+
+    function register()
+    {
+        return view('register-policeman');
     }
 }