• @lang('accounting::lang.monthly')
  • @lang('accounting::lang.quarterly')
  • @lang('accounting::lang.yearly')
@lang('accounting::lang.export_to_pdf') @lang('accounting::lang.export_to_csv') @lang('accounting::lang.export_to_excel')
@foreach($months as $k => $m) @endforeach @foreach($account_types as $account_type => $account_type_detail ) @php $account_ids=[]; @endphp @foreach($accounts->where('account_primary_type', $account_type)->sortBy('name')->all() as $account) @php $total = 0; $account_ids[]=$account->id; @endphp @foreach($months as $k => $m) @php $account_budget = $budget->where('accounting_account_id', $account->id)->first(); $value = !is_null($account_budget) && !is_null($account_budget->$m) ? $account_budget->$m : null; @endphp @endforeach @endforeach @foreach($months as $k => $m) @endforeach @endforeach @foreach($months as $k => $m) @endforeach
@lang('account.account') {{Carbon::createFromFormat('m', $k)->format('M')}}@lang('sale.total')
{{$account_type_detail['label']}}
{{$account->name}} @if(!is_null($value)) {{@num_format($value)}} @php $total += $value; @endphp @endif {{@num_format($total)}}
@lang('sale.total') {{@num_format($budget->whereIn('accounting_account_id', $account_ids)->sum($m))}}
@lang('lang_v1.grand_total') {{@num_format($budget->sum($m))}}
@lang('accounting::lang.export_to_pdf') @lang('accounting::lang.export_to_csv') @lang('accounting::lang.export_to_excel')
@foreach($account_types as $account_type => $account_type_detail ) @php $account_ids=[]; @endphp @foreach($accounts->where('account_primary_type', $account_type)->sortBy('name')->all() as $account) @php $total = 0; $account_ids[]=$account->id; $account_budget = $budget->where('accounting_account_id', $account->id)->first(); @endphp @endforeach @endforeach
@lang('account.account') @lang('accounting::lang.1st_quarter') @lang('accounting::lang.2nd_quarter') @lang('accounting::lang.3rd_quarter') @lang('accounting::lang.4th_quarter') @lang('sale.total')
{{$account_type_detail['label']}}
{{$account->name}} @if(!is_null($account_budget) && !is_null($account_budget->quarter_1)) @php $total += $account_budget->quarter_1; @endphp {{@num_format($account_budget->quarter_1)}} @else 0 @endif @if(!is_null($account_budget) && !is_null($account_budget->quarter_2)) @php $total += $account_budget->quarter_2; @endphp {{@num_format($account_budget->quarter_2)}} @else 0 @endif @if(!is_null($account_budget) && !is_null($account_budget->quarter_3)) @php $total += $account_budget->quarter_3; @endphp {{@num_format($account_budget->quarter_2)}} @else 0 @endif @if(!is_null($account_budget) && !is_null($account_budget->quarter_4)) @php $total += $account_budget->quarter_4; @endphp {{@num_format($account_budget->quarter_4)}} @else 0 @endif {{@num_format($total)}}
@lang('sale.total') {{@num_format($budget->whereIn('accounting_account_id', $account_ids)->sum('quarter_1'))}} {{@num_format($budget->whereIn('accounting_account_id', $account_ids)->sum('quarter_2'))}} {{@num_format($budget->whereIn('accounting_account_id', $account_ids)->sum('quarter_3'))}} {{@num_format($budget->whereIn('accounting_account_id', $account_ids)->sum('quarter_4'))}}
@lang('lang_v1.grand_total') {{@num_format($budget->sum('quarter_1'))}} {{@num_format($budget->sum('quarter_2'))}} {{@num_format($budget->sum('quarter_3'))}} {{@num_format($budget->sum('quarter_4'))}}
@lang('accounting::lang.export_to_pdf') @lang('accounting::lang.export_to_csv') @lang('accounting::lang.export_to_excel')
@foreach($account_types as $account_type => $account_type_detail ) @php $account_ids=[]; @endphp @foreach($accounts->where('account_primary_type', $account_type)->sortBy('name')->all() as $account) @php $account_ids[]=$account->id; $account_budget = $budget->where('accounting_account_id', $account->id)->first(); @endphp @endforeach @endforeach
@lang('account.account') {{$fy_year}}
{{$account_type_detail['label']}}
{{$account->name}} @if(!is_null($account_budget) && !is_null($account_budget->yearly)) {{@num_format($account_budget->yearly)}} @else 0 @endif
@lang('sale.total') {{@num_format($budget->whereIn('accounting_account_id', $account_ids)->sum('yearly'))}}
@lang('lang_v1.grand_total') {{@num_format($budget->sum('yearly'))}}