File Manager Lite
Dir:
/home/u540325668/domains/sostabazar.in/public_html/websites/sonarSonsar/app/DataTables
Upload
[..]
PostDataTable.php (4.15 KB)
Edit
Rename
Del
TransctionDataTable.php (3.45 KB)
Edit
Rename
Del
UsersDataTable.php (3.7 KB)
Edit
Rename
Del
Edit: TransctionDataTable.php
<?php namespace App\DataTables; use App\Models\Transction; use Illuminate\Database\Eloquent\Builder as QueryBuilder; use Yajra\DataTables\EloquentDataTable; use Yajra\DataTables\Html\Builder as HtmlBuilder; 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; use Auth; class TransctionDataTable extends DataTable { /** * Build the DataTable class. * * @param QueryBuilder $query Results from query() method. */ public function dataTable(QueryBuilder $query): EloquentDataTable { return (new EloquentDataTable($query)) ->addColumn('Action', function ($user) { return '<a href="/admin/customer/info/'.$user->id.'" class="btn btn-sm btn-primary"><span class="fa fa-info-circle"></span></a>.<a href="/admin/customer/edit/'.$user->id.'" class="btn btn-sm btn-success"><span class="fa fa-edit"></span></a>.<a href="/admin/customer/delete/'.$user->id.'"class="btn btn-sm btn-danger" onclick="return confirm(\'Are you sure to delete this Post\')" ><span class="fa fa-trash"></span></a>'; }) ->escapeColumns('Action') ->addColumn('Status', function ($user) { return $user->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('checkbox', '<input type="checkbox" name="selected_users[]" value="{{ $id }}">'); } /** * Get the query source of dataTable. */ public function query(Transction $model): QueryBuilder { // return $model->newQuery(); $user_id = Auth::user()->id; return $model= Transction::where('user_id', '=', $user_id); } /** * Optional method if you want to use the html builder. */ public function html(): HtmlBuilder { return $this->builder() ->setTableId('schooluc-table') ->columns($this->getColumns()) ->minifiedAjax() //->dom('Bfrtip') ->orderBy(1) ->selectStyleSingle() ->buttons([ Button::make('excel'), Button::make('csv'), Button::make('pdf'), Button::make('print'), Button::make('reset'), Button::make('reload') ]); } /** * Get the dataTable columns definition. */ public function getColumns(): array { return [ Column::computed('checkbox') ->title('') ->orderable(false) ->searchable(false) ->exportable(false) ->printable(false) ->width(5) ->addClass('text-center'), Column::make('created_at') ->title('Date & Time'), Column::make('user_id'), Column::make('job_id'), Column::make('desc')->title('Remarks'), Column::make('ob')->title('Opening'), Column::make('credit') ->title('Credit'), Column::make('debit') ->title('Debit'), Column::computed('balance')->title('Balance'), ]; } /** * Get the filename for export. */ protected function filename(): string { return 'SchoolUc_' . date('YmdHis'); } }
Simpan