prepare("INSERT INTO pumps (name, bunk_id) VALUES (?, ?)"); $stmt->execute([$name, $bunk_id]); $_SESSION['notification'] = ['text' => 'Pump added successfully!', 'type' => 'success']; } catch (PDOException $e) { $_SESSION['notification'] = ['text' => 'Error adding pump: ' . $e->getMessage(), 'type' => 'danger']; } } else { $_SESSION['notification'] = ['text' => 'Pump name and bunk are required.', 'type' => 'warning']; } } // Edit Pump elseif (isset($_POST['edit_pump'])) { $id = $_POST['pump_id']; $name = trim($_POST['name']); $bunk_id = $_POST['bunk_id']; if (!empty($name) && !empty($bunk_id) && !empty($id)) { try { $stmt = $db->prepare("UPDATE pumps SET name = ?, bunk_id = ? WHERE id = ?"); $stmt->execute([$name, $bunk_id, $id]); $_SESSION['notification'] = ['text' => 'Pump updated successfully!', 'type' => 'success']; } catch (PDOException $e) { $_SESSION['notification'] = ['text' => 'Error updating pump: ' . $e->getMessage(), 'type' => 'danger']; } } else { $_SESSION['notification'] = ['text' => 'Pump name, bunk and ID are required.', 'type' => 'warning']; } } header("Location: pumps.php"); exit; } // Soft Delete Pump if (isset($_GET['action']) && $_GET['action'] === 'delete' && isset($_GET['id'])) { try { $db = db(); $stmt = $db->prepare("UPDATE pumps SET deleted_at = NOW() WHERE id = ?"); $stmt->execute([$_GET['id']]); $_SESSION['notification'] = ['text' => 'Pump deleted successfully!', 'type' => 'success']; } catch (PDOException $e) { $_SESSION['notification'] = ['text' => 'Error deleting pump: ' . $e->getMessage(), 'type' => 'danger']; } header("Location: pumps.php"); exit; } if (isset($_SESSION['notification'])) { $notification = $_SESSION['notification']; unset($_SESSION['notification']); } $db = db(); $pumps = $db->query("SELECT p.*, b.name as bunk_name FROM pumps p JOIN bunks b ON p.bunk_id = b.id WHERE p.deleted_at IS NULL ORDER BY p.created_at DESC")->fetchAll(PDO::FETCH_ASSOC); $bunks = $db->query("SELECT * FROM bunks WHERE deleted_at IS NULL")->fetchAll(PDO::FETCH_ASSOC); $page_title = "Pump Management"; ?> <?= htmlspecialchars($page_title) ?> - Petrol Pump Management

Name Bunk Created At Actions