/** * Gets a inventory * * @return [InventoryEntity] List of items */ public function getItems() { $sql = "SELECT * FROM Inventory"; $stmt = $this->db->query($sql); $results = []; while ($row = $stmt->fetch()) { $inv_item = new InventoryEntity($row); $item_mapper = new ItemMapper($this->db); $item = $item_mapper->getItemById($inv_item->getId()); $inv_item->setItem($item); $results[] = $inv_item; } return $results; }
$data['id'] = filter_var($post_data['id'], FILTER_SANITIZE_STRING); $data['name'] = filter_var($post_data['name'], FILTER_SANITIZE_STRING); $data['color'] = filter_var($post_data['color'], FILTER_SANITIZE_STRING); $mapper = new ItemMapper($this->db); $item = $mapper->getItemById($data['id']); $item->setName($data['name']); $item->setColor($data['color']); $mapper->update($item); $response = $response->withRedirect("/index.php/items"); return $response; }); // Delete Item $app->get('/item/{id}/delete', function ($request, $response, $args) { $id = (int) $args['id']; $mapper = new ItemMapper($this->db); $item = $mapper->getItemById($id); $this->logger->info("Deleting Item " . $id); $mapper->delete($item); $response = $response->withRedirect("/index.php/items"); return $response; }); /**********************IVENTORY**********************/ // Inventory $app->get('/inventory', function ($request, $response, $args) { $this->logger->info("Inventory page"); $mapper = new InventoryMapper($this->db); $items = $mapper->getItems(); return $this->renderer->render($response, 'inventory/inventory.phtml', [$args, "inventoryItems" => $items]); }); // Add Item GET $app->get('/inventory/add', function ($request, $response, $args) {