function fetch_first_emails in Event Calendar 7

Function to fetch adminitrater email from user table.

1 call to fetch_first_emails()

_event_calendar_email_reciepents in ./event_calendar.module

Returns a list of email reciepents.

File

./event_calendar.module, line 175

The module file that allows events to be created and required admin approval.

Code

function fetch_first_emails($rid) {

  // Build query to fetch Emails.
  $query = db_select('users', 'u');
  $query
    ->join('users_roles', 'ur', 'u.uid = ur.uid');
  $query
    ->fields('u', array(
    'mail',
  ))
    ->condition('ur.rid', $rid)
    ->orderBy('u.uid', 'ASC')
    ->range(0, 1);
  $users = $query
    ->execute();
  $emails = array();
  foreach ($users as $user) {
    $emails[] = $user->mail;
  }
  return $emails;
}