<?php

namespace App\Http\Controllers;

use App\Events\orderNotification;
use Illuminate\Http\Request;
use App\Models\order;
use App\Models\normalusercart;
use App\Models\mainproducts;
use App\Models\cartview;
use App\Models\dashboardNotification;
use App\Models\selectedShippingCities;
use Illuminate\Support\Facades\Session;


class OrderController extends Controller
{
    public function insertOrder(Request $request)
    {
        // Get The QNT
        // normalusercart::select('normaluserCart_OrderQNT')->where('');



        $normaluserOrders_UserId = $request->input('normaluserOrders_UserId');
        $normaluserOrders_AddressId = $request->input('normaluserOrders_AddressId');
        $normaluserOrders_PaymentMethod = $request->input('normaluserOrders_PaymentMethod');
        $normaluserOrders_Delivery = $request->input('normaluserOrders_Delivery');
        $normaluserOrders_Coupon = $request->input('normaluserOrders_Coupon');
        $normaluserOrders_Price = $request->input('normaluserOrders_Price');

        $insertOrder = order::create([
            'order_userid' => $normaluserOrders_UserId,
            'order_addressid' => $normaluserOrders_AddressId,
            'order_paymentmethod' => $normaluserOrders_PaymentMethod,
            'order_delivery' => $normaluserOrders_Delivery,
            'order_coupon' => $normaluserOrders_Coupon,
            'order_price' => $normaluserOrders_Price,
        ]);

        $orderMaxId = order::max("order_id");

        //   Number of products in the cart "Not The QNT"
        $NumberOfProducts = cartview::where(['normalUserCart_UserId' => $normaluserOrders_UserId]);


        $updateOrderId = normalusercart::where(['normalUserCart_UserId' => $normaluserOrders_UserId, 'normaluserCart_Order' => "0"])
            ->update(['normaluserCart_Order' => $orderMaxId]);


        $products = normalusercart::select('normalUserCart_productId')->where('normaluserCart_Order', $orderMaxId)->distinct()->get();


        foreach ($products as $products) {
            json_encode(['products' => $products->normalUserCart_productId]);
            $changeQNT = mainproducts::select('mainProductStock')->where('mainProductID', $products->normalUserCart_productId)->value('mainProductStock') - normalusercart::select('normaluserCart_OrderQNT')->where('normalUserCart_productId', $products->normalUserCart_productId)->value('normaluserCart_OrderQNT');
            $json = ['stock' => $changeQNT];
            $array = array_unique($json);
            $result = json_encode($array);

            $updateQNT = mainproducts::select('mainProductStock')->where('mainProductID', $products->normalUserCart_productId)->update([
                'mainProductStock' => $changeQNT
            ]);
        };
        if ($insertOrder) {
            echo json_encode("Insert Order Done");
        } else {
            echo json_encode("Insert Order Failed");
        }
    }
    public function getOrders(Request $request)
    {
        $userid = $request->input('userid');
        $orders = order::where('order_userid', $userid)->get();

        if ($orders) {

            echo json_encode(['status' => 'Exists', 'orders' => $orders]);
        } else {
            echo json_encode(['status' => 'Not Exists']);
        }
    }
    public function ordersDashboardIndex(Request $request)
    {
        $orders = order::with('user', 'address', 'orderStatus', 'country')->where(['order_vendor_id' => Session::get('vendor_id')])->orderBy('created_at', 'desc')->paginate(10);
        return view('dashboard.orders.orders', ['orders' => $orders]);
    }
    public function ordersDashboarddelete(Request $request)
    {

        $categoryid = $request->segment(3);

        $studentQuery = order::where(['order_id' => $categoryid])->delete();

        return redirect()->route('dashboard.ordersDashboardIndex')->with(['success' => 'تم إزالة الطلب بنجاح']);
    }
    public function ordersDashboardview(Request $request)
    {
        $orderid = $request->segment(4);

        $orderQuery = order::with(['address'])->where(['order_id' => $orderid])->get();

        $address = selectedShippingCities::with('country', 'city')->where(['selected_shipping_city_id' => $orderQuery[0]->address['normaluserAddress_cityID']])->get();

        $country = $address[0]->country['country_NameAR'];

        $addressName = $address[0]->city['shippingCity_NameAr'];

        $Query = normalusercart::with('product')->groupBy('normalUserCart_productId')->where(['normaluserCart_Order' => $orderid])->get();

        // Change Notification State
        if ($orderQuery) {
            dashboardNotification::where(['order_id' => $orderid])->update([
                'dashboard_notifications_seen' => 1,
            ]);
        } 

        // Change Notification State

        return view('dashboard.orders.orderview')->with(['products' => $Query, 'orders' => $orderQuery, 'country' => $country, 'addressName' => $addressName]);
    }

    // AJAX ===================================================================================================================================================================================
    public function paymentStatus(Request $request)
    {
        $orderid = $request->input('orderid');
        $paymentStatus = $request->input('paymentStatus');
        $query = order::where(['order_id' => $orderid])->update([
            'order_paymentStatus' => $paymentStatus,
        ]);
        return "<div class='alert alert-success alert-dismissible' style='background-color: #00800036;'>
                    <button type='button' class='close' data-dismiss='alert'>&times;</button>
                    تم التعديل
                </div>";
    }
    public function orderState(Request $request)
    {
        $orderid = $request->input('orderid');
        $orderState = $request->input('orderState');
        $query = order::where(['order_id' => $orderid])->update([
            'order_state_id' => $orderState,
        ]);
        return "<div class='alert alert-success alert-dismissible' style='background-color: #00800036;'>
                    <button type='button' class='close' data-dismiss='alert'>&times;</button>
                    تم التعديل
                </div>";
    }
    public function orderProduct($vendor_name, $locale, $id, Request $request)
    // public function orderProduct(Request $request)
    {
        $vendor_name = $request->segment(5);
        $locale = $request->segment(6);
        $id = $request->segment(7);

        $url = ("{$vendor_name}/{$locale}/product/{$id}");
        return redirect($url);
    }

    // AJAX ===================================================================================================================================================================================

}
