<?php
include("../../core/headers.php");
include_once("../../core/initialize.php");

require_once(CONT_PATH . DS . "project.php");

$database = new Database();
$db = $database->connect();

$data = json_decode(file_get_contents('php://input'));

$project = new Project($db);
$project->status = !empty($data->status) ? $data->status : "";;
$result = $project->list();

$arr = array();
$arr["data"] = array();

while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
    extract($row);

    $item = array(
        "id" => $pid,
        "name" => $name,
        "liveAttributes" => $liveAttributes,
        "updatedDate" => date("d-m-Y", strtotime($updated_at)),
        "status" => $status,
    );

    array_push($arr["data"], $item);
}

echo json_encode($arr);