/**
* Given a queue event ID, find the corresponding email address.
*
* @param int $queue_id The queue event ID
* @return string The email address
* @access public
* @static
*/
function getEmailAddress($queue_id)
{
$email = CRM_Core_BAO_Email::getTableName();
$eq = CRM_Mailing_Event_BAO_Queue::getTableName();
$query = " SELECT {$email}.email as email \n FROM {$email} \n INNER JOIN {$eq} \n ON {$eq}.email_id = {$email}.id \n WHERE {$eq}.id = " . CRM_Utils_Type::rule($queue_id, 'Integer');
$q =& new CRM_Mailing_Event_BAO_Queue();
$q->query($query);
if (!$q->fetch()) {
return null;
}
return $q->email;
}
