check_asset.php 2.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. <?php
  2. include_once "../../include/DB.php";
  3. $AssetID="";
  4. if (isset($_POST["AssetID"]) && !empty($_POST["AssetID"])) {
  5. $AssetID=$_POST["AssetID"];
  6. }
  7. $assetsql = "SELECT *,
  8. asset.CreatedAt AS AssetCreatedAt,
  9. asset.UpdatedAt AS AssetUpdatedAt,
  10. assetcategory.CreatedAt AS AssetCategoryCreatedAt,
  11. assetcategory.UpdatedAt AS AssetCategoryUpdatedAt
  12. FROM asset asset
  13. JOIN assetcategory assetcategory ON assetcategory.AssetCategoryID =asset.AssetCategoryID
  14. WHERE asset.AssetID='$AssetID'";
  15. $assetresult = $conn->query($assetsql);
  16. $assetlistArray= [];
  17. if ($assetresult!== false && $assetresult->num_rows > 0) {
  18. while($sassetrow = $assetresult->fetch_assoc()) {
  19. $assetvalue = array(
  20. "AssetID"=>$sassetrow["AssetID"],
  21. "AssetName"=>$sassetrow["AssetName"],
  22. "AssetCategoryID"=>(int)$sassetrow["AssetCategoryID"],
  23. "AssetCategory"=>array(
  24. "AssetCategoryID"=>(int)$sassetrow["AssetCategoryID"],
  25. "AssetCategoryTitle"=>$sassetrow["AssetCategoryTitle"],
  26. "AssetCategoryCreatedAt"=>$sassetrow["AssetCategoryCreatedAt"],
  27. "AssetCategoryUpdatedAt"=>$sassetrow["AssetCategoryUpdatedAt"],
  28. ),
  29. "IsInServiceCenter"=>(int)$sassetrow["IsInServiceCenter"],
  30. "AssetCreatedAt"=>$sassetrow["AssetCreatedAt"],
  31. "AssetUpdatedAt"=>$sassetrow["AssetUpdatedAt"],
  32. );
  33. $assetlistArray[]= $assetvalue;
  34. }
  35. $count = count($assetlistArray);
  36. if($count==1){
  37. // Use json_encode() function
  38. $json = json_encode($assetlistArray[0]);
  39. }else {
  40. // Use json_encode() function
  41. $json = json_encode($assetlistArray);
  42. }
  43. }else {
  44. http_response_code(404);
  45. $errorMesage= $conn->error;
  46. if ($errorMesage=="") {
  47. $errorMesage = "AssetID not available";
  48. if ($AssetID=="") {
  49. $errorMesage = "AssetID is empty";
  50. }
  51. }
  52. // Declare an array with error message
  53. $value = array(
  54. "Message"=>"Failed to get data",
  55. "Error"=>$errorMesage
  56. );
  57. // Use json_encode() function
  58. $json = json_encode($value);
  59. }
  60. // Display the output
  61. echo($json);
  62. $conn->close();