You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am trying to pass search data to the class from the controller. Here is what I got so far but when I put the variables in to pass they do not go to the datatable class.
use Carbon\Carbon; use Vanguard\NarcoticLog; 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 NarcoticLogsDataTable extends DataTable { /** * Build DataTable class. * * @param mixed $query Results from query() method. * @return \Yajra\DataTables\DataTableAbstract */ public function dataTable($query) { $query->where('companyId', auth()->user()->companyId)->orderBy('timeOut', 'desc');
return datatables() ->eloquent($query) ->addColumn('time out', function (NarcoticLog $row){ return Carbon::parse($row->timeOut)->format('m-d-Y H:i:s'); }) ->addColumn('box id', function (NarcoticLog $row){ return ($row->box->boxNumber ?? 'Ukn Box'); }) ->addColumn('unit', function (NarcoticLog $row){ return ($row->unit->unitNumber ?? 'Ukn Unit'); }) ->addColumn('assigned out', function (NarcoticLog $row){ return ($row->assignedOut->first_name ?? 'Unk User').' '.($row->assignedOut->last_name ?? '').' '. ($row->assignedOut->level->description ?? ''); }) ->addColumn('seal out', function (NarcoticLog $row){ return ($row->sealOut ?? 'Unk Seal'); }) ->addColumn('time in', function (NarcoticLog $row){ if($row->timeIn){ return Carbon::parse($row->timeIn)->format('m-d-Y H:i:s'); } }) ->addColumn('assigned in', function (NarcoticLog $row){ if($row->inSignature){ return ($row->assignedIn->first_name ?? 'Unk User').' '.($row->assignedIn->last_name ?? '').' '.($row->assignedIn->level->description ?? ''); }else{ return 'Box is Checked Out'; } }) ->addColumn('seal in', function (NarcoticLog $row){ if($row->sealIn){ return ($row->sealIn ?? ''); } }) ->addColumn('drug bag', function (NarcoticLog $row){ return ($row->bag->description ?? ''); }); } /** * Get query source of dataTable. * * @param Vanguard\NarcoticLog $model * @return \Illuminate\Database\Eloquent\Builder */ public function query(NarcoticLog $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('narcoticlogs-table') ->columns($this->getColumns()) ->minifiedAjax() ->dom('Bfrtip') ->orderBy(1) ->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('time out'), Column::make('box id'), Column::make('unit'), Column::make('assigned out'), Column::make('seal out'), Column::make('time in'), Column::make('assigned in'), Column::make('seal in'), Column::make('drug bag'), ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'NarcoticLogs_' . date('YmdHis'); }
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
-
I am trying to pass search data to the class from the controller. Here is what I got so far but when I put the variables in to pass they do not go to the datatable class.
Controller
`public function narcoticLogs(NarcoticLogsDataTable $dataTable, $start = NULL , $end = NULL)
{
if(!$start){
$start = Carbon::now()->subMonth(1)->startOfDay();
}else{
$start = Carbon::parse($start)->startOfDay();
}
if(!$end){
$end = Carbon::now()->endOfDay();
}else{
$end = Carbon::parse($end)->endOfDay();
}
return $dataTable->render('logistics.narcoticLogs');
`<?php
namespace Vanguard\DataTables;
use Carbon\Carbon;
use Vanguard\NarcoticLog;
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 NarcoticLogsDataTable extends DataTable
{
/**
* Build DataTable class.
*
* @param mixed $query Results from query() method.
* @return \Yajra\DataTables\DataTableAbstract
*/
public function dataTable($query)
{
$query->where('companyId', auth()->user()->companyId)->orderBy('timeOut', 'desc');
}`
Beta Was this translation helpful? Give feedback.
All reactions