/**
* @param \Wonderland\Application\Model\Member $author
*
* @return array
*/
public function findByAuthor(Member $author)
{
$statement = $this->connection->prepareStatement('SELECT m.id, m.title, m.content, m.created_at, m.opened_at, ' . 'u.id as recipient_id, u.avatar as recipient_avatar, u.identity as recipient_identity, ' . 'FROM messages m ' . 'INNER JOIN users u ON u.id = m.recipient_id ' . 'WHERE m.author_id = :author_id AND m.deleted_by_author = 0', ['author_id' => $author->getId()]);
$result = [];
while ($data = $statement->fetch(\PDO::FETCH_ASSOC)) {
$data['author_id'] = $author->getId();
$data['author_identity'] = $author->getIdentity();
$data['author_avatar'] = $author->getAvatar();
$result[] = $this->formatObject($data);
}
return $result;
}
/**
* @param \Wonderland\Application\Model\Member $member
* @return boolean|array
*/
public function update(Member $member)
{
$statement = $this->connection->prepareStatement('UPDATE users SET login = :login, password = :password, salt = :salt, ' . 'identity = :identity, email = :email, avatar = :avatar, ' . 'language = :language, country_id = :country_id, region_id = :region_id, ' . 'last_connected_at = :last_connected_at, created_at = :created_at, ' . 'is_enabled = :is_enabled, is_banned = :is_banned WHERE id = :id', ['login' => $member->getLogin(), 'password' => $member->getPassword(), 'salt' => $member->getSalt(), 'identity' => $member->getIdentity(), 'email' => $member->getEmail(), 'avatar' => $member->getAvatar(), 'language' => $member->getLanguage(), 'country_id' => $member->getCountry()->getId(), 'region_id' => $member->getRegion()->getId(), 'last_connected_at' => $member->getLastConnectedAt()->format('c'), 'created_at' => $member->getCreatedAt()->format('c'), 'is_enabled' => (int) $member->getIsEnabled(), 'is_banned' => (int) $member->getIsBanned(), 'id' => $member->getId()]);
if ($statement->rowCount() === 0) {
return $statement->errorInfo();
}
return true;
}
/**
* @return array
*/
public function jsonSerialize()
{
return ['id' => $this->id, 'title' => $this->title, 'content' => $this->content, 'author' => ['id' => $this->author->getId(), 'identity' => $this->author->getIdentity(), 'avatar' => $this->author->getAvatar()], 'recipient' => ['id' => $this->recipient->getId(), 'identity' => $this->recipient->getIdentity(), 'avatar' => $this->recipient->getAvatar()], 'created_at' => $this->createdAt, 'opened_at' => $this->openedAt];
}
