Level 67
Are you using models? If not, I'd just leave the sql raw and use DB::raw($query). It'd be faster anyway than using the query builder, which it then has to translate back to pure sql which is what you have in the first place.
Oct 9, 2017
6
Level 1
How to make sub query where in laravel
this is my query
SELECT p.id_pekerjaan, p.nama as pekerjaans, ks.tgl_survey
FROM users u INNER JOIN kegiatan_surveys ks on(u.id = ks.user_surveyor_id) inner join pekerjaans p on (ks.pekerjaan_id = p.id_pekerjaan) inner join kontraks k on(k.pekerjaan_id=p.id_pekerjaan) inner JOIN setting_basts sb on (sb.kontrak_id=k.id_kontrak)
WHERE ks.tgl_survey > (SELECT ks.tgl_survey
FROM pekerjaans p inner join kegiatan_surveys ks on(ks.pekerjaan_id=p.id_pekerjaan)
ORDER by ks.tgl_survey asc
limit 1
)
but i dont know how to make this to laravel can some one help me??
Level 1
@Cronix yeah i using model.. can u give exaple how to use DB::raw ?? i still dont understand how to use it
Level 67
Sorry, I meant select for an entire query. DB::select(the_query_you_originally_showed)
Level 1
@Cronix thx bro
Level 1
@cronix but if u use DB::select('myquery') i cant use pagination function.. can u help me?
Level 67
You'd have to use a manual paginator (LengthAwarePaginator). You'd have to add a count (select count) to get the total count in your current query for it to work so it knows how many records there are to paginate through.
https://laravel.com/docs/5.5/pagination#manually-creating-a-paginator
Please or to participate in this conversation.