<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\banner;
use App\Models\maincategories;
use App\Models\vendorsSubscriptions;
use Illuminate\Support\Facades\Session;

class BannerController extends Controller
{
    // App ======================================================================================================================

    public function categoriesbannersDashboardIndex()
    {
        $subscription =  vendorsSubscriptions::with(['subscription'])->where([
            'vendors_subscriptions_vendor_id' => Session::get('vendor_id'),
            'vendors_subscriptions_State' => 1,
        ])->first();

        $banner = banner::where(['banner_vendor_id' => Session::get('vendor_id')])->paginate(10);
        return view('dashboard.categoriesbanners.banners', ['banners' => $banner, 'subscription' => $subscription]);
    }

    public function categoriesbannersDashboardadd()
    {
        $subscription =  vendorsSubscriptions::with(['subscription'])->where([
            'vendors_subscriptions_vendor_id' => Session::get('vendor_id'),
            'vendors_subscriptions_State' => 1,
        ])->first();

        $banners = banner::where(['banner_vendor_id' => Session::get('vendor_id')])->count();

        if ($subscription->vendors_subscriptions_Categoriesbanners_limit <= $banners) {
            return redirect()->route('dashboard.categoriesbannersDashboardIndex')->with(['problem' => 'تم تسجيل بيانات الحساب بنجاح']);
        } else {
            $maincategories = maincategories::where(['mainCategory_vendor_id' => Session::get('vendor_id')])->get();
            return view('dashboard.categoriesbanners.addbanner', ['maincategories' => $maincategories]);
        }
    }
    public function categoriesbannersDashboardaddSuccess(Request $request)
    {
        $subscription =  vendorsSubscriptions::with(['subscription'])->where([
            'vendors_subscriptions_vendor_id' => Session::get('vendor_id'),
            'vendors_subscriptions_State' => 1,
        ])->first();

        $banners = banner::where(['banner_vendor_id' => Session::get('vendor_id')])->count();

        if ($subscription->vendors_subscriptions_Categoriesbanners_limit <= $banners) {
            return redirect()->route('dashboard.categoriesbannersDashboardIndex')->with(['problem' => 'تم تسجيل بيانات الحساب بنجاح']);
        } else {

            if ($request->file('banner_photo')) {

                $request->validate([
                    'banner_photo' => 'required|mimes:jpeg,bmp,png,jpg'
                ]);


                $banner_photo = time() . '.' . $request->banner_photo->extension();
                $request->banner_photo->move(public_path('images/banner'), $banner_photo);
            } else {
                $banner_photo = "";
            }


            $banner_titleEN = $request->input('banner_titleEN');
            $banner_titleAR = $request->input('banner_titleAR');
            $mainCategoryID = $request->input('mainCategoryID');



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


            $addQuery = banner::create([
                'banner_titleEN' => $banner_titleEN,
                'banner_titleAR' => $banner_titleAR,
                'banner_photo' => $banner_photo == "" ? "" : "images/banner/$banner_photo",
                'banner_vendor_id' => Session::get('vendor_id'),
                'maincategories_id' => $mainCategoryID,
            ]);


            if ($addQuery) {
                return redirect()->route('dashboard.categoriesbannersDashboardIndex')->with(['success' => 'تم تسجيل بيانات الدورة بنجاح']);
            } else {
                return redirect()->back()->with([]);
            }
        }
    }
    public function categoriesbannersDashboardedit(Request $request)
    {
        $bannerid = $request->segment(4);
        $banner = banner::with('category')->where(['banner_id' => $bannerid])->get();
        $category = maincategories::where('mainCategoryID', $banner[0]->maincategories_id)->get();
        $maincategories = maincategories::where(['mainCategory_vendor_id' => Session::get('vendor_id')])->get();
        return view('dashboard.categoriesbanners.editbanner', ['banner' => $banner, 'maincategories' => $maincategories, 'category' => $category]);
    }
    public function categoriesbannersDashboardeditSuccess(Request $request)
    {
        $bannerid = $request->segment(4);
        $banner = banner::with('category')->where(['banner_id' => $bannerid])->get();

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


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

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

                $banner_photo->move(('images/banner'), $imageName);

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

                // Update the category's banner_photo path
                $updatePhoto = banner::where(['banner_id' => $bannerid])->update([
                    'banner_photo' => "images/banner/$imageName",
                ]);
          
        }


        $banner_titleEN = $request->input('banner_titleEN');
        $banner_titleAR = $request->input('banner_titleAR');
        $mainCategoryID = $request->input('mainCategoryID');


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

        $addQuery = banner::where(['banner_id' => $bannerid])->update([
            'banner_titleEN' => $banner_titleEN,
            'banner_titleAR' => $banner_titleAR,
            'banner_vendor_id' => Session::get('vendor_id'),
            'maincategories_id' => $mainCategoryID,
        ]);


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

    public function categoriesbannersDashboarddelete(Request $request)
    {
        $categoryid = $request->segment(4);

        $studentQuery = banner::where(['banner_id' => $categoryid])->delete();

        return redirect()->route('dashboard.categoriesbannersDashboardIndex')->with(['success' => 'تم إزالة البانر بنجاح']);
    }
    // AJAX =========================================================================================================================================================
    public function categoriesbannersSearch(Request $request)
    {
        $name = $request->input('search');
        if ($name) {
            $category =  banner::where('CategoryNameAr', 'LIKE', '%' . $name . '%')
                ->orwhere('CategoryName', 'LIKE', '%' . $name . '%')->orwhere('CategorySEO', 'LIKE', '%' . $name . '%')
                ->paginate(10);

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

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