public function getUserInfoById($id)
{
$db = JFactory::getDbo();
$query = "SELECT u.*, su.provider, COUNT(DISTINCT fd.id) followers, COUNT(DISTINCT fr.id) following, f.id followed " . "FROM text_users u " . "LEFT JOIN text_follows fd ON (u.id=fd.followed_id) " . "LEFT JOIN text_follows fr ON (u.id=fr.follower_id) " . "LEFT JOIN text_follows f ON (u.id=f.followed_id) " . "LEFT JOIN text_slogin_users su ON (u.id=su.user_id) " . "WHERE u.id=" . $id . " group by u.id";
$db->setQuery($query);
$user_info = $db->loadObject();
$user_info->following = Ideary::getCountUsersWhoIAmFollowing($id);
$user_info->followers = Ideary::getCountUsersWhoFollowMe($id);
return $user_info;
}
public function get_users_who_follow_me()
{
// Get the application object.
$app = JFactory::getApplication();
$user_id = JRequest::getInt('user_id');
$user_id = $user_id ? $user_id : JFactory::getUser()->get('id');
$limit = JRequest::getInt('limit');
$offset = JRequest::getInt('offset');
$users = Ideary::getUsersWhoFollowMe($user_id, $offset, $limit);
$usersHtml = Ideary::generateUserListContent($users);
$countUsers = Ideary::getCountUsersWhoFollowMe($user_id);
echo json_encode(array('countUsers' => $countUsers, 'usersHtml' => $usersHtml));
$app->close();
}
