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

@extends('layouts.blank')

@section('title')
    Laporan Buku Besar
@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 Buku Besar</p>
    @if($bulan != '') <p class="text-center my-0">{{ $bulan }}</p> @endif
    <br>
    @foreach($data as $value)
        @if(count($value['data']) > 0)
            <table class="table table-bordered mb-3">
                <thead>
                <tr>
                    <th colspan="5"><b>{{ $value['akun'] }}</b></th>
                </tr>
                <tr>
                    <th width="3%">No</th>
                    <th width="10%">Tanggal</th>
                    <th>Keterangan</th>
                    <th class="text-right" width="10%">Debit</th>
                    <th class="text-right" width="10%">Kredit</th>
                    <th class="text-right" width="10%">Saldo</th>
                </tr>
                </thead>
                <tbody>
                @php($saldo = 0)
                @foreach($value['data'] as $key => $item)
                    @php($saldo = $saldo + ($item->debit - $item->kredit))
                    <tr>
                        <td>{{ $key+1 }}</td>
                        <td>{{ $item->jurnal->tanggal }}</td>
                        <td>{{ $item->jurnal->keterangan }}</td>
                        <td class="text-right">{{ format_number($item->debit) }}</td>
                        <td class="text-right">{{ format_number($item->kredit) }}</td>
                        <td class="text-right">{{ format_number($saldo) }}</td>
                    </tr>
                @endforeach
                <tr>
                    <td class="text-right" colspan="3"><b>Total</b></td>
                    <td class="text-right"><b>{{ format_number($value['data']->sum('debit')) }}</b></td>
                    <td class="text-right"><b>{{ format_number($value['data']->sum('kredit')) }}</b></td>
                    <td class="text-right"><b>{{ format_number($saldo) }}</b></td>
                </tr>
                </tbody>
            </table>
        @endif
    @endforeach

@endsection