query( "SELECT id, name, current_stock, unit FROM products ORDER BY name ASC" )->fetchAll(); // Pre-select product when coming from product list $preselect_id = (int) ($_GET['product_id'] ?? 0); $success = ''; $error = ''; // Form sticky values $form = [ 'product_id' => $preselect_id, 'quantity' => '', 'notes' => '', ]; if ($_SERVER['REQUEST_METHOD'] === 'POST') { $form['product_id'] = (int) ($_POST['product_id'] ?? 0); $form['quantity'] = trim($_POST['quantity'] ?? ''); $form['notes'] = trim($_POST['notes'] ?? ''); $quantity = (int) $form['quantity']; if ($form['product_id'] <= 0) { $error = 'Please select a product.'; } elseif ($quantity <= 0) { $error = 'Quantity must be a positive number.'; } else { // Verify product exists $prod_stmt = $pdo->prepare("SELECT id, name, current_stock, unit FROM products WHERE id = ?"); $prod_stmt->execute([$form['product_id']]); $product = $prod_stmt->fetch(); if (!$product) { $error = 'Selected product not found.'; } else { // Increase stock $pdo->prepare("UPDATE products SET current_stock = current_stock + ? WHERE id = ?") ->execute([$quantity, $product['id']]); // Log the transaction $pdo->prepare( "INSERT INTO stock_transactions (product_id, user_id, quantity, type, notes) VALUES (?, ?, ?, 'added', ?)" )->execute([$product['id'], $_SESSION['user_id'], $quantity, $form['notes']]); $success = "Added {$quantity} {$product['unit']}(s) to \"{$product['name']}\". " . "New stock: " . ($product['current_stock'] + $quantity) . " {$product['unit']}(s)."; // Refresh product list to show updated stock $all_products = $pdo->query( "SELECT id, name, current_stock, unit FROM products ORDER BY name ASC" )->fetchAll(); // Reset form $form = ['product_id' => 0, 'quantity' => '', 'notes' => '']; } } } include 'includes/header.php'; ?>

Add Stock

Add Stock to Product
No products available. Add a product first.
Select a product above
Cancel