public function AssetOrLocationArgument::query in farmOS 2.x

Set up the query for this argument.

The argument sent may be found at $this->argument.

Overrides ArgumentPluginBase::query

File

modules/core/ui/views/src/Plugin/views/argument/AssetOrLocationArgument.php, line 18

Class

AssetOrLocationArgument

Argument handler for both the asset and location fields on logs.

Namespace

Drupal\farm_ui_views\Plugin\views\argument

Code

public function query($group_by = FALSE) {

  // Join the log__asset table with a condition to match the asset ID.
  $this
    ->ensureMyTable();

  /** @var \Drupal\views\Plugin\views\join\JoinPluginBase $join */
  $join = Views::pluginManager('join')
    ->createInstance('standard', [
    'table' => 'log__asset',
    'field' => 'entity_id',
    'left_table' => $this->table,
    'left_field' => 'id',
    'extra' => [
      [
        'field' => 'deleted',
        'value' => 0,
      ],
      [
        'field' => 'asset_target_id',
        'value' => $this->argument,
      ],
    ],
  ]);
  $asset_alias = $this->query
    ->addRelationship('log__asset', $join, $this->table);

  // Join the log__location table with a condition to match the asset ID.

  /** @var \Drupal\views\Plugin\views\join\JoinPluginBase $join */
  $join = Views::pluginManager('join')
    ->createInstance('standard', [
    'table' => 'log__location',
    'field' => 'entity_id',
    'left_table' => $this->table,
    'left_field' => 'id',
    'extra' => [
      [
        'field' => 'deleted',
        'value' => 0,
      ],
      [
        'field' => 'location_target_id',
        'value' => $this->argument,
      ],
    ],
  ]);
  $location_alias = $this->query
    ->addRelationship('log__location', $join, $this->table);

  // Limit the query to only include logs that reference the asset on the
  // asset OR location field. This must be added in a single where expression
  // so the condition is not combined with other filters from the view.
  $asset_condition = "{$asset_alias}.asset_target_id IS NOT NULL";
  $location_condition = "{$location_alias}.location_target_id IS NOT NULL";
  $this->query
    ->addWhereExpression(0, "{$this->table}.id IS NOT NULL AND ({$asset_condition} OR {$location_condition})");
}