@php
use App\Models\AccTransaksi;
use App\Models\UITransaksiReseller;
@endphp
<tr>
    <td style="text-align: center" colspan="18" class="header"><strong>{{env('CORP_NAME')}}</strong></td>
</tr>
<tr>
    <td style="text-align: center" colspan="18" class="header"><strong>{{env('CORP_ADDRESS')}}</strong></td>
</tr>
<tr>
    <td style="text-align: center" colspan="18" class="header"><strong>Phone: <span
            style="color: #0f1fad">{{env('CORP_PHONE')}}</span> | Whatsapp: <span
            style="color: #0f1fad">{{env('CORP_WA_FINANCE')}}</span> | Email: <span
            style="color: #0f1fad">{{env('CORP_EMAIL_CS')}}</span></strong></td>
</tr>
<tr></tr>
<tr>
    <td colspan="18" style="text-align: center"><strong>Rekap Transaksi Reseller</strong></td>
</tr>
    <tr>
        <td colspan="18" style="text-align: center"><strong>Periode : {{ tgl_indo($dari_tgl_export) }} s/d {{ tgl_indo($sampai_tgl_export) }}</strong></td>    
    </tr>
<tr></tr>
<tbody>
    @foreach ($transaksi_reseller as $id_unit_instalasi => $rows)
    @php
    $subtotal_dpp = 0;
    $subtotal_ppn = 0;
    $subtotal_netto = 0;
    $subtotal_bhp_uso = 0;
    $total_adm_midtrans = 0;
    $total_adm_system = 0;
    $total_nilai_dibayar = 0;
    @endphp

    <!-- Unit Instalasi Header -->
    <tr>
        <td colspan="15"><strong>Unit Instalasi: {{ $rows->first()->nama_ui }}</strong></td>
    </tr>
    <tr>
        <th rowspan="2"><strong>No </strong></th>
        <th rowspan="2"><strong>Unit Instalasi </strong></th>
        <th rowspan="2"><strong>Nama </strong></th>
        <th rowspan="2"><strong>Marketing </strong></th>
        <th rowspan="2"><strong>Teknisi </strong></th>
        <th rowspan="2"><strong>Paket </strong></th>
        <th rowspan="2"><strong>Invoice </strong></th>
        <th rowspan="2"><strong>Faktur Pajak </strong></th>
        <th rowspan="2"><strong>Tgl. Create </strong></th>
        <th rowspan="2"><strong>Tgl. Bayar </strong></th>
        <th colspan="3"><strong>Harga </strong></th>
        <th colspan="4"><strong>Biaya </strong></th>
        <th rowspan="2"><strong>Nilai Dibayar </strong></th>
    </tr>
    <tr>
        <th><strong>DPP </strong></th>
        <th><strong>PPn </strong></th>
        <th><strong>Bruto </strong></th>
        <th><strong>BHP + USO </strong></th>
        <th><strong>Metode Bayar </strong></th>
        <th><strong>Adm Pembayaran </strong></th>
        <th><strong>Adm System </strong></th>
    </tr>
    <!-- Data Baris Tabel -->
    @foreach ($rows as $row)
    @php
    if ($row->payment_type == 'bank_transfer') {
    $adm_midtrans = 4440;
    } elseif ($row->payment_type == 'cstore') {
    $adm_midtrans = 5000;
    } elseif ($row->payment_type == 'echannel') {
    $adm_midtrans = 4440;
    } elseif ($row->payment_type == 'gopay') {
    $adm_midtrans = ($row->gross_amount * 2) / 100;
    } elseif ($row->payment_type == 'qris') {
    $adm_midtrans = ($row->gross_amount * 0.7) / 100;
    } else {
    $adm_midtrans = 0;
    }

    $bhp_uso = UITransaksiReseller::where('id_menu_ui_transaksi', $row->id_menu_ui_transaksi)
    ->where('menu_ui_transaksi', 'Biaya BHP+USO')
    ->first();
    $biaya_adm_midtrans = UITransaksiReseller::where('id_menu_ui_transaksi', $row->id_menu_ui_transaksi)
    ->where('menu_ui_transaksi', 'Payment Gateway')
    ->first();
    $biaya_adm_system = UITransaksiReseller::where('id_menu_ui_transaksi', $row->id_menu_ui_transaksi)
    ->where('menu_ui_transaksi', 'Biaya Adm. System')
    ->first();
    @endphp

    @php
    $subtotal_dpp += $row->item_details_price;
    $subtotal_ppn += $row->tax;
    $subtotal_netto += $row->gross_amount;
    $subtotal_bhp_uso += $bhp_uso->nominal_ui_transaksi;
    $total_adm_midtrans += $biaya_adm_midtrans->nominal_ui_transaksi ;
    $total_adm_system += $biaya_adm_system->nominal_ui_transaksi;
    $total_nilai_dibayar += $row->nilai_dibayar;

    @endphp

    <tr>
        <td align="center">{{ $loop->iteration }}</td>
        <td>{{ $row->nama_ui }}</td>
        <td>{{ $row->jenis_customer }} {{ $row->nama }}</td>
        <td>{{ $row->nama_marketing }}</td>
        <td>{{ $row->nama_teknisi }}</td>
        <td>{{ $row->item_details_name }}</td>
        <td>{{ $row->no_invoice ?? 'N/A' }}</td>
        <td>Non PKP</td>
        <td>{{ tgl_indo($row->tgl_invoice) }}</td>
        <td>{{ tgl_indo($row->tgl_pembayaran) }}</td>
        <td align="right">{{ $row->item_details_price }}</td>
        <td align="right">{{ $row->tax }}</td>
        <td align="right">{{ $row->gross_amount }}</td>
        <td align="right">{{ $bhp_uso->nominal_ui_transaksi }}</td>
        <td>{{ $row->payment_type }}</td>
        <td align="right">{{ ($biaya_adm_midtrans->nominal_ui_transaksi) }}</td>
        <td align="right">{{ ($biaya_adm_system->nominal_ui_transaksi) }}</td>
        <td align="right">{{ $row->nilai_dibayar }}</td>
    </tr>
    @endforeach

    <tr>
        <td align="right" colspan="10"><strong>Subtotal {{ $rows->first()->nama_ui }}</strong></td>
        <td align="right"><strong>{{ $subtotal_dpp }}</strong></td>
        <td align="right"><strong>{{ $subtotal_ppn }}</strong></td>
        <td align="right"><strong>{{ $subtotal_netto }}</strong></td>
        <td align="right"><strong>{{ $subtotal_bhp_uso }}</strong></td>
        <td></td>
        <td align="right"><strong> {{ $total_adm_midtrans }}</strong></td>
        <td align="right"><strong>{{ $total_adm_system }}</strong></td>
        <td align="right"><strong>{{$total_nilai_dibayar}}</strong></td>

    </tr>
    @endforeach
</tbody>