public function getTotalPage($idiom) { switch ($idiom) { case 'world': if (!Cache::has('totalWorldFacebookPages')) { $data['total'] = FacebookPage::count(); Cache::put('totalWorldFacebookPages', $data, 1440); } return Cache::get('totalWorldFacebookPages'); break; case 'hispanic': if (!Cache::has('totalHispanicFacebookPages')) { $data['total'] = FacebookPage::whereIdiom('es')->count(); Cache::put('totalHispanicFacebookPages', $data, 1440); } return Cache::get('totalHispanicFacebookPages'); break; } return 'Invalid method'; }
public function getTotalPage($idiom) { $var_cache = 'total' . ucfirst($idiom) . 'FacebookPages'; if (!Cache::has($var_cache)) { switch ($idiom) { case 'world': $data['total'] = FacebookPage::count(); break; case 'hispanic': $data['total'] = FacebookPage::whereIdiom('es')->count(); break; default: if (FacebookCountry::whereCode(strtolower($idiom))->first()) { $data['total'] = FacebookPage::where('country_code', strtoupper($idiom))->count(); } else { return 'Invalid method'; } } Cache::put($var_cache, $data, 1440); } return Cache::get($var_cache); }
public function getTotalPage($where, $category = 'all') { $where = strtolower($where); $var_cache = 'total' . ucfirst($where) . ucfirst($category) . 'FacebookPages'; if (!Cache::has($var_cache)) { $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) { $data['total'] = FacebookPage::whereCategoryId($id_category)->where(function ($query) { $query->whereParent(0)->orWhereRaw('id_page = parent'); })->count(); } else { $data['total'] = FacebookPage::whereParent(0)->orWhereRaw('id_page = parent')->count(); } break; case 'hispanic': if ($is_have_category) { $data['total'] = FacebookPage::whereIdiom('es')->whereCategoryId($id_category)->where(function ($query) { $query->whereParent(0)->orWhereRaw('id_page = parent'); })->count(); } else { $data['total'] = FacebookPage::whereIdiom('es')->where(function ($query) { $query->whereParent(0)->orWhereRaw('id_page = parent'); })->count(); } break; default: $country_idiom = FacebookCountry::whereIdiom($where)->first(); $country = FacebookCountry::whereSlug($where)->first(); if ($country) { if ($is_have_category) { $data['total'] = FacebookPageLocalFans::where('country_code', strtoupper($country->code))->whereCategoryId($id_category)->where(function ($query) { $query->whereParent(0)->orWhereRaw('id_page = parent'); })->count(); } else { $data['total'] = FacebookPageLocalFans::where('country_code', strtoupper($country->code))->where(function ($query) { $query->whereParent(0)->orWhereRaw('id_page = parent'); })->count(); } } elseif ($country_idiom) { if ($is_have_category) { $data['total'] = FacebookPage::whereIdiom($where)->whereCategoryId($id_category)->where(function ($query) { $query->whereParent(0)->orWhereRaw('id_page = parent'); })->count(); } else { $data['total'] = FacebookPage::whereIdiom($where)->where(function ($query) { $query->whereParent(0)->orWhereRaw('id_page = parent'); })->count(); } } else { return 'Invalid method'; } } Cache::put($var_cache, $data, 1440); } return Cache::get($var_cache); }