<?php
require_once 'Db.php';

$db = new Database('localhost', 'babyweb', 'root', '');

if ($_SERVER['REQUEST_METHOD'] === 'POST'){

    $_POST = json_decode(file_get_contents('php://input'), true);

    $red_score = $_POST['red_score'];
    $blue_score = $_POST['blue_score'];

    $red_p1 = $_POST['red_p1'];
    $red_p2 = $_POST['red_p2'] !== 'NULL' ? $_POST['red_p2'] : NULL;
    $blue_p1 = $_POST['blue_p1'];
    $blue_p2 = $_POST['blue_p2'] !== 'NULL' ? $_POST['blue_p2'] : NULL;

    $db->requestPushInsert("INSERT INTO matchs (red_score, blue_score, red_p1, red_p2, blue_p1, blue_p2, created_at) VALUES (:red_score, :blue_score, :red_p1, :red_p2, :blue_p1, :blue_p2, NOW())",
        [
            'red_score' => $red_score,
            'blue_score' => $blue_score,
            'red_p1' => $red_p1,
            'red_p2' => $red_p2,
            'blue_p1' => $blue_p1,
            'blue_p2' => $blue_p2,
        ]);

    if ($red_score > $blue_score){
        $db->requestPush("UPDATE players SET score = score + 10 WHERE id = :id", ['id' => $red_p1]);
        if ($red_p2 != NULL)
            $db->requestPush("UPDATE players SET score = score + 10 WHERE id = :id", ['id' => $red_p2]);

        $db->requestPush("UPDATE players SET score = score - 10 WHERE id = :id", ['id' => $blue_p1]);
        if ($blue_p2 != NULL)
            $db->requestPush("UPDATE players SET score = score - 10 WHERE id = :id", ['id' => $blue_p2]);
    }else{
        $db->requestPush("UPDATE players SET score = score + 10 WHERE id = :id", ['id' => $blue_p1]);
        if ($blue_p2 != NULL)
            $db->requestPush("UPDATE players SET score = score + 10 WHERE id = :id", ['id' => $blue_p2]);

        $db->requestPush("UPDATE players SET score = score - 10 WHERE id = :id", ['id' => $red_p1]);
        if ($red_p2 != NULL)
            $db->requestPush("UPDATE players SET score = score - 10 WHERE id = :id", ['id' => $red_p2]);
    }

    $players = $db->requestAll("SELECT * FROM players ORDER BY score");
    echo json_encode($players);
}