TemplateRepository.php

<?php

namespace SGalinski\SgMail\Domain\Repository;

/***************************************************************
 *  Copyright notice
 *
 *  (c) sgalinski Internet Services (https://www.sgalinski.de)
 *
 *  All rights reserved
 *
 *  This script is part of the TYPO3 project. The TYPO3 project is
 *  free software; you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation; either version 3 of the License, or
 *  (at your option) any later version.
 *
 *  The GNU General Public License can be found at
 *  http://www.gnu.org/copyleft/gpl.html.
 *
 *  This script is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  This copyright notice MUST APPEAR in all copies of the script!
 ***************************************************************/

use SGalinski\SgMail\Domain\Model\Template;
use TYPO3\CMS\Core\Database\DatabaseConnection;
use TYPO3\CMS\Extbase\Persistence\Generic\Typo3QuerySettings;

/**
 * Repository for the Template object
 */
class TemplateRepository extends AbstractRepository {
	/**
	 * @param string $extensionKey
	 * @param string $templateName
	 * @param string $language
	 *
	 * @return Template
	 */
	public function findOneByTemplate($extensionKey, $templateName, $language) {
		$query = $this->createQuery();

		$querySettings = $this->objectManager->get(Typo3QuerySettings::class);
		$querySettings->setRespectStoragePage(FALSE);

		$constraintsAnd[] = $query->equals('extension_key', $extensionKey);
		$constraintsAnd[] = $query->equals('template_name', $templateName);
		$constraintsAnd[] = $query->equals('language', $language);

		$query->matching(
			$query->logicalAnd($constraintsAnd)
		);

		return $query->execute()->getFirst();
	}

	/**
	 * Delete a Template
	 *
	 * @param $extensionKey
	 * @param $templateName
	 * @param $language
	 */
	public function deleteTemplate($extensionKey, $templateName, $language) {
		/** @var $databaseConnection DatabaseConnection */
		$databaseConnection = $GLOBALS['TYPO3_DB'];

		$tableName = 'tx_sgmail_domain_model_template';
		$where = 'extension_key = ' . $databaseConnection->fullQuoteStr($extensionKey, $tableName);
		$where.= ' AND template_name = ' . $databaseConnection->fullQuoteStr($templateName, $tableName);
		if ($language !== '') {
			$where.= ' AND language = ' . $databaseConnection->fullQuoteStr($language, $tableName);
		}
		$databaseConnection->exec_DELETEquery($tableName, $where);
	}
}