@php
    header("Content-type: application/vnd-ms-excel");
    header("Content-Disposition: attachment; filename=Neraca Lajur Tahun ". $tahun .".xls");
@endphp

@extends('layouts.blank')

@section('title')
    Laporan Neraca
@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 Neraca Lanjut</p>
    @if($tahun != '') <p class="text-center my-0">{{ $tahun }}</p> @endif
    <br>

    <table class="table table-bordered">
        <tbody>
        <tr>
            <td class="text-nowrap text-center py-1" rowspan="2"><b>NAMA AKUN</b></td>
            <td class="text-nowrap text-center py-1" colspan="2"><b>NERACA AWAL</b></td>
            <td class="text-nowrap text-center py-1" colspan="2"><b>NERACA MUTASI</b></td>
            <td class="text-nowrap text-center py-1" colspan="2"><b>NERACA PERCOBAAN</b></td>
            <td class="text-nowrap text-center py-1" colspan="2"><b>NERACA SISA</b></td>
            <td class="text-nowrap text-center py-1" colspan="2"><b>AYAT PENYESUAIAN</b></td>
            <td class="text-nowrap text-center py-1" colspan="2"><b>NERACA SISA<br>SETELAH DISESUAIKAN</b></td>
            <td class="text-nowrap text-center py-1" colspan="2"><b>RUGI/LABA</b></td>
            <td class="text-nowrap text-center py-1" colspan="2"><b>NERACA AKHIR</b></td>
        </tr>
        <tr>
        @for($i = 1; $i <= 8; $i++)
            <td class="text-nowrap text-center py-1"><b>D</b></td>
            <td class="text-nowrap text-center py-1"><b>K</b></td>
        @endfor
        </tr>
        @php($debit_sisa = 0)
        @php($kredit_sisa = 0)
        @php($sesuai_debit = 0)
        @php($sesuai_kredit = 0)
        @php($sesuai_setelah_debit = 0)
        @php($sesuai_setelah_kredit = 0)
        @foreach($akun as $value)
            <tr>
                <td class="py-1 text-nowrap {{ (count(explode('.', $value->kode_tampil)) == 1) ? 'font-weight-bold' : '' }}">
                    @for($i = 1; $i < strlen($value->kode_tampil); $i++) &nbsp; @endfor
                    {{ $value->text }}
                </td>
                <td class="text-right py-1">@if($value->debit_awal > 0) {{ ($value->debit_awal) }} @endif</td>
                <td class="text-right py-1">@if($value->kredit_awal > 0) {{ ($value->kredit_awal) }} @endif</td>
                <td class="text-right py-1">@if($value->debit > 0) {{ ($value->debit) }} @endif</td>
                <td class="text-right py-1">@if($value->kredit > 0) {{ ($value->kredit) }} @endif</td>
                <td class="text-right py-1">@if($value->debit_percobaan > 0) {{ ($value->debit_percobaan) }} @endif</td>
                <td class="text-right py-1">@if($value->kredit_percobaan > 0) {{ ($value->kredit_percobaan) }} @endif</td>
                <td class="text-right py-1">@if($value->debit_sisa > 0) {{ ($value->debit_sisa) }} @endif</td>
                <td class="text-right py-1">@if($value->kredit_sisa > 0) {{ ($value->kredit_sisa) }} @endif</td>
                <td class="text-right py-1">{{ $value->penyesuaian->debit ?? '' }}</td>
                <td class="text-right py-1">{{ $value->penyesuaian->kredit ?? '' }}</td>
                <td class="text-right py-1">{{ ($value->debit_sisa_setelah ?? '') }}</td>
                <td class="text-right py-1">{{ ($value->kredit_sisa_setelah ?? '') }}</td>
                <td class="text-right py-1">@if($value->pengeluaran > 0) {{ ($value->pengeluaran) }} @endif</td>
                <td class="text-right py-1">@if($value->pendapatan > 0) {{ ($value->pendapatan) }} @endif</td>
                <td class="text-right py-1">{{ ($value->debit_akhir ?? '') }}</td>
                <td class="text-right py-1">{{ ($value->kredit_akhir ?? '') }}</td>
            </tr>
            @php($debit_sisa += $value->debit_sisa > 0 ? $value->debit_sisa : 0)
            @php($kredit_sisa += $value->kredit_sisa > 0 ? $value->kredit_sisa : 0)
            @php($sesuai_debit += $value->penyesuaian->debit ?? 0)
            @php($sesuai_kredit += $value->penyesuaian->kredit ?? 0)
            @php($sesuai_setelah_debit += $value->debit_sisa_setelah ?? 0)
            @php($sesuai_setelah_kredit += $value->kredit_sisa_setelah ?? 0)
        @endforeach
        @php($laba = $akun->sum('pendapatan') - $akun->sum('pengeluaran'))
        <tr>
            <td class="py-1 text-nowrap"><b>Sisa Hasil Usaha</b></td>
            <td class="text-right py-1"></td>
            <td class="text-right py-1"></td>
            <td class="text-right py-1"></td>
            <td class="text-right py-1"></td>
            <td class="text-right py-1"></td>
            <td class="text-right py-1"></td>
            <td class="text-right py-1"></td>
            <td class="text-right py-1"></td>
            <td class="text-right py-1"></td>
            <td class="text-right py-1"></td>
            <td class="text-right py-1"></td>
            <td class="text-right py-1"></td>
            <td class="text-right py-1">{{ ($laba) }}</td>
            <td class="text-right py-1"></td>
            <td class="text-right py-1"></td>
            <td class="text-right py-1">{{ ($laba) }}</td>
        </tr>
        <tr>
            <td class="py-1 text-right"><b>Total</b></td>
            <td class="text-right py-1"><b>{{ ($akun->sum('debit_awal')) }}</b></td>
            <td class="text-right py-1"><b>{{ ($akun->sum('kredit_awal')) }}</b></td>
            <td class="text-right py-1"><b>{{ ($akun->sum('debit')) }}</b></td>
            <td class="text-right py-1"><b>{{ ($akun->sum('kredit')) }}</b></td>
            <td class="text-right py-1"><b>{{ ($akun->sum('debit_percobaan')) }}</b></td>
            <td class="text-right py-1"><b>{{ ($akun->sum('kredit_percobaan')) }}</b></td>
            <td class="text-right py-1"><b>{{ ($akun->sum('debit_sisa')) }}</b></td>
            <td class="text-right py-1"><b>{{ ($akun->sum('kredit_sisa')) }}</b></td>
            <td class="text-right py-1"><b>{{ ($akun->sum('penyesuaian_debit')) }}</b></td>
            <td class="text-right py-1"><b>{{ ($akun->sum('penyesuaian_kredit')) }}</b></td>
            <td class="text-right py-1"><b>{{ ($akun->sum('debit_sisa_setelah')) }}</b></td>
            <td class="text-right py-1"><b>{{ ($akun->sum('kredit_sisa_setelah')) }}</b></td>
            <td class="text-right py-1"><b>{{ ($akun->sum('pengeluaran') + $laba) }}</b></td>
            <td class="text-right py-1"><b>{{ ($akun->sum('pendapatan')) }}</b></td>
            <td class="text-right py-1"><b>{{ ($akun->sum('debit_akhir')) }}</b></td>
            <td class="text-right py-1"><b>{{ ($akun->sum('kredit_akhir') + $laba) }}</b></td>
        </tr>
        </tbody>
    </table>

@endsection