<?php

if (! $_SERVER['REQUEST_METHOD'] === 'POST') {
    exit("not permitted bad request");
}

//getting the request data
$requestData = json_decode(file_get_contents('php://input'), true);

// connecting to the db
$servername = "10.80.0.11";
$username = "root";
$password = "cr4ftd4t4b4s3";
$dbname = "support";
try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
    echo(json_encode("DB ERROR $e"));
}

if ($requestData["method"] == "create"){
    $stmt = $conn->prepare("INSERT INTO support
                                    (name, issue, mail, whatsapp, sms)
                                VALUES (:name, :issue, :mail, :whatsapp, :sms)
                                ");
    $stmt->bindParam(':name', $requestData["name"]);
    $stmt->bindParam(':issue', $requestData["anliegen"]);
    $stmt->bindParam(':mail', $requestData["inputValues"]["mail"]);
    $stmt->bindParam(':whatsapp', $requestData["inputValues"]["whatsapp"]);
    $stmt->bindParam(':sms', $requestData["inputValues"]["sms"]);
    $success = $stmt->execute();

    if ($success) {
        echo(json_encode("Die Anweisung wurde erfolgreich ausgeführt."));
    } else {
        echo(json_encode("Es gab ein Problem bei der Ausführung der Anweisung."));
    }
}

if ($requestData["method"] == "read") {
    //reading the unseen issues
    $stmt = $conn->prepare("SELECT *
                            FROM support
                            WHERE deleted = false && seen = false
                            ORDER BY created_at");
    $stmt->execute();
    $unseen = $stmt->fetchAll(PDO::FETCH_ASSOC);

    //reading the seen issues
    $stmt = $conn->prepare("SELECT *
                            FROM support
                            WHERE deleted = false && seen = true
                            ORDER BY created_at");
    $stmt->execute();
    $seen = $stmt->fetchAll(PDO::FETCH_ASSOC);

    $response["unseen"] = $unseen;
    $response["seen"] = $seen;
    echo(json_encode($response));
}

if ($requestData["method"] == "update") {
    if (isset($requestData["read"])) {
        $stmt = $conn->prepare("
                                    UPDATE support
                                    SET seen = 1
                                    WHERE id = :id;");
        $stmt->bindParam(':id', $requestData["id"]);
        $success = $stmt->execute();
    }

    if ($success) {
        echo(json_encode("Die Anweisung wurde erfolgreich ausgeführt."));
    } else {
        echo(json_encode("Es gab ein Problem bei der Ausführung der Anweisung."));
    }
}

if ($requestData["method"] == "delete") {
    if (! isset($requestData["cleanup"])) {
        $stmt = $conn->prepare("
                                    UPDATE support
                                    SET deleted = 1
                                    WHERE id = :id;");
        $stmt->bindParam(':id', $requestData["id"]);
        $success = $stmt->execute();
    }

    if ($success) {
        echo(json_encode("Die Anweisung wurde erfolgreich ausgeführt."));
    } else {
        echo(json_encode("Es gab ein Problem bei der Ausführung der Anweisung."));
    }
}

$conn = null;

?>