@extends('layouts.master')
@section('title')
    {{translate('loan')}}
@endsection
@section('content')
    <div class="panel panel-white">
        <div class="panel-heading">
            <h6 class="panel-title">

                @if(isset($_REQUEST['status']))
                    @if($_REQUEST['status']=='pending')
                        {{translate('loan pending approval')}}
                    @endif
                    @if($_REQUEST['status']=='approved')
                        {{translate('loan awaiting disbursement')}}
                    @endif
                    @if($_REQUEST['status']=='disbursed')
                        {{translate('loan disbursed')}}
                    @endif
                    @if($_REQUEST['status']=='declined')
                        {{translate('loan declined')}}
                    @endif
                    @if($_REQUEST['status']=='withdrawn')
                        {{translate('loan withdrawn')}}
                    @endif
                    @if($_REQUEST['status']=='written_off')
                        {{translate('loan written_off')}}
                    @endif
                    @if($_REQUEST['status']=='closed')
                        {{translate('loan closed')}}
                    @endif
                    @if($_REQUEST['status']=='pending_reschedule')
                        {{translate('loan pending reschedule')}}
                    @endif
                @else
                    {{translate('all loan')}}
                @endif
            </h6>

            <div class="heading-elements">
                @if(Sentinel::hasAccess('loans.create'))
                    <a href="{{ url('loan/create') }}"
                       class="btn btn-info btn-sm">{{translate('add loan')}}</a>
                @endif
            </div>
        </div>
        <div class="panel-body table-responsive">
            <table id="data-table" class="table table-bordered table-striped table-condensed table-hover">
                <thead>
                <tr style="background-color: #D1F9FF">
                    <th>{{translate('borrower')}}</th>
                    <th>#</th>
                    <th>{{translate('principal')}}</th>
                    <th>{{translate('released')}}</th>
                    <th>{{translate('interest')}}%</th>
                    <th>{{translate('due')}}</th>
                    <th>{{translate('paid')}}</th>
                    <th>{{translate('balance')}}</th>
                    <th>{{translate('status')}}</th>
                    <th>{{ translate('action') }}</th>
                </tr>
                </thead>
                <tbody>
                @foreach($data as $key)
                    <tr>
                        <td>
                            @if(!empty($key->borrower))
                                <a href="{{url('borrower/'.$key->borrower_id.'/show')}}">{{$key->borrower->first_name}} {{$key->borrower->last_name}}</a>
                            @else
                                <span class="label label-danger">{{translate('broken')}} <i
                                        class="fa fa-exclamation-triangle"></i> </span>
                            @endif
                            {{ $key->name }}
                        </td>
                        <td>{{$key->id}}</td>
                        <td>

                            {{currency_converter($key->principal)}}

                        </td>
                        <td>{{$key->release_date}}</td>
                        <td>
                            {{currency_converter($key->interest_rate)}}%/{{$key->interest_period}}
                        </td>
                        <td>
                            @if($key->override==1)
                                <s>{{currency_converter(\App\Helpers\GeneralHelper::loan_total_due_amount($key->id))}}</s>
                                <br>
                                {{currency_converter($key->balance)}}
                            @else
                                {{currency_converter(\App\Helpers\GeneralHelper::loan_total_due_amount($key->id))}}
                            @endif

                        </td>
                        <td>{{currency_converter(\App\Helpers\GeneralHelper::loan_total_paid($key->id))}}</td>
                        <td>
                            {{currency_converter(\App\Helpers\GeneralHelper::loan_total_balance($key->id))}}
                        </td>
                        <td>
                            @if($key->maturity_date<date("Y-m-d") && \App\Helpers\GeneralHelper::loan_total_balance($key->id)>0)
                                <span class="label label-danger">{{translate('past_maturity')}}</span>
                            @else
                                @if($key->status=='pending')
                                    <span
                                        class="label label-warning">{{translate('pending approval')}}</span>
                                @endif
                                @if($key->status=='approved')
                                    <span
                                        class="label label-info">{{translate('awaiting disbursement')}}</span>
                                @endif
                                @if($key->status=='disbursed')
                                    <span class="label label-info">{{translate('active')}}</span>
                                @endif
                                @if($key->status=='declined')
                                    <span class="label label-danger">{{translate('declined')}}</span>
                                @endif
                                @if($key->status=='withdrawn')
                                    <span class="label label-danger">{{translate('withdrawn')}}</span>
                                @endif
                                @if($key->status=='written_off')
                                    <span class="label label-danger">{{translate('written_off')}}</span>
                                @endif
                                @if($key->status=='closed')
                                    <span class="label label-success">{{translate('closed')}}</span>
                                @endif
                                @if($key->status=='pending_reschedule')
                                    <span
                                        class="label label-warning">{{translate('pending reschedule')}}</span>
                                @endif
                                @if($key->status=='rescheduled')
                                    <span class="label label-info">{{translate('rescheduled')}}</span>
                                @endif
                            @endif
                        </td>
                        <td>
                            <div class="btn-group">
                                <button type="button" class="btn btn-info btn-xs dropdown-toggle"
                                        data-toggle="dropdown" aria-expanded="false">
                                    {{ translate('choose') }} <span class="caret"></span>
                                    <span class="sr-only">Toggle Dropdown</span>
                                </button>
                                <ul class="dropdown-menu dropdown-menu-right" role="menu">
                                    @if(Sentinel::hasAccess('loans.view'))
                                        <li><a href="{{ url('loan/'.$key->id.'/show') }}"><i
                                                    class="fa fa-search"></i> {{ translate('detail') }}
                                            </a>
                                        </li>
                                    @endif
                                    @if(Sentinel::hasAccess('loans.create'))
                                        <li><a href="{{ url('loan/'.$key->id.'/edit') }}"><i
                                                    class="fa fa-edit"></i> {{ translate('edit') }} </a></li>
                                    @endif
                                    @if(Sentinel::hasAccess('loans.delete'))
                                        <li><a href="{{ url('loan/'.$key->id.'/delete') }}"
                                               class="delete"><i
                                                    class="fa fa-trash"></i> {{ translate('delete') }} </a></li>
                                    @endif
                                </ul>
                            </div>
                        </td>
                    </tr>
                @endforeach
                </tbody>
            </table>
        </div>
        <!-- /.panel-body -->
    </div>
    <!-- /.box -->
@endsection
@section('footer-scripts')
    <script src="{{ asset('assets/plugins/datatable/media/js/jquery.dataTables.js')}}"></script>
    <script src="{{ asset('assets/plugins/datatable/media/js/dataTables.bootstrap.js')}}"></script>
    <script src="{{ asset('assets/plugins/datatable/extensions/Buttons/js/dataTables.buttons.min.js')}}"></script>
    <script src="{{ asset('assets/plugins/datatable/extensions/Buttons/js/buttons.html5.min.js')}}"></script>
    <script src="{{ asset('assets/plugins/datatable/extensions/Buttons/js/buttons.print.min.js')}}"></script>
    <script src="{{ asset('assets/plugins/datatable/extensions/Responsive/js/dataTables.responsive.min.js')}}"></script>
    <script src="{{ asset('assets/plugins/datatable/extensions/Buttons/js/buttons.colVis.min.js')}}"></script>
    <script>
        $('#data-table').DataTable({
            dom: 'Bfrtip',
            buttons: [
                {extend: 'copy', 'text': '{{ translate('copy') }}'},
                {extend: 'excel', 'text': '{{ translate('excel') }}'},
                {extend: 'pdf', 'text': '{{ translate('pdf') }}'},
                {extend: 'print', 'text': '{{ translate('print') }}'},
                {extend: 'csv', 'text': '{{ translate('csv') }}'},
                {extend: 'colvis', 'text': '{{ translate('colvis') }}'}
            ],
            "paging": true,
            "lengthChange": true,
            "displayLength": 25,
            "searching": true,
            "ordering": true,
            "info": true,
            "autoWidth": true,
            "order": [[3, "desc"]],
            "columnDefs": [
                {"orderable": false, "targets": [9]}
            ],
            "language": {
                "lengthMenu": "{{ translate('lengthMenu') }}",
                "zeroRecords": "{{ translate('zeroRecords') }}",
                "info": "{{ translate('info') }}",
                "infoEmpty": "{{ translate('infoEmpty') }}",
                "search": "{{ translate('search') }}",
                "infoFiltered": "{{ translate('infoFiltered') }}",
                "paginate": {
                    "first": "{{ translate('first') }}",
                    "last": "{{ translate('last') }}",
                    "next": "{{ translate('next') }}",
                    "previous": "{{ translate('previous') }}"
                }
            },
            responsive: false
        });
    </script>
@endsection