<?php

namespace App\DataTables;

use App\User;
use App\UserSenderId;
use Yajra\Datatables\Services\DataTable;

class ClientSenderIDTable extends DataTable
{
    /**
     * Display ajax response.
     *
     * @return \Illuminate\Http\JsonResponse
     */
    public function ajax()
    {
        return $this->datatables
            ->eloquent($this->query())
            ->addColumn('action', function ($query){
                $access = session()->get('access');
                $action1 =  '<div class="btn-group">'
                    .'<a style="background-color: #ffcb05; color: #000;" class="btn btn-success btn-sm"  title="VIEW" href=""><i class="fa fa-smile-o"></i></a>'
                    .'</div>';
                $action = '<div class="btn-group">'
                    .'<a style="background-color: #ffcb05; color: #000;" 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>'

                    .'</div>';
                return $access  == 2 ? $action : $action;
            })->rawColumns(['action'])
            ->make(true);
    }


    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'])
                    ->parameters($this->getBuilderParameters());
    }

    /**
     * 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();
    }
}
