jazzus

public function __construct()
{
    $this->authorizeResource(Article::class, 'article');
}

User::withCount(['posts' => function($query) {
         $query->whereDate('created_at', '>=', now()->startOfWeek());
      }])
      ->orderByDesc('posts_count')
      ->take(3)
      ->get();

Article::whereYear('created_at', now()->year)
       ->whereMonth('created_at', now()->month)
       ->orWhere(function ($query) {
           $query->whereYear('created_at', now()->subYear()->year)
                 ->whereMonth('created_at', now()->month);
          })
       ->get()
       ->groupBy(function($article) {
           return Carbon::parse($article->created_at)
                        ->format('m-Y');
        });

как мне сохранять данные в смежной таблице

$user->posts()->attach($postId, [
  'active' => false
]);

$user->posts()->updateExistingPivot($postId, [
  'active' => true
]);

$this->authorize('download', $file);
return Storage::disk($disk)->download($path);

return !$post->isPaid or optional($user)->hasSubscription;

\DB::table('users')
   ->where('active', true)
   ->whereDate('updated_at', '<=', now()->subMonths(3))
   ->update(['active' => false]);