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

Category Sales Report

  1. Report
  2. List
Export Excel

National Monthly Sale

@foreach ($data['months'] as $dt) @endforeach @foreach ($data['cats'] as $cat) @foreach ($data['months'] as $dt) @php $netsales = collect($data['orders'])->where('brand_id',$cat->sub_category_id)->where('datemonth',$dt->format("Y-m"))->first(); $netsale = (float)$netsales->net_sale; @endphp @endforeach @endforeach
Main Category Sub Category{{$dt->format("M-Y")}}
{{$cat->main_category_name}} {{$cat->sub_category_name}}{{number_format($netsale,2)}}
@endsection @section('scripts') @endsection