Changeset 92df8cd for app

Timestamp:

02/11/24 18:29:24 (9 months ago)

Author:

bube-ristovska <ristovska725@…>

Branches:

main

Children:

7e9dadd

Parents:

d9c4096

Message:

Add policeman

Location:

app/Http/Controllers

Files:

• OfficerController.php (modified) (2 diffs)
• PeopleController.php (modified) (1 diff)

app/Http/Controllers/OfficerController.php

@@ -6 +6 @@
 use Illuminate\Contracts\Auth\Authenticatable;
 use Illuminate\Http\Request;
+use Illuminate\Support\Carbon;
 use Illuminate\Support\Facades\DB;
 use Illuminate\Support\Facades\Session;
@@ -26 +27 @@
         return view('register-policeman');
     }
+    function register_post()
+    {
+        $policeman = request()->validate([
+            'badge_no' => 'required',
+            'embg' => 'required',
+            'password' => 'required',
+            'rank'=>'required'
+        ]);
+
+        $pe_id = DB::select('select pe_id from people where embg = :embg;', ['embg' => $policeman["embg"]]);
+        DB::insert('INSERT INTO policeman (pe_id, badge_no, p_date_of_employment, rank, p_id, p_password) VALUES (?, ?, ?, ?, ?, ?)', [$pe_id[0]->pe_id, $policeman["badge_no"], Carbon::now()->format('Y-m-d'), $policeman["rank"], $policeSTATION,$policeman["password"]]);
+        return view('register-policeman');
+    }
 
 

app/Http/Controllers/PeopleController.php

@@ -34 +34 @@
         ]);
     }
-    function get_person($embg){
-        $person = DB::select('SELECT * FROM people WHERE embg=:embg', ['embg' => $embg]);
-        dd($person);
-        return view('register-policeman', [
-            'person' => $person[0]
-        ]);
+    public function getPerson(Request $request)
+    {
+        $embg = $request->input('embg');
+        $person = DB::select('SELECT * FROM people WHERE embg = :embg', ['embg' => $embg]);
+
+        return response()->json($person[0] ?? null);
     }
 }