/** * @param StockItem $stockItem * @param int $page * @param int $pageSize * @param callable $callback * @return \Zend\Paginator\Paginator */ public function getPagedChangelog(StockItem $stockItem, $page = 1, $pageSize = 100, callable $callback = null) { $builder = $this->em()->createQueryBuilder(); $builder->select(LevelChange::ALIAS, Stock::ALIAS, StockItem::ALIAS, StockUnit::ALIAS, User::ALIAS)->from(LevelChange::class, LevelChange::ALIAS)->leftJoin(sprintf('%s.stock', LevelChange::ALIAS), Stock::ALIAS)->leftJoin(sprintf('%s.stock_item', Stock::ALIAS), StockItem::ALIAS)->leftJoin(sprintf('%s.storage_unit', StockItem::ALIAS), StockUnit::ALIAS)->leftJoin(sprintf('%s.corrector', LevelChange::ALIAS), User::ALIAS)->where(sprintf('%s.id = :id', StockItem::ALIAS))->orderBy(sprintf('%s.created_at', LevelChange::ALIAS), 'desc')->setParameter('id', $stockItem->getId()); if ($callback) { $callback($builder); } return $this->paginateQueryBuilder($builder, $page, $pageSize); }
/** * @return int|null */ public function getRecordIdOrNull() { return $this->existingRecord ? $this->existingRecord->getId() : null; }