<?php

namespace App\Http\Controllers;

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

class CategoriesController extends Controller
{
    // App ======================================================================================================================
    public function categoryChecker(Request $request)
    {
        $categoryid = $request->input('categoryid');
        if (mainproducts::select('mainCategoryID')->where(['mainCategoryID' => $categoryid])->value('mainCategoryID') == $categoryid) {
            echo json_encode("notEmpty");
        } else {
            echo json_encode("Empty");
        }
    }

    // App ======================================================================================================================

    // Web ======================================================================================================================
    public function allcategories(Request $request)
    {
        $allcategories = maincategories::where(['mainCategoryIsActivated' => "1", 'mainCategory_vendor_id' => Session::get('website_id')])->paginate(10);

        return view('allcategories', ['allcategories' => $allcategories]);
    }

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


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

        $categories = maincategories::where(['mainCategory_vendor_id' => Session::get('vendor_id')])->paginate(10);
        return view('dashboard.categories.categories', ['categories' => $categories, 'subscription' => $subscription]);
    }

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

        $categories = maincategories::where(['mainCategory_vendor_id' => Session::get('vendor_id')])->count();

        if ($subscription->vendors_subscriptions_Categories_limit <= $categories) {
            Session::flash('problem', 'Your data has been saved successfully!');
            return redirect()->route('dashboard.categoriesDashboardIndex');
        } else {
            $categories = maincategories::where(['mainCategory_vendor_id' => Session::get('vendor_id')])->get();
            return view('dashboard.categories.addcategory', ['categories' => $categories, 'subscription' => $subscription]);
        }
    }
    public function categoriesDashboardaddSuccess(Request $request)
    {

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

        $mainCategoryName = $request->input('mainCategoryName');
        $mainCategoryNameAr = $request->input('mainCategoryNameAr');
        $mainCategorySEO = $request->input('mainCategorySEO');



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


        $addQuery = maincategories::create([
            'mainCategoryName' => $mainCategoryName,
            'mainCategoryNameAr' => $mainCategoryNameAr,
            'mainCategorySEO' => $mainCategorySEO ?? "",
            'mainCategory_vendor_id' => Session::get('vendor_id'),
            'mainCategoryIsActivated' => 1,

        ]);

        $categoryid = maincategories::where(['mainCategory_vendor_id' => Session::get('vendor_id'),])->max("mainCategoryID");

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

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

            $mainCategoryPhoto->move(('images/categories'), $imageName);

            // Update the admin's mainCategoryPhoto path
            $updatePhoto = maincategories::where(['mainCategoryID' => $categoryid])->update([
                'mainCategoryPhoto' => "images/categories/$imageName",
            ]);
        }



        if ($addQuery) {
            return redirect()->route('dashboard.categoriesDashboardIndex')->with(['success' => 'تم تسجيل بيانات الدورة بنجاح']);
        } else {
            return redirect()->back()->with([]);
        }
    }
    public function categoriesDashboardedit(Request $request)
    {
        $categoryid = $request->categoryid;
        $category = maincategories::where(['mainCategoryID' => $categoryid])->get();
        $categories = maincategories::all();
        return view('dashboard.categories.editcategory', ['categories' => $categories, 'category' => $category]);
    }
    public function categoriesDashboardeditSuccess(Request $request)
    {
        $categoryid = $request->categoryid;
        $category = maincategories::where(['mainCategoryID' => $categoryid])->get();

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


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

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

            $mainCategoryPhoto->move(('images/categories'), $imageName);

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

            // Update the category's maincategoryPhoto path
            $updatePhoto = maincategories::where(['maincategoryID' => $categoryid])->update([
                'mainCategoryPhoto' => "images/categories/$imageName",
            ]);
        }




        $mainCategoryName = $request->input('mainCategoryName');
        $mainCategoryNameAr = $request->input('mainCategoryNameAr');
        $mainCategorySEO = $request->input('mainCategorySEO');



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


        $addQuery = maincategories::where(['maincategoryID' => $categoryid])->update([
            'mainCategoryName' => $mainCategoryName,
            'mainCategoryNameAr' => $mainCategoryNameAr,
            'mainCategorySEO' => $mainCategorySEO ?? "",
            'mainCategory_vendor_id' => Session::get('vendor_id'),

        ]);


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

    public function categoriesDashboarddelete(Request $request)
    {
        $categoryid = $request->categoryid;

        $studentQuery = maincategories::where(['mainCategoryID' => $categoryid])->delete();

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



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

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

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



    // Administration ======================================================================================================================
    public function categoriesAdministrationIndex()
    {
        $categories = maincategories::with(['vendor'])->paginate(10);
        return view('administration.categories.categories', ['categories' => $categories]);
    }

    public function categoriesAdministrationadd()
    {
        $categories = maincategories::all();
        $vendors = vendor::all();

        return view('administration.categories.addcategory', ['categories' => $categories, 'vendors' => $vendors]);
    }
    public function categoriesAdministrationaddSuccess(Request $request)
    {

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

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


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


        $mainCategoryName = $request->input('mainCategoryName');
        $mainCategoryNameAr = $request->input('mainCategoryNameAr');
        $mainCategorySEO = $request->input('mainCategorySEO');
        $mainCategory_vendor_id = $request->input('mainCategory_vendor_id');

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


        $addQuery = maincategories::create([
            'mainCategoryName' => $mainCategoryName,
            'mainCategoryNameAr' => $mainCategoryNameAr,
            'mainCategoryPhoto' => $mainCategoryPhoto == "" ? "" : "images/categories/$mainCategoryPhoto",
            'mainCategorySEO' => $mainCategorySEO ?? "",
            'mainCategory_vendor_id' => $mainCategory_vendor_id,
        ]);


        if ($addQuery) {
            return redirect()->route('administration.categoriesAdministrationIndex')->with(['success' => 'تم تسجيل بيانات الدورة بنجاح']);
        } else {
            return redirect()->back()->with([]);
        }
    }
    public function categoriesAdministrationedit(Request $request)
    {
        $categoryid = $request->segment(4);
        $vendors = vendor::all();

        $category = maincategories::with(['vendor'])->where(['mainCategoryID' => $categoryid])->get();
        $categories = maincategories::with(['vendor'])->get();
        return view('administration.categories.editcategory', ['categories' => $categories, 'category' => $category, 'vendors' => $vendors]);
    }
    public function categoriesAdministrationeditSuccess(Request $request)
    {
        $categoryid = $request->segment(4);

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

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


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


        $mainCategoryName = $request->input('mainCategoryName');
        $mainCategoryNameAr = $request->input('mainCategoryNameAr');
        $mainCategorySEO = $request->input('mainCategorySEO');
        $mainCategory_vendor_id = $request->input('mainCategory_vendor_id');

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


        $addQuery = maincategories::where(['mainCategoryID' => $categoryid])->update([
            'mainCategoryName' => $mainCategoryName,
            'mainCategoryNameAr' => $mainCategoryNameAr,
            'mainCategoryPhoto' => $mainCategoryPhoto == "" ? "" : "images/categories/$mainCategoryPhoto",
            'mainCategorySEO' => $mainCategorySEO ?? "",
            'mainCategory_vendor_id' => $mainCategory_vendor_id,
        ]);


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

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

        $studentQuery = maincategories::where(['mainCategoryID' => $categoryid])->delete();

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



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

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

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

}
