public function testAnd()
{
$criteria1 = Tx_PtExtlist_Domain_QueryObject_Criteria::lessThan('test', 1);
$criteria2 = Tx_PtExtlist_Domain_QueryObject_Criteria::greaterThan('test', 0);
$andCriteria = Tx_PtExtlist_Domain_QueryObject_Criteria::andOp($criteria1, $criteria2);
$this->assertTrue(is_a($andCriteria, 'Tx_PtExtlist_Domain_QueryObject_AndCriteria'));
}
/**
* Creates filter query from filter value and settings
*
* @param Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldIdentifier
* @return Tx_PtExtlist_Domain_QueryObject_Criteria Criteria for current filter value (null, if empty)
*/
protected function buildFilterCriteria(Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldIdentifier)
{
$timestampBoundaries = $this->getCalculatedTimestampBoundaries();
$fieldName = Tx_PtExtlist_Utility_DbUtils::getSelectPartByFieldConfig($fieldIdentifier);
$criteria1 = Tx_PtExtlist_Domain_QueryObject_Criteria::greaterThanEquals($fieldName, $timestampBoundaries['filterValueFromTimestamp']);
$criteria2 = Tx_PtExtlist_Domain_QueryObject_Criteria::lessThanEquals($fieldName, $timestampBoundaries['filterValueToTimestamp']);
$criteria = Tx_PtExtlist_Domain_QueryObject_Criteria::andOp($criteria1, $criteria2);
return $criteria;
}
/**
* @param Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldStart
* @param Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldEnd
* @return Tx_PtExtlist_Domain_QueryObject_Criteria
*
* TODO: Optimize this for a 1-field query
*/
protected function buildTimeSpanFilterCriteria(Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldStart, Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldEnd)
{
$fieldStartName = Tx_PtExtlist_Utility_DbUtils::getSelectPartByFieldConfig($fieldStart);
$fieldEndName = Tx_PtExtlist_Utility_DbUtils::getSelectPartByFieldConfig($fieldEnd);
$startValueCriteria = Tx_PtExtlist_Domain_QueryObject_Criteria::andOp(Tx_PtExtlist_Domain_QueryObject_Criteria::lessThanEquals($fieldStartName, $this->getFilterValueStartInDBFormat()), Tx_PtExtlist_Domain_QueryObject_Criteria::greaterThanEquals($fieldEndName, $this->getFilterValueStartInDBFormat()));
$endValueCriteria = Tx_PtExtlist_Domain_QueryObject_Criteria::andOp(Tx_PtExtlist_Domain_QueryObject_Criteria::lessThanEquals($fieldStartName, $this->getFilterValueEndInDBFormat()), Tx_PtExtlist_Domain_QueryObject_Criteria::greaterThanEquals($fieldEndName, $this->getFilterValueEndInDBFormat()));
$betweenValuesCriteria = Tx_PtExtlist_Domain_QueryObject_Criteria::andOp(Tx_PtExtlist_Domain_QueryObject_Criteria::greaterThanEquals($fieldStartName, $this->getFilterValueStartInDBFormat()), Tx_PtExtlist_Domain_QueryObject_Criteria::lessThanEquals($fieldEndName, $this->getFilterValueEndInDBFormat()));
$criteria = Tx_PtExtlist_Domain_QueryObject_Criteria::orOp(Tx_PtExtlist_Domain_QueryObject_Criteria::orOp($startValueCriteria, $endValueCriteria), $betweenValuesCriteria);
return $criteria;
}
/**
* @param $fieldName
* @param $andLevelArray
* @return null|Tx_PtExtlist_Domain_QueryObject_AndCriteria|Tx_PtExtlist_Domain_QueryObject_SimpleCriteria
*/
public function buildAndCriteria($fieldName, $andLevelArray)
{
$criteria = null;
foreach ($andLevelArray as $singleValue) {
$singleAndCriteria = $this->buildFilterCriteriaForSingleValue($fieldName, $singleValue);
if ($criteria) {
$criteria = Tx_PtExtlist_Domain_QueryObject_Criteria::andOp($criteria, $singleAndCriteria);
} else {
$criteria = $singleAndCriteria;
}
}
return $criteria;
}
/**
* @param $fieldName
* @return Tx_PtExtlist_Domain_QueryObject_AndCriteria|Tx_PtExtlist_Domain_QueryObject_SimpleCriteria
*/
protected function buildFilterCriteriaForGalleryField($fieldName)
{
$criteria = Tx_PtExtlist_Domain_QueryObject_Criteria::equals($fieldName, $this->galleryUid);
if ($this->hideHidden) {
$criteria1 = $criteria;
$criteria2 = Tx_PtExtlist_Domain_QueryObject_Criteria::equals('hidden', '0');
$criteria = Tx_PtExtlist_Domain_QueryObject_Criteria::andOp($criteria1, $criteria2);
}
return $criteria;
}
