items.php 5.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152
  1. <?php
  2. header("Access-Control-Allow-Origin: *");
  3. header("Content-Type: application/json; charset=UTF-8");
  4. header("Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS");
  5. header("Access-Control-Allow-Headers: Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With");
  6. if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
  7. exit(0);
  8. }
  9. require_once '../config/database.php';
  10. require_once '../models/Item.php';
  11. $database = new Database();
  12. $db = $database->getConnection();
  13. $item = new Item($db);
  14. $request_method = $_SERVER['REQUEST_METHOD'];
  15. switch($request_method) {
  16. case 'GET':
  17. if(isset($_GET['id'])) {
  18. $item->id = $_GET['id'];
  19. $item->readOne();
  20. if($item->name != null) {
  21. $item_arr = array(
  22. "id" => $item->id,
  23. "name" => $item->name,
  24. "description" => $item->description,
  25. "serial_number" => $item->serial_number,
  26. "picture" => $item->picture,
  27. "quantity" => $item->quantity,
  28. "price" => $item->price,
  29. "created_at" => $item->created_at,
  30. "updated_at" => $item->updated_at
  31. );
  32. http_response_code(200);
  33. echo json_encode($item_arr);
  34. } else {
  35. http_response_code(404);
  36. echo json_encode(array("message" => "Item not found."));
  37. }
  38. } else {
  39. $stmt = $item->read();
  40. $num = $stmt->rowCount();
  41. if($num > 0) {
  42. $items_arr = array();
  43. $items_arr["records"] = array();
  44. while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
  45. extract($row);
  46. $item_item = array(
  47. "id" => $id,
  48. "name" => $name,
  49. "description" => $description,
  50. "serial_number" => $serial_number,
  51. "picture" => $picture,
  52. "quantity" => $quantity,
  53. "price" => $price,
  54. "created_at" => $created_at,
  55. "updated_at" => $updated_at
  56. );
  57. array_push($items_arr["records"], $item_item);
  58. }
  59. http_response_code(200);
  60. echo json_encode($items_arr);
  61. } else {
  62. http_response_code(200);
  63. echo json_encode(array("records" => array()));
  64. }
  65. }
  66. break;
  67. case 'POST':
  68. $data = json_decode(file_get_contents("php://input"));
  69. if(!empty($data->name) && !empty($data->quantity) && !empty($data->price)) {
  70. $item->name = $data->name;
  71. $item->description = $data->description ?? '';
  72. $item->serial_number = $data->serial_number ?? '';
  73. $item->picture = $data->picture ?? '';
  74. $item->quantity = $data->quantity;
  75. $item->price = $data->price;
  76. if($item->create()) {
  77. http_response_code(201);
  78. echo json_encode(array("message" => "Item was created."));
  79. } else {
  80. http_response_code(503);
  81. echo json_encode(array("message" => "Unable to create item."));
  82. }
  83. } else {
  84. http_response_code(400);
  85. echo json_encode(array("message" => "Unable to create item. Data is incomplete."));
  86. }
  87. break;
  88. case 'PUT':
  89. $data = json_decode(file_get_contents("php://input"));
  90. if(!empty($data->id) && !empty($data->name) && !empty($data->quantity) && !empty($data->price)) {
  91. $item->id = $data->id;
  92. $item->name = $data->name;
  93. $item->description = $data->description ?? '';
  94. $item->serial_number = $data->serial_number ?? '';
  95. $item->picture = $data->picture ?? '';
  96. $item->quantity = $data->quantity;
  97. $item->price = $data->price;
  98. if($item->update()) {
  99. http_response_code(200);
  100. echo json_encode(array("message" => "Item was updated."));
  101. } else {
  102. http_response_code(503);
  103. echo json_encode(array("message" => "Unable to update item."));
  104. }
  105. } else {
  106. http_response_code(400);
  107. echo json_encode(array("message" => "Unable to update item. Data is incomplete."));
  108. }
  109. break;
  110. case 'DELETE':
  111. if(isset($_GET['id'])) {
  112. $item->id = $_GET['id'];
  113. if($item->delete()) {
  114. http_response_code(200);
  115. echo json_encode(array("message" => "Item was deleted."));
  116. } else {
  117. http_response_code(503);
  118. echo json_encode(array("message" => "Unable to delete item."));
  119. }
  120. } else {
  121. http_response_code(400);
  122. echo json_encode(array("message" => "Unable to delete item. ID is missing."));
  123. }
  124. break;
  125. default:
  126. http_response_code(405);
  127. echo json_encode(array("message" => "Method not allowed."));
  128. break;
  129. }
  130. ?>