@extends('layouts.reseller')

@section('title', 'SMS Reports')
@section('page-title', 'SMS Reports')

@section('content')
<div class="card shadow">
    <div class="card-header bg-primary text-white py-3">
        <div class="d-flex justify-content-between align-items-center">
            <h5 class="mb-0">SMS Reports</h5>
            <div class="btn-group">
                <button type="button" class="btn btn-light dropdown-toggle" data-bs-toggle="dropdown">
                    <i class="fas fa-download me-2"></i>Export
                </button>
                <ul class="dropdown-menu">
                    <li><a class="dropdown-item" href="#" id="exportCSV">CSV</a></li>
                    <li><a class="dropdown-item" href="#" id="exportPDF">PDF</a></li>
                </ul>
            </div>
        </div>
    </div>
    <div class="card-body">
        <!-- Filters -->
        <div class="row mb-4">
            <div class="col-md-12">
                <form id="filterForm" class="row g-3">
                    <div class="col-md-3">
                        <label for="user_id" class="form-label">User</label>
                        <select class="form-control" id="user_id" name="user_id">
                            <option value="">All Users</option>
                            @foreach($users as $user)
                                <option value="{{ $user->id }}">{{ $user->name }}</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-2">
                        <label for="status" class="form-label">Status</label>
                        <select class="form-control" id="status" name="status">
                            <option value="">All Status</option>
                            <option value="sent">Sent</option>
                            <option value="delivered">Delivered</option>
                            <option value="failed">Failed</option>
                            <option value="pending">Pending</option>
                        </select>
                    </div>
                    <div class="col-md-2">
                        <label for="start_date" class="form-label">Start Date</label>
                        <input type="date" class="form-control" id="start_date" name="start_date">
                    </div>
                    <div class="col-md-2">
                        <label for="end_date" class="form-label">End Date</label>
                        <input type="date" class="form-control" id="end_date" name="end_date">
                    </div>
                    <div class="col-md-3 d-flex align-items-end">
                        <button type="submit" class="btn btn-primary me-2">
                            <i class="fas fa-filter me-2"></i>Filter
                        </button>
                        <button type="button" id="resetFilters" class="btn btn-secondary">
                            <i class="fas fa-redo me-2"></i>Reset
                        </button>
                    </div>
                </form>
            </div>
        </div>

        <!-- Statistics -->
        <div class="row mb-4">
            <div class="col-xl-3 col-md-6 mb-4">
                <div class="card border-left-primary shadow h-100 py-2">
                    <div class="card-body">
                        <div class="row no-gutters align-items-center">
                            <div class="col mr-2">
                                <div class="text-xs font-weight-bold text-primary text-uppercase mb-1">
                                    Total SMS</div>
                                <div class="h5 mb-0 font-weight-bold text-gray-800">{{ $stats['total_sms'] }}</div>
                            </div>
                            <div class="col-auto">
                                <i class="fas fa-sms fa-2x text-gray-300"></i>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="col-xl-3 col-md-6 mb-4">
                <div class="card border-left-success shadow h-100 py-2">
                    <div class="card-body">
                        <div class="row no-gutters align-items-center">
                            <div class="col mr-2">
                                <div class="text-xs font-weight-bold text-success text-uppercase mb-1">
                                    Total Cost</div>
                                <div class="h5 mb-0 font-weight-bold text-gray-800">৳{{ number_format($stats['total_cost'], 2) }}</div>
                            </div>
                            <div class="col-auto">
                                <i class="fas fa-money-bill-wave fa-2x text-gray-300"></i>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="col-xl-3 col-md-6 mb-4">
                <div class="card border-left-info shadow h-100 py-2">
                    <div class="card-body">
                        <div class="row no-gutters align-items-center">
                            <div class="col mr-2">
                                <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                                    Your Cost</div>
                                <div class="h5 mb-0 font-weight-bold text-gray-800">৳{{ number_format($stats['your_cost'], 2) }}</div>
                            </div>
                            <div class="col-auto">
                                <i class="fas fa-hand-holding-usd fa-2x text-gray-300"></i>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="col-xl-3 col-md-6 mb-4">
                <div class="card border-left-warning shadow h-100 py-2">
                    <div class="card-body">
                        <div class="row no-gutters align-items-center">
                            <div class="col mr-2">
                                <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">
                                    Your Commission</div>
                                <div class="h5 mb-0 font-weight-bold text-gray-800">৳{{ number_format($stats['commission_earned'], 2) }}</div>
                            </div>
                            <div class="col-auto">
                                <i class="fas fa-chart-line fa-2x text-gray-300"></i>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <!-- Reports Table -->
        <div class="table-responsive">
            <table class="table table-bordered table-hover" id="smsReportsTable">
                <thead class="table-dark">
                    <tr>
                        <th>ID</th>
                        <th>User</th>
                        <th>Sender ID</th>
                        <th>Recipients</th>
                        <th>Message</th>
                        <th>User Cost</th>
                        <th>Your Cost</th>
                        <th>Commission</th>
                        <th>Status</th>
                        <th>Date</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($smsLogs as $sms)
                    <tr>
                        <td>{{ $sms->id }}</td>
                        <td>
                            <div class="d-flex align-items-center">
                                <div class="avatar bg-primary text-white rounded-circle me-2" 
                                     style="width: 30px; height: 30px; line-height: 30px; text-align: center; font-size: 12px;">
                                    {{ strtoupper(substr($sms->user->name, 0, 1)) }}
                                </div>
                                {{ $sms->user->name }}
                            </div>
                        </td>
                        <td>
                            <span class="badge bg-info">{{ $sms->sender_id }}</span>
                        </td>
                        <td>
                            <span class="badge bg-secondary">{{ $sms->message_count }}</span>
                        </td>
                        <td>
                            <span class="message-preview" data-bs-toggle="tooltip" 
                                  title="{{ $sms->message }}">
                                {{ Str::limit($sms->message, 50) }}
                            </span>
                        </td>
                        <td>
                            <strong class="text-success">৳{{ number_format($sms->cost, 2) }}</strong>
                        </td>
                        <td>
                            <strong class="text-info">৳{{ number_format($sms->cost * $resellerRate / ($sms->user->sms_rate ?? $defaultRate), 2) }}</strong>
                        </td>
                        <td>
                            <strong class="text-warning">৳{{ number_format($sms->cost - ($sms->cost * $resellerRate / ($sms->user->sms_rate ?? $defaultRate)), 2) }}</strong>
                        </td>
                        <td>
                            @php
                                $statusClass = [
                                    'sent' => 'success',
                                    'delivered' => 'primary',
                                    'failed' => 'danger',
                                    'pending' => 'warning'
                                ][$sms->status] ?? 'secondary';
                            @endphp
                            <span class="badge bg-{{ $statusClass }}">
                                {{ ucfirst($sms->status) }}
                            </span>
                        </td>
                        <td>{{ $sms->created_at->format('M j, Y H:i') }}</td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
        </div>

        <div class="d-flex justify-content-between align-items-center mt-3">
            <div>Showing {{ $smsLogs->firstItem() }} to {{ $smsLogs->lastItem() }} of {{ $smsLogs->total() }} records</div>
            <div>
                {{ $smsLogs->links() }}
            </div>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script>
$(document).ready(function() {
    // Initialize tooltips
    $('[data-bs-toggle="tooltip"]').tooltip();

    // Filter form submission
    $('#filterForm').submit(function(e) {
        e.preventDefault();
        loadReports();
    });

    // Reset filters
    $('#resetFilters').click(function() {
        $('#filterForm')[0].reset();
        loadReports();
    });

    // Export functionality
    $('#exportCSV').click(function() {
        exportReport('csv');
    });

    $('#exportPDF').click(function() {
        exportReport('pdf');
    });

    function loadReports() {
        const formData = $('#filterForm').serialize();
        // AJAX call to load filtered data
        $.ajax({
            url: '{{ route("reseller.reports.sms") }}',
            data: formData,
            success: function(response) {
                // Update table and statistics
                console.log('Reports loaded', response);
            }
        });
    }

    function exportReport(format) {
        const formData = $('#filterForm').serialize();
        window.location.href = `{{ route("reseller.reports.sms.export") }}?${formData}&format=${format}`;
    }
});
</script>
@endpush