Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $collection = Dapil_Kotakab::raw(function ($collection) use ($page, $perPage) {
- return $collection->aggregate([
- [
- '$lookup' => [
- 'as' => 'KecDetails',
- 'from' => 'src_kecamatan',
- 'foreignField' => 'id',
- 'localField' => 'idKecamatan'
- ]
- ],
- [
- '$lookup' => [
- 'as' => 'KotDetails',
- 'from' => 'src_kota_kabupaten',
- 'foreignField' => 'code',
- 'localField' => 'idKota'
- ]
- ],
- [
- '$lookup' => [
- 'as' => 'ProvDetails',
- 'from' => 'src_provinsi',
- 'foreignField' => 'idProv',
- 'localField' => 'idProvinsi'
- ]
- ],
- ['$skip' => ($page - 1) * $perPage],
- ['$limit' => $perPage],
- ]);
- });
- $collection = Dapil_Kotakab::whereRaw(array('$text'=>array('$search'=> """.$word.""" )))->skip(($page - 1)*$perPage)->limit($perPage)->get();
Add Comment
Please, Sign In to add comment