/**
* Search for orders to review per website.
*/
public function searchOrdersForReview()
{
$websites = $this->helper->getwebsites(true);
foreach ($websites as $website) {
$apiEnabled = $this->helper->isEnabled($website);
if ($apiEnabled && $this->helper->getWebsiteConfig(\Dotdigitalgroup\Email\Helper\Config::XML_PATH_CONNECTOR_SYNC_ORDER_ENABLED, $website) && $this->helper->getOrderStatus($website) && $this->helper->getDelay($website)) {
$storeIds = $website->getStoreIds();
if (empty($storeIds)) {
continue;
}
$orderStatusFromConfig = $this->helper->getOrderStatus($website);
$delayInDays = $this->helper->getDelay($website);
$campaignCollection = $this->campaignCollection->create()->addFieldToFilter('event_name', 'Order Review');
$campaignOrderIds = $campaignCollection->getColumnValues('order_increment_id');
$fromTime = $this->date;
$fromTime->subDay($delayInDays);
$toTime = clone $fromTime;
$to = $toTime->toString('YYYY-MM-dd HH:mm:ss');
$from = $fromTime->subHour(2)->toString('YYYY-MM-dd HH:mm:ss');
$created = ['from' => $from, 'to' => $to, 'date' => true];
$collection = $this->orderCollection->create()->addFieldToFilter('main_table.status', $orderStatusFromConfig)->addFieldToFilter('main_table.created_at', $created)->addFieldToFilter('main_table.store_id', ['in' => $storeIds]);
if (!empty($campaignOrderIds)) {
$collection->addFieldToFilter('main_table.increment_id', ['nin' => $campaignOrderIds]);
}
//process rules on collection
$collection = $this->rulesFactory->create()->process($collection, \Dotdigitalgroup\Email\Model\Rules::REVIEW, $website->getId());
if ($collection->getSize()) {
$this->reviewCollection[$website->getId()] = $collection;
}
}
}
}
