/**
* Returns an array of constraints created from a given demand object.
*
* @param \TYPO3\CMS\Extbase\Persistence\QueryInterface $query
* @param Tx_MooxNews_Domain_Model_DemandInterface $demand
* @throws UnexpectedValueException
* @throws InvalidArgumentException
* @throws Exception
* @return array<\TYPO3\CMS\Extbase\Persistence\Generic\Qom\ConstraintInterface>
*/
protected function createConstraintsFromDemand(\TYPO3\CMS\Extbase\Persistence\QueryInterface $query, Tx_MooxNews_Domain_Model_DemandInterface $demand)
{
$constraints = array();
if (is_array($demand->getTypes()) && count($demand->getTypes())) {
$constraints[] = $query->in('type', $demand->getTypes());
} elseif ($demand->getType() != "") {
$constraints[] = $query->equals('type', (string) $demand->getType());
}
if ($demand->getIncludeOnlySelectedNewsInRss()) {
$constraints[] = $query->equals('shareRss', 1);
}
if ($demand->getCategories() && $demand->getCategories() !== '0') {
$constraints[] = $this->createCategoryConstraint($query, $demand->getCategories(), $demand->getCategoryConjunction(), $demand->getIncludeSubCategories());
}
if ($demand->getAuthor()) {
$constraints[] = $query->equals('author', $demand->getAuthor());
}
$listViewSearchFields = $GLOBALS['TCA']['tx_mooxnews_domain_model_news']['listViewSearchFields']['moox_news']['default'];
if ($demand->getQuery()) {
$listViewSearchFields = $GLOBALS['TCA']['tx_mooxnews_domain_model_news']['listViewSearchFields']['moox_news']['default'];
if (is_array($demand->getTypes())) {
$type = reset($demand->getTypes());
}
if ($type != "" && isset($GLOBALS['TCA']['tx_mooxnews_domain_model_news']['listViewSearchFields'][$type]['default']) && $GLOBALS['TCA']['tx_mooxnews_domain_model_news']['listViewSearchFields'][$type]['default'] != "") {
$listViewSearchFields = $GLOBALS['TCA']['tx_mooxnews_domain_model_news']['listViewSearchFields'][$type]['default'];
} else {
$listViewSearchFields = $GLOBALS['TCA']['tx_mooxnews_domain_model_news']['listViewSearchFields']['moox_news']['default'];
}
if ($listViewSearchFields != "") {
$listViewSearchFields = explode(",", $listViewSearchFields);
} else {
$listViewSearchFields = array("title");
}
$queryConstraints = array();
foreach ($listViewSearchFields as $listViewSearchField) {
$queryConstraints[] = $query->like($listViewSearchField, "%" . $demand->getQuery() . "%");
}
$constraints[] = $query->logicalOr($queryConstraints);
}
if ($demand->getChar()) {
if ($demand->getChar() != "other") {
$char = substr($demand->getChar(), 0, 1);
if (in_array($char, $demand->getCharList())) {
$constraints[] = $query->like("title", $char . "%");
}
} else {
$charConstraints = array();
foreach ($demand->getCharList() as $char) {
if ($char != "all" && $char != "other") {
$charConstraints[] = $query->logicalNot($query->like("title", $char . "%"));
}
}
if (count($charConstraints)) {
$constraints[] = $query->logicalAnd($charConstraints);
}
}
}
// archived
if ($demand->getArchiveRestriction() == 'archived') {
$constraints[] = $query->logicalAnd($query->lessThan('archive', $GLOBALS['EXEC_TIME']), $query->greaterThan('archive', 0));
} elseif ($demand->getArchiveRestriction() == 'active') {
$constraints[] = $query->logicalOr($query->greaterThanOrEqual('archive', $GLOBALS['EXEC_TIME']), $query->equals('archive', 0));
}
if ($demand->getDateField() == "type" && is_array($demand->getTypes()) && count($demand->getTypes()) == 1) {
$type = reset($demand->getTypes());
if (isset($GLOBALS['TCA']['tx_mooxnews_domain_model_news']['dateTimeDefaultField'][$type]) && $GLOBALS['TCA']['tx_mooxnews_domain_model_news']['dateTimeDefaultField'][$type] != "") {
$dateTimeDefaultField = $GLOBALS['TCA']['tx_mooxnews_domain_model_news']['dateTimeDefaultField'][$type];
} else {
$dateTimeDefaultField = $GLOBALS['TCA']['tx_mooxnews_domain_model_news']['dateTimeDefaultField']['moox_news'];
}
$demand->setDateField($dateTimeDefaultField);
} elseif ($demand->getDateField() == "type") {
$dateTimeDefaultField = $GLOBALS['TCA']['tx_mooxnews_domain_model_news']['dateTimeDefaultField']['moox_news'];
$demand->setDateField($dateTimeDefaultField);
}
// Time restriction greater than or equal
$timeRestrictionField = $demand->getDateField();
$timeRestrictionField = empty($timeRestrictionField) ? 'datetime' : $timeRestrictionField;
if ($demand->getTimeRestriction()) {
$timeLimit = 0;
// integer = timestamp
if (\TYPO3\CMS\Core\Utility\MathUtility::canBeInterpretedAsInteger($demand->getTimeRestriction())) {
$timeLimit = $GLOBALS['EXEC_TIME'] - $demand->getTimeRestriction();
} else {
// try to check strtotime
$timeFromString = strtotime($demand->getTimeRestriction());
if ($timeFromString) {
$timeLimit = $timeFromString;
} else {
throw new Exception('Time limit Low could not be resolved to an integer. Given was: ' . htmlspecialchars($timeLimit));
}
}
$constraints[] = $query->greaterThanOrEqual($timeRestrictionField, $timeLimit);
}
// Time restriction less than or equal
if ($demand->getTimeRestrictionHigh()) {
$timeLimit = 0;
// integer = timestamp
if (\TYPO3\CMS\Core\Utility\MathUtility::canBeInterpretedAsInteger($demand->getTimeRestrictionHigh())) {
$timeLimit = $GLOBALS['EXEC_TIME'] + $demand->getTimeRestrictionHigh();
} else {
// try to check strtotime
$timeFromString = strtotime($demand->getTimeRestrictionHigh());
if ($timeFromString) {
$timeLimit = $timeFromString;
} else {
throw new Exception('Time limit High could not be resolved to an integer. Given was: ' . htmlspecialchars($timeLimit));
}
}
$constraints[] = $query->lessThanOrEqual($timeRestrictionField, $timeLimit);
}
// top news
if ($demand->getTopNewsRestriction() == 1) {
$constraints[] = $query->equals('istopnews', 1);
} elseif ($demand->getTopNewsRestriction() == 2) {
$constraints[] = $query->equals('istopnews', 0);
}
// top news
if ($demand->getExcludeFromRss() == 1) {
$constraints[] = $query->equals('excludeFromRss', 0);
}
// storage page
if ($demand->getStoragePage() != 0) {
$pidList = \TYPO3\CMS\Core\Utility\GeneralUtility::intExplode(',', $demand->getStoragePage(), TRUE);
$constraints[] = $query->in('pid', $pidList);
}
// datepicker filter
$datepickerConstraints = array();
if ($demand->getDateFrom() != "") {
$dateFrom = strtotime($demand->getDateFrom());
if ($dateFrom > 0) {
$dateFrom = mktime(0, 0, 0, date("n", $dateFrom), date("j", $dateFrom), date("Y", $dateFrom));
$datepickerConstraints[] = $query->greaterThanOrEqual($timeRestrictionField, $dateFrom);
}
}
if ($demand->getDateTo() != "") {
$dateTo = strtotime($demand->getDateTo());
if ($dateTo > 0) {
$dateTo = mktime(23, 59, 59, date("n", $dateTo), date("j", $dateTo), date("Y", $dateTo));
$datepickerConstraints[] = $query->lessThanOrEqual($timeRestrictionField, $dateTo);
}
}
if (count($datepickerConstraints) > 1) {
$constraints[] = $query->logicalAnd($datepickerConstraints);
} elseif (count($datepickerConstraints) > 0) {
$constraints[] = $datepickerConstraints[0];
}
// month & year OR year only
if (is_numeric($demand->getYear())) {
if ($demand->getYear() > 0) {
if ($demand->getMonth() > 0) {
if ($demand->getDay() > 0) {
$begin = mktime(0, 0, 0, $demand->getMonth(), $demand->getDay(), $demand->getYear());
$end = mktime(23, 59, 59, $demand->getMonth(), $demand->getDay(), $demand->getYear());
} else {
$begin = mktime(0, 0, 0, $demand->getMonth(), 1, $demand->getYear());
$end = mktime(23, 59, 59, $demand->getMonth() + 1, 0, $demand->getYear());
}
} else {
$begin = mktime(0, 0, 0, 1, 1, $demand->getYear());
$end = mktime(23, 59, 59, 12, 31, $demand->getYear());
}
$constraints[] = $query->logicalAnd($query->greaterThanOrEqual($timeRestrictionField, $begin), $query->lessThanOrEqual($timeRestrictionField, $end));
} else {
$constraints[] = $query->equals($timeRestrictionField, 0);
}
}
if (is_array($GLOBALS['TCA']['tx_mooxnews_domain_model_news']['listViewSearchFields'])) {
foreach ($GLOBALS['TCA']['tx_mooxnews_domain_model_news']['listViewSearchFields'] as $extkey => $queryFields) {
if ($extkey != "moox_news") {
foreach ($queryFields as $fieldname => $queryField) {
if ($fieldname != "default" && $queryField != "") {
$fieldname = \TYPO3\CMS\Core\Utility\GeneralUtility::underscoredToLowerCamelCase($fieldname);
$getCall = "get" . ucfirst($fieldname);
if (method_exists($demand, $getCall)) {
$fieldvalue = $demand->{$getCall}();
if ($fieldvalue != "") {
$listViewSearchFields = explode(",", $queryField);
$queryConstraints = array();
foreach ($listViewSearchFields as $listViewSearchField) {
$queryConstraints[] = $query->like($listViewSearchField, "%" . $fieldvalue . "%");
}
$constraints[] = $query->logicalOr($queryConstraints);
}
}
}
}
}
}
}
// set constraints based on extended filter fields from external extensions
foreach ($GLOBALS['TCA']['tx_mooxnews_domain_model_news']['columns'] as $fieldname => $field) {
if ($field['addToMooxNewsFrontendDemand']) {
$fieldname = \TYPO3\CMS\Core\Utility\GeneralUtility::underscoredToLowerCamelCase($fieldname);
$getCall = "get" . ucfirst($fieldname);
if (method_exists($demand, $getCall)) {
$fieldvalue = $demand->{$getCall}();
if (trim($fieldvalue) != "" && trim($fieldvalue) != "all") {
if (in_array($field['config']['type'], array("input", "text")) && !in_array($field['addToMooxNewsFrontendFilter']['type'], array("select"))) {
$constraints[] = $query->like($fieldname, '%' . $fieldvalue . '%');
} else {
if (in_array($field['addToMooxNewsFrontendFilter']['type'], array("select")) && $fieldvalue == "empty") {
$constraints[] = $query->logicalOr($query->equals($fieldname, ""), $query->equals($fieldname, NULL));
} else {
$constraints[] = $query->equals($fieldname, $fieldvalue);
}
}
}
}
}
}
// sys language
if (TYPO3_MODE == 'BE') {
$query->getQuerySettings()->setRespectSysLanguage(false);
$constraints[] = $query->equals('t3_origuid', 0);
if (is_numeric($demand->getSysLanguageUid())) {
$constraints[] = $query->equals('sys_language_uid', $demand->getSysLanguageUid());
}
}
// Tags
if (is_array($demand->getTags()) && count($demand->getTags())) {
$tags = $demand->getTags();
if (count($tags) > 1) {
$tagConstraints = array();
foreach ($tags as $tag) {
$tagConstraints[] = $query->contains('tags', $tag);
}
$constraints[] = $query->logicalOr($tagConstraints);
} else {
$constraints[] = $query->contains('tags', $tags[0]);
}
} elseif ($demand->getTag() != "") {
$constraints[] = $query->contains('tags', $demand->getTag());
}
// Targets
if (is_array($demand->getTargets()) && count($demand->getTargets())) {
$targets = $demand->getTargets();
if (count($targets) > 1) {
$targetConstraints = array();
foreach ($targets as $target) {
$targetConstraints[] = $query->contains('targets', $target);
}
$constraints[] = $query->logicalOr($targetConstraints);
} else {
$constraints[] = $query->contains('targets', $targets[0]);
}
} elseif ($demand->getTarget() != "") {
$constraints[] = $query->contains('targets', $demand->getTarget());
}
// mailer frequency
if (TYPO3_MODE == 'BE') {
if (is_numeric($demand->getMailerFrequency())) {
$constraints[] = $query->equals('mailerFrequency', $demand->getMailerFrequency());
}
}
// Search
$searchConstraints = $this->getSearchConstraints($query, $demand);
if (!empty($searchConstraints)) {
$constraints[] = $query->logicalAnd($searchConstraints);
}
// Exclude already displayed
if ($demand->getExcludeAlreadyDisplayedNews() && isset($GLOBALS['EXT']['moox_news']['alreadyDisplayed']) && !empty($GLOBALS['EXT']['moox_news']['alreadyDisplayed'])) {
$constraints[] = $query->logicalNot($query->in('uid', $GLOBALS['EXT']['moox_news']['alreadyDisplayed']));
}
// Clean not used constraints
foreach ($constraints as $key => $value) {
if (is_null($value)) {
unset($constraints[$key]);
}
}
/*
$parser = \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance('TYPO3\\CMS\\Extbase\\Persistence\\Generic\\Storage\\Typo3DbQueryParser');
$queryParts = $parser->parseQuery($query);
\TYPO3\CMS\Core\Utility\DebugUtility::debug($queryParts, 'Query');
exit();
*/
return $constraints;
}
