scci / security-employee-tracker

use Illuminate\Database\Eloquent\Collection;

use SET\User;

class Separated extends CollectionList

{

    public function getList() : Collection

    {

        return User::where(function ($q) {

            $q->where('status', 'separated')->orWhere('status', 'destroyed');

        })

            ->whereBetween('destroyed_date', [$this->start, $this->end])

            ->get();

    }

}

use Illuminate\Database\Eloquent\Collection;

use SET\TrainingUser;

class TrainingUsers extends CollectionList

{

    public function getList() : Collection

    {

        return TrainingUser::with('user', 'training')

            ->whereBetween('due_date', [$this->start, $this->end])

            ->whereNull('completed_date')

            ->orderBy('training_id')

            ->get();

    }

}