@@ 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. |