<?php

namespace App\DataTables\USSD;

use App\User;
use App\UssdService;
use App\UssdServiceType;
use Yajra\Datatables\Services\DataTable;

class USSDServiceDatatable extends DataTable
{
    /**
     * Display ajax response.
     *
     * @return \Illuminate\Http\JsonResponse
     */
    public function ajax()
    {
        return $this->datatables
            ->eloquent($this->query())
            ->addColumn('ussd_service_type_id', function ($row) {
                return $row->ussd_service_type->name;
            })
            ->addColumn('action', function ($row) {
                if($row->ussd_service_type_id==5){
                    return '<div class="btn-group">' .
                        '<a title="View" class="btn mr-5 btn-sm btn-success" href="' . route('service.show', ['id'=>$row->id]).'"><i class="fa fa-desktop"></i></a>' .
                        '<a title="Dashboard" class="btn mr-5 btn-sm btn-primary" href="' . route('service.collections.dashboard', ['id'=>$row->id]).'"><i class="fa fa-line-chart"></i></a>' .
                        '<a title="Report" class="btn mr-5 btn-sm btn-info" href="' . route('service.collections.report', ['id'=>$row->id]).'"><i class="fa fa-archive"></i></a>' .
                        '<a title="Delete " class="btn btn-sm btn-danger" href="' . route('service.delete', ['id'=>$row->id]) . '"' .
                        'onclick="return confirm(\'Do you want to delete this Service?\')"><i class="fa fa-trash"></i></a>' .
                        '</div>';
                }else{
                    return '<div class="btn-group">' .
                        '<a title="View" class="btn mr-5 btn-sm btn-success" href="' . route('service.show', ['id'=>$row->id]).'"><i class="fa fa-desktop"></i></a>' .
                        '<a title="Dashboard" class="btn mr-5 btn-sm btn-primary" href="' . route('service.report.dashboard', ['id'=>$row->id]).'"><i class="fa fa-line-chart"></i></a>' .
                        '<a title="Report" class="btn mr-5 btn-sm btn-info" href="' . route('service.response.report', ['id'=>$row->id]).'"><i class="fa fa-archive"></i></a>' .
                        '<a title="Delete " class="btn btn-sm btn-danger" href="' . route('service.delete', ['id'=>$row->id]) . '"' .
                        'onclick="return confirm(\'Do you want to delete this Service?\')"><i class="fa fa-trash"></i></a>' .
                        '</div>';
                }

            })
            ->make(true);
    }

    /**
     * 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 = UssdService::query();
        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' => '170px'])
            ->parameters($this->getBuilderParameters());

    }

    /**
     * Get columns.
     *
     * @return array
     */
    protected function getColumns()
    {
        return [
            'name',
            'code',
            'ussd_service_type_id' => ['title' => 'Service Type']
        ];
    }

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