@extends('member-new')
@push('head-script')
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/tables/datatable/dataTables.bootstrap5.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/tables/datatable/responsive.bootstrap5.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/css/components.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/vendors.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/extensions/toastr.min.css">
    <link rel="stylesheet" href="/assets/plugins/bower_components/bootstrap-datepicker/bootstrap-datepicker.min.css">
    <link rel="stylesheet" href="/assets/css/daterangepicker.css">
    <!-- BEGIN: Page CSS-->
    <link rel="stylesheet" type="text/css" href="/app-assets/css/core/menu/menu-types/vertical-menu.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/css/plugins/forms/pickers/form-flat-pickr.css">
    <!-- END: Page CSS-->
    
@endpush 

@push('content-header')
    <div class="row breadcrumbs-top">
       
        <div class="col-12">
            <h2 class="content-header-title float-start mb-0">Loans</h2>
            <div class="breadcrumb-wrapper">
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="/">Home</a>
                    </li>
                    <li class="breadcrumb-item active">Loans
                    </li>
                </ol>
            </div>
        </div>
    </div>
@endpush
@section('content')
    <!-- Column Search -->
    <section id="column-search-datatable">
        <!-- Filters -->
   {{--    
    <div class="content-header row">
        <div class="content-header-left col-md-12 col-12 mb-2">
            <div class="row breadcrumbs-top">
                <div class="col-12">
                    <h2 class="content-header-title float-start mb-0"></h2>
                    
                </div>
            </div>
        </div>
        <div class="content-header-right text-md-end col-md-3 col-12 d-md-block d-none">
            <div class="mb-1 breadcrumb-right">
                <div class="dropdown">
                    <button class="btn-icon btn btn-primary btn-round btn-sm dropdown-toggle" type="button"
                        data-bs-toggle="offcanvas" data-bs-target="#offcanvasEnd" aria-controls="offcanvasEnd"
                        type="button"><i data-feather='filter'></i></button>
                </div>
            </div>
        </div>
    </div>
    <div class="offcanvas-end-example">
        <div class="offcanvas offcanvas-end" tabindex="-1" id="offcanvasEnd" aria-labelledby="offcanvasEndLabel">
            <div class="offcanvas-header">
                <h5 id="offcanvasEndLabel" class="offcanvas-title">Filter</h5>
                <button type="button" class="btn-close text-reset" data-bs-dismiss="offcanvas"
                    aria-label="Close"></button>
            </div>
            <div class="offcanvas-body my-auto mx-0 flex-grow-0">
                <div class="row">
                    <div class="col-sm-12">
                        <div class="form-label-group">
                            <label class="form-label" for="date_range">Date range</label>
                            <input type="text" id="date_range" name="date_range" class="form-control daterangebg"> {!! $errors->first('date_range', '<label class="control-label error" for="date_range">:message</label>')!!}
                        </div>
                    </div>

                    <div class="col-sm-12 mt-1">
                        <div class="form-label-group">
                            <label class="form-label">Leave Status</label>
                            <select class="form-control select2" id="leave_status" name="leave_status" class="form-control">
								<option value="">ALL</option>
                                <option value="pending">Pending</option>
                                <option value="approved">Approved</option>
                                <option value="rejected">Rejected</option>
                                <option value="revoked">Revoked</option>
							</select>
                        </div>
                    </div>

                    <div class="col-sm-12 mt-1">
                        <div class="form-label-group">
                            <label class="form-label">Department</label>
                            <select class="form-control select2" id="department_id" class="form-control">
                                <option value="">Select Department</option>
                                @foreach($departments as $department)
                                    <option value="{{$department->id}}">
                                        {{$department->name}}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                    <div class="col-sm-12 mt-1">
                        <div class="form-label-group">
                            <label class="form-label">Designation</label>
                            <select class="form-control select2" id="designation_id" class="form-control">
                                <option value="">Select Designation</option>
                                @foreach($designations as $designation)
                                    <option value="{{$designation->id}}">
                                        {{$designation->name}}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                    <div class="col-sm-12 mt-1">
                        <div class="form-label-group">
                            <label class="form-label">Manager</label>
                            <select class="form-control select2" id="manager_id" class="form-control">
                                <option value="">Select Manager</option>
                                @foreach($managers as $manager)
                                    <option value="{{$manager['id']}}">
                                        {{$manager['name']}}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                    <div class="col-sm-12 mt-1">
                        <div class="form-label-group">
                            <label class="form-label">Location</label>
                            <select class="form-control select2" id="location_id" class="form-control" onchange="getSubLocation(this.value)">
                                <option value="">Select Location</option>
                                @foreach($locations as $location)
                                    <option value="{{$location->id}}">
                                        {{$location->name}}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                    <div class="col-sm-12 mt-1">
                        <div class="form-label-group">
                            <label class="form-label">Sub Location</label>
                            <select class="form-control select2" id="sublocation_id" class="form-control">
                                <option value="">Select Sub Location</option>
                                @foreach($subLocations as $subLocation)
                                    <option value="{{$subLocation->id}}">
                                        {{$subLocation->name}}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                   
                    <div class="col-sm-12 mt-1">
                        <div class="form-label-group">
                            <label class="form-label">Contractor</label>
                            <select class="form-control select2" id="contractor_id" class="form-control">
                                <option value="">Select Contractor</option>
                                @foreach($contractors as $contractor)
                                    <option value="{{$contractor->id}}">
                                        {{$contractor->name}}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                    

                    <div class="col-sm-12 mt-1">
                        <div class="form-label-group">
                            <label class="form-label">Employee Type</label>
                            <select class="form-control select2" id="employee_type" class="form-control" onchange="getEmployeeByType(this.value)">
                                <option value="">Select Type</option>
                                @foreach($employeeTypes as $empType)
                                    <option value="{{$empType}}">
                                        {{$empType}}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                    <div class="col-sm-12 mt-1">
                        <div class="form-label-group">
                            <label class="form-label">Employees</label>
                            <select class="form-control select2" id="employee_id" class="form-control">
                                <option value="">Select Employees</option>
                                @foreach($employees as $employee)
                                    <option value="{{$employee->id}}">
                                        {{$employee->name}}({{$employee->employee_code}})
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                </div>
                
            
                <button type="button" class="btn btn-primary mt-2 mb-1 d-grid w-100 d-flex justify-content-center" onclick="leaveFilter()" data-bs-dismiss="offcanvas" aria-label="Close"><i
                    data-feather='search' class="me-2"></i> Search</button>
        
            </div>
        </div>
    </div>
    --}}
    <!-- // Filters // -->

        <div class="row">

             @if (isset($status))
                <div class="card-header">
                  @foreach ($status['messages'] as $m)
                  <div class="demo-spacing-0">
                   <div class="alert alert-{{$status['code']}}" role="alert">
                    <div class="alert-body"><strong>{{$m}}</strong></div>
                   </div>
                  </div>
                  @endforeach
                 </div> 
                 @endif
                 
            <div class="col-12">
                <div class="card">
                    <!-- <div class="card-header border-bottom">
                        <h4 class="card-title">Employee Listing</h4>
                    </div> -->
                    <div class="card-datatable">
                        <table class="dt-column-search table" id="organization">
                            <thead>
                                <th>ID</th>
                                <th>Employee</th>
                                <th>Loan Type</th>
                                <th>Loan Amount</th>
                                <th>Total EMI</th>
                                <th>Status</th>
                                <th>Apply Date</th>
                                <th>Action</th>
                            </thead>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </section>
    <!--/ Column Search -->
@endsection 
@push('footer-script') 
    <!-- BEGIN: Page Vendor JS-->
    <script src="/app-assets/vendors/js/tables/datatable/jquery.dataTables.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.bootstrap5.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.responsive.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/responsive.bootstrap5.js"></script>
    <script src="/app-assets/vendors/js/pickers/flatpickr/flatpickr.min.js"></script>
    <script src="/app-assets/js/scripts/ui/ui-feather.js"></script>

    <script type="text/javascript" src="https://cdn.jsdelivr.net/momentjs/latest/moment.min.js"></script>
    <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.min.js"></script>
    <link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.css" />

    <script src="/app-assets/vendors/js/tables/datatable/datatables.checkboxes.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/datatables.buttons.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/jszip.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/pdfmake.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/vfs_fonts.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/buttons.html5.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/buttons.print.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.rowGroup.min.js"></script>
    <!-- END: Page Vendor JS-->
    <script src="/app-assets/vendors/js/extensions/toastr.min.js"></script>

    <!-- BEGIN: Page JS-->
    <script src="/app-assets/js/scripts/tables/table-datatables-basic.js"></script>
    <script src="/app-assets/js/scripts/tables/table-datatables-advanced.js"></script>
    <!-- END: Page JS-->
 

<script>
   $(document).ready(function(){
 
            var dt_filter_table = $('.dt-column-search'); 

            if ($('body').attr('data-framework') === 'laravel') {
                assetPath = $('body').attr('data-asset-path');
            }

            if (dt_filter_table.length) {
                
                var dt_filter = dt_filter_table.DataTable({
                ajax: {
                    "url": "{{ route('member.loan.all',['slug'=>$alias]) }}",
                    "dataType": "json",
                    "type": "POST",
                    "data": {
                        _token: "{{csrf_token()}}"
                    }
                },
                "columns": [{
                        "data": "id",
                            render: function(data, type, row, meta) {
                                return ($('#organization').DataTable().page.info().page*$('#organization').DataTable().page.info().length)+(meta.row + 1);
                            }
                    },
                    {
                        "data": "user.name",
                        render: function(data, type,row) 
                        {
                            data =row.user.name;
                            return data;
                         }   
                    },
                     {
                        "data": "loan_type_id",
                        "orderable": true,
                        render: function(data, type,row) {
                            if (type === "display") {
                                if(row.loan_type_id){
                                    data = row.loan_type.name;  
                                }else{
                                    data="";
                                }
                            }
                        return data;
                    }
                    
                },{
                        "data": "loan_amount",
                    },{
                        "data": "no_of_emi",
                    },{
                        "data": "loan_status",
                        render: function(data, type) {
                            if (type === "display") {
                                if (data == "Approved") {
                                    data = '<div class="fw-bold badge rounded-pill badge-light-success">approved</div>';
                                } else if (data == "Rejected") {
                                    data = '<div class="fw-bold badge rounded-pill badge-light-danger">Rejected</div>';
                                }else if (data == "revoked") {
                                    data = '<div class="label label-danger">revoked</div>';
                                }else{
                                    data = '<div class="fw-bold badge rounded-pill badge-light-info">Pending</div>';
                                }
                                return data;
                            }
                            return data;
                        }    
                    }, 
                    {
                        "data": "created_at",
                    },
                    {
                        "data": "loan_status",
                        "orderable": false,
                    }],
                "columnDefs": [{
                    "targets": -1,
                    "data": null,
                    render: function(data, type, row, meta) {
                        var status=row.loan_status;
                        if (type === 'display') {
                            data="";
                            var user_id='