38 lines
1.5 KiB
PHP
38 lines
1.5 KiB
PHP
<?php
|
|
header('Content-Type: application/json');
|
|
require_once __DIR__ . '/../db/config.php';
|
|
|
|
$response = ['success' => false, 'message' => 'Invalid request'];
|
|
$pdoconn = db();
|
|
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
|
|
$data = json_decode(file_get_contents('php://input'), true);
|
|
|
|
if (empty($data['nome']) || empty($data['status'])) {
|
|
$response['message'] = 'Nome and status are required.';
|
|
} else {
|
|
try {
|
|
$sql = "INSERT INTO equipamentos (nome, categoria, numero_serie, status) VALUES (:nome, :categoria, :numero_serie, :status)";
|
|
$stmt = $pdoconn->prepare($sql);
|
|
$stmt->execute([
|
|
':nome' => $data['nome'],
|
|
':categoria' => $data['categoria'] ?? null,
|
|
':numero_serie' => $data['numero_serie'] ?? null,
|
|
':status' => $data['status']
|
|
]);
|
|
$response = ['success' => true, 'message' => 'Equipamento adicionado com sucesso!'];
|
|
} catch (PDOException $e) {
|
|
$response['message'] = 'Database error: ' . $e->getMessage();
|
|
}
|
|
}
|
|
} elseif ($_SERVER['REQUEST_METHOD'] === 'GET') {
|
|
try {
|
|
$stmt = $pdoconn->query("SELECT id, nome, categoria, numero_serie, status FROM equipamentos ORDER BY created_at DESC");
|
|
$equipamentos = $stmt->fetchAll();
|
|
$response = ['success' => true, 'data' => $equipamentos];
|
|
} catch (PDOException $e) {
|
|
$response['message'] = 'Database error: ' . $e->getMessage();
|
|
}
|
|
}
|
|
|
|
echo json_encode($response);
|
|
?>
|