<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\normalusercart;
use App\Models\productview;
use App\Models\cartview;
use App\Models\maincategories;
use App\Models\mainproducts;
use App\Models\vendor;
use App\Models\productRating;
use App\Models\productPhoto;
use App\Models\country;
use App\Models\vendorsSubscriptions;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Session;
use Illuminate\Support\Facades\Storage;



class productsController extends Controller
{
    public function getProducts()
    {
        $categories = maincategories::where(['mainCategory_vendor_id' => Session::get('website_id')])->paginate(20);

        $products = productview::where(['mainCategory_vendor_id' => Session::get('website_id')])->paginate(20);

        return view('home', ['products' => $products, 'categories' => $categories]);
    }

    public function showProduct(Request $request)
    {

        $id = $request->segment(5);
        $products = productview::with('country')->where(['mainProduct_vendor_id' => Session::get('website_id')])->with('category')->paginate(20);
        $showProductData = productview::with('country')->where(['mainProductID' => $id, 'mainProduct_vendor_id' => Session::get('website_id')])->get();
        $photos = productPhoto::where(['product_photo_product_id' => $id])->get();
        // Rating       
        $ratings = productRating::with('user')->where([
            'product_rating_product_id' => $id,
            'product_rating_vendor_id' => Session::get('website_id'),
        ])->orderBy('created_at', 'desc')->get();


        $rating1 = productRating::where([
            'product_rating_product_id' => $id,
            'product_rating_vendor_id' => Session::get('website_id'),
            'product_rating_stars' => "1",
        ])->get();
        $rating2 = productRating::where([
            'product_rating_product_id' => $id,
            'product_rating_vendor_id' => Session::get('website_id'),
            'product_rating_stars' => "2",
        ])->get();
        $rating3 = productRating::where([
            'product_rating_product_id' => $id,
            'product_rating_vendor_id' => Session::get('website_id'),
            'product_rating_stars' => "3",
        ])->get();
        $rating4 = productRating::where([
            'product_rating_product_id' => $id,
            'product_rating_vendor_id' => Session::get('website_id'),
            'product_rating_stars' => "4",
        ])->get();
        $rating5 = productRating::where([
            'product_rating_product_id' => $id,
            'product_rating_vendor_id' => Session::get('website_id'),
            'product_rating_stars' => "5",
        ])->get();
        // Rating


        return view('product', [
            'products' => $products,
            'showProductData' => $showProductData,
            'photos' => $photos,
            'ratings' => $ratings,
            'rating1' => $rating1,
            'rating2' => $rating2,
            'rating3' => $rating3,
            'rating4' => $rating4,
            'rating5' => $rating5,
        ]);
    }
    public function showCategory(Request $request)
    {
        $id = $request->segment(5);
        $categories = maincategories::where(['mainCategoryIsActivated' => "1", 'mainCategory_vendor_id' => Session::get('website_id')])->get();
        $category = maincategories::where(['mainCategoryID' => $id, 'mainCategoryIsActivated' => "1", 'mainCategory_vendor_id' => Session::get('website_id')])->get();

        if (empty($request->input('from')) && empty($request->input('to'))) {
            $categorydata = productview::where([
                'mainCategoryID' => $id,
                'mainProduct_vendor_id' => Session::get('website_id')
            ])->with('category')
                ->paginate(25);
            return view('categories', ['categorydata' => $categorydata, 'categories' => $categories, 'category' => $category]);
        } else {


            return $from = $request->input('from');
            $to = $request->input('to');

            $categorydata = productview::where([
                'mainCategoryID' => $id,
                'mainProduct_vendor_id' => Session::get('website_id')
            ])->whereBetween('mainProductPrice', [$from, $to])
                ->with('category')
                ->paginate(25);
            return view('categories', ['categorydata' => $categorydata, 'categories' => $categories, 'category' => $category, 'from' => $from, 'to' => $to]);
        }
    }
    public function productSearch(Request $request)
    {
        $query = $request->input('query');
        $results = productview::where('mainProductName', 'LIKE', "%{$query}%")
            ->orWhere('mainProductNameAr', 'LIKE', "%{$query}%")
            ->where([
                'mainProduct_vendor_id' => Session::get('website_id'),
            ])->get(); // Adjust the column and model as needed

        $formattedResults = $results->map(function ($item) {
            return [
                'name' => $item->mainProductName, // Adjust the field you want to return
                'image' => url($item->mainProductPhoto), // Adjust the field for the image URL
                'link' => route('product', ['id' => $item->mainProductID]), // Replace with your actual route name and parameters
                'price' => $item->MainProductPrices // Adjust according to your actual field for price

            ];
        });

        return response()->json($formattedResults);
    }




    // App

    public function getcategoriesApp()
    {
        // foreach ($maincategories as $maincategory) {
        // if (mainproducts::where(['mainCategoryID' => $maincategory->mainCategoryID])->get() == $maincategory->mainCategoryID) {
        //     echo json_encode("notEmpty");
        // } else {
        //     echo json_encode("Empty");
        // }
        // }
        $maincategories = maincategories::all();
        echo json_encode($maincategories);
    }

    public function getProductsCategoriesApp(Request $request)
    {


        if ($categoryid = $request->input('categoryid')) {
            if ($ProductsCategories = productview::all()->where('mainCategoryID', $categoryid)->values()) {
                echo json_encode($ProductsCategories);
            } else {
                echo json_encode("assadasdf");
            }
        } else {
            echo json_encode("0");
        }
    }

    public function getCartCountApp(Request $request)
    {
        $normalUser_id = $request->input('userid');

        $cartCount = cartview::where('normalUserCart_UserId', $normalUser_id)->count();
        echo json_encode($cartCount);
    }


    public function getAllProducts()
    {
        $AllProducts = productview::all();
        echo json_encode($AllProducts);
    }

    public function getAllProductsFromCategory(Request $request)
    {
        $AllProductsFromCategory = productview::all();
    }
    public function addtocartApp(Request $request)
    {
        $normalUserCart_UserId = $request->input("normalUserCart_UserId");
        $normalUserCart_productId = $request->input("normalUserCart_productId");
        $cartProductQuantity = $request->input("cartProductQuantity");



        for ($i = 0; $i < $cartProductQuantity; $i++) {
            $addTocartQuery = normalusercart::create([
                'normalUserCart_productId' => $normalUserCart_productId,
                'normalUserCart_UserId' => $normalUserCart_UserId,
                'normaluserCart_OrderQNT' => $cartProductQuantity == "1" ? normalusercart::where(['normalUserCart_UserId' => $normalUserCart_UserId, 'normalUserCart_productId' => $normalUserCart_productId, 'normaluserCart_Order' => 0])->get()->count() + $cartProductQuantity : $cartProductQuantity,
                'normaluserCart_Order' => "0"
            ]);
        }

        $updateToAll = normalusercart::where(['normalUserCart_UserId' => $normalUserCart_UserId, 'normalUserCart_productId' => $normalUserCart_productId, 'normaluserCart_Order' => 0])->update([
            "normaluserCart_OrderQNT" => normalusercart::where(['normalUserCart_UserId' => $normalUserCart_UserId, 'normalUserCart_productId' => $normalUserCart_productId, 'normaluserCart_Order' => 0])->get()->count()
        ]);

        //     if (normalusercart::select('normaluserCart_OrderQNT')->where(['normalUserCart_UserId'=>$normalUserCart_UserId,'normalUserCart_productId'=>$normalUserCart_productId,'normaluserCart_OrderQNT'=> 1 ,'normaluserCart_Order' => 0])) {
        //         normalusercart::where(['normalUserCart_UserId'=>$normalUserCart_UserId,'normalUserCart_productId'=>$normalUserCart_productId,'normaluserCart_OrderQNT'=> 1 ,'normaluserCart_Order' => 0])->update([
        // 'normaluserCart_OrderQNT'=>normalusercart::select('normaluserCart_OrderQNT')->where(['normalUserCart_UserId'=>$normalUserCart_UserId,'normalUserCart_productId'=>$normalUserCart_productId,'normaluserCart_OrderQNT'=> 1 ,'normaluserCart_Order' => 0])->count() + $cartProductQuantity
        //         ]);
        //     }


        if ($addTocartQuery->exists) {
            echo json_encode("added success");
        } else {
            echo json_encode("added fail");
        }
    }

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

        $productsCount = mainproducts::where(['mainProduct_vendor_id' => Session::get('vendor_id')])->count();
        $products = mainproducts::where(['mainProduct_vendor_id' => Session::get('vendor_id')])->paginate(10);
        return view('dashboard.products.products', [
            'products' => $products,
            'productsCount' => $productsCount,
            'subscription' => $subscription,

        ]);
    }

    public function productsDashboardadd()
    {
        $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')])->get();

        if ($categories->isEmpty()) {
            return redirect()->route('dashboard.productsDashboardIndex')->with(['noCategories' => 'noCategories']);
        } else {
            $countries = country::where(['country_state' => 1])->get();

            $products = mainproducts::where(['mainProduct_vendor_id' => Session::get('vendor_id')])->count();

            if ($subscription->vendors_subscriptions_Products_limit <= $products) {
                return redirect()->route('dashboard.productsDashboardIndex')->with(['problem' => 'sdfdf']);
            } else {
                return view('dashboard.products.addproduct', [
                    'categories' => $categories,
                    'countries' => $countries,
                    'subscription' => $subscription,

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

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

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


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

        $mainProductNameAr = $request->input('mainProductNameAr');
        $mainProductName = $request->input('mainProductName');
        $mainProductDescAr = $request->input('mainProductDescAr');
        $mainProductDesc = $request->input('mainProductDesc');
        $mainProductCode = $request->input('mainProductCode');
        $mainProductVendor = $request->input('mainProductVendor');
        $mainProductPrice = $request->input('mainProductPrice');
        $mainProductSale = $request->input('mainProductSale');
        $mainProductStock = $request->input('mainProductStock');
        $mainCategoryID = $request->input('mainCategoryID');
        $mainProductSearchKeywords = $request->input('mainProductSearchKeywords');
        $mainProductSEO = $request->input('mainProductSEO');
        $country_currency = $request->input('country_currency');


        if ($request->discount == "0") {

            $validate = $request->validate([
                'mainProductNameAr' => ['required'],
                'mainProductName' => ['required'],
                'mainProductCode' => ['required'],
                'mainProductPrice' => ['required'],
                'mainProductStock' => ['required'],
                'mainCategoryID' => ['required'],
            ]);


            $addQuery = mainproducts::create([
                'mainProductNameAr' => $mainProductNameAr,
                'mainProductName' => $mainProductName,
                'mainProductDescAr' => $mainProductDescAr ?? "",
                'mainProductDesc' => $mainProductDesc ?? "",
                'mainProductCode' => $mainProductCode,
                'mainProductPhoto' => $mainProductPhoto == "" ? "" : "images/products/$mainProductPhoto",
                'mainProductVendor' => "",
                'mainProductPrice' => $mainProductPrice,
                'mainProductStock' => $mainProductStock,
                'mainCategoryID' => $mainCategoryID,
                'mainProductSearchKeywords' => $mainProductSearchKeywords,
                'mainProductSEO' => $mainProductSEO,
                'mainProduct_vendor_id' => Session::get('vendor_id'),
                'mainProduct_currency' => $country_currency,
            ]);
        } else {

            $validate = $request->validate([
                'mainProductNameAr' => ['required'],
                'mainProductName' => ['required'],
                'mainProductCode' => ['required'],
                'mainProductPrice' => ['required'],
                'mainProductSale' => ['required'],
                'mainProductStock' => ['required'],
                'mainCategoryID' => ['required'],

            ]);


            $addQuery = mainproducts::create([
                'mainProductNameAr' => $mainProductNameAr,
                'mainProductName' => $mainProductName,
                'mainProductDescAr' => $mainProductDescAr ?? "",
                'mainProductDesc' => $mainProductDesc ?? "",
                'mainProductCode' => $mainProductCode,
                'mainProductPhoto' => $mainProductPhoto == "" ? "" : "images/products/$mainProductPhoto",
                'mainProductVendor' => "",
                'mainProductPrice' => $mainProductPrice,
                'mainProductSale' => $mainProductSale,
                'mainProductStock' => $mainProductStock,
                'mainCategoryID' => $mainCategoryID,
                'mainProductSearchKeywords' => $mainProductSearchKeywords,
                'mainProductSEO' => $mainProductSEO,
                'mainProduct_vendor_id' => Session::get('vendor_id'),
                'mainProduct_currency' => $country_currency,
            ]);
        }


        // Additional Images
        if ($request->hasfile('images')) {
            foreach ($request->file('images') as $image) {
                $name = time() . rand(1, 100) . '.' . $image->extension();
                $image->move(public_path('images/products'), $name);
                $imgData[] = $name;
            }


            foreach ($imgData as $img) {
                productPhoto::create([
                    'product_photo_product_id' => mainproducts::where(['mainProduct_vendor_id' => Session::get('vendor_id')])->orderBy('mainProductID', 'desc')->first()->mainProductID,
                    'product_photo_vendor_id' => Session::get('vendor_id'),
                    'mainProductPhoto' => $img == "" ? "" : "images/products/$img",
                    'product_photo_state' => "1",
                ]);
            }
            // Additional Images
        }

        if ($addQuery) {
            return redirect()->route('dashboard.productsDashboardIndex')->with(['success' => 'تم تسجيل بيانات الدورة بنجاح']);
        } else {
            return redirect()->back()->with([]);
        }
    }
    public function productsDashboardedit(Request $request)
    {
        $productid = $request->segment(4);
        $product = productview::with('category')->where(['mainProductID' => $productid])->get();
        $photos = productPhoto::where([
            'product_photo_product_id' => $productid,
            'product_photo_vendor_id' => Session::get('vendor_id')
        ])->get();

        $categories = maincategories::where(['mainCategory_vendor_id' => Session::get('vendor_id')])->get();
        return view('dashboard.products.editproduct', ['categories' => $categories, 'product' => $product, 'photos' => $photos]);
    }
    public function productsDashboardeditSuccess(Request $request)
    {
        $productid = $request->segment(4);
        $product = productview::with('category')->where(['mainProductID' => $productid])->get();

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


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

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

            $mainProductPhoto->move(('images/products'), $imageName);

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

            // Update the product's mainProductPhoto path
            $updatePhoto = mainproducts::where(['mainProductID' => $productid])->update([
                'mainProductPhoto' => "images/products/$imageName",
            ]);
        }


        $mainProductNameAr = $request->input('mainProductNameAr');
        $mainProductName = $request->input('mainProductName');
        $mainProductDescAr = $request->input('mainProductDescAr');
        $mainProductDesc = $request->input('mainProductDesc');
        $mainProductCode = $request->input('mainProductCode');
        $mainProductVendor = $request->input('mainProductVendor');
        $mainProductPrice = $request->input('mainProductPrice');
        $mainProductSale = $request->input('mainProductSale');
        $mainProductStock = $request->input('mainProductStock');
        $mainCategoryID = $request->input('mainCategoryID');
        $mainProductSearchKeywords = $request->input('mainProductSearchKeywords');
        $mainProductSEO = $request->input('mainProductSEO');

        if ($request->discount == "discount") {

            $validate = $request->validate([
                'mainProductNameAr' => ['required'],
                'mainProductName' => ['required'],
                'mainProductCode' => ['required'],
                'mainProductPrice' => ['required'],
                'mainProductStock' => ['required'],

            ]);

            $addQuery = mainproducts::where(['mainProductID' => $productid])->update([
                'mainProductNameAr' => $mainProductNameAr,
                'mainProductName' => $mainProductName,
                'mainProductDescAr' => $mainProductDescAr ?? "",
                'mainProductDesc' => $mainProductDesc ?? "",
                'mainProductCode' => $mainProductCode,
                'mainProductVendor' => "",
                'mainProductPrice' => $mainProductPrice,
                'mainProductStock' => $mainProductStock,
                'mainCategoryID' => $mainCategoryID,
                'mainProductSearchKeywords' => $mainProductSearchKeywords,
                'mainProductSEO' => $mainProductSEO,
                'mainProduct_vendor_id' => Session::get('vendor_id'),
            ]);
        } else {

            $validate = $request->validate([
                'mainProductNameAr' => ['required'],
                'mainProductName' => ['required'],
                'mainProductCode' => ['required'],
                'mainProductSale' => ['required'],
                'mainProductStock' => ['required'],

            ]);


            $addQuery = mainproducts::where(['mainProductID' => $productid])->update([
                'mainProductNameAr' => $mainProductNameAr,
                'mainProductName' => $mainProductName,
                'mainProductDescAr' => $mainProductDescAr ?? "",
                'mainProductDesc' => $mainProductDesc ?? "",
                'mainProductCode' => $mainProductCode,
                'mainProductVendor' => "",
                'mainProductPrice' => $mainProductPrice,
                'mainProductSale' => $mainProductSale,
                'mainProductStock' => $mainProductStock,
                'mainCategoryID' => $mainCategoryID,
                'mainProductSearchKeywords' => $mainProductSearchKeywords,
                'mainProductSEO' => $mainProductSEO,
                'mainProduct_vendor_id' => Session::get('vendor_id'),
            ]);
        }


        // Additional Images
        if ($request->hasfile('images')) {
            foreach ($request->file('images') as $image) {
                $name = time() . rand(1, 100) . '.' . $image->extension();
                $image->move(('images/products'), $name);
                $imgData[] = $name;
            }
            foreach ($imgData as $img) {
                productPhoto::create([
                    'product_photo_product_id' => $productid,
                    'product_photo_vendor_id' => Session::get('vendor_id'),
                    'mainProductPhoto' => $img == "" ? "" : "images/products/$img",
                    'product_photo_state' => "1",
                ]);
            }
        }

        // Additional Images

        if ($addQuery) {
            return redirect()->route('dashboard.productsDashboardIndex')->with(['success' => 'تم تسجيل بيانات الدورة بنجاح']);
        } else {
            return redirect()->back()->with([]);
        }
    }
    public function productsDashboarddelete(Request $request)
    {
        $productid = $request->segment(4);

        $studentQuery = mainproducts::where(['mainProductID' => $productid])->delete();

        return redirect()->route('dashboard.productsDashboardIndex')->with(['success' => 'تم إزالة المنتج بنجاح']);
    }
    public function productsremovePhotoDashboarddelete(Request $request)
    {
        $photoid = $request->input('photoid');

        $Query = productPhoto::where([
            'product_photo_id' => $photoid,
            'product_photo_vendor_id' => Session::get('vendor_id'),
        ])->delete();

        if ($Query) {
            return "<div class='alert alert-success' role='alert'> <svg
            xmlns='http://www.w3.org/2000/svg' width='16'
            height='16' fill='currentColor' class='bi bi-check-lg'
            viewBox='0 0 16 16'>
            <path
                d='M12.736 3.97a.733.733 0 0 1 1.047 0c.286.289.29.756.01 1.05L7.88 12.01a.733.733 0 0 1-1.065.02L3.217 8.384a.757.757 0 0 1 0-1.06.733.733 0 0 1 1.047 0l3.052 3.093 5.4-6.425z' />
        </svg></div>'";
        } else {
            return "<div class='alert alert-danger' role='alert'> <svg
            xmlns='http://www.w3.org/2000/svg' width='16'
            height='16' fill='currentColor' class='bi bi-check-lg'
            viewBox='0 0 16 16'>
            <path
                d='M12.736 3.97a.733.733 0 0 1 1.047 0c.286.289.29.756.01 1.05L7.88 12.01a.733.733 0 0 1-1.065.02L3.217 8.384a.757.757 0 0 1 0-1.06.733.733 0 0 1 1.047 0l3.052 3.093 5.4-6.425z' />
        </svg></div>'";
        }
    }

    // AJAX =========================================================================================================================================================
    public function productsSearch(Request $request)
    {
        $name = $request->input('search');
        if ($name) {
            $product = productview::where('mainProductNameAr', 'LIKE', '%' . $name . '%')
                ->orwhere('mainProductName', 'LIKE', '%' . $name . '%')->orwhere('mainProductCode', 'LIKE', '%' . $name . '%')
                ->paginate(10);

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

            foreach ($product as $products) {
                echo "<tr>
                        <th scope='row'>
    
                        <label class='control control--checkbox'>
                        <input type='checkbox'>
                        <div class='control__indicator'></div>
                        </label>
    
                        </th>
                        <td>
                                $products->mainProductID
                        </td>
                        
                        <td><img src='{{ url($products->mainProductPhoto) }}' alt='' class='img-fluid' width='10%' height='10%'></td>
                        <td>$products->mainProductNameAr</td>
                        <td>$products->mainProductPrice</td>
                        <td>
    
                        <a name='' id='' class='btn btn-success' href='Products/$products->mainProductID/edit' role='button'>تعديل</a>
                        <a name='' id='' class='btn btn-danger' href='Products/$products->mainProductID/delete' role='button'>حذف</a>
    
                        </td>
                     </tr>";
            }
        }
    }
    // AJAX =========================================================================================================================================================


    // Dashboard ===========+========================================================================================================================================================================



    // administration ===================================================================================================================================================================================
    public function productsAdministrationIndex()
    {
        $products = mainproducts::with(['vendor'])->paginate(10);
        return view('administration.products.products', ['products' => $products]);
    }

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

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

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

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


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


        $mainProductNameAr = $request->input('mainProductNameAr');
        $mainProductName = $request->input('mainProductName');
        $mainProductDescAr = $request->input('mainProductDescAr');
        $mainProductDesc = $request->input('mainProductDesc');
        $mainProductCode = $request->input('mainProductCode');
        $mainProductVendor = $request->input('mainProductVendor');
        $mainProductPrice = $request->input('mainProductPrice');
        $mainProductSale = $request->input('mainProductSale');
        $mainProductStock = $request->input('mainProductStock');
        $mainCategoryID = $request->input('mainCategoryID');
        $mainProductSearchKeywords = $request->input('mainProductSearchKeywords');
        $mainProductSEO = $request->input('mainProductSEO');
        $mainProduct_vendor_id = $request->input('mainProduct_vendor_id');


        if ($request->Subject == "school") {

            $validate = $request->validate([
                'mainProductNameAr' => ['required'],
                'mainProductName' => ['required'],
                'mainProductCode' => ['required'],
                'mainProductPrice' => ['required'],
                'mainProductStock' => ['required'],
                'mainCategoryID' => ['required'],
                'mainProductSearchKeywords' => ['required'],

            ]);


            $addQuery = mainproducts::create([
                'mainProductNameAr' => $mainProductNameAr,
                'mainProductName' => $mainProductName,
                'mainProductDescAr' => $mainProductDescAr ?? "",
                'mainProductDesc' => $mainProductDesc ?? "",
                'mainProductCode' => $mainProductCode,
                'mainProductPhoto' => $mainProductPhoto == "" ? "" : "images/products/$mainProductPhoto",
                'mainProductVendor' => $mainProductVendor,
                'mainProductPrice' => $mainProductPrice,
                'mainProductStock' => $mainProductStock,
                'mainCategoryID' => $mainCategoryID,
                'mainProductSearchKeywords' => $mainProductSearchKeywords,
                'mainProductSEO' => $mainProductSEO,
                'mainProduct_vendor_id' => $mainProduct_vendor_id,

            ]);
        } else {

            $validate = $request->validate([
                'mainProductNameAr' => ['required'],
                'mainProductName' => ['required'],
                'mainProductCode' => ['required'],
                'mainProductSale' => ['required'],
                'mainProductStock' => ['required'],
                'mainCategoryID' => ['required'],
                'mainProductSearchKeywords' => ['required'],

            ]);


            $addQuery = mainproducts::create([
                'mainProductNameAr' => $mainProductNameAr,
                'mainProductName' => $mainProductName,
                'mainProductDescAr' => $mainProductDescAr ?? "",
                'mainProductDesc' => $mainProductDesc ?? "",
                'mainProductCode' => $mainProductCode,
                'mainProductPhoto' => $mainProductPhoto == "" ? "" : "images/products/$mainProductPhoto",
                'mainProductVendor' => $mainProductVendor,
                'mainProductSale' => $mainProductSale,
                'mainProductStock' => $mainProductStock,
                'mainCategoryID' => $mainCategoryID,
                'mainProductSearchKeywords' => $mainProductSearchKeywords,
                'mainProductSEO' => $mainProductSEO,
                'mainProduct_vendor_id' => $mainProduct_vendor_id,

            ]);
        }


        if ($addQuery) {
            return redirect()->route('administration.productsAdministrationIndex')->with(['success' => 'تم تسجيل بيانات الدورة بنجاح']);
        } else {
            return redirect()->back()->with([]);
        }
    }
    public function productsAdministrationedit(Request $request)
    {
        $productid = $request->segment(4);
        $vendors = vendor::all();
        $product = mainproducts::with(['vendor'])->where(['mainProductID' => $productid])->get();
        $categories = maincategories::all();
        return view('administration.products.editproduct', ['categories' => $categories, 'product' => $product, 'vendors' => $vendors]);
    }
    public function productsAdministrationeditSuccess(Request $request)
    {
        $productid = $request->segment(4);

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

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


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


        $mainProductNameAr = $request->input('mainProductNameAr');
        $mainProductName = $request->input('mainProductName');
        $mainProductDescAr = $request->input('mainProductDescAr');
        $mainProductDesc = $request->input('mainProductDesc');
        $mainProductCode = $request->input('mainProductCode');
        $mainProductVendor = $request->input('mainProductVendor');
        $mainProductPrice = $request->input('mainProductPrice');
        $mainProductSale = $request->input('mainProductSale');
        $mainProductStock = $request->input('mainProductStock');
        $mainCategoryID = $request->input('mainCategoryID');
        $mainProductSearchKeywords = $request->input('mainProductSearchKeywords');
        $mainProductSEO = $request->input('mainProductSEO');
        $mainProduct_vendor_id = $request->input('mainProduct_vendor_id');



        $validate = $request->validate([
            'mainProductNameAr' => ['required'],
            'mainProductName' => ['required'],
            'mainProductCode' => ['required'],
            'mainProductPrice' => ['required'],
            'mainProductStock' => ['required'],
            'mainCategoryID' => ['required'],
            'mainProductSearchKeywords' => ['required'],

        ]);


        $addQuery = mainproducts::where(['mainProductID' => $productid])->update([
            'mainProductNameAr' => $mainProductNameAr,
            'mainProductName' => $mainProductName,
            'mainProductDescAr' => $mainProductDescAr ?? "",
            'mainProductDesc' => $mainProductDesc ?? "",
            'mainProductCode' => $mainProductCode,
            'mainProductPhoto' => $mainProductPhoto == "" ? "" : "images/products/$mainProductPhoto",
            'mainProductVendor' => $mainProductVendor,
            'mainProductPrice' => $mainProductPrice,
            'mainProductStock' => $mainProductStock,
            'mainCategoryID' => $mainCategoryID,
            'mainProductSearchKeywords' => $mainProductSearchKeywords,
            'mainProductSEO' => $mainProductSEO,
            'mainProduct_vendor_id' => $mainProduct_vendor_id,

        ]);


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

        $studentQuery = mainproducts::where(['mainProductID' => $productid])->delete();

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

    // AJAX =========================================================================================================================================================
    public function productsAdministrationSearch(Request $request)
    {
        $name = $request->input('search');
        if ($name) {
            $product = productview::where('mainProductNameAr', 'LIKE', '%' . $name . '%')
                ->orwhere('mainProductName', 'LIKE', '%' . $name . '%')->orwhere('mainProductCode', 'LIKE', '%' . $name . '%')
                ->paginate(10);

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

            foreach ($product as $products) {
                echo "<tr>
                            <th scope='row'>
        
                            <label class='control control--checkbox'>
                            <input type='checkbox'>
                            <div class='control__indicator'></div>
                            </label>
        
                            </th>
                            <td>
                                    $products->mainProductID
                            </td>
                            
                            <td><img src='{{ url($products->mainProductPhoto) }}' alt='' class='img-fluid' width='10%' height='10%'></td>
                            <td>$products->mainProductNameAr</td>
                            <td>$products->mainProductPrice</td>
                            <td>
        
                            <a name='' id='' class='btn btn-success' href='Products/$products->mainProductID/edit' role='button'>تعديل</a>
                            <a name='' id='' class='btn btn-danger' href='Products/$products->mainProductID/delete' role='button'>حذف</a>
        
                            </td>
                         </tr>";
            }
        }
    }
    // AJAX =========================================================================================================================================================

    // administration ===================================================================================================================================================================================

}
