function opening_hours_instance_load_multiple in Opening hours 7

Same name and namespace in other branches

1. 6 opening_hours.module \opening_hours_instance_load_multiple()

Load opening hours instances by nid and date.

1 call to opening_hours_instance_load_multiple()

opening_hours_crud_api_page in includes/opening_hours.pages.inc

The CRUD API for communication with Backbone.

File

./opening_hours.module, line 323

Opening hours module.

Code

function opening_hours_instance_load_multiple($nids, $from_date, $to_date) {

  // Make sure nids is an array.
  if (!is_array($nids)) {
    $nids = array(
      $nids,
    );
  }

  // Filter nids, so we don't pass nasty things to the database.
  $nids = array_filter($nids, 'is_numeric');
  $nids = array_filter($nids);
  $query = db_query("\n    SELECT * FROM {opening_hours} WHERE nid IN (:nids)\n    AND date BETWEEN :from_date AND :to_date\n    ORDER BY start_time\n  ", array(
    ':nids' => $nids,
    ':from_date' => $from_date,
    ':to_date' => $to_date,
  ));
  $results = array();
  foreach ($query as $row) {
    $results[] = opening_hours_instance_prepare($row);
  }

  // Alter instances if is needed.
  drupal_alter('opening_hours_instance_load_multiple', $results);
  return $results;
}