<?php

namespace App\DataTables;

use App\SmsPriceRange;
use Yajra\DataTables\Services\DataTable;

class SmsPricePerBalanceDataTable extends DataTable
{

    public function dataTable($query)
    {
       return datatables()
            ->eloquent($query)
            ->addColumn('action', function ($query){
                return '<div class="btn-group">' .
                    '<a title="Edit Setting" class="btn btn-sm btn-primary" href="' . route('admin.sms.price.setup.edit', ['id'=>$query->id]).'"><i class="fa fa-pencil"></i></a>';
            });

    }


    public function query()
    {
        $query = SmsPriceRange::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' => '80px'])
                    ->parameters($this->getBuilderParameters());
    }

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

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