<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use App\Models\normaluser;
use App\Models\settings;
use Illuminate\Support\Facades\Session;
use App\Mail\vendor\verifyUser;
use Illuminate\Support\Facades\Mail;


class loginController extends Controller
{
    public function loginIndex(Request $request)
    {
        if (Session::get('type') == "1") {
            return redirect()->route('home');
        }


        return view('login');
    }
    public function signup(Request $request)
    {
        return view('signup');
    }
    public function signupSuccess(Request $request)
    {
        $websiteID = Session::get('website_id');

        $request->validate([
            'username' => 'required|string|min:3|max:25|unique:normalusers,normalUser_name',
            'email' => 'required|email|max:255|unique:normalusers,normalUser_email',
            'password' => 'required|string|min:8|confirmed',
            'password_confirmation' => 'required|string|min:8',
            'phone_number' => 'required|string|min:10|max:15|regex:/^\+?[0-9]*$/'

        ]);

        $username = $request->input('username');
        $email = $request->input('email');
        $password = $request->input('password');
        $phone_number = $request->input('phone_number');
        $code = rand(100000, 999999);

        $addQuery = normaluser::create([
            'normalUser_name' => $username,
            'normalUser_email' => $email,
            'normalUser_password' => $password,
            'normalUser_phone' => $phone_number,
            'normalUser_type' => "1",
            'normalUser_verifyCode' => $code,
            'normalUser_approve' => 0,
            'normalUser_vendor_id' => $websiteID,
        ]);

        // Vendor Settings
        $settings = settings::where(['settings_vendor_id' => $websiteID])->get();
        // Vendor Settings


        $sendEmail = Mail::to($email)->send(new verifyUser($username, $email,Session::get('website_name'), $code, $settings));

        $userid = normaluser::where(['normalUser_email' => $email, 'normalUser_vendor_id' => $websiteID])->get('normalUser_id')->value('normalUser_id');

        if ($request->hasFile('normalUser_Photo')) {
            // Get the new vendor_photo
            $normalUser_Photo = $request->file('normalUser_Photo');

                // Store the new image
                $imageName = time() . '.' . $normalUser_Photo->extension();

                $normalUser_Photo->move(('images/normalUsersPhotos'), $imageName);


                // Update the product's normalUser_Photo path
                $updatePhoto = normaluser::where(['normalUser_id' => $userid, 'normalUser_vendor_id' => $websiteID])->update([
                    'normalUser_Photo' => "images/normalUsersPhotos/$imageName",
                ]);
            
        }


        if ($addQuery && $sendEmail) {
            return view('auth.verifyCode')->with(['success' => 'تم تحديث بيانات الحساب بنجاح', 'id' => $userid]);
        } else {
            return redirect()->back()->with(['fail' => 'تم تحديث بيانات الحساب بنجاح']);
        }
    }
    public function OTPcodeChecker(Request $request)
    {
        $websiteID = Session::get('website_id');

        $id = $request->id;
        $number1 = $request->input('number1');
        $number2 = $request->input('number2');
        $number3 = $request->input('number3');
        $number4 = $request->input('number4');
        $number5 = $request->input('number5');
        $number6 = $request->input('number6');

        $code = $number1 . $number2 . $number3 . $number4 . $number5 . $number6;

        $user = normaluser::where('normalUser_id', $id)->get();

        // Vendor Settings
        $settings = settings::where(['settings_vendor_id' => $websiteID])->get();
        // Vendor Settings


        if ($user[0]->normalUser_verifyCode == $code) {

            $updateState = normaluser::where(['normalUser_id' => $user[0]->normalUser_id])->update([
                'normalUser_approve' => "1",
            ]);
            Session::flash('signUpApproved', 'تم إنشاء الحساب نجاح');

            return redirect()->route('home');
        } else {

            $code = rand(100000, 999999);

            $updateState = normaluser::where(['normalUser_id' => $user[0]->normalUser_id])->update([
                'normalUser_verifyCode' => $code,
            ]);
            Session::flash('signUpFailed', 'لم يتم تأكيد الحساب');

            $sendEmail = Mail::to($user[0]->normalUser_email)->send(new verifyUser($user[0]->normalUser_name, $user[0]->normalUser_email,Session::get('website_name'), $code,$settings));


            if ($updateState && $sendEmail) {
                return view('auth.verifyCode')->with(['id' => $id]);
            } else {
                return view('auth.verifyCode')->with(['id' => $id]);
            }
        }
    }

    public function loginCheck(Request $request)
    {


        $email = $request->input('normalUser_emailApp');
        $password = $request->input('normalUser_passwordApp');

        if (normaluser::where(['normaluser_email' => $email])->exists()) {

            if (normaluser::where(['normalUser_password' => $password, 'normaluser_email' => $email])->exists()) {
                $query = normaluser::where(['normalUser_password' => $password, 'normaluser_email' => $email])->get();
                $request->session()->put('userID', $query[0]->normalUser_id);
                $request->session()->put('normalUser_name', $query[0]->normalUser_name);
                $request->session()->put('normalUser_email', $query[0]->normalUser_email);
                $request->session()->put('normalUser_Photo', $query[0]->normalUser_Photo);
                $request->session()->put('country', $query[0]->normalUser_country);
                $request->session()->put('type', "1");
                return redirect()->back();
            } else {
                return redirect()->back()->with(['fail' => 'كلمة السر غير صحيحة']);
            }
        } else {
            return redirect()->back()->with(['fail' => 'لا يوجد حساب بهذا البريد الالكتروني']);
        }


        // if (DB::select('select * from normalusers where normalUser_name = ? and normalUser_password = ?', [$request->input('normalUser_nameApp'), $request->input('normalUser_passwordApp')]) == true) {
        //     // $userID = DB::table('normalusers')->select('normalUser_id')->where('normalUser_password',$request->input('normalUser_nameApp'));
        //     $userID = normaluser::select('normalUser_id')->where('normalUser_password', $request->input('normalUser_nameApp'))->get()->value('normalUser_id');
        //     // $userID = DB::statement(' SELECT FROM  normalusers WHERE normalUser_id = ');
        //     $request->session()->put('userID', $userID);
        //     $request->session()->put('type', "1");
        //     return redirect('');
        // } else {
        //     return redirect()->back()->with(['success' => 'تم تسجيل بيانات الدورة بنجاح']);
        // }
    }
    public function editAccount(Request $request)
    {
        $websiteID = Session::get('website_id');

        $user = normaluser::where(['normalUser_id' => Session::get('userID'), 'normalUser_vendor_id' => $websiteID])->get();

        $normalUser_name = $request->input('normalUser_name');
        $normalUser_email = $request->input('normalUser_email');
        $normalUser_password = $request->input('normalUser_password');
        $normalUser_phone = $request->input('normalUser_phone');


        $validate = $request->validate([
            'normalUser_name' => 'required|max:255',
            'normalUser_email' => 'required|max:255|email',
            'normalUser_password' => 'required|max:255',
            'normalUser_phone' => 'required',
        ]);

        $request->validate([
            'normalUser_Photo' => 'nullable|image|mimes:jpeg,png,jpg,gif|max:2048'
        ]);


        if ($request->hasFile('normalUser_Photo')) {
            // Get the new vendor_photo
            $normalUser_Photo = $request->file('normalUser_Photo');

                // Store the new image
                $imageName = time() . '.' . $normalUser_Photo->extension();

                $normalUser_Photo->move(('images/normalUsersPhotos'), $imageName);

                // Delete the old image if it exists
                if ($user[0]->normalUser_Photo && file_exists(('images/normalUsersPhotos' . $user[0]->normalUser_Photo))) {
                    unlink(('images/normalUsersPhotos' . $user[0]->normalUser_Photo));
                }


                // Update the product's normalUser_Photo path
                $updatePhoto = normaluser::where(['normalUser_id' => Session::get('userID'), 'normalUser_vendor_id' => $websiteID])->update([
                    'normalUser_Photo' => "images/normalUsersPhotos/$imageName",
                ]);
            
        }

        $update = normaluser::where(['normalUser_id' => $user[0]->normalUser_id, 'normalUser_vendor_id' => $websiteID])->update([
            'normalUser_name' => $normalUser_name,
            'normalUser_email' => $normalUser_email,
            'normalUser_password' => $normalUser_password,
            'normalUser_phone' => $normalUser_phone,
        ]);

        if ($update || $updatePhoto) {
            $request->session()->put('userID', $user[0]->normalUser_id);
            $request->session()->put('normalUser_name', $user[0]->normalUser_name);
            $request->session()->put('normalUser_email', $user[0]->normalUser_email);
            $request->session()->put('normalUser_Photo', $user[0]->normalUser_Photo);
            $request->session()->put('type', "1");

            return redirect()->back()->with(['success' => 'تم تحديث بيانات الحساب بنجاح']);
        } else {
            return redirect()->back()->with(['failed' => 'لم يتم التحديث لوجود خطأ']);
        }
    }

    public function logout()
    {
        Session::forget(['userID', 'normalUser_name', 'normalUser_email', 'normalUser_Photo', 'type']);
        return redirect()->route('home');
    }
    public function storeCountry(Request $request)
    {
        $currency = $request->country;
        $exchangeRates = config('currencies.currencies');
        Session::put('country', $currency);

        if (isset($exchangeRates[$currency])) {
            Session::put('currency', $currency);
            
        } else {
            Session::put('currency', 'EGP');
        }

    }

}
