@extends('admin.layout.app') @section('content')

Sales Graph

Sales Chart

@foreach($all_business_list as $all_business_lists) @php $total_orders = \DB::table('orders')->where('restaurant',$all_business_lists->reference_market_id)->where('status','!=','6')->count(); $total_orders_done = \DB::table('orders')->where('restaurant',$all_business_lists->reference_market_id)->where('status','5')->count(); $total_orders_amount = \DB::table('orders')->where('restaurant',$all_business_lists->reference_market_id)->where('status','!=','6')->sum('total'); $total_orders_done_amount = \DB::table('orders')->where('restaurant',$all_business_lists->reference_market_id)->where('status','5')->sum('total'); @endphp
{{@$all_business_lists->name}}
{{$total_orders_done}}/{{$total_orders}}
@if($total_orders ==0)
@else
@endif
${{$total_orders_done_amount}}/${{$total_orders_amount}}
@if($total_orders_amount ==0)
@else
@endif
@endforeach
@endsection