Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.37.1.lve.el8.x86_64

PHP Version:

8.0.30

User:

u885320773

Directory:

/home/u885320773/domains/sugatu.in/.trash

Free Space:

2.65 TB

🔧 Quick Actions

✏️ Editing: combo-details.php

<!DOCTYPE html>
<html class="no-js" lang="en">

<head>
    <meta charset="utf-8" />
    <title>Sugatu - Product Combo</title>
    <meta http-equiv="x-ua-compatible" content="ie=edge" />
    <meta name="description" content="" />
    <meta name="viewport" content="width=device-width, initial-scale=1" />
    <meta property="og:title" content="" />
    <meta property="og:type" content="" />
    <meta property="og:url" content="" />
    <meta property="og:image" content="" />
    
    <link rel="shortcut icon" type="image/x-icon" href="assets/imgs/theme/favicon.png" />
    
    <link rel="stylesheet" href="assets/css/plugins/slider-range.css" />
    <link rel="stylesheet" href="assets/css/main.css?v=5.6" />
    <link href="https://cdn.jsdelivr.net/npm/bootstrap-icons/font/bootstrap-icons.css" rel="stylesheet">

// Initialize subtotals and total on page load
    initializeSubtotals();
    updateTotal();

// Function to initialize subtotals on page load
function initializeSubtotals() {
    $(".qty-val").each(function () {
        var row = $(this).closest("tr");
        var productId = row.data("product-id");
        var quantity = parseInt($(this).text()) || 0;
        var price = parseFloat(row.find(".price").text().replace('₹', '').trim()) || 0;
        var subtotal = quantity * price;
        row.data("subtotal", subtotal);
        subtotals[productId] = subtotal;
    });

// Update the total and subtotal displays
    updateTotal();
    updateSubtotalDisplay();
}

// Function to update subtotal display
function updateSubtotalDisplay() {
    var totalSubtotal = 0;

// Iterate through each product row
    $(".qty-val").each(function () {
        var subtotal = parseFloat($(this).closest("tr").data("subtotal")) || 0;
        totalSubtotal += subtotal;
    });

// Update the content of the subtotal <h4> tag
    $("#subtotalValue").text('₹' + totalSubtotal.toFixed(2));
}

// Function to update subtotal for the row
    
// Function to update subtotal for the row
function updateSubtotal(element) {
    var row = element.closest("tr");
    var quantityElement = row.find(".qty-val");
    var priceElement = row.find(".price");

// Retrieve quantity and price values
    var quantity = parseInt(quantityElement.text()) || 0;
    var price = parseFloat(priceElement.text().replace('₹', '').trim()) || 0;

// Update quantity and calculate subtotal
    if (element.hasClass("qty-down")) {
        quantity = Math.max(quantity - 1, 1); // Ensure quantity is not less than 1
    } else {
        quantity += 1;
    }

var subtotal = quantity * price;
    quantityElement.text(quantity);
    row.data("subtotal", subtotal);

// Update 'subtotals' object with the new subtotal value
    var productId = row.data("product-id");
    subtotals[productId] = subtotal;

// Debugging output
    console.log("Updated Subtotal for Product ID " + productId + ": ₹" + subtotal.toFixed(2));

// Update subtotal display
    updateSubtotalDisplay();
}

// Function to update the total price
    function updateTotal() {
        var totalPrice = 0;

// Iterate through each product row
        $(".qty-val").each(function () {
            var subtotal = parseFloat($(this).closest("tr").data("subtotal")) || 0;
            totalPrice += subtotal;
        });

// Calculate discount value based on discount percent
        var discountPercent = parseFloat(document.getElementById("discountPercent").value) || 0;
        var discountValue = (discountPercent / 100) * totalPrice;

// Update the content of the discount and total <h5> and <h4> tags
        $("#discountValue").text('₹' + discountValue.toFixed(2));
        $("#totalValue").text('₹' + (totalPrice - discountValue).toFixed(2));

// Update a hidden input field with the total value (for submission to PHP)
        $("#totalInput").val((totalPrice - discountValue).toFixed(2));

// Debugging output
        console.log("Total Price: ₹" + totalPrice.toFixed(2));
        console.log("Discount Value: ₹" + discountValue.toFixed(2));
    }

// Function to update hidden form field with subtotal data
    function updateHiddenField() {
        // Convert JavaScript object to a JSON string
        var subtotalsJson = JSON.stringify(subtotals);

// Update the value of the hidden form field
        $("#subtotalsInput").val(subtotalsJson);

// Debugging output
        console.log("Updated Subtotals JSON: " + subtotalsJson);
    }
    
    // Function to update the displayed price for a row
function updateDisplayedPrice(row) {
    var quantity = parseInt(row.find(".qty-val").text()) || 0;
    var price = parseFloat(row.find(".price").text().replace('₹', '').trim()) || 0;

var displayedPrice = quantity * price;
    row.find(".text-brand").text('₹' + displayedPrice.toFixed(2));
}

// Event handler for quantity decrease
$(document).on("click", ".qty-down, .qty-up", function () {
    var row = $(this).closest("tr");
    updateSubtotal($(this));
    updateTotal(); // Update the total after changing quantity
    updateHiddenField(); // Update hidden form field
    updateDisplayedPrice(row); // Update the displayed price
});
});

</script>

.zoomContainer, .zoomWindow {
        z-index: 997;
    }
    ul{
        /* list-style-type: '✔  '; */
        list-style-type:disc;
    }
    
    .hidden {
      display: none;
    }
    
    
    @media only screen and (max-width: 480px){
.table td {
    text-align: left;
}
.shopping-summery table > :not(caption) > * > * {
    padding: 5px;
}
}
    
    
    
    </style>
</head>

<body>
 
    <?php 
    
    include 'includes/header.php'; 
    
    
    if ($_SERVER["REQUEST_METHOD"] == "GET" && isset($_REQUEST['combokitid'])) {
  
        $combokitid = $_REQUEST['combokitid'];
        $product_id = $combokitid;

include 'admin/config.php';

// Fetch Parent Category Name
        $sql2 = "SELECT cktitle,features,description,combokitimage,discountpercent FROM combo WHERE combokitid = '$combokitid'";
        $result2 = $conn->query($sql2);
        if ($result2->num_rows > 0) {
            while ($row = $result2->fetch_assoc()) {
                $cktitle = $row['cktitle'];
                $features = $row['features'];
                $description = $row['description'];
                $combokitimage = $row['combokitimage'];
                $discountpercent = $row['discountpercent'];
            }
        }

$ptitle = $cktitle;
        $gmain = $combokitimage;

// $sqll="SELECT ck.id, ck.combokitid, ck.cktitle, ck.combokitimage, cc.ckname as 'ckcategory' FROM combokits ck JOIN combokitcategory cc ON ck.parentCategory = cc.id WHERE ck.parentCategory = $catid;";

} 
    
    ?>

<main class="main">
        <div class="page-header breadcrumb-wrap">
            <div class="container">
                <div class="breadcrumb">
                    <a href="index.html" rel="nofollow"><i class="fi-rs-home mr-5"></i>Home</a>
                    <span></span> Product Combo
                    <span></span> <?php echo $cktitle; ?>
                </div>
            </div>
        </div>
        <div class="container mb-80 mt-50">
            <div class="row">
                <div class="col-sm-12 mb-40">
                    <div class="row">
                        <div class="col-md-6 mb-40">
                           <img src="admin/assets/imgs/combokits/<?php echo $combokitimage ?>" style="width:100%; border:solid 1px #efefef; border-radius:10px">
                        </div>
                        <div class="col-md-6 mb-40">
                            <h1 class="heading-2 mb-10"><?php echo $cktitle; ?></h1>
                            <?php
                                include 'admin/config.php';
                                $sql = "SELECT cp.id, cp.changeqty, cp.combokitid, cp.productid, cp.pquantity, p.discounterprice, p.gstpercent FROM comboproduct cp JOIN products p ON cp.productid = p.id WHERE cp.combokitid = $combokitid;";

$result = $conn->query($sql);

if (!$result) {
                                    die("Error executing query: " . $conn->error);
                                }

$totalDiscounterPrice = 0; // Initialize total discounted price
                                $totalGstPrice = 0; // Initialize total price including GST

if ($result->num_rows > 0) {
                                    // Output data of each row
                                    // Loop through the query result
                                    while($row = $result->fetch_assoc()) {
                                        $discounterPrice = $row['discounterprice'];
                                        $quantity = $row['pquantity'];
                                        $changeQty = $row['changeqty'];
                                        $price = $quantity * $discounterPrice;
                                        $gstPercent = $row['gstpercent'];
                                        $gstPrice = (($price * $gstPercent) / 100) + $price;

// Accumulate total discounted price and total price including GST
                                        $totalDiscounterPrice += $price;
                                        $totalGstPrice += $gstPrice;
                                    }
                                }

?>
                            <div class="detail-info">
                            <div class="clearfix product-price-cover">
                                <div class="row">
                                    <div class="col-sm-12">
                                        <div class="product-price primary-color float-left" style="margin-bottom:0;">
                                            <span class="current-price text-brand">₹<?php echo $totalDiscounterPrice; ?></span>
                                            <span>
                                                <span class="save-price font-md color3 ml-15">Including GST</span>
                                                <span class="old-price font-md ml-15" style="text-decoration: none;">₹<?php echo $totalGstPrice; ?></span>
                                            </span>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            </div>

<div class="short-desc mb-30 mt-30">
                                <p class="font-lg">
                                    <b style="color:#000000;">FEATURES</b><br>
                                    <?php echo $features ?>
                                </p>
                            </div> 
                            <div class="divider-2 mb-30"></div>
                            <div class="short-desc mb-30">
                                <p class="font-lg">
                                    <b style="color:#000000;">DESCRIPTION</b><br>
                                    <?php echo $description ?>
                                </p>
                            </div>

<div class="detail-extralink mb-50">
                                    <div class="product-extra-link2">
                                        
                                        <button class="add add-to-cart button button-add-to-cart" data-bs-toggle="modal" data-bs-target="#enquiryModal" data-product-id="<?php echo $product_id; ?>">
                                            <i class="fi-rs-envelope"></i> Send Enquiry
                                        </button>

<div class="modal fade" id="enquiryModal" tabindex="-1" aria-labelledby="enquiryModalLabel" aria-hidden="true">
  <div class="modal-dialog modal-lg">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="enquiryModalLabel">Send Enquiry</h5>
        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
      </div>
      <div class="modal-body">
        <div class="row">
          <div class="col-md-4">
            <img src="admin/assets/imgs/combokits/<?php echo $gmain; ?>" class="img-fluid" alt="Product Image">
            
          </div>
          <div class="col-md-8">
            <h5 class="title-detail mb-30">Enquiry for <?php echo $ptitle; ?></h5>
            
            <form action="process/submit_enquiry.php" method="POST">
              <input type="hidden" name="pid" value="<?php echo $product_id; ?>">
              <input type="hidden" name="ptitle" value="<?php echo $ptitle; ?>">
              <input type="hidden" name="type" value="Combo">
              <div class="row">
                <div class="col-sm-12 mb-3">
                    
                    <input type="text" class="form-control" id="nameInput" placeholder="Name" name="name" required>
                </div>
                <div class="col-sm-12 mb-3">
                    
                    <input type="email" class="form-control" id="emailInput" placeholder="Email id" name="email" required>
                </div>
                <div class="col-sm-6 mb-3">
                    
                    <input type="text" class="form-control" id="phoneInput" placeholder="Phone" name="phone" required>
                </div>
                <div class="col-sm-6 mb-3">
                    
                    <input type="text" class="form-control" id="pincodeInput" placeholder="Pincode" name="pincode" maxlength="6" required>
                </div>
              </div>
              <button type="submit" class="btn btn-primary">Submit</button>
            </form>
          </div>
        </div>
        
      </div>
    </div>
  </div>
</div>

</div>
                                </div>

</div>
                        
                    </div>
                    
                </div>
            </div>
            <div class="row">
                <div class="col-lg-12">
                    
                <div class="table-responsive shopping-summery">
                        <table class="table table-wishlist">
                            <thead>
                                <tr class="main-heading">
                                    
                                    <th class="start pl-30" scope="col" colspan="2" style="width:40%">Product</th>
                                    <th scope="col">Rate</th>
                                    <th scope="col">Qty</th>
                                    <th scope="col">Subtotal</th>
                                    <th scope="col">Inc GST</th>
                                </tr>
                            </thead>
                            <tbody>
                            <?php
                                include 'admin/config.php';

// SQL query to fetch data from the table
                                $sql = "SELECT cp.id, cp.changeqty, cp.combokitid, cp.productid, cp.pquantity, p.id as pid, p.ptitle, p.gmain, p.discounterprice, p.gstpercent FROM comboproduct cp JOIN products p ON cp.productid = p.id WHERE cp.combokitid = $combokitid;";

$result = $conn->query($sql);

if (!$result) {
                                    die("Error executing query: " . $conn->error);
                                }

if ($result->num_rows > 0) {
                                    // Output data of each row
                                   
                                    while($row = $result->fetch_assoc()) {
                                        $quantity = $row['pquantity'];
                                        $changeQty = $row['changeqty'];
                                        $price=$row['pquantity'] * $row['discounterprice'];
                                        $gstpercent=$row['gstpercent'];
                                        $gstprice=(($price*$gstpercent)/100)+$price;

echo '<tr data-product-id="'.$row['id'].'">
                                            
                                            <td class="image product-thumbnail pl-30"><img src="admin/assets/imgs/products/'.$row['gmain'].'" alt="#" style="height:60px; width:60px;"></td>
                                            <td class="product-des product-name"> 
                                                <p class="mb-5"> <a class="product-name mb-10 text-heading" href="product-details.php?id='.$row['pid'].'" target="_blank" style="padding-left:3px;"> '.$row['ptitle'].'</a></p>
                                               
                                            </td>
                                            <td class="price" data-title="Rate">
                                                <h4 class="text-body">₹'.$row['discounterprice'].' </h4>
                                            </td>
                                            <td class="price" data-title="Qty">
                                                <h4 class="text-body">'.$row['pquantity'].'</h4>
                                            </td>
                                            <td class="price" data-title="Price">
                                                <h4 class="text-body">₹'.$price.' </h4>
                                            </td>
                                            <td class="price" data-title="Inc GST">
                                                <h4 class="text-brand">₹'.$gstprice.' <span class="text-body" style="font-weight:400; font-size:16px">(Inc '.$gstpercent.' GST)</span></h4>
                                            </td>

</tr>';

/*   echo '<tr class="product-row ' . ($changeQty === 'no' ? 'non-changeable' : '') . '" data-product-id="'.$row['id'].'">
                                            
                                            <td class="image product-thumbnail pl-30"><img src="admin/assets/imgs/products/'.$row['gmain'].'" alt="#" style="height:60px; width:60px;"></td>
                                            <td class="product-des product-name">
                                                <p class="mb-5"><a class="product-name mb-10 text-heading" href="#">'.$row['ptitle'].'</a></p>
                                               
                                            </td>
                                            <td class="price" data-title="Price">
                                                <h4 class="text-body">₹'.$row['discounterprice'].' </h4>
                                            </td>
                                            <td class="text-center detail-info" data-title="Stock">
                                            <div class="detail-extralink mr-15">
                                                <div class="detail-qty border radius">
                                                    <a href="#" class="qty-down" data-product-id="'.$row['id'].'"><i class="fi-rs-angle-small-down"></i></a>
                                                    <span class="qty-val">'.$row['pquantity'].'</span>
                                                    <a href="#" class="qty-up" data-product-id="'.$row['id'].'"><i class="fi-rs-angle-small-up"></i></a>
                                                </div>
                                            </div>
                                            </td>
                                            <td class="price" data-title="Price">
                                                <h4 class="text-brand">₹'.$row['pquantity'] * $row['discounterprice'].' </h4>
                                            </td>
                                    
                                        </tr>';

}
                                    echo '</tbody></table>';
                                } else {
                                    echo "0 results";
                                }

// Close connection
                                $conn->close();
                            ?>
                             
                            </tbody>
                        </table>
                    </div>
                   
                </div>
            </div>
            
            
            
            <div class="row">
                
                <div class="col-sm-12">
                    
                    
                    
                    <div class="accordion" id="faqAccordion">

<?php
        // Database connection details
        include 'admin/config.php';
        
        // Query to fetch FAQs from the database
        $query = "SELECT * FROM combo WHERE combokitid = '$combokitid' ";
        $result = $conn->query($query);
//        echo $query;

// After executing the query, add the following:
/*
if ($result === false) {
    die("Error in query: " . $conn->error);
}
*/

// Before the closing brace of the script, add the following:

// Check if there are results
        if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                
                
                $faqFound = false;
                $faqHeadingDisplayed = false; // Initializing the variable

for ($i = 1; $i <= 10; $i++) {
    $fq_key = 'fq' . $i;
    $fa_key = 'fa' . $i;
    
    if (!empty($row[$fq_key]) && !empty($row[$fa_key])) {
        $faqFound = true;

// If at least one FAQ is found, display the heading for "Frequently Asked Questions"
        if (!$faqHeadingDisplayed) {
            echo '<div class="col-sm-12 mb-20">
            <h2>Frequently Asked Questions</h2>
        </div>';
            $faqHeadingDisplayed = true;
        }

echo '
        <div class="accordion-item">
            <h2 class="accordion-header" id="heading' . $i . '">
                <button class="accordion-button" type="button" data-bs-toggle="collapse" data-bs-target="#collapse' . $i . '" aria-expanded="false" aria-controls="collapse' . $i . '">
                    ' . $row[$fq_key] . '
                </button>
            </h2>
            <div id="collapse' . $i . '" class="accordion-collapse collapse" aria-labelledby="heading' . $i . '" data-bs-parent="#faqAccordion">
                <div class="accordion-body">
                    ' . $row[$fa_key] . '
                </div>
            </div>
        </div>';
    }
}

if (!$faqFound) {
 //   echo "No FAQs found";
}

}
         //   var_dump($result->num_rows); // Check the number of rows returned
        } else {
            echo '<p>No FAQs found.</p>';
         //   var_dump($result->num_rows); // Check the number of rows returned
        }

// Close the database connection
        $conn->close();
        ?>

</div>
                    
                    
                </div>

<div class="col-sm-12 mt-30">
                <?php
// Database connection details
include 'admin/config.php';

// Query to fetch files from the database
$query = "SELECT * FROM combo WHERE combokitid = '$combokitid'";
$result = $conn->query($query);

// Check if there are results
if ($result->num_rows > 0) {
    $filesExist = false;

// Check if any file exists
    while ($row = $result->fetch_assoc()) {
        for ($i = 1; $i <= 8; $i++) {
            $nameKey = 's' . $i . 'name';
            $fileKey = 's' . $i . 'file';

// Check if both name and file are set and not empty
            if (isset($row[$nameKey]) && isset($row[$fileKey]) && !empty($row[$nameKey]) && !empty($row[$fileKey])) {
                $filesExist = true;
                break; // Exit the loop if any file is found
            }
        }

if ($filesExist) {
            break; // Exit the loop if any file is found
        }
    }

// If files exist, display the heading "Documents" and the table
    if ($filesExist) {
        echo '<div class="col-sm-12 mb-20">
        <h2>Documents</h2>
    </div>';
        echo '<table>';
        echo '<tr>
                <th>Document Name</th>
                <th>Download</th>
              </tr>';

// Display each file in the table
        foreach ($result as $row) {
            for ($i = 1; $i <= 8; $i++) {
                $nameKey = 's' . $i . 'name';
                $fileKey = 's' . $i . 'file';

// Check if both name and file are set and not empty
                if (isset($row[$nameKey]) && isset($row[$fileKey]) && !empty($row[$nameKey]) && !empty($row[$fileKey])) {
                    echo '
                    <tr>
                        <td>'.$row[$nameKey].'</td>
                        <td><a href="admin/assets/pdfs/combokits/'.$row[$fileKey].'" class="btn btn-primary">Download</a></td>
                    </tr>';
                }
            }
        }

echo '</table>';
    }
}
?>

</div>

</div>
        </div>
    </main>
    <?php include 'includes/footer.php'; ?>
    
    
    <script src="assets/js/vendor/modernizr-3.6.0.min.js"></script>
    <script src="assets/js/vendor/jquery-3.6.0.min.js"></script>
    <script src="assets/js/vendor/jquery-migrate-3.3.0.min.js"></script>
    <script src="assets/js/vendor/bootstrap.bundle.min.js"></script>
    <script src="assets/js/plugins/slick.js"></script>
    <script src="assets/js/plugins/jquery.syotimer.min.js"></script>
    <script src="assets/js/plugins/wow.js"></script>
    <script src="assets/js/plugins/slider-range.js"></script>
    <script src="assets/js/plugins/perfect-scrollbar.js"></script>
    <script src="assets/js/plugins/magnific-popup.js"></script>
    <script src="assets/js/plugins/select2.min.js"></script>
    <script src="assets/js/plugins/waypoints.js"></script>
    <script src="assets/js/plugins/counterup.js"></script>
    <script src="assets/js/plugins/jquery.countdown.min.js"></script>
    <script src="assets/js/plugins/images-loaded.js"></script>
    <script src="assets/js/plugins/isotope.js"></script>
    <script src="assets/js/plugins/scrollup.js"></script>
    <script src="assets/js/plugins/jquery.vticker-min.js"></script>
    <script src="assets/js/plugins/jquery.theia.sticky.js"></script>
    <script src="assets/js/plugins/jquery.elevatezoom.js"></script>
    
    <script src="./assets/js/main.js?v=5.6"></script>
    <script src="./assets/js/shop.js?v=5.6"></script>
</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: combo-details.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation