@extends('admin.layout.master')
@section('title', 'Loan Summary')
@section('custom_style')
    <style>

    </style>
    <style>
        {!! $print['style_css'] !!}
    </style>
@endsection
@section('content')
    <div class="card sina-card">
        <div class="card-header card-header-s d-flex flex-wrap align-items-center">
            <h4 class="col-8 pl-0">Loan Summary</h4>
            <div class="col-2 d-flex justify-content-end">
            </div>
            <div class="col-2 d-flex justify-content-end">
                @include('payroll.includes.report_print_excel_button')
            </div>
        </div>
        <div class="card-body pt-2">
            <form action="{{ route('payroll.payroll.manage_loan.loan_summary') }}" method="get">
                <div class='row'>
                    <div class='col-lg-3 col-md-3 col-sm-6 '>
                        <div class="form-group">
                            <label> Name/Code</label>
                            <select class="form-control name_code_live_search" name="employee_id" id="employee_id">
                            </select>
                        </div>
                    </div>

                    <div class='col-lg-2 col-md-2 col-sm-6 '>
                        <div class="form-group">
                            <label>Department</label>
                            <select name="department_id" id="department_id" class="form-control select_2">
                                <option value="">--Select--</option>
                                @if (!empty($departments))
                                    @foreach ($departments as $department)
                                        <option value="{{ $department->id }}"
                                            @if (request()->get('department_id') == $department) {{ 'selected' }} @endif>
                                            {{ $department->name }}</option>
                                    @endforeach
                                @endif
                            </select>
                        </div>
                    </div>

                    {{-- <div class='col-lg-2 col-md-2 col-sm-6 '>
                        <div class="form-group">
                            <label>Type</label>
                            <select name="type" id="type" class="form-control">
                                <option value="2" @if (request()->get('type') == 2) {{'selected'}} @endif>Loan</option>
                                <option value="1" @if (request()->get('type') == 1) {{'selected'}} @endif>Advance</option>
                            </select>
                        </div>
                    </div> --}}

                    <div class='col-lg-2 col-md-2 col-sm-6 '>
                        <div class="form-group">
                            <label>Status</label>
                            <select name="status" id="status" class="form-control select_2">
                                <option value="">Select</option>
                                <option value="1" @if (request()->get('status') == 1) {{ 'selected' }} @endif>Running
                                </option>
                                <option value="2" @if (request()->get('status') == 2) {{ 'selected' }} @endif>Closed
                                </option>
                            </select>
                        </div>
                    </div>

                    <div class='col-lg-2 col-md-2 col-sm-6 '>
                        <div class="form-group">
                            <label>Start Date </label>
                            <input type="text" class="date_picker form-control input-sm" name="start_date"
                                id="start_date"
                                value="{{ request()->get('start_date') ? request()->get('start_date') : date('d-m-Y') }}">
                        </div>
                    </div>

                    <div class='col-lg-2 col-md-2 col-sm-6 '>
                        <div class="form-group">
                            <label>End Date </label>
                            <input type="text" class="date_picker form-control input-sm" name="end_date" id="end_date"
                                value="{{ request()->get('end_date') ? request()->get('end_date') : date('d-m-Y') }}">
                        </div>
                    </div>

                    <div class='col-1 text-center mt-4'>
                        <button type="submit" name="filter" class='btn btn-sm btn-warning' id="">Filter</button>
                    </div>
                </div>
            </form>

            <hr>
            @if (count($loans) > 0)
                <div id="printThis" class="common_excel_export" style="">
                    <style>
                        @media print {
                            .no-print {
                                display: none;
                            }

                            @page {
                                /* size: 8.5in 5.5in; */
                                size: A4 portrait;
                                /* size: legal landscape;   */

                                /* font-size: 10px; */
                                margin: 4mm !important;
                                padding: 0 !important;
                            }

                            body {
                                zoom: 60%;
                                font-family: serif;
                                font-size: 15px;
                                font-weight: bold;
                                /* background-color: #FFFFFF !important; */

                            }
                        }
                    </style>
                    {{-- @foreach ($loans->chunk(30) as $chunkLoan) --}}
                        {{-- {!! $print['head'] !!} --}}
                        @include('payroll.report_header', ['title' => " Loan Sammary Report",'text_align'=>"text-center"])

                        <table class="table table-bordered table-hover text-center" style="width:100%">
                            <thead>
                                <tr>
                                    <th style="width:5%">SL</th>
                                    <th style="width:10%">Code</th>
                                    <th style="width:15%">Name</th>
                                    <th style="width:13%">Designation</th>
                                    <th style="width:12%">Date</th>
                                    <th style="width:10%">Loan Start </th>
                                    <th style="width:10%">Amount</th>
                                    <th style="widtXh:10%">Total Installment</th>
                                    <th style="widtXh:10%">Installment</th>
                                    <th style="widtXh:10%">Paid</th>
                                    <th style="widtXh:10%">Balance</th>
                                    <th style="width:8%">Status</th>
                                    <th style="width:8%" class="no-print">Action</th>
                                </tr>
                            </thead>
                            <tbody>

                                @php
                                    $sl = 1;
                                    $total_balance = 0;
                                    $total_paid = 0;
                                @endphp
                                @foreach ($loans as $loan)
                                    <tr>
                                        <td>{{ $sl++ }}</td>
                                        <td>{{ $loan->empinfo->emp_code }}</td>
                                        <td class="text-left">{{ $loan->empinfo->emp_name }}</td>
                                        <td  class="text-left">{{ $loan->empinfo->fetch_designation->name }}</td>

                                        <td>{{ $loan->application_date }}</td>
                                        <td>{{ date('M-Y', strtotime($loan->disburse_date)) }}</td>
                                        <td>{{ $loan->amount }}</td>
                                        <td>{{ $loan->installment_no }}</td>
                                        <td>{{ $loan->installment_amount}}</td>
                                        <td>{{ $loan->totalPaid > 0 ? $loan->totalPaid : 0}}</td>
                                        <td>
                                            @php
                                                $balance = $loan->amount - $loan->totalPaid;
                                                $total_balance += $balance;
                                                $total_paid += $loan->totalPaid;
                                            @endphp
                                            {{ $loan->amount - $loan->totalPaid}} 
                                        </td>

                                        <td>

                                            @if ($loan->amount <= $loan->totalPaid)
                                                {{ 'Completed' }}
                                            @else
                                                {{ 'Running' }}
                                            @endif

                                        </td>
                                        <td class="no-print py-1">
                                            @if (count($loan->loan_advance_payment_history) > 0)
                                                <a href="{{ route('loan.details', ['loan_id' => $loan->id]) }}"
                                                    class='btn btn-sm btn-info' target="_blank">Details</a>
                                            @endif

                                        </td>
                                    </tr>
                                @endforeach
                                <tr>
                                    <td colspan="6" class="text-right"><b>Total</b></td>
                                    <td ><b>{{number_format($loans->sum('amount'))}}</b></td>
                                    <td ></td>
                                    <td ><b></b></td>
                                    <td ><b>{{number_format($total_paid)}}</b></td>
                                    <td ><b>{{number_format($total_balance)}}</b></td>
                                    <td ></td>
                                    <td class="no-print"></td>
                                </tr>
                            </tbody>
                        </table>
                        {{-- <div style="page-break-after: always"></div> --}}
                    {{-- @endforeach --}}
                </div>

            @endif
        </div>
    </div>
@endsection

@section('script')
    <script src="{{ asset('payroll_assets/payroll_common.js') }}"></script>
    <script src="{{ asset('payroll_assets/print_excel.js') }}"></script>

    <script type="text/javascript">
        $(document).ready(function() {
            $('.select_2').select2();
        });
    </script>
@endsection