<?php

namespace App\DataTables;

use App\ContactGroup;
use App\User;
use Illuminate\Support\Facades\Auth;
use Yajra\DataTables\Html\Button;
use Yajra\DataTables\Services\DataTable;

class ContactcgroupdataTable extends DataTable
{

    public function dataTable($query)
    {
       return datatables()
            ->eloquent($query)
            ->addColumn('action', function ($row){
                return '<div class="btn-group">' .
                '<a style="text-decoration:none" class="btn btn-sm btn-primary" href="' . route('addressbook.groups.edit_group', ['id'=>$row->id]).'">Edit</a>' .
                '<a style="text-decoration:none" class="btn btn-sm btn-warning" href="' . route('addressbook.groups.delete_group', ['id'=>$row->id]) . '"' .
                    'onclick="return confirm(\'Do you want to delete this group?\')">Delete</a>' .
                '<a style="text-decoration:none" class="btn btn-sm btn-primary" href="' . route('addressbook.contacts', ['group_id'=>$row->id]).'">Manage contacts</a>' .
                '</div>';
            });

    }

    /**
     * Get the query object to be processed by dataTables.
     *
     * @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|\Illuminate\Support\Collection
     */
    public function query()
    {
        $query = Auth::user()->groups()->orderBy('created_at', 'desc');

        return $this->applyScopes($query);
    }

    /**
     * Optional method if you want to use html builder.
     *
     * @return \Yajra\Datatables\Html\Builder
     */
    public function html()
    {
        return $this->builder()
                    ->columns($this->getColumns())
                    ->ajax('')
                    ->addAction(['width' => '220px'])
                    ->dom('Bfrtip')
                    ->buttons(
                        Button::make('excel'),
                        Button::make('csv'),
                        Button::make('pdf')
                    );
    }

    /**
     * Get columns.
     *
     * @return array
     */
    protected function getColumns()
    {
        return [
//            'id',
            'name',
            'description',
//            'updated_at',
        ];
    }

    /**
     * Get filename for export.
     *
     * @return string
     */
    protected function filename()
    {
        return 'contactcgroupdatatables_' . time();
    }
}
