@extends('layouts.app')

@section('title', 'Bandwidth Item Prices')

@section('content')
<div class="container-fluid">
    <!-- Success/Error Messages -->
    @if(session('success'))
        <div class="alert alert-success alert-dismissible fade show">
            <i class="fas fa-check-circle mr-2"></i>{{ session('success') }}
            <button type="button" class="close" data-dismiss="alert">
                <span>&times;</span>
            </button>
        </div>
    @endif

    @if(session('error'))
        <div class="alert alert-danger alert-dismissible fade show">
            <i class="fas fa-exclamation-circle mr-2"></i>{{ session('error') }}
            <button type="button" class="close" data-dismiss="alert">
                <span>&times;</span>
            </button>
        </div>
    @endif

    <!-- Page Header -->
    <div class="row mb-4">
        <div class="col-12">
            <div class="d-flex justify-content-between align-items-center flex-wrap">
                <h1 class="h3 mb-0 text-gray-800">
                    <i class="fas fa-tags mr-2"></i>Bandwidth Item Prices
                </h1>
                <div class="d-flex align-items-center" style="gap: 10px;">
                    <!-- Year Filter -->
                    <div class="form-group mb-0">
                        <label for="yearFilter" class="mr-2 font-weight-bold" style="margin-bottom: 0;">
                            <i class="fas fa-calendar-alt mr-1"></i>Year:
                        </label>
                        <form method="GET" action="{{ route('reseller.bandwidth-item-cost-prices.index') }}" class="d-inline-block" style="margin: 0;">
                            <select name="year" id="yearFilter" class="form-control form-control-sm" onchange="this.form.submit()" style="min-width: 120px; display: inline-block;">
                                @foreach($availableYears as $year)
                                    <option value="{{ $year }}" {{ $selectedYear == $year ? 'selected' : '' }}>{{ $year }}</option>
                                @endforeach
                            </select>
                        </form>
                    </div>
                    <a href="{{ route('reseller.bandwidth-item-cost-prices.create') }}" class="btn btn-primary btn-sm">
                        <i class="fas fa-plus mr-2"></i>Add New Price
                    </a>
                </div>
            </div>
        </div>
    </div>

    <!-- Matrix Table -->
    <div class="row">
        <div class="col-12">
            <div class="card shadow">
                <div class="card-header bg-primary text-white">
                    <h6 class="m-0 font-weight-bold">
                        <i class="fas fa-calendar-check mr-2"></i>
                        Cost Prices for Year: <span class="badge badge-light">{{ $selectedYear }}</span>
                    </h6>
                </div>
                <div class="card-body p-0">
                    <div class="table-responsive">
                        <table class="table table-bordered table-hover mb-0" style="table-layout: fixed;">
                            <thead class="thead-light">
                                <tr>
                                    <th width="12%" class="text-left" style="position: sticky; left: 0; background-color: #f8f9fa; z-index: 10;">
                                        <strong>Bandwidth Item</strong>
                                    </th>
                                    <th width="7.3%" class="text-center">January</th>
                                    <th width="7.3%" class="text-center">February</th>
                                    <th width="7.3%" class="text-center">March</th>
                                    <th width="7.3%" class="text-center">April</th>
                                    <th width="7.3%" class="text-center">May</th>
                                    <th width="7.3%" class="text-center">June</th>
                                    <th width="7.3%" class="text-center">July</th>
                                    <th width="7.3%" class="text-center">August</th>
                                    <th width="7.3%" class="text-center">September</th>
                                    <th width="7.3%" class="text-center">October</th>
                                    <th width="7.3%" class="text-center">November</th>
                                    <th width="7.3%" class="text-center">December</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($bandwidthItems as $item)
                                    <tr>
                                        <td class="text-left font-weight-bold" style="position: sticky; left: 0; background-color: white; z-index: 9; padding: 12px;">
                                            {{ $item->name }}
                                        </td>
                                        @for($month = 1; $month <= 12; $month++)
                                            @php
                                                $priceData = $priceMatrix[$item->id][$month] ?? null;
                                            @endphp
                                            <td class="text-center align-middle" style="padding: 12px; min-height: 60px;">
                                                @if($priceData)
                                                    <div class="price-cell">
                                                        <div class="text-primary font-weight-bold mb-1">
                                                            ৳{{ number_format($priceData['cost_rate'], 2) }}
                                                        </div>
                                                        @if($priceData['gross_cost'])
                                                            <small class="text-muted d-block">
                                                                {{ number_format($priceData['gross_cost'], 2) }}%
                                                            </small>
                                                        @endif
                                                        <div class="mt-1">
                                                            <button type="button" 
                                                                    class="btn btn-xs btn-sm btn-outline-primary edit-price-btn" 
                                                                    data-price-id="{{ $priceData['id'] }}"
                                                                    title="Edit" 
                                                                    style="padding: 2px 6px; font-size: 10px;">
                                                                <i class="fas fa-edit"></i>
                                                            </button>
                                                        </div>
                                                    </div>
                                                @else
                                                    <span class="text-muted">-</span>
                                                @endif
                                            </td>
                                        @endfor
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="13" class="text-center text-muted py-4">
                                            <i class="fas fa-info-circle mr-2"></i>
                                            No bandwidth items found.
                                        </td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Edit Price Modal -->
<div class="modal fade" id="editPriceModal" tabindex="-1" role="dialog" aria-labelledby="editPriceModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg" role="document">
        <div class="modal-content">
            <div class="modal-header bg-primary text-white">
                <h5 class="modal-title" id="editPriceModalLabel">
                    <i class="fas fa-edit mr-2"></i>Edit Bandwidth Item Price
                </h5>
                <button type="button" class="close text-white" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
            <form id="editPriceForm" method="POST">
                @csrf
                @method('PUT')
                <div class="modal-body">
                    <div id="editPriceErrors" class="alert alert-danger" style="display: none;"></div>
                    
                    <div class="alert alert-info">
                        <i class="fas fa-info-circle mr-2"></i>
                        <strong>Bandwidth Item:</strong> <span id="edit_item_name_display"></span>
                    </div>
                    
                    <input type="hidden" name="bandwidth_item_id" id="edit_bandwidth_item_id">
                    
                    <div class="form-group">
                        <label for="edit_cost_rate">Cost Rate (৳) <span class="text-danger">*</span></label>
                        <input type="number" 
                               name="cost_rate" 
                               id="edit_cost_rate" 
                               class="form-control" 
                               step="0.01" 
                               min="0"
                               required>
                        <small class="form-text text-muted">This will update only this specific price entry.</small>
                    </div>

                    <div class="form-group">
                        <label for="edit_gross_cost">Gross Cost (%)</label>
                        <input type="number" 
                               name="gross_cost" 
                               id="edit_gross_cost" 
                               class="form-control" 
                               step="0.01" 
                               min="0"
                               max="100"
                               placeholder="0.00">
                        <small class="form-text text-muted">
                            <i class="fas fa-exclamation-triangle text-warning"></i>
                            Changing this will update <strong>ALL items'</strong> Gross Cost for the same month.
                        </small>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">
                        <i class="fas fa-times mr-2"></i>Cancel
                    </button>
                    <button type="submit" class="btn btn-primary">
                        <i class="fas fa-save mr-2"></i>Update Price
                    </button>
                </div>
            </form>
        </div>
    </div>
</div>

@push('scripts')
<script>
jQuery(document).ready(function($) {
    let currentPriceId = null;
    
    // Handle edit button click
    $(document).on('click', '.edit-price-btn', function(e) {
        e.preventDefault();
        currentPriceId = $(this).data('price-id');
        
        // Show modal
        $('#editPriceModal').modal('show');
        $('#editPriceErrors').hide().html('');
        
        // Fetch price data
        const editUrl = '{{ route("reseller.bandwidth-item-cost-prices.edit", ":id") }}'.replace(':id', currentPriceId);
        
        $.ajax({
            url: editUrl,
            method: 'GET',
            headers: {
                'X-Requested-With': 'XMLHttpRequest',
                'Accept': 'application/json'
            },
            success: function(response) {
                if (response.success) {
                    // Display item name
                    $('#edit_item_name_display').text(response.item_name || 'N/A');
                    $('#edit_bandwidth_item_id').val(response.price.bandwidth_item_id);
                    
                    // Populate form fields (only Cost Rate and Gross Cost)
                    $('#edit_cost_rate').val(response.price.cost_rate || '');
                    $('#edit_gross_cost').val(response.price.gross_cost || '');
                    
                    // Update form action
                    const updateUrl = '{{ route("reseller.bandwidth-item-cost-prices.update", ":id") }}'.replace(':id', currentPriceId);
                    $('#editPriceForm').attr('action', updateUrl);
                }
            },
            error: function(xhr) {
                console.error('Error loading price data:', xhr);
                let errorMessage = 'Error loading price data. Please try again.';
                
                if (xhr.responseJSON && xhr.responseJSON.message) {
                    errorMessage = xhr.responseJSON.message;
                } else if (xhr.status === 404) {
                    errorMessage = 'Price entry not found.';
                } else if (xhr.status === 500) {
                    errorMessage = 'Server error. Please try again later.';
                }
                
                $('#editPriceErrors').html('<i class="fas fa-exclamation-circle mr-2"></i>' + errorMessage).show();
            }
        });
    });
    
    // Handle form submission
    $('#editPriceForm').on('submit', function(e) {
        e.preventDefault();
        
        const formData = $(this).serialize();
        const url = $(this).attr('action');
        
        if (!url) {
            $('#editPriceErrors').html('<i class="fas fa-exclamation-circle mr-2"></i>Invalid form action. Please close and reopen the modal.').show();
            return;
        }
        
        $.ajax({
            url: url,
            method: 'POST',
            data: formData + '&_method=PUT',
            headers: {
                'X-Requested-With': 'XMLHttpRequest',
                'Accept': 'application/json',
                'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
            },
            success: function(response) {
                if (response.success) {
                    // Close modal
                    $('#editPriceModal').modal('hide');
                    
                    // Show success message
                    $('body').append(
                        '<div class="alert alert-success alert-dismissible fade show" style="position: fixed; top: 20px; right: 20px; z-index: 9999;">' +
                        '<i class="fas fa-check-circle mr-2"></i>' + response.message +
                        '<button type="button" class="close" data-dismiss="alert"><span>&times;</span></button>' +
                        '</div>'
                    );
                    
                    // Auto-dismiss alert after 3 seconds
                    setTimeout(function() {
                        $('.alert-success').fadeOut(function() {
                            $(this).remove();
                        });
                    }, 3000);
                    
                    // Reload page after 1 second to show updated data
                    setTimeout(function() {
                        window.location.reload();
                    }, 1000);
                }
            },
            error: function(xhr) {
                let errorHtml = '<strong>Please correct the following errors:</strong><ul class="mb-0 mt-2">';
                
                if (xhr.responseJSON && xhr.responseJSON.errors) {
                    $.each(xhr.responseJSON.errors, function(key, errors) {
                        $.each(errors, function(index, error) {
                            errorHtml += '<li>' + error + '</li>';
                        });
                    });
                } else if (xhr.responseJSON && xhr.responseJSON.message) {
                    errorHtml += '<li>' + xhr.responseJSON.message + '</li>';
                } else {
                    errorHtml += '<li>An error occurred. Please try again.</li>';
                }
                
                errorHtml += '</ul>';
                $('#editPriceErrors').html(errorHtml).show();
            }
        });
    });
    
    // Clear form when modal is closed
    $('#editPriceModal').on('hidden.bs.modal', function() {
        $('#editPriceForm')[0].reset();
        $('#editPriceErrors').hide().html('');
        $('#edit_item_name_display').text('');
        $('#edit_bandwidth_item_id').val('');
    });
});
</script>
@endpush

<style>
    .table-responsive {
        overflow-x: auto;
        overflow-y: visible;
    }
    
    .table th {
        white-space: nowrap;
        font-weight: 600;
    }
    
    .table td {
        vertical-align: middle;
        padding: 12px;
    }
    
    .price-cell {
        min-height: 50px;
        display: flex;
        flex-direction: column;
        justify-content: center;
        align-items: center;
    }
    
    /* Ensure sticky column stays on top */
    thead th:first-child,
    tbody td:first-child {
        position: sticky;
        left: 0;
        z-index: 10;
        background-color: white;
        box-shadow: 2px 0 5px rgba(0,0,0,0.1);
    }
    
    thead th:first-child {
        z-index: 11;
        background-color: #f8f9fa;
    }
    
    tbody tr:hover td:first-child {
        background-color: #f8f9fa;
    }
    
    tbody tr:hover {
        background-color: #f8f9fa;
    }
</style>
@endsection