Changeset 92df8cd for app/Http/Controllers/OfficerController.php

Timestamp:

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

Author:

bube-ristovska <ristovska725@…>

Branches:

main

Children:

7e9dadd

Parents:

d9c4096

Message:

Add policeman

File:

• app/Http/Controllers/OfficerController.php (modified) (2 diffs)

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