<?php
    header("Access-Control-Allow-Origin: *");
    header('Content-Type: application/json; charset=UTF-8');

    require_once("constants.php");

	require_once("repositories/CommentRepository.php");

	/*$servername = "localhost";
	$username = "smartcharging";
	$password = "LXRLBaEAuRr7M7jY";*/

	//$params = json_decode($_REQUEST["params"], true);

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

	$conn;
	$risposta = array();
	$comment_repo;
	$comments;

	try {
    	$conn = new PDO("mysql:host=".DB_SERVERNAME.";dbname=".DB_NAME, DB_USERNAME, DB_PASSWORD);
    	$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    	//echo "Connesso con successo al DB";
        
    	$comment_repo = new CommentRepository($conn);

        $countComments = $comment_repo->countComments($params["id"]);
    	$comments = $comment_repo->getComments($params["id"], $params["startIndex"], $params["length"]);		

        $risposta["count"] = $countComments;
        $risposta["id"] = $params["id"];
        $risposta["comments"] = $comments;

    }
	catch(PDOException $e)
    {
   		echo $e->getMessage();
        $risposta = createErrorMessage(1, "Errore DB");
   		/*$risposta["id"] = -1;
        $risposta["comments"] = null;*/
    }

    echo json_encode($risposta);
	$conn = null; //Close the connection to the DBMS

?>