@extends('layouts.master') @section('styles') @endsection @section('content')

Brand Sales Report

Export Excel

Month Wise

@foreach ($data['months'] as $dt) @endforeach @foreach ($data['brands'] as $brand) @foreach ($data['months'] as $dt) @php $netsales = collect($data['orders'])->where('brand_id',$brand->id)->where('datemonth',$dt->format("Y-m"))->first(); $netsale = (float)$netsales->net_sale; @endphp @endforeach @endforeach
Brand{{$dt->format("M-Y")}}
{{$brand->name}}{{number_format($netsale,2)}}
@endsection @section('scripts') @endsection