Index: app/Http/Controllers/OfficerController.php =================================================================== --- app/Http/Controllers/OfficerController.php (revision 6b10b67af9fe7f741727510eaec46700644227be) +++ app/Http/Controllers/OfficerController.php (revision cf84baa56f694b471c891665131a4f1cabaa2e6f) @@ -4,4 +4,5 @@ use App\Models\Policeman; +use Illuminate\Contracts\Auth\Authenticatable; use Illuminate\Http\Request; use Illuminate\Support\Facades\DB; @@ -21,3 +22,5 @@ return view('register-policeman'); } + + } Index: app/Http/Controllers/PeopleController.php =================================================================== --- app/Http/Controllers/PeopleController.php (revision 6b10b67af9fe7f741727510eaec46700644227be) +++ app/Http/Controllers/PeopleController.php (revision cf84baa56f694b471c891665131a4f1cabaa2e6f) @@ -4,9 +4,26 @@ use Illuminate\Http\Request; +use Illuminate\Support\Facades\DB; class PeopleController extends Controller { function filter(){ - return view('filter'); + $peoples = DB::select('select * from people;'); + + return view('filter', [ + 'peoples' => $peoples + ]); + } + function filter_post(){ + $credentials = request()->validate([ + 'embg' => 'required' + ]); + $embg = $credentials['embg']; + + $peoples = DB::select('SELECT * FROM people WHERE embg ~ :embg', ['embg' => '^' . $embg]); + + return view('filter', [ + 'peoples' => $peoples + ]); } } Index: app/Http/Controllers/SessionsController.php =================================================================== --- app/Http/Controllers/SessionsController.php (revision 6b10b67af9fe7f741727510eaec46700644227be) +++ app/Http/Controllers/SessionsController.php (revision cf84baa56f694b471c891665131a4f1cabaa2e6f) @@ -3,8 +3,55 @@ namespace App\Http\Controllers; +use App\Models\Officer; use Illuminate\Http\Request; +use Illuminate\Support\Facades\Auth; +use Illuminate\Support\Facades\DB; +use Illuminate\Support\Facades\Session; class SessionsController extends Controller { - // + public function store() + { + + $credentials = request()->validate([ + 'badge_no' => 'required', + 'password' => 'required' + ]); + $password = $credentials['password']; + $badge_no = $credentials['badge_no']; + $policeman = true; + $exists = DB::select('select * from policeman where badge_no = :badge_no;', ['badge_no' => $badge_no]); + $pass = DB::select('select p_password from policeman where badge_no = :badge_no;', ['badge_no' => $badge_no]); + if($exists == null) { + $exists = DB::select('select * from officer where o_badge_no = :badge_no;', ['badge_no' => $badge_no]); + $pass = DB::select('select o_password from officer where o_badge_no = :badge_no;', ['badge_no' => $badge_no]); + $policeman = false; + } + if($exists == null) { + return back()->withErrors(['badge_no' => 'Invalid credentials']); + } + + foreach ($pass[0] as $key => $val) { + $value = $val; + break; // Break after the first key-value pair + } + + + if ($value == $password) { + // Authentication passed + Session::put('badge_no', $badge_no); + Session::put('is_policeman', $policeman); + return redirect()->intended('/'); + } + + // Authentication failed + return back()->withErrors(['password' => 'Invalid credentials']); + } + + public function logout() + { + Session::forget('badge_no'); + Session::forget('is_policeman'); + return redirect('/login'); + } } Index: resources/views/case.blade.php =================================================================== --- resources/views/case.blade.php (revision 6b10b67af9fe7f741727510eaec46700644227be) +++ resources/views/case.blade.php (revision cf84baa56f694b471c891665131a4f1cabaa2e6f) @@ -74,5 +74,5 @@ Профил Помош - Одјави се + Одјави се Index: resources/views/cases.blade.php =================================================================== --- resources/views/cases.blade.php (revision 6b10b67af9fe7f741727510eaec46700644227be) +++ resources/views/cases.blade.php (revision cf84baa56f694b471c891665131a4f1cabaa2e6f) @@ -74,5 +74,5 @@ Профил Помош - Одјави се + Одјави се Index: resources/views/employees.blade.php =================================================================== --- resources/views/employees.blade.php (revision 6b10b67af9fe7f741727510eaec46700644227be) +++ resources/views/employees.blade.php (revision cf84baa56f694b471c891665131a4f1cabaa2e6f) @@ -101,5 +101,5 @@ Профил Помош - Одјави се + Одјави се Index: resources/views/filter.blade.php =================================================================== --- resources/views/filter.blade.php (revision 6b10b67af9fe7f741727510eaec46700644227be) +++ resources/views/filter.blade.php (revision cf84baa56f694b471c891665131a4f1cabaa2e6f) @@ -154,5 +154,5 @@ Профил Помош - Одјави се + Одјави се @@ -216,6 +216,6 @@

Контролна табла

-
- + + @csrf
@@ -224,5 +224,7 @@
- + + +
@@ -269,10 +271,5 @@ -
-

- Граѓани -

- -
+
@@ -289,24 +286,17 @@ - - - - - - - - - - - - - - - - - - - - + + @foreach($peoples as $people) + + + + + + + + + + + @endforeach
1011001470303ЕмирАбазиМул.Македонија бр.80 ТетовоМакедонијаАлбанец622322662
0302954470303ВасилијаВасиљоскаЖул.154 бр.20 СкопјеМакедонијаМакедонка622322662
{{$people->embg}}{{$people->first_name}}{{$people->last_name}}{{$people->gender}}{{$people->address}}{{$people->country}}{{$people->nationality}}{{$people->contact}}
Index: resources/views/login.blade.php =================================================================== --- resources/views/login.blade.php (revision 6b10b67af9fe7f741727510eaec46700644227be) +++ resources/views/login.blade.php (revision cf84baa56f694b471c891665131a4f1cabaa2e6f) @@ -44,17 +44,25 @@ Најави се на твојот профил - + + @csrf
- - + +
+ @error('badge_no') +

{{$message}}

+ @enderror
+ @error('password') +

{{$message}}

+ @enderror +
- +
Index: resources/views/register-policeman.blade.php =================================================================== --- resources/views/register-policeman.blade.php (revision 6b10b67af9fe7f741727510eaec46700644227be) +++ resources/views/register-policeman.blade.php (revision cf84baa56f694b471c891665131a4f1cabaa2e6f) @@ -164,5 +164,5 @@ - +
Index: resources/views/welcome.blade.php =================================================================== --- resources/views/welcome.blade.php (revision 6b10b67af9fe7f741727510eaec46700644227be) +++ resources/views/welcome.blade.php (revision cf84baa56f694b471c891665131a4f1cabaa2e6f) @@ -29,5 +29,9 @@
Index: routes/web.php =================================================================== --- routes/web.php (revision 6b10b67af9fe7f741727510eaec46700644227be) +++ routes/web.php (revision cf84baa56f694b471c891665131a4f1cabaa2e6f) @@ -23,7 +23,11 @@ Route::get('/login', function () { return view('login'); + }); -Route::post('logout', [SessionsController::class, 'destroy'])->middleware('auth'); +Route::post('/login', [SessionsController::class, 'store']); + + +Route::get('logout', [SessionsController::class, 'logout']); @@ -31,4 +35,6 @@ Route::get('employees', [OfficerController::class, 'employees'])->middleware('guest'); Route::get('filter', [PeopleController::class, 'filter'])->middleware('guest'); +Route::post('filter', [PeopleController::class, 'filter_post'])->middleware('guest'); + Route::get('cases', [CrimeCaseController::class, 'cases'])->middleware('guest'); Route::get('case', [CrimeCaseController::class, 'case'])->middleware('guest');