addColumn('is_director', function ($query) {
if ($query->is_director == 1) {
return 'Yes';
} else {
return 'No';
}
})
->addColumn('action', function ($query) {
return '
';
})
->rawColumns(['action'])
// ->rawColumns(['response', 'action'])
;
}
//
/**
* Get query source of dataTable.
*
* @param \App\App\UsersDataTable $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query()
{
$current_year = Carbon::now()->year;
// $query = CoiUsers::query()->where('status','Completed')->orWhere('status','Updated')->where('conflict','1');
// $query = DB::select("select * from coi_users where conflict= 0 and deleted_at is null");
$query = DB::select("SELECT * FROM `coi_users` WHERE dept IS NOT NULL AND deleted_at IS NULL AND coi_status = 'Agree' AND status IN ('Completed', 'Updated', 'UpdatedFromLastYear') AND conflict = 0");
return $this->applyScopes($query);
}
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\DataTables\Html\Builder
*/
public function html()
{
return $this->builder()
->setTableId('usersdatatable-table')
->columns($this->getColumns())
->minifiedAjax()
->dom('Bfrtip')
->orderBy(0)
->buttons(
Button::make('export'),
Button::make('print'),
// Button::make('reset'),
Button::make('reload')
)
;
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
Column::make('id')->visible(false)->exportable(false)
->printable(false),
Column::make('name')->title('Name'),
Column::make('email')->title('Email'),
Column::make('phone'),
Column::make('dept'),
Column::make('division'),
Column::make('is_director')->title('Is He/She a Director'),
Column::make('starttime')->title('Date Started'),
// Column::make('response')->title('Assessment Sent'),
Column::computed('action')
->exportable(false)
->printable(false)
->width(60)
->addClass('text-center'),
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'Users_' . date('YmdHis');
}
}