@extends('layouts.back-end.app') @section('title','Earning Report') @push('css_or_js') @endpush @section('content')
Image Description

{{trans('messages.Earning')}} {{trans('messages.Report')}} {{trans('messages.Overview')}}

{{trans('messages.Admin')}}: {{auth('admin')->user()->name}}
{{trans('messages.Date')}}
( {{session('from_date')}} - {{session('to_date')}} )
@csrf
@php $from = session('from_date'); $to = session('to_date'); $total_tax=\App\Models\OrderDetail::where(['delivery_status'=>'delivered']) ->whereBetween('created_at', [$from, $to]) ->sum('tax'); if($total_tax==0){ $total_tax=0.01; } @endphp
@php $total_sold=\App\Models\Order::where(['order_status'=>'delivered'])->whereBetween('created_at', [$from, $to])->sum('order_amount'); if($total_sold==0){ $total_sold=.01; } @endphp

{{trans('messages.Total')}} {{trans('messages.Sold')}}

{{round(abs(\App\CPU\BackEndHelper::usd_to_currency($total_sold-$total_tax)))}} {{\App\CPU\BackEndHelper::currency_symbol()}}

{{trans('messages.Total')}} {{trans('messages.Tax')}}

{{round(abs(\App\CPU\BackEndHelper::usd_to_currency($total_tax)))}} {{\App\CPU\BackEndHelper::currency_symbol()}}
@php $total_sold=\App\Models\Order::where(['order_status'=>'delivered'])->whereBetween('created_at', [date('y-01-01'), date('y-12-31')])->sum('order_amount') @endphp
Total sale of {{date('Y')}} : {{\App\CPU\BackEndHelper::usd_to_currency($total_sold)." ".\App\CPU\BackEndHelper::currency_symbol()}}
{{trans('messages.Orders')}}
@php $sold=[]; for ($i=1;$i<=12;$i++){ $from = date('Y-'.$i.'-01'); $to = date('Y-'.$i.'-30'); $sold[$i]=\App\Models\Order::where(['order_status'=>'delivered'])->whereBetween('created_at', [$from, $to])->sum('order_amount'); } @endphp @php $tax=[]; for ($i=1;$i<=12;$i++){ $from = date('Y-'.$i.'-01'); $to = date('Y-'.$i.'-30'); $tax[$i]=\App\Models\OrderDetail::where(['delivery_status'=>'delivered'])->whereBetween('created_at', [$from, $to])->sum('tax'); } @endphp
@endsection @push('script') @endpush @push('script_2') @endpush