public function get_unread_chats_username($me_user_id)
{
$output = array();
$model = new Common_model();
$redis_functions = new Redisfunctions();
$me_username = $model->fetchSelectedData('user_username', TABLE_USERS, array('user_id' => $me_user_id))[0]['user_username'];
$deleted_message_ids = $redis_functions->get_deleted_message_ids($me_username);
$where_str = '`message_user_to` = ' . $me_user_id . ' and `message_read` = "0"';
if (!empty($deleted_message_ids)) {
$imploded_message_id = implode(',', $deleted_message_ids);
$where_str .= ' AND message_id NOT IN (' . $imploded_message_id . ')';
}
$sql = 'select distinct user_username as from_username from ' . TABLE_MESSAGES . ' left join `users` on user_id = `message_user_from` where ' . $where_str;
$records = $this->db->query($sql)->result_array();
if (!empty($records)) {
foreach ($records as $value) {
$output[] = $value['from_username'];
}
}
return $output;
}
