<?php
include_once "../../include/DB.php";

$AssetID="";

if (isset($_POST["AssetID"]) && !empty($_POST["AssetID"])) {
   $AssetID=$_POST["AssetID"];
}

$assetsql = "SELECT *,
asset.CreatedAt AS AssetCreatedAt,
asset.UpdatedAt AS AssetUpdatedAt,
assetcategory.CreatedAt AS AssetCategoryCreatedAt,
assetcategory.UpdatedAt AS AssetCategoryUpdatedAt
FROM asset asset
JOIN assetcategory assetcategory ON assetcategory.AssetCategoryID =asset.AssetCategoryID
WHERE asset.AssetID='$AssetID'";
$assetresult = $conn->query($assetsql);

$assetlistArray= [];
if ($assetresult!== false && $assetresult->num_rows > 0) {
    while($sassetrow = $assetresult->fetch_assoc()) {
        $assetvalue = array(
            "AssetID"=>$sassetrow["AssetID"],
            "AssetName"=>$sassetrow["AssetName"],
            "AssetCategoryID"=>(int)$sassetrow["AssetCategoryID"],
            "AssetCategory"=>array(
                "AssetCategoryID"=>(int)$sassetrow["AssetCategoryID"],
                "AssetCategoryTitle"=>$sassetrow["AssetCategoryTitle"],
                "AssetCategoryCreatedAt"=>$sassetrow["AssetCategoryCreatedAt"],
                "AssetCategoryUpdatedAt"=>$sassetrow["AssetCategoryUpdatedAt"],
            ),
            "IsInServiceCenter"=>(int)$sassetrow["IsInServiceCenter"],
            "AssetCreatedAt"=>$sassetrow["AssetCreatedAt"],
            "AssetUpdatedAt"=>$sassetrow["AssetUpdatedAt"],
        );
        $assetlistArray[]= $assetvalue;
    }
    $count = count($assetlistArray);
    if($count==1){
        // Use json_encode() function
        $json = json_encode($assetlistArray[0]);
    }else {
        // Use json_encode() function
        $json = json_encode($assetlistArray);
    }
}else { 
    http_response_code(404);  
    $errorMesage= $conn->error;
    if ($errorMesage=="") {
        $errorMesage = "AssetID not available";
        if ($AssetID=="") {
            $errorMesage = "AssetID is empty";
        }
    }
    // Declare an array with error message 
    $value = array(
        "Message"=>"Failed to get data",
        "Error"=>$errorMesage
    );
    // Use json_encode() function
    $json = json_encode($value);
}
// Display the output
echo($json);
$conn->close();