@extends('layouts.back-end.app') @section('title', \App\CPU\translate('Order Report')) @push('css_or_js') @endpush @section('content')
Image Description

{{\App\CPU\translate('Order')}} {{\App\CPU\translate('Report')}} {{\App\CPU\translate('Overview')}}

{{\App\CPU\translate('Admin')}} :
{{auth('admin')->user()->name}}
{{\App\CPU\translate('Date')}}
( {{session('from_date')}} - {{session('to_date')}} )
@csrf
@php $from = session('from_date'); $to = session('to_date'); $total=\App\Model\Order::where('order_type','default_type')->whereBetween('created_at', [$from, $to])->count(); if($total==0){ $total=.01; } @endphp
@php $delivered=\App\Model\Order::where('order_type','default_type')->where(['order_status'=>'delivered'])->whereBetween('created_at', [$from, $to])->count() @endphp

{{\App\CPU\translate('Delivered')}}

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

{{\App\CPU\translate('Returned')}}

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

{{\App\CPU\translate('Failed')}}

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

{{\App\CPU\translate('Processing')}}

{{$canceled}}
@php $from = \Carbon\Carbon::now()->startOfYear()->format('Y-m-d'); $to = \Carbon\Carbon::now()->endOfYear()->format('Y-m-d'); $total=\App\Model\Order::where('order_type','default_type')->whereBetween('created_at', [$from, $to])->count() @endphp
Total orders of {{date('Y')}} :
{{round($total)}}
{{\App\CPU\translate('Orders')}}
@php $delivered=[]; $from = \Carbon\Carbon::now()->startOfYear()->format('Y-m-d'); $to = \Carbon\Carbon::now()->endOfYear()->format('Y-m-d'); $data=\App\Model\Order::where('order_type','default_type') ->where(['order_status'=>'delivered'])->select( \Illuminate\Support\Facades\DB::raw('COUNT(id) as count'), \Illuminate\Support\Facades\DB::raw('YEAR(created_at) year, MONTH(created_at) month') )->whereBetween('created_at', [$from, $to])->groupby('year', 'month')->get()->toArray(); for ($inc = 1; $inc <= 12; $inc++) { $delivered[$inc] = 0; foreach ($data as $match) { if ($match['month'] == $inc) { $delivered[$inc] = $match['count']; } } } @endphp @php $ret=[]; $from = \Carbon\Carbon::now()->startOfYear()->format('Y-m-d'); $to = \Carbon\Carbon::now()->endOfYear()->format('Y-m-d'); $data=\App\Model\Order::where('order_type','default_type') ->where(['order_status'=>'returned'])->select( \Illuminate\Support\Facades\DB::raw('COUNT(id) as count'), \Illuminate\Support\Facades\DB::raw('YEAR(created_at) year, MONTH(created_at) month') )->whereBetween('created_at', [$from, $to])->groupby('year', 'month')->get()->toArray(); for ($inc = 1; $inc <= 12; $inc++) { $ret[$inc] = 0; foreach ($data as $match) { if ($match['month'] == $inc) { $ret[$inc] = $match['count']; } } } @endphp @php $fai=[]; $from = \Carbon\Carbon::now()->startOfYear()->format('Y-m-d'); $to = \Carbon\Carbon::now()->endOfYear()->format('Y-m-d'); $data=\App\Model\Order::where('order_type','default_type') ->where(['order_status'=>'failed'])->select( \Illuminate\Support\Facades\DB::raw('COUNT(id) as count'), \Illuminate\Support\Facades\DB::raw('YEAR(created_at) year, MONTH(created_at) month') )->whereBetween('created_at', [$from, $to])->groupby('year', 'month')->get()->toArray(); for ($inc = 1; $inc <= 12; $inc++) { $fai[$inc] = 0; foreach ($data as $match) { if ($match['month'] == $inc) { $fai[$inc] = $match['count']; } } } @endphp @php $can=[]; $from = \Carbon\Carbon::now()->startOfYear()->format('Y-m-d'); $to = \Carbon\Carbon::now()->endOfYear()->format('Y-m-d'); $data=\App\Model\Order::where('order_type','default_type') ->where(['order_status'=>'processing'])->select( \Illuminate\Support\Facades\DB::raw('COUNT(id) as count'), \Illuminate\Support\Facades\DB::raw('YEAR(created_at) year, MONTH(created_at) month') )->whereBetween('created_at', [$from, $to])->groupby('year', 'month')->get()->toArray(); for ($inc = 1; $inc <= 12; $inc++) { $can[$inc] = 0; foreach ($data as $match) { if ($match['month'] == $inc) { $can[$inc] = $match['count']; } } } $max_order=\App\CPU\BackEndHelper::max_orders(); @endphp

{{\App\CPU\translate('Weekly')}} {{\App\CPU\translate('Report')}}

@php $orders= \App\Model\Order::where('order_type','default_type')->whereBetween('created_at', [now()->startOfWeek(), now()->endOfWeek()])->paginate(20); @endphp
@php $orders= \App\Model\Order::where('order_type','default_type')->whereBetween('created_at', [now()->subDays(7)->startOfWeek(), now()->subDays(7)->endOfWeek()])->paginate(20); @endphp
@endsection @push('script') @endpush @push('script_2') @endpush