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/public_html

Free Space:

14.06 GB

🔧 Quick Actions

✏️ Editing: fixed-departure.php

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

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

// Use prepared statements to prevent SQL injection
 $stmt = $conn->prepare("SELECT id, category, image 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'];
} else {
    // Handle invalid or missing category
    $category_named = "Fixed Departure Tours";
    $category_id = 0;
    $category_banner_image = '';
}

// Check if we have a banner image
if (!empty($category_banner_image)) {
    // If the image path is relative, make it absolute
    if (strpos($category_banner_image, 'http') !== 0) {
        $base_url = 'https://bluesands.in/myvacation/admin/image-of-tours/galleryimg/'; // Change to your domain
        $category_banner_image = $base_url . $category_banner_image;
    }
} else {
    // Fallback to default image if none exists
    $category_banner_image = 'https://bluesands.in/myvacation/admin/image-of-tours/galleryimg/default-banner.jpg'; // Change to your default image
}

// --- Prices Logic (Dynamic) ---
 $price_sql = "SELECT tour_price FROM tour_package WHERE fixed_departure = 1 AND tour_price REGEXP '^[0-9,]+$'";
 $stmt_price = $conn->prepare($price_sql);
 $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 fixed_departure = 1 AND tour_duration != '' GROUP BY tour_duration ORDER BY LENGTH(tour_duration), tour_duration";
 $stmt_durations = $conn->prepare($durations_sql);
 $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 fixed_departure = 1 LIMIT 1";
 $stmt_tour = $conn->prepare($tour_sql);
 $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 fixed_departure = 1";
 $stmt_count = $conn->prepare($count_sql);
 $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'];
}

// Escape output for security
 $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; ?></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.4.0/css/all.min.css">

.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 Slider - Fixed */
    .price-range-container {
        margin-top: 10px;
    }
    .price-range {
        width: 100%;
        height: 5px;
        border-radius: 5px;
        background: #ddd;
        outline: none;
        -webkit-appearance: none;
        cursor: pointer;
    }
    .price-range::-webkit-slider-thumb {
        -webkit-appearance: none;
        appearance: none;
        width: 20px;
        height: 20px;
        border-radius: 50%;
        background: #0a98d2;
        cursor: pointer;
    }
    .price-range::-moz-range-thumb {
        width: 20px;
        height: 20px;
        border-radius: 50%;
        background: #0a98d2;
        cursor: pointer;
        border: none;
    }
    .price-display {
        margin-top: 5px;
        font-size: 14px;
        color: #666;
    }

/* 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 {
        display: flex;
        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; ?></h1>
    <div class="breadcrumb-container">
      <p><a href="index.php">Home</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>

<section class="explore-india-section">
  <div class="container">
    <h2 class="explore-india-title">Explore all fixed departure tour to do in India</h2>
    <p class="explore-india-text">
      Experience the magic of the Himalayas 🏔️ with our Fixed Departure Himachal Tour from Delhi!
Join a well-planned group trip covering Shimla 🏙️, Dharamshala 🕉️, and Dalhousie 🏞️ — where snow-clad peaks ❄️ meet serene valleys 🌿.
Enjoy pre-scheduled departures, guided sightseeing, comfortable stays 🏡, and hassle-free travel arrangements 🚍.
Perfect for solo travelers, families, and adventure lovers looking for a ready-made holiday plan! 📅
👉 Reserve your seat now and travel with a fun group!
    </p>
  </div>
</section>

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

<hr>

<div class="filter-group">
          <h6>Duration</h6>
          <div class="duration-cards" id="durationsList">
            <?php
            $dur_count = 0;
            
            if ($total_durations > 0) {
                $durations_result->data_seek(0); // Reset result pointer
                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
// Get all fixed departure tour packages
 $tour_sql = "SELECT * FROM tour_package WHERE fixed_departure = 1";
 $tour_result = mysqli_query($conn, $tour_sql);

if (mysqli_num_rows($tour_result) > 0) {
    while ($tour = mysqli_fetch_assoc($tour_result)) {
        $clean_price = str_replace(',', '', $tour['tour_price']);
        $numeric_price = is_numeric($clean_price) ? (float)$clean_price : 0;
?>
      
      <div class="package-card" 
           data-price="<?php echo $numeric_price; ?>"
           data-duration="<?php echo htmlspecialchars($tour['tour_duration']); ?>">
        <div class="package-image">
            <img src="admin/image-of-tours/galleryimg/<?php echo htmlspecialchars($tour['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">
                <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>
          <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>
<?php
    }
} else {
    echo "<div class='no-tours-message'><p>No fixed departure tours available at the moment.</p></div>";
}
?>
    </div>
  </div>
</section>

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

// --- FILTER LOGIC ---
function updatePriceDisplay(value) {
    document.getElementById('priceDisplay').textContent = 'Up to ₹' + Number(value).toLocaleString('en-IN');
    currentPriceFilter = parseInt(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 > 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');
    
    container.innerHTML = ''; // Clear existing tags

// Price Tag
    if (currentPriceFilter < maxPriceLimit) {
        const tag = document.createElement('div');
        tag.className = 'filter-tag';
        tag.innerHTML = `Price: Up to ₹${Number(currentPriceFilter).toLocaleString('en-IN')} <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 ₹' + Number(maxPriceLimit).toLocaleString('en-IN');
    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';
    }
}

// Initialize on page load
document.addEventListener('DOMContentLoaded', function() {
    // Make sure price filter works on page load
    updatePriceDisplay(maxPriceLimit);
    
    // Add event listeners for price range
    const priceRange = document.getElementById('priceRange');
    priceRange.addEventListener('input', function() {
        updatePriceDisplay(this.value);
    });
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: fixed-departure.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation