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';
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
// Require admin authentication
requireAdmin();

// Set page title
$pageTitle = 'Kelola Paket';

// Add Package button for header
$headerButtons = '
<div class="btn-toolbar mb-2 mb-md-0">
    <button type="button" class="btn btn-warning me-2" onclick="fixDescriptions()">
        <i class="fas fa-magic me-2"></i>Perbaiki Deskripsi
    </button>
    <button type="button" class="btn btn-gold" data-bs-toggle="modal" data-bs-target="#addPackageModal">
        <i class="fas fa-plus me-2"></i>Tambah Paket
    </button>
</div>';

// Handle form submissions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['action'])) {
        switch ($_POST['action']) {
            case 'add':
                // Handle add package
                $name = sanitize($_POST['name']);
                // Do not apply SQL escaping here because we use prepared statements.
                // Use raw trimmed description so newline characters are preserved.
                $description = trim($_POST['description']);
                $price = floatval($_POST['price']);
                $duration = intval($_POST['duration']);
                $departure_date = sanitize($_POST['departure_date']);
                $category = sanitize($_POST['category']);
                $status = sanitize($_POST['status']);
                $hotel_rating = sanitize($_POST['hotel_rating']);
                $features = sanitize($_POST['features']);
                $departure_city = sanitize($_POST['departure_city']);
                $total_seats = intval($_POST['total_seats']);
                $booked_seats = intval($_POST['booked_seats']);
                $airline = sanitize($_POST['airline']);

                // var_dump($departure_date);
                // die;
                
                // Handle image upload
                $image_url = '';
                if (isset($_FILES['image']) && $_FILES['image']['error'] === UPLOAD_ERR_OK) {
                    $upload_dir = '../uploads/packages/';
                    if (!file_exists($upload_dir)) {
                        mkdir($upload_dir, 0777, true);
                    }
                    
                    $file_extension = strtolower(pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION));
                    $allowed_extensions = array('jpg', 'jpeg', 'png', 'gif');
                    
                    if (in_array($file_extension, $allowed_extensions)) {
                        $new_filename = uniqid('package_') . '.' . $file_extension;
                        $upload_path = $upload_dir . $new_filename;
                        
                        if (move_uploaded_file($_FILES['image']['tmp_name'], $upload_path)) {
                            $image_url = 'uploads/packages/' . $new_filename;
                        } else {
                            $error = "Failed to upload image";
                        }
                    } else {
                        $error = "Invalid file type. Allowed types: jpg, jpeg, png, gif";
                    }
                }
                
                if (!isset($error)) {
                    $sql = "INSERT INTO packages (name, description, image_url, price, departure_date, duration, category, status, hotel_rating, features, departure_city, total_seats, booked_seats, airline, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())";
                    $stmt = mysqli_prepare($conn, $sql);
                    // Correct bind types: name(s), description(s), image_url(s), price(d), departure_date(s), duration(i),
                    // category(s), status(s), hotel_rating(i), features(s), departure_city(s), total_seats(i), booked_seats(i), airline(s)
                    mysqli_stmt_bind_param($stmt, "sssdsississiis", $name, $description, $image_url, $price, $departure_date, $duration, $category, $status, $hotel_rating, $features, $departure_city, $total_seats, $booked_seats, $airline);
                    
                    if (mysqli_stmt_execute($stmt)) {
                        $package_id = mysqli_insert_id($conn);
                        
                        // Insert hotel associations
                        if (isset($_POST['hotels']) && isset($_POST['nights'])) {
                            $hotels = $_POST['hotels'];
                            $nights = $_POST['nights'];
                            
                            for ($i = 0; $i < count($hotels); $i++) {
                                if (!empty($hotels[$i]) && !empty($nights[$i])) {
                                    $sql = "INSERT INTO package_hotels (package_id, hotel_id, nights) VALUES (?, ?, ?)";
                                    $stmt = mysqli_prepare($conn, $sql);
                                    mysqli_stmt_bind_param($stmt, "iii", $package_id, $hotels[$i], $nights[$i]);
                                    mysqli_stmt_execute($stmt);
                                }
                            }
                        }
                        
                        logEvent('packages', "New package added: $name", 'info');
                        $success = "Paket berhasil ditambahkan";
                    } else {
                        $error = "Gagal menambahkan paket: " . mysqli_error($conn);
                    }
                }
                break;
                
            case 'edit':
                // Handle edit package
                $id = intval($_POST['id']);
                $name = sanitize($_POST['name']);
                // Preserve newlines for description; avoid mysqli_real_escape_string to prevent literal backslashes being stored.
                $description = trim($_POST['description']);
                $price = floatval($_POST['price']);
                $departure_date = sanitize($_POST['departure_date']);
                $duration = intval($_POST['duration']);
                $category = sanitize($_POST['category']);
                $status = sanitize($_POST['status']);
                $hotel_rating = sanitize($_POST['hotel_rating']);
                $features = sanitize($_POST['features']);
                $departure_city = sanitize($_POST['departure_city']);
                $total_seats = intval($_POST['total_seats']);
                $booked_seats = intval($_POST['booked_seats']);
                $airline = sanitize($_POST['airline']);
                // var_dump($_POST);
                // die();
                // Get current image_url
                $stmt = mysqli_prepare($conn, "SELECT image_url FROM packages WHERE id = ?");
                mysqli_stmt_bind_param($stmt, "i", $id);
                mysqli_stmt_execute($stmt);
                $result = mysqli_stmt_get_result($stmt);
                $current_package = mysqli_fetch_assoc($result);
                $image_url = $current_package['image_url'];
                
                // Handle image upload
                if (isset($_FILES['image']) && $_FILES['image']['error'] === UPLOAD_ERR_OK) {
                    $upload_dir = '../uploads/packages/';
                    if (!file_exists($upload_dir)) {
                        mkdir($upload_dir, 0777, true);
                    }
                    
                    $file_extension = strtolower(pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION));
                    $allowed_extensions = array('jpg', 'jpeg', 'png', 'gif');
                    
                    if (in_array($file_extension, $allowed_extensions)) {
                        // Delete old image if exists
                        if ($image_url && file_exists("../$image_url")) {
                            unlink("../$image_url");
                        }
                        
                        $new_filename = uniqid('package_') . '.' . $file_extension;
                        $upload_path = $upload_dir . $new_filename;
                        
                        if (move_uploaded_file($_FILES['image']['tmp_name'], $upload_path)) {
                            $image_url = 'uploads/packages/' . $new_filename;
                        } else {
                            $error = "Failed to upload image";
                        }
                    } else {
                        $error = "Invalid file type. Allowed types: jpg, jpeg, png, gif";
                    }
                }
                
                if (!isset($error)) {
                    $sql = "UPDATE packages SET name = ?, description = ?, image_url = ?, price = ?, departure_date = ?, duration = ?, category = ?, status = ?, hotel_rating = ?, features = ?, departure_city = ?, total_seats = ?, booked_seats = ?, airline = ? WHERE id = ?";
                    $stmt = mysqli_prepare($conn, $sql);
                    // Correct bind types for update: name(s), description(s), image_url(s), price(d), departure_date(s), duration(i),
                    // category(s), status(s), hotel_rating(i), features(s), departure_city(s), total_seats(i), booked_seats(i), airline(s), id(i)
                    mysqli_stmt_bind_param($stmt, "sssdsississiisi", $name, $description, $image_url, $price, $departure_date, $duration, $category, $status, $hotel_rating, $features, $departure_city, $total_seats, $booked_seats, $airline, $id);
                    
                    if (mysqli_stmt_execute($stmt)) {
                        // Update hotel associations
                        // First, remove existing associations
                        mysqli_query($conn, "DELETE FROM package_hotels WHERE package_id = " . intval($id));
                        
                        // Then add new ones
                        if (isset($_POST['hotels']) && isset($_POST['nights'])) {
                            $hotels = $_POST['hotels'];
                            $nights = $_POST['nights'];
                            
                            for ($i = 0; $i < count($hotels); $i++) {
                                if (!empty($hotels[$i]) && !empty($nights[$i])) {
                                    $sql = "INSERT INTO package_hotels (package_id, hotel_id, nights) VALUES (?, ?, ?)";
                                    $stmt = mysqli_prepare($conn, $sql);
                                    mysqli_stmt_bind_param($stmt, "iii", $id, $hotels[$i], $nights[$i]);
                                    mysqli_stmt_execute($stmt);
                                }
                            }
                        }
                        
                        logEvent('packages', "Package updated: $name", 'info');
                        $success = "Paket berhasil diperbarui";
                    } else {
                        $error = "Gagal memperbarui paket: " . mysqli_error($conn);
                    }
                }
                break;
                
            case 'delete':
                // Handle delete package
                $id = intval($_POST['id']);
                
                $sql = "DELETE FROM packages WHERE id = ?";
                $stmt = mysqli_prepare($conn, $sql);
                mysqli_stmt_bind_param($stmt, "i", $id);
                
                if (mysqli_stmt_execute($stmt)) {
                    logEvent('packages', "Package deleted: ID $id", 'warning');
                    $success = "Paket berhasil dihapus";
                } else {
                    $error = "Gagal menghapus paket: " . mysqli_error($conn);
                }
                break;
        }
    }
}

// Get all packages
$packages = mysqli_query($conn, "SELECT * FROM packages ORDER BY created_at DESC");

// Get all hotels for the forms
$hotels_query = mysqli_query($conn, "SELECT * FROM hotels ORDER BY location, name");
$hotels = [];
while ($hotel = mysqli_fetch_assoc($hotels_query)) {
    $hotels[] = $hotel;
}

// Get all airlines for the forms
$airlines_query = mysqli_query($conn, "SELECT * FROM airlines ORDER BY name");
$airlines = [];
while ($airline_row = mysqli_fetch_assoc($airlines_query)) {
    $airlines[] = $airline_row;
}

// Prepare content
$content = '
<!-- Alerts -->
' . (isset($success) ? '<div class="alert alert-success alert-dismissible fade show" role="alert">
    ' . $success . '
    <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
</div>' : '') . '
' . (isset($error) ? '<div class="alert alert-danger alert-dismissible fade show" role="alert">
    ' . $error . '
    <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
</div>' : '') . '

<!-- Packages List -->
<div class="card content-card">
    <div class="card-header d-flex justify-content-between align-items-center">
        <h5 class="card-title mb-0">Daftar Paket</h5>
        <div class="card-tools">
           
        </div>
    </div>
    <div class="card-body">
        <div class="table-responsive">
            <table class="table datatable table-hover">
                <thead>
                    <tr>
                        <th>Gambar</th>
                        <th>Nama Paket</th>
                        <th>Kategori</th>
                        <th>Tanggal Keberangkatan</th>
                        <th>Durasi</th>
                        <th>Harga</th>
                        <th>Status</th>
                        <th>Aksi</th>
                    </tr>
                </thead>
                <tbody>';

while ($package = mysqli_fetch_assoc($packages)) {
    $content .= '
    <tr>
        <td>
            ' . ($package['image_url'] ? '<img src="../' . htmlspecialchars($package['image_url']) . '" alt="' . htmlspecialchars($package['name']) . '" style="width: 50px; height: 50px; object-fit: cover; border-radius: 5px;">' : '<span class="text-muted">No image</span>') . '
        </td>
        <td>' . htmlspecialchars($package['name']) . '</td>
        <td>' . htmlspecialchars($package['category']) . '</td>
        <td>' . $package['departure_date'] . '</td>
        <td>' . $package['duration'] . ' Hari</td>
        <td>Rp ' . number_format($package['price'], 0, ',', '.') . '</td>
        <td><span class="badge ' . ($package['status'] === 'active' ? 'bg-success' : 'bg-danger') . '">' . ucfirst($package['status']) . '</span></td>
        <td>
            <div class="btn-group">
                <button class="btn btn-sm btn-info" onclick="editPackage(' . $package['id'] . ')" title="Edit">
                    <i class="fas fa-edit"></i>
                </button>
                <button class="btn btn-sm btn-danger" onclick="deletePackage(' . $package['id'] . ')" title="Hapus">
                    <i class="fas fa-trash"></i>
                </button>
            </div>
        </td>
    </tr>';
}

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

<!-- Add Package Modal -->
<div class="modal fade" id="addPackageModal" tabindex="-1">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Tambah Paket Baru</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <form method="POST" enctype="multipart/form-data">
                <div class="modal-body">
                    <input type="hidden" name="action" value="add">
                    
                    <div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label class="form-label">Nama Paket</label>
                                <input type="text" class="form-control" name="name" required>
                            </div>
                            
                            <div class="mb-3">
                                <label class="form-label">Deskripsi</label>
                                <textarea class="form-control" name="description" rows="3" required></textarea>
                            </div>
                            
                            <div class="mb-3">
                                <label class="form-label">Gambar Paket</label>
                                <input type="file" class="form-control" name="image" accept="image/*" required>
                                <small class="text-muted">Format yang diizinkan: JPG, JPEG, PNG, GIF</small>
                            </div>
                            
                            <div class="row">
                                <div class="col-md-6 mb-3">
                                    <label class="form-label">Harga</label>
                                    <div class="input-group">
                                        <span class="input-group-text">Rp</span>
                                        <input type="number" class="form-control" name="price" required>
                                    </div>
                                </div>
                                
                                <div class="col-md-6 mb-3">
                                    <label class="form-label">Durasi (Hari)</label>
                                    <input type="number" class="form-control" name="duration" required>
                                </div>
                                <div class="col-md-6 mb-3">
                                    <label class="form-label">Tanggal Keberangkatan</label>
                                    <input type="date" class="form-control" name="departure_date" required>
                                </div>
                            </div>
                        </div>
                        
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label class="form-label">Kategori</label>
                                <select class="form-select" name="category" required>
                                    <option value="umrah">Umrah Reguler</option>
                                    <option value="umrah_plus">Umrah Plus</option>
                                    <option value="hajj">Haji</option>
                                    <option value="halal_tour">Wisata Halal</option>
                                </select>
                            </div>
                            
                            <div class="mb-3">
                                <label class="form-label">Status</label>
                                <select class="form-select" name="status" required>
                                    <option value="active">Active</option>
                                    <option value="inactive">Inactive</option>
                                </select>
                            </div>
                            
                            <div class="mb-3">
                                <label class="form-label">Hotel Rating</label>
                                <select class="form-select" name="hotel_rating" required>
                                    <option value="3">3 Stars</option>
                                    <option value="4">4 Stars</option>
                                    <option value="5">5 Stars</option>
                                </select>
                            </div>
                            
                            <div class="mb-3">
                                <label class="form-label">Features</label>
                                <textarea class="form-control" name="features" rows="2" placeholder="Comma-separated list of features"></textarea>
                                <small class="text-muted">Pisahkan dengan koma, contoh: WiFi, Breakfast, Transport</small>
                            </div>
                            
                            <div class="mb-3">
                                <label class="form-label">Kota Keberangkatan</label>
                                <input type="text" class="form-control" name="departure_city" required>
                            </div>
                            
                            <div class="row">
                                <div class="col-md-6 mb-3">
                                    <label class="form-label">Total Seats</label>
                                    <input type="number" class="form-control" name="total_seats" required>
                                </div>
                                
                                <div class="col-md-6 mb-3">
                                    <label class="form-label">Booked Seats</label>
                                    <input type="number" class="form-control" name="booked_seats" value="0" required>
                                </div>
                            </div>
                            
                            <div class="mb-3">
                                <label class="form-label">Maskapai</label>
                                <select class="form-select" name="airline" required>
                                    <option value="">-- Pilih Maskapai --</option>';
                                    foreach ($airlines as $airline) {
                                        $content .= '<option value="' . $airline['id'] . '">' . htmlspecialchars($airline['name']) . '</option>';
                                    }
$content .= '                                </select>
                            </div>
                        </div>
                    </div>
                    
                    <div class="mb-3">
                        <label class="form-label">Hotels</label>
                        <div id="hotelContainer">
                            <div class="hotel-entry mb-2">
                                <div class="row">
                                    <div class="col-md-8">
                                        <select class="form-select hotel-select" name="hotels[]" required>
                                            <option value="">Select Hotel</option>';
                                            foreach ($hotels as $hotel) {
                                                $content .= '<option value="' . $hotel['id'] . '">' . htmlspecialchars($hotel['name']) . ' (' . htmlspecialchars($hotel['location']) . ' - ' . $hotel['rating'] . ' Star)</option>';
                                            }
$content .= '
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <input type="number" class="form-control" name="nights[]" placeholder="Nights" required min="1">
                                    </div>
                                    <div class="col-md-1">
                                        <button type="button" class="btn btn-danger btn-sm remove-hotel" onclick="removeHotel(this)"><i class="fas fa-times"></i></button>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <button type="button" class="btn btn-sm btn-secondary mt-2" onclick="addHotel()">Add Another Hotel</button>
                    </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>

<!-- Edit Package Modal -->
<div class="modal fade" id="editPackageModal" tabindex="-1">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Edit Paket</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <form method="POST" enctype="multipart/form-data">
                <div class="modal-body">
                    <input type="hidden" name="action" value="edit">
                    <input type="hidden" name="id" id="editPackageId">
                    
                    <div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label class="form-label">Nama Paket</label>
                                <input type="text" class="form-control" name="name" id="editPackageName" required>
                            </div>
                            
                            <div class="mb-3">
                                <label class="form-label">Deskripsi</label>
                                <textarea class="form-control" name="description" id="editPackageDescription" rows="3" required></textarea>
                            </div>
                            
                            <div class="mb-3">
                                <label class="form-label">Gambar Paket</label>
                                <div id="currentImage" class="mb-2"></div>
                                <input type="file" class="form-control" name="image" accept="image/*">
                                <small class="text-muted">Format yang diizinkan: JPG, JPEG, PNG, GIF. Biarkan kosong jika tidak ingin mengubah gambar.</small>
                            </div>
                            
                            <div class="row">
                                <div class="col-md-6 mb-3">
                                    <label class="form-label">Harga</label>
                                    <div class="input-group">
                                        <span class="input-group-text">Rp</span>
                                        <input type="number" class="form-control" name="price" id="editPackagePrice" required>
                                    </div>
                                </div>
                                
                                <div class="col-md-6 mb-3">
                                    <label class="form-label">Durasi (Hari)</label>
                                    <input type="number" class="form-control" name="duration" id="editPackageDuration" required>
                                </div>
                                <div class="col-md-6 mb-3">
                                    <label class="form-label">Tanggal Keberangkatan</label>
                                    <input type="date" class="form-control" name="departure_date" id="editPackageDepartureDate" required>
                                </div>
                            </div>
                        </div>
                        
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label class="form-label">Kategori</label>
                                <select class="form-select" name="category" id="editPackageCategory" required>
                                    <option value="umrah">Umrah Reguler</option>
                                    <option value="umrah_plus">Umrah Plus</option>
                                    <option value="hajj">Haji</option>
                                    <option value="halal_tour">Wisata Halal</option>
                                </select>
                            </div>
                            
                            <div class="mb-3">
                                <label class="form-label">Status</label>
                                <select class="form-select" name="status" id="editPackageStatus" required>
                                    <option value="active">Active</option>
                                    <option value="inactive">Inactive</option>
                                </select>
                            </div>
                            
                            <div class="mb-3">
                                <label class="form-label">Hotel Rating</label>
                                <select class="form-select" name="hotel_rating" id="editPackageHotelRating" required>
                                    <option value="3">3 Stars</option>
                                    <option value="4">4 Stars</option>
                                    <option value="5">5 Stars</option>
                                </select>
                            </div>
                            
                            <div class="mb-3">
                                <label class="form-label">Features</label>
                                <textarea class="form-control" name="features" id="editPackageFeatures" rows="2" placeholder="Comma-separated list of features"></textarea>
                                <small class="text-muted">Pisahkan dengan koma, contoh: WiFi, Breakfast, Transport</small>
                            </div>
                            
                            <div class="mb-3">
                                <label class="form-label">Kota Keberangkatan</label>
                                <input type="text" class="form-control" name="departure_city" id="editPackageDepartureCity" required>
                            </div>
                            
                            <div class="row">
                                <div class="col-md-6 mb-3">
                                    <label class="form-label">Total Seats</label>
                                    <input type="number" class="form-control" name="total_seats" id="editPackageTotalSeats" required>
                                </div>
                                
                                <div class="col-md-6 mb-3">
                                    <label class="form-label">Booked Seats</label>
                                    <input type="number" class="form-control" name="booked_seats" id="editPackageBookedSeats" required>
                                </div>
                            </div>
                            
                            <div class="mb-3">
                                <label class="form-label">Maskapai</label>
                                <select class="form-select" name="airline" id="editPackageAirline" required>
                                    <option value="">-- Pilih Maskapai --</option>';
                                    foreach ($airlines as $airline) {
                                        $content .= '<option value="' . $airline['id'] . '">' . htmlspecialchars($airline['name']) . '</option>';
                                    }
$content .= '                                </select>
                            </div>
                        </div>
                    </div>
                    
                    <div class="mb-3">
                        <label class="form-label">Hotels</label>
                        <div id="editHotelContainer">
                            <!-- Hotel entries will be added here dynamically -->
                        </div>
                        <button type="button" class="btn btn-sm btn-secondary mt-2" onclick="addHotelToEdit()">Add Another Hotel</button>
                    </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 Perubahan</button>
                </div>
            </form>
        </div>
    </div>
</div>

<!-- Package search functionality -->
<script>
function fixDescriptions() {
    if (confirm("Apakah Anda yakin ingin memperbaiki format deskripsi untuk semua paket?")) {
        var btn = document.querySelector("button[onclick=\'fixDescriptions()\']");
        var originalText = btn.innerHTML;
        btn.innerHTML = "&lt;span class=\"spinner-border spinner-border-sm me-2\"&gt;&lt;/span&gt;Memperbaiki...";
        btn.disabled = true;
        
        fetch("fix_descriptions.php")
            .then(function(response) { return response.json(); })
            .then(function(data) {
                if (data.success) {
                    alert("Berhasil memperbaiki " + data.fixed + " deskripsi paket. Silakan refresh halaman.");
                    location.reload();
                } else {
                    alert("Terjadi kesalahan saat memperbaiki deskripsi:\n" + data.errors.join("\n"));
                }
            })
            .catch(function(error) {
                console.error("Error:", error);
                alert("Terjadi kesalahan saat menghubungi server. Silakan coba lagi.");
            })
            .finally(function() {
                btn.innerHTML = originalText;
                btn.disabled = false;
            });
    }
}

function editPackage(id) {
    // Fetch package data
    fetch("get_package.php?id=" + id)
        .then(response => response.json())
        .then(package => {
            // Populate form fields
            document.getElementById("editPackageId").value = package.id;
            document.getElementById("editPackageName").value = package.name;
            document.getElementById("editPackageDescription").value = package.description;
            document.getElementById("editPackagePrice").value = package.price;
            document.getElementById("editPackageDepartureDate").value = package.departure_date;
            document.getElementById("editPackageDuration").value = package.duration;
            document.getElementById("editPackageCategory").value = package.category;
            document.getElementById("editPackageStatus").value = package.status;
            document.getElementById("editPackageHotelRating").value = package.hotel_rating;
            document.getElementById("editPackageFeatures").value = package.features;
            document.getElementById("editPackageDepartureCity").value = package.departure_city;
            document.getElementById("editPackageTotalSeats").value = package.total_seats;
            document.getElementById("editPackageBookedSeats").value = package.booked_seats;
            document.getElementById("editPackageAirline").value = package.airline;
            
            // Show current image if exists
            const currentImage = document.getElementById("currentImage");
            if (package.image_url) {
                currentImage.innerHTML = `
                    <img src="../${package.image_url}" alt="Current Image" style="max-width: 200px; max-height: 200px;" class="img-thumbnail">
                    <p class="mt-2">Current Image</p>
                `;
            } else {
                currentImage.innerHTML = "<p>No image currently set</p>";
            }
            
            // Fetch and populate hotels
            fetch("get_package_hotels.php?id=" + id)
                .then(response => response.json())
                .then(hotels => {
                    const container = document.getElementById("editHotelContainer");
                    container.innerHTML = ""; // Clear existing entries
                    
                    if (hotels.length === 0) {
                        addHotelToEdit(); // Add one empty entry if no hotels
                    } else {
                        hotels.forEach(hotel => {
                            addHotelToEdit();
                            const lastEntry = container.lastElementChild;
                            lastEntry.querySelector("select").value = hotel.hotel_id;
                            lastEntry.querySelector("input").value = hotel.nights;
                        });
                    }
                })
                .catch(error => {
                    console.error("Error fetching hotels:", error);
                    addHotelToEdit(); // Add one empty entry on error
                });
            
            // Show modal
            new bootstrap.Modal(document.getElementById("editPackageModal")).show();
        })
        .catch(error => {
            console.error("Error:", error);
            alert("Gagal mengambil data paket. Silakan coba lagi.");
        });
}

function deletePackage(id) {
    if (confirm("Anda yakin ingin menghapus paket ini?")) {
        const form = document.createElement("form");
        form.method = "POST";
        form.innerHTML = `
            <input type="hidden" name="action" value="delete">
            <input type="hidden" name="id" value="${id}">
        `;
        document.body.appendChild(form);
        form.submit();
    }
}

// Package search functionality
document.getElementById("packageSearch").addEventListener("keyup", function() {
    const searchText = this.value.toLowerCase();
    const table = document.querySelector(".table-custom");
    const rows = table.getElementsByTagName("tr");

    for (let i = 1; i < rows.length; i++) {
        const row = rows[i];
        const cells = row.getElementsByTagName("td");
        let found = false;

        for (let j = 0; j < cells.length; j++) {
            const cell = cells[j];
            if (cell.textContent.toLowerCase().indexOf(searchText) > -1) {
                found = true;
                break;
            }
        }

        row.style.display = found ? "" : "none";
    }
});

function addHotel() {
    const container = document.getElementById("hotelContainer");
    const template = container.children[0].cloneNode(true);
    template.querySelector("select").value = "";
    template.querySelector("input").value = "";
    container.appendChild(template);
}

function addHotelToEdit() {
    const container = document.getElementById("editHotelContainer");
    const template = `
        <div class="hotel-entry mb-2">
            <div class="row">
                <div class="col-md-8">
                    <select class="form-select hotel-select" name="hotels[]" required>
                        <option value="">Select Hotel</option>
                        ${Array.from(document.querySelector(".hotel-select").options)
                            .map(opt => opt.outerHTML)
                            .join("")}
                    </select>
                </div>
                <div class="col-md-3">
                    <input type="number" class="form-control" name="nights[]" placeholder="Nights" required min="1">
                </div>
                <div class="col-md-1">
                    <button type="button" class="btn btn-danger btn-sm remove-hotel" onclick="removeHotel(this)">
                        <i class="fas fa-times"></i>
                    </button>
                </div>
            </div>
        </div>
    `;
    container.insertAdjacentHTML("beforeend", template);
}

function removeHotel(button) {
    const container = button.closest(".hotel-entry");
    if (container.parentElement.children.length > 1) {
        container.remove();
    }
}
</script>';

?>
<!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">
    <style>
        .stat-card {
            border: none;
            border-radius: 15px;
            box-shadow: 0 5px 20px rgba(184, 134, 11, 0.1);
            transition: transform 0.3s ease;
        }
        .stat-card:hover {
            transform: translateY(-5px);
        }
        .stat-icon {
            width: 50px;
            height: 50px;
            border-radius: 10px;
            display: flex;
            align-items: center;
            justify-content: center;
            font-size: 1.5rem;
            margin-bottom: 1rem;
            background: linear-gradient(135deg, #b8860b 0%, #ffd700 100%);
            color: white;
        }
        .stat-number {
            font-size: 2rem;
            font-weight: 600;
            color: #1a1f3c;
            margin-bottom: 0.5rem;
        }
        .stat-label {
            color: #6c757d;
            font-size: 0.9rem;
        }
    </style>
</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>
                    <?php echo $headerButtons; ?>
                </div>

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

    <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>
    <script>

    // Initialize DataTable
    $('.datatable').DataTable();
</script>
</body>
</html>