<?php

namespace App\DataTables;

use App\User;
use App\UserSenderId;
use Yajra\DataTables\Html\Button;
use Yajra\DataTables\Services\DataTable;

class ClientSenderIDTable extends DataTable
{

    public function dataTable($query)
    {
        return datatables()
            ->eloquent($query)
            ->addColumn('action', function ($query){
                $access = session()->get('access');
                return '<div class="btn-group">'
                    .'<a class="btn btn-success btn-sm" id="approve" title="APPROVE" href="'.route('admin.users.sender_id.update',['id'=>$query->id,'status'=>1]).'"><i class="fa fa-check-circle"></i></a>'
                    .'<a class="btn btn-danger btn-sm"  id="reject" title="REJECT" href="'.route('company.sender-id.approve-or-reject',['id'=>$query->id]).'">
                               <i class="fa fa-times-circle"></i></a>';

            });

    }


    public function query()
    {
        $var = session()->get('this_user_id');
        $query = UserSenderId::query()->where([['user_id',$var],['status',0]]);
        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' => '80px'])
                    ->dom('Bfrtip')
                    ->buttons(
                        Button::make('export'),
                        Button::make('print'),
                        Button::make('reset'),
                        Button::make('reload')
                    );
    }

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

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