class Messages extends Model
{
    protected $table = 'messages';
    protected $fillable = [
        'project_user_id',
        'newsletter_id',
        'project_id',
        'type',
        'statuses',
        'delivered',
        'opened',
        'clicked',
        'spam',
        'temporary_fail',
        'permanent_fail',
        'unsubscribed',
    ];
    protected $casts = [
        'statuses' => 'array'
    ];

public function getDashboardStats()
    {
        return [
            'messages' => $this
                ->filteredByProject()
                ->filteredByDateRange()
                ->count(),
            'opened' => $this
                ->filteredByProject()
                ->filteredByDateRange()
                ->where('opened', 1)
                ->count(),
            'clicked' => $this
                ->filteredByProject()
                ->filteredByDateRange()
                ->where('clicked', 1)
                ->count(),

        ];
    }

}