| @@ 80-94 (lines=15) @@ | ||
| 77 | return $qb; |
|
| 78 | } |
|
| 79 | ||
| 80 | public function getEventTypes() |
|
| 81 | { |
|
| 82 | $q = $this->getEntityManager()->createQueryBuilder() |
|
| 83 | ->select('e.event as event') |
|
| 84 | ->from($this->getEntityName(), 'e') |
|
| 85 | ->distinct() |
|
| 86 | ->orderBy('e.event ', 'asc') |
|
| 87 | ->getQuery(); |
|
| 88 | $result = array(); |
|
| 89 | foreach ($q->execute() as $next) { |
|
| 90 | $result[] = $next['event']; |
|
| 91 | } |
|
| 92 | ||
| 93 | return $result; |
|
| 94 | } |
|
| 95 | ||
| 96 | public function getDomains() |
|
| 97 | { |
|
| @@ 96-111 (lines=16) @@ | ||
| 93 | return $result; |
|
| 94 | } |
|
| 95 | ||
| 96 | public function getDomains() |
|
| 97 | { |
|
| 98 | $q = $this->getEntityManager()->createQueryBuilder() |
|
| 99 | ->select('e.domain as domain') |
|
| 100 | ->from($this->getEntityName(), 'e') |
|
| 101 | ->distinct() |
|
| 102 | ->orderBy('e.domain ', 'asc') |
|
| 103 | ->getQuery(); |
|
| 104 | ||
| 105 | $result = array(); |
|
| 106 | foreach ($q->execute() as $next) { |
|
| 107 | $result[] = $next['domain']; |
|
| 108 | } |
|
| 109 | ||
| 110 | return $result; |
|
| 111 | } |
|
| 112 | ||
| 113 | public function getRecipients() |
|
| 114 | { |
|
| @@ 113-128 (lines=16) @@ | ||
| 110 | return $result; |
|
| 111 | } |
|
| 112 | ||
| 113 | public function getRecipients() |
|
| 114 | { |
|
| 115 | $q = $this->getEntityManager()->createQueryBuilder() |
|
| 116 | ->select('e.recipient as recipient') |
|
| 117 | ->from($this->getEntityName(), 'e') |
|
| 118 | ->distinct() |
|
| 119 | ->orderBy('e.recipient ', 'asc') |
|
| 120 | ->getQuery(); |
|
| 121 | ||
| 122 | $result = array(); |
|
| 123 | foreach ($q->execute() as $next) { |
|
| 124 | $result[] = $next['recipient']; |
|
| 125 | } |
|
| 126 | ||
| 127 | return $result; |
|
| 128 | } |
|
| 129 | ||
| 130 | /** |
|
| 131 | * Get last known sender IP based on stored events list. |
|