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