/**
* 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()]);
}
/**
* Gibt die Avatarnachrichten für den Avatar und die Clientmessages zurück
* @param \DragonJsonServerAvatar\Entity\Avatar $avatar
* @param \DragonJsonServer\Event\Clientmessages $eventClientmessages
* @return array
*/
public function getAvatarmessagesByEventClientmessages(\DragonJsonServerAvatar\Entity\Avatar $avatar, \DragonJsonServer\Event\Clientmessages $eventClientmessages)
{
$entityManager = $this->getEntityManager();
return $entityManager->createQuery("\n\t\t\t\tSELECT avatarmessage FROM \\DragonJsonServerAvatarmessage\\Entity\\Avatarmessage avatarmessage\n\t\t\t\tWHERE\n\t\t\t\t\tavatarmessage.to_avatar = :to_avatar_id\n\t\t\t\t\tAND\n\t\t\t\t\tavatarmessage.to_state = 'new'\n\t\t\t\t\tAND\n\t\t\t\t\tavatarmessage.created >= :from AND avatarmessage.created < :to \n\t\t\t")->execute(['to_avatar_id' => $avatar->getAvatarId(), 'from' => $eventClientmessages->getFrom(), 'to' => $eventClientmessages->getTo()]);
}