<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\order;
use App\Models\orderState;
use App\Models\normalusercart;
use App\Models\cartview;
use App\Models\cartviewCompleted;
use Illuminate\Support\Facades\Session;
use Carbon\Carbon;

class StatisticsController extends Controller
{
    public function DailyDashboardIndex(Request $request)
    {
        if ($request->filled('coulmns')) {
            $coulmns = $request->input('coulmns');
        } else {
            $coulmns = 10;
        }

        $orderStates = orderState::all();

        $code = $request->input('code');
        $user = $request->input('user');
        if ($request->filled('date')) {
            $date = $request->input('date');
        } else {
            $date = Carbon::today();
        }

        $orderstate = $request->input('orderstate');
        $paymentstate = $request->input('paymentstate');
        $paymentmethod = $request->input('paymentmethod');

        $orders = order::with('user', 'address', 'orderStatus')->whereDate('created_at', $date)
            ->where([
                'order_vendor_id' => Session::get('vendor_id'),
            ])
            ->where('order_id', 'like', '%' . $code . '%')
            ->where('order_state_id', 'like', '%' . $orderstate . '%')
            ->where('order_paymentStatus', 'like', '%' . $paymentstate . '%')
            ->where('order_paymentmethod', 'like', '%' . $paymentmethod . '%')
            ->whereHas('user', function ($query) use ($user) {
                $query->where('normalUser_name', 'like', '%' . $user . '%');
                $query->where('normalUser_email', 'like', '%' . $user . '%');
                $query->where('normalUser_phone', 'like', '%' . $user . '%');
            })
            ->paginate($coulmns);


        $price = order::with('user', 'address', 'orderStatus')->whereDate('created_at', Carbon::today())
            ->where([
                'order_vendor_id' => Session::get('vendor_id'),
                'order_paymentStatus' => "1", // 1 == Success
                'order_state_id' => "4", // 4 == Deliverd

            ])->sum('order_price');
        return view('dashboard.Statistics.Daily.daily', [
            'orders' => $orders,
            'price' => $price,
            'orderStates' => $orderStates,
            'coulmns' => $coulmns,

        ]);
    }
    public function MonthlyDashboardIndex(Request $request)
    {
        if ($request->filled('coulmns')) {
            $coulmns = $request->input('coulmns');
        } else {
            $coulmns = 10;
        }

        $orderStates = orderState::all();

        $code = $request->input('code');
        $user = $request->input('user');



        $orderstate = $request->input('orderstate');
        $paymentstate = $request->input('paymentstate');
        $paymentmethod = $request->input('paymentmethod');


        if ($request->filled('dateFrom') && $request->filled('dateTo')) {
            $dateFrom = $request->input('dateFrom');
            $dateTo = $request->input('dateTo');

            $orders = order::with('user', 'address', 'orderStatus')
                ->whereBetween('created_at', [$dateFrom, $dateTo])
                ->whereYear('created_at', Carbon::now()->year)
                ->whereMonth('created_at', Carbon::now()->month)
                ->where([
                    'order_vendor_id' => Session::get('vendor_id'),
                ])
                ->where('order_id', 'like', '%' . $code . '%')
                ->where('order_state_id', 'like', '%' . $orderstate . '%')
                ->where('order_paymentStatus', 'like', '%' . $paymentstate . '%')
                ->where('order_paymentmethod', 'like', '%' . $paymentmethod . '%')
                ->whereHas('user', function ($query) use ($user) {
                    $query->where('normalUser_name', 'like', '%' . $user . '%');
                    $query->where('normalUser_email', 'like', '%' . $user . '%');
                    $query->where('normalUser_phone', 'like', '%' . $user . '%');
                })
                ->paginate($coulmns);
        } else {
            $orders = order::with('user', 'address', 'orderStatus')
                ->whereYear('created_at', Carbon::now()->year)
                ->whereMonth('created_at', Carbon::now()->month)
                ->where([
                    'order_vendor_id' => Session::get('vendor_id'),
                ])
                ->where('order_id', 'like', '%' . $code . '%')
                ->where('order_state_id', 'like', '%' . $orderstate . '%')
                ->where('order_paymentStatus', 'like', '%' . $paymentstate . '%')
                ->where('order_paymentmethod', 'like', '%' . $paymentmethod . '%')
                ->whereHas('user', function ($query) use ($user) {
                    $query->where('normalUser_name', 'like', '%' . $user . '%');
                    $query->where('normalUser_email', 'like', '%' . $user . '%');
                    $query->where('normalUser_phone', 'like', '%' . $user . '%');
                })
                ->paginate($coulmns);
        }



        $price = order::with('user', 'address', 'orderStatus')
            ->whereYear('created_at', Carbon::now()->year)
            ->whereMonth('created_at', Carbon::now()->month)
            ->where([
                'order_vendor_id' => Session::get('vendor_id'),
                'order_paymentStatus' => "1", // 1 == Success
                'order_state_id' => "4", // 4 == Deliverd

            ])->sum('order_price');
        return view('dashboard.Statistics.Monthly.monthly', [
            'orders' => $orders,
            'price' => $price,
            'orderStates' => $orderStates,
            'coulmns' => $coulmns,

        ]);
    }
    public function StockDashboardIndex(Request $request)
    {
        if ($request->filled('coulmns')) {
            $coulmns = $request->input('coulmns');
        } else {
            $coulmns = 10;
        }

        $orderStates = orderState::all();

        $code = $request->input('code');
        $product = $request->input('product');
        if ($request->filled('date')) {
            $date = $request->input('date');
        } else {
            $date = Carbon::today();
        }

        $orderstate = $request->input('orderstate');
        $paymentstate = $request->input('paymentstate');
        $paymentmethod = $request->input('paymentmethod');

    //  return   $products = cartviewCompleted::
    //     where([
    //         'normaluserCart_vendor_id' => Session::get('vendor_id'),
    //     ])->whereNot('normaluserCart_Order', '0')
    //     // ->where('order_id', 'like', '%' . $code . '%')
    //     // ->where('order_state_id', 'like', '%' . $orderstate . '%')
    //     // ->where('order_paymentStatus', 'like', '%' . $paymentstate . '%')
    //     // ->where('order_paymentmethod', 'like', '%' . $paymentmethod . '%')
    //     ->where('mainProductName', 'like', '%' . $product . '%')
    //     ->where('mainProductNameAr', 'like', '%' . $product . '%')
    //     ->where('mainProductCode', 'like', '%' . $product . '%')
    //     ->get();


        if ($request->filled('dateFrom') && $request->filled('dateTo')) {
            $dateFrom = $request->input('dateFrom');
            $dateTo = $request->input('dateTo');

            $products = cartviewCompleted::
                whereBetween('created_at', [$dateFrom, $dateTo])
                ->where([
                    'normaluserCart_vendor_id' => Session::get('vendor_id'),
                ])->whereNot('normaluserCart_Order', '0')
                // ->where('order_id', 'like', '%' . $code . '%')
                // ->where('order_state_id', 'like', '%' . $orderstate . '%')
                // ->where('order_paymentStatus', 'like', '%' . $paymentstate . '%')
                // ->where('order_paymentmethod', 'like', '%' . $paymentmethod . '%')
                ->where('mainProductName', 'like', '%' . $product . '%')
                ->where('mainProductNameAr', 'like', '%' . $product . '%')
                ->where('mainProductCode', 'like', '%' . $product . '%')
                ->paginate($coulmns);
        } else {
            $products = cartviewCompleted::
                where([
                    'normaluserCart_vendor_id' => Session::get('vendor_id'),
                ])->whereNot('normaluserCart_Order', '0')
                // ->where('order_id', 'like', '%' . $code . '%')
                // ->where('order_state_id', 'like', '%' . $orderstate . '%')
                // ->where('order_paymentStatus', 'like', '%' . $paymentstate . '%')
                // ->where('order_paymentmethod', 'like', '%' . $paymentmethod . '%')
                ->where('mainProductName', 'like', '%' . $product . '%')
                ->where('mainProductNameAr', 'like', '%' . $product . '%')
                ->where('mainProductCode', 'like', '%' . $product . '%')
                ->paginate($coulmns);
        }


        $Stock = cartviewCompleted::whereNot('normaluserCart_Order', '0')->where([
                'normaluserCart_vendor_id' => Session::get('vendor_id'),
            ])->sum('cartStock');

        return view('dashboard.Statistics.Stock.stock', [
            'products' => $products,
            'Stock' => $Stock,
            'orderStates' => $orderStates,
            'coulmns' => $coulmns,

        ]);
    }
}
