<?php

namespace App\Http\Controllers\RestAPI\v4;

use App\Http\Controllers\Controller;
use App\Models\Brand;
use App\Models\Category;
use App\Models\FlashDeal;
use App\Models\FlashDealProduct;
use App\Models\MostDemanded;
use App\Models\Order;
use App\Models\OrderDetail;
use App\Models\Product;
use App\Models\Review;
use App\Models\ShippingMethod;
use App\Models\Translation;
use App\Models\Wishlist;
use App\Utils\CategoryManager;
use App\Utils\Helpers;
use App\Utils\ImageManager;
use App\Utils\ProductManager;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Validator;

class ProductController extends Controller
{
    public function get_latest_products(Request $request)
    {
        $products = ProductManager::get_latest_products($request, $request['limit'], $request['offset']);
        $products['products'] = Helpers::product_data_formatting($products['products'], true);
        return response()->json($products, 200);
    }

    public function get_featured_products(Request $request)
    {
        $products = ProductManager::get_featured_products($request, $request['limit'], $request['offset']);
        $products['products'] = Helpers::product_data_formatting($products['products'], true);
        return response()->json($products, 200);
    }

    public function get_top_rated_products(Request $request)
    {
        $products = ProductManager::get_top_rated_products($request, $request['limit'], $request['offset']);
        $products['products'] = Helpers::product_data_formatting($products['products'], true);
        return response()->json($products, 200);
    }

    public function get_searched_products(Request $request)
    {
        $user = Helpers::get_customer($request);

        $porduct_data = Product::active()->with([
            'flashDealProducts.flashDeal',
            'reviews', 'rating',
            'seller.shop',
            'wishList' => function ($query) use ($request) {
                return $query->where('customer_id', $request->user()->id ?? 0);
            },
            'compareList' => function ($query) use ($request) {
                return $query->where('user_id', $request->user()->id ?? 0);
            }
        ])
            ->withCount('reviews')
            ->withCount(['wishList' => function ($query) use ($user) {
                $query->where('customer_id', $user != 'offline' ? $user->id : '0');
            }])
            ->when($request->has('seller_id'), function ($query) use ($request) {
                $sellerId = $request['seller_id'] == '0' ? 1 : $request['seller_id'];
                $addedBy = $request['seller_id'] == '0' ? 'admin' : 'seller';
                return $query->where(['user_id' => $sellerId, 'added_by' => $addedBy]);
            })
            ->when($request['data_from'] == 'category', function ($query) use ($request) {
                $query->where('category_id', $request['id'])
                    ->orWhere('sub_category_id', $request['id'])
                    ->orWhere('sub_sub_category_id', $request['id']);
            })
            ->when($request->has('category') && $request['category'] != 'all', function ($query) use ($request) {
                $query->where('category_id', $request['id'])
                    ->orWhere('sub_category_id', $request['id'])
                    ->orWhere('sub_sub_category_id', $request['id']);
            })
            ->when($request['data_from'] == 'brand', function ($query) use ($request) {
                $query->where('brand_id', $request['id']);
            })
            ->when(!$request->has('data_from') || $request['data_from'] == 'latest', function ($query) {
                return $query;
            });

        $query = $porduct_data;
        if ($request['data_from'] == 'top-rated') {
            $reviews = Review::select('product_id', DB::raw('AVG(rating) as count'))
                ->groupBy('product_id')
                ->orderBy("count", 'desc')->get();
            $product_ids = [];
            foreach ($reviews as $review) {
                array_push($product_ids, $review['product_id']);
            }
            $query = $porduct_data->whereIn('id', $product_ids);
        }

        if ($request['data_from'] == 'best-selling') {
            $details = OrderDetail::with('product')
                ->select('product_id', DB::raw('COUNT(product_id) as count'))
                ->groupBy('product_id')
                ->orderBy("count", 'desc')
                ->get();
            $product_ids = [];
            foreach ($details as $detail) {
                array_push($product_ids, $detail['product_id']);
            }
            $query = $porduct_data->whereIn('id', $product_ids);
        }

        if ($request['data_from'] == 'most-favorite') {
            $details = Wishlist::with('product')
                ->select('product_id', DB::raw('COUNT(product_id) as count'))
                ->groupBy('product_id')
                ->orderBy("count", 'desc')
                ->get();
            $product_ids = [];
            foreach ($details as $detail) {
                array_push($product_ids, $detail['product_id']);
            }
            $query = $porduct_data->whereIn('id', $product_ids);
        }

        if ($request['data_from'] == 'featured') {
            $query = Product::with([
                    'flashDealProducts.flashDeal',
                    'reviews', 'seller.shop',
                    'wishList' => function ($query) use ($request) {
                        return $query->where('customer_id', $request->user()->id ?? 0);
                    },
                    'compareList' => function ($query) use ($request) {
                        return $query->where('user_id', $request->user()->id ?? 0);
                    }
                ])
                ->withCount('reviews')->active()->where('featured', 1);
        }

        if ($request['data_from'] == 'featured_deal') {
            $featured_deal_id = FlashDeal::where(['status' => 1])->where(['deal_type' => 'feature_deal'])->pluck('id')->first();
            $featured_deal_product_ids = FlashDealProduct::where('flash_deal_id', $featured_deal_id)->pluck('product_id')->toArray();
            $query = Product::with([
                'flashDealProducts.flashDeal',
                'reviews', 'seller.shop',
                'wishList' => function ($query) use ($request) {
                    return $query->where('customer_id', $request->user()->id ?? 0);
                },
                'compareList' => function ($query) use ($request) {
                    return $query->where('user_id', $request->user()->id ?? 0);
                }
            ])->withCount('reviews')->active()->whereIn('id', $featured_deal_product_ids);
        }

        if ($request['data_from'] == 'discounted') {
            $query = Product::with([
                'flashDealProducts.flashDeal',
                'reviews', 'seller.shop',
                'wishList' => function ($query) use ($request) {
                    return $query->where('customer_id', $request->user()->id ?? 0);
                },
                'compareList' => function ($query) use ($request) {
                    return $query->where('user_id', $request->user()->id ?? 0);
                }
            ])->withCount('reviews')->active()->where('discount', '!=', 0);
        }

        if ($request->has('search_category') && $request['search_category'] != 'all') {
            $products = $porduct_data->get();
            $product_ids = [];
            foreach ($products as $product) {
                foreach (json_decode($product['category_ids'], true) as $category) {
                    if ($category['id'] == $request['search_category']) {
                        array_push($product_ids, $product['id']);
                    }
                }
            }
            $query = $porduct_data->whereIn('id', $product_ids);
        }

        if ($request['data_from'] == 'search') {
            $key = explode(' ', $request['name']);
            $product_ids = Product::with([
                'flashDealProducts.flashDeal',
                'seller.shop',
                'wishList' => function ($query) use ($request) {
                    return $query->where('customer_id', $request->user()->id ?? 0);
                },
                'compareList' => function ($query) use ($request) {
                    return $query->where('user_id', $request->user()->id ?? 0);
                }
            ])
                ->withCount('reviews')
                ->when($request->has('seller_id'), function ($query) use ($request) {
                    $sellerId = $request['seller_id'] == '0' ? 1 : $request['seller_id'];
                    $addedBy = $request['seller_id'] == '0' ? 'admin' : 'seller';
                    return $query->where(['user_id' => $sellerId, 'added_by' => $addedBy]);
                })
                ->where(function ($q) use ($key) {
                    foreach ($key as $value) {
                        $q->orWhere('name', 'like', "%{$value}%")
                            ->orWhereHas('tags', function ($query) use ($value) {
                                $query->where('tag', 'like', "%{$value}%");
                            });
                    }
                })->pluck('id');

            if ($product_ids->count() == 0) {
                $product_ids = Translation::where('translationable_type', 'App\Models\Product')
                    ->where('key', 'name')
                    ->where(function ($q) use ($key) {
                        foreach ($key as $value) {
                            $q->orWhere('value', 'like', "%{$value}%");
                        }
                    })
                    ->pluck('translationable_id');
            }

            $query = $porduct_data->WhereIn('id', $product_ids);
        }

        $fetched = $query->when($request->has('sort_by') && !empty($request->sort_by), function ($query) use ($request) {
            $query->when($request['sort_by'] == 'low-high', function ($query) {
                return $query->orderBy('unit_price', 'ASC');
            })
                ->when($request['sort_by'] == 'high-low', function ($query) {
                    return $query->orderBy('unit_price', 'DESC');
                })
                ->when($request['sort_by'] == 'a-z', function ($query) {
                    return $query->orderBy('name', 'ASC');
                })
                ->when($request['sort_by'] == 'z-a', function ($query) {
                    return $query->orderBy('name', 'DESC');
                })
                ->when($request['sort_by'] == '', function ($query) {
                    return $query->latest();
                });
        })->latest();

        $common_query = $fetched;

        $rating_1 = 0;
        $rating_2 = 0;
        $rating_3 = 0;
        $rating_4 = 0;
        $rating_5 = 0;

        foreach ($common_query->get() as $rating) {
            if (isset($rating->rating[0]['average']) && ($rating->rating[0]['average'] > 0 && $rating->rating[0]['average'] < 2)) {
                $rating_1 += 1;
            } elseif (isset($rating->rating[0]['average']) && ($rating->rating[0]['average'] >= 2 && $rating->rating[0]['average'] < 3)) {
                $rating_2 += 1;
            } elseif (isset($rating->rating[0]['average']) && ($rating->rating[0]['average'] >= 3 && $rating->rating[0]['average'] < 4)) {
                $rating_3 += 1;
            } elseif (isset($rating->rating[0]['average']) && ($rating->rating[0]['average'] >= 4 && $rating->rating[0]['average'] < 5)) {
                $rating_4 += 1;
            } elseif (isset($rating->rating[0]['average']) && ($rating->rating[0]['average'] == 5)) {
                $rating_5 += 1;
            }
        }
        $ratings = [
            'rating_1' => $rating_1,
            'rating_2' => $rating_2,
            'rating_3' => $rating_3,
            'rating_4' => $rating_4,
            'rating_5' => $rating_5,
        ];

        $maximumProductPrice = $common_query->max('unit_price');

        $products = $common_query->paginate($request['limit'], ['*'], 'page', $request['offset']);
        $currentDate = date('Y-m-d H:i:s');
        $products?->map(function ($product) use ($currentDate) {
            $flashDealStatus = 0;
            $flashDealEndDate = 0;
            if (count($product->flashDealProducts) > 0) {
                $flashDeal = null;
                foreach ($product->flashDealProducts as $flashDealData) {
                    if ($flashDealData->flashDeal) {
                        $flashDeal = $flashDealData->flashDeal;
                    }
                }
                if ($flashDeal) {
                    $startDate = date('Y-m-d H:i:s', strtotime($flashDeal->start_date));
                    $endDate = date('Y-m-d H:i:s', strtotime($flashDeal->end_date));
                    $flashDealStatus = $flashDeal->status == 1 && (($currentDate >= $startDate) && ($currentDate <= $endDate)) ? 1 : 0;
                    $flashDealEndDate = $flashDeal->end_date;
                }
            }
            $product['flash_deal_status'] = $flashDealStatus;
            $product['flash_deal_end_date'] = $flashDealEndDate;
            return $product;
        });
        $products_final = Helpers::product_data_formatting($products, true);

        $categories = Category::withCount(['product' => function ($query) use ($request) {
            $query->active()
                ->when($request->has('seller_id'), function ($query) use ($request) {
                    $sellerId = $request['seller_id'] == '0' ? 1 : $request['seller_id'];
                    $addedBy = $request['seller_id'] == '0' ? 'admin' : 'seller';
                    return $query->where(['user_id' => $sellerId, 'added_by' => $addedBy]);
                });
        }])->with(['childes' => function ($query) {
            $query->with(['childes' => function ($query) {
                $query->withCount(['subSubCategoryProduct'])->where('position', 2);
            }])->withCount(['subSubCategoryProduct'])->where('position', 1);
        }, 'childes.childes'])
            ->whereHas('product', function ($query) use ($request) {
                $query->active()
                    ->when($request->has('seller_id'), function ($query) use ($request) {
                        $sellerId = $request['seller_id'] == '0' ? 1 : $request['seller_id'];
                        $addedBy = $request['seller_id'] == '0' ? 'admin' : 'seller';
                        return $query->where(['user_id' => $sellerId, 'added_by' => $addedBy]);
                    });
            })
            ->where('position', 0)->get();
        // Categories End

        $brands = Brand::active()->withCount(['brandProducts' => function ($query) use ($request) {
            return $query->when($request->has('seller_id'), function ($query) use ($request) {
                $sellerId = $request['seller_id'] == '0' ? 1 : $request['seller_id'];
                $addedBy = $request['seller_id'] == '0' ? 'admin' : 'seller';
                $query->where(['user_id' => $sellerId, 'added_by' => $addedBy]);
            });
        }])->latest()->get();

        return [
            'total_size' => $products->total(),
            'limit' => $request['limit'],
            'offset' => $request['offset'],
            'products' => $products_final,
            'brands' => $brands,
            'category' => $categories,
            'rating' => $ratings,
            'maximum_product_price' => $maximumProductPrice,
        ];
    }

    public function product_filter(Request $request)
    {
        $categories = $request->category ?? [];
        $selected_category = [];
        if ($request->has('category') && count($request->category) > 0) {
            foreach ($categories as $category) {
                $cat_info = Category::where('id', $category)->first();
                $index = $cat_info ? array_search($cat_info->parent_id, $categories) : false;
                if ($index !== false) {
                    array_splice($categories, $index, 1);
                }
            }
            $selected_category = Category::whereIn('id', $request->category)
                ->select('id', 'name')
                ->get();
        }

        $selected_brands = [];
        if ($request->has('brand') && count($request->brand) > 0) {
            $selected_brands = Brand::whereIn('id', $request->brand)->select('id', 'name')->get();
        }
        $rating = $request->rating ?? [];

        // products search
        $products_query = Product::active()->with(['seller.shop', 'reviews', 'rating', 'flashDealProducts.flashDeal', 'wishList' => function ($query) use ($request) {
            return $query->where('customer_id', $request->user()->id ?? 0);
        }, 'compareList' => function ($query) use ($request) {
            return $query->where('user_id', $request->user()->id ?? 0);
        }])
            ->withCount('reviews')
            ->when(isset($request->shop_id) && $request->shop_id == '0', function ($query) {
                return $query->where(['added_by' => 'admin']);
            })
            ->when(isset($request->shop_id) && $request->shop_id != '0', function ($query) use ($request) {
                return $query->where(['added_by' => 'seller', 'user_id' => $request->shop_id]);
            })
            ->when($request->has('brand') && count($request->brand) > 0, function ($query) use ($request) {
                return $query->whereIn('brand_id', $request->brand);
            })
            ->when($request->has('category') && count($request->category) > 0, function ($query) use ($categories) {
                return $query->whereIn('category_id', $categories)
                    ->orWhereIn('sub_category_id', $categories)
                    ->orWhereIn('sub_sub_category_id', $categories);
            })
            ->when($request->has('sort_by') && !empty($request->sort_by), function ($query) use ($request) {
                $query->when($request['sort_by'] == 'low-high', function ($query) {
                    return $query->orderBy('unit_price', 'ASC');
                })
                    ->when($request['sort_by'] == 'high-low', function ($query) {
                        return $query->orderBy('unit_price', 'DESC');
                    })
                    ->when($request['sort_by'] == 'a-z', function ($query) {
                        return $query->orderBy('name', 'ASC');
                    })
                    ->when($request['sort_by'] == 'z-a', function ($query) {
                        return $query->orderBy('name', 'DESC');
                    });
            })
            ->when(!empty($request['price_min']) || !empty($request['price_max']), function ($query) use ($request) {
                return $query->whereBetween('unit_price', [Helpers::convert_manual_currency_to_usd($request['price_min'], $request['currency']), Helpers::convert_manual_currency_to_usd($request['price_max'], $request['currency'])]);
            })
            ->when(!empty($request->colors), function ($query) use ($request) {
                return $query->where(function ($query) use ($request) {
                    foreach ($request->colors as $color) {
                        $query->orWhere('colors', 'like', '%' . $color . '%');
                    }
                });
            })
            ->when(!empty($request->rating), function ($query) use ($request) {
                $query->with(['rating'])->whereHas('rating', function ($query) use ($request) {
                    return $query;
                });
            })
            ->when(isset($request->name) && $request->name, function ($query) use ($request) {
                $query->where('name', 'like', "%{$request['name']}%")
                    ->orWhereHas('tags', function ($query) use ($request) {
                        $query->where('tag', 'like', "%{$request['name']}%");
                    });;
            })
            ->when(isset($request->data_from) && $request->data_from == 'featured', function ($query) use ($request) {
                $query->where('featured', 1);
            })
            ->when(isset($request->data_from) && $request->data_from == 'discounted', function ($query) use ($request) {
                $query->where('discount', '!=', 0);
            });

        if ($request->data_from == 'top-rated') {
            $reviews = Review::select('product_id', DB::raw('AVG(rating) as count'))
                ->groupBy('product_id')
                ->orderBy("count", 'desc')->get();
            $product_ids = [];
            foreach ($reviews as $review) {
                $product_ids[] = $review['product_id'];
            }
            $products_query = $products_query->whereIn('id', $product_ids);
        }

        if ($request->data_from == 'best-selling') {
            $details = OrderDetail::with('product')
                ->select('product_id', DB::raw('COUNT(product_id) as count'))
                ->groupBy('product_id')
                ->orderBy("count", 'desc')
                ->get();
            $product_ids = [];
            foreach ($details as $detail) {
                $product_ids[] = $detail['product_id'];
            }
            $products_query = $products_query->whereIn('id', $product_ids);
        }

        if ($request->data_from == 'most-favorite') {
            $details = Wishlist::with('product')
                ->select('product_id', DB::raw('COUNT(product_id) as count'))
                ->groupBy('product_id')
                ->orderBy("count", 'desc')
                ->get();
            $product_ids = [];
            foreach ($details as $detail) {
                $product_ids[] = $detail['product_id'];
            }
            $products_query = $products_query->whereIn('id', $product_ids);
        }

        if ($request->data_from == 'featured_deal') {
            $featured_deal_id = FlashDeal::where(['status' => 1])->where(['deal_type' => 'feature_deal'])->pluck('id')->first();
            $featured_deal_product_ids = FlashDealProduct::where('flash_deal_id', $featured_deal_id)->pluck('product_id')->toArray();
            $products_query = $products_query->whereIn('id', $featured_deal_product_ids);
        }

        if ($request->data_from == 'latest') {
            $products_query = $products_query->latest();
        }

        if ($request->has('rating') && $request->rating) {
            $products_query = $products_query->get()->each(function ($item) {
                if (isset($item->rating) && count($item->rating) != 0) {
                    $item->rating_avg = (int) ($item->rating[0]['average'] ?? 0);
                } else {
                    $item->rating_avg = 0;
                }
            });

            $products_query = $products_query->whereIn('rating_avg', (array) $request->rating);
            $products = $products_query->take($request['limit'])->paginate($request['limit']);
        }else{
            $products = $products_query->paginate($request['limit'], ['*'], 'page', $request['offset']);
        }

        $currentDate = date('Y-m-d H:i:s');
        $products?->map(function ($product) use ($currentDate) {
            $flashDealStatus = 0;
            $flashDealEndDate = 0;
            if (count($product->flashDealProducts) > 0) {
                $flashDeal = null;
                foreach ($product->flashDealProducts as $flashDealData) {
                    if ($flashDealData->flashDeal) {
                        $flashDeal = $flashDealData->flashDeal;
                    }
                }
                if ($flashDeal) {
                    $startDate = date('Y-m-d H:i:s', strtotime($flashDeal->start_date));
                    $endDate = date('Y-m-d H:i:s', strtotime($flashDeal->end_date));
                    $flashDealStatus = $flashDeal->status == 1 && (($currentDate >= $startDate) && ($currentDate <= $endDate)) ? 1 : 0;
                    $flashDealEndDate = $flashDeal->end_date;
                }
            }
            $product['flash_deal_status'] = $flashDealStatus;
            $product['flash_deal_end_date'] = $flashDealEndDate;
            return $product;
        });


        return [
            'total_size' => $products->total(),
            'limit' => $request['limit'],
            'offset' => $request['offset'],
            'products' => Helpers::product_data_formatting($products->items(), true),
            'selected_brands' => $selected_brands,
            'selected_category' => $selected_category,
        ];
    }

    public function get_product(Request $request, $slug)
    {
        $user = Helpers::get_customer($request);

        $product = Product::with(['reviews.customer', 'seller.shop', 'tags'])
            ->withCount(['reviews','wishList' => function ($query) use ($user) {
                $query->where('customer_id', $user != 'offline' ? $user->id : '0');
            }])
            ->where(['slug' => $slug])
            ->first();
        if (isset($product)) {
            $product = Helpers::product_data_formatting($product, false);

            if (isset($product->reviews) && !empty($product->reviews)) {
                $overallRating = getOverallRating($product->reviews);
                $product['average_review'] = $overallRating[0];
            } else {
                $product['average_review'] = 0;
            }

            $product_reviews_count = $product->reviews->count();
            $ratting_status_positive = $product->reviews ? $product->reviews->where('rating', '>=', 4)->count() : 0;
            $ratting_status_good = $product->reviews ? $product->reviews->where('rating', 3)->count() : 0;
            $ratting_status_neutral = $product->reviews ? $product->reviews->where('rating', 2)->count() : 0;
            $ratting_status_negative = $product->reviews ? $product->reviews->where('rating', '=', 1)->count() : 0;
            $ratting_status = [
                'positive' => $ratting_status_positive,
                'good' => $ratting_status_good,
                'neutral' => $ratting_status_neutral,
                'negative' => $ratting_status_negative,
                'total_review_count' => $product_reviews_count,
            ];

            $temporary_close = Helpers::get_business_settings('temporary_close');
            $inhouse_vacation = Helpers::get_business_settings('vacation_add');
            $inhouse_vacation_start_date = $product['added_by'] == 'admin' ? $inhouse_vacation['vacation_start_date'] : null;
            $inhouse_vacation_end_date = $product['added_by'] == 'admin' ? $inhouse_vacation['vacation_end_date'] : null;
            $inhouse_temporary_close = $product['added_by'] == 'admin' ? $temporary_close['status'] : false;
            $product['inhouse_vacation_start_date'] = $inhouse_vacation_start_date;
            $product['inhouse_vacation_end_date'] = $inhouse_vacation_end_date;
            $product['inhouse_temporary_close'] = $inhouse_temporary_close;
            $product['rating_status'] = $ratting_status;
        }
        return response()->json($product, 200);
    }

    public function get_best_sellings(Request $request)
    {
        $products = ProductManager::get_best_selling_products($request, $request['limit'], $request['offset']);
        $products['products'] = Helpers::product_data_formatting($products['products'], true);

        return response()->json($products, 200);
    }

    public function get_home_categories(Request $request)
    {
        $categories = Category::where(['home_status' => 1])->orderBy('priority', 'ASC')->get();
        $categories->map(function ($data) use ($request) {
            $products = CategoryManager::products($data['id'], $request);
            $data['products'] = Helpers::product_data_formatting($products, true);
            return $data;
        });
        return response()->json($categories, 200);
    }

    public function get_related_products(Request $request, $id)
    {
        if (Product::find($id)) {
            $products = ProductManager::get_related_products($id, $request);
            $products = Helpers::product_data_formatting($products, true);
            return response()->json($products, 200);
        }
        return response()->json([
            'errors' => ['code' => 'product-001', 'message' => 'Product not found!']
        ], 404);
    }

    public function get_product_reviews($id)
    {
        $reviews = Review::with(['customer'])->where(['product_id' => $id])->get();

        $storage = [];
        foreach ($reviews as $item) {
            $item['attachment'] = json_decode($item['attachment']);
            array_push($storage, $item);
        }

        return response()->json($storage, 200);
    }

    public function get_product_rating($id)
    {
        try {
            $product = Product::withCount('reviews')->find($id);
            $overallRating = getOverallRating($product->reviews);
            return response()->json(floatval($overallRating[0]), 200);
        } catch (\Exception $e) {
            return response()->json(['errors' => $e], 403);
        }
    }

    public function counter($product_id)
    {
        try {
            $countOrder = OrderDetail::where('product_id', $product_id)->count();
            $countWishlist = Wishlist::where('product_id', $product_id)->count();
            return response()->json(['order_count' => $countOrder, 'wishlist_count' => $countWishlist], 200);
        } catch (\Exception $e) {
            return response()->json(['errors' => $e], 403);
        }
    }

    public function social_share_link($product_slug)
    {
        $product = Product::withCount('reviews')->where('slug', $product_slug)->first();
        $link = route('product', $product->slug);
        try {

            return response()->json($link, 200);
        } catch (\Exception $e) {
            return response()->json(['errors' => $e], 403);
        }
    }

    public function submit_product_review(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'product_id' => 'required',
            'comment' => 'required',
            'rating' => 'required',
        ]);

        if ($validator->fails()) {
            return response()->json(['errors' => Helpers::error_processor($validator)], 403);
        }


        $image_array = [];
        if (!empty($request->file('fileUpload'))) {
            foreach ($request->file('fileUpload') as $image) {
                if ($image != null) {
                    array_push($image_array, ImageManager::upload('review/', 'webp', $image));
                }
            }
        }

        Review::updateOrCreate(
            [
                'delivery_man_id' => null,
                'customer_id' => $request->user()->id,
                'product_id' => $request->product_id
            ],
            [
                'customer_id' => $request->user()->id,
                'product_id' => $request->product_id,
                'comment' => $request->comment,
                'rating' => $request->rating,
                'attachment' => json_encode($image_array),
            ]
        );

        return response()->json(['message' => 'successfully review submitted!'], 200);
    }

    public function submit_deliveryman_review(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'order_id' => 'required',
            'comment' => 'required',
            'rating' => 'required',
        ]);

        if ($validator->fails()) {
            return response()->json(['errors' => Helpers::error_processor($validator)], 403);
        }

        $order = Order::where([
            'id' => $request->order_id,
            'customer_id' => $request->user()->id,
            'payment_status' => 'paid'])->first();

        if (!isset($order->delivery_man_id)) {
            return response()->json(['message' => 'Invalid review!'], 403);
        }

        Review::updateOrCreate(
            [
                'delivery_man_id' => $order->delivery_man_id,
                'customer_id' => $request->user()->id,
                'order_id' => $order->id
            ],
            [
                'customer_id' => $request->user()->id,
                'order_id' => $order->id,
                'delivery_man_id' => $order->delivery_man_id,
                'comment' => $request->comment,
                'rating' => $request->rating,
            ]
        );

        return response()->json(['message' => 'successfully review submitted!'], 200);
    }

    public function get_shipping_methods(Request $request)
    {
        $methods = ShippingMethod::where(['status' => 1])->get();
        return response()->json($methods, 200);
    }

    public function get_discounted_product(Request $request)
    {
        $products = ProductManager::get_discounted_product($request, $request['limit'], $request['offset']);
        $products['products'] = Helpers::product_data_formatting($products['products'], true);
        return response()->json($products, 200);
    }

    public function get_most_demanded_product(Request $request)
    {
        $user = Helpers::get_customer($request);
        // Most demanded product
        $products = MostDemanded::where('status', 1)->with(['product' => function ($query) use ($user) {
            $query->withCount(['order_details', 'order_delivered', 'reviews', 'wishList' => function ($query) use ($user) {
                $query->where('customer_id', $user != 'offline' ? $user->id : '0');
            }]);
        }])->whereHas('product', function ($query) {
            return $query->active();
        })->first();

        if ($products) {
            $products['banner'] = $products->banner ?? '';
            $products['product_id'] = $products->product['id'] ?? 0;
            $products['slug'] = $products->product['slug'] ?? '';
            $products['review_count'] = $products->product['reviews_count'] ?? 0;
            $products['order_count'] = $products->product['order_details_count'] ?? 0;
            $products['delivery_count'] = $products->product['order_delivered_count'] ?? 0;
            $products['wishlist_count'] = $products->product['wish_list_count'] ?? 0;

            unset($products->product['category_ids']);
            unset($products->product['images']);
            unset($products->product['details']);
            unset($products->product);
        } else {
            $products = [];
        }

        return response()->json($products, 200);
    }
}

• [D] auth
• [F] AttributeController.php
  Delete
• [F] BannerController.php
  Delete
• [F] BrandController.php
  Delete
• [F] CartController.php
  Delete
• [F] CategoryController.php
  Delete
• [F] ChatController.php
  Delete
• [F] CompareController.php
  Delete
• [F] ConfigController.php
  Delete
• [F] CouponController.php
  Delete
• [F] CustomerController.php
  Delete
• [F] DealController.php
  Delete
• [F] DealOfTheDayController.php
  Delete
• [F] DeliveryManController.php
  Delete
• [F] FlashDealController.php
  Delete
• [F] GeneralController.php
  Delete
• [F] MapApiController.php
  Delete
• [F] NotificationController.php
  Delete
• [F] OrderController.php
  Delete
• [F] ProductController.php
  Delete
• [F] SellerController.php
  Delete
• [F] ShippingMethodController.php
  Delete
• [F] UserLoyaltyController.php
  Delete
• [F] UserWalletController.php
  Delete