/**
* {@inheritdoc}
*/
public function scheduleForChannelAndLocale(ChannelInterface $channel, LocaleInterface $locale)
{
$sql = <<<SQL
DELETE c FROM pim_catalog_completeness c
WHERE c.channel_id = :channel_id
AND c.locale_id = :locale_id
SQL;
$sql = $this->applyTableNames($sql);
$stmt = $this->connection->prepare($sql);
$stmt->bindValue('channel_id', $channel->getId());
$stmt->bindValue('locale_id', $locale->getId());
$stmt->execute();
}
/**
* {@inheritdoc}
*/
public function scheduleForChannelAndLocale(ChannelInterface $channel, LocaleInterface $locale)
{
$productQb = $this->documentManager->createQueryBuilder($this->productClass);
$pullExpr = $productQb->expr()->addAnd($productQb->expr()->field('channel')->equals($channel->getId()))->addAnd($productQb->expr()->field('locale')->equals($locale->getId()));
$productQb->update()->multiple(true)->field(sprintf('normalizedData.completenesses.%s-%s', $channel->getCode(), $locale->getCode()))->unsetField()->field('completenesses')->pull($pullExpr)->getQuery()->execute();
}
