@extends('layouts.admin.master')

@section('title')
    My Sponsorship Requests
@endsection

@section('content')
    <div class="container-fluid">
        <div class="row">
            <div class="col">
                <div class="card dashboard-custom-card">
                    <div class="card-body">
                        <div class="custom-card-header d-flex justify-content-between align-items-center">
                            <div>
                                <h4 class="h4 mb-1">My Sponsorship Requests</h4>
                                <p class="text-muted">View and manage your sponsorship requests</p>
                            </div>
                            <div>
                                <a href="{{ route('sponsorship-advertisements.public') }}" class="btn btn-primary">
                                    <i class="fas fa-plus mr-2"></i> New Request
                                </a>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="card dashboard-custom-card card-custom">
                    <div class="card-body">
                        <div class="table-responsive">
                            <table class="table datatable custom-table dt-responsive nowrap">
                                <thead>
                                <tr>
                                    <th class="fs-5">SL#</th>
                                    <th class="fs-5">Package</th>
                                    <th class="fs-5">Quantity</th>
                                    <th class="fs-5">Total Amount</th>
                                    <th class="fs-5">Request Status</th>
                                    {{-- <th class="fs-5">Payment Status</th> --}}
                                    <th class="fs-5">Date</th>
                                    <th class="fs-5">Action</th>
                                </tr>
                                </thead>
                                <tbody>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Loading Overlay -->
    <div id="loading-overlay" style="display: none; position: fixed; top: 0; left: 0; width: 100%; height: 100%; background: rgba(0,0,0,0.5); z-index: 9999; align-items: center; justify-content: center;">
        <div class="spinner-border text-light" role="status" style="width: 3rem; height: 3rem;">
            <span class="sr-only">Loading...</span>
        </div>
    </div>

    <!-- Invoice Modal -->
    <div class="modal fade" id="invoiceModal" tabindex="-1" role="dialog" aria-labelledby="invoiceModalLabel" aria-hidden="true">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="invoiceModalLabel">
                        <i class="fas fa-file-invoice mr-2"></i> Invoice
                    </h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body" id="invoice-content">
                    <div class="invoice-box p-4">
                        <div class="text-center mb-4">
                            <h3 class="font-weight-bold">BAU 2001-2002 Alumni Association</h3>
                            <p class="text-muted">Sponsorship Invoice</p>
                        </div>
                        
                        <div class="row mb-4">
                            <div class="col-md-6">
                                <h6 class="font-weight-bold">Invoice To:</h6>
                                <p class="mb-1" id="invoice-user-name"></p>
                                <p class="mb-1" id="invoice-email"></p>
                                <p class="mb-1" id="invoice-phone"></p>
                            </div>
                            <div class="col-md-6 text-right">
                                <h6 class="font-weight-bold">Invoice Details:</h6>
                                <p class="mb-1"><strong>Invoice No:</strong> <span id="invoice-no"></span></p>
                                <p class="mb-1"><strong>Date:</strong> <span id="invoice-date"></span></p>
                                <p class="mb-1"><strong>Transaction ID:</strong> <span id="invoice-transaction-id"></span></p>
                            </div>
                        </div>

                        <table class="table table-bordered">
                            <thead class="bg-light">
                                <tr>
                                    <th>Package</th>
                                    <th class="text-center">Rate</th>
                                    <th class="text-center">Quantity</th>
                                    <th class="text-right">Amount</th>
                                </tr>
                            </thead>
                            <tbody>
                                <tr>
                                    <td id="invoice-package"></td>
                                    <td class="text-center"><span id="invoice-rate"></span> Tk</td>
                                    <td class="text-center"><span id="invoice-quantity"></span></td>
                                    <td class="text-right"><span id="invoice-subtotal"></span> Tk</td>
                                </tr>
                            </tbody>
                            <tfoot>
                                <tr>
                                    <td colspan="3" class="text-right"><strong>Total Amount:</strong></td>
                                    <td class="text-right"><strong><span id="invoice-total"></span> Tk</strong></td>
                                </tr>
                                <tr class="bg-success text-white">
                                    <td colspan="3" class="text-right"><strong>Payment Status:</strong></td>
                                    <td class="text-right"><strong>PAID</strong></td>
                                </tr>
                            </tfoot>
                        </table>

                        <div class="row mt-4">
                            <div class="col-md-6">
                                <p class="mb-1"><strong>Payment Method:</strong> <span id="invoice-payment-method"></span></p>
                                <p class="mb-1"><strong>Payment Date:</strong> <span id="invoice-payment-date"></span></p>
                            </div>
                        </div>

                        <div class="text-center mt-4 pt-4 border-top">
                            <p class="text-muted small mb-0">Thank you for your sponsorship!</p>
                            <p class="text-muted small">For any queries, please contact us at info@bau2001-2002.com</p>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">
                        <i class="fas fa-times mr-1"></i> Close
                    </button>
                    <a href="#" id="download-invoice-btn" class="btn btn-primary" target="_blank">
                        <i class="fas fa-print mr-1"></i> Print Invoice
                    </a>
                </div>
            </div>
        </div>
    </div>

    <!-- Details Modal -->
    <div class="modal fade" id="detailsModal" tabindex="-1" role="dialog" aria-labelledby="detailsModalLabel" aria-hidden="true">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="detailsModalLabel">
                        <i class="fas fa-info-circle mr-2"></i> Request Details
                    </h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    <div class="row">
                        <div class="col-md-6">
                            <table class="table table-bordered">
                                <tr>
                                    <th width="40%">Request ID</th>
                                    <td>#<span id="detail-id"></span></td>
                                </tr>
                                <tr>
                                    <th>Package</th>
                                    <td id="detail-package"></td>
                                </tr>
                                <tr>
                                    <th>Quantity</th>
                                    <td id="detail-quantity"></td>
                                </tr>
                                <tr>
                                    <th>Total Amount</th>
                                    <td><strong class="text-primary"><span id="detail-amount"></span> Tk</strong></td>
                                </tr>
                            </table>
                        </div>
                        <div class="col-md-6">
                            <table class="table table-bordered">
                                <tr>
                                    <th width="50%">Request Status</th>
                                    <td id="detail-status"></td>
                                </tr>
                                <tr>
                                    <th>Payment Status</th>
                                    <td id="detail-payment-status"></td>
                                </tr>
                                <tr>
                                    <th>Requested On</th>
                                    <td id="detail-created"></td>
                                </tr>
                                <tr>
                                    <th>Reviewed On</th>
                                    <td id="detail-reviewed"></td>
                                </tr>
                            </table>
                        </div>
                    </div>

                    <div class="row mt-3">
                        <div class="col-12">
                            <h6 class="font-weight-bold">Reviewer:</h6>
                            <p id="detail-reviewer" class="text-muted"></p>
                        </div>
                    </div>

                    <div class="row mt-3" id="comments-section">
                        <div class="col-12">
                            <h6 class="font-weight-bold">Your Comments:</h6>
                            <p id="detail-comments" class="mb-0"></p>
                        </div>
                    </div>

                    <div class="row mt-3" id="admin-comments-section">
                        <div class="col-12">
                            <h6 class="font-weight-bold">Admin Response:</h6>
                            <p id="detail-admin-comments" class="mb-0"></p>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">
                        <i class="fas fa-times mr-1"></i> Close
                    </button>
                </div>
            </div>
        </div>
    </div>
@endsection

@push('css')
    <link rel="stylesheet" href="https://cdn.datatables.net/1.13.4/css/dataTables.bootstrap4.min.css">
    <link rel="stylesheet" href="https://cdn.datatables.net/responsive/2.4.1/css/responsive.bootstrap4.min.css">
@endpush

@push('js')
    <script src="https://cdn.datatables.net/1.13.4/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.4/js/dataTables.bootstrap4.min.js"></script>
    <script src="https://cdn.datatables.net/responsive/2.4.1/js/dataTables.responsive.min.js"></script>
    <script src="https://cdn.datatables.net/responsive/2.4.1/js/responsive.bootstrap4.min.js"></script>

    <script>
        $(document).ready(function() {
            // Initialize DataTable
            var dataTable = $('.datatable').DataTable({
                processing: true,
                serverSide: true,
                responsive: true,
                ajax: {
                    url: "{{ route('my-sponsorship-requests.datatable') }}",
                    type: 'GET'
                },
                columns: [
                    { 
                        data: 'DT_RowIndex', 
                        name: 'DT_RowIndex', 
                        orderable: false, 
                        searchable: false,
                        render: function (data, type, row, meta) {
                            return meta.row + meta.settings._iDisplayStart + 1;
                        }
                    },
                    { data: 'package', name: 'package' },
                    { data: 'quantity_info', name: 'quantity_info', orderable: false },
                    { data: 'amount', name: 'amount', orderable: false },
                    { 
                        data: 'status', 
                        name: 'status',
                        render: function(data) {
                            return data;
                        }
                    },
                    // { 
                    //     data: 'payment_status', 
                    //     name: 'payment_status',
                    //     render: function(data) {
                    //         return data;
                    //     }
                    // },
                    { 
                        data: 'created_at', 
                        name: 'created_at',
                        render: function(data) {
                            if (!data) return '';
                            var date = new Date(data);
                            var months = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'];
                            return months[date.getMonth()] + ' ' + 
                                   String(date.getDate()).padStart(2, '0') + ', ' + 
                                   date.getFullYear();
                        }
                    },
                    { 
                        data: 'action', 
                        name: 'action', 
                        orderable: false, 
                        searchable: false,
                        render: function(data) {
                            return data;
                        }
                    }
                ],
                order: [[6, 'desc']],
                language: {
                    processing: '<i class="fa fa-spinner fa-spin fa-3x fa-fw"></i><span class="sr-only">Loading...</span> '
                },
                pageLength: 10,
                lengthMenu: [[10, 25, 50, 100, -1], [10, 25, 50, 100, "All"]]
            });

            // View Details
            $(document).on('click', '.view-details', function() {
                var id = $(this).data('id');
                var package = $(this).data('package');
                var amount = $(this).data('amount');
                var quantity = $(this).data('quantity');
                var status = $(this).data('status');
                var paymentStatus = $(this).data('payment-status');
                var comments = $(this).data('comments');
                var adminComments = $(this).data('admin-comments');
                var created = $(this).data('created');
                var reviewed = $(this).data('reviewed');
                var reviewer = $(this).data('reviewer');

                // Populate modal
                $('#detail-id').text(id);
                $('#detail-package').text(package);
                $('#detail-amount').text(amount);
                $('#detail-quantity').text(quantity);
                $('#detail-created').text(created);
                $('#detail-reviewed').text(reviewed);
                $('#detail-reviewer').text(reviewer);

                // Status badges
                var statusBadges = {
                    'pending': '<span class="badge bg-warning text-dark">Pending</span>',
                    'approved': '<span class="badge bg-success">Approved</span>',
                    'rejected': '<span class="badge bg-danger">Rejected</span>'
                };
                $('#detail-status').html(statusBadges[status] || status);

                var paymentBadges = {
                    'pending': '<span class="badge bg-warning text-dark">Pending</span>',
                    'paid': '<span class="badge bg-success">Paid</span>',
                    'failed': '<span class="badge bg-danger">Failed</span>'
                };
                $('#detail-payment-status').html(paymentBadges[paymentStatus] || paymentStatus);

                // Comments
                if (comments && comments.trim() !== '') {
                    $('#detail-comments').text(comments);
                    // $('#comments-section').show();
                } else {
                    // $('#comments-section').hide();
                }

                if (adminComments && adminComments.trim() !== '') {
                    $('#detail-admin-comments').text(adminComments);
                    // $('#admin-comments-section').show();
                } else {
                    // $('#admin-comments-section').hide();
                }

                $('#detailsModal').modal('show');
            });

            // Handle payment form submission with loading overlay
            $(document).on('submit', 'form[action*="payment"]', function(e) {
                $('#loading-overlay').css('display', 'flex');
            });

            // View Invoice
            $(document).on('click', '.view-invoice', function() {
                var requestId = $(this).data('request-id');
                
                // Show loading
                $('#loading-overlay').css('display', 'flex');
                
                $.ajax({
                    url: "{{ url('admin/my-sponsorship-request') }}/" + requestId + "/invoice",
                    method: 'GET',
                    success: function(response) {
                        if (response.success) {
                            var data = response.data;
                            
                            // Populate invoice modal
                            $('#invoice-user-name').text(data.user_name);
                            $('#invoice-email').text(data.email);
                            $('#invoice-phone').text(data.phone);
                            $('#invoice-no').text(data.invoice_no);
                            $('#invoice-date').text(data.created_at);
                            $('#invoice-transaction-id').text(data.transaction_id);
                            $('#invoice-package').text(data.package_title);
                            $('#invoice-rate').text(parseFloat(data.package_amount).toLocaleString('en-US', {minimumFractionDigits: 2}));
                            $('#invoice-quantity').text(data.quantity + ' ' + data.duration_type);
                            $('#invoice-subtotal').text(parseFloat(data.total_amount).toLocaleString('en-US', {minimumFractionDigits: 2}));
                            $('#invoice-total').text(parseFloat(data.total_amount).toLocaleString('en-US', {minimumFractionDigits: 2}));
                            $('#invoice-payment-method').text(data.payment_method);
                            $('#invoice-payment-date').text(data.payment_date);
                            
                            // Set download link
                            $('#download-invoice-btn').attr('href', "{{ url('admin/my-sponsorship-request') }}/" + requestId + "/invoice/download");
                            
                            $('#loading-overlay').hide();
                            $('#invoiceModal').modal('show');
                        } else {
                            $('#loading-overlay').hide();
                            toastr.error(response.message || 'Failed to load invoice');
                        }
                    },
                    error: function(xhr) {
                        $('#loading-overlay').hide();
                        var errorMsg = 'Failed to load invoice';
                        if (xhr.responseJSON && xhr.responseJSON.message) {
                            errorMsg = xhr.responseJSON.message;
                        }
                        toastr.error(errorMsg);
                    }
                });
            });
        });
    </script>
@endpush