<?php
include "include.php";
if(isset($_POST['state']) && isset($_POST['order_id']))
{
    $futureState = intval($_POST['state']);
    $requestId = intval($_POST['order_id']);
    $sqlRequest = $db->prepare('SELECT state FROM requests WHERE id = ?');
    $sqlRequest->execute([$requestId]);
    $result = $sqlRequest->fetchAll();
    $currentState = (isset($result[0][0]) ? $result[0][0] : null);
    $state = intval($_POST['state']);
    if($requestId > 0 && $currentState != null)
    {
        switch($state)
        {
            case 1: //Success
                if($currentState == 2)
                {
                    $sqlRequest = $db->prepare('UPDATE requests SET state = 3 WHERE id = ?');
                    $sqlRequest->execute([$requestId]);
                }
                break;
            case 2: //Refund
                if($currentState < 3)
                {
                    $sqlRequest = $db->prepare('UPDATE requests SET state = 4 WHERE id = ?');
                    $sqlRequest->execute([$requestId]);
                }
                break;
            case 3: // No refund (don't have the item)
                if($currentState < 3)
                {
                    $sqlRequest = $db->prepare('UPDATE requests SET state = 5 WHERE id = ?');
                    $sqlRequest->execute([$requestId]);
                }
        }
    }
}
?>