@inject('carbon', '\Carbon')
@inject('constant', '\App\Util\Constant')

@php
    $financingData = [
        [
            'label' => 'Jumlah Pembiayaan',
            'value' => 'Rp ' . getPriceNumber($invoice->submissionValue),
            'indent' => false
        ],
        [
            'label' => 'Jenis Pembiayaan',
            'value' => $invoice->loanType,
            'indent' => false
        ],
        [
            'label' => 'Tujuan Pembiayaan',
            'value' => $invoice->financingPurposes,
            'indent' => false
        ],
        [
            'label' => 'Rating',
            'value' => $invoice->rating,
            'indent' => false
        ],
        [
            'label' => 'Payor',
            'value' => $invoice->payorName,
            'indent' => false
        ],
        [
            'label' => 'Ujroh/Fee Per Tahun',
            'value' => 'Eqv ' . number_format((float)(($invoice->investorMarginRate * $invoice->marginRate) / 100), 2, ',', '') . '% flat',
            'indent' => false
        ],
        [
            'label' => 'Tenor',
            'value' => $invoice->period > 0 ? getPriceNumber($invoice->period) . ' bulan' : getPriceNumber($invoice->periodDay) . ' hari',
            'indent' => false
        ],
        [
            'label' => 'Tanggal Penyaluran',
            'value' => empty($invoice->adminFeeDate) ? '-' : parseDateToIndonesian(Carbon\Carbon::parse($invoice->adminFeeDate)->format('d M Y')),
            'indent' => false
        ],
        [
            'label' => 'Jatuh Tempo Pengembalian',
            'value' => empty($invoice->emailDueDate) ? '-' : parseDateToIndonesian(Carbon\Carbon::parse($invoice->emailDueDate)->format('d M Y')),
            'indent' => false
        ],
        [
            'label' => 'Skema Pengembalian',
            'value' => (is_int($invoice->period) && $invoice->period > 3) 
                        ? 'Pokok dibayar saat jatuh tempo dan ujroh dibayarkan perbulan' 
                        : 'Pokok dan ujroh/fee dibayar saat jatuh tempo',
            'indent' => true
        ]
    ];

    $profileData = [
        [
            'label' => 'Nama (Inisial)',
            'value' => getCompanyInitialName(
                $creditApplicationBusiness->businessName,
                $creditApplicationBusiness->businessType,
                $creditApplication->creditType
            ),
            'indent' => false
        ],
        [
            'label' => 'Bidang Usaha',
            'value' => $creditApplicationBusiness->businessField,
            'indent' => false
        ],
        [
            'label' => 'Berdiri Tahun',
            'value' => parseDateToIndonesian($carbon::parse($creditApplicationBusiness->establishmentDeedDate)->format('Y')),
            'indent' => false
        ],
        [
            'label' => 'Domisili',
            'value' => $creditApplicationBusiness->currentCity,
            'indent' => false
        ],
        [
            'label' => 'NPWP',
            'value' => $creditApplicationBusiness->taxNumber,
            'indent' => false
        ],
        [
            'label' => 'NIB',
            'value' => $creditApplicationBusiness->businessPermitNumber1,
            'indent' => false   
        ],
        [
            'label' => 'Informasi Kelompok Usaha (Afiliasi)',
            'value' =>  'TIdak ada',
            'indent' => false
        ]
    ];

    // Prepare report dates
    $financial = $creditApplicationBusiness->creditApplicationBusinessFinancialPerformance;
    
    $formatDate = function($date) {
        if (empty($date)) return "";
        
        try {
            $parsed = parseDateToIndonesian(Carbon\Carbon::parse($date)->format('M-Y'));
            $parts = explode("-", $parsed);
            return substr($parts[0], 0, 3) . '-' . $parts[1];
        } catch (\Throwable $th) {
            return "";
        }
    };

    $reportDate = $formatDate($financial->reportDate);
    $reportDate2 = $formatDate($financial->reportDate2);

    // Define financial data structure
    $financialSections = [
        [
            'title' => 'Neraca',
            'items' => [
                ['label' => 'Total Current Aset', 'value1' => $financial->totalCurrentAsset, 'value2' => $financial->totalCurrentAsset2, 'formatter' => 'getBillionMillionNumber'],
                ['label' => 'Total Aset', 'value1' => $financial->totalAsset, 'value2' => $financial->totalAsset2, 'formatter' => 'getBillionMillionNumber'],
                ['label' => 'Total Current Liabilities', 'value1' => $financial->totalCurrentLiabilities, 'value2' => $financial->totalCurrentLiabilities2, 'formatter' => 'getBillionMillionNumber'],
                ['label' => 'Total Liabilities', 'value1' => $financial->totalLiabilities, 'value2' => $financial->totalLiabilities2, 'formatter' => 'getBillionMillionNumber'],
                ['label' => 'Ekuitas', 'value1' => $financial->ekuitas, 'value2' => $financial->ekuitas2, 'formatter' => 'getBillionMillionNumber'],
            ]
        ],
        [
            'title' => 'Laba / (Rugi)',
            'items' => [
                ['label' => 'Pendapatan Usaha', 'value1' => $financial->operatingRevenues, 'value2' => $financial->operatingRevenues2, 'formatter' => 'getBillionMillionNumber'],
                ['label' => 'Laba Kotor', 'value1' => $financial->grossProfit, 'value2' => $financial->grossProfit2, 'formatter' => 'getBillionMillionNumber'],
                ['label' => 'Laba Usaha Sebelum Pajak', 'value1' => $financial->profitBeforeTax, 'value2' => $financial->profitBeforeTax2, 'formatter' => 'getBillionMillionNumber'],
                ['label' => 'Laba Bersih Setelah Pajak', 'value1' => $financial->nettProfitAfterTax, 'value2' => $financial->nettProfitAfterTax2, 'formatter' => 'getBillionMillionNumber'],
            ]
        ],
        [
            'title' => 'Rasio Keuangan [%]',
            'items' => [
                ['label' => 'Return On Assets (ROA)', 'value1' => $financial->roa, 'value2' => $financial->roa2, 'formatter' => 'getFormattedNumber', 'suffix' => '%'],
                ['label' => 'Return On Equity (ROE)', 'value1' => $financial->roe, 'value2' => $financial->roe2, 'formatter' => 'getFormattedNumber', 'suffix' => '%'],
                ['label' => 'Debt To Equity (DER)', 'value1' => $financial->der, 'value2' => $financial->der2, 'formatter' => 'getFormattedNumber'],
                ['label' => 'Net Profit Margin (NPM)', 'value1' => $financial->npm, 'value2' => $financial->npm2, 'formatter' => 'getFormattedNumber', 'suffix' => '%'],
                ['label' => 'Quick Ratio', 'value1' => $financial->currentRatio, 'value2' => $financial->currentRatio2, 'formatter' => 'getFormattedNumber'],
            ]
        ]
    ];

    $pefindoFdcScore = [
        [
            'label' => 'PEFINDO',
            'value' => $invoice->proposalInvoicer->kredit_skor_pefindo,
            'indent' => false
        ],
        [
            'label' => 'FDC',
            'value' => $invoice->proposalInvoicer->kredit_skor_fdc,
            'indent' => false
        ],
    ];

    $historyItems = [
        [
            'label' => 'Total Nilai Pembiayaan Sejak Awal',
            'value' => 'Rp ' . getPriceNumber($summaryPembiayaan['totalPembiayaanAwal']),
            'note' => ''
        ],
        [
            'label' => 'Total Nilai Outstanding',
            'value' => 'Rp ' . getPriceNumber($summaryPembiayaan['totalNilaiOutstanding']),
            'note' => ''
        ],
        [
            'label' => 'Jumlah Transaksi Pembiayaan Sejak Awal',
            'value' => $summaryPembiayaan['jumlahTransaksiAwal'],
            'note' => ''
        ],
        [
            'label' => 'Jumlah Transaksi Pengembalian Lancar',
            'value' => $summaryPembiayaan['jumlahTransaksiTepatWaktu'],
            'note' => 'Dipercepat : ' . $summaryPembiayaan['jumlahTransaksiPercepat']
        ],
        [
            'label' => 'Jumlah Transaksi Pengembalian Terlambat (>7 Hari)',
            'value' => $summaryPembiayaan['jumlahTransaksiTerlambat'],
            'note' => ''
        ]
    ];
@endphp

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
    <style>
        @page {
            height: 100vh;
        }

        .fs-s {
            font-size: 10px;
        }
        .fs-m {
            font-size: 12px;
        }
        .fs-l {
            font-size: 14px;
        }
        .section {
            padding: 0 60px;
        }
        .section-title {
            width: 100%;
            font-size: 14px;
            border-bottom: 2px solid black;
        }
        .financial-table {
            width: 100%;
            border-collapse: collapse;
            margin-top: 10px;
            font-size: 12px;
        }

        .financial-header {
            font-weight: bold;
            font-size: 12px;
        }

        .financial-period {
            text-align: right;
            font-weight: bold;
            font-size: 12px;
        }

        .financial-table-header {
            background-color: white;
            font-weight: bold;
            padding: 6px;
        }

        .financial-table-section-header {
            background-color: #ccc;
            font-weight: bold;
            padding: 6px;
        }

        .financial-section-title {
            margin: 0;
            padding: 6px;
        }

        .financial-label {
            padding: 6px;
        }

        .financial-value {
            padding: 6px;
            text-align: right;
        }

        .risk-grid {
            display: grid;
            grid-template-columns: 1fr 1fr;
            gap: 16px;
            margin-top: 10px;
        }

        .risk-item {
            padding: 10px;
            border: 1px solid #ddd;
            border-radius: 6px;
            background-color: #f9f9f9;
        }

        .end-page {
            page-break-before: always;
            margin: 0;
            padding: 0;
            /* display: flex;
            flex-direction: column; 
            justify-content: center; 
            align-items: center;    
            padding: 46% 0;
            width: 500px;
            margin: auto;
            text-align: center; */
        }
        
        .footer-content {
            display: flex;
            flex-direction: column; /* arah vertikal */
            justify-content: center; /* vertikal align */
            align-items: center;     /* horizontal align */
            width: 500px;
            margin: auto;
            padding: 46% 0;
            text-align: center;
        }
        
        .end-page p {
            margin: 5px 0;
            text-align: center;
            font-size: 12px;
            line-height: 1.4;
        }

        .footer-content img {
            width: 80px;
            height: auto;
        }

        .header {
            position: absolute;
            left: 0;
            top: 0;
            width: 100%;
        }
    </style>
</head>
<body>
    <div class="header">
        <div style="background: url('/assets/admin/image/bg-factsheet.png') no-repeat; color: white; height: 80px; padding: 20px;">
            <table width="100%" style="padding-top: 10px">
                <tr>
                    <td>
                        <img src="{{ url('/') }}/assets/frontend/images/logo-white.png" alt="logo" style="height: 50px;">
                    </td>
                    <td style="text-align: right;">
                        <h2 style="margin: 0;color: white; font-size: 12px;">FACT SHEET</h2>
                    </td>
                </tr>
            </table>
        </div>
    </div>
    <div class="section" style="padding-top: 100px;">
        <table>
            <tr>
                <td width="35%"> <p class="fs-m">No Invoice </p></td>
                <td> <p class="fs-m">: &nbsp; {{ $invoice->invoiceNumber }} </p></td>
            </tr>
            <tr>
                <td width="35%"> <p class="fs-m">Tanggal </p></td>
                <td> <p class="fs-m">: &nbsp; {{ empty($invoice->createdAt) ? "" : parseDateToIndonesian($carbon::parse($invoice->createdAt)->format('d M Y')) }} </p></td>
            </tr>
        </table>
    </div>
    <div class="section">
        <h2 class="section-title">DETAIL PEMBIAYAAN</h2>
        <table>
            @foreach($financingData as $item)
            <tr style="width: 100%;">
                <td width="35%"><p class="fs-m">{{ $item['label'] }}</p></td>
                <td width="2%"><p class="fs-m">:</p></td>
                <td>
                    <p class="fs-m">
                        @if($item['indent'])
                        <span style="margin-left: 25px;">{{ $item['value'] }}</span>
                        @else
                        {{ $item['value'] }}
                        @endif
                    </p>
                </td>
            </tr>
            @endforeach
        </table>
    </div>
    <div class="section">
        <h2 class="section-title">JAMINAN</h2>
        <table>
            @if (empty($creditApplicationBusiness->businessGuarantee))
            <tr style="width: 100%">
                <td class="fs-m">Tidak ada jaminan</td>
            </tr>
            @else
                @foreach (json_decode($creditApplicationBusiness->businessGuarantee) as $item)
                <tr style="width: 100%">
                    <td class="fs-m">- {{ $constant::BUSINESS_GUARANTEE_LABELS[$item] }} </td>
                </tr>
                @endforeach
            @endif
        </table>
    </div>
    <div class="section">
        <h2 class="section-title">PROFIL PENERIMA PEMBIAYAAN</h2>
        <table>
            @foreach($profileData as $item)
            <tr style="width: 100%;">
                <td width="35%"><p class="fs-m">{{ $item['label'] }}</p></td>
                <td width="2%"><p class="fs-m">:</p></td>
                <td>
                    <p class="fs-m">
                        @if($item['indent'])
                        <span style="margin-left: 25px;">{{ $item['value'] }}</span>
                        @else
                        {{ $item['value'] }}
                        @endif
                    </p>
                </td>
            </tr>
            @endforeach
        </table>
    </div>
    <div class="section">
        <h2 class="section-title">INFORMASI USAHA</h2>
        <table>
            @if (empty($creditApplication->description))
            <tr style="width: 100%">
                <td class="fs-m">Tidak ada informasi usaha</td>
            </tr>
            @else
            <tr style="width: 100%">
                <td class="fs-m"> {!! nl2br($creditApplication->description) !!} </td>
            </tr>
            @endif
        </table>
    </div>
    <div class="section">
        <h2 class="section-title">KINERJA KEUANGAN</h2>
        <table class="financial-table">
            <tr>
                <td width="60%" class="financial-table-header"><p class="financial-header">Laporan Keuangan (dalam juta Rp.)</p></td>
                <td class="financial-table-header"><p class="financial-period"><b>{{ $reportDate }}</b></p></td>
                <td class="financial-table-header"><p class="financial-period"><b>{{ $reportDate2 }}</b></p></td>
            </tr>
            @foreach($financialSections as $section)
            <tr>
                <td colspan="3" class="financial-table-section-header"><p class="financial-section-title"><b>{{ $section['title'] }}</b></p></td>
            </tr>
            @foreach($section['items'] as $item)
            <tr>
                <td width="60%"><p class="financial-label"><b>{{ $item['label'] }}</b></p></td>
                <td>
                    <p class="financial-value">
                        {{ $item['formatter']($item['value1'], 2) }}{{ isset($item['suffix']) ? $item['suffix'] : '' }}
                    </p>
                </td>
                <td>
                    <p class="financial-value">
                        {{ $item['formatter']($item['value2'], 2) }}{{ isset($item['suffix']) ? $item['suffix'] : '' }}
                    </p>
                </td>
            </tr>
            @endforeach
            @endforeach
        </table>
        <div class="">
            <p class="fs-m">Catatan kinerja keuangan :
                <br/>
                {!! nl2br($financial->notes) !!}
            </p>
        </div>
    </div>
    <div class="section">
        <h2 class="section-title">KEUNGGULAN BERSAING</h2>
        <table>
            <tr style="width: 100%;">
                <td>
                    <p class="fs-m">{!! nl2br($creditApplication->competitiveAdvantageDescription) !!}</p>
                </td>
            </tr>
        </table>
    </div>
    <div class="section">
        <h2 class="section-title">PEFINDO & FINTECH DATA CENTER SCORE</h2>
        <table>
            @foreach($pefindoFdcScore as $item)
            <tr style="width: 100%;">
                <td width="35%"><p class="fs-m">{{ $item['label'] }}</p></td>
                <td width="2%"><p class="fs-m">:</p></td>
                <td>
                    <p class="fs-m">
                        @if($item['indent'])
                        <span style="margin-left: 25px;">{{ $item['value'] }}</span>
                        @else
                        {{ $item['value'] }}
                        @endif
                    </p>
                </td>
            </tr>
            @endforeach
        </table>
    </div>
    <div class="section">
        <h2 class="section-title">ANALISA RESIKO</h2>
        <table>
            <tr style="width: 100%">
                <td>
                    <p class="fs-m">
                        {!! nl2br($invoice->proposalInvoicer->analisa_risk_note) !!}
                    </p>
                </td>
            </tr>
        </table>
        <table width="100%" cellpadding="6" cellspacing="0">
            <tr>
                <td width="50%" valign="top">
                    <h4 class="fs-m" style="border-bottom: 1px solid black"><strong>Jenis Resiko:</strong></h4>
                    <p class="fs-m">
                        {!! nl2br($invoice->proposalInvoicer->analisa_risk_jenis) !!}
                    </p>
                </td>
                <td width="50%" valign="top">
                    <h4 class="fs-m" style="border-bottom: 1px solid black"><strong>Mitigasi Resiko:</strong></h4>
                    <p class="fs-m">
                        {!! nl2br($invoice->proposalInvoicer->analisa_risk_mitigasi) !!}
                    </p>
                </td>
            </tr>
        </table>
    </div>
    <div class="section">
        <h2 class="section-title">INFORMASI PAYOR</h2>
        <table>
            <tr style="width: 100%">
                <td>
                    <p class="fs-m" style="text-align: justify;">{!! nl2br($invoice->proposalInvoicer->informasi_payor) !!}</p>
                </td>
            </tr>
        </table>
      <!---  <p class="fs-m">Rating Pefindo: -</p> -->
    </div>
    <div class="section">
        <h2 class="section-title">RIWAYAT PEMBIAYAAN</h2>
        <table>
            @foreach($historyItems as $item)
            <tr>
                <td width="60%"><p class="fs-m">{{ $item['label'] }}</p></td>
                <td width="2%"><p class="fs-m">:</p></td>
                <td>
                    <p class="fs-m">
                        {{ $item['value'] }}
                        @if(!empty($item['note']))
                        <span class="fs-m">({{ $item['note'] }})</span>
                        @endif
                    </p>
                </td>
            </tr>
            @endforeach
        </table>
    </div>
    <div class="end-page">
        <div class="footer-content">
            <img src="{{ url('/') }}/assets/frontend/images/LOGO.png" alt="logo">
            <div style="padding-top: 4%">
                <p style="font: bold"><strong>PT DUHA MADANI SYARIAH</strong></p>
                <p>Gedung Millennium Centennial Center Lantai 37 Unit B Jl. Jenderal Sudirman Kav. 25</p>
                <p>Kelurahan Karet, Kecamatan Setiabudi</p>
                <p>Jakarta Selatan, 12920</p>
                <p>Telp: 021-3026 5454</p>
            </div>
        </div>
    </div>
</body>
</html>