/**
* Returns an array of orderings created from a given demand object.
*
* @param Tx_MooxNews_Domain_Model_DemandInterface $demand
* @return array<\TYPO3\CMS\Extbase\Persistence\Generic\Qom\ConstraintInterface>
*/
protected function createOrderingsFromDemand(Tx_MooxNews_Domain_Model_DemandInterface $demand)
{
$orderings = array();
if (Tx_MooxNews_Utility_Validation::isValidOrdering($demand->getOrder(), $demand->getOrderByAllowed())) {
$orderList = \TYPO3\CMS\Core\Utility\GeneralUtility::trimExplode(',', $demand->getOrder(), TRUE);
if (!empty($orderList)) {
// go through every order statement
foreach ($orderList as $orderItem) {
list($orderField, $ascDesc) = \TYPO3\CMS\Core\Utility\GeneralUtility::trimExplode(' ', $orderItem, TRUE);
// count == 1 means that no direction is given
if ($ascDesc) {
$orderings[$orderField] = strtolower($ascDesc) == 'desc' ? \TYPO3\CMS\Extbase\Persistence\QueryInterface::ORDER_DESCENDING : \TYPO3\CMS\Extbase\Persistence\QueryInterface::ORDER_ASCENDING;
} else {
$orderings[$orderField] = \TYPO3\CMS\Extbase\Persistence\QueryInterface::ORDER_ASCENDING;
}
}
}
}
return $orderings;
}
/**
* Get the search constraints
*
* @param \TYPO3\CMS\Extbase\Persistence\QueryInterface $query
* @param Tx_MooxNews_Domain_Model_DemandInterface $demand
* @return array
* @throws UnexpectedValueException
*/
protected function getSearchConstraints(\TYPO3\CMS\Extbase\Persistence\QueryInterface $query, Tx_MooxNews_Domain_Model_DemandInterface $demand)
{
$constraints = array();
if ($demand->getSearch() === NULL) {
return $constraints;
}
/* @var $searchObject Tx_MooxNews_Domain_Model_Dto_Search */
$searchObject = $demand->getSearch();
$searchSubject = $searchObject->getSubject();
if (!empty($searchSubject)) {
$searchFields = \TYPO3\CMS\Core\Utility\GeneralUtility::trimExplode(',', $searchObject->getFields(), TRUE);
$searchConstraints = array();
if (count($searchFields) === 0) {
throw new UnexpectedValueException('No search fields defined', 1318497755);
}
foreach ($searchFields as $field) {
if (!empty($searchSubject)) {
$searchConstraints[] = $query->like($field, '%' . $searchSubject . '%');
}
}
if (count($searchConstraints)) {
$constraints[] = $query->logicalOr($searchConstraints);
}
}
$minimumDate = strtotime($searchObject->getMinimumDate());
if ($minimumDate) {
$field = $searchObject->getDateField();
if (empty($field)) {
throw new UnexpectedValueException('No date field is defined', 1396348732);
}
$constraints[] = $query->greaterThanOrEqual($field, $minimumDate);
}
$maximumDate = strtotime($searchObject->getMaximumDate());
if ($maximumDate) {
$field = $searchObject->getDateField();
if (empty($field)) {
throw new UnexpectedValueException('No date field is defined', 1396348733);
}
$constraints[] = $query->lessThanOrEqual($field, $maximumDate);
}
return $constraints;
}
