["input", "", "", "text"],
"quantity" => ["input", "", "", "text"],
"unit_conversion" => ["input", "", "", "text"],
"package_conversion" => ["input", "", "", "text"],
"case_conversion" => ["input", "", "", "text"],
"last_updated" => ["input", "", "", "text"],
);
if (isset($_POST['add_product_quantity'])) {
$actionId = escape(($_POST['actionId']));
$product = escape($_POST['product_id']);
// echo $product; die();
$quantity = escape($_POST['quantity']);
$unit_conversion = escape($_POST['unit_conversion']);
$package_conversion = escape($_POST['package_conversion']);
$case_conversion = escape($_POST['case_conversion']);
if ($actionId == "") {
$query = "insert into jeoXillityCrm_product_stock set product_id='$product', quantity='$quantity', unit_conversion='$unit_conversion',
package_conversion='$package_conversion', case_conversion='$case_conversion'";
} else {
$query = "update jeoXillityCrm_product_stock set quantity='$quantity', unit_conversion='$unit_conversion', package_conversion='$package_conversion',
case_conversion='$case_conversion' where id='$actionId' and product_id='$product'";
}
// echo $query;
// exit;
runQuery($query);
header("Location: ?" . generateUrlParams_return(["m" => "Data was saved successfully!", "type" => "success"]));
exit();
}
if (isset($_GET['product_id'])) {
$productId = $_GET['product_id'];
// Query to fetch product details from the database
$query = "SELECT a.one_per_unit, a.one_per_package, a.one_per_case,b.unit_conversion,b.package_conversion,b.case_conversion,b.sale_quantity FROM jeoXillityCrm_products a
left join jeoXillityCrm_product_stock b on a.id=b.product_id WHERE a.id = '$productId'";
// echo $query; exit;
$productDetails = getRow($con, $query); // Assuming getRow returns a single row of data
// Return the product details as a JSON response
echo json_encode($productDetails);
exit;
}
?>
| Product |
Quantity |
Unit Conversion |
Package Conversion |
Case Conversion |
Date |
Actions |