@extends('layouts.back-end.app') @section('title','Dashboard') @push('css_or_js') @endpush @section('content')
@php $array=[]; for ($i=1;$i<=12;$i++){ $from = date('Y-'.$i.'-01'); $to = date('Y-'.$i.'-30'); $array[$i]=\App\Models\Order::whereBetween('created_at', [$from, $to])->count(); } @endphp
@php $array=[]; for ($i=1;$i<=12;$i++){ $from = date('Y-'.$i.'-01'); $to = date('Y-'.$i.'-30'); $array[$i]=\App\Models\Order::where(['order_status'=>'delivered'])->whereBetween('created_at', [$from, $to])->count(); } @endphp
{{trans('messages.Delivered')}}
{{\App\Models\Order::where(['order_status'=>'delivered'])->count()}}
Jan - Dec
@php $array=[]; for ($i=1;$i<=12;$i++){ $from = date('Y-'.$i.'-01'); $to = date('Y-'.$i.'-30'); $array[$i]=\App\Models\Order::where(['order_status'=>'returned'])->whereBetween('created_at', [$from, $to])->count(); } @endphp
{{trans('messages.Returned')}}
{{\App\Models\Order::where(['order_status'=>'returned'])->count()}}
Jan - Dec
@php $array=[]; for ($i=1;$i<=12;$i++){ $from = date('Y-'.$i.'-01'); $to = date('Y-'.$i.'-30'); $array[$i]=\App\Models\Order::where(['order_status'=>'failed'])->whereBetween('created_at', [$from, $to])->count(); } @endphp
{{trans('messages.Failed')}}
{{\App\Models\Order::where(['order_status'=>'failed'])->count()}}
Jan - Dec
@php $array=[]; for ($i=1;$i<=12;$i++){ $from = date('Y-'.$i.'-01'); $to = date('Y-'.$i.'-30'); $array[$i]=\App\Models\Order::where(['order_status'=>'delivered'])->whereBetween('created_at', [$from, $to])->sum('order_amount'); } @endphp
@php($this_month=\App\Models\Order::where(['order_status'=>'delivered'])->whereBetween('updated_at', [date('Y-m-01'), date('Y-m-30')])->sum('order_amount')) @php($amount=0) @foreach($array as $ar)@php($amount+=$ar)@endforeach{{\App\CPU\BackEndHelper::usd_to_currency($amount)." ".\App\CPU\BackEndHelper::currency_symbol()}} @php($amount=$amount!=0?$amount:0.01) {{round(($this_month/$amount)*100)}} %
Monthly Earning

{{trans('messages.bestsellings')}}

@foreach($bestSellProduct as $key => $bestSell) @if($bestSell->product) @endif @endforeach

{{trans('messages.new_selling')}}

@foreach($newSellingProduct as $key => $newSell) @if($newSell->product) @endif @endforeach
{{ trans('messages.Withdraw Request Table')}}
{{-- --}} @foreach($withdraw_req as $k=>$wr) {{-- --}} @endforeach
{{trans('messages.SL#')}} {{trans('messages.amount')}}{{trans('messages.note')}}{{trans('messages.request_time')}} {{trans('messages.status')}} Close
{{$k+1}} {{\App\CPU\BackEndHelper::usd_to_currency($wr['amount'])}} {{\App\CPU\currency_symbol()}}{{$wr->transaction_note}}{{$wr->created_at}} @if($wr->approved==0) @elseif($wr->approved==1) @else @endif @if($wr->approved==0) {{trans('messages.View')}} @else @endif
@endsection @push('script') @endpush @push('script_2') @endpush