/**
* Execute the console command.
*
* @return void
*/
public function fire()
{
DB::connection()->disableQueryLog();
$conn = DB::connection('stats');
$conn->disableQueryLog();
$conn->statement('pragma synchronous = off;');
$firstDay = Carbon::create(2013, 1, 1);
$x = 1;
$weekAgo = Carbon::today()->subWeek();
$actions = UserAction::where('created_at', '>', $weekAgo)->get();
// Delete old data first
$fromDay = $weekAgo->diffInDays($firstDay);
$conn->table('daily_actions')->where('day', '>=', $fromDay)->delete();
foreach ($actions as $action) {
$object = $action->element;
if (!$object) {
continue;
}
$day = $object->created_at->diffInDays($firstDay);
$points = $this->calculatePoints($action, $object);
$fieldName = $this->getFieldName($action);
$query = $conn->table('daily_actions')->where('day', $day)->where('user_id', $action->user_id)->where('group_id', $object->group_id);
// First try to increase existing record
$result = $query->increment($fieldName);
if ($result) {
$query->increment('uv', $object->uv);
$query->increment('uv', $object->dv);
if ($points > 0) {
$query->increment('points', $points);
}
if ($points < 0) {
$query->decrement('points', $points);
}
} else {
$data = ['day' => $day, 'user_id' => $action->user_id, 'group_id' => $object->group_id, 'uv' => $object->uv, 'dv' => $object->dv, 'contents' => 0, 'comments' => 0, 'entries' => 0, 'points' => $points];
$data[$fieldName] = 1;
$conn->table('daily_actions')->insert($data);
}
// Show progress
if (!($x++ % 100)) {
$this->info($x . ' actions processed');
}
}
$this->info('All actions processed');
}