@extends('layouts.back-end.app') @section('title','Order Report') @push('css_or_js') @endpush @section('content')
@csrf
@php $from = session('from_date'); $to = session('to_date'); $total=\App\Models\Order::whereBetween('created_at', [$from, $to])->count(); if($total==0){ $total=.01; } @endphp
@php $delivered=\App\Models\Order::where(['order_status'=>'delivered'])->whereBetween('created_at', [$from, $to])->count() @endphp

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

{{$delivered}}
@php $returned=\App\Models\Order::where(['order_status'=>'returned'])->whereBetween('created_at', [$from, $to])->count() @endphp

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

{{$returned}}
@php $failed=\App\Models\Order::where(['order_status'=>'failed'])->whereBetween('created_at', [$from, $to])->count() @endphp

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

{{$failed}}
@php $canceled=\App\Models\Order::where(['order_status'=>'processing'])->whereBetween('created_at', [$from, $to])->count() @endphp

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

{{$canceled}}

@php $x=1; $y=12; $total=\App\Models\Order::whereBetween('created_at', [date('Y-'.$x.'-01'), date('Y-'.$y.'-30')])->count() @endphp
Total orders of {{date('Y')}}: {{round($total)}}
@php $delivered=[]; for ($i=1;$i<=12;$i++){ $from = date('Y-'.$i.'-01'); $to = date('Y-'.$i.'-30'); $delivered[$i]=\App\Models\Order::where(['order_status'=>'delivered'])->whereBetween('created_at', [$from, $to])->count(); } @endphp @php $ret=[]; for ($i=1;$i<=12;$i++){ $from = date('Y-'.$i.'-01'); $to = date('Y-'.$i.'-30'); $ret[$i]=\App\Models\Order::where(['order_status'=>'returned'])->whereBetween('created_at', [$from, $to])->count(); } @endphp @php $fai=[]; for ($i=1;$i<=12;$i++){ $from = date('Y-'.$i.'-01'); $to = date('Y-'.$i.'-30'); $fai[$i]=\App\Models\Order::where(['order_status'=>'failed'])->whereBetween('created_at', [$from, $to])->count(); } @endphp @php $can=[]; for ($i=1;$i<=12;$i++){ $from = date('Y-'.$i.'-01'); $to = date('Y-'.$i.'-30'); $can[$i]=\App\Models\Order::where(['order_status'=>'canceled'])->whereBetween('created_at', [$from, $to])->count(); } @endphp
@endsection @push('script') @endpush @push('script_2') @endpush