/**
* Get product collection by channel and completness
*/
protected function DnDBuildByChannelAndCompleteness($channel, $isComplete)
{
$scope = $channel->getCode();
if (version_compare(Version::VERSION, '1.3.0', '<')) {
$qb = $this->repository->buildByScope($scope);
$rootAlias = $qb->getRootAlias();
$complete = $isComplete ? $qb->expr()->eq('pCompleteness.ratio', '100') : $qb->expr()->lt('pCompleteness.ratio', '100');
$expression = 'pCompleteness.product = ' . $rootAlias . ' AND ' . $complete . ' AND ' . $qb->expr()->eq('pCompleteness.channel', $channel->getId());
$rootEntity = current($qb->getRootEntities());
$completenessMapping = $this->entityManager->getClassMetadata($rootEntity)->getAssociationMapping('completenesses');
$completenessClass = $completenessMapping['targetEntity'];
$qb->innerJoin($completenessClass, 'pCompleteness', 'WITH', $expression);
$treeId = $channel->getCategory()->getId();
$expression = $qb->expr()->eq('pCategory.root', $treeId);
$qb->innerJoin($rootAlias . '.categories', 'pCategory', 'WITH', $expression);
} else {
$qb = $this->repository->buildByScope($scope);
$rootAlias = current($qb->getRootAliases());
$complete = $isComplete ? $qb->expr()->eq('pCompleteness.ratio', '100') : $qb->expr()->lt('pCompleteness.ratio', '100');
$expression = 'pCompleteness.product = ' . $rootAlias . ' AND ' . $complete . ' AND ' . $qb->expr()->eq('pCompleteness.channel', $channel->getId());
$rootEntity = current($qb->getRootEntities());
$completenessMapping = $this->entityManager->getClassMetadata($rootEntity)->getAssociationMapping('completenesses');
$completenessClass = $completenessMapping['targetEntity'];
$qb->innerJoin($completenessClass, 'pCompleteness', 'WITH', $expression);
$treeId = $channel->getCategory()->getId();
$expression = $qb->expr()->eq('pCategory.root', $treeId);
$qb->innerJoin($rootAlias . '.categories', 'pCategory', 'WITH', $expression);
}
return $qb;
}
