@extends('layouts.app')
@section('title', session('company_code') . ' Elite System')

@section('body')
<div class="box box-default">
    <div class="box-body">
        <div class="row">
            <div class="col-xs-12 hidden-print">
                <label class="text-primary" style="font-size:16px; margin-top:6px">Outstanding Advance Payment - <small class="text-muted" style="font-weight: 400">Customers remaining advances.</small></label> 

                <div class="pull-right" style="margin-right:3px">
                    <button class="btn btn-default" id="report-print"><i class="fa fa-fw fa-print text-warning"></i> Print</button>
                </div>
                <div class="pull-right" style="margin-right:3px">
                    <button class="btn btn-default" id="report-excel"><i class="fa fa-fw fa-file-excel-o text-success"></i> Excel</button>
                </div> 
            </div>
        </div>
        <hr style="margin-top:6px; margin-bottom:8px">
        <div class="row">
            <div id="report-container">
                <div class="col-xs-12">
                    <section id="report-printable">
                        <p class="text-center text-bold" style="margin-bottom:0px">{{ strtoupper(session('company_name')) }}</p>
                        <p class="text-center" style="margin-bottom:0px">{{ strtoupper(session('branch_name')) }}</p>
                        <p class="text-center text-bold" style="margin-bottom:0px">Outstanding Advance Payment</p>
                        <p class="text-center">As of {{ date_format(date_create($date), 'M d, Y') }}</p>
                        <br>
                        <table class="table table-bordered table-condensed">
                            <thead>
                                <tr>
                                    <th>Account Number</th>
                                    <th>Customer Name</th>
                                    <th>Address</th>
                                    <th>Class</th>
                                    <th>Book</th>
                                    <th class="text-right">Total Amount</th>
                                    <th class="text-right">Amount Used</th>
                                    <th class="text-right">Amount Remaining</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($data as $d)
                                    <tr>
                                        <td>{{ $d->acct_number }}</td>
                                        <td>{{ strtoupper($d->customer_name) }}</td>
                                        <td>{{ strtoupper($d->address) }}</td>
                                        <td>{{ $d->class }}</td>
                                        <td>{{ $d->book }}</td>
                                        <td class="text-right">{{ number_format((float)$d->total_advances, 2,".",",") }}</td>
                                        <td class="text-right">{{ number_format((float)$d->total_used, 2,".",",") }}</td>
                                        <td class="text-right">{{ number_format((float)$d->total_remaining, 2,".",",") }}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                            <tfoot>
                                <tr>
                                    <th colspan="5">Total Number of Account: {{ $total['accounts'] }}</th>
                                    <th class="text-right">{{ number_format((float)$total['advances'], 2,".",",") }}</th>
                                    <th class="text-right">{{ number_format((float)$total['used'], 2,".",",") }}</th>
                                    <th class="text-right">{{ number_format((float)$total['remaining'], 2,".",",") }}</th>
                                </tr>
                            </tfoot>
                        </table>
                    </section>
                </div>
            </div>
        </div> 
    </div>
</div>
@endsection

@section('scripts')
<script src="{{ URL::asset('js/reports/JsonExportExcel.min.js') }}"></script>
<script src="{{ URL::asset('js/printThis.js') }}"></script>
<script type="text/javascript">
$(document).ready(function() {
    $('#report-print').click(function() {
        $('#report-printable').printThis({
            importCSS: true,
            loadCSS: $app_url + '/css/printthis.css'
        });
    });

    $('#report-excel').click(function() {
        var option={};

        var table_class_name = 'table';
        var file_name        = 'Advance Payment Summary ';

        var $header  = $('.table > thead');
        var $details = $('.'+table_class_name).find('tbody > tr');

        var $column = $header.find('tr > th').map(function(index, value){
            return $.trim($(value).text());
        }).get();
        
        var $row  = [];     

        $.each($details, function(){            
            var $d    = $(this);
            var $cell = {};

            for(i=0; i<$column.length; i++){
                $cell[$column[i]] = $d.find('td').eq(i).text();
            }           
            $row.push($cell);
        });

        option.fileName = file_name + '@' + new Date().toLocaleString();
        option.datas = [{
                sheetData   : $row,
                sheetName   : 'Advance Payment Summary',
                sheetHeader : $column
        }]

        var toExcel=new ExportJsonExcel(option);
        toExcel.saveExcel();
    });
});
</script>
@endsection