@extends('layouts.master') @section('title','Expense Analysis') @section('page-header') Expense Analysis @stop @push('style') @endpush @section('content')
@include('partials._alert_message')

Expense Analysis

Date From {{ fdate(request('from'),'d/m/Y') }} To {{ fdate(request('to'),'d/m/Y') }}
@php $dateWiseTransactions = $transactions->groupBy('date'); @endphp @foreach($dateWiseTransactions as $date => $dateWise) @php $subWiseTransactions = $dateWise->groupBy('account_subsidiary_id'); @endphp @foreach($subWiseTransactions as $account_subsidiary_id => $subWise) @endforeach @endforeach
Date {{fdate($date)}}
@php $controlWiseTransactions = $dateWise->groupBy('account_control_id'); @endphp @foreach($controlWiseTransactions as $account_control_id => $controlWise) @endforeach
Sub-Accounts  {{optional(optional(optional($subWise->first())->account)->accountSubsidiary)->name}}
Control-Accounts  {{optional(optional(optional($controlWise->first())->account)->accountControl)->name}}
@foreach($controlWise as $account_id => $transaction) @endforeach
Account  None Amount
{{$transaction->account->name}} {{number_format($transaction->amount, 2)}}
Total Control Account {{number_format($controlWise->sum('amount'),2)}}
Total Subsidiary Account {{number_format($subWise->sum('amount'),2)}}
Date Wise Total Amount {{number_format($dateWise->sum('amount'),2)}}
@endsection @section('js') @endsection