->baseQuery(function (Builder $query, array $data): Builder {
$query->from('subjects')
->leftJoin('subject_allocations', function ($join) use ($data) {
$join->on('subjects.id', '=', 'subject_allocations.subject_id');
if (isset($data['school_class_id']) && isset($data['section_id'])) {
$join->where('subject_allocations.school_class_id', $data['school_class_id'])
->where('subject_allocations.section_id', $data['section_id']);
}
});
Log::info($query->toSql(), $query->getBindings());
return $query;
})
->baseQuery(function (Builder $query, array $data): Builder {
$query->from('subjects')
->leftJoin('subject_allocations', function ($join) use ($data) {
$join->on('subjects.id', '=', 'subject_allocations.subject_id');
if (isset($data['school_class_id']) && isset($data['section_id'])) {
$join->where('subject_allocations.school_class_id', $data['school_class_id'])
->where('subject_allocations.section_id', $data['section_id']);
}
});
Log::info($query->toSql(), $query->getBindings());
return $query;
})