Statement of Budget
Financial Year: {{$data['fiscalYear']}}
Organization Name: {{$data['companyInfo']['name']}}
Certificate No: {{$data['companyInfo']['certificate']}}
{{-- --}} @foreach ($data['misBudgetStatementConfig']['firstTable'] as $config) @if ($config['hasValue'] == true) @php $varience = ''; if($config['sl'] > 6){ $varience = number_format((((isset($data['reportDataMIS']['actual'][$config['keyName']]) ?$data['reportDataMIS']['actual'][$config['keyName']] : 0) - (isset($data['reportDataMIS']['projected'][$config['keyName']]) ? $data['reportDataMIS']['projected'][$config['keyName']] : 0))/(isset($data['reportDataMIS']['projected'][$config['keyName']]) ? $data['reportDataMIS']['projected'][$config['keyName']] : 0))*100,0).'%'; }else{ $varience = number_format((isset($data['reportDataMIS']['actual'][$config['keyName']]) ?$data['reportDataMIS']['actual'][$config['keyName']] : 0) - (isset($data['reportDataMIS']['projected'][$config['keyName']]) ? $data['reportDataMIS']['projected'][$config['keyName']] : 0),0); } @endphp @else @endif @endforeach
SL Description {{$data['previousFyscalYear']->name}}@if (!empty($data['proposedFiscalYear'])) {{$data['proposedFiscalYear']}} (Proposed) @else{{$data['fiscalYear']}} (Proposed) @endif {{$data['fiscalYear']}} (Proposed) Remarks
projected Actual Varience(%)
@if (!empty($config['sl'])) @endif{{$config['sl']}} {{$config['name']}}{{isset($data['reportDataMIS']['projected'][$config['keyName']]) ? number_format($data['reportDataMIS']['projected'][$config['keyName']]) : 0}} {{isset($data['reportDataMIS']['actual'][$config['keyName']]) ? number_format($data['reportDataMIS']['actual'][$config['keyName']]) : 0}}{{ $varience }} {{isset($data['reportDataMIS']['proposed'][$config['keyName']]) ? number_format($data['reportDataMIS']['proposed'][$config['keyName']]) : 0}}
@foreach ($data['misBudgetStatementConfig']['secondTable'] as $config) @if ($config['hasValue'] == true) @else @endif @endforeach
SL Description Current Balance as of {{\Carbon\Carbon::parse($data['previousFyscalYear']->fyEndDate)->format('d F Y')}}
@if (!empty($config['sl'])) @endif{{$config['sl']}} {{$config['name']}}{{isset($data['reportDataMISTable2'][$config['keyName']]) ? number_format($data['reportDataMISTable2'][$config['keyName']]) : 0}}
{{-- --}} @foreach ($data['lavel1Config'] as $lvl1ParentKey => $item1) @php $ledgerIds1 = json_decode($item1['acc_ledgerId']); @endphp @if ($item1['has_input'] == 1) @else @endif @if (isset($data['lavel2Config'][$item1['id']])) @php $i1projected = 0; $i1actual = 0; $i1proposed = 0; @endphp @foreach ($data['lavel2Config'][$item1['id']] as $item2) @php $ledgerIds = json_decode($item2['acc_ledgerId']); @endphp @if ($item2['has_input'] == 1) @php $i1projected += isset($data['reportData']['projected'][$item2['id']]) ? $data['reportData']['projected'][$item2['id']] : 0; $i1actual += isset($data['reportData']['actual'][$item2['id']]) ? $data['reportData']['actual'][$item2['id']] : 0; $i1proposed += isset($data['reportData']['proposed'][$item2['id']]) ? $data['reportData']['proposed'][$item2['id']] : 0; @endphp @else @endif @if (isset($data['lavel3Config'][$item2['id']])) @php $i2projected = 0; $i2actual = 0; $i2proposed = 0; @endphp @foreach ($data['lavel3Config'][$item2['id']] as $item3) @php $ledgerIds3 = json_decode($item3['acc_ledgerId']); @endphp @if ($item3['has_input'] == 1) @php $i2projected += isset($data['reportData']['projected'][$item3['id']])? $data['reportData']['projected'][$item3['id']] : 0 ; $i2actual += isset($data['reportData']['actual'][$item3['id']])? $data['reportData']['actual'][$item3['id']] : 0 ; $i2proposed += isset($data['reportData']['proposed'][$item3['id']])? $data['reportData']['proposed'][$item3['id']] : 0 ; @endphp @else @endif @if (isset($data['lavel4Config'][$item3['id']])) @php $i3projected = 0; $i3actual = 0; $i3proposed = 0; @endphp @foreach ($data['lavel4Config'][$item3['id']] as $item4) @php $ledgerIds4 = json_decode($item4['acc_ledgerId']); @endphp @if ($item4['has_input'] == 1) @php $i3projected += isset($data['reportData']['projected'][$item4['id']])? $data['reportData']['projected'][$item4['id']] : 0; $i3actual += isset($data['reportData']['actual'][$item4['id']])? $data['reportData']['actual'][$item4['id']] : 0; $i3proposed += isset($data['reportData']['proposed'][$item4['id']])? $data['reportData']['proposed'][$item4['id']] : 0; @endphp @else @endif @endforeach {{-- end of level 4 --}} @if ($item3['has_total'] == 1) @if ($i3projected >0 && $i3actual > 0) @else @endif @endif @endif @endforeach {{-- end of level 3 --}} @if ($item2['has_total'] == 1) @if ($item2['id'] == 74) @else @endif @if ($i2projected >0 && $i2actual > 0) @else @endif @endif @endif @endforeach {{-- end of level 2 --}} @if ($item1['has_total'] == 1) @if ($item1['id'] == 62) @else @endif @if ($i1projected >0 && $i1actual > 0) @else @endif @endif @endif @endforeach {{-- end of level 1 --}}
SL Description {{$data['previousFyscalYear']->name}}@if (!empty($data['proposedFiscalYear'])) {{$data['proposedFiscalYear']}} (Proposed) @else{{$data['fiscalYear']}} (Proposed) @endif {{$data['fiscalYear']}} (Proposed)
projected Actual Varience(%)
@if ($item1['has_sl'] == 1){{$item1['sl_no']}}. @endif {{$item1['name']}} :{{isset($data['reportData']['projected'][$item1['id']])? number_format($data['reportData']['projected'][$item1['id']]) : 0}} {{isset($data['reportData']['actual'][$item1['id']])? number_format($data['reportData']['actual'][$item1['id']]) : 0}} {{isset($data['reportData']['variance'][$item1['id']])? $data['reportData']['variance'][$item1['id']] : "0%"}} {{isset($data['reportData']['proposed'][$item1['id']])? number_format($data['reportData']['proposed'][$item1['id']]) : 0}}
@if ($item2['has_sl'] == 1){{$item2['sl_no']}}. @endif{{$item2['name']}}{{isset($data['reportData']['projected'][$item2['id']])? number_format($data['reportData']['projected'][$item2['id']]) : 0}} {{isset($data['reportData']['actual'][$item2['id']])? number_format($data['reportData']['actual'][$item2['id']]) : 0}} {{isset($data['reportData']['variance'][$item2['id']])? $data['reportData']['variance'][$item2['id']] : "0%"}} {{isset($data['reportData']['proposed'][$item2['id']])? number_format($data['reportData']['proposed'][$item2['id']]) : 0}}
@if ($item3['has_sl'] == 1){{$item3['sl_no']}}. @endif {{$item3['name']}}{{isset($data['reportData']['projected'][$item3['id']])? number_format($data['reportData']['projected'][$item3['id']]) : 0}} {{isset($data['reportData']['actual'][$item3['id']])? number_format($data['reportData']['actual'][$item3['id']]) : 0}} {{isset($data['reportData']['variance'][$item3['id']])? $data['reportData']['variance'][$item3['id']] : "0%"}} {{isset($data['reportData']['proposed'][$item3['id']])? number_format($data['reportData']['proposed'][$item3['id']]) : 0}}
@if ($item4['has_sl'] == 1){{$item4['sl_no']}}. @endif {{$item4['name']}}{{isset($data['reportData']['projected'][$item4['id']])? number_format($data['reportData']['projected'][$item4['id']]) : 0}} {{isset($data['reportData']['actual'][$item4['id']])? number_format($data['reportData']['actual'][$item4['id']]) : 0}} {{isset($data['reportData']['variance'][$item4['id']])? $data['reportData']['variance'][$item4['id']] : "0%"}} {{isset($data['reportData']['proposed'][$item4['id']])? number_format($data['reportData']['proposed'][$item4['id']]) : 0}}
Total {{number_format($i3projected)}} {{number_format($i3actual)}}{{round((($i3actual-$i3projected)/$i3projected)*100)}}% 0%{{number_format($i3proposed)}}
Total Financial Expenses (1+....+6)Total{{number_format($i2projected)}} {{number_format($i2actual)}}{{round((($i2actual-$i2projected)/$i2projected)*100)}}% 0%{{number_format($i2proposed)}}
Total Income(1+....10)Total{{number_format($i1projected)}} {{number_format($i1actual)}}{{round((($i1actual-$i1projected)/$i1projected)*100)}}% 0%{{number_format($i1proposed)}}