@foreach ($sub_category as $sub_cat) @endforeach @if (count($deposit_date) == 0) @endif @foreach ($deposit_date as $key => $dd) @php $dd = date('Y-d-m',strtotime($dd)); $total = 0; $bank_amount = 0; @endphp @foreach ($sub_category as $sub_cat) @endforeach @endforeach
{{ trans('cruds.report.date') }} {{$sub_cat->title}} {{ trans('cruds.report.balance') }}
{{date('d/m/Y',strtotime($dd))}} @foreach ($deposit_shop->where('date',$dd) as $ds) @if (($dd == $ds->date) && ($sub_cat->id == $ds->sub_category_id)) {{number_format($ds->amount,2)}} @if ($ds->bank_statement_id != null && $ds->status == 1) @if ($ds->bank_statement != null)
Credit : {{number_format($ds->bank_statement->amount,2)}} @php $bank_amount += $ds->bank_statement->amount; @endphp @endif @endif @php $total += $ds->amount; @endphp @endif @endforeach
{{number_format($bank_amount - $total,2)}}