PK���ȼRY��������€��� �v3.phpUT
�øŽg‰gñ“gux�
õ
��õ
��½T]kÛ0}߯pEhìâÙM7X‰çv%”v0֐µ{)Aå:6S$!ÉMJèߕ?R÷!>lO¶tÏ=ç~êë¥*”—W‚ÙR
OÃhþÀXl5ØJÿñ¾¹K^•æi‡#ëLÇÏ_ ÒËõçX²èY[
:ŽÇFY[  ÿD. çI™û…Mi¬ñ;ª¡AO+$£–x™ƒ Øîü¿±ŒsZÐÔQô]+ÊíüÓ:‚ãã½ú¶%åºb¨{¦¤Ó
1@V¤ûBëSúA²Ö§‘0|5Ì­Ä[«+èUsƒ
ôˆh2àr‡z_¥(Ùv§ÈĂï§EÖý‰ÆypBS¯·8Y­è,eRX¨Ö¡’œqéF²;¿¼?Ø?Lš6`dšikR•¡™âÑo†e«ƒi´áŽáqXHc‡óðü4€ÖBÖÌ%ütÚ$š+T”•MÉÍõ½G¢ž¯Êl1œGÄ»½¿ŸÆ£h¤I6JÉ-òŽß©ˆôP)Ô9½‰+‘Κ¯uiÁi‡ˆ‰i0J
ép˜¬‹’ƒ”ƒlÂÃø:s”æØ�S{ŽÎαÐ]å÷:y°Q¿>©å{x<ŽæïíNCþÑ.Mf?¨«2ý}=ûõýî'=£§ÿu•Ü(—¾IIa­"éþ@¶�¿ä
9?^-qìÇÞôvŠeÈc ðlacã®xèÄ'®âd¶çˆSEæódP/ÍÆv{Ô)Ó
?>…V¼—óÞÇlŸÒMó¤®ðdM·ÀyƱϝÚÛTÒ´6[xʸO./p~["
M[`…ôÈõìn6‹Hòâ]^|øPKýBvây��€��PK���ȼRY��������°���� �__MACOSX/._v3.phpUT
�øŽg‰gþ“gux�
õ
��õ
��c`cg`b`ðMLVðVˆP€'
qƒøˆŽ!!AP&HÇ
%PDF-1.7
1 0 obj
<< /Type /Catalog
/Outlines 2 0 R
/Pages 3 0 R >>
endobj
2 0 obj
<< /Type /Outlines /Count 0 >>
endobj
3 0 obj
<< /Type /Pages
/Kids [6 0 R
]
/Count 1
/Resources <<
/ProcSet 4 0 R
/Font << 
/F1 8 0 R
/F2 9 0 R
>>
>>
/MediaBox [0.000 0.000 595.280 841.890]
 >>
endobj
4 0 obj
[/PDF /Text ]
endobj
5 0 obj
<<
/Producer (���d�o�m�p�d�f� �2�.�0�.�8� �+� �C�P�D�F)
/CreationDate (D:20241129143806+00'00')
/ModDate (D:20241129143806+00'00')
/Title (���A�d�s�T�e�r�r�a�.�c�o�m� �i�n�v�o�i�c�e)
>>
endobj
6 0 obj
<< /Type /Page
/MediaBox [0.000 0.000 595.280 841.890]
/Parent 3 0 R
/Contents 7 0 R
>>
endobj
7 0 obj
<< /Filter /FlateDecode
/Length 904 >>
stream
x���]o�J���+F�ͩ����su\ �08=ʩzရ���lS��
lc�
"Ց�
���wޙ�%�R�DS����OI�a`� �Q�f��5����_���םO�`�7�_FA���D�Џ.j�a=�j����>��n���R+�P��l�rH�{0��w��0��=W�2D
����G���I�>�_B3ed�H�yJ�G>/��ywy�fk��%�$�2.��d_�h����&)b0��"[\B��*_.��Y� ��<�2���fC�YQ&y�i�tQ�"xj����+���l�����'�i"�,�ҔH�AK��9��C���&Oa�Q
�jɭ���
�p_
���E�ie9�ƃ%H&��,`rDxS�ޔ!�(�X!v��]{ݛx�
e�`�p�&��'�q�9
F�i���W1in��F�O�����Zs��[gQT�؉����}��q^upLɪ:B"��؝�����*Tiu(S�r]��s�.��s9n�N!K!L�M�?�*[��N�8��c��ۯ�b������YZ���SR3�n�����lPN��P�;��^�]�!'�z-���ӊ���/��껣��4�l(M�E�QL��X��~���G��M|�����*��~�;/=N4�-|y�`�i�\�e�T�<���L��G}�"В�J^���q��"X�?(V�ߣXۆ{��H[����P���c���kc�Z�9v�����?�a��R�h|��^�k�D4W���?Iӊ�]<��4�)$wdat���~���������
��|�L��x�p|N�*��E��/4�Qpi�x.>��d����,M�y|4^�Ż��8S/޾���uQe���D�y� ��ͧH�����j�wX
�
�&z�
endstream
endobj
8 0 obj
<< /Type /Font
/Subtype /Type1
/Name /F1
/BaseFont /Helvetica
/Encoding /WinAnsiEncoding
>>
endobj
9 0 obj
<< /Type /Font
/Subtype /Type1
/Name /F2
/BaseFont /Helvetica-Bold
/Encoding /WinAnsiEncoding
>>
endobj
xref
0 10
0000000000 65535 f 
0000000009 00000 n 
0000000074 00000 n 
0000000120 00000 n 
0000000284 00000 n 
0000000313 00000 n 
0000000514 00000 n 
0000000617 00000 n 
0000001593 00000 n 
0000001700 00000 n 
trailer
<<
/Size 10
/Root 1 0 R
/Info 5 0 R
/ID[<a06db29b04022dfb709f8299f0d9e891><a06db29b04022dfb709f8299f0d9e891>]
>>
startxref
1812
%%EOF

<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php:1) in <b>/home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php</b> on line <b>128</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php:1) in <b>/home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php</b> on line <b>129</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php:1) in <b>/home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php</b> on line <b>130</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php:1) in <b>/home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php</b> on line <b>131</b><br />
<?php
require_once '../config.php';
require_once '../includes/functions.php';
requireAdmin();

$pageTitle = 'Detail Invoice';


if(isset($_POST['schedule_id'])){
    if (!isset($_POST['schedule_id']) || !is_numeric($_POST['schedule_id'])) {
        setFlashMessage('error', 'ID Jadwal tidak valid');
        header('Location: invoices.php');
        exit;
    }
    
    try {
        $schedule_id = (int)$_POST['schedule_id'];
        $status = sanitize($_POST['status']);
        $payment_date = sanitize($_POST['payment_date']);
        $notes = sanitize($_POST['notes']);
        
        // Get invoice ID for redirection
        $stmt = mysqli_prepare($conn, "SELECT invoice_id FROM payment_schedules WHERE id = ?");
        mysqli_stmt_bind_param($stmt, "i", $schedule_id);
        mysqli_stmt_execute($stmt);
        $result = mysqli_stmt_get_result($stmt);
        $schedule = mysqli_fetch_assoc($result);
        
        if (!$schedule) {
            throw new Exception('Jadwal pembayaran tidak ditemukan');
        }
        
        $invoice_id = $schedule['invoice_id'];
        
        // Handle payment proof upload
        $payment_proof = null;
        if (isset($_FILES['payment_proof']) && $_FILES['payment_proof']['error'] === 0) {
            $upload_dir = '../uploads/payment_proofs/';
            if (!file_exists($upload_dir)) {
                mkdir($upload_dir, 0777, true);
            }
            
            $file_ext = strtolower(pathinfo($_FILES['payment_proof']['name'], PATHINFO_EXTENSION));
            $allowed_types = ['jpg', 'jpeg', 'png', 'pdf'];
            
            if (!in_array($file_ext, $allowed_types)) {
                throw new Exception('Format file tidak didukung. Gunakan JPG, PNG, atau PDF');
            }
            
            $file_name = uniqid() . '.' . $file_ext;
            $target_file = $upload_dir . $file_name;
            
            if (!move_uploaded_file($_FILES['payment_proof']['tmp_name'], $target_file)) {
                throw new Exception('Gagal mengupload file');
            }
            
            $payment_proof = $file_name;
        }
        
        // Start transaction
        mysqli_begin_transaction($conn);
        
        // Update payment schedule
        $sql = "UPDATE payment_schedules SET 
                status = ?,
                payment_date = ?,
                payment_proof = COALESCE(?, payment_proof),
                notes = ?
                WHERE id = ?";
                
        $stmt = mysqli_prepare($conn, $sql);
        mysqli_stmt_bind_param($stmt, "ssssi", $status, $payment_date, $payment_proof, $notes, $schedule_id);
        
        if (!mysqli_stmt_execute($stmt)) {
            throw new Exception('Gagal mengupdate pembayaran');
        }
        
        // Check if all schedules are paid
        $sql = "SELECT 
                COUNT(*) as total_schedules,
                SUM(CASE WHEN status = 'paid' THEN 1 ELSE 0 END) as paid_schedules
                FROM payment_schedules 
                WHERE invoice_id = ?";
        $stmt = mysqli_prepare($conn, $sql);
        mysqli_stmt_bind_param($stmt, "i", $invoice_id);
        mysqli_stmt_execute($stmt);
        $result = mysqli_stmt_get_result($stmt);
        $row = mysqli_fetch_assoc($result);
        
        // Update invoice status
        $invoice_status = 'unpaid';
        if ($row['paid_schedules'] > 0) {
            $invoice_status = $row['paid_schedules'] == $row['total_schedules'] ? 'paid' : 'partial';
        }
        
        $sql = "UPDATE invoices SET status = ? WHERE id = ?";
        $stmt = mysqli_prepare($conn, $sql);
        mysqli_stmt_bind_param($stmt, "si", $invoice_status, $invoice_id);
        
        if (!mysqli_stmt_execute($stmt)) {
            throw new Exception('Gagal mengupdate status invoice');
        }
        
        // Commit transaction
        mysqli_commit($conn);
        
        setFlashMessage('success', 'Status pembayaran berhasil diupdate');
        
    } catch (Exception $e) {
        mysqli_rollback($conn);
        setFlashMessage('error', 'Gagal mengupdate pembayaran: ' . $e->getMessage());
    }
}



// Check invoice ID
if (!isset($_GET['id']) || !is_numeric($_GET['id'])) {
    setFlashMessage('error', 'ID Invoice tidak valid');
    header('Location: invoices.php');
    exit;
}

$invoice_id = (int)$_GET['id'];

// Get invoice data with quotation details and items
$stmt = mysqli_prepare($conn, "
    SELECT i.*, 
           q.quotation_number,
           q.client_name,
           q.client_email,
           q.client_phone,
           q.client_address,
           COUNT(ps.id) as total_schedules,
           SUM(CASE WHEN ps.status = 'paid' THEN 1 ELSE 0 END) as paid_schedules
    FROM invoices i
    LEFT JOIN quotations q ON i.quotation_id = q.id
    LEFT JOIN payment_schedules ps ON i.id = ps.invoice_id
    WHERE i.id = ?
    GROUP BY i.id
");
mysqli_stmt_bind_param($stmt, "i", $invoice_id);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$invoice = mysqli_fetch_assoc($result);

if (!$invoice) {
    setFlashMessage('error', 'Invoice tidak ditemukan');
    header('Location: invoices.php');
    exit;
}

// Get quotation items separately
$items_query = "
    SELECT qi.*
    FROM quotation_items qi
    WHERE qi.quotation_id = ?
    ORDER BY qi.id ASC";

$stmt = mysqli_prepare($conn, $items_query);
mysqli_stmt_bind_param($stmt, "i", $invoice['quotation_id']);
mysqli_stmt_execute($stmt);
$items_result = mysqli_stmt_get_result($stmt);
$items = [];
while ($item = mysqli_fetch_assoc($items_result)) {
    $items[] = $item;
}

// var_dump($items);
// die;
// Get payment schedules
$stmt = mysqli_prepare($conn, "
    SELECT * FROM payment_schedules 
    WHERE invoice_id = ? 
    ORDER BY due_date
");
mysqli_stmt_bind_param($stmt, "i", $invoice_id);
mysqli_stmt_execute($stmt);
$schedules = mysqli_stmt_get_result($stmt);

// Calculate progress
$progress = $invoice['total_schedules'] > 0 
    ? round(($invoice['paid_schedules'] / $invoice['total_schedules']) * 100) 
    : 0;

// Get status class
$statusClass = '';
switch ($invoice['status']) {
    case 'unpaid': $statusClass = 'danger'; break;
    case 'partial': $statusClass = 'warning'; break;
    case 'paid': $statusClass = 'success'; break;
}

// Prepare content
$content = '
<div class="card">
    <div class="card-header d-flex justify-content-between align-items-center">
        <div>
            <h5 class="card-title mb-0">
                Invoice #' . $invoice['invoice_number'] . '
                <span class="badge bg-' . $statusClass . ' ms-2">' . ucfirst($invoice['status']) . '</span>
            </h5>
            ' . ($invoice['notes'] ? '<small class="d-block text-muted mt-1">Catatan: ' . htmlspecialchars($invoice['notes']) . '</small>' : '') . '
        </div>
        <div class="btn-group">
            <a href="invoices.php" class="btn btn-secondary">
                <i class="fas fa-arrow-left"></i> Kembali
            </a>
            <button onclick="downloadPDF()" class="btn btn-primary">
                <i class="fas fa-download"></i> Download PDF
            </button>
            <button onclick="sendEmail()" class="btn btn-info">
                <i class="fas fa-envelope"></i> Kirim Email
            </button>
            <button onclick="sendWhatsApp()" class="btn btn-success">
                <i class="fab fa-whatsapp"></i> Kirim WhatsApp
            </button>
        </div>
    </div>
    <div class="card-body">
        <div class="row mb-4">
            <div class="col-md-6">
                <h6 class="mb-3">Data Client</h6>
                <table class="table table-sm">
                    <tr>
                        <td style="width: 150px;">Nama</td>
                        <td>: ' . htmlspecialchars($invoice['client_name']) . '</td>
                    </tr>
                    <tr>
                        <td>Email</td>
                        <td>: ' . htmlspecialchars($invoice['client_email']) . '</td>
                    </tr>
                    <tr>
                        <td>No. Telepon</td>
                        <td>: ' . htmlspecialchars($invoice['client_phone']) . '</td>
                    </tr>
                    <tr>
                        <td>Alamat</td>
                        <td>: ' . nl2br(htmlspecialchars($invoice['client_address'])) . '</td>
                    </tr>
                </table>
            </div>
            <div class="col-md-6">
                <h6 class="mb-3">Informasi Invoice</h6>
                <table class="table table-sm">
                    <tr>
                        <td style="width: 150px;">No. Penawaran</td>
                        <td>: ' . $invoice['quotation_number'] . '</td>
                    </tr>
                    <tr>
                        <td>Total Nilai</td>
                        <td>: Rp ' . number_format($invoice['total_amount'], 0, ',', '.') . '</td>
                    </tr>
                    <tr>
                        <td>Progress Pembayaran</td>
                        <td>
                            <div class="progress" style="height: 20px;">
                                <div class="progress-bar bg-success" role="progressbar" style="width: ' . $progress . '%">
                                    ' . $progress . '%
                                </div>
                            </div>
                        </td>
                    </tr>
                    <tr>
                        <td>Jatuh Tempo</td>
                        <td>: ' . date('d/m/Y', strtotime($invoice['due_date'])) . '</td>
                    </tr>
                </table>
            </div>
        </div>

        <h6 class="mb-3">Item Penawaran</h6>
        <div class="table-responsive mb-4">
            <table class="table table-bordered">
                <thead>
                    <tr>
                        <th>Nama Item</th>
                        <th>Deskripsi</th>
                        <th class="text-center">Jumlah</th>
                        <th class="text-end">Harga Satuan</th>
                        <th class="text-center">Diskon</th>
                        <th class="text-end">Total</th>
                    </tr>
                </thead>
                <tbody>
                    ' . implode('', array_map(function($item) {
                        return '
                        <tr>
                            <td>' . htmlspecialchars($item['name']) . '</td>
                            <td>' . htmlspecialchars($item['description']) . '</td>
                            <td class="text-center">' . $item['quantity'] . '</td>
                            <td class="text-end">Rp ' . number_format($item['unit_price'], 0, ',', '.') . '</td>
                            <td class="text-center">' . $item['discount_percent'] . '%</td>
                            <td class="text-end">Rp ' . number_format($item['quantity'] * $item['unit_price'] * (1 - $item['discount_percent']/100), 0, ',', '.') . '</td>
                        </tr>';
                    }, $items)) . '
                </tbody>
                <tfoot>
                    <tr>
                        <td colspan="5" class="text-end"><strong>Total:</strong></td>
                        <td class="text-end"><strong>Rp ' . number_format($invoice['total_amount'], 0, ',', '.') . '</strong></td>
                    </tr>
                </tfoot>
            </table>
        </div>

        <h6 class="mb-3">Jadwal Pembayaran</h6>
        <div class="table-responsive">
            <table class="table table-bordered datatable">
                <thead>
                    <tr>
                        <th style="width: 40px;">No</th>
                        <th>Deskripsi</th>
                        <th style="width: 100px;" class="text-center">Persentase</th>
                        <th style="width: 150px;" class="text-end">Jumlah</th>
                        <th style="width: 120px;" class="text-center">Jatuh Tempo</th>
                        <th style="width: 120px;" class="text-center">Status</th>
                        <th style="width: 100px;" class="text-center">Aksi</th>
                    </tr>
                </thead>
                <tbody>';

$no = 1;
while ($schedule = mysqli_fetch_assoc($schedules)) {
    $scheduleStatusClass = $schedule['status'] === 'paid' ? 'success' : 'warning';
    
    $content .= '
        <tr>
            <td class="text-center">' . $no++ . '</td>
            <td>' . htmlspecialchars($schedule['description']) . '</td>
            <td class="text-center">' . $schedule['percentage'] . '%</td>
            <td class="text-end">Rp ' . number_format($schedule['amount'], 0, ',', '.') . '</td>
            <td class="text-center">' . date('d/m/Y', strtotime($schedule['due_date'])) . '</td>
            <td class="text-center">
                <span class="badge bg-' . $scheduleStatusClass . '">' . ucfirst($schedule['status']) . '</span>
            </td>
            <td class="text-center">';
    
    if ($schedule['status'] === 'pending') {
        $content .= '
            <button type="button" class="btn btn-sm btn-primary" onclick="updatePayment(' . $schedule['id'] . ')" title="Update Pembayaran">
                <i class="fas fa-money-bill"></i>
            </button>';
    } else {
        /*
        $content .= '
            <button type="button" class="btn btn-sm btn-info" onclick="viewPayment(' . $schedule['id'] . ')" title="Lihat Detail">
                <i class="fas fa-eye"></i>
            </button>';
            */
    }
    
    $content .= '
            </td>
        </tr>';
}

$content .= '
                </tbody>
            </table>
        </div>
    </div>
</div>

<!-- Update Payment Modal -->
<div class="modal fade" id="updatePaymentModal" tabindex="-1">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Update Pembayaran</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <form method="POST" action="" enctype="multipart/form-data">
                <input type="hidden" name="schedule_id" id="schedule_id">
                <div class="modal-body">
                    <div class="mb-3">
                        <label class="form-label">Status Pembayaran</label>
                        <select class="form-select" name="status" required>
                            <option value="pending">Pending</option>
                            <option value="paid">Paid</option>
                        </select>
                    </div>
                    
                    <div class="mb-3">
                        <label class="form-label">Tanggal Pembayaran</label>
                        <input type="date" class="form-control" name="payment_date" required>
                    </div>
                    
                    <div class="mb-3">
                        <label class="form-label">Bukti Pembayaran</label>
                        <input type="file" class="form-control" name="payment_proof" accept="image/*,.pdf">
                    </div>
                    
                    <div class="mb-3">
                        <label class="form-label">Catatan</label>
                        <textarea class="form-control" name="notes" rows="3"></textarea>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Batal</button>
                    <button type="submit" class="btn btn-primary">Simpan</button>
                </div>
            </form>
        </div>
    </div>
</div>

<!-- View Payment Modal -->
<div class="modal fade" id="viewPaymentModal" tabindex="-1">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Detail Pembayaran</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <div class="modal-body" id="paymentDetails">
                Loading...
            </div>
        </div>
    </div>
</div>

<script>
function downloadPDF() {
    window.location.href = `generate_invoice_pdf.php?id=' . $invoice_id . '`;
}

function sendEmail() {
    if(confirm("Kirim invoice ini melalui email?")) {
        window.location.href = `send_invoice_email.php?id=' . $invoice_id . '`;
    }
}

function sendWhatsApp() {
    if(confirm("Kirim invoice ini melalui WhatsApp?")) {
        window.location.href = `send_invoice_whatsapp.php?id=' . $invoice_id . '`;
    }
}



function viewPayment(scheduleId) {
    const modal = new bootstrap.Modal(document.getElementById("viewPaymentModal"));
    
    // Load payment details
    fetch(`get_payment_details.php?schedule_id=${scheduleId}`)
        .then(response => response.json())
        .then(data => {
            const details = document.getElementById("paymentDetails");
            details.innerHTML = `
                <table class="table">
                    <tr>
                        <td>Status</td>
                        <td>: ${data.payment.status}</td>
                    </tr>
                    <tr>
                        <td>Tanggal Pembayaran</td>
                        <td>: ${data.payment.payment_date}</td>
                    </tr>
                    <tr>
                        <td>Bukti Pembayaran</td>
                        <td>
                            ${data.payment.proof_url ? 
                                `<a href="${data.payment.proof_url}" target="_blank">Lihat Bukti</a>` : 
                                "Tidak ada bukti"}
                        </td>
                    </tr>
                    <tr>
                        <td>Catatan</td>
                        <td>${data.payment.notes || "-"}</td>
                    </tr>
                </table>
            `;
            modal.show();
        })
        .catch(error => {
            console.error("Error:", error);
            alert("Gagal memuat detail pembayaran");
        });
}
</script>';

// Include template
?>
<!DOCTYPE html>
<html lang="id">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title><?php echo $pageTitle ?? 'Admin Panel'; ?> Travel Umroh</title> 
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
    <link rel="stylesheet" href="../assets/css/admin.css">
</head>
<body>
    <?php include 'includes/header.php'; ?>
    
    <div class="container-fluid">
        <div class="row">
            <?php include 'includes/sidebar.php'; ?>
            
            <main class="col-md-9 ms-sm-auto col-lg-10 px-md-4 py-4">
                <div class="d-flex justify-content-between flex-wrap flex-md-nowrap align-items-center pt-3 pb-2 mb-3 border-bottom">
                    <h1 class="h2"><?php echo $pageTitle; ?></h1>
                </div>

                <?php echo $content; ?>
            </main>
        </div>
    </div>

    <!-- Load Bootstrap first -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
    <script src="../assets/js/admin.js"></script>
   
    <script src="https://cdn.datatables.net/1.11.5/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/1.11.5/js/dataTables.bootstrap5.min.js"></script>
    <!-- Custom script for this page -->
    <script>
        $(document).ready(function() {
            $('.datatable').DataTable();
        });
    function downloadPDF() {
        window.location.href = `generate_invoice_pdf.php?id=<?php echo $invoice_id; ?>`;
    }

    function sendEmail() {
        if(confirm("Kirim invoice ini melalui email?")) {
            window.location.href = `send_invoice_email.php?id=<?php echo $invoice_id; ?>`;
        }
    }

    function sendWhatsApp() {
        if(confirm("Kirim invoice ini melalui WhatsApp?")) {
            window.location.href = `send_invoice_whatsapp.php?id=<?php echo $invoice_id; ?>`;
        }
    }

    function updatePayment(scheduleId) {
        document.getElementById("schedule_id").value = scheduleId;
        // alert(scheduleId);
        new bootstrap.Modal(document.getElementById("updatePaymentModal")).show();
    }

    function viewPayment(scheduleId) {
        const modal = new bootstrap.Modal(document.getElementById("viewPaymentModal"));
        
        // Load payment details
        fetch(`get_payment_details.php?schedule_id=${scheduleId}`)
            .then(response => response.json())
            .then(data => {
                const details = document.getElementById("paymentDetails");
                details.innerHTML = `
                    <table class="table">
                        <tr>
                            <td>Status</td>
                            <td>: ${data.payment.status}</td>
                        </tr>
                        <tr>
                            <td>Tanggal Pembayaran</td>
                            <td>: ${data.payment.payment_date}</td>
                        </tr>
                        <tr>
                            <td>Bukti Pembayaran</td>
                            <td>
                                ${data.payment.proof_url ? 
                                    `<a href="${data.payment.proof_url}" target="_blank">Lihat Bukti</a>` : 
                                    'Tidak ada bukti'}
                            </td>
                        </tr>
                        <tr>
                            <td>Catatan</td>
                            <td>${data.payment.notes || '-'}</td>
                        </tr>
                    </table>
                `;
                modal.show();
            })
            .catch(error => {
                console.error("Error:", error);
                alert("Gagal memuat detail pembayaran");
            });
    }
    </script>
</body>
</html>