@extends('layouts.admin')
@section('content')

<div class="row">
    <div class="col-12">
        <div class="page-title-box d-sm-flex align-items-center justify-content-between bg-galaxy-transparent">
            <h4 class="mb-sm-0">Due Diligence Requests</h4>
            <ol class="breadcrumb m-0">
                <li class="breadcrumb-item"><a href="{{ route('admin.dashboard') }}">Home</a></li>
                <li class="breadcrumb-item active">DD Requests</li>
            </ol>
        </div>
    </div>
</div>

<div class="card">
    <div class="card-header border-0">
        <h5 class="card-title mb-0">DD Requests Table</h5>
    </div>
    <div class="card-body">
        <div class="table-responsive">
            <table id="DDTable" class="table table-bordered nowrap align-middle" style="width:100%;">
                <thead class="text-uppercase">
                    <tr>
                        <th>ID</th>
                        <th>Listing</th>
                        <th>Total Price</th>
                        <th>Status</th>
                        <th>Services</th>
                        <th>Actions</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($requests as $dd)
                    <tr>
                        <td>{{ $dd->id }}</td>
                        <td>{{ $dd->listing->title ?? '-' }}</td>
                        <td><img src="{{ config('global.default_currency_code') }}" alt="Currency" width="16" style="vertical-align: middle;">{{ number_format($dd->price,2) }}</td>
                        <td>
                            <select style="width: 160px !important" class="form-select dd-status" data-id="{{ $dd->id }}">
                                <!-- <option value="Pending" {{ $dd->status=='Pending'?'selected':'' }}>Pending</option> -->
                                 <option value="DD_Requested" {{ $dd->status=='DD_Requested'?'selected':'' }}>DD Requested</option>
                                <!-- <option value="Commissioned" {{ $dd->status=='Commissioned'?'selected':'' }}>Commissioned</option> -->
                                <option value="Completed" {{ $dd->status=='Completed'?'selected':'' }}>Completed</option>
                            </select>
                        </td>
                        <td>
                            @php
                                // Normalize services JSON
                                $jsonServices = $dd->services;
                                if (is_string($jsonServices)) {
                                    $jsonServices = json_decode($jsonServices, true);
                                }
                                $jsonServices = is_array($jsonServices) ? $jsonServices : [];

                                // Convert DB-based services to array for comparison
                                $dbServices = $dd->serviceReports->pluck('service.name')->filter()->toArray();
                            @endphp

                            <ul class="list-unstyled">
                                {{-- Show all DB services --}}
                                @foreach($dd->serviceReports as $srv)
                                    <li class="mb-2">
                                        <strong>{{ $srv->service->name ?? '' }}:</strong>
                                        @if($srv->report_file)
                                            <a href="{{ $srv->report_file_url }}" target="_blank">View PDF</a>
                                        @else
                                            <form class="upload-service-form mt-2" enctype="multipart/form-data">
                                                <input type="hidden" name="service_id" value="{{ $srv->id }}">
                                                <input type="hidden" name="dd_request_id" value="{{ $dd->id }}">
                                                <input type="hidden" name="service_name" value="{{ $srv->service->name ?? '' }}">
                                                <input type="file" name="report_file" accept="application/pdf" class="form-control mb-2" required>
                                                <button type="submit" class="btn btn-sm btn-success">Upload</button>
                                            </form>
                                        @endif
                                    </li>
                                @endforeach

                                {{-- Show remaining JSON services that aren't in DB --}}
                                @foreach($jsonServices as $srv)
                                    @if(!in_array($srv, $dbServices))
                                        <li class="mb-2">
                                            <strong>{{ $srv }}</strong> — <em>No report uploaded</em>
                                            <form class="upload-service-form mt-2" enctype="multipart/form-data">
                                                <input type="hidden" name="dd_request_id" value="{{ $dd->id }}">
                                                <input type="hidden" name="service_name" value="{{ $srv }}">
                                                <input type="file" name="report_file" accept="application/pdf" class="form-control mb-2" required>
                                                <button type="submit" class="btn btn-sm btn-success">Upload</button>
                                            </form>
                                        </li>
                                    @endif
                                @endforeach
                            </ul>

                            @if($dd->serviceReports->isEmpty() && empty($jsonServices))
                                <span class="text-muted">No services found</span>
                            @endif
                        </td>

                        <td class="text-center">
                            <a href="{{ route('admin.ddrequests.view', $dd->id) }}" class="btn btn-sm btn-primary">View</a>
                            <button class="btn btn-sm btn-danger delete-btn" data-url="{{ route('admin.ddrequests.destroy', $dd->id) }}">Delete</button>
                        </td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>
</div>

@endsection

@section('script')
<script>
$(function(){
   // $('#DDTable').DataTable({ responsive:true });
    $('#DDTable').DataTable({
        responsive: true,
        order: [[0, 'desc']] // 0 = first column, sort descending
    });

    // ✅ Change Status
    $("body").on("change", ".dd-status", function(){
        let id = $(this).data('id');
        let status = $(this).val();
        fetch("{{ route('admin.ddrequests.status') }}", {
            method: 'POST',
            headers: {
                "Content-Type": "application/json",
                "X-CSRF-TOKEN": document.querySelector('meta[name="csrf-token"]').content
            },
            body: JSON.stringify({ id, status })
        }).then(r => r.json()).then(response => {
            Swal.fire({
                iconHtml: `<img src="{{ asset('assets/images/success-circle.svg') }}" class="img-fluid">`,
                text: response.message,
                confirmButtonText: "OK",
                customClass: { confirmButton: 'custom-ok-button-class w-sm' }
            }).then(() => location.reload());
        });
    });

    // ✅ Upload Service PDF (existing or JSON-based)
    $("body").on("submit", ".upload-service-form", function(e){
        e.preventDefault();
        let formData = new FormData(this);
        fetch("{{ route('admin.ddrequests.upload.service') }}", {
            method: 'POST',
            headers: { 'X-CSRF-TOKEN': document.querySelector('meta[name="csrf-token"]').content },
            body: formData
        }).then(r => r.json()).then(response => {
            Swal.fire({
                iconHtml: `<img src="{{ asset('assets/images/success-circle.svg') }}" class="img-fluid">`,
                text: response.message,
                confirmButtonText: "OK",
                customClass: { confirmButton: 'custom-ok-button-class w-sm' }
            }).then(() => location.reload());
        });
    });

    // ✅ Delete DD Request
    $("body").on("click", ".delete-btn", function(){
        let url = $(this).data('url');
        if(confirm("Delete this DD request?")){
            fetch(url, {
                method: 'DELETE',
                headers: { 'X-CSRF-TOKEN': document.querySelector('meta[name="csrf-token"]').content }
            }).then(r => r.json()).then(response => {
                Swal.fire({
                    iconHtml: `<img src="{{ asset('assets/images/success-circle.svg') }}" class="img-fluid">`,
                    text: response.message,
                    confirmButtonText: "OK",
                    customClass: { confirmButton: 'custom-ok-button-class w-sm' }
                }).then(() => location.reload());
            });
        }
    });
});
</script>
@endsection