/**
* Check usage of template code in other templates
*
* @param \Magento\Newsletter\Model\Template $template
* @return boolean
*/
public function checkCodeUsage(\Magento\Newsletter\Model\Template $template)
{
if ($template->getTemplateActual() != 0 || is_null($template->getTemplateActual())) {
$bind = ['template_id' => $template->getId(), 'template_code' => $template->getTemplateCode(), 'template_actual' => 1];
$select = $this->_getReadAdapter()->select()->from($this->getMainTable(), new \Zend_Db_Expr('COUNT(template_id)'))->where('template_id != :template_id')->where('template_code = :template_code')->where('template_actual = :template_actual');
$countOfCodes = $this->_getReadAdapter()->fetchOne($select, $bind);
return $countOfCodes > 0;
} else {
return false;
}
}
