@php
    use App\Models\AccTransaksi;
    use App\Models\UITransaksiReseller;
@endphp
<tr>
    <td colspan="16" class="header">{{env('CORP_NAME')}}</td>
</tr>
<tr>
    <td colspan="16" class="header">{{env('CORP_ADDRESS')}}</td>
</tr>
<tr>
    <td colspan="16" class="header"> Phone: {{ substr(env('CORP_PHONE'), 0, 4) . '-' . substr(env('CORP_PHONE'), 4, 4) . '-' . substr(env('CORP_PHONE'), 8) }}
        | Whatsapp:
        {{ substr(env('CORP_WA_FINANCE'), 0, 4) . '-' . substr(env('CORP_WA_FINANCE'), 4, 4) . '-' . substr(env('CORP_WA_FINANCE'), 8) }}
| Email: {{env('CORP_EMAIL_CS')}}</td>
</tr>
<br>
<tr>
    <td colspan="16" class="header">Rekap Komisi Reseller</td>
</tr>
<tr>
    <td colspan="16" class="header">Reseller : {{$unit_instalasi->nama_ui}}</td>
</tr>
<tr>
    <td colspan="16" class="header"><b>Periode :  {{ tgl_lengkap($dari_tgl_export) }} s/d
        {{ tgl_lengkap($sampai_tgl_export) }}</b></td>
</tr>
<tr><td colspan="16"></td></tr>

<table width="100%" border="1" cellspacing="0" cellpadding="0">
    <thead>
        <tr>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;" rowspan="2">No</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;" rowspan="2">Nama</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;" rowspan="2">Marketing</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;" rowspan="2">Teknisi</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;" rowspan="2">Paket</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;" rowspan="2">Invoice</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;" rowspan="2">Tgl. Create</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;" rowspan="2">Tgl. Bayar</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;" colspan="3">Harga</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;" colspan="4">Biaya</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;" rowspan="2">Nilai Dibayar</th>
        </tr>
        <tr>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;">DPP</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;">PPn </th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;">Bruto</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;">BHP + USO</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;">Metode Bayar</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;">Adm Pembayaran </th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;">Adm System</th>
        </tr>

    </thead>
    <tbody>
        @php
            $total_dpp = 0;
            $total_ppn11 = 0;
            $total_net = 0;
            $sub_total_bhp_uso = 0;
            $total_adm_midtrans = 0;
            $total_adm_system = 0;
            $total_nilai_dibayar = 0;
        @endphp
        @foreach ($transaksi_reseller 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


            <tr>
                <td style="padding:2px 2px 2px 2px;" align="center">{{ $loop->index + 1 }}</td>
                <td>{{ $row->nama }}</td>
                <td>{{ $row->nama_marketing }}</td>
                <td>{{ $row->nama_teknisi }}</td>
                <td>{{ $row->nama_produk }}</td>
                <td>{{ $row->no_invoice }}</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>
                    @if ($row->payment_type == 'gopay')
                        <span class="badge badge-success">Gopay</span>
                    @elseif ($row->payment_type == 'bank_transfer')
                        <span class="badge badge-info">Bank Transfer</span>
                    @elseif ($row->payment_type == 'cstore')
                        <span class="badge badge-danger">Alfamart</span>
                    @elseif ($row->payment_type == 'echannel')
                        <span class="badge badge-danger">Bank Mandiri</span>
                    @elseif ($row->payment_type == 'VA')
                        <span class="badge badge-info">VA Mandiri</span>
                    @else
                        <span class="badge badge-info">{{ $row->payment_type }}</span>
                    @endif
                </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>
            @php
                $total_dpp += $row->item_details_price;
                $total_ppn11 += $row->tax;
                $total_net += $row->gross_amount;
                $sub_total_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
        @endforeach
        <tr>
            <td align="right" colspan="8"><b>Total</b></td>
            <td align="right"><b>{{ ($total_dpp) }}</b></td>
            <td align="right"><b>{{ ($total_ppn11) }}</b></td>
            <td align="right"><b>{{ ($total_net) }}</b></td>
            <td align="right"><b>{{ ($sub_total_bhp_uso) }}</b></td>
            <td></td>
            <td align="right"><b>{{ ($total_adm_midtrans) }}</b></td>
            <td align="right"><b>{{ ($total_adm_system) }}</b></td>
            <td align="right"><b>{{ ($total_nilai_dibayar) }}</b></td>
        </tr>
        <tr><td colspan="16" rowspan="2"></td></tr>
    </tbody>
</table>

<h4>Biaya Oprasional Lainnya</h4>
<table width="100%" border="1" cellspacing="0" cellpadding="0" style="margin: 2px 2px 2px 2px;">
    <thead>
        <tr style="background:#f26b0b; color:rgb(0, 0, 0);">
            <th style="background-color: #f26b0b; color:white; font-weight: bold;" align="center">No</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;">Tanggal</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;">Keterangan</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;">Biaya</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td></td>
            <td colspan="3">Biaya Pokok</td>
        </tr>
        @php
            $total_biaya_pokok = 0;
        @endphp
        @foreach ($riwayat_biaya_reseller as $row)
            <tr>
                <td style="padding:2px 2px 2px 2px;" align="center">{{ $loop->index + 1 }}</td>
                <td>{{ tgl_lengkap($row->tgl_transaksi) }}</td>
                <td>{!! $row->keterangan_ui_transaksi !!}</td>
                <td align="right">{{ ($row->nominal_ui_transaksi) }}</td>
            </tr>
            @php
                $total_biaya_pokok += $row->nominal_ui_transaksi;
            @endphp
        @endforeach
        <tr>
            <td colspan="3" align="right"><b>Total</b></td>
            <td align="right"><b>{{ ($total_biaya_pokok) }}</b></td>
        </tr>


        <tr>
            <td></td>
            <td colspan="3">Biaya WA Blast</td>
        </tr>
        @php
            $total_biaya_wa_blast = 0;
        @endphp
        @foreach ($riwayat_wa_blast as $row)
            <tr>
                <td style="padding:2px 2px 2px 2px;" align="center">{{ $loop->index + 1 }}</td>
                <td>{{ tgl_lengkap($row->tgl_transaksi) }}</td>
                <td>{{ $row->keterangan_ui_transaksi }}</td>
                <td align="right">{{ ($row->nominal_ui_transaksi) }}</td>
            </tr>
            @php
                $total_biaya_wa_blast += $row->nominal_ui_transaksi;
            @endphp
        @endforeach
        <tr>
            <td colspan="3" align="right"><b>Total</b></td>
            <td align="right"><b>{{ ($total_biaya_wa_blast) }}</b></td>
        </tr>
        
        <tr>
            <td></td>
            <td colspan="3">Biaya Pajak TER</td>
        </tr>
        @php
            $total_biaya_pajak_ter = 0;
        @endphp
        @foreach ($riwayat_pajak_ter as $row)
            <tr>
                <td style="padding:2px 2px 2px 2px;" align="center">{{ $loop->index + 1 }}</td>
                <td>{{ tgl_lengkap($row->tgl_transaksi) }}</td>
                <td>{{ $row->keterangan_ui_transaksi }}</td>
                <td align="right">{{ ($row->nominal_ui_transaksi) }}</td>
            </tr>
            @php
                $total_biaya_pajak_ter += $row->nominal_ui_transaksi;
            @endphp
        @endforeach
        <tr>
            <td colspan="3" align="right"><b>Total</b></td>
            <td align="right"><b>{{ ($total_biaya_pajak_ter) }}</b></td>
        </tr>

        <tr>
            <td></td>
            <td colspan="3">Biaya Transfer Komisi / Payout Fee</td>
        </tr>
        @php
            $total_biaya_payout_fee = 0;
        @endphp
        @foreach ($riwayat_payout_fee as $row)
            <tr>
                <td style="padding:2px 2px 2px 2px;" align="center">{{ $loop->index + 1 }}</td>
                <td>{{ tgl_lengkap($row->tgl_transaksi) }}</td>
                <td>{{ $row->keterangan_ui_transaksi }}</td>
                <td align="right">{{ ($row->nominal_ui_transaksi) }}</td>
            </tr>
            @php
                $total_biaya_payout_fee += $row->nominal_ui_transaksi;
            @endphp
        @endforeach
        <tr>
            <td colspan="3" align="right"><b>Total</b></td>
            <td align="right"><b>{{ ($total_biaya_payout_fee) }}</b></td>
        </tr>
        <tr><td colspan="16" rowspan="2"></td></tr>
    </tbody>
</table>

<h4>Riwayat Withdraw / Penarikan Dana</h4>
<table width="100%" border="1" cellspacing="0" cellpadding="0" style="margin: 2px 2px 2px 2px;">
    <thead>
        <tr style="background:#f26b0b; color:rgb(0, 0, 0);">
            <th style="background-color: #f26b0b; color:white; font-weight: bold;" align="center">No</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;">Tanggal</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;">Keterangan</th>
            <th style="background-color: #f26b0b; color:white; font-weight: bold;">Biaya</th>
        </tr>
    </thead>
    <tbody>
        @php
            $sub_total_penarikan_dana = 0;
        @endphp
        @foreach ($riwayat_penarikan_dana as $row)
            <tr>
                <td style="padding:2px 2px 2px 2px;" align="center">{{ $loop->index + 1 }}</td>
                <td>{{ tgl_lengkap($row->tgl_transaksi) }}</td>
                <td>{{ $row->keterangan_ui_transaksi }}</td>
                <td align="right">{{ ($row->nominal_ui_transaksi) }}</td>
            </tr>
            @php
                $sub_total_penarikan_dana += $row->nominal_ui_transaksi;
            @endphp
        @endforeach
        <tr>
            <td colspan="3" align="right"><b>Total</b></td>
            <td align="right"><b>{{ ($sub_total_penarikan_dana) }}</b></td>
        </tr>
        <tr><td colspan="16" rowspan="2"></td></tr>
    </tbody>

</table>

<h4>Rekap Laporan Reseller Periode {{ tgl_lengkap($dari_tgl_export) }} s/d
    {{ tgl_lengkap($sampai_tgl_export) }}</h4>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
        @php
            $tgl_sebelumnya = date('Y-m-d', strtotime('-1 days', strtotime($dari_tgl_export)));
        @endphp
        <td colspan="3" style="color: red;"><b>Saldo Awal Pada {{ tgl_lengkap($tgl_sebelumnya) }}</b></td>
        <td style="color: red;"><b>: {{ ($saldo_periode_sebelumnya) }}</b></td>
        <td colspan="12" rowspan="22"></td>
    </tr>
    <tr> <td colspan="4"></td></tr>
    <tr>
        <td colspan="3"><b>Debit</b></td>       
    </tr>    
    <tr>
        <td colspan="3" width="25%">Invoice Penjualan</td>
        <td width="75%">: {{ ($total_invoice_penjualan) }}</td>
        <td colspan="12"></td>
    </tr>
    <tr>
        <td colspan="3">Pembayaran Piutang</td>
        <td>: {{ ($total_pembayaran_piutang) }}</td>
        <td colspan="12"></td>
    </tr>
    <tr>
        <td colspan="3" style="color: blue;"><b>Total Debit / Pemasukan</b> </td>
        <td style="color: blue;"><b>:
                {{ ($grandtotal_debit = $total_invoice_penjualan + $total_pembayaran_piutang) }}</b></td>
                <td colspan="12"></td>
    </tr>
    <tr><td colspan="4"></td></tr>
    <tr>
        <td colspan="3"><b>Kredit</b>
        </td>        
    </tr>    
    <tr>
        <td colspan="3">Biaya PPn </td>
        <td>: {{ ($total_ppn) }}</td>
        <td colspan="12"></td>        
    </tr>
    <tr>
        <td colspan="3">Biaya BHP USO </td>
        <td>: {{ ($total_bhp_uso) }}</td>
        <td colspan="12"></td>
    </tr>
    <tr>
        <td colspan="3">Biaya Payment Gateway</td>
        <td>: {{ ($total_payment_gateway) }}</td>
        <td colspan="12"></td>
    </tr>
    <tr>
        <td colspan="3">Biaya Adm. System</td>
        <td>: {{ ($total_biaya_admin) }}</td>
        <td colspan="12"></td>
    </tr>
    <tr>
        <td colspan="3">Biaya Whatsapp Blast </td>
        <td>: {{ ($total_wa_blast) }}</td>
        <td colspan="12"></td>
    </tr>
    <tr>
        <td colspan="3">Biaya Pokok Reseller </td>
        <td>: {{ ($total_biaya_reseller) }}</td>
        <td colspan="12"></td>
    </tr>
    <tr>
        <td colspan="3">Biaya Pajak TER</td>
        <td>: {{ ($total_pajak_ter) }}</td>
        <td colspan="12"></td>
    </tr>
    <tr>
        <td colspan="3">Biaya Transfer Komisi</td>
        <td>: {{ ($total_payout_fee) }}</td>
        <td colspan="12"></td>
    </tr>
    <tr>
        <td colspan="3" style="color: red;"><b>Total Kredit / Biaya</b> </td>
        <td style="color: red;"><b>:
                {{ ($grandtotal_kredit = $total_ppn + $total_bhp_uso + $total_payment_gateway + $total_biaya_admin + $total_wa_blast + $total_biaya_reseller + $total_pajak_ter + $total_payout_fee) }}</b>
        </td>
        <td colspan="12"></td>
    </tr>
    <tr><td colspan="4"></td></tr>
    <tr>
        <td colspan="3"><b>Withdraw</b>
        </td>
    </tr>
    
    <tr>    
        <td colspan="3">Saldo Awal Pada {{ tgl_lengkap($dari_tgl_export) }} s/d
            {{ tgl_lengkap($sampai_tgl_export) }}</td>
        <td>: {{ ($saldo_awal_periode = $saldo_periode_sebelumnya + $grandtotal_debit - $grandtotal_kredit) }}</td>
        <td colspan="12"></td>
    </tr>

    <tr>
        <td colspan="3" style="color: green;"><b>Total Refund/Dana Ditarik  </b></td>
        <td style="color: green;"><b>: {{ ($total_penarikan_dana) }}</b></td>
        <td colspan="12"></td>
    </tr>

    <tr>
        <td colspan="3">Saldo Akhir Pada {{ tgl_lengkap($dari_tgl_export) }} s/d
            {{ tgl_lengkap($sampai_tgl_export) }}</td>
        <td>: {{ ($sisa_saldo_periode = $saldo_periode_sebelumnya + $grandtotal_debit - $grandtotal_kredit - $total_penarikan_dana) }}</td>
        <td colspan="12"></td>
    </tr>
</table>