File Manager Lite
Dir:
/home/u540325668/domains/englishandcomputer.com/public_html/app/DataTables
Upload
[..]
PostDataTable.php (4.15 KB)
Edit
Rename
Del
SchemeOneDataTable.php (3.39 KB)
Edit
Rename
Del
UsersDataTable.php (3.54 KB)
Edit
Rename
Del
Edit: SchemeOneDataTable.php
<?php namespace App\DataTables; use App\Admission; 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 SchemeOneDataTable extends DataTable { /** * Build DataTable class. * * @param mixed $query Results from query() method. * @return \Yajra\DataTables\DataTableAbstract */ public function dataTable($query) { return datatables() ->eloquent($query) ->addColumn('Action', function ($Admission) { return '<a href="/admin/admission/info/'.$Admission->id.'" class="btn btn-sm btn-primary"><span class="fa fa-info-circle"></span></a>.<a href="/admin/admission/edit/'.$Admission->id.'" class="btn btn-sm btn-success"><span class="fa fa-edit"></span></a>.<a href="/admin/admission/delete/'.$Admission->id.'"class="btn btn-sm btn-danger" onclick="return confirm(\'Are you sure to delete this Book\')" ><span class="fa fa-trash"></span></a>'; }) ->escapeColumns('Action') ->addColumn('Status', function ($Admission) { return $Admission->close == 0 ? '<i class="fa fa-check-circle btn btn-sm btn-success"></i>' : '<i class="fa fa-times-circle btn btn-sm btn-danger"></i>'; })->escapeColumns('Status') ->addColumn('name', function (Admission $Admission) { return $Admission->user->name."-".$Admission->user_id; }); } /** * Get query source of dataTable. * * @param \App\App\SchemeOne $model * @return \Illuminate\Database\Eloquent\Builder */ public function query(Admission $model) { return $model->newQuery(); } /** * Optional method if you want to use html builder. * * @return \Yajra\DataTables\Html\Builder */ public function html() { return $this->builder() ->setTableId('schemeone-table') ->columns($this->getColumns()) ->minifiedAjax() ->orderBy(0) ->buttons( Button::make('create'), Button::make('export'), Button::make('print'), Button::make('reset'), Button::make('reload') ); } /** * Get columns. * * @return array */ protected function getColumns() { return [ Column::make('id'), Column::make('bookNumber') ->title('Book ID'), Column::make('name') ->data('name') ->name('scheme_ones.user_id'), Column::make('village'), Column::make('receiveAmount') ->title('Received'), Column::make('amount'), Column::make('created_at') ->title('Open Date'), Column::make('Status') ->title('Status') ->name('scheme_ones.close'), Column::computed('Action') ->exportable(false) ->printable(false) ->width(150) ->addClass('text-center'), ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'SchemeOne_' . date('YmdHis'); } }
Simpan