Ejemplo n.º 1
0
 /** 
  * Import user accounts from wordpress
  *
  * @param int $limit
  * The amount of records to import at one time
  */
 public function import($limit = 0)
 {
     $count = 0;
     $table = $this->model->table;
     $id = (int) DB::table($table)->max('id');
     $wordpressLogs = $this->db->table('wp_badgeos_logs')->where('id', '>', $id)->orderBy('id', 'asc')->limit($limit)->get();
     // Use dummy model to get action types
     $l = new $this->model();
     foreach ($wordpressLogs as $wlog) {
         if (!in_array($wlog->action, $l->actionTypes)) {
             continue;
         }
         $object = false;
         $log = new $this->model();
         $log->id = $wlog->id;
         $log->user_id = $wlog->user_id;
         $log->action = $wlog->action;
         $log->message = $wlog->message;
         $log->points_earned = $wlog->points_earned;
         $log->total_points = $wlog->total_points;
         $log->timestamp = $wlog->timestamp;
         $log->timezone = $wlog->timezone;
         if ($wlog->action == 'artwork') {
             $log->artwork_id = $wlog->object_id;
             $object = OctoberActivity::where('activity_type', '=', 'LikeWorkOfArt')->first();
         } else {
             // Get the wordpress post type
             $post_type = $this->db->table('wp_posts')->select('post_type')->where('ID', $wlog->object_id)->first();
             if (isset($post_type->post_type)) {
                 // Convert the post type to a usable object model
                 switch ($post_type->post_type) {
                     case 'activity':
                         $object = OctoberActivity::findWordpress($wlog->object_id);
                         break;
                     case 'badge':
                         $object = OctoberBadge::findWordpress($wlog->object_id);
                         break;
                     case 'badgeos-rewards':
                         $object = OctoberReward::findWordpress($wlog->object_id);
                         break;
                     case 'dma-location':
                         $object = OctoberLocation::findWordpress($wlog->object_id);
                         break;
                     case 'step':
                         $object = OctoberStep::findWordpress($wlog->object_id);
                         break;
                     default:
                         continue;
                 }
             } else {
                 continue;
             }
         }
         try {
             if ($log->save()) {
                 // If the log is related to an object, save that relation
                 if ($object) {
                     $object = $object->first();
                     // Ugly hack to get sync working for now
                     if (get_class($object) == 'DMA\\Friends\\Wordpress\\ActivityLog') {
                         continue;
                     }
                     $object->activityLogs()->save($log);
                 }
                 $count++;
             }
         } catch (Exception $e) {
             echo "Failed to import log entry id: " . $log->id . "\n";
             echo $e->getMessage() . "\n";
         }
     }
     return $count;
 }
 /** 
  * Execute the console command.
  * @return void
  */
 public function fire()
 {
     // Taxonomy terms
     $termRelations = $this->db->table('wp_term_relationships')->get();
     foreach ($termRelations as $relation) {
         $activity = Activity::findWordpress($relation->object_id)->first();
         if ($activity) {
             if (!$activity->categories->contains($relation->term_taxonomy_id)) {
                 $category = Category::find($relation->term_taxonomy_id);
                 if ($category) {
                     $activity->categories()->save($category);
                 }
             }
         }
     }
     // p2p connections
     $p2ps = $this->db->table('wp_p2p')->get();
     foreach ($p2ps as $p2p) {
         list($from, $t, $to) = explode('-', $p2p->p2p_type);
         switch ($from) {
             case 'activity':
                 $from = Activity::findWordpress($p2p->p2p_from)->first();
                 $from_table = 'activity';
                 break;
             case 'badge':
                 $from = Badge::findWordpress($p2p->p2p_from)->first();
                 $from_table = 'badge';
                 break;
             case 'dma-location':
                 $from = Location::findWordpress($p2p->p2p_from)->first();
                 $from_table = 'location';
                 break;
             case 'step':
                 $from = Step::findWordpress($p2p->p2p_from)->first();
                 $from_table = 'step';
                 break;
             default:
                 $from = false;
         }
         switch ($to) {
             case 'activity':
                 $to = Activity::findWordpress($p2p->p2p_to)->first();
                 $to_table = 'activity';
                 break;
             case 'badge':
                 $to = Badge::findWordpress($p2p->p2p_to)->first();
                 $to_table = 'badge';
                 break;
             case 'dma-location':
                 $to = Location::findWordpress($p2p->p2p_to)->first();
                 $to_table = 'location';
                 break;
             case 'step':
                 $to = Step::findWordpress($p2p->p2p_to)->first();
                 $to_table = 'step';
                 break;
             default:
                 $to = false;
         }
         if ($from && $to) {
             $table = 'dma_friends_' . $from_table . '_' . $to_table;
             switch ($table) {
                 case 'dma_friends_activity_step':
                     $from->steps()->save($to);
                     $this->info('activity: ' . $from->title . ' --> step: ' . $to->title);
                     break;
                 case 'dma_friends_step_badge':
                     $to->steps()->save($from);
                     $this->info('step: ' . $from->title . ' --> badge: ' . $to->title);
                     break;
                 default:
                     $values = [$from_table . '_id' => $from->id, $to_table . '_id' => $to->id];
                     if (Schema::hasTable($table)) {
                         DB::table($table)->insert($values);
                         $this->info('from: ' . $from->title . ' ----- ' . $to->title);
                     } else {
                         $this->error('table doesnt exist: ' . $table);
                     }
             }
         }
     }
     // User achievements
     $achievements = $this->db->table('wp_usermeta')->where('meta_key', '_badgeos_achievements')->get();
     $post = new Post();
     $this->info('Sync Achievements');
     foreach ($achievements as $achievement) {
         $user = User::find($achievement->user_id);
         if (empty($user)) {
             continue;
         }
         // Flush existing records
         DB::table($this->userStepTable)->where('user_id', $user->id)->delete();
         DB::table($this->userBadgeTable)->where('user_id', $user->id)->delete();
         $data = unserialize($achievement->meta_value);
         // wtf we don't need arrays in our arrays if we want to array
         $data = array_pop($data);
         foreach ($data as $d) {
             $link = ['user_id' => $user->id, 'created_at' => $post->epochToTimestamp($d->date_earned)];
             // About half way thru the data for the location key changes.
             // so lets deal with that
             if (isset($d->location)) {
                 $location_id = $d->location;
             } elseif (isset($d->location_earned)) {
                 $location_id = $d->location_earned;
             } else {
                 $location_id = null;
             }
             $location = Location::findWordpress($location_id)->first();
             if (isset($location->id)) {
                 $link['location_id'] = $location->id;
             }
             if ($d->post_type == 'step') {
                 $step = Step::findWordpress($d->ID)->first();
                 if ($step) {
                     $link['step_id'] = $step->id;
                     DB::table($this->userStepTable)->insert($link);
                 }
             } elseif ($d->post_type == 'badge') {
                 $badge = Badge::findWordpress($d->ID)->first();
                 if ($badge) {
                     $link['badge_id'] = $badge->id;
                     DB::table($this->userBadgeTable)->insert($link);
                 }
             }
         }
     }
     // Syncronize activities and users
     $this->info('Importing Activity/User relations');
     $table = 'dma_friends_activity_user';
     DB::table($table)->delete();
     ActivityLog::where('action', '=', 'activity')->chunk(100, function ($activityLogs) use($table) {
         foreach ($activityLogs as $activityLog) {
             if ($activityLog->object_id) {
                 echo '.';
                 $pivotTable = ['user_id' => $activityLog->user_id, 'activity_id' => $activityLog->object_id, 'created_at' => $activityLog->timestamp, 'updated_at' => $activityLog->timestamp];
                 DB::table($table)->insert($pivotTable);
             }
         }
     });
     // Syncronize rewards and users
     $this->info('Importing Reward/User relations');
     $table = 'dma_friends_reward_user';
     //DB::table($table)->delete();
     ActivityLog::where('action', '=', 'reward')->where('timestamp', '<', '2015-02-02 12:10:35')->chunk(100, function ($activityLogs) use($table) {
         foreach ($activityLogs as $activityLog) {
             if ($activityLog->object_id) {
                 echo '.';
                 if (Reward::find($activityLog->object_id) && User::find($activityLog->user_id)) {
                     $pivotTable = ['user_id' => $activityLog->user_id, 'reward_id' => $activityLog->object_id, 'created_at' => $activityLog->timestamp, 'updated_at' => $activityLog->timestamp];
                     DB::table($table)->insert($pivotTable);
                 }
             }
         }
     });
     $this->info('Sync complete');
 }