перевести запрос на laravel

Question

перевести запрос на laravel

пожалуйста, переведите запрос на красноречивый
я пробую 2 дня:

SELECT absens.kelas_id AS kelas_id
, absens.nisn AS nisn
, (SELECT t2.kondisi
FROM absens t2
WHERE ((t2.date = '20170811')
AND (t2.kelas_id = 2)
AND (t2.nisn = absens.nisn)
AND (t2.jam_ke = 0))
) AS Jam 0
FROM absens
WHERE ((absens.date = '20170811')
AND (absens.kelas_id = 2))
GROUP
BY absens.nisn;

-9

laravel mysql php

Решение

Другие решения

Других решений пока нет …

Источник

Accepted Answer

DB::select(DB::raw("SELECT absens.kelas_id AS kelas_id
, absens.nisn AS nisn
, (SELECT t2.kondisi
FROM absens t2
WHERE ((t2.date = '20170811')
AND (t2.kelas_id = 2)
AND (t2.nisn = absens.nisn)
AND (t2.jam_ke = 0))
) AS Jam 0
FROM absens
WHERE ((absens.date = '20170811')
AND (absens.kelas_id = 2))
GROUP
BY absens.nisn;
")
);

надеюсь я помог XD

-1