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

Free Space:

2.65 TB

🔧 Quick Actions

✏️ Editing: update-price.php

<?php
include '../config.php';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $productid = (int) $_POST['productid']; // Ensure productid is an integer
    $new_costprice = (float) $_POST['price']; // Convert to float for calculations
    $new_marginpercent = (float) $_POST['marginpercent']; // Convert to float for calculations
    $new_discountpercent = (float) $_POST['discountpercent']; // Convert to float for calculations

// Fetch the current GST percentage for the product from the database
    $query = "SELECT gstpercent FROM products WHERE productid = $productid";
    $result = mysqli_query($conn, $query);

if ($result && mysqli_num_rows($result) > 0) {
        $row = mysqli_fetch_assoc($result);
        $gstpercent = (float) $row['gstpercent']; // Convert to float for calculations

// Calculate the MRP, discounted price, and GST price, and round them off
        $mrp = round($new_costprice * (1 + ($new_marginpercent / 100)));
        $discounted_price = round($mrp * (1 - ($new_discountpercent / 100)));
        $gst_price = round($discounted_price * ($gstpercent / 100));

// Round the new cost price as well
        $new_costprice = round($new_costprice);

// Update the database with new costprice, marginpercent, discountpercent, MRP, discounted price, and GST price
        $update_query = "
            UPDATE products 
            SET costprice = $new_costprice, 
                marginpercent = $new_marginpercent, 
                discountpercent = $new_discountpercent, 
                mrp = $mrp, 
                discounterprice = $discounted_price, 
                gstprice = $gst_price 
            WHERE productid = $productid";
        
        if (mysqli_query($conn, $update_query)) {
            // Redirect or show success message
            header('Location: ../products.php?success=price_updated');
        } else {
            // Handle error
            echo "Error updating product prices: " . mysqli_error($conn);
        }
    } else {
        echo "Error fetching product details.";
    }
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: update-price.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation