private function sites($like)
{
$sites = Site::where('sitecode', 'LIKE', "%{$like}%")->get();
$cameras = Cameras::sites();
foreach ($sites as $site) {
// Cleanup site name
$remove = [' Basic Aquatic', ' Advanced Aquatic', 'Provo River at ', 'Provo River near ', 'Provo River Below ', 'Logan River at ', 'Logan River near '];
foreach ($remove as $r) {
$site['sitename'] = str_replace($r, '', $site['sitename']);
}
// Convert Lat/Lon to float
$site['latitude'] = floatval($site['latitude']);
$site['longitude'] = floatval($site['longitude']);
// Check to see if site has a camera
$site['camera'] = false;
if (in_array($site['sitecode'], $cameras)) {
$site['camera'] = true;
}
// Append array of series at site
$series = [];
foreach (DB::table('series')->select('variablecode')->where('sitecode', '=', $site->sitecode)->get() as $var) {
$series[] = $var->variablecode;
}
$site->series = $series;
}
return $sites;
}
public function timestamps($sitecode)
{
$stamps = Cameras::timestamps($sitecode);
return response()->json($stamps);
}
