@php
use App\Models\Invoice;

$ftth_mr = Invoice::join('instalasi', 'instalasi.id_instalasi', '=', 'invoice.id_instalasi')
    ->join('customer', 'customer.id_customer', '=', 'instalasi.id_customer')
    ->join('produk', 'produk.id_produk', '=', 'instalasi.id_produk')
    ->where('invoice.id_unit_instalasi',1)
    ->where('status_invoice', 'settlement')
    ->where('customer.jenis_customer', 'Mr.')
    ->whereMonth('invoice.tgl_pembayaran', $_GET['bulan'])
    ->whereYear('invoice.tgl_pembayaran', $_GET['tahun'])
    ->sum('nilai_dibayar');

$ftth_mrs = Invoice::join('instalasi', 'instalasi.id_instalasi', '=', 'invoice.id_instalasi')
    ->join('customer', 'customer.id_customer', '=', 'instalasi.id_customer')
    ->join('produk', 'produk.id_produk', '=', 'instalasi.id_produk')
    ->where('invoice.id_unit_instalasi',1)
    ->where('status_invoice', 'settlement')
    ->where('customer.jenis_customer', 'Mrs.')
    ->whereMonth('invoice.tgl_pembayaran', $_GET['bulan'])
    ->whereYear('invoice.tgl_pembayaran', $_GET['tahun'])
    ->sum('nilai_dibayar');

$total_ftth = $ftth_mr + $ftth_mrs;

$educ = Invoice::join('instalasi', 'instalasi.id_instalasi', '=', 'invoice.id_instalasi')
    ->join('customer', 'customer.id_customer', '=', 'instalasi.id_customer')
    ->join('produk', 'produk.id_produk', '=', 'instalasi.id_produk')
    ->where('invoice.id_unit_instalasi',1)
    ->where('status_invoice', 'settlement')
    ->where('customer.jenis_customer', 'Educ.')
    ->whereMonth('invoice.tgl_pembayaran', $_GET['bulan'])
    ->whereYear('invoice.tgl_pembayaran', $_GET['tahun'])
    ->sum('nilai_dibayar');

$corp = Invoice::join('instalasi', 'instalasi.id_instalasi', '=', 'invoice.id_instalasi')
    ->join('customer', 'customer.id_customer', '=', 'instalasi.id_customer')
    ->join('produk', 'produk.id_produk', '=', 'instalasi.id_produk')
    ->where('invoice.id_unit_instalasi',1)
    ->where('status_invoice', 'settlement')
    ->where('customer.jenis_customer', 'Corp.')
    ->whereMonth('invoice.tgl_pembayaran', $_GET['bulan'])
    ->whereYear('invoice.tgl_pembayaran', $_GET['tahun'])
    ->sum('nilai_dibayar');

$dinas = Invoice::join('instalasi', 'instalasi.id_instalasi', '=', 'invoice.id_instalasi')
    ->join('customer', 'customer.id_customer', '=', 'instalasi.id_customer')
    ->join('produk', 'produk.id_produk', '=', 'instalasi.id_produk')
    ->where('invoice.id_unit_instalasi',1)
    ->where('status_invoice', 'settlement')
    ->where('customer.jenis_customer', 'Dinas.')
    ->whereMonth('invoice.tgl_pembayaran', $_GET['bulan'])
    ->whereYear('invoice.tgl_pembayaran', $_GET['tahun'])
    ->sum('nilai_dibayar');

$reseller = Invoice::join('instalasi', 'instalasi.id_instalasi', '=', 'invoice.id_instalasi')
    ->join('customer', 'customer.id_customer', '=', 'instalasi.id_customer')
    ->join('produk', 'produk.id_produk', '=', 'instalasi.id_produk')
    ->where('invoice.id_unit_instalasi','!=',1)
    ->where('status_invoice', 'settlement')
    ->whereMonth('invoice.tgl_pembayaran', $_GET['bulan'])
    ->whereYear('invoice.tgl_pembayaran', $_GET['tahun'])
    ->sum('nilai_dibayar');


@endphp



<table class="table table-bordered" border="1" style="width: 100%; border-collapse: collapse;">
    <thead>
        <tr>
            <th colspan="2" class="text-center">LAPORAN PENDAPATAN {{$_GET['bulan']}}/{{$_GET['tahun']}}</th>
        </tr>
        <tr>
            <th>Kategori</th>
            <th>Total Pendapatan</th>
        </tr>
    </thead>
    <tbody>
            <tr>
                <td>FTTH</td>
                <td>{{ number($total_ftth) }}</td>
            </tr>
            <tr>
                <td>Educ.</td>
                <td>{{ number($educ) }}</td>
            </tr>
            <tr>
                <td>Corp.</td>
                <td>{{ number($corp) }}</td>
            </tr>
            <tr>
                <td>Dinas.</td>
                <td>{{ number($dinas) }}</td>
            </tr>
            <tr>
                <td>Reseller.</td>
                <td>{{ number($reseller) }}</td>
            </tr>
    </tbody>
    <tfoot>
        <tr>
            <td colspan="1" class="text-right"><strong>Total Pendapatan</td>
            <td class="text-right"><strong>{{ number($total_ftth + $educ + $corp + $dinas + $reseller) }}<br>
            <span style="font-size: 10px;">(FTTH + Educ. + Corp. + Dinas. + Reseller)</span>
            </strong></td>
        </tr>
    </tfoot>
</table>