Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.19.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u802471691

Directory:

/home/u802471691/public_html

Free Space:

9.31 TB

🔧 Quick Actions

✏️ Editing: product_parts.php

<?php
include 'db.php';
include 'header.php';

$product_id = isset($_GET['product_id']) ? (int)$_GET['product_id'] : 0;

if (!$product_id) {
    echo "<script>window.location.href='parts.php';</script>";
    exit;
}

// Fetch Product Details
$stmt = $conn->prepare("SELECT p.*, b.name as brand_name FROM products p JOIN brands b ON p.brand_id = b.id WHERE p.id = ?");
$stmt->bind_param("i", $product_id);
$stmt->execute();
$product = $stmt->get_result()->fetch_assoc();

if (!$product) {
    echo "<script>window.location.href='parts.php';</script>";
    exit;
}

$brand_id = $product['brand_id'];

// Fetch all brands (for dropdown)
$brands_res = $conn->query("SELECT * FROM brands WHERE brand_type IN ('All', 'Parts') ORDER BY name ASC");
$all_brands = $brands_res->fetch_all(MYSQLI_ASSOC);

// Fetch Series for this brand (for dropdown)
$series_id = $product['series_id'];
$series_res = $conn->query("SELECT id, name FROM series WHERE brand_id = $brand_id ORDER BY name DESC");
$all_series = $series_res->fetch_all(MYSQLI_ASSOC);

// Fetch all products for this series (for dropdown)
// Fallback: If no series is assigned to the current product, maybe show all products for the brand or just those with no series?
// For now, let's stick to the user request strictly: "according to the chosen series product models will be loaded".
// So if current product has a series, load products from that series.
if ($series_id) {
    $prods_res = $conn->query("SELECT id, name, image FROM products WHERE series_id = $series_id ORDER BY order_no DESC, name DESC");
} else {
    // Fallback if current product has no series: show products with no series for this brand?
    // Or maybe show nothing? Let's show products with no series to be safe.
    $prods_res = $conn->query("SELECT id, name, image FROM products WHERE brand_id = $brand_id AND category_id=1 AND (series_id IS NULL OR series_id = 0) ORDER BY order_no DESC, name DESC");
}
$all_brand_products = $prods_res->fetch_all(MYSQLI_ASSOC);

// Fetch Parts
$parts_stmt = $conn->prepare("SELECT * FROM product_parts WHERE product_id = ? ORDER BY category, name");
$parts_stmt->bind_param("i", $product_id);
$parts_stmt->execute();
$all_parts = $parts_stmt->get_result()->fetch_all(MYSQLI_ASSOC);

// Group parts by category
$grouped_parts = [];
foreach ($all_parts as $part) {
    $grouped_parts[$part['category']][] = $part;
}

// Category Configuration (Icon Map)
$category_config = [
    'ram' => ['icon' => 'fa-memory', 'label' => 'RAM'],
    'screen_type' => ['icon' => 'fa-mobile-screen', 'label' => 'Screen Type'],
    'motherboards' => ['icon' => 'fa-microchip', 'label' => 'Motherboard'],
    'spare_part' => ['icon' => 'fa-hard-drive', 'label' => 'Spare Parts'],
    'battery' => ['icon' => 'fa-battery-full', 'label' => 'Battery'],
    'backcover' => ['icon' => 'fa-table-cells', 'label' => 'Back Cover'],
    'camera' => ['icon' => 'fa-camera', 'label' => 'Camera'],
    'attachments' => ['icon' => 'fa-paperclip', 'label' => 'Attachments'],
    'service_inspection' => ['icon' => 'fa-screwdriver-wrench', 'label' => 'Service & Inspection']
];
?>

<div class="bg-white p-6 rounded-xl shadow-sm mb-8">
         <div class="grid grid-cols-1 md:grid-cols-3 gap-6">
             
             <div>
                 <label class="block text-gray-500 font-medium mb-1 text-sm uppercase">Brand</label>
                 <select id="brand-select" class="w-full border border-gray-300 rounded-lg px-4 py-3 focus:outline-none focus:ring-2 focus:ring-red-900 transition font-medium text-lg">
                     <?php foreach ($all_brands as $brand): ?>
                         <option value="<?php echo $brand['id']; ?>" <?php echo $brand['id'] == $brand_id ? 'selected' : ''; ?>>
                             <?php echo htmlspecialchars($brand['name']); ?>
                         </option>
                     <?php endforeach; ?>
                 </select>
             </div>

<div>
                 <label class="block text-gray-500 font-medium mb-1 text-sm uppercase">Series</label>
                 <select id="series-select" class="w-full border border-gray-300 rounded-lg px-4 py-3 focus:outline-none focus:ring-2 focus:ring-red-900 transition font-medium text-lg">
                     <option value="">Select Series</option>
                     <?php foreach ($all_series as $series): ?>
                         <option value="<?php echo $series['id']; ?>" <?php echo $series['id'] == $series_id ? 'selected' : ''; ?>>
                             <?php echo htmlspecialchars($series['name']); ?>
                         </option>
                     <?php endforeach; ?>
                 </select>
             </div>
             
             
             <div>
                 <label class="block text-gray-500 font-medium mb-1 text-sm uppercase">Product Model</label>
                 <select id="product-select" class="w-full">
                     <?php foreach ($all_brand_products as $bp): ?>
                         <option value="<?php echo $bp['id']; ?>" 
                                 data-image="<?php echo !empty($bp['image']) ? $bp['image'] : 'https://placehold.co/50x50?text=No+Img'; ?>"
                                 <?php echo $bp['id'] == $product_id ? 'selected' : ''; ?>>
                             <?php echo htmlspecialchars($bp['name']); ?>
                         </option>
                     <?php endforeach; ?>
                 </select>
             </div>
         </div>
    </div>

<div class="w-full" style="width: 100%;text-align: center;margin-bottom:2%;">
                             
                      <h2 class="text-4xl font-bold mb-6">Out of Warranty Repair Fee</h2>
                      <p>Estimated Price=Service Fee + Parts Cost(inclusive of 18% GST)</p>
    </div>

<div class="flex flex-col md:flex-row gap-8">
        
        
        
        <div class="w-full md:w-1/3">
             <div class="bg-white rounded-xl shadow-lg p-6 sticky top-24">
                 <div class="aspect-square flex items-center justify-center mb-6 bg-gray-50 rounded-lg overflow-hidden">
                     <img src="<?php echo !empty($product['image']) ? $product['image'] : 'https://placehold.co/600x600?text=No+Image'; ?>" 
                          class="max-w-full max-h-80 object-contain hover:scale-105 transition duration-500">
                 </div>
                 <h1 class="text-3xl font-bold text-gray-900 text-center mb-2"><?php echo htmlspecialchars($product['name']); ?></h1>
                 <p class="text-gray-500 text-center text-lg mb-6">Genuine Spare Parts & Pricing</p>
                 <div class="text-center">
                    <span class="inline-block bg-red-50 text-red-900 px-4 py-1 rounded-full font-medium text-sm">
                        <?php echo htmlspecialchars($product['brand_name']); ?>
                    </span>
                 </div>
             </div>
        </div>

<div class="w-full md:w-2/3">
            <div class="space-y-4">
                <?php
                if (empty($grouped_parts)) {
                    echo '<div class="bg-yellow-50 text-yellow-800 p-6 rounded-lg text-center font-medium">No parts listed for this model yet.</div>';
                }

// Special handling for service_inspection - show first and not collapsible
                if (isset($grouped_parts['service_inspection'])) {
                    $config = $category_config['service_inspection'];
                    $parts = $grouped_parts['service_inspection'];
                ?>
                    
                    <div class="bg-white rounded-xl shadow overflow-hidden border border-gray-100">
                        <div class="flex items-center gap-2 p-1.5 bg-white">
                             <div class="w-7 h-7 rounded-full bg-red-50 flex items-center justify-center text-red-900 text-sm">
                                 <i class="fa-solid <?php echo $config['icon']; ?>"></i>
                             </div>
                             <h2 class="text-sm font-bold text-gray-800"><?php echo $config['label']; ?></h2>
                        </div>

<div class="border-t border-gray-100 bg-gray-50/50">
                            <div class="p-6 space-y-3">
                                <?php foreach ($parts as $part): ?>
                                    <div class="flex flex-col sm:flex-row justify-between items-center bg-white p-4 rounded-lg border border-gray-200 shadow-sm hover:shadow-md transition">
                                        <div class="flex items-center gap-3 mb-2 sm:mb-0">
                                            <input type="checkbox" id="part-<?php echo $part['id']; ?>" data-price="<?php echo $part['price']; ?>" data-name="<?php echo htmlspecialchars($part['name']); ?>" checked disabled class="w-4 h-4 text-red-600 bg-gray-100 border-gray-300 rounded focus:ring-red-500">
                                            <span class="font-semibold text-gray-700"><?php echo htmlspecialchars($part['name']); ?></span>
                                        </div>
                                            <span class="font-bold text-lg text-red-900">₹<?php echo number_format($part['price'], 2); ?></span>
                                    </div>
                                <?php endforeach; ?>
                            </div>
                        </div>
                    </div>
                <?php } ?>

<?php
                foreach ($category_config as $key => $config):
                    if ($key === 'service_inspection' || !isset($grouped_parts[$key])) continue;
                    $parts = $grouped_parts[$key];
                ?>
                    
                    <div class="bg-white rounded-xl shadow overflow-hidden border border-gray-100">
                        <button onclick="toggleAccordion('<?php echo $key; ?>')" class="w-full flex items-center justify-between p-1.5 bg-white hover:bg-gray-50 transition text-left">
                             <div class="flex items-center gap-2">
                                 <div class="w-7 h-7 rounded-full bg-red-50 flex items-center justify-center text-red-900 text-sm">
                                     <i class="fa-solid <?php echo $config['icon']; ?>"></i>
                                 </div>
                                 <h2 class="text-sm font-bold text-gray-800"><?php echo $config['label']; ?></h2>
                             </div>
                             <i id="icon-<?php echo $key; ?>" class="fa-solid fa-chevron-down text-gray-400 transition-transform duration-300 text-sm"></i>
                        </button>

<div id="content-<?php echo $key; ?>" class="hidden border-t border-gray-100 bg-gray-50/50">
                            <div class="p-6 space-y-3">
                                <?php foreach ($parts as $part): ?>
                                    <div class="flex flex-col sm:flex-row justify-between items-center bg-white p-4 rounded-lg border border-gray-200 shadow-sm hover:shadow-md transition">
                                        <div class="flex items-center gap-3 mb-2 sm:mb-0">
                                            <input type="checkbox" id="part-<?php echo $part['id']; ?>" data-price="<?php echo $part['price']; ?>" data-name="<?php echo htmlspecialchars($part['name']); ?>" class="w-4 h-4 text-red-600 bg-gray-100 border-gray-300 rounded focus:ring-red-500">
                                            <span class="font-semibold text-gray-700"><?php echo htmlspecialchars($part['name']); ?></span>
                                        </div>
                                            <span class="font-bold text-lg text-red-900">₹<?php echo number_format($part['price'], 2); ?></span>
                                    </div>
                                <?php endforeach; ?>
                            </div>
                        </div>
                    </div>
                <?php endforeach; ?>
            </div>

<div id="total-anchor" class="mt-8">
                <div id="sticky-total-box" class="bg-white rounded-xl shadow-lg p-6">
                    <div class="flex flex-col md:flex-row justify-between items-center">
                        <div class="text-center md:text-left mb-4 md:mb-0">
                            <h3 class="text-xl font-bold text-gray-800">Total Amount</h3>
                            <p class="text-gray-600">Selected parts and service inspection</p>
                        </div>
                        <div class="flex items-center gap-6">
                            <span id="totalAmount" class="text-3xl font-bold text-red-900">₹0.00</span>
                            <button id="sendEnquiryBtn" class="bg-red-900 hover:bg-red-800 text-white px-6 py-3 rounded-lg font-bold transition duration-200 flex items-center gap-2">
                                Send Enquiry <i class="fa-solid fa-arrow-right"></i>
                            </button>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        
    </div>
    <div class="w-full md:w-3/3">
            <div class="bg-white p-6 rounded-xl shadow-sm mt-8">
                 <div class="prose max-w-none">
                    <h4 style="font-weight: bold;">NOTES</h4>
                     <?php  
                            if($product['notes']){
                                echo nl2br(htmlspecialchars($product['notes']));
                            } else {

// Display parts content from settings
                         $settings_res = $conn->query("SELECT parts_content FROM settings WHERE id = 1");
                         $settings = $settings_res->fetch_assoc();
                         echo $settings['parts_content'];
                                    if(empty($settings['parts_content'])) {
                                echo "<p class='text-gray-500'>No additional notes for this product.</p>";
                                    }else{
                                        echo nl2br(htmlspecialchars($settings['parts_content']));
                                    }
                            }

?>
                 </div>                        
        </div>
    </div>

<div id="enquiryModal" class="fixed inset-0 bg-black bg-opacity-50 z-50 hidden flex items-center justify-center">
    <div class="bg-white rounded-xl shadow-2xl p-6 w-full max-w-md mx-4 transform transition-all scale-95 opacity-0" id="modalContent">
        <div class="flex justify-between items-center mb-6">
            <h3 class="text-xl font-bold text-gray-800">Part Enquiry</h3>
            <button onclick="closeModal()" class="text-gray-400 hover:text-gray-600 focus:outline-none">
                <i class="fa-solid fa-times text-xl"></i>
            </button>
        </div>
        
        <form id="enquiryForm" class="space-y-4">
            <input type="hidden" name="part_name" id="modalPartName">
            <input type="hidden" name="product_name" id="modalProductName" value="<?php echo htmlspecialchars($product['name']); ?>">
            
            <div class="bg-gray-50 p-3 rounded-lg border border-gray-100 mb-4">
                <p class="text-xs text-gray-500 uppercase font-bold mb-1">Enquiring For:</p>
                <p class="font-bold text-gray-800" id="displayPartName">Part Name</p>
                <p class="text-sm text-gray-600"><?php echo htmlspecialchars($product['name']); ?></p>
            </div>

<div>
                <label class="block text-gray-700 font-medium mb-1">Your Name</label>
                <input type="text" name="name" required class="w-full border border-gray-300 rounded px-3 py-2 text-gray-700 focus:outline-none focus:ring-2 focus:ring-red-900" placeholder="John Doe">
            </div>
            
            <div>
                <label class="block text-gray-700 font-medium mb-1">Phone Number</label>
                <input type="tel" name="phone" required pattern="[0-9]{10}" class="w-full border border-gray-300 rounded px-3 py-2 text-gray-700 focus:outline-none focus:ring-2 focus:ring-red-900" placeholder="9876543210">
                <p class="text-xs text-gray-400 mt-1">We will contact you on this number.</p>
            </div>
            
            <button type="submit" class="w-full bg-red-900 hover:bg-red-800 text-white font-bold py-3 rounded-lg transition duration-200 mt-2">
                Send Enquiry
            </button>
        </form>
    </div>
</div>

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>

// Modal Functions
    function openEnquiryModal(partName) {
        document.getElementById('modalPartName').value = partName;
        document.getElementById('displayPartName').innerText = partName;
        
        const modal = document.getElementById('enquiryModal');
        const content = document.getElementById('modalContent');
        
        modal.classList.remove('hidden');
        // Small delay to allow display flex to apply before opacity transition
        setTimeout(() => {
            content.classList.remove('scale-95', 'opacity-0');
            content.classList.add('scale-100', 'opacity-100');
        }, 10);
    }

function closeModal() {
        const modal = document.getElementById('enquiryModal');
        const content = document.getElementById('modalContent');
        
        content.classList.remove('scale-100', 'opacity-100');
        content.classList.add('scale-95', 'opacity-0');
        
        setTimeout(() => {
            modal.classList.add('hidden');
        }, 300);
    }

// Close modal on outside click
    document.getElementById('enquiryModal').addEventListener('click', function(e) {
        if (e.target === this) {
            closeModal();
        }
    });

function openBulkEnquiryModal() {
        const selectedParts = [];
        $('input[type="checkbox"]:checked').each(function() {
            selectedParts.push($(this).data('name'));
        });

if (selectedParts.length === 0) {
            Swal.fire({
                icon: 'warning',
                title: 'No Parts Selected',
                text: 'Please select at least one part to send an enquiry.',
                confirmButtonColor: '#7f1d1d'
            });
            return;
        }

document.getElementById('modalPartName').value = JSON.stringify(selectedParts);
        document.getElementById('displayPartName').innerText = selectedParts.join(', ');

const modal = document.getElementById('enquiryModal');
        const content = document.getElementById('modalContent');

modal.classList.remove('hidden');
        // Small delay to allow display flex to apply before opacity transition
        setTimeout(() => {
            content.classList.remove('scale-95', 'opacity-0');
            content.classList.add('scale-100', 'opacity-100');
        }, 10);
    }

$(document).ready(function() {
        // Initialize Select2 with Custom Template
        $('#product-select').select2({
            templateResult: formatProductOption,
            templateSelection: formatProductSelection,
            minimumResultsForSearch: 5
        });

// Handle Brand Change
        $('#brand-select').on('change', function() {
            var brandId = $(this).val();
            // Clear Series and Product
            $('#series-select').html('<option value="">Loading...</option>');
            $('#product-select').empty().trigger('change');

if (brandId) {
                $.ajax({
                    url: 'get_options.php', // You need to create this file
                    type: 'GET',
                    data: { type: 'series', id: brandId },
                    dataType: 'json',
                    success: function(data) {
                        if (data.length > 0) {
                            var options = '<option value="">Select Series</option>';
                            $.each(data, function(index, item) {
                                options += '<option value="' + item.id + '">' + item.name + '</option>';
                            });
                            $('#series-select').html(options);
                            $('#product-select').html('<option value="">Select Series First</option>');
                        } else {
                            // No series found - fallback to load products for brand directly
                            $('#series-select').html('<option value="">No Series Available</option>');
                            fetchBrandProducts(brandId);
                        }
                    }
                });
            } else {
                 $('#series-select').html('<option value="">Select Series</option>');
            }
        });

// Handle Series Change
        $('#series-select').on('change', function() {
            var seriesId = $(this).val();
            $('#product-select').html('<option value="">Loading...</option>').trigger('change');

if (seriesId) {
                 $.ajax({
                    url: 'get_options.php',
                    type: 'GET',
                    data: { type: 'products', id: seriesId },
                    dataType: 'json',
                    success: function(data) {
                        var options = '<option value="">Select Product</option>';
                        $.each(data, function(index, item) {
                            var img = item.image ? item.image : 'https://placehold.co/50x50?text=No+Img';
                            options += '<option value="' + item.id + '" data-image="' + img + '">' + item.name + '</option>';
                        });
                        $('#product-select').html(options).trigger('change');
                    }
                });
            } else {
                 $('#product-select').html('<option value="">Select Series First</option>');
            }
        });

// Handle Product Change (Redirect)
        $('#product-select').on('change', function() {
            var val = $(this).val();
            if (val) {
                 window.location.href = 'product_parts.php?product_id=' + val;
            }
        });

// Calculate initial total
        calculateTotal();

// Handle checkbox changes
        $('input[type="checkbox"]:not([disabled])').on('change', function() {
            calculateTotal();
        });

// Handle Send Enquiry button
        $('#sendEnquiryBtn').on('click', function() {
            openBulkEnquiryModal();
        });

// Handle Form Submission
        $('#enquiryForm').on('submit', function(e) {
            e.preventDefault();
            const btn = $(this).find('button[type="submit"]');
            const originalText = btn.text();

btn.prop('disabled', true).html('<i class="fa-solid fa-spinner fa-spin"></i> Sending...');

$.ajax({
                url: 'submit_part_enquiry.php',
                type: 'POST',
                data: $(this).serialize(),
                dataType: 'json',
                success: function(response) {
                    if (response.success) {
                        closeModal();
                        Swal.fire({
                            icon: 'success',
                            title: 'Enquiry Sent!',
                            text: response.message,
                            confirmButtonColor: '#7f1d1d'
                        });
                        $('#enquiryForm')[0].reset();
                    } else {
                        Swal.fire({
                            icon: 'error',
                            title: 'Error',
                            text: response.message,
                            confirmButtonColor: '#7f1d1d'
                        });
                    }
                },
                error: function() {
                    Swal.fire({
                        icon: 'error',
                        title: 'Error',
                        text: 'Something went wrong. Please try again.',
                        confirmButtonColor: '#7f1d1d'
                    });
                },
                complete: function() {
                    btn.prop('disabled', false).text(originalText);
                }
            });
        });

// Sticky Total Box Logic
        function handleStickyTotal() {
            const anchor = $('#total-anchor');
            const box = $('#sticky-total-box');
            
            if (anchor.length === 0 || box.length === 0) return;
            
            // Measure box height to reserve space
            // Note: If box is fixed, we must rely on its current outerHeight.
            // If it's static, same thing.
            const boxHeight = box.outerHeight();
            
            // Set anchor height to reserve space in flow
            anchor.css('height', boxHeight + 'px');
            
            // Calculate positions
            const anchorTop = anchor.offset().top; 
            const anchorBottom = anchorTop + boxHeight;
            const scrollPos = $(window).scrollTop();
            const windowHeight = $(window).height();
            const winBottom = scrollPos + windowHeight;
            
            // Logic: 
            // If the bottom of the anchor (where natural box ends) is below the viewport bottom,
            // then we haven't reached the end, so FIX the box to bottom.
            if (winBottom < anchorBottom) {
                // Determine width and left from anchor to match layout
                const width = anchor.width();
                const left = anchor.offset().left;
                
                box.css({
                    'position': 'fixed',
                    'bottom': '0',
                    'left': left + 'px',
                    'width': width + 'px',
                    'z-index': '50',
                    'border-radius': '0.75rem 0.75rem 0 0',
                    'box-shadow': '0 -4px 10px rgba(0,0,0,0.1)'
                });
            } else {
                // We reached the bottom (natual position), reset to static
                box.css({
                    'position': 'static',
                    'bottom': '',
                    'left': '',
                    'width': '',
                    'z-index': '',
                    'border-radius': '', // Return to default class
                    'box-shadow': ''
                });
            }
        }

// Bind Sticky Events
        $(window).on('scroll resize', handleStickyTotal);
        // Initial call after small delay to ensure rendering
        setTimeout(handleStickyTotal, 100);
        
        // Update when checkbox changes (in case height changes, unlikely but good practice)
        $('input[type="checkbox"]').on('change', function(){
             setTimeout(handleStickyTotal, 50);
        });
    });

function formatProductOption(state) {
        if (!state.id) return state.text;
        var image = $(state.element).data('image');
        var $state = $(
            '<div class="select2-item-custom">' +
                '<img src="' + image + '" class="img-flag" />' +
                '<span>' + state.text + '</span>' +
            '</div>'
        );
        return $state;
    }

function formatProductSelection(state) {
        if (!state.id) return state.text;
        var image = $(state.element).data('image');
        // Small image for selection view
        return $('<span class="flex items-center"><img src="'+image+'" class="w-8 h-8 rounded mr-2 object-contain bg-gray-100" /> ' + state.text + '</span>');
    }
</script>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: product_parts.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation