public function get_event_messages($event_id)
{
$this->db->select('em.id, em.created, em.message, u.id as author_id, u.username as author_username, u.birthday as author_birthday, u.gender as author_gender');
$this->db->join($this->users_model->table . ' u', 'em.users_id = u.id');
$this->db->where('em.events_id', $event_id);
$messages = $this->db->get($this->table . ' em')->result_array();
if (!$messages) {
return [];
}
foreach ($messages as &$row) {
$row['author_avatar'] = $this->users_model->get_photo($row['author_id'], $this->users_model->avatar);
}
return $messages;
}
public function get_event_joined($event_id, $count = false)
{
$this->db->select('etu.created as join_date, u.id, u.username, u.birthday, u.gender');
$this->db->join($this->users_model->table . ' u', 'etu.users_id = u.id');
$this->db->where('etu.events_id', $event_id);
if ($count) {
return $this->db->count_all_results($this->table . ' etu');
}
$users = $this->db->get($this->table . ' etu')->result_array();
if (!$users) {
return [];
}
foreach ($users as &$row) {
$row['avatar'] = $this->users_model->get_photo($row['id'], $this->users_model->avatar);
}
return $users;
}
public function avatar_get()
{
$this->auth();
try {
$avatar = $this->model->get_photo($this->user_id, $this->model->avatar);
$this->response($avatar, 200);
} catch (Exception $e) {
$this->response($e->getMessage(), $e->getCode());
}
}
public function get_my_joined($user_id)
{
$this->db->select("e.*, e.users_id as creator_id, u.username as creator_username, u.birthday as creator_birthday, u.gender as creator_gender,\n (SELECT COUNT(etu.id) FROM {$this->etu_model->table} etu WHERE etu.events_id = e.id) as joined_count");
$this->db->join($this->users_model->table . ' u', 'e.users_id = u.id');
$this->db->join($this->etu_model->table . ' etu', 'etu.events_id = e.id', 'left');
$this->db->where('etu.users_id', $user_id);
$this->db->where('e.users_id !=', $user_id);
$events = $this->db->get($this->table . ' e')->result_array();
foreach ($events as &$event) {
$event['creator_avatar'] = $this->users_model->get_photo($event['users_id'], $this->users_model->avatar);
unset($event['users_id']);
$event['place_info'] = json_decode($event['place_info']);
}
return $events;
}
