Go back"); } // Handle form submission if ($_SERVER['REQUEST_METHOD'] === 'POST') { $sale_date = $_POST['sale_date']; $total_amount = floatval($_POST['total_amount']); $payment_mode = $_POST['payment_mode']; $notes = trim($_POST['notes']); // Validation if (empty($sale_date) || $total_amount <= 0) { $error = "Please fill all required fields with valid values"; } else { // Update sale $sql = "UPDATE sales SET sale_date = ?, total_amount = ?, payment_mode = ?, notes = ? WHERE sale_id = ?"; if (executeQuery($sql, "sdssi", [$sale_date, $total_amount, $payment_mode, $notes, $sale_id])) { logActivity($_SESSION['user_id'], 'UPDATE', 'sales', "Edited sale #$sale_id"); $success = "Sale entry updated successfully!"; // Reload sale data $sale = fetchSingle(" SELECT s.*, u.full_name as added_by_name FROM sales s JOIN users u ON s.added_by = u.user_id WHERE s.sale_id = ? ", "i", [$sale_id]); } else { $error = "Failed to update sale entry"; } } } $page_title = 'Edit Sale'; require_once __DIR__ . '/../includes/header.php'; ?>

Edit Sale Entry #

Current Details

₹

Edit Sale Entry

Cancel 🗑️ Delete Entry