public function getKabKotaByProvinsiID($provinsi_id) { $res = KabKota::whereHas('provinsi', function ($q) use($provinsi_id) { $q->where('id', '=', $provinsi_id); })->get(); return $res->toJSON(); }
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); }