@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">
                <label class="text-primary" style="font-size:16px; margin-top:6px">Athena Loans</label>

                <div class="pull-right box-tools">
                    <a href="{{ url('athena/athena-loans/new') }}" class="btn btn-default btn-flat pull-right"><i class="fa fa-plus-circle text-success"></i> New Athena Loan</a>
                </div>

                <div class="pull-right" style="width:140px; margin-right:3px">
                <select id="filter-by-status" class="form-control select2 select2-hidden-accessible" data-placeholder="PAYMENT STATUS" style="width: 100%;" aria-hidden="true">
                        <option value="p">PAID</option>
                        <option value="up" selected="true">UNPAID</option>
                        <option value="c">CANCELLED</option>
                        <option value="d">DEFAULTED</option>
                    </select>
                </div>
            </div>
        </div>
        <hr style="margin-top:6px; margin-bottom:8px">
  		<div class="row">
    		<div class="col-xs-12">
      			<table class="table table-condensed table-hover" id="table-loans" style="width:100%">
                    <thead class="table-header-bg">
                        <tr>
                            <th width="10%">APPL NO.</th>
                            <th width="10%">ACCT NO.</th>
                            <th width="25%">CUSTOMER NAME</th>
                            <th width="5%">PRINCIPAL</th>
                            <th width="5%">INT RATE</th>
                            <th width="5%">INT AMT</th>
                            <th width="5%">NET AMT</th>
                            <th width="5%">TERMS</th>
                            <th width="5%">TERMS RMNG</th>
                            <th width="6%">MONTHLY</th>
                            <th width="6%">AMT PAID</th>
                            <th width="6%">BALANCE</th>
                            <th width="5%">STATUS</th>
                            <th width="2%"></th>
                        </tr>
                    </thead>
                </table>
    		</div>
	  	</div>
	</div>
</div>
@endsection

@section('scripts')
<script src="{{ URL::asset('js/elite.js') }}"></script>
<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() {
		$dt = $('#table-loans').DataTable({
            deferred: true,
            processing: true,
            serverSide: true,
            bSort: false,
            ajax: {
                url: $app_url + '/athena/athena-loans/dt',
                data: function(d) {
                    d.filter_by_status = $('#filter-by-status option:selected').val()
                }
            },
            columns: [
                { data:'appl_number',       name:'appl_number',			orderable:false,   className:"text-uppercase" },
                { data:'acct_number',       name:'acct_number',			orderable:false,   className:"text-uppercase" },
                { data:'cust_name',			name:'cust_name',			orderable:false,   className:"text-uppercase" },
                { data:'principal_amt',		name:'principal_amt',		orderable:false,   className:"text-uppercase",	searchable:false  },
                { data:'interest_rate',		name:'interest_rate',		orderable:false,   className:"text-uppercase",	searchable:false  },
                { data:'interest_amt',      name:'interest_amt',        orderable:false,   className:"text-uppercase",  searchable:false  },
                { data:'amt_remaining',		name:'amt_remaining',		orderable:false,   className:"text-uppercase",	searchable:false  },
                { data:'terms',				name:'terms',				orderable:false,   className:"text-uppercase",	searchable:false  },
                { data:'terms_remaining',	name:'terms_remaining',		orderable:false,   className:"text-uppercase",	searchable:false  },
                { data:'amortization_amt',	name:'amortization_amt',	orderable:false,   className:"text-uppercase",	searchable:false  },
                { data:'amt_paid',			name:'amt_paid',			orderable:false,   className:"text-uppercase",	searchable:false  },
                { data:'amt_remaining',		name:'amt_remaining',		orderable:false,   className:"text-uppercase",	searchable:false  },
                { data:'status',			name:'status',				orderable:false,   className:"text-uppercase",	searchable:false  },
                { data:'action',			name:'action',				orderable:false,   searchable:false }
            ],
        });

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

        $('#filter-by-status').on('change', function() {
            $dt.search($('#table-loans_filter input').val()).draw();
        });
	})
    .on('click', '.loan-cancel', function(){
        $id = $(this).data('id');

        $jc = $.confirm({
            title: false,
            draggable: true,
            columnClass: 'medium',
            content: function() {
                var self = this;

                return $.ajax({
                    url: $app_url + '/athena/athena-loans/cancel',
                    data: { 'id' : $id },
                    dataType: 'html',
                    method: 'get'
                }).done(function(res) {
                    self.setContent(res);
                }).fail(function() {
                    $jc.close();
                });
            },
            onContentReady: function() {
                $('#reason').focus();
            },
            buttons: {
                CANCEL: {
                    btnClass:'btn btn-default',
                    text: '<small>[ESC]</small> CLOSE',
                    keys: ['esc']
                },
                POST: {
                    btnClass:'btn btn-danger',
                    text: 'CANCEL',
                    action: function() {
                        $.ajax({
                            url: $app_url + '/athena/athena-loans/cancel',
                            data: { 
                                'id' : $id,
                                'reason' : $('#reason').val() 
                            },
                            method: 'post',
                            success: function(res) {
                                $jc.close();
                                $dt.draw();
                            },  
                            error: function(res) {
                                $.each(res.responseJSON, function(field, message) {
                                    $('#'+field).closest('.form-group').addClass('has-error').prop('title', message);
                                });
                            }
                        });

                        return false;
                    }
                }
            }
        });
    })
    .on('click', '.loan-edit', function(){
        $id = $(this).data('id');

        $jc = $.confirm({
            title: false,
            draggable: true,
            columnClass: 'medium',
            content: function() {
                var self = this;

                return $.ajax({
                    url: $app_url + '/athena/athena-loans/edit',
                    data: { 'id' : $id },
                    dataType: 'html',
                    method: 'get'
                }).done(function(res) {
                    self.setContent(res);
                }).fail(function() {
                    $jc.close();
                });
            },
            onContentReady: function() {
                $amt_net = $('#amt-net').data('amt');

                $('#terms').focus();

                $('#terms').keyup(function() {
                    $terms = $(this).val();
                    $amortization = $amt_net / $terms;
                    $('#amortization').val(numeral($amortization).format('0,0.00'));
                }); 
            },
            buttons: {
                CANCEL: {
                    btnClass:'btn btn-default',
                    text: '<small>[ESC]</small> CLOSE',
                    keys: ['esc']
                },
                POST: {
                    btnClass:'btn btn-success',
                    text: 'UPDATE BILL PROMISSORY',
                    action: function() {
                        $.ajax({
                            url: $app_url + '/athena/athena-loans/edit',
                            data: { 
                                'id' : $id,
                                'terms' : $('#terms').val() 
                            },
                            method: 'post',
                            success: function(res) {
                                $jc.close();
                                $dt.draw();
                            },
                            error: function(res) {
                                $.each(res.responseJSON, function(field, message) {
                                    $('#'+field).closest('.form-group').addClass('has-error').prop('title', message);
                                });
                            }
                        });

                        return false;
                    }
                }
            }
        });
    })
    .on('click', '.loan-amort-sched', function() {
        $id = $(this).data('id');
        $appl_id = $(this).data('appl-id');

        $.confirm({
            title: '',
            draggable: true,
            columnClass: 'x-large',
            content: function() {
                var self = this;

                return $.ajax({
                    url: $app_url + '/athena/athena-loans/amort-sched',
                    data: { 
                        'id': $id,
                        'appl_id': $appl_id 
                    },
                    dataType: 'html',
                    method: 'get'
                }).done(function(res) {
                    self.setContent(res);
                }).fail(function() {
                    self.setContent('Something went wrong. Please try again or refresh the page.');
                });
            },
            buttons: {
                CLOSE: {
                    btnClass: 'btn btn-default',
                    text: '<small>[ESC]</small> CLOSE',
                    keys: ['esc']
                },
                PRINT: {
                    btnClass: 'btn btn-primary',
                    text: '<i class="fa fa-print"></i> PRINT',
                    action: function() {
                        $('#amort-printable').printThis({
                            importCSS: true
                        });
                    }
                }
            }
        });
    })
    .on('click', '.loan-view-ledger', function(){
        $id = $(this).data('id');
        $appl_id = $(this).data('appl-id');

        $.confirm({
            title: '',
            draggable: true,
            columnClass: 'x-large',
            content: function() {
                var self = this;

                return $.ajax({
                    url: $app_url + '/athena/athena-loans/view-ledger',
                    data: { 
                        'id': $id,
                        'appl_id': $appl_id 
                    },
                    dataType: 'html',
                    method: 'get'
                }).done(function(res) {
                    self.setContent(res);
                }).fail(function() {
                    self.setContent('Something went wrong. Please try again or refresh the page.');
                });
            },
            buttons: {
                CLOSE: {
                    btnClass: 'btn btn-default',
                    text: '<small>[ESC]</small> CLOSE',
                    keys: ['esc']
                },
                PRINT: {
                    btnClass: 'btn btn-primary',
                    text: '<i class="fa fa-print"></i> PRINT',
                    action: function() {
                        $('#ledger-printable').printThis({
                            importCSS: true
                        });
                    }
                }
            }
        });
    });
</script>
@endsection