<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\normalusercart;
use App\Models\cartview;
use App\Models\mainproducts;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Session;

class cartController extends Controller
{
  // Web ==================================================================================================================================================
  public function increase(Request $request)
  {
    $productid = $request->input('productid');

    normalusercart::create([
      'normalUserCart_productId' => $productid,
      'normalUserCart_UserId' => Session::get('userID'),
      'normaluserCart_Order'=>0,
      'normaluserCart_vendor_id' => Session::get('website_id'),
    ]);
  }
  public function decrease(Request $request)
  {
    $productid = $request->input('productid');

    normalusercart::where([
      'normalUserCart_productId' => $productid, 
      'normalUserCart_UserId' => Session::get('userID'),
      'normaluserCart_Order'=>0,
      'normaluserCart_vendor_id' => Session::get('website_id'),
      ])->take(1)->delete();
  }
  public function delete(Request $request)
  {
    $productid = $request->input('productid');
    normalusercart::where([
      'normalUserCart_productId' => $productid, 
      'normalUserCart_UserId' => Session::get('userID'),
      'normaluserCart_Order'=>0,
      'normaluserCart_vendor_id' => Session::get('website_id'),
      ])->delete();
  }

  public function cartdataApp(Request $request)
  {
    $normalUserCart_UserId = $request->input('userid');


    $cartdata = cartview::where(['normalUserCart_UserId' => $normalUserCart_UserId, 'normaluserCart_Order' => 0])->get();
    if ($cartdata) {
      echo json_encode(['status' => 'Right', 'data' => $cartdata]);
    } else {
      echo json_encode(['status' => 'Fail']);
    }
  }

  public function getCartPrice(Request $request)
  {
    $normalUserCart_UserId = $request->input('userid');

    $cartPrice = cartview::select(DB::raw('sum(mainProductsPrice) as mainProductsPrice'))->where('normalUserCart_UserId', $normalUserCart_UserId)->value('mainProductsPrice');
    $cartCount = cartview::select(DB::raw('count(mainProductsPrice) as mainProductsPrice'))->where('normalUserCart_UserId', $normalUserCart_UserId)->value('mainProductsPrice');

    echo json_encode(['data' => $cartPrice, 'cartCount' => $cartCount]);
  }
  public function increaseApp(Request $request)
  {
    $normalUserCart_UserId = $request->input("normalUserCart_UserId");
    $normalUserCart_productId = $request->input("normalUserCart_productId");


    normalusercart::create([
      'normalUserCart_productId' => $normalUserCart_productId,
      'normalUserCart_UserId' => $normalUserCart_UserId
    ]);
  }
  public function decreaseApp(Request $request)
  {
    $normalUserCart_UserId = $request->input("normalUserCart_UserId");
    $normalUserCart_productId = $request->input("normalUserCart_productId");

    if (normalusercart::where(['normalUserCart_productId' => $normalUserCart_productId, 'normalUserCart_UserId' => $normalUserCart_UserId])->take(1)->delete()) {
      echo json_encode("delete success");
    } else {
      echo json_encode("delete failed");
    }
  }
  // Web ==================================================================================================================================================
  public function cart(Request $request)
  {
    Session::get('userID');
    $normalUserCart_UserId = $request->session()->get('userID');
    $cartPrice = cartview::select(DB::raw('sum(mainProductsPrice) as mainProductsPrice'))->where(['normalUserCart_UserId' => $normalUserCart_UserId, 'normaluserCart_vendor_id' => Session::get('website_id')])->value('mainProductsPrice');
    $cartdata = cartview::where(['normalUserCart_UserId' => Session::get('userID'), 'normaluserCart_vendor_id' => Session::get('website_id')])->get();
    // $cartEquation =  ($cartPrice - ($cartStock * $cartSale));
    $cartEquation = 0;
    foreach ($cartdata as $cartdataa) {
      $cartEquation += ($cartdataa->cartitems * $cartdataa->mainProductSale);
    }

    if (!$cartdata->isEmpty()) {
      return view('cart', ['cartdata' => $cartdata, 'cartPrice' => $cartPrice, 'cartEquation' => $cartEquation]);
    } else {
      return view('cart', ['cartdata' => "empty", 'cartPrice' => $cartPrice]);
    }
  }

  // Web AJAX ==================================================================================================================================================
  public function addToCart(Request $request)
  {

    $cartProductQuantity = $request->input('quantity');  
    $productid = $request->input('productid');
   $product = mainproducts::where(['mainProductID'=>$productid])->get();

if ($cartProductQuantity > $product[0]->mainProductStock) {
  # code...
} else {
  $userid = Session::get('userID');

  for ($i = 0; $i < $cartProductQuantity; $i++) {
    normalusercart::create([
      'normalUserCart_productId' => $productid,
      'normalUserCart_UserId' => $request->session()->get('userID'),
      'normaluserCart_vendor_id' => Session::get('website_id'),
      'normaluserCart_OrderQNT' => $cartProductQuantity == "1" ? normalusercart::where(['normalUserCart_UserId' => $userid, 'normalUserCart_productId' => $productid, 'normaluserCart_Order' => 0])->get()->count() + $cartProductQuantity : $cartProductQuantity,
    ]);
  }
  return "<div class='alert alert-success customAlert' role='alert'>تم إضافة المنتج للسلة</div>";

}



  }
  public function CartCount(Request $request)
  {

    $userid = Session::get('userID');

    $cartdata = cartview::where(['normalUserCart_UserId' => $userid, 'normaluserCart_vendor_id' => Session::get('website_id')])->get();

    return $cartdata->count();
  }


  // Web AJAX ==================================================================================================================================================

}
