Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $queryFilter = Arsip::select(
- 'arsip.id as idArsip',
- 'arsip.code as codeArsip',
- 'arsip.nama as namaArsip',
- 'arsip.tgl_registrasi as tglRegistrasiArsip',
- 'arsip.path',
- 'bidang.nama_bidang',
- 'pendidikan.nama_pendidikan'
- )->leftJoin('bidang', 'arsip.bidang_id', '=', 'bidang.id')
- ->leftJoin('pendidikan', 'arsip.pendidikan_id', '=', 'pendidikan.id')
- ->where($columnsFilter, $filterVal)-get();
- $query = Arsip::select(
- 'arsip.id as idArsip',
- 'arsip.code as codeArsip',
- 'arsip.nama as namaArsip',
- 'arsip.tgl_registrasi as tglRegistrasiArsip',
- 'arsip.path',
- 'bidang.nama_bidang',
- 'pendidikan.nama_pendidikan'
- )->leftJoin('bidang', 'arsip.bidang_id', '=', 'bidang.id')
- ->leftJoin('pendidikan', 'arsip.pendidikan_id', '=', 'pendidikan.id')
- ->where('arsip.code', 'LIKE', "%{$search}%")
- ->orWhere('arsip.nama', 'LIKE', "%{$search}%")
- ->orWhere('bidang.nama_bidang', 'LIKE', "%{$search}%")
- ->orWhere('pendidikan.nama_pendidikan', 'LIKE', "%{$search}%")
- ->orderBy($order, $dir)
- ->offset($start)
- ->limit($limit)->get();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement