@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">Refund Vouchers - <small class="text-muted" style="font-weight: 400">List of Customer Refund Vouchers</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">List of Refund Vouchers</p>
                        <p class="text-center">As of {{ date_format(date_create($date), 'M d, Y') }}</p>
                        <br>
                        <table class="table table-hover table-condensed table-bordered">
						    <thead>
						        <tr class="table-header-bg">
						            <th>Acct/Appl No</th>
						            <th>Customer Name</th>
						            <th class="text-center">Voucher No</th>
						            <th class="text-right">Appl GD</th>
						            <th class="text-right">Appl Materials</th>
						            <th class="text-right">Appl Services</th>
						            <th class="text-right">Appl DP</th>
						            <th class="text-right">GD</th>
						            <th class="text-right">Advances</th>
						            <th class="text-right">Proc Fee</th>
						            <th class="text-right">Total Amt</th>
						            <th>Explanation</th>
						            <th class="text-right">Date Refunded</th>
						        </tr>
						    </thead>
						    <tbody>
						    	@foreach($data AS $d)
						        <tr>
						        	<td>{{ $d->acct_number ? $d->acct_number : $d->application_number }}</td>
						        	<td>{{ $d->acct_number ? strtoupper($d->customer_name) : strtoupper($d->applicant_name) }}</td>
						        	<td class="text-center">{{ $d->voucher_no }}</td>
        							<td class="text-right">{{ number_format((float)$d->appl_gdeposit, 2,".",",") }}</td>
        							<td class="text-right">{{ number_format((float)$d->appl_materials, 2,".",",") }}</td>
        							<td class="text-right">{{ number_format((float)$d->appl_services, 2,".",",") }}</td>
        							<td class="text-right">{{ number_format((float)$d->appl_downpayment, 2,".",",") }}</td>
        							<td class="text-right">{{ number_format((float)$d->gd, 2,".",",") }}</td>
        							<td class="text-right">{{ number_format((float)$d->advances, 2,".",",") }}</td>
        							<td class="text-right">{{ number_format((float)$d->processing_fee, 2,".",",") }}</td>
        							<td class="text-right">{{ number_format((float)$d->total_amount, 2,".",",") }}</td>
						        	<td>{{ $d->explanation }}</td>
						        	<td class="text-right">{{ date('M d, Y', strtotime($d->date_refunded)) }}</td>
						        </tr>
						        @endforeach	
						    </tbody>
						    <tfoot>
						    	<tr>
						    		<th colspan="3">Total Number of Refund Voucher: {{ $total['count'] }}</th>
						    		<th class="text-right">{{ number_format((float)$total['appl_gdeposit'], 2,".",",") }}</th>
						    		<th class="text-right">{{ number_format((float)$total['appl_materials'], 2,".",",") }}</th>
						    		<th class="text-right">{{ number_format((float)$total['appl_services'], 2,".",",") }}</th>
						    		<th class="text-right">{{ number_format((float)$total['appl_downpayment'], 2,".",",") }}</th>
						    		<th class="text-right">{{ number_format((float)$total['gdeposit'], 2,".",",") }}</th>
						    		<th class="text-right">{{ number_format((float)$total['advances'], 2,".",",") }}</th>
						    		<th class="text-right">{{ number_format((float)$total['processing_fee'], 2,".",",") }}</th>
						    		<th class="text-right">{{ number_format((float)$total['amount'], 2,".",",") }}</th>
						    		<th></th>
                                    <th></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        = 'Refund Vouchers';

        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]] = $.trim($d.find('td').eq(i).text());
            }           
            $row.push($cell);
        });

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

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