/** * Return the items of an given Block * @param Block $block * * @return ItemBlock[] */ public static function findAllByBlock(Block $block) { $id = $block->getId(); $pdo = DatabaseManager::getConnection(); $stmt = $pdo->prepare("SELECT * FROM itemblock WHERE id_block = :id"); $stmt->bindParam(':id', $id, \PDO::PARAM_INT); $stmt->execute(); $array = $stmt->fetchAll(); if ($array == false) { return []; } $items = []; $api = ApiManager::getAPI(); foreach ($array as $data) { $item = new ItemBlock(); $item->setId($data['id']); $item->setItem($api->staticData()->getItem($data['item'], 'all')); $item->setCount(new \SplInt((int) $data['count'])); $item->setBlock($block); $items[] = $item; } return $items; }