<?php
$servername = "localhost:3306";
$username = "root";
$password = "root";
$dbname = "fsharkc_efetasks";

$itemId = $_REQUEST['itemId'];

//Classes
class HorasFenix {
    public $dataLancada= '';
    public $horasTrabalhadas= '';
}

class Fenix {
    public $horasFenix = '';
    public $etc = '';
}
//Classes - FIM

// Instâncicas
$fenix      = new Fenix;
$horasFenix = new HorasFenix;

// Variaveis
$createDate   = '';
$deadLineDate = '';

//MySQL==============================================================================================================================
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$sqlEverisHours = "SELECT itemId,date,incurred,etc FROM everis_hours_fenix WHERE itemId = $itemId";

$sqlMaxEtc = "SELECT etc
FROM everis_hours_fenix AS a
WHERE date = (
    SELECT MAX(date)
    FROM everis_hours_fenix AS b
    WHERE a.itemId = $itemId
)";

$resultEverisHours = mysqli_query($conn, $sqlEverisHours);
$resultMaxEtc      = mysqli_query($conn, $sqlMaxEtc);

// Cria array
$arrayHF = array();

// SELECT EVERIS HOURS
if (mysqli_num_rows($resultEverisHours) > 0) {

    // output data of each row
    while($row = mysqli_fetch_assoc($resultEverisHours)) {

        // Objeto horasFenix
        $horasFenix = "";
        $horasFenix->dataLancada      = date("d-m-Y", strtotime($row["date"]));
        $horasFenix->horasTrabalhadas = $row["incurred"];

        // Insere no array
        array_push($arrayHF, $horasFenix);
    }
} else {
    echo "0 results - SELECT EVERIS HOURS";
}

// SELECT MAX DATE ETC
if (mysqli_num_rows($resultMaxEtc) > 0) {

    // output data of each row
    while($row = mysqli_fetch_assoc($resultMaxEtc)) {

        $fenix->etc = $row["etc"];
    }
} else {
    echo "0 results - SELECT MAX DATE ETC";
}
// fecha conexão mysql
mysqli_close($conn);
//MySQL - FIM========================================================================================================================

// Objeto fenix
$fenix->horasFenix = $arrayHF;

$myJSON = json_encode($fenix);
echo $myJSON;
?>