@php
    use Carbon\Carbon;
    
    $statement = $loan->statement;
    $collection = collect($statement->more);
    $data = '<div style="font-size: 1.2em">';
    $data .=
        '<img src="./logo1.png" style="width:160px"/><br/><div style="font-weight: bolder;margin-top:2em">ACCOUNT STATEMENT FOR : ' .
        strtoupper($loan->more->account_info->first_name . ' ' . $loan->more->account_info->last_name) .
        '</div><div style="margin-top:2em">
        <div style="color: rgb(255, 34, 34);font-size:1.4em;font-weight:bolder;">ACCOUNT STATEMENT</div>
    </div>
    <div style="font-size: 1em; margin-top: 1em">
        EMAIL ADDRESS:  ' .
        strtoupper($loan->more->account_info->personal_email) .
        '<br/>
        ACCOUNT NAME:  ' .
        strtoupper($loan->more->account_info->first_name) .
        ' ' .
        strtoupper($loan->more->account_info->other_name) .
        ' ' .
        strtoupper($loan->more->account_info->last_name) .
        '<br/>
    </div>
    ';
    $data .= '<div style="margin-top: 2em">
    <table style="border-collapse: collapse;width: 100%;max-width: 100%">
        <tr style="border: 2px solid #222">
            <th colspan="5" style="background-color: #888;color: #fff;font-size: 0.8em;padding: 10px 5px;font-weight: bolder" align="left">ACCOUNT SUMMARY</th>
        </tr>
        <tr style="border: 2px solid #222">
            <td style="border: 1px solid #222; font-size: 0.8em;padding: 10px;" align="left">Currency</td>
            <td style="border: 1px solid #222; font-size: 0.8em;padding: 10px;" align="left">Opening Balance</td>
            <td style="border: 1px solid #222; font-size: 0.8em;padding: 10px;" align="left">Credits</td>
            <td style="border: 1px solid #222; font-size: 0.8em;padding: 10px;" align="left">Debits</td>
            <td style="border: 1px solid #222; font-size: 0.8em;padding: 10px;" align="left">Closing Balance</td>
        </tr>
        <tr style="border: 2px solid #222">
            <td style="border: 1px solid #222; background-color: rgb(37, 184, 0);font-size: 0.7em;padding: 10px" align="left">NGN</td>
        ';
    $data .=
        '
<td style="border: 1px solid #222; background-color: rgb(37, 184, 0);font-size: 0.7em;padding: 10px" align="left">' .
        number_format($collection->first()->amount, 2) .
        '</td>
<td style="border: 1px solid #222; background-color: rgb(37, 184, 0);font-size: 0.7em;padding: 10px" align="left">' .
        number_format($collection->where('type', 'credit')->sum('amount'), 2) .
        '</td>
<td style="border: 1px solid #222; background-color: rgb(37, 184, 0);font-size: 0.7em;padding: 10px" align="left">' .
        number_format($collection->where('type', 'debit')->sum('amount'), 2) .
        '</td>
<td style="border: 1px solid #222; background-color: rgb(37, 184, 0);font-size: 0.7em;padding: 10px" align="left">' .
        number_format($collection->last()->amount, 2) .
        '</td>';
    $data .= '</tr>
    </table>
    <div style="margin-top: 2em">
        <table style="border-collapse: collapse;width: 100%;max-width: 100%">
            <tr style="border: 2px solid #222">
                <th style="border: 1px solid #222;background-color: #888;color: #fff;font-size: 0.8em;padding: 10px 5px;font-weight: bolder" align="center">DATE</th>
                <th style="border: 1px solid #222;background-color: #888;color: #fff;font-size: 0.8em;padding: 10px 5px;font-weight: bolder" align="center">NARATION</th>
                <th style="border: 1px solid #222;background-color: #888;color: #fff;font-size: 0.8em;padding: 10px 5px;font-weight: bolder" align="center">DEBIT AMOUNT</th>
                <th style="border: 1px solid #222;background-color: #888;color: #fff;font-size: 0.8em;padding: 10px 5px;font-weight: bolder" align="center">CREDIT AMOUNT</th>
                <th style="border: 1px solid #222;background-color: #888;color: #fff;font-size: 0.8em;padding: 10px 5px;font-weight: bolder" align="center">BALANCE</th>
            </tr>';
    foreach ($statement->more as $file) {
        $data .= '<tr style="border: 2px solid #222">';
        $data .= '<td style="border: 1px solid #222;padding: 10px 5px;font-size: 0.7em;" align="center">' . Carbon::parse($file->date)->format('F d, Y h:i A') . '</td>';
        $data .= '<td style="border: 1px solid #222;padding: 10px 5px;font-size: 0.7em;" align="center">' . $file->narration . '</td>';
        if ($file->type == 'debit') {
            $data .= '<td style="border: 1px solid #222;padding: 10px 5px;font-size: 0.7em;color: #ff0000" align="center">-' . number_format($file->amount, 2) . '</td>';
            $data .= '<td style="border: 1px solid #222;padding: 10px 5px;font-size: 0.7em;" align="center"></td>';
        } else {
            $data .= '<td style="border: 1px solid #222;padding: 10px 5px;font-size: 0.7em;" align="center"></td>';
            $data .= '<td style="border: 1px solid #222;padding: 10px 5px;font-size: 0.7em;color: #00512B" align="center">+' . number_format($file->amount, 2) . '</td>';
        }
        $data .= '<td style="border: 1px solid #222;padding: 10px 5px;font-size: 0.7em;" align="center">' . number_format($file->balance, 2) . '</td>';
    }
    $data .= '</table>
    </div>
</div>';
    $data .= '</div>';
@endphp
{!! $data !!}