@extends('admin.layout')

@section('content')
    <link rel="stylesheet" href="https://cdn.datatables.net/1.13.4/css/jquery.dataTables.min.css">

    <div class="row mb-3">
        <div class="row d-flex justify-content-between">
            <h4 class="page-top-heading">Retail History</h4>
        </div>

        <div class="container my-4">
            <!-- Filter Section -->
            {{-- <div class="d-flex justify-content-between align-items-center mb-3">
                <div class="d-flex gap-2">
                    <input type="date" class="form-control" placeholder="From Date">
                    <input type="date" class="form-control" placeholder="To Date">
                    <input type="text" class="form-control" placeholder="User ID">
                </div>
                <div class="d-flex gap-2">
                    <button class="btn btn-primary">Search</button>
                    <button class="btn btn-secondary">Reset</button>
                </div>
            </div> --}}

            <!-- Table Card -->
            <div class="card p-3">
                <div class="table-responsive">
                    <table id="retailHistoryTable" class="table table-hover table-borderless">
                        <thead>
                            <tr>
                                <th>S/N</th>
                                <th>Date</th>
                                <th>User&nbspID</th>
                                <th>Name</th>
                                <th>Package&nbspID</th>
                                <th>Package&nbspTitle</th>
                                <th>Image&nbsppreview</th>
                                <th>Description</th>
                                <th>Mrp</th>
                                <th>Discount&nbspPrice</th>
                                <th>PV</th>
                            </tr>
                        </thead>
                        @php
                            $sn = 1;
                        @endphp
                        <tbody>
                            @foreach ($datatables as $data)
                                @php
                                    $packagedetails = DB::table('packages')
                                        ->where('package_id', $data->package_id)
                                        ->first();

                                    $userdetails = DB::table('users')
                                        ->where('user_id', $data->user_id)
                                        ->first();
                                @endphp
                                <tr>
                                    <td>{{ $loop->iteration }}</td>
                                    <td>{{ \Carbon\Carbon::parse($data->created_at)->format('d-m-Y') }}</td>
                                    <td>{{ $data->user_id }}</td>
                                    <td>{{ $userdetails->name }}</td>
                                    <td>{{ $data->package_id }}</td>
                                    <td>{{ $data->title }}</td>
                                    <td>
                                        <a href="#" data-bs-toggle="modal" data-bs-target="#imageModal"
                                            onclick="showImage('{{ asset($data->package_image) }}')">
                                            View Image
                                        </a>
                                    </td>
                                    <td>{{ $data->description }}</td>
                                    <td>{{ $data->mrp }}</td>
                                    <td>{{ $data->discount_price }}</td>
                                    <td>{{ $data->pv }}</td>

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


    <!-- Modal -->
    <div class="modal fade" id="imageModal" tabindex="-1" aria-labelledby="imageModalLabel" aria-hidden="true">
        <div class="modal-dialog modal-dialog-centered">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="imageModalLabel">Package Image</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body text-center">
                    <img id="modalImage" src="" alt="Package Image" class="img-fluid">
                </div>
            </div>
        </div>
    </div>


    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.4/js/jquery.dataTables.min.js"></script>

    <script>
        $(document).ready(function() {
            $('#retailHistoryTable').DataTable();
        });
    </script>

    <script>
        function showImage(imageUrl) {
            document.getElementById('modalImage').src = imageUrl;
        }
    </script>
@endsection