Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

Apache/2

System:

Linux 5.15.0-161-generic

PHP Version:

8.1.32

User:

myvacationholi

Directory:

/home/myvacationholi/domains/myvacationholidays.in/private_html

Free Space:

14.04 GB

🔧 Quick Actions

✏️ Editing: packages-detail.php

<?php
include('admin/config.php');

$category_sluged = $_GET['category'] ?? '';

// Fetch current category info
 $stmt = $conn->prepare("SELECT id, category, image, tour_type FROM tour_category WHERE url = ? LIMIT 1");
 $stmt->bind_param("s", $category_sluged);
 $stmt->execute();
 $category_resulted = $stmt->get_result();

if ($category_resulted->num_rows > 0) {
    $category_datad = $category_resulted->fetch_assoc();
    $category_named = $category_datad['category']; 
    $category_id = $category_datad['id']; 
    $category_banner_image = $category_datad['image'];
    $tour_type = $category_datad['tour_type'];
} else {
    $category_named = "Unknown Category";
    $category_id = 0;
    $category_banner_image = '';
    $tour_type = '';
}

// Fix banner image
if (!empty($category_banner_image)) {
    if (strpos($category_banner_image, 'http') !== 0) {
        $base_url = 'https://bluesands.in/myvacation/admin/image-of-tours/galleryimg/';
        $category_banner_image = $base_url . $category_banner_image;
    }
} else {
    $category_banner_image = 'https://bluesands.in/myvacation/admin/image-of-tours/galleryimg/default.jpg';
}

// --- Prices Logic (Dynamic) ---
 $price_sql = "SELECT tour_price FROM tour_package WHERE tour_type = ? AND tour_price REGEXP '^[0-9,]+$'";
 $stmt_price = $conn->prepare($price_sql);
 $stmt_price->bind_param("i", $category_id);
 $stmt_price->execute();
 $price_result = $stmt_price->get_result();

$prices = [];
while ($row = mysqli_fetch_assoc($price_result)) {
    $clean_price = str_replace(',', '', $row['tour_price']);
    if (is_numeric($clean_price)) {
        $prices[] = (float)$clean_price;
    }
}
 $min_price = !empty($prices) ? min($prices) : 0;
 $max_price = !empty($prices) ? max($prices) : 50000;

// --- Durations Logic (Dynamic) ---
 $durations_sql = "SELECT DISTINCT tour_duration, COUNT(*) as count FROM tour_package WHERE tour_type = ? AND tour_duration != '' GROUP BY tour_duration ORDER BY LENGTH(tour_duration), tour_duration";
 $stmt_durations = $conn->prepare($durations_sql);
 $stmt_durations->bind_param("i", $category_id);
 $stmt_durations->execute();
 $durations_result = $stmt_durations->get_result();
 $total_durations = $durations_result->num_rows;

// Get first package image for overlay background
 $first_package_image = '';
 $tour_sql = "SELECT image FROM tour_package WHERE tour_type = ? LIMIT 1";
 $stmt_tour = $conn->prepare($tour_sql);
 $stmt_tour->bind_param("i", $category_id);
 $stmt_tour->execute();
 $tour_result = $stmt_tour->get_result();
if ($tour_result->num_rows > 0) {
    $first_tour = $tour_result->fetch_assoc();
    $first_package_image = $first_tour['image'];
}

// Count total packages
 $count_sql = "SELECT COUNT(*) as total FROM tour_package WHERE tour_type = ?";
 $stmt_count = $conn->prepare($count_sql);
 $stmt_count->bind_param("i", $category_id);
 $stmt_count->execute();
 $count_result = $stmt_count->get_result();
 $total_packages = 0;
if ($count_result->num_rows > 0) {
    $count_data = $count_result->fetch_assoc();
    $total_packages = $count_data['total'];
}

$category_named = htmlspecialchars($category_named, ENT_QUOTES, 'UTF-8');
 $category_banner_image = htmlspecialchars($category_banner_image, ENT_QUOTES, 'UTF-8');
 $first_package_image = htmlspecialchars($first_package_image, ENT_QUOTES, 'UTF-8');
?>

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title><?php echo $category_named; ?> Packages</title>

.india-banner-content{position:relative;z-index:2;color:white;text-align:center;padding-top:120px;}
.breadcrumb-container{color:white;font-size:14px;margin-top:10px;}
.breadcrumb-container a{color:white;text-decoration:none;}
.breadcrumb-container a:hover{text-decoration:underline;}

/* Container Layout */
.packages-container{display:flex;gap:20px;flex-wrap:wrap;}
.packages-filter-sidebar{width:250px;flex-shrink:0; position: sticky; top: 125px; bottom: 0px;}

@media (min-width: 1200px) {
    .packages-container{ max-width:100% !important }
}

/* Filter Box */
.filter-box{border:1px solid #ddd;padding:15px;border-radius:8px;margin-bottom:20px;background:#fff;}
.filter-title{font-weight:600;margin-bottom:10px;}
.filter-group{margin-bottom:15px;}
.price-range{width:100%;}

/* Duration Cards */
.duration-cards{display:flex;flex-wrap:wrap;gap:10px;margin-top:10px;}
.duration-card{cursor:pointer;padding:8px 12px;border:1px solid #ddd;border-radius:6px;font-size:14px;transition:0.3s;background:#fff;}
.duration-card:hover{border-color:#0a98d2;background:#f0f9ff;}
.duration-card input{ margin-right: 5px; }

/* Packages List */
.packages-list{
    flex: 1;
    display: flex;
    flex-direction: column;
    gap: 20px;
}

/* Special styling when there's only one package */
.single-package .package-card {
    max-width: 900px;
    margin: 0 auto;
}

/* Package Card UI - Updated to horizontal layout with three sections */
.package-card{
    display: flex;
    background: #fff;
    border-radius: 8px;
    overflow: hidden;
    box-shadow: 0 4px 8px rgba(0,0,0,0.1);
    transition: transform 0.3s ease, box-shadow 0.3s ease;
}

.package-card:hover {
    transform: translateY(-3px);
    box-shadow: 0 8px 16px rgba(0,0,0,0.15);
}

/* Left Section - Image */
.package-image {
    width: 300px;
    flex-shrink: 0;
   
}

.package-image img {
    width: 100%;
    height: 250px;
    object-fit: cover;
    display: block;
}

/* Center Section - Content */
.package-content {
    flex: 1;
    padding: 20px;
    display: flex;
    flex-direction: column;
}

.package-title {
    font-size: 20px;
    font-weight: 600;
    margin-bottom: 10px;
    color: #333;
}

.package-meta {
    display: flex;
    flex-wrap: wrap;
    gap: 6px;
    
}

.package-location, .package-duration, .package-rating {
    font-size: 14px;
    color: #666;
    display: flex;
    align-items: center;
}

.package-location i, .package-duration i, .package-rating i {
    margin-right: 5px;
    color: #0a98d2;
}

/* Icons Section */
.package-icons {
    display: flex;
    flex-wrap: wrap;
    gap: 15px;
    margin-top: 10px;
}

.icon-item {
    
    gap: 8px;
    font-size: 14px;
    color: #555;
}

.icon-item i {
    background-color: #0a98d2;
    color: white;
    padding: 6px;
    border-radius: 50%;
    font-size: 14px;
    width: 28px;
    height: 28px;
    display: flex;
    align-items: center;
    justify-content: center;
}

/* Right Section - Price and Actions */
.package-actions {
    width: 250px;
    flex-shrink: 0;
    padding: 20px;
    display: flex;
    flex-direction: column;
    justify-content: space-between;
    border-left: 1px solid #eee;
}

.package-price {
    margin-bottom: 10px;
}

.new-price {
    font-size: 24px;
    font-weight: 600;
    color: #0a98d2;
}

.new-price span {
    font-size: 14px;
    font-weight: normal;
    color: #666;
}

.enquiry-btn {
    width: 100%;
    padding: 10px;
    border: none;
    border-radius: 4px;
    color: #fff;
    background: #0a98d2;
    cursor: pointer;
    font-weight: 500;
    margin-bottom: 15px;
    transition: background 0.3s;
}

.enquiry-btn:hover {
    background: #0978b0;
}

.contact-buttons {
    display: flex;
    gap: 10px;
    
}

.contact-buttons a {
    flex: 1;
}

.contact-buttons button {
    width: 100%;
    padding: 8px 0;
    border: none;
    border-radius: 4px;
    color: #fff;
    cursor: pointer;
    transition: opacity 0.3s;
}

.whatsapp-btn {
    background: #25D366;
}

.call-btn {
    background: #28a745;
}

.details-link {
    display: block;
    text-align: center;
    color: #0a98d2;
    font-weight: 500;
    text-decoration: none;
    padding: 8px 0;
    border: 1px solid #0a98d2;
    border-radius: 4px;
    transition: all 0.3s;
}

.details-link:hover {
    background-color: #0a98d2;
    color: white;
}

.no-packages {
    text-align: center;
    padding: 20px;
    color: #666;
    font-size: 16px;
}

/* --- NEW STYLES --- */
/* 1. Active Filters Section */
.active-filters-section {
    background-color:#f2f2f2;
    padding: 15px 0;
    border-bottom: 1px solid #ddd;
    margin-bottom: 20px;
}
.active-filters-content {
    display: flex;
    justify-content: space-between;
    align-items: center;
    flex-wrap: wrap;
    gap: 10px;
}
.active-tags {
    display: flex;
    flex-wrap: wrap;
    gap: 10px;
}
.filter-tag {
    background-color: #e6f7ff;
    border: 1px solid #0a98d2;
    color: #0a98d2;
    padding: 5px 12px;
    border-radius: 20px;
    font-size: 14px;
    display: flex;
    align-items: center;
    gap: 8px;
}
.filter-tag span {
    cursor: pointer;
    font-weight: bold;
    font-size: 16px;
    line-height: 1;
}
.clear-filters-btn {
    color: #ff4d4f;
    background: none;
    border: 1px solid #ff4d4f;
    padding: 6px 15px;
    border-radius: 4px;
    cursor: pointer;
    font-size: 14px;
    transition: 0.3s;
}
.clear-filters-btn:hover {
    background: #ff4d4f;
    color: #fff;
}

/* Class to hide the button */
.btn-hidden {
    display: none !important;
}

/* 2. See More Logic */
.hidden-duration {
    display: none !important;
}
.see-more-container {
    margin-top: 10px;
    text-align: center;
}
.see-more-btn {
    background: none;
    border: none;
    color: #0a98d2;
    font-size: 12px;
    cursor: pointer;
    text-decoration: underline;
    padding: 5px;
}

/* Responsive adjustments */
@media(max-width:991px){
    .packages-container{ flex-direction:column; }
    .packages-filter-sidebar{ width:100%; position:static; }
    
    .package-card {
        flex-direction: column;
    }
    
    .package-image {
        width: 100%;
        height: 200px;
    }
    
    .package-actions {
        width: 100%;
        border-left: none;
        border-top: 1px solid #eee;
    }
    
    /* Override single package width on mobile */
    .single-package .package-card {
        width: 100%;
    }
}
</style>
</head>
<body>
<?php include "header2.php"; ?>

<section class="india-banner-section" style="background-image:url('<?php echo $category_banner_image; ?>');">
  <div class="india-banner-overlay"></div>
  <div class="india-banner-content">
    <h1><?php echo $category_named; ?> Packages</h1>
    <div class="breadcrumb-container">
      <p><a href="index.php">Home</a> / <a href="tour-grid.php">Packages</a> / <?php echo $category_named; ?></p>
    </div>
  </div>
</section>

<div class="active-filters-section">
    <div class="container">
        <div class="active-filters-content">
            <div id="activeFilterTags" class="active-tags">
                
            </div>
            
            <button class="clear-filters-btn btn-hidden" onclick="clearAllFilters()">Clear All</button>
        </div>
    </div>
</div>

<div class="container packages-container">
    
    
    <aside class="packages-filter-sidebar">
      <div class="filter-box">
        <h5 class="filter-title">Filter By</h5>

<div class="filter-group">
          <h6>Price</h6>
          <input type="range" class="price-range" id="priceRange" 
                 min="<?php echo $min_price; ?>" 
                 max="<?php echo $max_price; ?>" 
                 value="<?php echo $max_price; ?>"
                 oninput="updatePriceDisplay(this.value)">
          <div class="price-display" id="priceDisplay">Up to ₹<?php echo $max_price; ?></div>
        </div>

<hr>

<div class="filter-group">
          <h6>Duration</h6>
          <div class="duration-cards" id="durationsList">
            <?php
            $dur_count = 0;
            $stmt_durations->data_seek(0); 
            
            if ($total_durations > 0) {
                while($duration = $durations_result->fetch_assoc()) {
                    $duration_name = htmlspecialchars($duration['tour_duration']);
                    
                    $extra_class = ($dur_count >= 5) ? 'hidden-duration' : '';
                    
                    echo '<label class="duration-card '.$extra_class.'">';
                    echo '<input type="radio" name="duration" value="' . $duration_name . '" onchange="filterPackages()"> ';
                    echo $duration_name;
                    echo '</label>';
                    
                    $dur_count++;
                }
            }
            ?>
          </div>
          
          <?php if ($total_durations > 5): ?>
          <div class="see-more-container" id="seeMoreContainer">
             <button class="see-more-btn" id="seeMoreBtn" onclick="toggleDurationView()">See More</button>
          </div>
          <?php endif; ?>
          
        </div>
      </div>
    </aside>

<div class="packages-list <?php echo ($total_packages == 1) ? 'single-package' : ''; ?>" id="packagesList">
      <?php
      $tour_sql = "SELECT * FROM tour_package WHERE tour_type = ?";
      $stmt_tour = $conn->prepare($tour_sql);
      $stmt_tour->bind_param("i", $category_id);
      $stmt_tour->execute();
      $tour_result = $stmt_tour->get_result();

if ($tour_result->num_rows > 0) {
          while ($tour = $tour_result->fetch_assoc()) {
              $image = !empty($tour['image']) ? $tour['image'] : 'default.jpg';
      ?>
      <div class="package-card" 
           data-price="<?php 
               $clean_price = str_replace(',', '', $tour['tour_price']);
               echo is_numeric($clean_price) ? htmlspecialchars($clean_price) : '999999';
           ?>"
           data-duration="<?php echo htmlspecialchars($tour['tour_duration']); ?>">
        
        <div class="package-image">
            <img src="admin/image-of-tours/galleryimg/<?php echo htmlspecialchars($image); ?>" alt="<?php echo htmlspecialchars($tour['package_name']); ?>">
        </div>
        
        
        <div class="package-content">
            <h4 class="package-title"><?php echo htmlspecialchars($tour['package_name']); ?></h4>
            
            <div class="package-meta">
                <div class="package-location" style="position:relative;top:7px;">
                    <i class="fas fa-map-marker-alt"></i> 
                    <?php echo htmlspecialchars($tour['tour_destination']); ?>
                </div>
                <div class="package-duration">
                    <i class="fas fa-clock"></i> 
                    <?php echo htmlspecialchars($tour['tour_duration']); ?>
                </div>
                <div class="package-rating">
                    <i class="fas fa-star"></i> 
                    4.5 (<?php echo rand(10, 50); ?> reviews)
                </div>
            </div>
            
            
            <div class="package-icons">
                <div class="icon-item">
                    <i class="fas fa-hotel"></i>
                    <span>Hotel</span>
                </div>
                <div class="icon-item">
                    <i class="fas fa-utensils"></i>
                    <span>Meals</span>
                </div>
                <div class="icon-item">
                    <i class="fas fa-binoculars"></i>
                    <span>Sights</span>
                </div>
                <div class="icon-item">
                    <i class="fas fa-van-shuttle"></i>
                    <span>Transfer</span>
                </div>
            </div>
        </div>
        
        
        <div class="package-actions">
            <div class="package-price">
                <div class="new-price">₹<?php echo htmlspecialchars($tour['tour_price']); ?> <span>/ Per Person</span></div>
            </div>
            
            <div>
                <a href="contact-us.php">
                    <button class="enquiry-btn">Enquiry Now</button>
                </a>
                
                <div class="contact-buttons">
                    <a href="https://wa.me/919650216055" target="_blank">
                        <button class="whatsapp-btn"><i class="fab fa-whatsapp"></i></button>
                    </a>
                    <a href="tel:9650216055">
                        <button class="call-btn"><i class="fas fa-phone"></i></button>
                    </a>
                </div>
                
                <a href="tour-detail.php?id=<?php echo $tour['url']; ?>" class="details-link">View Details →</a>
            </div>
        </div>
      </div>
      <?php
          }
      } else {
          echo '<div class="no-packages">No tours available for this category.</div>';
      }
      ?>
    </div>
</div>

<?php include "footer.php"; ?>

// --- FILTER LOGIC ---
function updatePriceDisplay(value) {
    document.getElementById('priceDisplay').textContent = 'Up to ₹' + value;
    currentPriceFilter = value;
    filterPackages();
}

function filterPackages() {
    const durationRadio = document.querySelector('input[name="duration"]:checked');
    const selectedDuration = durationRadio ? durationRadio.value : '';
    const priceFilter = currentPriceFilter;

const packages = document.querySelectorAll('.package-card');
    packages.forEach(pkg => {
        const price = parseFloat(pkg.getAttribute('data-price')) || 0;
        const duration = pkg.getAttribute('data-duration');
        let showPackage = true;

if(price !== 999999 && price > priceFilter) showPackage = false;
        if(selectedDuration && duration !== selectedDuration) showPackage = false;

pkg.style.display = showPackage ? 'flex' : 'none';
    });

updateActiveTags();
    
    // Check if only one package is visible after filtering
    const visiblePackages = Array.from(packages).filter(pkg => pkg.style.display !== 'none');
    const packagesList = document.getElementById('packagesList');
    
    if (visiblePackages.length === 1) {
        packagesList.classList.add('single-package');
    } else {
        packagesList.classList.remove('single-package');
    }
}

// --- ACTIVE FILTERS TAGS LOGIC ---
function updateActiveTags() {
    const container = document.getElementById('activeFilterTags');
    const clearBtn = document.querySelector('.clear-filters-btn');
    const section = document.querySelector('.active-filters-section');
    
    container.innerHTML = ''; // Clear existing tags

// Price Tag
    if (currentPriceFilter < maxPriceLimit) {
        const tag = document.createElement('div');
        tag.className = 'filter-tag';
        tag.innerHTML = `Price: Up to ₹${currentPriceFilter} <span onclick="removePriceFilter()">×</span>`;
        container.appendChild(tag);
    }

// Duration Tag
    const durationRadio = document.querySelector('input[name="duration"]:checked');
    if (durationRadio) {
        const tag = document.createElement('div');
        tag.className = 'filter-tag';
        tag.innerHTML = `${durationRadio.value} <span onclick="removeDurationFilter()">×</span>`;
        container.appendChild(tag);
    }

// Show/Hide Clear All Button based on active tags
    if (container.children.length > 0) {
        clearBtn.classList.remove('btn-hidden');
    } else {
        clearBtn.classList.add('btn-hidden');
    }
}

function removePriceFilter() {
    const slider = document.getElementById('priceRange');
    slider.value = maxPriceLimit;
    currentPriceFilter = maxPriceLimit;
    document.getElementById('priceDisplay').textContent = 'Up to ₹' + maxPriceLimit;
    filterPackages();
}

function removeDurationFilter() {
    const radio = document.querySelector('input[name="duration"]:checked');
    if(radio) radio.checked = false;
    filterPackages();
}

function clearAllFilters() {
    removePriceFilter();
    removeDurationFilter();
}

// --- SEE MORE LOGIC ---
function toggleDurationView() {
    const hiddenItems = document.querySelectorAll('.duration-card.hidden-duration');
    const btn = document.getElementById('seeMoreBtn');
    
    if (hiddenItems.length > 0) {
        hiddenItems.forEach(item => item.classList.remove('hidden-duration'));
        btn.textContent = 'See Less';
    } else {
        const allItems = document.querySelectorAll('.duration-card');
        allItems.forEach((item, index) => {
            if (index >= 5) item.classList.add('hidden-duration');
        });
        btn.textContent = 'See More';
    }
}
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: packages-detail.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation