public function show($id)
{
if (\Request::ajax()) {
/* autocomplete response (New contact form, group field) */
if ($id == 0) {
$term = \Input::get('term');
$db = Group::where('Name', 'like', $term . '%')->get();
$group = [];
foreach ($db as $key) {
$group[$key->ID] = ['label' => $key->Name, 'id' => $key->ID];
}
return \Response::json($group);
} else {
$data = Group::select('pbk_groups.*', 'pbk.Name as cname', 'pbk.Number')->leftJoin('pbk', 'pbk.GroupID', '=', 'pbk_groups.ID')->where('pbk_groups.ID', $id)->get();
if ($data) {
return \Response::json($data);
} else {
return \Response::json(null, 404);
}
}
} else {
abort(404);
}
}
