SWAMPy

✎ CARVE FLESH

EDITING: packages.php

<?php
require_once '../config.php';

header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: GET, PATCH, DELETE, OPTIONS');
header('Access-Control-Allow-Headers: Content-Type, Authorization');

if ($_SERVER['REQUEST_METHOD'] === 'OPTIONS') {
    exit;
}

authenticate();

$db = getDbConnection();
$method = $_SERVER['REQUEST_METHOD'];

if ($method === 'GET') {
    $tier = $_GET['filter_tier'] ?? 'all';
    $status = $_GET['filter_status'] ?? 'all';
    $search = $_GET['search'] ?? '';

$query = "SELECT * FROM package_leads WHERE 1=1";
    $params = [];

if ($tier !== 'all') {
        $query .= " AND tier = ?";
        $params[] = $tier;
    }

if ($status !== 'all') {
        $query .= " AND status = ?";
        $params[] = $status;
    }

if (!empty($search)) {
        $query .= " AND (name LIKE ? OR email LIKE ? OR org LIKE ?)";
        $searchTerm = "%$search%";
        $params = array_merge($params, [$searchTerm, $searchTerm, $searchTerm]);
    }

$query .= " ORDER BY created_at DESC";

$stmt = $db->prepare($query);
    $stmt->execute($params);
    sendJsonResponse($stmt->fetchAll());

} elseif ($method === 'PATCH') {
    $input = getJsonInput();
    $id = $input['id'] ?? null;
    $status = $input['status'] ?? null;

if (!$id || !$status) {
        sendJsonResponse(['success' => false, 'message' => 'ID and status are required'], 400);
    }

$stmt = $db->prepare("UPDATE package_leads SET status = ? WHERE id = ?");
    if ($stmt->execute([$status, $id])) {
        sendJsonResponse(['success' => true, 'message' => 'Package lead status updated.']);
    } else {
        sendJsonResponse(['success' => false, 'message' => 'Failed to update package lead status.'], 500);
    }

} elseif ($method === 'DELETE') {
    $input = getJsonInput();
    $id = $input['id'] ?? null;

if (!$id) {
        sendJsonResponse(['success' => false, 'message' => 'ID is required'], 400);
    }

$stmt = $db->prepare("DELETE FROM package_leads WHERE id = ?");
    if ($stmt->execute([$id])) {
        sendJsonResponse(['success' => true, 'message' => 'Package lead deleted.']);
    } else {
        sendJsonResponse(['success' => false, 'message' => 'Failed to delete package lead.'], 500);
    }

} else {
    sendJsonResponse(['success' => false, 'message' => 'Method not allowed'], 405);
}
?>

CANCEL

Name	Type	Size	Modified	Actions
↩ ..	DIR	—	—
📄 applications.php	PHP	2.4 KB	2026-05-16 11:22	EDIT
📄 change-password.php	PHP	1.6 KB	2026-05-16 11:22	EDIT
📄 inquiries.php	PHP	2.4 KB	2026-05-16 11:22	EDIT
📄 login.php	PHP	1.1 KB	2026-05-16 11:22	EDIT
📄 packages.php	PHP	2.3 KB	2026-05-16 11:22	EDIT
📄 recent.php	PHP	1.3 KB	2026-05-16 11:22	EDIT
📄 settings.php	PHP	2.6 KB	2026-05-16 12:59	EDIT
📄 stats.php	PHP	1.5 KB	2026-05-16 11:22	EDIT