请求帮助：实现productPrice经floor()取整后自动填充至productRewards

Hey there! Let's figure out how to auto-fill your productRewards field with the floored value of productPrice whenever an admin enters a price in the console form. Here are three practical approaches you can pick based on your tech stack and needs:

1. Frontend Real-Time Update (Instant Feedback) #

If you want admins to see the productRewards value populate immediately as they type, JavaScript is your friend. This gives a smooth user experience and prevents manual entry mistakes.

First, set up your form inputs with unique IDs, then add a listener to the price input:

<!-- Admin form inputs -->
<label>Product Price:</label>
<input type="number" step="0.01" id="productPrice" name="productPrice" placeholder="e.g., 199.99">

<label>Product Rewards:</label>
<input type="number" id="productRewards" name="productRewards" readonly>

<script>
// Get references to the input fields
const priceInput = document.getElementById('productPrice');
const rewardsInput = document.getElementById('productRewards');

// Listen for input changes on the price field
priceInput.addEventListener('input', () => {
  const priceValue = parseFloat(priceInput.value);
  // Only update if the input is a valid number
  if (!isNaN(priceValue)) {
    rewardsInput.value = Math.floor(priceValue);
  } else {
    // Clear the rewards field if price is invalid
    rewardsInput.value = '';
  }
});
</script>

Pro tip: Mark productRewards as readonly so admins can't manually edit it—this ensures the value always comes from the calculated floor of the price.

2. Backend Fallback (Secure Data Validation) #

Frontend code can be bypassed, so it's smart to add a backend layer to enforce the logic. This guarantees that even if someone submits data directly (without using the form), productRewards gets set correctly.

Here's an example using PHP (adjust for your backend language like Node.js, Python, etc.):

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
  $productPrice = $_POST['productPrice'] ?? null;
  $productRewards = null;

  // Validate and calculate the floored value
  if ($productPrice !== null && is_numeric($productPrice)) {
    $productRewards = floor((float)$productPrice);
  }

  // Insert into the products table (using PDO for safety)
  $pdo = new PDO('mysql:host=your_host;dbname=your_db', 'user', 'password');
  $stmt = $pdo->prepare('INSERT INTO products (productPrice, productRewards) VALUES (:price, :rewards)');
  $stmt->execute([
    ':price' => $productPrice,
    ':rewards' => $productRewards
  ]);
}

This way, you double down on data integrity—no matter how the data gets sent to the server, the rewards value is always calculated correctly.

3. Database Trigger (Persistent Enforcement) #

If you want this logic to apply to all inserts/updates (including API imports, bulk scripts, etc.), a database trigger is the most reliable option. It runs directly in the database, so you don't have to rely on frontend or backend code.

For MySQL, create these triggers:

-- Trigger for new inserts
DELIMITER //
CREATE TRIGGER auto_set_rewards_on_insert BEFORE INSERT ON products
FOR EACH ROW
BEGIN
  SET NEW.productRewards = FLOOR(NEW.productPrice);
END //
DELIMITER ;

-- Trigger for updates (if you want rewards to update when price changes)
DELIMITER //
CREATE TRIGGER auto_update_rewards_on_change BEFORE UPDATE ON products
FOR EACH ROW
BEGIN
  SET NEW.productRewards = FLOOR(NEW.productPrice);
END //
DELIMITER ;

Now, every time a row is added or the productPrice is updated, productRewards will automatically be set to the floored price—no extra code needed elsewhere.

Which Should You Choose? #

• Frontend + Backend: Best for user experience + data safety
• Database Trigger: Best for universal enforcement across all data entry methods

内容的提问来源于stack exchange，提问作者Daz Lee