private function searchAccountInDB($username, $social_network) { switch ($social_network) { case 'facebook': $data = FacebookPage::whereUsername($username)->first(['fb_id', 'username', 'name']); break; case 'twitter': $data = TwitterProfile::whereScreenName($username)->first(['screen_name', 'name', 'picture']); break; case 'instagram': $data = InstagramProfile::whereUsername($username)->first(['username', 'name', 'picture']); break; default: return 'Invalid method'; break; } if ($data) { $page['username'] = strtolower(isset($data['username']) ? $data['username'] : $data['screen_name']); $page['name'] = !empty($data['name']) ? $data['name'] : $page['username']; $page['picture'] = $social_network == 'facebook' ? 'http://graph.facebook.com/' . $data['fb_id'] . '/picture?height=200&type=normal&width=200' : str_replace('_normal.', '_200x200.', $data['picture']); return $page; } else { return NULL; } }
public function getRankingPageGrow($idiom) { $where = ucfirst($idiom); $var_cache = 'rankingGrowLikes' . $where; if (!Cache::has($var_cache)) { $ranking = FacebookPage::take(4)->orderBy('likes_grow_30', 'DESC'); switch ($where) { case 'All': $ranking->whereParent(0)->orWhereRaw('id_page = parent'); break; case 'Es': $ranking->whereIdiom('es')->whereParent(0)->orWhereRaw('id_page = parent'); break; /*case 'It': $ranking->whereIdiom('it')->whereParent(0)->orWhereRaw('id_page = parent'); break;*/ /*case 'It': $ranking->whereIdiom('it')->whereParent(0)->orWhereRaw('id_page = parent'); break;*/ default: return 'Invalid method'; } $ranking = $ranking->get(['fb_id', 'username', 'name', 'likes', 'likes_grow_30']); $pages = array(); foreach ($ranking as $key => $value) { $cache = NULL; $cache['username'] = strtolower($value['username']); $cache['name'] = $value['name']; $cache['picture'] = 'https://graph.facebook.com/' . $value['fb_id'] . '/picture?type=large'; $cache['percent'] = 0; if ($value['likes'] - $value['likes_grow_30'] > 0) { $cache['percent'] = $this->owlooFormatPorcent($value['likes_grow_30'], $value['likes'] - $value['likes_grow_30']); } $cache['grow_30'] = $this->owloo_number_format($value['likes_grow_30']); $pages[] = $cache; } Cache::put($var_cache, $pages, 1440); } return Cache::get($var_cache); }
public function getLastPageAdded($idiom, $limit = 4) { $where = strtolower($idiom); $var_cache = 'lastFacebookPageAdded' . ucfirst($where) . $limit; if (!Cache::has($var_cache)) { $ranking = FacebookPage::take($limit)->orderBy('id_page', 'DESC'); switch ($where) { case 'all': $ranking->whereParent(0)->orWhereRaw('id_page = parent'); break; default: $country_idiom = FacebookCountry::whereIdiom($where)->first(); if ($country_idiom) { $ranking->whereIdiom($where)->where(function ($query) { $query->whereParent(0)->orWhereRaw('id_page = parent'); }); } else { return 'Invalid method'; } } $ranking = $ranking->get(['fb_id', 'username', 'name']); $pages = array(); foreach ($ranking as $key => $value) { $cache = NULL; $cache['username'] = strtolower($value['username']); $cache['name'] = $value['name']; $cache['picture'] = 'https://graph.facebook.com/' . $value['fb_id'] . '/picture?type=large'; $pages[] = $cache; } Cache::put($var_cache, $pages, 1440); } return Cache::get($var_cache); }
public function getTotalUsers() { return FacebookPage::whereActive('1')->count(); }
<?php error_reporting(E_ALL); ini_set('display_errors', true); require_once __DIR__ . '/vendor/autoload.php'; require_once __DIR__ . '/FacebookPage.php'; require_once __DIR__ . '/config.inc.php'; $limit = 1; $id = '245916628859249'; $token = 'CAACWiAlh00MBAK5CZCZBfCx08JQEkZCcu9BBL2rXQH1o9IUzql4tJfy4bTp1lsjT4MjFFwaJ2Q6sdWZBkBM9NEFoLHrM3UmGcjbggmcHQeoZCYx5WkMaQpGJmKrGmHik3nbiuJE2RnJEtWDZC9snMkFFU0IcZBDSCORITtyl4yo6ZA7utUHBw74b'; $page = new FacebookPage($config, $pageConfig); $posts = $page->getPosts(10); ?> <!DOCTYPE html> <html id="top"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Facebook Page Posts example</title> <meta name="description" content="Mode, kleding, jurken, fashion, online shop ✔ Geen retourkosten ✔ Veilig betalen ✔ Een outfit voor elk moment!" /> <meta name="keywords" content="" /> <meta name="robots" content="INDEX,FOLLOW" /> <link rel="stylesheet" type="text/css" href="styles.css" media="all" /> <meta name="viewport" content="initial-scale=1.0, width=device-width" /> </head> <body > <div class="wrapper"> <ol class="fb-posts"> <?php foreach ($posts as $post) { ?>
public function getRankingPageDev($where, $category, $page = 1) { $where = ucfirst($where); if (!Cache::has('rankingLikes' . $where . 'PageCat' . $category . '_' . ($page - 1) * 20)) { if ($where != 'World' && $where != 'Hispanic') { $ranking = FacebookPageLocalFans::take(20)->skip(($page - 1) * 20)->orderBy('likes_local_fans', 'DESC')->orderBy('likes', 'DESC'); } else { $ranking = FacebookPage::take(20)->skip(($page - 1) * 20)->orderBy('likes', 'DESC')->orderBy('talking_about', 'DESC'); } switch ($where) { case 'World': $ranking->whereParent(0); break; case 'Hispanic': $ranking->whereIdiom('es')->whereParent(0); break; default: if (FacebookPage::whereCode(strtolower($where))) { $ranking->where('country_code', strtoupper($where)); } else { return 'Invalid method'; } } if ($category != 'all' && is_numeric($category)) { $ranking->where('Category_id', $category); } if ($where != 'World' && $where != 'Hispanic') { $ranking = $ranking->get(['fb_id', 'username', 'name', 'is_verified', 'likes', 'likes_grow_7', 'talking_about', 'likes_local_fans']); } else { $ranking = $ranking->get(['fb_id', 'username', 'name', 'is_verified', 'likes', 'likes_grow_7', 'talking_about', 'country_code', 'first_country_code']); } foreach ($ranking as $key => $value) { $cache = NULL; $cache['position'] = ($page - 1) * 20 + $key + 1; $cache['username'] = strtolower($value['username']); $cache['name'] = $value['name']; $cache['picture'] = 'http://graph.facebook.com/' . $value['fb_id'] . '/picture?height=50&type=normal&width=50'; $cache['is_verified'] = $value['is_verified']; $cache['likes'] = $this->owloo_number_format($value['likes']); $cache['grow_7'] = $value['likes_grow_7']; $cache['pta'] = 0; if ($value['likes'] > 0) { $cache['pta'] = $this->owlooFormatPorcent($value['talking_about'], $value['likes']); } if ($where != 'World' && $where != 'Hispanic') { $cache['likes_local_fans'] = $this->owloo_number_format($value['likes_local_fans']); } else { $cache['country'] = strtolower(!empty($value['country_code']) ? $value['country_code'] : $value['first_country_code']); } $var = 'rankingLikes' . $where . 'PageCat' . $category . '_' . (($page - 1) * 20 + $key); Cache::put($var, $cache, 1440); } } $from = ($page - 1) * 20; $to = $page * 20 - 1; $foo = array(); for ($from; $from <= $to; $from++) { $var = 'rankingLikes' . $where . 'PageCat' . $category . '_' . $from; $foo[$from] = Cache::get($var); } return $foo; }
/** * Return facebook posts. * * @todo: Make posts clickable * */ error_reporting(E_ALL); ini_set('display_errors', true); require_once __DIR__ . '/vendor/autoload.php'; require_once __DIR__ . '/FacebookPage.php'; require_once __DIR__ . '/config.inc.php'; $limit = 1; $id = '245916628859249'; $token = 'CAACWiAlh00MBAK5CZCZBfCx08JQEkZCcu9BBL2rXQH1o9IUzql4tJfy4bTp1lsjT4MjFFwaJ2Q6sdWZBkBM9NEFoLHrM3UmGcjbggmcHQeoZCYx5WkMaQpGJmKrGmHik3nbiuJE2RnJEtWDZC9snMkFFU0IcZBDSCORITtyl4yo6ZA7utUHBw74b'; $page = new FacebookPage($config, $pageConfig); $posts = $page->getPosts(getCount()); $content = '<div class="fb-content"><h2>Boerhaavegroep op Facebook</h2><div id="fb-wrap">'; $content .= '<ol id="fb-carousel" class="fb-posts group">'; foreach ($posts as $post) { if (empty($post['media']['photos'])) { continue; } $content .= '<li>'; $content .= '<a href="' . $post['url'] . '" target="_blank">'; $content .= '<p class="message">' . $post['message'] . '</p>'; $content .= '<div class="image">'; $content .= '<img src="' . $post['media']['main_image']['src'] . '" height="320">'; if (count($post['media']['photos']) > 1) { $content .= '<div class="photos">' . count($post['media']['photos']) . '</div>'; }