示例#1
0
 public function getKabKotaByProvinsiID($provinsi_id)
 {
     $res = KabKota::whereHas('provinsi', function ($q) use($provinsi_id) {
         $q->where('id', '=', $provinsi_id);
     })->get();
     return $res->toJSON();
 }
示例#2
0
 public function search()
 {
     $keyword = Input::get('keyword');
     $kbk = KabKota::whereHas("provinsi", function ($query) use($keyword) {
         $query->where('nama', 'LIKE', '%' . $keyword . '%');
     })->orWhere('id', 'LIKE', '%' . $keyword . '%')->orWhere('nama', 'LIKE', '%' . $keyword . '%')->paginate(6);
     $data = ['page_title' => 'Kabupaten / Kota', 'panel_title' => 'Search View', 'location' => 'search', 'table' => $kbk];
     return View::make('kabkota.view', $data);
 }