<?php

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'];
        // mozhe da se najavi kako policaec i kako officer, znaeme koj e koj po znachkata

        $policeman = true;
        $is_policeman = DB::select('select * from policeman where badge_no = :badge_no;', ['badge_no' => $badge_no]);
        $is_officer = DB::select('select * from officer where o_badge_no = :badge_no;', ['badge_no' => $badge_no]);
        if($is_officer==null && $is_policeman==null) {
            return back()->withErrors(['password' => 'Invalid credentials']);
        }
        if($is_officer!=null) {
            $pass = DB::select('select o_password from officer where o_badge_no = :o_badge_no;', ['o_badge_no' => $badge_no]);
            $policeman = false;
        } else {
            $pass = DB::select('select p_password from policeman where badge_no = :badge_no;', ['badge_no' => $badge_no]);
        }

        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);
            if($policeman){
                Session::put('pe_id', $is_policeman[0]->pe_id);
                Session::put('p_id', $is_policeman[0]->p_id);
            } else {
                Session::put('pe_id', $is_officer[0]->pe_id);
            }
            return view('welcome');
        }

        // Authentication failed
        return back()->withErrors(['password' => 'Invalid credentials']);
    }

    public function logout()
    {
        Session::forget('badge_no');
        Session::forget('p_id');
        Session::forget('pe_id');
        Session::forget('is_policeman');
        return redirect('/login');
    }
}