/**
* 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;
}
