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