/**
* Check usage of template in queue
*
* @param \Magento\Newsletter\Model\Template $template
* @return boolean
*/
public function checkUsageInQueue(\Magento\Newsletter\Model\Template $template)
{
if ($template->getTemplateActual() !== 0 && !$template->getIsSystem()) {
$select = $this->_getReadAdapter()->select()->from($this->getTable('newsletter_queue'), new \Zend_Db_Expr('COUNT(queue_id)'))->where('template_id = :template_id');
$countOfQueue = $this->_getReadAdapter()->fetchOne($select, ['template_id' => $template->getId()]);
return $countOfQueue > 0;
} elseif ($template->getIsSystem()) {
return false;
} else {
return true;
}
}
