@php
    header("Content-type: application/vnd-ms-excel");
    header("Content-Disposition: attachment; filename=Arus Kas ". $bulan .".xls");
@endphp

@extends('layouts.blank')

@section('title')
    Laporan Arus Kas
@endsection

@section('body')
    <h3 class="text-center my-0">{{ $profil->nama }}</h3>
    <p class="text-center my-0">{{ $profil->alamat }}, Telp: {{ $profil->notelp }}</p>
    <hr class="my-1">
    <p class="text-center my-0">Laporan Arus Kas</p>
    @if($bulan != '') <p class="text-center my-0">{{ $bulan }}</p> @endif
    <br>
    <table class="table table-bordered">
        <tbody>
        @php($total_kredit = 0)
        @php($total_debit = 0)
        @php($total = 0)
        @foreach($kas as $value)
            <tr>
                <td class="text-nowrap py-1 {{ (count(explode('.', $value['akun']['kode_tampil'])) == 1) ? 'font-weight-bold' : '' }}">
                    @for($i = 1; $i < strlen($value['akun']['kode_tampil']); $i++) &nbsp; @endfor
                    {{ $value['akun']['text'] }}
                </td>
                <td class="text-right py-1">{{ format_number($value['total_kredit']) }}</td>
                <td class="text-right py-1">{{ format_number($value['total_debit']) }}</td>
                <td class="text-right py-1">
                    @if($value['total_kredit']-$value['total_debit'] != 0)
                        {{ format_akuntansi($value['total_kredit']-$value['total_debit']) }}
                    @endif
                </td>
                @php($total_kredit += $value['total_kredit'])
                @php($total_debit += $value['total_debit'])
                @php($total = $total + ($value['total_kredit'] - $value['total_debit']))
            </tr>
        @endforeach
        <tr>
            <td class="text-nowrap py-1 px-1" colspan="1"><b>SALDO KAS</b></td>
            <td class="text-right py-1">{{ format_akuntansi($total_kredit) }}</td>
            <td class="text-right py-1">{{ format_akuntansi($total_debit) }}</td>
            <td class="text-right py-1">{{ format_akuntansi($total) }}</td>
        </tr>
        </tbody>
    </table>


@endsection