/**
* @return string
* @throws NotSupportedException
*/
protected function resolveComponentAttributeStringContentForNestedAttribute()
{
$attributeAndRelationData = $this->componentForm->getAttributeAndRelationData();
$count = 0;
$moduleClassName = $this->componentForm->getModuleClassName();
$modelClassName = $this->componentForm->getModelClassName();
$onTableAliasName = null;
$startingModelClassName = null;
foreach ($attributeAndRelationData as $key => $relationOrAttribute) {
$modelToReportAdapter = ModelRelationsAndAttributesToReportAdapter::make($moduleClassName, $modelClassName, $this->componentForm->getReportType());
$modelAttributeToDataProviderAdapter = $this->makeModelAttributeToDataProviderAdapter($modelToReportAdapter, $relationOrAttribute);
if ($this->shouldPrematurelyStopBuildingJoinsForAttribute($modelToReportAdapter, $modelAttributeToDataProviderAdapter)) {
$attribute = 'id';
$modelAttributeToDataProviderAdapter = $this->makeModelAttributeToDataProviderAdapter($modelToReportAdapter, $attribute);
break;
} elseif ($modelToReportAdapter->isReportedOnAsARelation($relationOrAttribute)) {
$modelClassName = $modelToReportAdapter->getRelationModelClassName($relationOrAttribute);
$moduleClassName = $modelToReportAdapter->getRelationModuleClassName($relationOrAttribute);
if ($modelToReportAdapter->isInferredRelation($relationOrAttribute) || $modelToReportAdapter->isDerivedRelationsViaCastedUpModelRelation($relationOrAttribute)) {
static::resolveCastingHintForAttribute($modelToReportAdapter, $modelAttributeToDataProviderAdapter, $modelClassName, $modelToReportAdapter->resolveRealAttributeName($attributeAndRelationData[$key + 1]));
}
$modelAttributeToDataProviderAdapter->setCastingHintStartingModelClassName($startingModelClassName);
$builder = new ModelJoinBuilder($modelAttributeToDataProviderAdapter, $this->joinTablesAdapter);
$onTableAliasName = $builder->resolveJoins($onTableAliasName, ModelDataProviderUtil::resolveCanUseFromJoins($onTableAliasName));
$startingModelClassName = $modelAttributeToDataProviderAdapter->getCastingHintModelClassNameForAttribute();
} else {
if ($count + 1 != count($attributeAndRelationData)) {
throw new NotSupportedException('The final element in array must be an attribute, not a relation');
}
}
$count++;
}
$modelAttributeToDataProviderAdapter->setCastingHintStartingModelClassName($startingModelClassName);
return $this->resolveFinalContent($modelAttributeToDataProviderAdapter, $onTableAliasName);
}
/**
* @param User $user
* @param RedBeanModelJoinTablesQueryAdapter $joinTablesAdapter
* @param $where
* @param $selectDistinct
* @throws NotSupportedException
*/
public static function resolveReadPermissionsOptimizationToSqlQuery(User $user, RedBeanModelJoinTablesQueryAdapter $joinTablesAdapter, &$where, &$selectDistinct)
{
assert('$where == null || is_string($where)');
assert('is_bool($selectDistinct)');
$modelClassName = get_called_class();
$moduleClassName = $modelClassName::getModuleClassName();
//Currently only adds munge if the module is securable and this model supports it.
if (static::hasReadPermissionsOptimization() && $moduleClassName != null && is_subclass_of($moduleClassName, 'SecurableModule')) {
$permission = PermissionsUtil::getActualPermissionDataForReadByModuleNameForUser($moduleClassName);
if (($permission == Permission::NONE || $permission == Permission::DENY) && !static::bypassReadPermissionsOptimizationToSqlQueryBasedOnWhere($where)) {
$quote = DatabaseCompatibilityUtil::getQuote();
$modelAttributeToDataProviderAdapter = new OwnedSecurableItemIdToDataProviderAdapter($modelClassName, null);
$builder = new ModelJoinBuilder($modelAttributeToDataProviderAdapter, $joinTablesAdapter);
$ownedTableAliasName = $builder->resolveJoins();
$ownerColumnName = static::getForeignKeyName('OwnedSecurableItem', 'owner');
$mungeIds = AllPermissionsOptimizationUtil::getMungeIdsByUser($user);
if ($where != null) {
$where = '(' . $where . ') and ';
}
if (count($mungeIds) > 0 && $permission == Permission::NONE) {
$extraOnQueryPart = " and {$quote}munge_id{$quote} in ('" . join("', '", $mungeIds) . "')";
$mungeTableName = ReadPermissionsOptimizationUtil::getMungeTableName($modelClassName);
$mungeTableAliasName = $joinTablesAdapter->addLeftTableAndGetAliasName($mungeTableName, 'securableitem_id', $ownedTableAliasName, 'securableitem_id', $extraOnQueryPart);
$where .= "({$quote}{$ownedTableAliasName}{$quote}.{$quote}{$ownerColumnName}{$quote} = {$user->id} OR ";
// Not Coding Standard
$where .= "{$quote}{$mungeTableName}{$quote}.{$quote}munge_id{$quote} IS NOT NULL)";
// Not Coding Standard
$selectDistinct = true;
//must use distinct since adding munge table query.
} elseif ($permission == Permission::DENY) {
$where .= "{$quote}{$ownedTableAliasName}{$quote}.{$quote}{$ownerColumnName}{$quote} = {$user->id}";
// Not Coding Standard
} else {
throw new NotSupportedException();
}
}
}
}
/**
* @param ModelJoinBuilder $builder
* @param $modelAttributeToDataProviderAdapter
* @param null | string $onTableAliasName
* @throws NotSupportedException if the display attribute is made via select like SUM(integer) but the
* adapter being used is not a summation adapter
*/
protected function resolveDisplayAttributeForProcessingAllJoins(ModelJoinBuilder $builder, $modelAttributeToDataProviderAdapter, $onTableAliasName = null)
{
assert('$modelAttributeToDataProviderAdapter instanceof RedBeanModelAttributeToDataProviderAdapter');
assert('is_string($onTableAliasName) || $onTableAliasName == null');
$tableAliasName = $builder->resolveJoins($onTableAliasName, ModelDataProviderUtil::resolveCanUseFromJoins($onTableAliasName));
if ($this->isDisplayAttributeMadeViaSelect()) {
if (!$this->modelToReportAdapter instanceof ModelRelationsAndAttributesToSummableReportAdapter) {
throw new NotSupportedException();
}
$this->modelToReportAdapter->resolveDisplayAttributeTypeAndAddSelectClause($this->selectQueryAdapter, $this->componentForm->getResolvedAttribute(), $tableAliasName, $this->resolveColumnName($modelAttributeToDataProviderAdapter), $this->componentForm->columnAliasName, $this->getAttributeClauseQueryStringExtraPart($tableAliasName));
} else {
$tableAliasName = $this->resolvedTableAliasName($modelAttributeToDataProviderAdapter, $builder);
$this->selectQueryAdapter->resolveIdClause($this->resolvedModelClassName($modelAttributeToDataProviderAdapter), $tableAliasName);
$this->componentForm->setModelAliasUsingTableAliasName($tableAliasName);
}
}
/**
* If the $onTableAliasName is used (not null):
* Special use of group by attribute resolution. If you are resolving a group by attribute against a relation then
* the joins must utilize a left join in the case of casting up. Does not support when the attribute is a
* relation itself as this expects any relation processing to be done before this is called.
*
* @param RedBeanModelAttributeToDataProviderAdapter $modelAttributeToDataProviderAdapter
* @param RedBeanModelJoinTablesQueryAdapter $joinTablesAdapter
* @param null | string $onTableAliasName
* @return string
* @throws NotSupportedException
*/
public static function resolveGroupByAttributeColumnName(RedBeanModelAttributeToDataProviderAdapter $modelAttributeToDataProviderAdapter, RedBeanModelJoinTablesQueryAdapter $joinTablesAdapter, $onTableAliasName = null)
{
assert('is_string($onTableAliasName) || $onTableAliasName == null');
$builder = new ModelJoinBuilder($modelAttributeToDataProviderAdapter, $joinTablesAdapter);
$tableAliasName = $builder->resolveJoins($onTableAliasName, self::resolveCanUseFromJoins($onTableAliasName));
if ($modelAttributeToDataProviderAdapter->hasRelatedAttribute()) {
$resolvedGroupByColumnName = $modelAttributeToDataProviderAdapter->getRelatedAttributeColumnName();
} else {
$resolvedGroupByColumnName = $modelAttributeToDataProviderAdapter->getColumnName();
}
return self::resolveGroupByColumnNameString($tableAliasName, $resolvedGroupByColumnName);
}
/**
* @param RedBeanModelAttributeToDataProviderAdapter $modelAttributeToDataProviderAdapter
* @param null | string $onTableAliasName
* @return string
*/
protected function resolveSortAttributeContent(RedBeanModelAttributeToDataProviderAdapter $modelAttributeToDataProviderAdapter, $onTableAliasName = null)
{
assert('is_string($onTableAliasName) || $onTableAliasName == null');
$builder = new ModelJoinBuilder($modelAttributeToDataProviderAdapter, $this->joinTablesAdapter);
$tableAliasName = $builder->resolveJoins($onTableAliasName, ModelDataProviderUtil::resolveCanUseFromJoins($onTableAliasName));
$resolvedSortColumnName = self::resolveSortColumnName($modelAttributeToDataProviderAdapter);
$queryStringExtraPart = $this->getAttributeClauseQueryStringExtraPart($tableAliasName);
return $this->resolveOrderByString($tableAliasName, $resolvedSortColumnName, $queryStringExtraPart);
}
