<?php

namespace App\DataTables;

use App\Models\EventOrganiser;
use Yajra\DataTables\Html\Button;
use Yajra\DataTables\Html\Column;
use Yajra\DataTables\Html\Editor\Editor;
use Yajra\DataTables\Html\Editor\Fields;
use Yajra\DataTables\Services\DataTable;

class EventOrganiserDataTable extends DataTable
{
    public function dataTable($query)
    {
        return datatables()
            ->eloquent($query);
    }

    public function query(EventOrganiser $model)
    {
        $query = $model->newQuery();

        return $query->where('EventName', 'Nursing Conclave')->orderBy('created_at', 'DESC');
    }

    public function html()
    {
        return $this->builder()
                    ->setTableId('eventorganiser-table')
                    ->columns($this->getColumns())
                    ->minifiedAjax()
                    ->ordering(false)
                    ->serverSide(true)
                    ->dom('Bfrtip')
                    ->buttons(
                        ['excel', 'csv', 'print', 'reload', 'colvis']
                    );
    }

    protected function getColumns()
    {
        return [
            Column::make('TxnNumber')->title('Booking ID'),
            Column::make('created_at')->title('Txn Date'),
            Column::make('Name'),
            Column::make('Phone'),
            Column::make('Email'),
            Column::make('City'),
            Column::make('Qualification')->title('Designation'),
            Column::make('Organization')->title('Organization/Institute'),
            Column::make('Profession'),
            Column::make('RegistrationID')->title('Nursing Reg. No'),
            Column::make('Amount'),
            Column::make('PaymentStatus')->title('Payment Status'),
            Column::make('media.url')->title('Attachment')
        ];
    }

    protected function filename()
    {
        return 'EventOrganiser_' . date('YmdHis');
    }
}