62 lines
1.9 KiB
PHP
62 lines
1.9 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
namespace A2G\A2gTravelBlog\Domain\Repository;
|
|
|
|
use TYPO3\CMS\Core\Utility\MathUtility;
|
|
|
|
/**
|
|
* This file is part of the "Products" Extension for TYPO3 CMS.
|
|
*
|
|
* For the full copyright and license information, please read the
|
|
* LICENSE.txt file that was distributed with this source code.
|
|
*
|
|
* (c) 2021 Raphael Martin <raphy.martin@gmail.com>, none
|
|
*/
|
|
|
|
/**
|
|
* The repository for TravelPost
|
|
*/
|
|
class TravelPostRepository extends \TYPO3\CMS\Extbase\Persistence\Repository {
|
|
|
|
/**
|
|
* @var array
|
|
*/
|
|
protected $defaultOrderings = [
|
|
'crdate' => \TYPO3\CMS\Extbase\Persistence\QueryInterface::ORDER_DESCENDING
|
|
];
|
|
|
|
static protected function mapInt($value){
|
|
if(MathUtility::canBeInterpretedAsInteger($value)){
|
|
return (int)$value;
|
|
}
|
|
return null;
|
|
}
|
|
|
|
public function getFromCategoryUids(array $uids){
|
|
$uidsFiltered = array_filter(array_map('self::mapInt', $uids));
|
|
$query = $this->createQuery();
|
|
$query->matching($query->in('categories.uid', $uidsFiltered));
|
|
return $query->execute();
|
|
}
|
|
public function getFromAuthorUids(array $uids){
|
|
$uidsFiltered = array_filter(array_map('self::mapInt', $uids));
|
|
$query = $this->createQuery();
|
|
$query->matching($query->in('authors.uid', $uidsFiltered));
|
|
return $query->execute();
|
|
}
|
|
public function getFromTagUids(array $uids){
|
|
$uidsFiltered = array_filter(array_map('self::mapInt', $uids));
|
|
$query = $this->createQuery();
|
|
$query->matching($query->in('tags.uid', $uidsFiltered));
|
|
return $query->execute();
|
|
}
|
|
|
|
public function initializeObject() {
|
|
$querySettings = $this->objectManager->get(\TYPO3\CMS\Extbase\Persistence\Generic\Typo3QuerySettings::class);
|
|
$querySettings->setRespectStoragePage(false);
|
|
$this->setDefaultQuerySettings($querySettings);
|
|
}
|
|
}
|