Query recent messages

RecentlyUsedAccounts.php

  <?php
namespace App\Console\Commands;

use App\Message;
use Carbon\Carbon;
use Illuminate\Console\Command;

class RecentlyUsedAccounts extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'account:recent';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Get recently used accounts';

    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * Execute the console command.
     *
     * @return mixed
     */
    public function handle()
    {
      $headers = [
              'id',
              'account', 
              'layout', 
              'pdf',
              'pdf_layout',
              'to',
              'reply',
              'cc',
              'bcc',
              'content',
              'subject',
              'hash',
              'opened',
              'clicked',
              'spammed',
              'entry_data',
              'local_id',
              'attachments',
              'spam_detected'
          ];

            $accounts = Message::all( $headers )->where( 'created_at', '<=', Carbon::now()->subMonth()->month )->toArray();

            $this->table($headers, $accounts);
      
    }
}