/** * Gibt die Accountclientmessages der übergebenen AccountId und des Clientmessage Events zurück * @param integer $account_id * @param \DragonJsonServer\Event\Clientmessages $eventClientmessages * @return array */ public function getAccountclientmessagesByAccountIdAndEventClientmessages($account_id, \DragonJsonServer\Event\Clientmessages $eventClientmessages) { $entityManager = $this->getEntityManager(); return $entityManager->createQuery(' SELECT accountclientmessages FROM \\DragonJsonServerAccountclientmessage\\Entity\\Accountclientmessage accountclientmessages WHERE accountclientmessages.account_id = :account_id AND accountclientmessages.created >= :from AND accountclientmessages.created < :to AND accountclientmessages.key IN (:keys) ORDER BY accountclientmessages.created ')->execute(['account_id' => $account_id, 'from' => $eventClientmessages->getFrom(), 'to' => $eventClientmessages->getTo(), 'keys' => $eventClientmessages->getKeys()]); }