@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">Customer Guarantee Deposit - <small class="text-muted" style="font-weight: 400">Customers with remaining and refunded guarantee deposits.</small></label> 

                <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">
                        @include('reports.guarantee-deposits._customers-with-gd')
                    </section>
                </div>
            </div>
        </div> 
	</div>
</div>
@endsection

@section('scripts')
<script src="{{ URL::asset('js/reports/JsonExportExcel.min.js') }}"></script>
<script type="text/javascript">
$(document).ready(function() {
    $dt = $('#table-customers').DataTable({
        deferred: true,
        processing: true,
        serverSide: true,
        bSort: false,
        ajax: {
            url: $app_url + '/reports/guarantee-deposits/dt',
            beforeSend: function() {
                showBoxLoadingState();
            },
            complete: function() {
                removeBoxLoadingState();
            }
        },
        columns: [
            { data:'acct_number',       name:'acct_number',         orderable:false,   className:"text-uppercase" },
            { data:'customer_name',     name:'customer_name',       orderable:false,   className:"text-uppercase" },
            { data:'address',           name:'address',             orderable:false,   className:"text-uppercase" },
            { data:'class',             name:'class',               orderable:false,   className:"text-uppercase" },
            { data:'book',              name:'book',                orderable:false,   className:"text-uppercase" },
            { data:'gdeposit',          name:'gdeposit',            orderable:false,   className:"text-uppercase",  searchable:false },
            { data:'gdeposit_refunded', name:'gdeposit_refunded',   orderable:false,   className:"text-uppercase",  searchable:false },
            { data:'contract_no',       name:'contract_no',         orderable:false,   className:"text-uppercase",  searchable:false },
            { data:'date_installed',    name:'date_installed',      orderable:false,   className:"text-uppercase",  searchable:false },
            { data:'status',            name:'status',              orderable:false,   className:"text-uppercase",  searchable:false },
            { data:'refunded',          name:'refunded',            orderable:false,   className:"text-uppercase",  searchable:false }
        ]
    });

    $('#table-customers_filter input').unbind();
    $('#table-customers_filter input').bind('keyup', function(e) {
        if(e.keyCode == 13) {
            $dt.search($(this).val()).draw();
        }
    });

    $('#report-excel').click(function() {
        ajaxcall('{!! route("gd.export-excel") !!}','GET',{},function(response){
            if($.isEmptyObject(response)){
                $.confirm({
                    draggable: true,
                    type: 'red',
                    title: false,
                    content: '<p class="text-center"><i class="fa fa-exclamation-triangle text-bold text-danger" style="font-size:54px"></i></p>' +
                            '<p class="text-center">NO RECORD FOUND</p>',
                    buttons: {
                        yes: {
                            text: '<small>[ENTER]</small> OK!',
                            btnClass: 'btn-danger',
                            keys: ['enter', 'esc']
                        }
                    }
                });
            }else{
                var $header = ["ACCOUNT NUMBER", "CUSTOMER NAME", "ADDRESS", "CLASS", "BOOK", "GD", "GD REFUNDED", "CONTRACT NO", "DATE INSTALLED", "STATUS", "REFUNDED"];
                var $details = response;
                export_to_excel($header, $details, "Customer Guarantee Deposits");
            }
        },true);
    });

    function export_to_excel(header, details, filename){
        var option={};

        var file_name = filename;

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

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

@endsection