function insight_alerts_load_by_params in Insight 7

2 calls to insight_alerts_load_by_params()

insight_alert_load_by_params in ./insight.module

Loads one alert by params

insight_report_alerts_save in ./insight.module

File

./insight.module, line 432

Code

function insight_alerts_load_by_params($irid = NULL, $report_name = NULL, $alert_name = NULL, $nid = NULL, $path = NULL) {
  $query = db_select('insight_alert', 'a', array(
    'fetch' => PDO::FETCH_ASSOC,
  ))
    ->fields('a');
  if (isset($irid)) {
    $query
      ->condition('a.irid', $irid);
  }
  if (isset($report_name)) {
    $query
      ->condition('a.report', $report_name);
  }
  if (isset($alert_name)) {
    $query
      ->condition('a.name', $alert_name);
  }
  if (isset($nid)) {
    $query
      ->condition('a.nid', $nid);
  }
  elseif (isset($path)) {
    $query
      ->condition('a.path', $path);
  }
  $alerts = $query
    ->execute()
    ->fetchAllAssoc('name', PDO::FETCH_ASSOC);

  // Otherwise the set was not found.
  return $alerts;
}