@extends('app')

@section('content')

<center> <button onclick="ExportToExcel('xlsx')" style="border:0px; padding:15px 20px; font-weight:bold; background:#4E2E74; color:#fff;">Download Report</button></center>

<table id="tbl_exporttable_to_xls">
    <tr><td>
     
    <table class = "table table-bordered">
        <thead>
            <tr>
                <th>Effective Date</th>
                <th>Status</th>
                <th>Client</th>
                <th>Name</th>
                <th>Agreement</th>
                <th>Agreement Type</th>
                <th>Agreement Descrip</th>
                <th>Trans. Type</th>
                <th>Invoice #</th>
                <th>Ref</th>
                <th style="text-align:right">Interest</th>
                <th style="text-align:right">Capital</th>
                <th style="text-align:right">Total</th>
                <th>Comment</th>
            </tr>
        </thead>
        
        <tbody>

            @foreach ($transactions as $transaction) 
            <tr>
                <td>{!! App\Helpers\DateHelper::stringify($transaction->effective_date) !!}</td>
                <td>{{ $transaction->agreement_status }}</td>
                <td>{{ $transaction->client_code }}</td>
                <td>{{ $transaction->client_name }}</td>
                <td>{{ $transaction->agreement_code }}</td>
                <td>{{ ucfirst($transaction->agreement_type) }}</td>
                <td>{{ $transaction->agreement_description }}</td>
                <td>{{ ucfirst($transaction->type_description) }}</td>
                <td>{{ $transaction->invoice_no }}</td>    
                <td>{{ $transaction->reference }}</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($transaction->interest) !!}</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($transaction->capital) !!}</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($transaction->capital + $transaction->interest) !!}</td> 
                <td>{{ $transaction->comment }}</td>
            </tr>
            @endforeach

        </tbody>
            
        <tfoot>
            <tr>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td>TOTALS</td>
                <td></td>
                <td></td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($total->interest) !!}</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($total->capital) !!}</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($total->capital + $total->interest) !!}</td> 
                <td></td>
            </tr>    
        </tfoot>
     </table>
        
    <div style="page-break-inside:avoid;">
        <h4>Summary</h4>
        <table class = "table table-bordered">
            <thead>
                <tr>
                    <th style="text-align:center">Type</th>
                    <th style="text-align:right">Interest</th>
                    <th style="text-align:right">Capital</th>
                    <th style="text-align:right">Total</th>
                </tr>
            </thead>
            
            <tbody>
                
                @foreach ($summary as $sum)
                  
                <tr>
                    <td>{{ $sum['description'] }}</td>
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($sum['interest']) !!}</td>
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($sum['capital']) !!}</td>
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($sum['capital'] + $sum['interest']) !!}</td>    
                </tr>
    
                @endforeach
             
            </tbody>
        </table>
    </div>    


@stop

</td>
</tr>
</table>
@section('scripts')
    
<script type="text/javascript" src="https://unpkg.com/xlsx@0.15.1/dist/xlsx.full.min.js"></script>
<script>
   
   function ExportToExcel(type, fn, dl) {
            var elt = document.getElementById('tbl_exporttable_to_xls');
            var wb = XLSX.utils.table_to_book(elt, { sheet: "sheet1" });

           return dl ?
                XLSX.write(wb, { bookType: type, bookSST: true, type: 'base64' }) :
                XLSX.writeFile(wb, fn || ('{{ $report->description }}.' + (type || 'xlsx')));
        }


</script>
    
@stop