@php
use App\Models\Invoice;
use Illuminate\Support\Facades\DB;

$invoices = Invoice::join('unit_instalasi', 'unit_instalasi.id_unit_instalasi', 'invoice.id_unit_instalasi')
    ->join('instalasi', 'instalasi.id_instalasi', 'invoice.id_instalasi')
    ->where('status_invoice', 'settlement')
    ->whereYear('invoice.tgl_pembayaran', 2024)
    ->whereMonth('invoice.tgl_pembayaran', 12)
    ->groupBy('invoice.id_unit_instalasi', 'unit_instalasi.nama_ui')
    ->select(
        'unit_instalasi.nama_ui as nama_reseller',
        DB::raw('SUM(item_details_price) as total')
    )
    ->where('unit_instalasi.id_unit_instalasi', '!=' , '1')
    ->orderBy('unit_instalasi.nama_ui', 'ASC')
    ->get();

$customer = Invoice::join('instalasi', 'instalasi.id_instalasi', 'invoice.id_instalasi')
    ->join('customer', 'customer.id_customer', 'instalasi.id_customer')
    ->join('unit_instalasi', 'unit_instalasi.id_unit_instalasi', 'invoice.id_unit_instalasi')
    ->where('invoice.status_invoice', 'settlement')
    ->whereYear('invoice.tgl_pembayaran', 2024)
    ->whereMonth('invoice.tgl_pembayaran', 12)
    ->where('invoice.id_unit_instalasi', '!=', 1)
    ->select(
        'unit_instalasi.nama_ui',
        'invoice.id_unit_instalasi',
        DB::raw('COUNT(DISTINCT customer.id_customer) as total_customer')
    )
    ->groupBy('invoice.id_unit_instalasi', 'unit_instalasi.nama_ui')
    ->orderBy('unit_instalasi.nama_ui', 'ASC')
    ->get();


@endphp
<style>
    .tb_pendapatan {
        display: flex;
        justify-content: center;
        margin-top: 20px;
        margin-bottom: 40px;
    }

    table {
        border-collapse: collapse;
        width: 70%;
        font-family: Arial, sans-serif;
    }

    th, td {
        border: 1px solid #ddd;
        padding: 10px;
        text-align: left;
    }

    th {
        background-color: #f2f2f2;
    }

    tr:nth-child(even) {
        background-color: #f9f9f9;
    }

    tfoot {
        background-color: #f2f2f2;
        font-weight: bold;
    }
</style>

<h3 style="text-align: center">Pendapatan Tahunan Reseller Desember 2024</h3>

<div class="tb_pendapatan">
    <table>
        <thead>
            <tr>
                <th>Nama Reseller</th>
                <th>Pendapatan</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($invoices as $inv)
                <tr>
                    <td>{{ $inv->nama_reseller }}</td>
                    <td>{{ rupiah($inv->total) }}</td>
                </tr>
            @endforeach
        </tbody>
    </table>
</div>

<br>
<br>

<h3 style="text-align: center">Total Customer Reseller Desember 2024</h3>

<div class="tb_pendapatan">
    <table>
        <thead>
            <tr>
                <th>Nama Reseller</th>
                <th>Total Customer</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($customer as $row)
                <tr>
                    <td>{{ $row->nama_ui }}</td>
                    <td>{{ ($row->total_customer) }}</td>
                </tr>
            @endforeach
        </tbody>
    </table>
</div>