/** * Check for not-updated-today, not-deleted keywords * And set for rank update if exist * * daily */ public function queue_keywords_for_update() { $keyword_rank = new Keyword_rank(); $keyword_rank_ids = $keyword_rank->where('date', date('Y-m-d'))->get()->all_to_single_array('keyword_id'); if (empty($keyword_rank_ids)) { $keyword_rank_ids = array(0); } $keywords = new Keyword(); $keywords->where('is_deleted', 0)->where_not_in('id', $keyword_rank_ids)->get(); if (!$keywords->exists()) { log_message('CRON_ERROR', __FUNCTION__ . ' > ' . 'No keywords for rank update'); return; } $acc = $this->getAAC(); foreach ($keywords as $keyword) { $user = new User($keyword->user_id); if (!$user->exists()) { continue; } $acc->setUser($user); if (!$acc->isGrantedPlan('local_search_keyword_tracking')) { continue; } $args = $keyword->to_array(); $this->jobQueue->addJob('tasks/google_rank_task/grabber', $args, array('thread' => self::GOOGLE_RANK_THREAD)); } $ids_str = implode(', ', array_values($keywords->all_to_single_array('id'))); log_message('CRON_SUCCESS', __FUNCTION__ . ' > ' . 'Keywords for rank update ids: ' . $ids_str); return; }
public function listKeywords($dataaccountid, $start, $count, $orderby, $desc) { /* $details = new StdClass(); $details->host = 'localhost'; $details->database = 'data_17'; $details->username = '******'; $details->password = '******'; //Config::set('database.connections.mysqlCustom.database', $details->database); Config::set('database.connections.key', array( 'driver' => 'mysql', 'host' => 'localhost', 'database' => 'data_18', 'username' => 'root', 'password' => 'root', )); */ //Config::set('database.connections.account', ['driver' => 'mysql', 'host' => $details->host, 'database' => $details->database, 'username' => $details->username, 'password' => $details->password]); //Config::set('database.connections.default', 'account'); //DB::setDefaultConnection('account'); /* Config::set('database.connections.mysql_tenant.database', $details->database); DB::setDefaultConnection('mysql_tenant'); */ if ($desc == 'true') { $desc = 'desc'; } else { $desc = 'asc'; } $totalRows = Keyword::where('dataAccount', $dataaccountid)->count(); return Response::json(array('count' => $totalRows, 'data' => Keyword::where('dataAccount', $dataaccountid)->skip($start)->take($count)->orderBy($orderby, $desc)->get())); }
public function hourly_queue_keywords_for_update() { $keyword_rank = new Keyword_rank(); $keyword_rank_ids = $keyword_rank->where('date', date('Y-m-d'))->get()->all_to_single_array('keyword_id'); if (empty($keyword_rank_ids)) { $keyword_rank_ids = array(0); } $keywords = new Keyword(); $keywords->where('is_deleted', 0)->where_not_in('id', $keyword_rank_ids)->get(); if (!$keywords->exists()) { // log_message('CRON_ERROR', __FUNCTION__ . ' > ' . 'No keywords for rank update'); exit; } $all_args = array(); foreach ($keywords as $keyword) { $args = $keyword->to_array(); $all_args[] = $args; } foreach ($all_args as $keyword_array) { try { $this->hourly_queue_keywords_for_update_single($keyword_array); } catch (Exception $e) { echo "Error " . $e->getMessage() . "\n"; } } $ids_str = implode(', ', array_values($keywords->all_to_single_array('id'))); log_message('CRON_SUCCESS', __FUNCTION__ . ' > ' . 'Keywords for rank update ids: ' . $ids_str); exit; }
public function kw() { $keyword_rank = new Keyword_rank(); $keyword_rank_ids = $keyword_rank->where('date', date('Y-m-d'))->get()->all_to_single_array('keyword_id'); if (empty($keyword_rank_ids)) { $keyword_rank_ids = array(0); } $keywords = new Keyword(); $keywords->where('is_deleted', 0)->where_not_in('id', $keyword_rank_ids)->get(); foreach ($keywords as $keyword) { var_dump($keyword->id); } }
public static function createWordCloud2($dataaccountid) { $tagArray = []; $temp = []; $temp = Keyword::where('dataAccount', $dataaccountid)->get(array('keyword')); foreach ($temp as $key => $keywrd) { $temp = explode(" ", $keywrd->keyword); if (sizeof($temp) > 1) { if (isset($tagArray[$temp[0] . " " . $temp[1]])) { $tagArray[$temp[0] . " " . $temp[1]]++; } else { $tagArray[$temp[0] . " " . $temp[1]] = 1; } } } arsort($tagArray, SORT_NUMERIC); //Sort alphabetically $insertData = []; foreach ($tagArray as $word => $count) { $insertData[] = array('word' => $word, 'freq' => $count, 'numword' => 2, 'dataaccount' => $dataaccountid); } DB::table('wordcloud')->insert($insertData); return Response::json($tagArray); }
public function delete($user_id = NULL) { $user = $this->prepare_user($user_id); if ($this->ion_auth->is_admin($user_id)) { $url = 'manage_admins'; } elseif ($this->ion_auth->is_manager($user_id)) { $url = 'manage_accounts'; } else { $url = 'admin_users'; } if ($this->ion_auth->is_collaborator($user_id)) { $this->c_user->delete($user); } $user_deleted = $this->ion_auth->delete_user($user->id); if (!$user_deleted) { $this->addFlash(lang('delete_error', [$this->ion_auth->errors()])); redirect('admin/admin_users'); } $sender = $this->get('core.mail.sender'); $sender->sendUserDeleteMail(array('user' => $user)); $access_token = new Access_token(); $access_token->where('user_id', $user->id)->get()->delete_all(); $directory_user = new Directory_User(); $directory_user->where('user_id', $user->id)->get()->delete_all(); $facebook_fanpage = new Facebook_Fanpage(); $facebook_fanpage->where('user_id', $user->id)->get()->delete_all(); $keyword = new Keyword(); $keyword->where('user_id', $user->id)->get(); foreach ($keyword as $k) { $keyword_rank = new Keyword_rank(); $keyword_rank->where('keyword_id', $k->id)->get()->delete_all(); } $keyword->delete_all(); $media = new Media(); $media->where('user_id', $user->id)->get()->delete_all(); $post = new Post(); $post->where('user_id', $user->id)->get(); foreach ($post as $p) { $post_social = new Post_social(); $post_social->where('post_id', $p->id)->get()->delete_all(); } $post->delete_all(); $review = new Review(); $review->where('user_id', $user->id)->get()->delete_all(); $reviews_notification = new Reviews_notification(); $reviews_notification->where('user_id', $user->id)->get()->delete_all(); $rss_feeds_users = new Rss_feeds_users(); $rss_feeds_users->where('user_id', $user->id)->get()->delete_all(); $social_post = new Social_post(); $social_post->where('user_id', $user->id)->get()->delete_all(); $social_value = new Social_value(); $social_value->where('user_id', $user->id)->get()->delete_all(); $user_additional = new User_additional(); $user_additional->where('user_id', $user->id)->get()->delete_all(); $user_feed = new User_feed(); $user_feed->where('user_id', $user->id)->get()->delete_all(); $user_timezone = new User_timezone(); $user_timezone->where('user_id', $user->id)->get()->delete_all(); $this->addFlash(lang('delete_success'), 'success'); redirect('admin/' . $url); }
public function fetchDataSetsByUserId($userId) { // Return all data accounts $temp = []; // AUTHENTICATION NOT IMPLIMENTED //$dataac = DataAccount::where('user_id', $userId)->get(); $dataac = DataAccount::get(); foreach ($dataac as $k => $v) { $v->keywordCount = Keyword::where('dataAccount', $v->id)->count(); $v->landingPageUrls = $v->landingPageUrls()->get(); // Laravel's magic $temp[] = $v; } return Response::json($temp); //return Response::make(DataAccount::get()); return $userId; }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { // Delete the data account and all data associated with it $lp = DataAccount::find($id)->landingPageUrls()->get(); // Laravel's magic foreach ($lp as $v) { DB::table('landingpagewordcloud')->where('landing_page_urls_id', $v->id)->delete(); } DataAccount::find($id)->landingPageUrls()->delete(); DataAccount::destroy($id); Keyword::where('dataAccount', $id)->delete(); Stopword::where('dataAccount', $id)->delete(); Negativekeyword::where('dataAccount', $id)->delete(); DB::table('keywords_segment')->where('dataAccount', $id)->delete(); DB::table('segmentmap')->where('dataAccount', $id)->delete(); DB::table('wordcloud')->where('dataAccount', $id)->delete(); //DB::statement( 'drop database data_' . $id ); return Response::json(array('success' => true)); }