@extends('layouts.app')

@section('content')
<div class="container-fluid">
    <!-- Header -->
    <div class="d-flex justify-content-between align-items-center mb-4">
        <div>
            <h4 class="mb-1">
                <i class="fas fa-tags"></i> 
                {{ $summary['sub_tag_name'] }}
                <small class="text-muted">({{ $summary['parent_tag_name'] }})</small>
            </h4>
            <p class="text-muted mb-0">
                <small>
                    <i class="fas fa-users"></i> {{ $summary['total_resellers'] }} resellers
                </small>
            </p>
        </div>
        <div>
            <a href="{{ url()->previous() }}" class="btn btn-secondary">
                <i class="fas fa-arrow-left"></i> Back to Report
            </a>
        </div>
    </div>

    <!-- Invoices Table -->
    <div class="card">
        <div class="card-header bg-white d-flex justify-content-between align-items-center">
            <h5 class="mb-0"><i class="fas fa-file-invoice"></i> Invoice Details</h5>
            <div>
                <button onclick="exportSubTagInvoices('excel')" class="btn btn-success btn-sm">
                    <i class="fas fa-file-excel"></i> Export to Excel
                </button>
                <button onclick="exportSubTagInvoices('pdf')" class="btn btn-danger btn-sm">
                    <i class="fas fa-file-pdf"></i> Export to PDF
                </button>
            </div>
        </div>
        <div class="card-body">
            @if($invoices->count() > 0)
                <div class="table-responsive">
                    <table class="table table-bordered table-hover">
                        <thead class="thead-light">
                            <tr>
                                <th>Customer</th>
                                <th class="text-right">Current Month Bill</th>
                                <th class="text-right">Previous Due</th>
                                <th class="text-right">Total Outstanding</th>
                                <th class="text-right">Current Month Receive</th>
                                <th class="text-right">Current Month Invoice Due</th>
                                <th class="text-right">Month to Month Due</th>
                                <th class="text-right">Closing Due Balance</th>
                                <th class="text-right">Advance</th>
                                <th class="text-right">Payment Rate</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $customerData = [];
                                $fromDate = request('from_date') ? \Carbon\Carbon::parse(request('from_date')) : null;
                                $toDate = request('to_date') ? \Carbon\Carbon::parse(request('to_date')) : null;
                                
                                // Group invoices by customer
                                foreach($invoices as $invoice) {
                                    $customerId = $invoice->customer_id;
                                    if (!isset($customerData[$customerId])) {
                                        $customerData[$customerId] = [
                                            'customer' => $invoice->customer,
                                            'current_month_bill' => 0,
                                            'previous_due' => 0,
                                            'total_outstanding' => 0,
                                            'current_month_receive' => 0,
                                            'current_month_invoice_due' => 0,
                                            'month_to_month_due' => 0,
                                            'closing_due_balance' => 0,
                                            'advance' => 0,
                                        ];
                                    }
                                }
                                
                                // Calculate for each customer
                                foreach($customerData as $customerId => $data) {
                                    $customer = $data['customer'];
                                    
                                    // Get all invoice IDs for this customer
                                    $allInvoiceIds = \App\Models\SalesInvoice::where('customer_id', $customerId)->pluck('id');
                                    
                                    // 1. Current Month Bill
                                    $currentMonthBill = \App\Models\SalesInvoice::where('customer_id', $customerId)
                                        ->when($fromDate, fn($q) => $q->whereDate('invoice_date', '>=', $fromDate))
                                        ->when($toDate, fn($q) => $q->whereDate('invoice_date', '<=', $toDate))
                                        ->sum('invoice_amount') ?? 0;
                                    
                                    // 2. Previous Due
                                    $previousInvoices = \App\Models\SalesInvoice::where('customer_id', $customerId)
                                        ->when($fromDate, fn($q) => $q->whereDate('invoice_date', '<', $fromDate))
                                        ->get();
                                    
                                    $previousDue = 0;
                                    foreach($previousInvoices as $prevInv) {
                                        $paid = \DB::table('sales_invoice_transections')
                                            ->where('sales_invoice_id', $prevInv->id)
                                            ->where('transaction_type', 'payment')
                                            ->when($fromDate, fn($q) => $q->whereDate('transaction_date', '<', $fromDate))
                                            ->sum('amount') ?? 0;
                                        $previousDue += max(0, $prevInv->invoice_amount - $paid);
                                    }
                                    
                                    // 3. Total Outstanding
                                    $totalOutstanding = $previousDue + $currentMonthBill;
                                    
                                    // 4. Current Month Receive
                                    $currentMonthReceive = \DB::table('sales_invoice_transections')
                                        ->whereIn('sales_invoice_id', $allInvoiceIds)
                                        ->where('transaction_type', 'payment')
                                        ->when($fromDate, fn($q) => $q->whereDate('transaction_date', '>=', $fromDate))
                                        ->when($toDate, fn($q) => $q->whereDate('transaction_date', '<=', $toDate))
                                        ->sum('amount') ?? 0;
                                    
                                    // 5. Current Month Invoice Due
                                    $currentMonthInvoices = \App\Models\SalesInvoice::where('customer_id', $customerId)
                                        ->when($fromDate, fn($q) => $q->whereDate('invoice_date', '>=', $fromDate))
                                        ->when($toDate, fn($q) => $q->whereDate('invoice_date', '<=', $toDate))
                                        ->get();
                                    
                                    $currentMonthInvoiceDue = 0;
                                    foreach($currentMonthInvoices as $currInv) {
                                        $paid = \DB::table('sales_invoice_transections')
                                            ->where('sales_invoice_id', $currInv->id)
                                            ->where('transaction_type', 'payment')
                                            ->sum('amount') ?? 0;
                                        $currentMonthInvoiceDue += max(0, $currInv->invoice_amount - $paid);
                                    }
                                    
                                    // 6. Month to Month Due
                                    $monthToMonthDue = max(0, $currentMonthBill - $currentMonthReceive);
                                    
                                    // 7. Closing Due Balance
                                    $closingDueBalance = max(0, $totalOutstanding - $currentMonthReceive);
                                    
                                    // 8. Advance
                                    $advance = \DB::table('advance_payments')
                                        ->where('user_id', $customerId)
                                        ->when($fromDate, fn($q) => $q->whereDate('payment_date', '>=', $fromDate))
                                        ->when($toDate, fn($q) => $q->whereDate('payment_date', '<=', $toDate))
                                        ->sum('amount') ?? 0;
                                    
                                    // Payment Status
                                    $paymentStatus = $closingDueBalance <= 0 ? 'Paid' : ($currentMonthReceive > 0 ? 'Partial' : 'Unpaid');
                                    $statusClass = $closingDueBalance <= 0 ? 'success' : ($currentMonthReceive > 0 ? 'warning' : 'danger');
                                    
                                    // Calculate Payment Rate
                                    $paymentRate = $totalOutstanding > 0 ? ($currentMonthReceive / $totalOutstanding) * 100 : 0;
                                    
                                    $customerData[$customerId] = array_merge($data, [
                                        'current_month_bill' => $currentMonthBill,
                                        'previous_due' => $previousDue,
                                        'total_outstanding' => $totalOutstanding,
                                        'current_month_receive' => $currentMonthReceive,
                                        'current_month_invoice_due' => $currentMonthInvoiceDue,
                                        'month_to_month_due' => $monthToMonthDue,
                                        'closing_due_balance' => $closingDueBalance,
                                        'advance' => $advance,
                                        'payment_rate' => $paymentRate,
                                        'payment_status' => $paymentStatus,
                                        'status_class' => $statusClass,
                                    ]);
                                }
                            @endphp
                            
                            @foreach($customerData as $data)
                                <tr>
                                    <td>
                                        <strong>{{ $data['customer']->name ?? 'Unknown' }}</strong>
                                        @if($data['customer']->company_name)
                                            <br><small class="text-muted">{{ $data['customer']->company_name }}</small>
                                        @endif
                                    </td>
                                    <td class="text-right">৳ {{ number_format($data['current_month_bill'], 0) }}</td>
                                    <td class="text-right {{ $data['previous_due'] > 0 ? 'text-danger' : '' }}">৳ {{ number_format($data['previous_due'], 0) }}</td>
                                    <td class="text-right {{ $data['total_outstanding'] > 0 ? 'text-warning font-weight-bold' : '' }}">৳ {{ number_format($data['total_outstanding'], 0) }}</td>
                                    <td class="text-right text-success">৳ {{ number_format($data['current_month_receive'], 0) }}</td>
                                    <td class="text-right {{ $data['current_month_invoice_due'] > 0 ? 'text-danger' : '' }}">৳ {{ number_format($data['current_month_invoice_due'], 0) }}</td>
                                    <td class="text-right {{ $data['month_to_month_due'] > 0 ? 'text-warning' : '' }}">৳ {{ number_format($data['month_to_month_due'], 0) }}</td>
                                    <td class="text-right {{ $data['closing_due_balance'] > 0 ? 'text-danger font-weight-bold' : 'text-success font-weight-bold' }}">৳ {{ number_format($data['closing_due_balance'], 0) }}</td>
                                    <td class="text-right text-info font-weight-bold">৳ {{ number_format($data['advance'], 0) }}</td>
                                    <td class="text-right font-weight-bold">{{ number_format($data['payment_rate'], 1) }}%</td>
                                </tr>
                            @endforeach
                        </tbody>
                        <tfoot class="table-active font-weight-bold">
                            <tr>
                                <td class="text-right"><strong>TOTAL:</strong></td>
                                <td class="text-right"><strong>৳ {{ number_format(array_sum(array_column($customerData, 'current_month_bill')), 0) }}</strong></td>
                                <td class="text-right"><strong>৳ {{ number_format(array_sum(array_column($customerData, 'previous_due')), 0) }}</strong></td>
                                <td class="text-right"><strong>৳ {{ number_format(array_sum(array_column($customerData, 'total_outstanding')), 0) }}</strong></td>
                                <td class="text-right text-success"><strong>৳ {{ number_format(array_sum(array_column($customerData, 'current_month_receive')), 0) }}</strong></td>
                                <td class="text-right"><strong>৳ {{ number_format(array_sum(array_column($customerData, 'current_month_invoice_due')), 0) }}</strong></td>
                                <td class="text-right"><strong>৳ {{ number_format(array_sum(array_column($customerData, 'month_to_month_due')), 0) }}</strong></td>
                                <td class="text-right"><strong>৳ {{ number_format(array_sum(array_column($customerData, 'closing_due_balance')), 0) }}</strong></td>
                                <td class="text-right text-info"><strong>৳ {{ number_format(array_sum(array_column($customerData, 'advance')), 0) }}</strong></td>
                                <td class="text-right">
                                    @php
                                        $totalOutstandingSum = array_sum(array_column($customerData, 'total_outstanding'));
                                        $totalReceiveSum = array_sum(array_column($customerData, 'current_month_receive'));
                                        $overallPaymentRate = $totalOutstandingSum > 0 ? ($totalReceiveSum / $totalOutstandingSum) * 100 : 0;
                                    @endphp
                                    <strong>{{ number_format($overallPaymentRate, 1) }}%</strong>
                                </td>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            @else
                <div class="text-center py-5">
                    <i class="fas fa-inbox fa-3x text-muted mb-3"></i>
                    <p class="text-muted">No invoices found for this sub-tag in the selected date range.</p>
                    <small class="text-muted">
                        This could mean:
                        <ul class="text-left mt-2">
                            <li>No resellers are assigned to this sub-tag</li>
                            <li>No invoices exist in the selected date range</li>
                            <li>Try selecting a different date range</li>
                        </ul>
                    </small>
                </div>
            @endif
        </div>
    </div>
</div>

<!-- Invoice Details Modal -->
<div class="modal fade" id="invoiceDetailsModal" tabindex="-1" role="dialog">
    <div class="modal-dialog modal-lg" role="document">
        <div class="modal-content">
            <div class="modal-header bg-primary text-white">
                <h5 class="modal-title"><i class="fas fa-file-invoice"></i> Invoice Details</h5>
                <button type="button" class="close text-white" data-dismiss="modal">
                    <span>&times;</span>
                </button>
            </div>
            <div class="modal-body" id="invoiceDetailsContent">
                <div class="text-center">
                    <div class="spinner-border text-primary" role="status">
                        <span class="sr-only">Loading...</span>
                    </div>
                </div>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>

<script>
function exportSubTagInvoices(format) {
    const subTagId = {{ $subTag->id }};
    const fromDate = '{{ request("from_date") }}';
    const toDate = '{{ request("to_date") }}';
    
    let url = `/reseller/sales-report/subtag/${subTagId}/export?format=${format}`;
    
    if (fromDate) {
        url += `&from_date=${fromDate}`;
    }
    if (toDate) {
        url += `&to_date=${toDate}`;
    }
    
    window.open(url, '_blank');
}

function viewInvoiceDetails(invoiceId) {
    $('#invoiceDetailsModal').modal('show');
    
    // Load invoice details via AJAX
    fetch(`/api/sales-invoice/${invoiceId}`)
        .then(response => response.json())
        .then(data => {
            if (data.success) {
                displayInvoiceDetails(data.invoice);
            } else {
                $('#invoiceDetailsContent').html(`
                    <div class="alert alert-danger">
                        <i class="fas fa-exclamation-triangle"></i> Error loading invoice details
                    </div>
                `);
            }
        })
        .catch(error => {
            $('#invoiceDetailsContent').html(`
                <div class="alert alert-danger">
                    <i class="fas fa-exclamation-triangle"></i> Error loading invoice details
                </div>
            `);
        });
}

function displayInvoiceDetails(invoice) {
    let html = `
        <div class="mb-3">
            <h6><strong>Invoice No:</strong> ${invoice.invoice_no}</h6>
            <p><strong>Date:</strong> ${new Date(invoice.invoice_date).toLocaleDateString()}</p>
            <p><strong>Customer:</strong> ${invoice.customer ? invoice.customer.name : 'Unknown'}</p>
            <p><strong>Amount:</strong> ৳ ${parseFloat(invoice.invoice_amount).toLocaleString()}</p>
        </div>
        
        <h6 class="mt-4">Items:</h6>
        <div class="table-responsive">
            <table class="table table-sm table-bordered">
                <thead class="thead-light">
                    <tr>
                        <th>Item Name</th>
                        <th>Description</th>
                        <th class="text-right">Quantity</th>
                        <th class="text-right">Rate</th>
                        <th class="text-right">Amount</th>
                    </tr>
                </thead>
                <tbody>
    `;
    
    if (invoice.items && invoice.items.length > 0) {
        invoice.items.forEach(item => {
            html += `
                <tr>
                    <td>${item.item_name || '-'}</td>
                    <td><small>${item.description || '-'}</small></td>
                    <td class="text-right">${item.quantity || 0}</td>
                    <td class="text-right">৳ ${parseFloat(item.rate || 0).toLocaleString()}</td>
                    <td class="text-right">৳ ${parseFloat(item.total_amount || 0).toLocaleString()}</td>
                </tr>
            `;
        });
    } else {
        html += `
            <tr>
                <td colspan="5" class="text-center text-muted">No items</td>
            </tr>
        `;
    }
    
    html += `
                </tbody>
            </table>
        </div>
    `;
    
    $('#invoiceDetailsContent').html(html);
}
</script>
@endsection