How do i filter datatable queries from my controller, and how do i return a collection or array to my view from datatable controller

[toyintheisaac]

How do i filter datatable queries from my controller, and how do i return a collection or array to my view from datatable controller

I have 2 issues.
No 1: I am trying to filter my datatable queries
eg.
When a class group is selected only record to that class show be displayed, if no class group is selected, all the class list should be displayed.

No 2: I want to show all teachers in the database to the view in yajra table.

Here is my sample code

• My controller
  

    public function getSubject(SubjectDataTable $dataTable){
        $allTeachers = (new TeacherService())->getSubjectTeacher();
        $classID = 10;
        return $dataTable->render('staffAuth.classes.subjects', compact(['allTeachers','classID']));
    }

• My Datatable Controller
  

    public function dataTable(QueryBuilder $query): EloquentDataTable
    {
        return (new EloquentDataTable($query))
            ->addColumn('class', 'components.subject-class')
            ->addColumn('subject_teacher', 'components.subject-teachers')  i want to be able to access  $allTeachers here in the view
            ->addColumn('action', 'components.subject-edit')
            ->escapeColumns([])
            ->setRowId('id');
    }
    public function query(Subject $model): QueryBuilder
    {
        if(!empty($this->classID)){  
            return $model->newQuery()->where('status', 'active')->where('class_id', $this->classID);
        }
        return $model->newQuery()->where('status', 'active'); 
    }

[toyintheisaac]

Please I need Help @yajra

[yajra]

I think you need to pass the classID using with:

// Controller
    public function getSubject(SubjectDataTable $dataTable){
        $allTeachers = (new TeacherService())->getSubjectTeacher();
        $classID = 10;

        return $dataTable->with('classID', $classID)
            ->render('staffAuth.classes.subjects', compact(['allTeachers','classID']));
    }

// DataTable
    public function query(Subject $model): QueryBuilder
    {
        return $model->newQuery()
                ->where('status', 'active')
                ->when($this->classID, function ($query, $classID) {
                    return $query->where('class_id', $classID);
                });
    }

[toyintheisaac]

I think you need to pass the classID using with:

// Controller
    public function getSubject(SubjectDataTable $dataTable){
        $allTeachers = (new TeacherService())->getSubjectTeacher();
        $classID = 10;

        return $dataTable->with('classID', $classID)
            ->render('staffAuth.classes.subjects', compact(['allTeachers','classID']));
    }

// DataTable
    public function query(Subject $model): QueryBuilder
    {
        return $model->newQuery()
                ->where('status', 'active')
                ->when($this->classID, function ($query, $classID) {
                    return $query->where('class_id', $classID);
                });
    }

This works really fine,
Thanks alot,

[toyintheisaac]

Please how do i solve this.

I want to be able to get $allTeachers from my controlller to the dataTable component on components.subject-teachers here.
Please how can i do this.

` public function dataTable(QueryBuilder $query): EloquentDataTable
{
    return (new EloquentDataTable($query))
        ->addColumn('class', 'components.subject-class')
        ->addColumn('subject_teacher', 'components.subject-teachers')  i want to be able to access  $allTeachers here in the view
        ->addColumn('action', 'components.subject-edit')
        ->escapeColumns([])
        ->setRowId('id');
}
public function query(Subject $model): QueryBuilder
{
     return $model->newQuery()
            ->where('status', 'active')
            ->when($this->classID, function ($query, $classID) {
                return $query->where('class_id', $classID);
            });
}`

@yajra

[yajra]

Something like below:

Controller:

->with('allTeachers', $allTeachers)

DataTable:

->addColumn('subject_teacher', function($model) {
  return view('components.subject-teacher', ['allTeachers' => $this->allTeachers, 'model' => $model]);
}) 

[toyintheisaac]

Something like below:

Controller:

->with('allTeachers', $allTeachers)

DataTable:

->addColumn('subject_teacher', function($model) {
  return view('components.subject-teacher', ['allTeachers' => $this->allTeachers, 'model' => $model]);
}) 

Thanks you very much, this works well,
I really appreciate your swift response.

[toyintheisaac]

Should i create a new issue for this?
Also this is my last question, And thanks for always replying.

I want to be able to number the ID column or SN by loop, not by the table column id value.

I want the ID to be numbered 1, 2 3 4 5 6 7 8 9 etc. instead of getting the values from the database which omits some numbers whenever an ID value is deleted

@yajra