<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\coupon;
use App\Models\country;
use Carbon\Carbon;

use Illuminate\Support\Facades\Session;

class CouponController extends Controller
{
    public function checkCoupon(Request $request)
    {
        $couponName = $request->input('coupon');

        if ($couponName == null) {
            echo json_encode(number_format(0.0, 2));
        } else {
            $dayTime = now()->format('Y-m-d H:i:s');
            $endDate = coupon::select('date_to_end')->where('coupon_Name', $couponName)->value('date_to_end');


            if (
                coupon::select('coupon_Name')
                ->where('coupon_Name', $couponName)
                ->where('date_to_begin', '>=', $dayTime)
                ->where('date_to_end', '<=', $endDate)
                ->value('coupon_Name') == $couponName
            ) {
                echo coupon::select('coupon_Discount')->where('coupon_Name', $couponName)->value('coupon_Discount');
                //  json_encode(['data'=>coupon::where('coupon_Name',$couponName)->get()])
            } else {
                echo json_encode(number_format(0.0, 2));
            }
        }
    }
    // Web ======================================================================================================================
    public function checKCouponWeb(Request $request)
    {
        $couponName = $request->input('coupon');
        $dayTime = now()->format('Y-m-d H:i:s');
        $currentDate = Carbon::now(); // Get current date and time

        $coupon = coupon::where([
            'coupon_Name' => $couponName,
            'coupon_vendor_id' => Session::get('website_id')
        ])->first();
        if (empty($coupon)) {
            // Coupon Not Available
            return "0";
        } else {
            if ($coupon->date_to_begin < $dayTime) {
                if ($coupon->date_to_end > $dayTime) {
                    // Coupon is valid
                    $query = coupon::where([
                        'coupon_Name' => $couponName,
                        'coupon_vendor_id' => Session::get('website_id')
                    ])->where('date_to_begin', '<=', $dayTime)
                        ->where('date_to_end', '>=', $dayTime)->first();

                    if ($query) {
                        Session::put('coupon', $query);
                        return $query->coupon_Discount;
                    } else {
                        return 0;
                    }
                } else {
                    return response()->json([
                        'fail' => true,
                        'message' => 'Coupon has expired.'
                    ]);
                }
            } else {
                // Coupon Not Valid Yet
                return "0";
            }
        }
    }
    public function removeCoupon(Request $request)
    {
        session()->forget('coupon');

        return response()->json([
            'success' => true,
            'message' => 'Coupon removed successfully.'
        ]);
    }

    // Web ======================================================================================================================


    // Dashboard ======================================================================================================================
    public function couponsDashboardIndex()
    {
        $coupons = coupon::where(['coupon_vendor_id' => Session::get('vendor_id')])->paginate(10);
        return view('dashboard.coupons.coupons', ['coupons' => $coupons]);
    }

    public function couponsDashboardadd()
    {

        $countries = country::where(['country_state' => 1])->get();
        return view('dashboard.coupons.addcoupon', ['countries' => $countries]);
    }
    public function couponsDashboardaddSuccess(Request $request)
    {

        $coupon_Name = $request->input('coupon_Name');
        $country_currency = $request->input('country_currency');
        $discount = $request->input('discount');
        $date_to_begin = $request->input('date_to_begin');
        $date_to_end = $request->input('date_to_end');
        $coupon_Count = $request->input('coupon_Count');



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


        $addQuery = coupon::create([
            'coupon_Name' => $coupon_Name,
            'coupon_Discount' => $discount,
            'date_to_begin' => $date_to_begin,
            'date_to_end' => $date_to_end,
            'coupon_country_id' => $country_currency,
            'coupon_vendor_id' => Session::get('vendor_id'),
            'coupon_Count' => $coupon_Count,

        ]);


        if ($addQuery) {
            return redirect()->route('dashboard.couponsDashboardIndex')->with(['success' => 'تم تسجيل بيانات الدورة بنجاح']);
        } else {
            return redirect()->back()->with([]);
        }
    }
    public function couponsDashboardedit(Request $request)
    {
        $couponid = $request->couponid;
        $coupon = coupon::with('country')->where(['coupon_id' => $couponid])->get();
        $countries = country::where(['country_state' => 1])->get();

        return view('dashboard.coupons.editcoupon', ['coupon' => $coupon, 'countries' => $countries]);
    }
    public function couponsDashboardeditSuccess(Request $request)
    {
        $couponid = $request->couponid;
        $coupon_Name = $request->input('coupon_Name');
        $country_currency = $request->input('country_currency');
        $discount = $request->input('discount');
        $date_to_begin = $request->input('date_to_begin');
        $date_to_end = $request->input('date_to_end');
        $coupon_Count = $request->input('coupon_Count');



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


        $addQuery = coupon::where(['coupon_id' => $couponid])->update([
            'coupon_Name' => $coupon_Name,
            'coupon_Discount' => $discount,
            'date_to_begin' => $date_to_begin,
            'date_to_end' => $date_to_end,
            'coupon_country_id' => $country_currency,
            'coupon_vendor_id' => Session::get('vendor_id'),
            'coupon_Count' => $coupon_Count,

        ]);


        if ($addQuery) {
            return redirect()->route('dashboard.couponsDashboardIndex')->with(['success' => 'تم تسجيل بيانات الدورة بنجاح']);
        } else {
            return redirect()->back()->with([]);
        }
    }

    public function couponsDashboarddelete(Request $request)
    {
        $couponid = $request->couponid;

        $studentQuery = coupon::where(['coupon_id' => $couponid])->delete();

        return redirect()->route('dashboard.couponsDashboardIndex')->with(['success' => 'تم إزالة القسم بنجاح']);
    }
    // Dashboard ======================================================================================================================



    // AJAX =========================================================================================================================================================
    public function couponsSearch(Request $request)
    {
        $name = $request->input('search');
        if ($name) {
            $category = coupon::where('mainCategoryNameAr', 'LIKE', '%' . $name . '%')
                ->orwhere('mainCategoryName', 'LIKE', '%' . $name . '%')->orwhere('mainCategorySEO', 'LIKE', '%' . $name . '%')
                ->paginate(10);

            foreach ($category as $coupons) {
                echo "<tr>
                                <th scope='row'>
            
                                <label class='control control--checkbox'>
                                <input type='checkbox'>
                                <div class='control__indicator'></div>
                                </label>
            
                                </th>
                                <td>
                                        $coupons->mainCategoryID
                                </td>
                                
                                <td><img src='$coupons->mainCategoryPhoto' height='100'></td>
                                <td>$coupons->mainCategoryNameAr</td>
                                <td>
            
                                <a name='' id='' class='btn btn-success' href='coupons/$coupons->mainCategoryID/edit' role='button'>تعديل</a>
                                <a name='' id='' class='btn btn-danger' href='coupons/$coupons->mainCategoryID/delete' role='button'>حذف</a>
            
                                </td>
                             </tr>";
            }
        }
        if ($name == "") {
            $user = coupon::all();

            foreach ($category as $coupons) {
                echo "<tr>
                                <th scope='row'>
            
                                <label class='control control--checkbox'>
                                <input type='checkbox'>
                                <div class='control__indicator'></div>
                                </label>
            
                                </th>
                                <td>
                                        $coupons->mainCategoryID
                                </td>
                                
                                <td><img src='$coupons->mainCategoryPhoto' height='100'></td>
                                <td>$coupons->mainCategoryNameAr</td>
                                <td>
            
                                <a name='' id='' class='btn btn-success' href='coupons/$coupons->mainCategoryID/edit' role='button'>تعديل</a>
                                <a name='' id='' class='btn btn-danger' href='coupons/$coupons->mainCategoryID/delete' role='button'>حذف</a>
            
                                </td>
                             </tr>";
            }
        }
    }
    // AJAX =========================================================================================================================================================

}
