I have this query
'''
SELECT class_student.KU_ID,
class_student.KU_KE_KR_MK_ID,
class_student.KU_KE_Kelas,
employees.PE_NamaLengkap,
t3.KE_Terisi,
students.MA_NamaLengkap,
students.MA_NRP_Baru,
t3.total AS 'Jumlah Pertemuan',
COUNT(presences.PR_KU_ID)as Kehadiran,
COUNT(presences.PR_KU_ID)/t3.total as 'Persentase Kehadiran' from class_student
LEFT Outer JOIN presences ON presences.PR_KU_ID=class_student.KU_ID
JOIN (SELECT meetings.PT_KE_ID,
classes.*,
COUNT(*) as total FROM meetings
JOIN classes ON meetings.PT_KE_ID=classes.KE_ID
GROUP BY meetings.PT_KE_ID
) as t3 on t3.KE_KR_MK_ID=class_student.KU_KE_KR_MK_ID
JOIN(students) ON class_student.KU_MA_Nrp= students.MA_Nrp
JOIN (employees)ON employees.PE_Nip=t3.KE_PE_NIPPengajar
WHERE t3.KE_Kelas=class_student.KU_KE_Kelas
group by class_student.KU_ID
ORDER BY class_student.KU_KE_KR_MK_ID, class_student.KU_MA_Nrp
'''
the result would be like this Query Result i am pretty new in laravel and i need to convert it to query bulider. Can someone help me please
From Indonesia
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire