Guest User

Untitled

a guest
Aug 14th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. $collection = Dapil_Kotakab::raw(function ($collection) use ($page, $perPage) {
  2. return $collection->aggregate([
  3. [
  4. '$lookup' => [
  5. 'as' => 'KecDetails',
  6. 'from' => 'src_kecamatan',
  7. 'foreignField' => 'id',
  8. 'localField' => 'idKecamatan'
  9. ]
  10. ],
  11. [
  12. '$lookup' => [
  13. 'as' => 'KotDetails',
  14. 'from' => 'src_kota_kabupaten',
  15. 'foreignField' => 'code',
  16. 'localField' => 'idKota'
  17. ]
  18. ],
  19. [
  20. '$lookup' => [
  21. 'as' => 'ProvDetails',
  22. 'from' => 'src_provinsi',
  23. 'foreignField' => 'idProv',
  24. 'localField' => 'idProvinsi'
  25. ]
  26. ],
  27. ['$skip' => ($page - 1) * $perPage],
  28. ['$limit' => $perPage],
  29. ]);
  30. });
  31.  
  32. $collection = Dapil_Kotakab::whereRaw(array('$text'=>array('$search'=> """.$word.""" )))->skip(($page - 1)*$perPage)->limit($perPage)->get();
Add Comment
Please, Sign In to add comment