Ejemplo n.º 1
0
 public function getRankingPage($idiom, $category, $page = 1)
 {
     $where = ucfirst($idiom);
     $var_cache = 'rankingLikes' . $where . 'PageCat' . $category . '_' . ($page - 1) * 20;
     if (!Cache::has($var_cache)) {
         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)->orWhereRaw('id_page = parent');
                 break;
             case 'Hispanic':
                 $ranking->whereIdiom('es')->whereParent(0)->orWhereRaw('id_page = parent');
                 break;
             default:
                 if (FacebookCountry::whereCode(strtolower($where))->first()) {
                     $ranking->where('country_code', strtoupper($where));
                 } else {
                     return 'Invalid method';
                 }
         }
         if ($category != 'all') {
             $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']);
         }
         $pages = array();
         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'] = !empty($value['likes_grow_7']) ? $value['likes_grow_7'] : 0;
             $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']);
             }
             $pages[] = $cache;
         }
         Cache::put($var_cache, $pages, 1440);
     }
     return Cache::get($var_cache);
 }
Ejemplo n.º 2
0
 public function getRankingPage($idiom, $category, $page = 1)
 {
     $where = strtolower($idiom);
     $var_cache = 'rankingLikes' . ucfirst($where) . 'PageCat' . ucfirst($category) . '_' . ($page - 1) * 20;
     if (!Cache::has($var_cache)) {
         //if(true){
         $is_ranking_by_country = false;
         $country_idiom = FacebookCountry::whereIdiom($where)->first();
         if ($where != 'world' && $where != 'hispanic' && !$country_idiom) {
             $ranking = FacebookPageLocalFans::take(20)->skip(($page - 1) * 20)->orderBy('likes_local_fans', 'DESC')->orderBy('likes', 'DESC');
             $is_ranking_by_country = true;
         } else {
             $ranking = FacebookPage::take(20)->skip(($page - 1) * 20)->orderBy('likes', 'DESC')->orderBy('talking_about', 'DESC');
         }
         $is_have_category = false;
         $id_category = NULL;
         if ($category != 'all') {
             $category_search = FacebookCategory::whereCategory($category)->first();
             if ($category_search) {
                 $id_category = $category_search->id_category;
                 $is_have_category = true;
             } else {
                 return 'Invalid method';
             }
         }
         switch ($where) {
             case 'world':
                 if ($is_have_category) {
                     $ranking->whereCategoryId($id_category)->where(function ($query) {
                         $query->whereParent(0)->orWhereRaw('id_page = parent');
                     });
                 } else {
                     $ranking->whereParent(0)->orWhereRaw('id_page = parent');
                 }
                 break;
             case 'hispanic':
                 if ($is_have_category) {
                     $ranking->whereIdiom('es')->whereCategoryId($id_category)->where(function ($query) {
                         $query->whereParent(0)->orWhereRaw('id_page = parent');
                     });
                 } else {
                     $ranking->whereIdiom('es')->where(function ($query) {
                         $query->whereParent(0)->orWhereRaw('id_page = parent');
                     });
                 }
                 break;
             default:
                 $country = FacebookCountry::whereSlug($where)->first();
                 if ($country) {
                     if ($is_have_category) {
                         $ranking->where('country_code', strtoupper($country->code))->whereCategoryId($id_category)->where(function ($query) {
                             $query->whereParent(0)->orWhereRaw('id_page = parent');
                         });
                     } else {
                         $ranking->where('country_code', strtoupper($country->code))->where(function ($query) {
                             $query->whereParent(0)->orWhereRaw('id_page = parent');
                         });
                     }
                 } elseif ($country_idiom) {
                     if ($is_have_category) {
                         $ranking->whereIdiom($where)->whereCategoryId($id_category)->where(function ($query) {
                             $query->whereParent(0)->orWhereRaw('id_page = parent');
                         });
                     } else {
                         $ranking->whereIdiom($where)->where(function ($query) {
                             $query->whereParent(0)->orWhereRaw('id_page = parent');
                         });
                     }
                 } else {
                     return 'Invalid method';
                 }
         }
         if ($is_ranking_by_country) {
             $ranking = $ranking->get(['category_id', 'fb_id', 'username', 'name', 'is_verified', 'likes', 'likes_grow_7', 'talking_about', 'likes_local_fans']);
         } else {
             $ranking = $ranking->get(['category_id', 'fb_id', 'username', 'name', 'is_verified', 'likes', 'likes_grow_7', 'talking_about', 'country_code', 'country_slug', 'first_country_code', 'first_country_slug']);
         }
         $pages = array();
         foreach ($ranking as $key => $value) {
             $cache = NULL;
             $cache['category_id'] = $value['category_id'];
             $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'];
             if (!$is_ranking_by_country) {
                 $cache['country']['code'] = strtolower(!empty($value['country_code']) ? $value['country_code'] : $value['first_country_code']);
                 $cache['country']['slug'] = !empty($value['country_slug']) ? $value['country_slug'] : $value['first_country_slug'];
             }
             $pta = 0;
             if ($value['likes'] > 0) {
                 $pta = $this->owlooFormatPorcent($value['talking_about'], $value['likes']);
             }
             //PTA
             $cache['second_column'][] = array('value' => $pta . '%', 'class' => '');
             //Semana
             $aux_num = $this->formatGrow($value['likes_grow_7'], $value['likes']);
             $cache['second_column'][] = array('value' => $aux_num['value'], 'class' => $aux_num['class']);
             //Fans totales
             $cache['second_column'][] = array('value' => $this->owloo_number_format($value['likes']), 'class' => '');
             if ($is_ranking_by_country) {
                 //Fans locales
                 $cache['second_column'][] = array('value' => $this->owloo_number_format($value['likes_local_fans']), 'class' => '');
             }
             $pages[] = $cache;
         }
         $second_column = array();
         if ($is_ranking_by_country) {
             $second_column = array('PTA', 'Semana', 'Fans totales', 'Fans locales');
         } else {
             $second_column = array('País', 'PTA', 'Semana', 'Fans totales');
         }
         $array_result = array('type' => 'fb_page', 'subtype' => $is_ranking_by_country ? 'fb_country_page' : 'fb_all_pages', 'main_column' => 'Página', 'second_column' => $second_column, 'large_column' => 3, 'link' => 'facebook-analytics/pages', 'items' => $pages);
         Cache::put($var_cache, $array_result, 1440);
     }
     return Cache::get($var_cache);
 }