@extends('admin.layout.master')
@section('home')

    <style>
        table th, td{
            text-align: center;
        }
    </style>
    <div class="row">
        <div class="col-lg-12">
            <h4 class="page-title text-center">Loan Summary</h4>
            <div class="card-box">
                <div class="card-block">
                    <form action="{{route('search-loan_summary')}}" method="post">
                        @csrf
                        <div class="row">
                            <div class='col-md-3'>
                                <div class="form-group">
                                    <label>Emp Code</label>
                                    <input type="text" class="form-control input-sm" name="emp_code" id="emp_code">
                                </div>
                            </div>
                            <div class='col-md-3'>
                                <div class="form-group">
                                    <label>Department</label>
                                    <select name="emp_department" id="emp_department" class="form-control input-sm">
                                        <option value="0">--Select--</option>
                                        @if(!empty($department_lists))
                                            @foreach($department_lists as $depart_val)
                                                <option value="{{$depart_val->id}}">{{$depart_val->name}}</option>
                                            @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                            <div class='col-md-2'>
                                <div class="form-group">
                                    <label>Installment Date From</label>
                                    <input type="text" class="bootstrap_datepicker form-control input-sm"
                                           name="date_from" id="date_from"
                                           value="@if(!empty($date_from)){{$date_from}}@endif">
                                </div>
                            </div>
                            <div class='col-md-2'>
                                <div class="form-group">
                                    <label>Installment Date To</label>
                                    <input type="text" class="bootstrap_datepicker form-control input-sm"
                                           name="date_to" id="date_to" value="@if(!empty($date_to)){{$date_to}}@endif">
                                </div>
                            </div>
                            <div class="col-md-2">
                                <div class="row mt-4">
                                    <button class='btn btn-primary btn-sm'>Submit</button>
                                </div>
                            </div>
                        </div>
                    </form>
                    <!-- Button trigger modal -->

                    <div class="mt-4">
                        <table class="display datatable table table-stripped ">
                            <thead>
                            <tr>
                                <th>Emp Code</th>
                                <th>Emp Name</th>
                                <th>Designation</th>
                                <th>Total Loan Amount</th>
                                <th>Total Loan Installment</th>
                                <th>Loan Start Date</th>
                                <th>Installment Date</th>
                                <th>Adjust Amount</th>
                                <th>Adjust Installment</th>
                                <th>Adjust From</th>
                                <th>Adjusted Month Of Salary</th>
                            </tr>
                            </thead>
                            <tbody>
                            @if(!empty($loan_info))
                                @foreach($loan_info as $loan_val)
                                    <tr>
                                        <td>{{$loan_val->empBasicInfo->emp_code}}</td>
                                        <td>{{$loan_val->empBasicInfo->emp_name}}</td>
                                        <td>{{$loan_val->empBasicInfo->fetch_designation->name}}</td>
                                        <td>{{$loan_val->loanInfo->amount}}</td>
                                        <td>{{$loan_val->loanInfo->installment_no}}</td>
                                        <td>{{$loan_val->loanInfo->disburse_date}}</td>
                                        <td>{{$loan_val->installment_date}}</td>
                                        <td>{{$loan_val->total_adjusted_amount}}</td>
                                        <td>{{$loan_val->total_adjusted_installment_no}}</td>
                                        <td>{{$loan_val->adjusted_remarks}}</td>
                                        <td>@if(!empty($loan_val->installment_month)){{date('d-m-Y',strtotime('01-'.$loan_val->installment_month))}}@endif</td>

                                    </tr>
                                @endforeach
                            @endif
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

@endsection