CodeExplorer
You are a developer and looking for Shopware projects?
Apply Now!
conditions example
/**
* {@inheritdoc}
*/
public function alwaysFalse() {
return $this->where('1 = 0');
}
/** * {@inheritdoc} */
public function Dconditions() {
return $this->conditions;
}
/** * {@inheritdoc} */
public function arguments() {
// If the caller forgot to call compile() first, refuse to run. if ($this->changed) {
return NULL;
}
public function alwaysFalse() {
return $this->where('1 = 0');
}
/** * {@inheritdoc} */
public function Dconditions() {
return $this->conditions;
}
/** * {@inheritdoc} */
public function arguments() {
// If the caller forgot to call compile() first, refuse to run. if ($this->changed) {
return NULL;
}
/**
* Extends the core SearchQuery to be able to gets its protected values.
*/
class ViewsSearchQuery extends SearchQuery {
/** * Returns the conditions property. * * @return array * The query conditions. */
public function Dconditions() {
return $this->conditions;
}
/** * Returns the words property. * * @return array * The positive search keywords. */
public function words() {
return $this->words;
}
class ViewsSearchQuery extends SearchQuery {
/** * Returns the conditions property. * * @return array * The query conditions. */
public function Dconditions() {
return $this->conditions;
}
/** * Returns the words property. * * @return array * The positive search keywords. */
public function words() {
return $this->words;
}
parent::entityQueryAlter($query);
// Bail out early if we do not need to match the Anonymous user. if (!$this->getConfiguration()['include_anonymous']) {
return;
}
if ($this->currentUser->hasPermission('administer users')) {
// In addition, if the user is administrator, we need to make sure to // match the anonymous user, that doesn't actually have a name in the // database. $conditions = &$query->conditions();
foreach ($conditions as $key => $condition) {
if ($key !== '#conjunction' && is_string($condition['field']) && $condition['field'] === 'users_field_data.name') {
// Remove the condition. unset($conditions[$key]);
// Re-add the condition and a condition on uid = 0 so that we end up // with a query in the form: // WHERE (name LIKE :name) OR (:anonymous_name LIKE :name AND uid = 0) $or = $this->connection->condition('OR');
$or->condition($condition['field'], $condition['value'], $condition['operator']);
// Sadly, the Database layer doesn't allow us to build a condition
// Bail out early if we do not need to match the Anonymous user. if (!$this->getConfiguration()['include_anonymous']) {
return;
}
if ($this->currentUser->hasPermission('administer users')) {
// In addition, if the user is administrator, we need to make sure to // match the anonymous user, that doesn't actually have a name in the // database. $conditions = &$query->conditions();
foreach ($conditions as $key => $condition) {
if ($key !== '#conjunction' && is_string($condition['field']) && $condition['field'] === 'users_field_data.name') {
// Remove the condition. unset($conditions[$key]);
// Re-add the condition and a condition on uid = 0 so that we end up // with a query in the form: // WHERE (name LIKE :name) OR (:anonymous_name LIKE :name AND uid = 0) $or = $this->connection->condition('OR');
$or->condition($condition['field'], $condition['value'], $condition['operator']);
// Sadly, the Database layer doesn't allow us to build a condition
$view = Views::getView('taxonomy_term');
$view->initDisplay();
$view->setArguments([$term->id()]);
$view->build();
/** @var \Drupal\Core\Database\Query\Select $query */
$query = $view->build_info['query'];
$tables = $query->getTables();
// Ensure that the join to node_field_data is not added by default. $this->assertEquals(['node_field_data', 'taxonomy_index'], array_keys($tables));
// Ensure that the filter to the language column is not there by default. $condition = $query->conditions();
// We only want to check the no. of conditions in the query. unset($condition['#conjunction']);
$this->assertCount(1, $condition);
// Clear permissions for anonymous users to check access for default views. Role::load(RoleInterface::ANONYMOUS_ID)->revokePermission('access content')->save();
// Test the default views disclose no data by default. $this->drupalLogout();
$this->drupalGet('taxonomy/term/' . $term->id());
$this->assertSession()->statusCodeEquals(403);
$view->initDisplay();
$view->setArguments([$term->id()]);
$view->build();
/** @var \Drupal\Core\Database\Query\Select $query */
$query = $view->build_info['query'];
$tables = $query->getTables();
// Ensure that the join to node_field_data is not added by default. $this->assertEquals(['node_field_data', 'taxonomy_index'], array_keys($tables));
// Ensure that the filter to the language column is not there by default. $condition = $query->conditions();
// We only want to check the no. of conditions in the query. unset($condition['#conjunction']);
$this->assertCount(1, $condition);
// Clear permissions for anonymous users to check access for default views. Role::load(RoleInterface::ANONYMOUS_ID)->revokePermission('access content')->save();
// Test the default views disclose no data by default. $this->drupalLogout();
$this->drupalGet('taxonomy/term/' . $term->id());
$this->assertSession()->statusCodeEquals(403);
'left_field' => 'word',
];
$join = Views::pluginManager('join')->createInstance('standard', $definition);
$search_total = $this->query->addRelationship('search_total', $join, $search_index);
// Add the search score field to the query. $this->search_score = $this->query->addField('', "$search_index.score * $search_total.count", 'score', ['function' => 'sum']);
// Add the conditions set up by the search query to the views query. $search_condition->condition("$search_index.type", $this->searchType);
$search_dataset = $this->query->addTable('node_search_dataset');
$conditions = $this->searchQuery->conditions();
$condition_conditions =& $conditions->conditions();
foreach ($condition_conditions as $key => &$condition) {
// Make sure we just look at real conditions. if (is_numeric($key)) {
// Replace the conditions with the table alias of views. $this->searchQuery->conditionReplaceString('d.', "$search_dataset.", $condition);
}
}
$search_conditions =& $search_condition->conditions();
$search_conditions = array_merge($search_conditions, $condition_conditions);
];
$join = Views::pluginManager('join')->createInstance('standard', $definition);
$search_total = $this->query->addRelationship('search_total', $join, $search_index);
// Add the search score field to the query. $this->search_score = $this->query->addField('', "$search_index.score * $search_total.count", 'score', ['function' => 'sum']);
// Add the conditions set up by the search query to the views query. $search_condition->condition("$search_index.type", $this->searchType);
$search_dataset = $this->query->addTable('node_search_dataset');
$conditions = $this->searchQuery->conditions();
$condition_conditions =& $conditions->conditions();
foreach ($condition_conditions as $key => &$condition) {
// Make sure we just look at real conditions. if (is_numeric($key)) {
// Replace the conditions with the table alias of views. $this->searchQuery->conditionReplaceString('d.', "$search_dataset.", $condition);
}
}
$search_conditions =& $search_condition->conditions();
$search_conditions = array_merge($search_conditions, $condition_conditions);
/**
* {@inheritdoc}
*/
public function alwaysFalse() {
$this->condition->alwaysFalse();
return $this;
}
/** * {@inheritdoc} */
public function Dconditions() {
return $this->condition->conditions();
}
/** * {@inheritdoc} */
public function arguments() {
return $this->condition->arguments();
}
/** * {@inheritdoc} */
public function alwaysFalse() {
$this->condition->alwaysFalse();
return $this;
}
/** * {@inheritdoc} */
public function Dconditions() {
return $this->condition->conditions();
}
/** * {@inheritdoc} */
public function arguments() {
return $this->condition->arguments();
}
/** * {@inheritdoc} */
if (!$langcode = $query->getMetaData('langcode')) {
$langcode = FALSE;
}
// Find all instances of the base table being joined -- could appear // more than once in the query, and could be aliased. Join each one to // the node_access table. $grants = node_access_grants($operation, $account);
// If any grant exists for the specified user, then user has access to the // node for the specified operation. $grant_conditions = $this->buildGrantsQueryCondition($grants);
$grants_exist = count($grant_conditions->conditions()) > 0;
$is_multilingual = \Drupal::languageManager()->isMultilingual();
foreach ($tables as $nalias => $tableinfo) {
$table = $tableinfo['table'];
if (!($table instanceof SelectInterface) && $table == $base_table) {
// Set the subquery. $subquery = $this->database->select('node_access', 'na')
->fields('na', ['nid']);
// Attach conditions to the sub-query for nodes. if ($grants_exist) {
$langcode = FALSE;
}
// Find all instances of the base table being joined -- could appear // more than once in the query, and could be aliased. Join each one to // the node_access table. $grants = node_access_grants($operation, $account);
// If any grant exists for the specified user, then user has access to the // node for the specified operation. $grant_conditions = $this->buildGrantsQueryCondition($grants);
$grants_exist = count($grant_conditions->conditions()) > 0;
$is_multilingual = \Drupal::languageManager()->isMultilingual();
foreach ($tables as $nalias => $tableinfo) {
$table = $tableinfo['table'];
if (!($table instanceof SelectInterface) && $table == $base_table) {
// Set the subquery. $subquery = $this->database->select('node_access', 'na')
->fields('na', ['nid']);
// Attach conditions to the sub-query for nodes. if ($grants_exist) {
// Namespace the join on every table.
if (isset($tables[$table_name]['condition'])) {
$tables[$table_name]['condition'] = $this->conditionNamespace($tables[$table_name]['condition']);
}
}
// Namespace fields. foreach (array_keys($fields) as $field_name) {
$fields[$field_name]['table'] .= $this->subquery_namespace;
$fields[$field_name]['alias'] .= $this->subquery_namespace;
}
// Namespace conditions. $where = &$subquery->conditions();
$this->alterSubqueryCondition($subquery, $where);
// Not sure why, but our sort order clause doesn't have a table. // TODO: the call to addHandler() above to add the sort handler is probably // wrong -- needs attention from someone who understands it. // In the meantime, this works, but with a leap of faith. $orders = &$subquery->getOrderBy();
foreach ($orders as $order_key => $order) {
// But if we're using a whole view, we don't know what we have! if ($options['subquery_view']) {
[$sort_table, $sort_field] = explode('.', $order_key);
}
$tables[$table_name]['condition'] = $this->conditionNamespace($tables[$table_name]['condition']);
}
}
// Namespace fields. foreach (array_keys($fields) as $field_name) {
$fields[$field_name]['table'] .= $this->subquery_namespace;
$fields[$field_name]['alias'] .= $this->subquery_namespace;
}
// Namespace conditions. $where = &$subquery->conditions();
$this->alterSubqueryCondition($subquery, $where);
// Not sure why, but our sort order clause doesn't have a table. // TODO: the call to addHandler() above to add the sort handler is probably // wrong -- needs attention from someone who understands it. // In the meantime, this works, but with a leap of faith. $orders = &$subquery->getOrderBy();
foreach ($orders as $order_key => $order) {
// But if we're using a whole view, we don't know what we have! if ($options['subquery_view']) {
[$sort_table, $sort_field] = explode('.', $order_key);
}
public function notExists($field, $function, $langcode = NULL);
/** * Gets a complete list of all conditions in this conditional clause. * * This method returns by reference. That allows alter hooks to access the * data structure directly and manipulate it before it gets compiled. * * @return array */
public function Dconditions();
/** * Compiles this conditional clause. * * @param $query * The query object this conditional clause belongs to. */
public function compile($query);
}
/**
* {@inheritdoc}
*/
#[\ReturnTypeWillChange] public function count() {
return count($this->conditions);
}
/** * {@inheritdoc} */
public function Dconditions() {
return $this->conditions;
}
/** * Implements the magic __clone function. * * Makes sure condition groups are cloned as well. */
public function __clone() {
foreach ($this->conditions as $key => $condition) {
if ($condition['field'] instanceof ConditionInterface) {
#[\ReturnTypeWillChange] public function count() {
return count($this->conditions);
}
/** * {@inheritdoc} */
public function Dconditions() {
return $this->conditions;
}
/** * Implements the magic __clone function. * * Makes sure condition groups are cloned as well. */
public function __clone() {
foreach ($this->conditions as $key => $condition) {
if ($condition['field'] instanceof ConditionInterface) {
public function havingCondition($field, $value = NULL, $operator = NULL) {
$this->having->condition($field, $value, $operator);
return $this;
}
/** * {@inheritdoc} */
public function DhavingConditions() {
return $this->having->conditions();
}
/** * {@inheritdoc} */
public function havingArguments() {
return $this->having->arguments();
}
/** * {@inheritdoc} */
public function notExists($field, $langcode = NULL);
/** * Gets a complete list of all conditions in this conditional clause. * * This method returns by reference. That allows alter hooks to access the * data structure directly and manipulate it before it gets compiled. * * @return array */
public function Dconditions();
/** * Compiles this conditional clause. * * @param $query * The query object this conditional clause belongs to. */
public function compile($query);
}
'left_field' => 'word',
];
$join = Views::pluginManager('join')->createInstance('standard', $definition);
$search_total = $this->query->addRelationship('search_total', $join, $search_index);
// Add the search score field to the query. $this->search_score = $this->query->addField('', "$search_index.score * $search_total.count", 'score', ['function' => 'sum']);
// Add the conditions set up by the search query to the views query. $search_condition->condition("$search_index.type", $this->searchType);
$search_dataset = $this->query->addTable('node_search_dataset');
$conditions = $this->searchQuery->conditions();
$condition_conditions =& $conditions->conditions();
foreach ($condition_conditions as $key => &$condition) {
// Make sure we just look at real conditions. if (is_numeric($key)) {
// Replace the conditions with the table alias of views. $this->searchQuery->conditionReplaceString('d.', "$search_dataset.", $condition);
}
}
$search_conditions =& $search_condition->conditions();
$search_conditions = array_merge($search_conditions, $condition_conditions);
];
$join = Views::pluginManager('join')->createInstance('standard', $definition);
$search_total = $this->query->addRelationship('search_total', $join, $search_index);
// Add the search score field to the query. $this->search_score = $this->query->addField('', "$search_index.score * $search_total.count", 'score', ['function' => 'sum']);
// Add the conditions set up by the search query to the views query. $search_condition->condition("$search_index.type", $this->searchType);
$search_dataset = $this->query->addTable('node_search_dataset');
$conditions = $this->searchQuery->conditions();
$condition_conditions =& $conditions->conditions();
foreach ($condition_conditions as $key => &$condition) {
// Make sure we just look at real conditions. if (is_numeric($key)) {
// Replace the conditions with the table alias of views. $this->searchQuery->conditionReplaceString('d.', "$search_dataset.", $condition);
}
}
$search_conditions =& $search_condition->conditions();
$search_conditions = array_merge($search_conditions, $condition_conditions);
protected function loadRecords() {
$prefix = $this->entityType->getConfigPrefix() . '.';
$prefix_length = strlen($prefix);
// Search the conditions for restrictions on configuration object names. $filter_by_names = [];
$has_added_restrictions = FALSE;
$id_condition = NULL;
$id_key = $this->entityType->getKey('id');
if ($this->condition->getConjunction() == 'AND') {
$lookup_keys = $this->entityType->getLookupKeys();
$conditions = $this->condition->conditions();
foreach ($conditions as $condition_key => $condition) {
$operator = $condition['operator'] ?: (is_array($condition['value']) ? 'IN' : '=');
if (is_string($condition['field']) && ($operator == 'IN' || $operator == '=')) {
// Special case ID lookups. if ($condition['field'] == $id_key) {
$has_added_restrictions = TRUE;
$ids = (array) $condition['value'];
$filter_by_names[] = array_map(static function D$id) use ($prefix) {
return $prefix . $id;
}, $ids);
}
$prefix = $this->entityType->getConfigPrefix() . '.';
$prefix_length = strlen($prefix);
// Search the conditions for restrictions on configuration object names. $filter_by_names = [];
$has_added_restrictions = FALSE;
$id_condition = NULL;
$id_key = $this->entityType->getKey('id');
if ($this->condition->getConjunction() == 'AND') {
$lookup_keys = $this->entityType->getLookupKeys();
$conditions = $this->condition->conditions();
foreach ($conditions as $condition_key => $condition) {
$operator = $condition['operator'] ?: (is_array($condition['value']) ? 'IN' : '=');
if (is_string($condition['field']) && ($operator == 'IN' || $operator == '=')) {
// Special case ID lookups. if ($condition['field'] == $id_key) {
$has_added_restrictions = TRUE;
$ids = (array) $condition['value'];
$filter_by_names[] = array_map(static function D$id) use ($prefix) {
return $prefix . $id;
}, $ids);
}
public function Dconditions();
/** * Gets a complete list of all values to insert into the prepared statement. * * @return array * An associative array of placeholders and values. */
public function arguments();
/** * Compiles the saved conditions for later retrieval. * * This method does not return anything, but simply prepares data to be * retrieved via __toString() and arguments(). * * @param $connection * The database connection for which to compile the conditionals. * @param $queryPlaceholder * The query this condition belongs to. If not given, the current query is * used. */