function search($keyword, $page = 1) { $toReturn = array(); $inventory = inventory::where('name', 'like', '%' . $keyword . '%')->orderBy('id', 'DESC')->take('20')->skip(20 * ($page - 1))->get()->toArray(); $toReturn['totalItems'] = inventory::where('name', 'like', '%' . $keyword . '%')->orderBy('id', 'DESC')->take('20')->skip(20 * ($page - 1))->count(); $teachers = User::where('role', 'teacher')->where('activated', '1')->get()->toArray(); $teacherArray = array(); while (list(, $value) = each($teachers)) { $teacherArray[$value['id']] = $value['fullName']; } $toReturn['inventory'] = array(); while (list(, $inventorry) = each($inventory)) { $toReturn['inventory'][] = array('id' => $inventorry['id'], "name" => $inventorry['name'], "inventorydate" => $inventorry['inventorydate'], "qty" => $inventorry['qty'], "total" => $inventorry['qty'], "status" => $inventorry['status'], "teachername" => isset($teacherArray[$inventorry['teacherId']]) ? $teacherArray[$inventorry['teacherId']] : ""); } return $toReturn; //////// }