<?php

namespace Ignite\Core\Models\Grid;

class TrashedTable extends ParticipantTable
{
    /**
     * The column keys that should be always visible.
     * @var array
     */
    protected $alwaysVisible = [
        'checkbox', 'user_id'
    ];

    /**
     * The columns to show.
     *
     * @return array
     */
    public function columns()
    {
        $columns = array_merge(
            ['checkbox' => $this->checkboxColumn()],
            parent::columns()
        );

        unset($columns['action']);

        return $columns;
    }

    /**
     * The trashed users query.
     *
     * @return \Illuminate\Database\Query\Builder
     */
    public function query()
    {
        $columns = collect($this->getColumns())
            ->keyBy('name')
            ->except('action', 'checkbox')
            ->keys()
            ->toArray();

        return $this->getConnection()->table('core_participant AS participant')
            ->select($columns)
            ->distinct()
            ->leftJoin('core_user AS user', 'user.user_id', '=', 'participant.user_id')
            ->whereNotNull('participant.deleted_at');
    }

    /**
     * Add the checkbox field to the column map.
     *
     * @return array
     */
    protected function getColumnFormattingMap()
    {
        return array_merge(parent::getColumnFormattingMap(), [$this->formatter, 'checkbox']);
    }

    /**
     * Get default builder parameters.
     *
     * @return array
     */
    protected function getBuilderParameters()
    {
        return parent::getBuilderParameters([
            "order" => [2, 'asc'], // Last Login
        ], $this->getCheckboxColumnParameters());
    }
}
