@extends('app-new')

@push('head-script')
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/vendors.min.css">
@endpush

@push('content-header')
    <div class="row breadcrumbs-top">
        <div class="col-12">
            <h2 class="content-header-title float-start mb-0">Cooperative Loan - Import Historical Data</h2>
            <div class="breadcrumb-wrapper">
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="{{ url($alias.'/cooperative-loans') }}">Cooperative Loan</a></li>
                    <li class="breadcrumb-item active">Import</li>
                </ol>
            </div>
        </div>
    </div>
@endpush

@push('prev-next-head')
    <div class="content-header-right text-end col-md-3 col-12">
        <div class="form-group breadcrumb-right">
            <a href="{{ url($alias.'/cooperative-loans') }}" class="btn btn-secondary btn-sm"><i data-feather="arrow-left-circle"></i> Back</a>
        </div>
    </div>
@endpush

@section('content')
<section id="basic-form-layouts">
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h4 class="card-title">Import Already-Calculated Loan + Ledger Data</h4>
                </div>
                <div class="card-body">
                    <p class="text-muted">
                        Upload a CSV/Excel file with one row per employee per month. Values are imported exactly as
                        given — no interest or balance calculation is performed. Required columns:
                    </p>
                    <p class="text-muted">
                        <code>employee_code, requested_amount, requested_date, principal_amount, emi_amount,
                        disbursed_amount, disbursed_date, required_shares, shortfall_shares, shortfall_amount,
                        month, year, amount, interest_amount, status, balance_after, remarks, transaction_date</code>
                    </p>
                    <p class="text-muted">
                        Rows must be sorted oldest-to-newest per employee. The <code>requested_amount</code> /
                        <code>requested_date</code> / <code>principal_amount</code> / <code>emi_amount</code> /
                        <code>disbursed_amount</code> / <code>disbursed_date</code> / <code>required_shares</code> /
                        <code>shortfall_shares</code> / <code>shortfall_amount</code> columns are only read from an
                        employee's <strong>earliest</strong> row — an employee with no existing active loan will have
                        one auto-created from those. The loan's outstanding balance is set from the
                        <strong>last</strong> row's <code>balance_after</code>; if that is 0, the loan is closed
                        automatically.
                    </p>

                    <a href="{{ url($alias.'/cooperative-loans/import/sample') }}" class="btn btn-outline-secondary btn-sm mb-2">
                        <i data-feather="download"></i> Download Sample File
                    </a>

                    <form id="cooperative-loan-import-form" enctype="multipart/form-data">
                        {{ csrf_field() }}
                        <div class="row">
                            <div class="col-md-6 mb-1">
                                <label class="form-label" for="file">File (CSV / XLSX) <span class="text-danger">*</span></label>
                                <input type="file" class="form-control" id="file" name="file" accept=".csv,.txt,.xlsx,.xls">
                                <span class="text-danger" id="err-file"></span>
                            </div>
                        </div>

                        <div class="form-actions mt-2">
                            <button type="button" id="submit-cooperative-loan-import" class="btn btn-primary">Import</button>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
</section>
@endsection

@push('footer-script')
<script>
var importUrl = "{!! route('cooperativeloan.import.store', ['alias' => $alias]) !!}";

$(function () {
    $('#submit-cooperative-loan-import').on('click', function () {
        $('.text-danger').text('');

        var fileInput = $('#file')[0];
        if (!fileInput.files.length) {
            $('#err-file').text('Please choose a file to import.');
            return;
        }

        var formData = new FormData();
        formData.append('_token', "{{ csrf_token() }}");
        formData.append('file', fileInput.files[0]);

        $.ajax({
            url: importUrl,
            type: 'POST',
            data: formData,
            contentType: false,
            processData: false,
            success: function (res) {
                if (res.status === 'fail') {
                    Swal.fire({ title: 'Error', text: res.message || 'Unable to import Cooperative Loan data', icon: 'error', confirmButtonColor: '#DD6B55' });
                    return;
                }

                Swal.fire({ title: 'Success', text: res.message || 'Import completed successfully', icon: 'success', confirmButtonColor: '#00c292' }).then(function () {
                    window.location.href = "{{ url($alias.'/cooperative-loans') }}";
                });
            },
            error: function (xhr) {
                if (xhr.status === 422 && xhr.responseJSON && xhr.responseJSON.errors) {
                    $.each(xhr.responseJSON.errors, function (field, messages) {
                        $('#err-' + field).text(messages[0]);
                    });
                } else {
                    Swal.fire({ title: 'Error', text: (xhr.responseJSON && xhr.responseJSON.message) ? xhr.responseJSON.message : 'Unable to import Cooperative Loan data', icon: 'error', confirmButtonColor: '#DD6B55' });
                }
            }
        });
    });
});
</script>
@endpush