Admin Dashboard

@if(env('APP_URL') == 'https://wlcm.westlinks.com') @endif

Statistics

Note: data on this dashboard is being filtered to show only records on or after the registration start date ({{ substr($reg_startdate,2,-2) }}).
{{-- @php $order = \App\Models\Order::find(619); @endphp --}} @foreach($tracked as $track) @php $pcount = \App\Models\Product:: leftJoin('categories', 'categories.id', '=', 'products.category_id') ->leftJoin('order_items', 'order_items.item_id', '=', 'products.id') ->leftJoin('orders', 'orders.id', '=', 'order_items.order_id') ->where('orders.order_status_id', '1') ->where('orders.created_at', '>=', $reg_startdate) ->where('categories.id', $track->id) ->sum('order_items.quantity','*','order_items.amount'); @endphp @endforeach
Item Records
Current Time {{ date('Y-m-d H:i:s') }}
Order 619 {{ $order->transaction->created_at }}
{{$track->title}} Sold {{ $pcount }}
Users in DB {{ $users_count }}
Verified Users {{ $users_verified_count }}
{{--
${{ number_format($grossrevenue,2) }}
--}}
{{ round(($grossrevenue / $grossrevenuegoal) * 100) }}%
Goal: ${{ number_format($grossrevenuegoal,2) }}
Sold: ${{ number_format($grossrevenue,2) }}
@if($grossrevenuegoal - $grossrevenue > 0 ) Remaining: ${{ number_format($grossrevenuegoal - $grossrevenue,2) }}
@else Remaining: ${{ number_format($grossrevenuegoal - $grossrevenue,2) }}
@endif
@foreach($tracked as $track) @php $pcount = \App\Models\Product:: leftJoin('categories', 'categories.id', '=', 'products.category_id') ->leftJoin('order_items', 'order_items.item_id', '=', 'products.id') ->leftJoin('orders', 'orders.id', '=', 'order_items.order_id') ->where('orders.created_at', '>=', $reg_startdate) ->where('orders.order_status_id', '1') // ->where('products.published', '1') ->where('categories.id', $track->id) ->sum('order_items.quantity','*','order_items.amount'); @endphp

{{$track->title}}

{{ round(($pcount / $track->goal) * 100) }}%
Goal: {{$track->goal}}
Sold: {{ $pcount }}
@if($track->goal - $pcount > 0 ) Remaining: {{ $track->goal - $pcount }}
@else Remaining: {{ $track->goal - $pcount }}
@endif
@endforeach