SWAMPy

✎ CARVE FLESH

EDITING: AddOnsController.php

<?php
/**
 * Flora and Creations — Admin Add-Ons Controller
 */

namespace App\Controllers\AdminApi;

use App\Database;
use App\Utils\Response;
use App\Utils\Request;
use App\Utils\Validator;
use App\Utils\Request as RequestHelper;

class AddOnsController
{
    /**
     * GET /api/admin/add-ons
     */
    public function index(array $params): void
    {
        $db = Database::getConnection();
        $query = RequestHelper::query();

$sql = "SELECT * FROM add_ons WHERE 1=1";

if (isset($query['active'])) {
            $active = filter_var($query['active'], FILTER_VALIDATE_BOOLEAN);
            $sql .= " AND active = :active";
        }

$sql .= " ORDER BY name ASC";

$stmt = $db->prepare($sql);
        if (isset($query['active'])) {
            $stmt->bindValue(':active', $active ? 1 : 0, \PDO::PARAM_INT);
        }
        $stmt->execute();

$addOns = $stmt->fetchAll();
        Response::ok($addOns);
    }

/**
     * POST /api/admin/add-ons
     */
    public function store(array $params): void
    {
        $db = Database::getConnection();
        $body = RequestHelper::body();

$errors = Validator::make($body, [
            'name'  => 'required',
            'price' => 'required|numeric',
        ]);

if ($errors) {
            Response::validationError($errors);
        }

$stmt = $db->prepare("INSERT INTO add_ons (name, price, type, active) VALUES (:name, :price, :type, :active)");
        $stmt->execute([
            ':name'   => trim($body['name']),
            ':price'  => (float) $body['price'],
            ':type'   => $body['type'] ?? 'default',
            ':active' => ($body['active'] ?? true) ? 1 : 0,
        ]);

$addonId = $db->lastInsertId();
        $stmt = $db->prepare("SELECT * FROM add_ons WHERE id = :id");
        $stmt->execute([':id' => $addonId]);
        Response::created($stmt->fetch());
    }

/**
     * PUT /api/admin/add-ons/:id
     */
    public function update(array $params): void
    {
        $db = Database::getConnection();
        $addonId = (int) $params['id'];
        $body = RequestHelper::body();

$stmt = $db->prepare("SELECT id FROM add_ons WHERE id = :id");
        $stmt->execute([':id' => $addonId]);
        if (!$stmt->fetch()) {
            Response::notFound('Add-on not found.');
        }

$updates = [];
        $bindings = [':id' => $addonId];

if (isset($body['name']))   { $updates['name'] = 'name'; $bindings[':name'] = trim($body['name']); }
        if (isset($body['price']))  { $updates['price'] = 'price'; $bindings[':price'] = (float) $body['price']; }
        if (isset($body['type']))   { $updates['type'] = 'type'; $bindings[':type'] = $body['type']; }
        if (isset($body['active'])) { $updates['active'] = 'active'; $bindings[':active'] = $body['active'] ? 1 : 0; }

if (empty($updates)) {
            Response::badRequest('No fields to update.');
        }

$setClause = implode(', ', array_map(fn($col, $param) => "$col = :$param", array_keys($updates), array_values($updates)));
        $sql = "UPDATE add_ons SET $setClause WHERE id = :id";

$stmt = $db->prepare($sql);
        $stmt->execute($bindings);

$stmt = $db->prepare("SELECT * FROM add_ons WHERE id = :id");
        $stmt->execute([':id' => $addonId]);
        Response::ok($stmt->fetch());
    }

/**
     * DELETE /api/admin/add-ons/:id
     */
    public function destroy(array $params): void
    {
        $db = Database::getConnection();
        $addonId = (int) $params['id'];

$stmt = $db->prepare("DELETE FROM add_ons WHERE id = :id");
        $stmt->execute([':id' => $addonId]);

if ($stmt->rowCount() === 0) {
            Response::notFound('Add-on not found.');
        }

Response::noContent();
    }
}

CANCEL

Name	Type	Size	Modified	Actions
↩ ..	DIR	—	—
📄 AddOnsController.php	PHP	3.8 KB	2026-07-15 09:17	EDIT
📄 CategoriesController.php	PHP	4.5 KB	2026-07-15 09:17	EDIT
📄 CustomersController.php	PHP	3.6 KB	2026-07-15 09:17	EDIT
📄 DashboardController.php	PHP	5.3 KB	2026-07-15 09:17	EDIT
📄 DeliveryZonesController.php	PHP	3.1 KB	2026-07-15 09:17	EDIT
📄 OrdersController.php	PHP	10.9 KB	2026-07-15 10:29	EDIT
📄 ProductsController.php	PHP	18.6 KB	2026-07-15 10:57	EDIT
📄 SettingsController.php	PHP	4.8 KB	2026-07-15 12:04	EDIT
📄 StaffController.php	PHP	11.1 KB	2026-07-15 13:54	EDIT