示例#1
0
 /**
  * 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;
 }