eloquent($query)
->filterColumn('state_id', function ($query, $keyword) {
$query->whereHas('state', function ($query) use ($keyword) {
$query->where('name', 'like', "%{$keyword}");
});
})
->filterColumn('state.country_id', function ($query, $keyword) {
$query->whereHas('state.country', function ($query) use ($keyword) {
$query->where('name', 'like', "%{$keyword}");
});
})
->addColumn('action', function ($item) {
$buttons = '';
$buttons .= ' ' . __('custom.edit') . ' ';
$buttons .= '
';
return '';
})
->addColumn('state_id', function ($item) {
return optional($item->state)->name;
})
->addColumn('state.country_id', function ($item) {
return optional(optional($item->state)->country)->name;
})
->rawColumns([ 'action'])->addIndexColumn();
}
/**
* Get query source of dataTable.
*
* @param SystemCity $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query(SystemCity $model)
{
return $model->with('state.country')->newQuery();
}
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\DataTables\Html\Builder
*/
public function html()
{
$params = $this->getBuilderParameters();
$params['order'] = [[1, 'asc']];
return $this->builder()
->columns($this->getColumns())
->minifiedAjax()
->addAction(['width' => '55px', 'class' => "text-center", 'printable' => false, 'exportable' => false, 'title' => __('custom.action')])
->parameters($params);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
Column::computed('DT_RowIndex', __('custom.sl')),
Column::make('name', 'name')->title(__('custom.name')),
Column::make('state_id', 'state_id')->title(__('custom.state')),
Column::make('state.country_id', 'state.country_id')->title(__('custom.country')),
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'SystemState' . date('YmdHis');
}
/**
* pdf
*
* @return void
*/
public function pdf()
{
$data = $this->getDataForExport();
$pdf = PDF::loadView('vendor.datatables.print', [
'data' => $data
]);
return $pdf->download($this->getFilename() . '.pdf');
}