<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\Http;
use Illuminate\Support\Str;
use App\Models\websiteBanner;
use App\Models\websiteUser;
use App\Models\vendor;
use App\Models\mainproducts;
use App\Models\maincategories;
use App\Models\admin;
use App\Models\payAuthentication;
use App\Models\vendorsSubscriptions;
use App\Models\subscription;
use App\Models\settings;
use App\Models\normaluser;
use App\Models\country;
use App\Models\client;
use App\Models\qr_user;
use App\Models\qr_settings;
use App\Models\qr_subscription;
use App\Models\ui;
use App\Models\ui_Categories;
use App\Models\ui_footer;
use App\Models\ui_header;
use App\Models\ui_products;
use App\Models\subscriptionCoupon;
use App\Models\dashboardPermission;
use App\Models\dashboardRoles;
use App\Models\selectedCountries;
use App\Models\selectedShippingCities;
use App\Models\shippingcity;

use Carbon\Carbon;
use SimpleSoftwareIO\QrCode\Facades\QrCode;
use Illuminate\Support\Facades\Mail;
use App\Mail\website\verifyWebsiteUser;
use App\Mail\website\VendorCreate;
use App\Mail\website\registrationSuccess;
use App\Mail\website\ExpiredSubscription;

use Illuminate\Support\Facades\Redirect;
use Illuminate\Support\Facades\Session;
use Stevebauman\Location\Facades\Location;

class websiteController extends Controller
{
    public function homeLocale(Request $request)
    {
        $lang = "ar";
        $currentURL = url()->current();
        $url = ("{$lang}");
        if (Str::contains($currentURL, 'en')) {
            return "en";
        } else {
            return redirect($url);
        }
    }

    public function websiteindex(Request $request)
    {
        // Currency 

        if (empty(Session::get('currency_website'))) {
            $currency = Location::get()->currencyCode;
            $exchangeRates = config('currencies.currencies');

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


        $subscriptionsSmall = subscription::whereNot('subscription_Price', '0')->where([
            'subscription_State' => 1,
            'subscription_Type' => 1,
        ])->get();
        $subscriptionsMedium = subscription::whereNot('subscription_Price', '0')->where([
            'subscription_State' => 1,
            'subscription_Type' => 2,
        ])->get();
        $subscriptionsLarge = subscription::whereNot('subscription_Price', '0')->where([
            'subscription_State' => 1,
            'subscription_Type' => 3,
        ])->get();

        $ourClients = client::where(['client_state' => "1"])->get();

        $banners = websiteBanner::where(['website_banner_state' => 1])->get();
        return view('website.home', [
            'banners' => $banners,
            'subscriptionsSmall' => $subscriptionsSmall,
            'subscriptionsMedium' => $subscriptionsMedium,
            'subscriptionsLarge' => $subscriptionsLarge,
            'ourClients' => $ourClients,

        ]);
    }
    public function websiteUserSettings(Request $request)
    {
        $vendors = vendor::where(['vendor_websiteuser_id' => Session::get('website_user_id')])->get();
        $countries = country::where(['country_state' => 1])->get();
        $QRs = qr_user::where(['qr_user_websiteuser_id' => Session::get('website_user_id')])->get();

        $user = websiteUser::where(['website_user_id' => Session::get('website_user_id')])->get();
        return view('website.dashboard.settings.settings', [
            'user' => $user,
            'vendors' => $vendors,
            'countries' => $countries,
            'QRs' => $QRs,
        ]);
    }
    public function currency(Request $request)
    {
        $currency = $request->cn;
        $exchangeRates = config('currencies.currencies');

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

        return redirect()->back();
    }

    // Auth =============================================================================================
    public function login(Request $request)
    {

        $validate = $request->validate([
            'EmailInputSignIn' => ['required'],
            'PasswordInputSignIn' => ['required'],
        ]);

        $email = $request->input('EmailInputSignIn');
        $password = $request->input('PasswordInputSignIn');
        $Query = websiteUser::where(['website_user_email' => $email])->get();




        if ($Query->isEmpty()) {
            return "no recent email";
        } else {
            if ($Query[0]->website_user_password == $password) {

                $request->session()->put('website_user_id', $Query[0]->website_user_id);
                $request->session()->put('website_user_name', $Query[0]->website_user_name);
                $request->session()->put('website_user_email', $Query[0]->website_user_email);
                $request->session()->put('website_user_Photo', $Query[0]->website_user_Photo);
                $request->session()->put('website_user_phone', $Query[0]->website_user_phone);
                $request->session()->put('website_user_token', $Query[0]->website_user_token);
                $request->session()->put('website_user_approve', $Query[0]->website_user_approve);


                return "login succsess";
            } else {

                return "password is not right";
            }
        }
    }
    public function signup(Request $request)
    {
        return view('website.auth.signup');
    }
    public function signupSuccess(Request $request)
    {

        $request->validate([
            'username' => 'required|string|min:3|max:25|unique:website_users,website_user_name',
            'email' => 'required|email|max:255|unique:website_users,website_user_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 = websiteUser::create([
            'website_user_name' => $username,
            'website_user_email' => $email,
            'website_user_password' => $password,
            'website_user_phone' => $phone_number,
            'website_user_type' => "1",
            'website_user_verifyCode' => $code,
            'website_user_approve' => 0,
        ]);

        $sendEmail = Mail::to($email)->send(new verifyWebsiteUser($username, $email, $code));

        $userid = websiteUser::where('website_user_email', $email)->get('website_user_id')->value('website_user_id');


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

    public function OTPcodeChecker(Request $request)
    {
        $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 = websiteUser::where('website_user_id', $id)->get();


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

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

            $sendEmail = Mail::to($user[0]->website_user_email)->send(new registrationSuccess($user[0]->website_user_name, $user[0]->website_user_email));

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

            $code = rand(100000, 999999);

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

            $sendEmail = Mail::to($user[0]->website_user_email)->send(new verifyWebsiteUser($user[0]->website_user_name, $user[0]->website_user_email, $code));


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

    public function logout(Request $request)
    {

        $request->session()->flush();

        return "loggedOut";
    }

    // Auth =============================================================================================


    // Dashboard ================================================================================================
    public function dashboardIndex()
    {

        $vendors = vendor::where(['vendor_websiteuser_id' => Session::get('website_user_id')])->first();
        $countries = country::where(['country_state' => 1])->get();
        $QRs = qr_user::where(['qr_user_websiteuser_id' => Session::get('website_user_id')])->get();
        $QRsubscriptions = qr_subscription::where(['qr_subscriptions_State' => "1", 'qr_subscriptions_Type' => "2"])->where('qr_subscriptions_Price', '!=', '0')->get();

        if ($vendors) {
            $vendors = vendor::where(['vendor_websiteuser_id' => Session::get('website_user_id')])->get();

            foreach ($vendors as $vendor) {
                $admins = admin::where('admin_vendor_id', $vendor->vendor_id)->count();
                $products = mainproducts::where('mainProduct_vendor_id', $vendor->vendor_id)->count();
                $users = normaluser::where('normalUser_vendor_id', $vendor->vendor_id)->count();

                return view('website.dashboard.home', [
                    'vendors' => $vendors,
                    'vendorsCount' => $vendors->count(),
                    'admins' => $admins,
                    'products' => $products,
                    'users' => $users,
                    'countries' => $countries,
                    'QRs' => $QRs,
                    'QRsubscriptions' => $QRsubscriptions,

                ]);
            }
        } else {
            return view('website.dashboard.home', [
                'vendors' => "0",
                'vendorsCount' => "0",
                'admins' => "0",
                'products' => "0",
                'users' => "0",
                'countries' => $countries,
                'QRsubscriptions' => $QRsubscriptions,

            ]);
        }
    }
    public function updateUserInfo(Request $request)
    {

        $user = websiteUser::where(['website_user_id' => Session::get('website_user_id')])->get();

        $website_user_name = $request->input('website_user_name');
        $website_user_email = $request->input('website_user_email');
        $website_user_password = $request->input('website_user_password');
        $website_user_phone = $request->input('website_user_phone');


        $validate = $request->validate([
            'website_user_name' => 'required|max:255',
            'website_user_email' => 'required|max:255|email',
            'website_user_password' => 'required|max:255',
            'website_user_phone' => 'required',
        ]);

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


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

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

            $website_user_Photo->move(('images/websiteUserProfile'), $imageName);

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


            // Update the product's website_user_Photo path
            $updatePhoto = websiteUser::where(['website_user_id' => $user[0]->website_user_id])->update([
                'website_user_Photo' => "images/websiteUserProfile/$imageName",
            ]);
        }

        $update = websiteUser::where(['website_user_id' => $user[0]->website_user_id])->update([
            'website_user_name' => $website_user_name,
            'website_user_email' => $website_user_email,
            'website_user_password' => $website_user_password,
            'website_user_phone' => $website_user_phone,
        ]);

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

    public function dashboardvendor(Request $request)
    {
        $countries = country::where(['country_state' => 1])->get();
        $QRs = qr_user::where(['qr_user_websiteuser_id' => Session::get('website_user_id')])->get();

        $vendorid = $request->id;
        $vendor = vendor::where(['vendor_id' => $vendorid])->get();
        $vendors = vendor::where(['vendor_websiteuser_id' => Session::get('website_user_id')])->get();
        $vendorsSubscriptions = vendorsSubscriptions::where(['vendors_subscriptions_vendor_id' => $vendorid])->with(['vendor', 'subscription'])->get();
        $subscriptions = subscription::where(['subscription_State' => "1"])->where('subscription_Price', '!=', '0')->get();

        $QRsubscriptions = qr_subscription::where(['qr_subscriptions_State' => "1", 'qr_subscriptions_Type' => "2"])->where('qr_subscriptions_Price', '!=', '0')->get();

        $products = mainproducts::where(['mainProduct_vendor_id' => $vendorid])->count();
        $categories = maincategories::where(['mainCategory_vendor_id' => $vendorid])->count();
        $admins = admin::where(['admin_vendor_id' => $vendorid])->count();

        $startDateNow = Carbon::now();
        if ($vendorsSubscriptions->isEmpty()) {
            return view('website.dashboard.vendor.vendor', [
                'vendor' => $vendor,
                'vendors' => $vendors,
                'subscriptions' => $subscriptions,
                'products' => $products,
                'categories' => $categories,
                'admins' => $admins,
                'vendorsSubscriptions' => $vendorsSubscriptions,
                'countries' => $countries,
                'QRs' => $QRs,
                'QRsubscriptions' => $QRsubscriptions,

            ]);
        } else {
            $startDate = Carbon::create($vendorsSubscriptions[0]->vendors_subscriptions_DateToBegin);

            $endDate = Carbon::create($vendorsSubscriptions[0]->vendors_subscriptions_DateToEnd); // or Carbon::parse('2023-01-15');

            $daysAvailable = $startDate->diffInDays($endDate);
            $days = $startDateNow->diffInDays($endDate);
        }




        return view('website.dashboard.vendor.vendor', [
            'vendor' => $vendor,
            'vendors' => $vendors,
            'subscriptions' => $subscriptions,
            'products' => $products,
            'categories' => $categories,
            'admins' => $admins,
            'vendorsSubscriptions' => $vendorsSubscriptions,
            'countries' => $countries,
            'QRs' => $QRs,
            'QRsubscriptions' => $QRsubscriptions,
            'days' => $days,
            'daysAvailable' => $daysAvailable,

        ]);
    }
    public function dashboardQR(Request $request)
    {

        $QRid = $request->id;
        $countries = country::where(['country_state' => 1])->get();

        $QR = qr_user::where(['qr_user_id' => $QRid])->get();
        $QRSettings = qr_settings::where(['qr_settings_vendor_id' => $QRid])->get();

        $QRs = qr_user::where(['qr_user_websiteuser_id' => Session::get('website_user_id')])->get();
        $QRsubscriptions = qr_subscription::where(['qr_subscriptions_State' => "1", 'qr_subscriptions_Type' => "2"])->where('qr_subscriptions_Price', '!=', '0')->get();

        // Generate The QR
        $scheme = request()->getScheme();
        $host = request()->getHost();
        $currentUrl = $scheme . '://' . $host;
        $fullURL = $currentUrl . '/qr/' . $QR[0]->qr_user_name;
        $qrCode = QrCode::format('svg')->size(300)->generate($fullURL);
        // $qrCode = base64_encode($qrCode); // Encode the QR code to base64


        // Generate The QR

        $vendors = vendor::where(['vendor_websiteuser_id' => Session::get('website_user_id')])->get();


        return view('website.dashboard.QR.QR', [
            'vendors' => $vendors,
            'QR' => $QR,
            'QRs' => $QRs,
            'countries' => $countries,
            'QRSettings' => $QRSettings,
            'qrCode' => $qrCode,
            'fullURL' => $fullURL,
            'QRsubscriptions' => $QRsubscriptions,

        ]);
    }
    public function regenerateQR(Request $request)
    {
        // Get the text from the request, or use a default value
        $text = $request->input('text');

        // Generate a new QR code
        $qrCode = QrCode::format('svg')->size(300)->generate("text");

        return response()->json(['qrCode' => $qrCode]);
    }
    public function dashboardQRSettings(Request $request)
    {
        $QRid = $request->id;
        $QRSettings = qr_settings::where(['qr_settings_vendor_id' => $QRid])->get();
        // Interface settings
        $qr_settings_main_color = $request->input('qr_settings_main_color');
        $qr_settings_main_titleEN = $request->input('qr_settings_main_titleEN');
        $qr_settings_main_titleEN = $request->input('qr_settings_main_titleEN');
        $qr_settings_main_text_color = $request->input('qr_settings_main_text_color');
        $qr_settings_main_phone = $request->input('qr_settings_main_phone');
        $qr_settings_main_email = $request->input('qr_settings_main_email');
        // Interface settings

        // Social Media
        $qr_settings_facebook = $request->input('qr_settings_facebook');
        $qr_settings_X = $request->input('qr_settings_X');
        $qr_settings_instagram = $request->input('qr_settings_instagram');
        $qr_settings_youtube = $request->input('qr_settings_youtube');
        $qr_settings_main_whatsapp = $request->input('qr_settings_main_whatsapp');
        $qr_settings_snapchat = $request->input('qr_settings_snapchat');
        $qr_settings_tiktok = $request->input('qr_settings_tiktok');
        $qr_settings_googleplay = $request->input('qr_settings_googleplay');
        $qr_settings_appstore = $request->input('qr_settings_appstore');
        // Social Media

        // SEO
        $qr_settings_main_SEO = $request->input('qr_settings_main_SEO');
        // SEO

        // About
        $qr_settings_main_aboutEN = $request->input('qr_settings_main_aboutEN');
        $qr_settings_main_aboutAR = $request->input('qr_settings_main_aboutAR');
        // About


        $settingsEdit = qr_settings::where(
            [
                'qr_settings_vendor_id' => $QRid,
            ]
        )->update([
            // Interface settings
            'qr_settings_main_color' => $qr_settings_main_color,
            'qr_settings_main_titleEN' => $qr_settings_main_titleEN,
            'qr_settings_main_titleEN' => $qr_settings_main_titleEN,
            'qr_settings_main_text_color' => $qr_settings_main_text_color,
            'qr_settings_main_email' => $qr_settings_main_email,
            'qr_settings_main_phone' => $qr_settings_main_phone,
            // Interface settings

            // Social Media
            'qr_settings_facebook' => $qr_settings_facebook,
            'qr_settings_X' => $qr_settings_X,
            'qr_settings_instagram' => $qr_settings_instagram,
            'qr_settings_youtube' => $qr_settings_youtube,
            'qr_settings_main_whatsapp' => $qr_settings_main_whatsapp,
            'qr_settings_snapchat' => $qr_settings_snapchat,
            'qr_settings_tiktok' => $qr_settings_tiktok,
            'qr_settings_googleplay' => $qr_settings_googleplay,
            'qr_settings_appstore' => $qr_settings_appstore,
            // Social Media

            // SEO
            'qr_settings_main_SEO' => $qr_settings_main_SEO,
            // SEO

            // About
            'qr_settings_main_aboutEN' => $qr_settings_main_aboutEN,
            'qr_settings_main_aboutAR' => $qr_settings_main_aboutAR,
            // About
        ]);


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

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

            $qr_settings_main_logo->move(('images/QRLogos'), $imageName);

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

            // Update the admin's qr_settings_main_logo path
            $updatePhoto = qr_settings::where(['qr_settings_id' => $QRSettings[0]->qr_settings_id])->update([
                'qr_settings_main_logo' => "images/QRLogos/$imageName",
            ]);
        }
        if ($request->hasFile('qr_settings_background')) {
            // Get the new qr_settings_background
            $qr_settings_background = $request->file('qr_settings_background');

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

            $qr_settings_background->move(('images/QRBackgrounds'), $imageName);

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

            // Update the admin's qr_settings_background path
            $updatePhoto = qr_settings::where(['qr_settings_id' => $QRSettings[0]->qr_settings_id])->update([
                'qr_settings_background' => "images/QRBackgrounds/$imageName",
            ]);
        }


        return redirect()->back()->with(['success' => 'تم تسجيل إعدادات المتجر بنجاح']);
    }


    public function dashboardAddvendor(Request $request)

    {

        // Check if user has more than 3 vendors
        if (vendor::where(['vendor_websiteuser_id' => Session::get('website_user_id')])->count() >= 2) {

            return redirect()->back()->with(['problem' => '']);
        } else {
            $validate = $request->validate([
                'vendor_name' => 'required|unique:vendors|max:255',
                'settings_main_titleEN' => 'required|unique:settings|max:255',
                'settings_main_titleAR' => 'required|unique:settings|max:255',
                'vendor_email' => 'required|unique:vendors|max:255|email',
                'vendor_phone' => 'required|unique:vendors|max:255',
                'vendor_country' => 'required',
            ]);

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


            $vendor_name = $request->input('vendor_name');
            $settings_main_titleEN = $request->input('settings_main_titleEN');
            $settings_main_titleAR = $request->input('settings_main_titleAR');
            $vendor_email = $request->input('vendor_email');
            $vendor_phone = $request->input('vendor_phone');
            $vendor_country = $request->input('vendor_country');
            $vendorurl = "vendor/$vendor_name";
            // $code = rand(10000, 20000);


            $addQuery = vendor::create([
                'vendor_name' => $vendor_name,
                'vendor_email' => $vendor_email,
                'vendor_phone' => $vendor_phone ?? "",
                'vendor_country_id' => $vendor_country,
                'vendor_state' => "1",
                'vendor_websiteuser_id' => Session::get('website_user_id'),
                'vendor_website_link' => url($vendorurl),
            ]);



            if ($addQuery) {

                // Create the settings for the website
                $vendorid = vendor::where('vendor_name', $vendor_name)->get('vendor_id')->value('vendor_id');

                // header
                $header = ui::where(['ui_type' => '3'])->first();
                ui_header::create([
                    'ui_headers_name' => 'Header_1',
                    'ui_headers_vendor_id' => $vendorid,
                    'ui_headers_ui_id' => $header->ui_id,
                    'ui_headers_state' => 1,
                ]);
                $maxHeaderID = ui_header::where(['ui_headers_vendor_id' => $vendorid, 'ui_headers_ui_id' => $header->ui_id,])->max("ui_headers_id");
                // header

                // Footer
                $footer = ui::where(['ui_type' => '4'])->first();
                ui_footer::create([
                    'ui_footers_name' => 'footers_1',
                    'ui_footers_vendor_id' => $vendorid,
                    'ui_footers_ui_id' => $footer->ui_id,
                    'ui_footers_state' => 1,
                ]);
                $maxfootersID = ui_footer::where(['ui_footers_vendor_id' => $vendorid, 'ui_footers_ui_id' => $footer->ui_id,])->max("ui_footers_id");
                // Footer

                // products
                $products = ui::where(['ui_type' => '1'])->first();
                ui_products::create([
                    'ui_products_name' => 'Products_1',
                    'ui_products_vendor_id' => $vendorid,
                    'ui_products_ui_id' => $products->ui_id,
                    'ui_products_state' => 1,
                ]);
                $maxProductID = ui_products::where(['ui_products_vendor_id' => $vendorid, 'ui_products_ui_id' => $products->ui_id,])->max("ui_products_id");
                // products

                // categories
                $categories = ui::where(['ui_type' => '2'])->first();
                ui_Categories::create([
                    'ui_categories_name' => 'categories_1',
                    'ui_categories_vendor_id' => $vendorid,
                    'ui_categories_ui_id' => $categories->ui_id,
                    'ui_categories_state' => 1,
                ]);
                $maxCategoriesID = ui_Categories::where(['ui_categories_vendor_id' => $vendorid, 'ui_categories_ui_id' => $categories->ui_id,])->max("ui_categories_id");
                // categories

                $addSettings = settings::create([
                    'settings_Products_id' => $maxProductID,
                    'settings_category_id' => $maxCategoriesID,
                    'settings_Header_id' => $maxHeaderID,
                    'settings_Footer_id' => $maxfootersID,

                    'settings_vendor_id' => $vendorid,
                    'settings_main_color' => '#6495ed',
                    'settings_main_titleEN' => $settings_main_titleEN,
                    'settings_main_titleAR' => $settings_main_titleAR,
                    'settings_main_text_color' => '#ffffff',

                ]);
                $settingsid = settings::where(['settings_vendor_id' => $vendorid,])->get('settings_id')->value('settings_id');
                // Create the settings for the website

                // Create Default User
                $addDefaultUser = admin::create([
                    'admin_name' => $vendor_name,
                    'admin_email' => $vendor_email,
                    'admin_password' => $vendor_phone,
                    'admin_vendor_id' => $vendorid,
                    'admin_state' => "1",
                ]);

                $defualtUserID = admin::where([
                    'admin_name' => $vendor_name,
                    'admin_email' => $vendor_email,
                    'admin_password' => $vendor_phone,
                    'admin_vendor_id' => $vendorid,
                ])->get();



                $Permissions = dashboardPermission::all();

                foreach ($Permissions as $Permission) {
                    $addPermissions = dashboardRoles::create([
                        'dashboard_role_userid' => $defualtUserID[0]->admin_id,
                        'dashboard_role_permissionid' => $Permission->dashboard_permission_id,
                    ]);
                }
                // Create Default User

                // Adding Country and places
                $addingCountry = selectedCountries::create([
                    "Country_id" => $vendor_country,
                    "selected_Country_vendor_id" => $vendorid,
                    "selected_Country_state" => 1,
                ]);

                $cities = shippingcity::where([
                    "shippingCity_Country" => $vendor_country,
                ])->get();

                foreach ($cities as $city) {
                    $addingPlaces = selectedShippingCities::create([
                        "selected_shipping_city_Cost" => 0,
                        "selected_shipping_city_Time" => 0,
                        "selected_shipping_city_DayOrHour" => "hour",
                        "selected_city" => $city->normaluserAddress_cityID,
                        "selected_city_Country" => $vendor_country,
                        "selected_city_vendor_id" => $vendorid,
                        "selected_Country_state" => 1,
                    ]);
                }
                // Adding Country and places

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

                    // Check if the new image is valid
                    if ($vendor_photo->isValid()) {
                        // Store the new image
                        $imageName = time() . '.' . $vendor_photo->extension();

                        $vendor_photo->move(('images/vendorsPhotos'), $imageName);

                        // Update the product's vendor_photo path
                        vendor::where(['vendor_id' => $vendorid])->update([
                            'vendor_photo' => "images/vendorsPhotos/$imageName",
                        ]);
                        settings::where(['settings_id' => $settingsid])->update([
                            'settings_main_logo' => "images/vendorsPhotos/$imageName",
                        ]);
                    }
                }
                // Email
                $sendEmail = Mail::to($vendor_email)->send(new VendorCreate($vendor_name, $settings_main_titleAR, $vendor_email));
                $sendEmailToAdministration = Mail::to('moaid.morgan@gmail.com')->send(new VendorCreate($vendor_name, $settings_main_titleAR, $vendor_email));
                // Email


                return redirect()->back()->with(['success' => 'تم تسجيل بيانات المتجر بنجاح']);
            } else {
                return redirect()->back()->with([]);
            }
        }
    }

    public function removeSubscribe(Request $request)
    {
        $id = $request->segment(4);

        $Query = vendorsSubscriptions::where(['vendors_subscriptions_id' => $id])->delete();

        return redirect()->back()->with(['success' => 'تم إزالة الإشتراك بنجاح']);
    }
    public function vendorChangeState(Request $request)
    {
        $id = $request->vendor_id;
        $new_state = $request->new_state;

        $Query = vendor::where(['vendor_id' => $id])->update([
            'vendor_state' => $new_state,
        ]);

        if ($Query) {
            return response()->json([
                'success' => true,
                'message' => 'success.'
            ]);
        } else {
            # code...
        }
    }

    public function subscribePrice(Request $request)
    {
        $id = $request->input('id');
        $subscriptions = subscription::where(['subscription_id' => $id, 'subscription_State' => "1"])->get();


        $numberOfMonths = $request->input('months');

        $equation = $numberOfMonths * $subscriptions[0]->subscription_Price;

        return number_format($equation, 2);
    }
    public function subscriptionPrice(Request $request)
    {
        $id = $request->input('id');


        $subscriptions = subscription::where(['subscription_id' => $id, 'subscription_State' => "1"])->get();

        $numberOfMonths = $request->input('months');

        $equation = $numberOfMonths * $subscriptions[0]->subscription_Price;

        return  number_format($equation, 2);
    }
    public function couponSubscribe(Request $request)
    {
        $totalPrice = $request->input('totalPrice');
        if (empty($request->input('couponSubscribe'))) {
            return "please type";
        } else {
            $couponName = $request->input('couponSubscribe');

            $today = Carbon::today()->toDateString();
            $coupon = subscriptionCoupon::where([
                'subscription_coupon_Name' => $couponName,
                'subscription_coupon_state' => 1,
            ])->get();

            if ($coupon[0]->date_to_end == null) {
                return "empty";
            } else {
                $query = subscriptionCoupon::where([
                    'subscription_coupon_Name' => $couponName,
                    'subscription_coupon_state' => 1,
                ])
                    ->where('date_to_begin', '<=', $today)
                    ->where('date_to_end', '>=', $today)
                    ->get();

                if ($query) {
                    $percent = (100 - $query[0]->subscription_coupon_Discount) / 100;
                    $equation =  $percent  *  (int) $totalPrice;
                    return  number_format($equation, 2);
                } else {
                    return 0;
                }
            }
        }
    }
    public function dashboardAccountReminder(Request $request)
    {

        $vendor = vendor::where(['vendor_id' => $request->vendorid])->get();

        // Check if checkbox is checked or not
        $updateQuery = vendor::where(['vendor_id' => $request->vendorid])->update([
            'vendor_dashboardAccount_reminder' => $request->input('reminder_preference'),
        ]);

        // Return JSON response
        return response()->json([
            'status' => 'success',
            'message' => 'Reminder preference updated!',
            'reminder_preference' => $request->input('reminder_preference')
        ]);
    }
    public function dashboardOnboardingReminder(Request $request)
    {

        $userid = $request->userid;

        // Check if checkbox is checked or not
        $updateQuery = websiteUser::where(['website_user_id' => $userid])->update([
            'website_user_onboarding' => $request->input('reminder_preference'),
        ]);

        // Return JSON response
        return response()->json([
            'status' => 'success',
            'message' => 'Reminder preference updated!',
            'reminder_preference' => $request->input('reminder_preference')
        ]);
    }

    public function subscribe(Request $request)
    {
        $subscriptionid = $request->input('Subscription_id');
        $vendorid = $request->segment(4);
        $type = $request->input('type');
        $originalDate = Carbon::now();
        $numberOfMonths = $request->input('months');
        if ($request->has('months')) {
            $numberOfMonths = $request->input('months');
        } else {
            $numberOfMonths = $request->input('monthsOfIncrease');
        }



        $newDate = $originalDate->addMonths($numberOfMonths);

        // Session Save 

        Session::put('vendor_subscripe_enddate', $newDate);
        Session::put('vendor_subscripe_begindate', $originalDate);
        Session::put('vendor_subscripe_subscription_id', $subscriptionid);
        Session::put('vendor_subscripe_vendor_id', $vendorid);
        Session::put('vendor_subscripe_vendor_numberOfMonths', $numberOfMonths);
        Session::put('vendor_subscripe_type', $type);

        // Session Save 


        // Price Validate =======

        if ($request->has('totalPrice')) {
            $price = $request->input('totalPrice');
        } else {
            $price = $request->input('IncreasetotalPrice');
        }


        $subscriptionQuery = subscription::where(['subscription_id' => $subscriptionid])->get();
        $subscriptionPriceQuery = number_format($subscriptionQuery[0]->subscription_Price * $numberOfMonths, 2);

        if ($price == $subscriptionPriceQuery) {
            $priceCents = 00;

            $priceToSend = intval($price) . $priceCents . $priceCents;
            $token = $this->token();
            $order = $this->makeorder($token, $priceToSend);
            $getPaymentToken = $this->getPaymentToken($token, $order, $priceToSend);
            $paylink = ('https://accept.paymobsolutions.com/api/acceptance/iframes/' . "782117" . '?payment_token=' . $getPaymentToken);
            return redirect()->to($paylink);
        } else {
            return "احا";
        }
        // Price Validate =======

    }
    public function receiveGift(Request $request)
    {

        $vendorid = $request->vendorid;

        $vendor = vendor::where(['vendor_id' => $vendorid])->get();
        if ($vendor[0]->vendor_newState == "1") {
            $originalDate = Carbon::now();
            $newDate = $originalDate->addDays(14);

            vendorsSubscriptions::create([
                'Subscription_id' => subscription::where(['subscription_NameEN' => 'Free Gift'])->get()[0]->subscription_id,
                'vendors_subscriptions_vendor_id' => $vendorid,
                'vendors_subscriptions_DateToBegin' => Carbon::now(),
                'vendors_subscriptions_DateToEnd' => $newDate,
                'vendors_subscriptions_Products_limit' => "100",
                'vendors_subscriptions_Admins_limit' => "3",
                'vendors_subscriptions_State' => "1",
                'vendors_subscriptions_PaymentState' => "1",
                'vendors_subscriptions_duration' => "14",
            ]);

            $updateNewState = vendor::where(['vendor_id' => $vendorid])->update([
                'vendor_newState' => "0"
            ]);
        } else {
            # code...
        }

        return redirect()->back();
    }

    // Dashboard ================================================================================================


    // Pay ================================================================================================
    public function token()
    {
        $Paymobtoken = "ZXlKaGJHY2lPaUpJVXpVeE1pSXNJblI1Y0NJNklrcFhWQ0o5LmV5SmpiR0Z6Y3lJNklrMWxjbU5vWVc1MElpd2ljSEp2Wm1sc1pWOXdheUk2TmpRME1EWTFMQ0p1WVcxbElqb2lNVFk1TWpRek56WXdOaTQxTnpJeU1UWWlmUS5ZenNhVjFQWHFCeURzQmJ5S3BBcDZCZjVObmdON2hSMU5xQ0pHQ2RqRUdyX1gxaFV0ZHh2WVhjN2RDS2FPR05wZWN5dVBGelFTbENEcHRGclFOMEpsQQ==";
        $response = Http::post('https://accept.paymob.com/api/auth/tokens', ['api_key' => $Paymobtoken]);
        return $response->object()->token;
    }
    public function makeorder($token, $priceToSend)
    {
        $data = [
            "auth_token" => $token,
            "delivery_needed" => "false",
            "amount_cents" => $priceToSend,
            "currency" => "EGP",

            // "merchant_order_id" => 22,
        ];
        $response = Http::post('https://accept.paymob.com/api/ecommerce/orders', $data);
        return $response->object();
    }
    public function getPaymentToken($token, $order, $priceToSend)
    {
        $data = [
            "auth_token" => $token,
            "amount_cents" => $priceToSend,
            "expiration" => 3600,
            "order_id" => $order->id,
            "billing_data" => [
                "apartment" => "803",
                "email" => "claudette09@exa.com",
                "floor" => "42",
                "first_name" => "Clifford",
                "street" => "Ethan Land",
                "building" => "8028",
                "phone_number" => "+86(8)9135210487",
                "shipping_method" => "PKG",
                "postal_code" => "01898",
                "city" => "Jaskolskiburgh",
                "country" => "CR",
                "last_name" => "Nicolas",
                "state" => "Utah",

            ],
            "currency" => "EGP",
            "integration_id" => 4110869
        ];
        $response = Http::post('https://accept.paymob.com/api/acceptance/payment_keys', $data);
        return $response->object()->token;
    }
    // Pay Callback
    public function pay(Request $request)
    {

        echo "haha";
        $query = payAuthentication::where(['pay_authentication_Hash' => $request['hmac']])->exists();

        if ($query) {
        } else {
            payAuthentication::create([
                'pay_authentication_Hash' => $request['hmac'],
                'pay_authentication_State' => 1,
                'pay_authentication_amount_cents' => $request['amount_cents'],
            ]);

            $subscription = subscription::where('subscription_id', Session::get('vendor_subscripe_subscription_id'))->get();

            vendorsSubscriptions::create([
                'Subscription_id' => Session::get('vendor_subscripe_subscription_id'),
                'vendors_subscriptions_vendor_id' => Session::get('vendor_subscripe_vendor_id'),
                'vendors_subscriptions_DateToBegin' => Session::get('vendor_subscripe_begindate'),
                'vendors_subscriptions_DateToEnd' => Session::get('vendor_subscripe_enddate'),
                'vendors_subscriptions_Products_limit' => $subscription[0]->subscription_Products_limit,
                'vendors_subscriptions_Admins_limit' => $subscription[0]->subscription_Admins_limit,
                'vendors_subscriptions_State' => "1",
                'vendors_subscriptions_PaymentState' => "1",
                'vendors_subscriptions_duration' => Session::get('vendor_subscripe_vendor_numberOfMonths'),
            ]);
            Session::forget([
                'vendor_subscripe_subscription_id',
                'vendor_subscripe_vendor_id',
                'vendor_subscripe_begindate',
                'vendor_subscripe_enddate',
                'vendor_subscripe_vendor_numberOfMonths',
            ]);
        }
    }
    public function state(Request $request)           // GET CALLBACK
    {
        $data = request()->query();
        $order = $data['order'];
        $Receivedhmac = $data['hmac'];


        $hmac = $data['hmac'];
        $amount_cents = $data['amount_cents'];
        $created_at = $data['created_at'];
        $currency = $data['currency'];
        $error_occured = $data['error_occured'];
        $has_parent_transaction = $data['has_parent_transaction'];
        $id = $data['id'];
        $integration_id = $data['integration_id'];
        $is_3d_secure = $data['is_3d_secure'];
        $is_auth = $data['is_auth'];
        $is_capture = $data['is_capture'];
        $is_refunded = $data['is_refunded'];
        $is_standalone_payment = $data['is_standalone_payment'];
        $is_voided = $data['is_voided'];
        $order_id = $data['order'];
        $owner = $data['owner'];
        $pending = $data['pending'];
        $source_data_pan = $data['source_data_pan'];
        $source_data_sub_type = $data['source_data_sub_type'];
        $source_data_type = $data['source_data_type'];
        $success = $data['success'];


        $request_string = $amount_cents . $created_at . $currency . $error_occured . $has_parent_transaction . $id . $integration_id . $is_3d_secure . $is_auth . $is_capture . $is_refunded . $is_standalone_payment . $is_voided . $order_id . $owner . $pending . $source_data_pan . $source_data_sub_type . $source_data_type . $success;

        $hased = hash_hmac('SHA512', $request_string, 'BFCE8CEC6D9DC2FCEEE59EEC2C6ECFD0');

        if ($Receivedhmac == $hased) {

            $query = payAuthentication::where(['pay_authentication_Hash' => $data['hmac']])->exists();

            if ($query) {
            } else {
                if (Session::get('vendor_subscripe_type') == "Increase") {
                    vendorsSubscriptions::where([
                        'vendors_subscriptions_vendor_id' => Session::get('vendor_subscripe_vendor_id'),
                        'Subscription_id' => Session::get('vendor_subscripe_subscription_id')
                    ])->update([
                        'vendors_subscriptions_DateToBegin' => Carbon::now(),
                        'vendors_subscriptions_DateToEnd' => Session::get('vendor_subscripe_enddate')

                    ]);
                    Session::forget([
                        'vendor_subscripe_subscription_id',
                        'vendor_subscripe_vendor_id',
                        'vendor_subscripe_begindate',
                        'vendor_subscripe_enddate',
                        'vendor_subscripe_vendor_numberOfMonths',
                        'vendor_subscripe_type',
                    ]);
                } else {

                    payAuthentication::create([
                        'pay_authentication_Hash' => $request['hmac'],
                        'pay_authentication_State' => 1,
                        'pay_authentication_amount_cents' => $request['amount_cents'],
                    ]);

                    $subscription = subscription::where('subscription_id', Session::get('vendor_subscripe_subscription_id'))->get();

                    vendorsSubscriptions::create([
                        'Subscription_id' => Session::get('vendor_subscripe_subscription_id'),
                        'vendors_subscriptions_vendor_id' => Session::get('vendor_subscripe_vendor_id'),
                        'vendors_subscriptions_DateToBegin' => Carbon::now(),
                        'vendors_subscriptions_DateToEnd' => Session::get('vendor_subscripe_enddate'),
                        'vendors_subscriptions_Products_limit' => $subscription[0]->subscription_Products_limit,
                        'vendors_subscriptions_Admins_limit' => $subscription[0]->subscription_Admins_limit,
                        'vendors_subscriptions_State' => "1",
                        'vendors_subscriptions_PaymentState' => "1",
                        'vendors_subscriptions_duration' => Session::get('vendor_subscripe_vendor_numberOfMonths'),
                    ]);
                    Session::forget([
                        'vendor_subscripe_subscription_id',
                        'vendor_subscripe_vendor_id',
                        'vendor_subscripe_begindate',
                        'vendor_subscripe_enddate',
                        'vendor_subscripe_vendor_numberOfMonths',
                        'vendor_subscripe_type',
                    ]);
                }
            }


            // Get the CSRF token
            // $csrfToken = csrf_token();

            // $response = Http::get(route('pay'), $data);


            // Get the response body
            // $responseBody = $response->body();

            // Check if the request was successful
            // if ($response->successful()) {
            //     // Handle the successful response
            //     return response()->json(['message' => 'Request successful', 'data' => $responseBody]);
            // } else {
            //     // Handle the error response
            //     return response()->json(['message' => 'Request failed', 'error' => $response->body()], $response->status());
            // }


            return view('website.callbacks.state', [
                'id' => $id,
                'order' => $order,
                'success' => $success,
                'pending' => $pending,
                'Receivedhmac' => $Receivedhmac,
                'hased' => $hased,
                'amount_cents' => $amount_cents,
                'created_at' => $created_at,

            ]);
        } else {
            return "error";
        }
    }
    public function Poststate(Request $request)        // POST CALLBACK
    {
        $json = json_decode($request);

        $amount_cents = $json->obj->amount_cents;                         // database
        $order_created_at = $json->obj->order->created_at;                // order created_at
        $currency = $json->obj->currency;                                 // currency// database
        $error_occured = $json->obj->error_occured;                       // error occured
        $has_parent_transaction = $json->obj->has_parent_transaction;     // has_parent_transaction
        $transaction_id = $json->obj->id;                                 // transactionID // database
        $integration_id = $json->obj->integration_id;                     // integration_id
        $is_3d_secure = $json->obj->is_3d_secure;                         // is_3d_secure
        $is_auth = $json->obj->is_auth;                                   // is_auth
        $is_capture = $json->obj->is_capture;                             // is_capture
        $is_refunded = $json->obj->is_refunded;                           // is_refunded
        $is_standalone_payment = $json->obj->is_standalone_payment;       // is_standalone_payment
        $is_voided = $json->obj->is_voided;                               // is_voided
        $order_id = $json->obj->order->id;                                // order ID        // database
        $owner = $json->obj->owner;                                       // owner
        $pending = $json->obj->pending;                                   // pending        // database
        $source_data_pan = $json->obj->source_data->pan;                  // source_data pan
        $source_data_type = $json->obj->source_data->type;                // source_data type
        $source_data_sub_type = $json->obj->source_data->sub_type;        // source_data sub_type
        $success = $json->obj->success;                                   // success        // database




        $secure_hash = $json->obj->data->secure_hash;


        $request_string = $amount_cents . $order_created_at . $currency . $error_occured . $has_parent_transaction . $transaction_id . $integration_id . $is_3d_secure . $is_auth . $is_capture . $is_refunded . $is_standalone_payment . $is_voided . $order_id . $owner . $pending . $source_data_pan . $source_data_sub_type . $source_data_type . $success;

        $hased = hash_hmac('SHA512', $request_string, 'BFCE8CEC6D9DC2FCEEE59EEC2C6ECFD0');


        // Purchase

        // Purchase

        return $secure_hash;
    }

    // Pay Callback


    // Pay ================================================================================================
}
