/**
* Main method to build expressions for given tables
* Evaluates the ctrl/enablecolumns/fe_group flag of the table and adds the according restriction if set
*
* @param array $queriedTables Array of tables, where array key is table name and value potentially an alias
* @param ExpressionBuilder $expressionBuilder Expression builder instance to add restrictions with
* @return CompositeExpression The result of query builder expression(s)
*/
public function buildExpression(array $queriedTables, ExpressionBuilder $expressionBuilder) : CompositeExpression
{
$constraints = [];
foreach ($queriedTables as $tableName => $tableAlias) {
$groupFieldName = $GLOBALS['TCA'][$tableName]['ctrl']['enablecolumns']['fe_group'] ?? null;
if (!empty($groupFieldName)) {
$fieldName = ($tableAlias ?: $tableName) . '.' . $groupFieldName;
// Allow records where no group access has been configured (field values NULL, 0 or empty string)
$constraints = [$expressionBuilder->isNull($fieldName), $expressionBuilder->eq($fieldName, $expressionBuilder->literal('')), $expressionBuilder->eq($fieldName, $expressionBuilder->literal('0'))];
foreach ($this->frontendGroupIds as $frontendGroupId) {
$constraints[] = $expressionBuilder->inSet($fieldName, $expressionBuilder->literal((string) $frontendGroupId));
}
}
}
return $expressionBuilder->orX(...$constraints);
}
/**
* @test
*/
public function isNullQuotesIdentifier()
{
$result = $this->subject->isNull('aField');
$this->connectionProphet->quoteIdentifier('aField')->shouldHaveBeenCalled();
$this->assertSame('aField IS NULL', $result);
}
