jeudi 23 avril 2020

Convert raw query into laravel query builder

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