public function PrivateHeartbeat::addViewQuery in Heartbeat 6.4

Function to add a part of a sql to a query built by views UI

Parameters

object $view The view handler object by reference to add our part to the query:

Overrides HeartbeatAccess::addViewQuery

File

includes/privateheartbeat.inc, line 43

Class

PrivateHeartbeat

Class PrivateHeartbeat Concrete class to prepare messages for the current user only

Code

public function addViewQuery(&$view) {

  // Make the sql limited to the access
  $field = "{$view->table_alias}.{$view->real_field}";
  $view->query
    ->set_where_group('OR', 'orgroup');
  $sql = "{$field} = %d  AND {$view->table_alias}.access > %d ";
  $view->query
    ->add_where('orgroup', $sql, $this->_uid, HEARTBEAT_PRIVATE);
  $sql = "({$view->table_alias}.uid_target = %d AND {$view->table_alias}.access > %d)";
  $view->query
    ->add_where('orgroup', $sql, $this->_uid, HEARTBEAT_PUBLIC_TO_ADDRESSEE);
}