cacert-testmgr/manager/library/CAcert/User/Emails.php
2015-08-09 22:23:21 +02:00

60 lines
1.5 KiB
PHP

<?php
class CAcert_User_Emails {
private $db = null;
public function __construct($db) {
$this->db = $db;
}
/**
* get list of email addresses by login, needed to be able to filter emails
* @param string $addr
* @return array
*/
public function getEmailAddressesByLogin($addr) {
$db = $this->db;
/**
* find out user id by email address
*/
$sql = 'select users.id from users where email=?';
$id = $db->fetchOne($sql, array($addr));
/**
* get secondary email addresses
*/
$sql = 'select email.email from email where memid=?';
$res = $db->query($sql, array($id));
$emails = array();
$num = $res->rowCount();
for ($i = 0; $i < $num; $i++) {
$row = $res->fetch(PDO::FETCH_ASSOC);
$emails[] = $row['email'];
}
/**
* get additional addresses by domains
*/
$sql = 'select domains.domain from domains where memid=?';
$res = $db->query($sql, array($id));
$num = $res->rowCount();
$variants = array('root','hostmaster','postmaster','admin','webmaster');
for ($i = 0; $i < $num; $i++) {
$row = $res->fetch(PDO::FETCH_ASSOC);
foreach ($variants as $variant) {
$emails[] = $variant . '@' . $row['domain'];
}
}
// Log::Log()->debug(__METHOD__ . ' addresses ' . implode(',', $emails));
return $emails;
}
}