/**
* Build the criteria for a single field
*
* @param Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldIdentifier
* @return Tx_PtExtlist_Domain_QueryObject_SimpleCriteria
*/
protected function buildFilterCriteria(Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldIdentifier)
{
$fieldName = Tx_PtExtlist_Utility_DbUtils::getSelectPartByFieldConfig($fieldIdentifier);
$singleCriteria = NULL;
$selectedPid = $this->yagContext->getSelectedPid();
$singleCriteria = Tx_PtExtlist_Domain_QueryObject_Criteria::equals($fieldName, $selectedPid);
return $singleCriteria;
}
/**
* 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;
}
/**
* (non-PHPdoc)
* @see Classes/Domain/Model/Filter/Tx_PtExtlist_Domain_Model_Filter_AbstractFilter::buildFilterCriteria()
*/
protected function buildFilterCriteria(Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldIdentifier)
{
$criteria = NULL;
if ($this->isActive) {
$fieldName = Tx_PtExtlist_Utility_DbUtils::getSelectPartByFieldConfig($fieldIdentifier);
$filterValue = intval($this->filterValue);
$criteria = Tx_PtExtlist_Domain_QueryObject_Criteria::lessThanEquals($fieldName, $filterValue);
}
return $criteria;
}
/**
* @param Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldIdentifier
* @return null|Tx_PtExtlist_Domain_QueryObject_SimpleCriteria
*/
protected function buildFilterCriteria(Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldIdentifier)
{
if ($this->filterValue == '') {
return null;
}
$fieldName = Tx_PtExtlist_Utility_DbUtils::getSelectPartByFieldConfig($fieldIdentifier);
if ($this->orToken || $this->andToken) {
$filterValueArray = $this->prepareFilterValue($this->filterValue);
$criteria = $this->buildOrCriteria($fieldName, $filterValueArray);
} else {
$criteria = $this->buildFilterCriteriaForSingleValue($fieldName, $this->filterValue);
}
return $criteria;
}
/**
* Build the filterCriteria for filter
*
* @return Tx_PtExtlist_Domain_QueryObject_Criteria
*/
protected function buildFilterCriteriaForAllFields()
{
$uidField = $this->fieldIdentifierCollection->getFieldConfigByIdentifier('uid');
$fieldName = Tx_PtExtlist_Utility_DbUtils::getSelectPartByFieldConfig($uidField);
$criteria = Tx_PtExtlist_Domain_QueryObject_Criteria::in($fieldName, $this->getRandomUIDs());
return $criteria;
}
/**
* Build the criteria for a single field
*
* @param Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldIdentifier
* @return Tx_PtExtlist_Domain_QueryObject_SimpleCriteria
*/
protected function buildFilterCriteria(Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldIdentifier)
{
$fieldName = Tx_PtExtlist_Utility_DbUtils::getSelectPartByFieldConfig($fieldIdentifier);
$singleCriteria = NULL;
$singleCriteria = Tx_PtExtlist_Domain_QueryObject_Criteria::in($fieldName, $this->getFilterNodeUIds());
return $singleCriteria;
}
/**
* Build the filterCriteria for filter
*
* @return Tx_PtExtlist_Domain_QueryObject_Criteria
*/
protected function buildFilterCriteriaForAllFields()
{
$albumField = $this->fieldIdentifierCollection->getFieldConfigByIdentifier('album');
$fieldName = Tx_PtExtlist_Utility_DbUtils::getSelectPartByFieldConfig($albumField);
$criteria = Tx_PtExtlist_Domain_QueryObject_Criteria::equals($fieldName, $this->albumUid);
return $criteria;
}
/**
* Builds select part from all parts of plugin
*
* @return string SELECT part of query without 'SELECT'
*/
public function buildSelectPart()
{
$selectParts = array();
foreach ($this->fieldConfigurationCollection as $fieldConfiguration) {
/* @var $fieldConfiguration Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig */
if ($fieldConfiguration->getExpandGroupRows() && $this->baseGroupByClause) {
$selectParts[] = 'group_concat(' . Tx_PtExtlist_Utility_DbUtils::getSelectPartByFieldConfig($fieldConfiguration) . ' SEPARATOR "' . $fieldConfiguration->getExpandGroupRowsSeparator() . '") AS ' . $fieldConfiguration->getIdentifier();
} else {
$selectParts[] = Tx_PtExtlist_Utility_DbUtils::getAliasedSelectPartByFieldConfig($fieldConfiguration);
}
}
return implode(', ', $selectParts);
}
/**
* Build the group data query to retrieve the group data
*
* @return Tx_PtExtlist_Domain_QueryObject_Query
*/
protected function buildQuery()
{
$query = new Tx_PtExtlist_Domain_QueryObject_Query();
foreach ($this->dateFieldConfigs as $key => $selectField) {
if ($selectField['start'] == $selectField['end']) {
$aliasedSelectPart = Tx_PtExtlist_Utility_DbUtils::getSelectPartByFieldConfig($selectField['start']) . ' AS ' . $selectField['start']->getIdentifier();
$query->addField($aliasedSelectPart);
} else {
$aliasedSelectPartStart = Tx_PtExtlist_Utility_DbUtils::getSelectPartByFieldConfig($selectField['start']) . ' AS ' . $this->buildFieldAlias($key, 'start');
$aliasedSelectPartEnd = Tx_PtExtlist_Utility_DbUtils::getSelectPartByFieldConfig($selectField['end']) . ' AS ' . $this->buildFieldAlias($key, 'end');
$query->addField($aliasedSelectPartStart);
$query->addField($aliasedSelectPartEnd);
}
}
return $query;
}
/**
* @param Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldIdentifier
* @return Tx_PtExtlist_Domain_QueryObject_SimpleCriteria
*/
protected function buildFilterCriteria(Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldIdentifier)
{
$fieldName = Tx_PtExtlist_Utility_DbUtils::getSelectPartByFieldConfig($fieldIdentifier);
$criteria = Tx_PtExtlist_Domain_QueryObject_Criteria::equals($fieldName, $this->filterValue);
return $criteria;
}
/**
* Build the criteria for a single field
*
* @param Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldIdentifier
* @return Tx_PtExtlist_Domain_QueryObject_SimpleCriteria
*/
protected function buildFilterCriteria(Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldIdentifier)
{
$fieldName = Tx_PtExtlist_Utility_DbUtils::getSelectPartByFieldConfig($fieldIdentifier);
$singleCriteria = null;
if ($fieldIdentifier->getIsRelation()) {
$singleCriteria = Tx_PtExtlist_Domain_QueryObject_Criteria::relation($fieldName, current($this->filterValues));
} elseif (is_array($this->filterValues) && count($this->filterValues) == 1) {
$singleCriteria = Tx_PtExtlist_Domain_QueryObject_Criteria::equals($fieldName, current($this->filterValues));
} elseif (is_array($this->filterValues) && count($this->filterValues) > 1) {
$singleCriteria = Tx_PtExtlist_Domain_QueryObject_Criteria::in($fieldName, $this->filterValues);
}
return $singleCriteria;
}
/**
* @param Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldIdentifier
* @return Tx_PtExtlist_Domain_QueryObject_AndCriteria|Tx_PtExtlist_Domain_QueryObject_SimpleCriteria
*/
protected function buildFilterCriteria(Tx_PtExtlist_Domain_Configuration_Data_Fields_FieldConfig $fieldIdentifier)
{
if ($this->galleryUid) {
$fieldName = Tx_PtExtlist_Utility_DbUtils::getSelectPartByFieldConfig($fieldIdentifier);
if ($fieldIdentifier->getField() === 'album') {
return $this->buildFilterCriteriaForAlbumField($fieldName);
} else {
return $this->buildFilterCriteriaForGalleryField($fieldName);
}
}
}
