public function show($id) { $sensor = Sensor::where('sensingDevice_id', '=', $id)->first(); return $sensor; }
public function getMinMaxMonitor($id) { if (is_numeric($id)) { $minMaxMonitor = MinMaxMonitor::where("id", "=", $id)->first(); return $minMaxMonitor; } $device = \App\SensingDevice::where("device_id", "=", $id)->first(); $sensor = \App\Sensor::where("sensingDevice_id", "=", $device->id)->first(); $minMaxMonitor = MinMaxMonitor::where("sensor_id", "=", $sensor->id)->first(); return $minMaxMonitor; }
if ($notificationCheck->maxCelsius != 0 && $notificationCheck->maxCelsius < $value) { $notificationController->sentMonitorNotification("Alert!! : " . $id . " reach minimum temperature >" . $notificationCheck->maxCelsius . " celsius", $id); } } $temperature = new Temperature(); $temperature->celsiusValue = $value; $Sensor->temperature()->save($temperature); }); Route::get('sensingResister/{device_id}/{temperature}/{soilmoisture}/{light}/{humidity}', function ($id, $temp, $soil, $lux, $humid) { $DeviceBaseId = DB::table('sensingdevice')->where('device_id', $id)->value('id'); $SensorPrimaryKey = DB::table('sensor')->where('sensingDevice_id', $DeviceBaseId)->value('id'); $checkHourly = Light::where('sensor_id', '=', $SensorPrimaryKey)->count(); $Sensor = Sensor::find($SensorPrimaryKey); $notificationController = new notificationController(); $device = \App\SensingDevice::where("device_id", "=", $id)->first(); $sensor = \App\Sensor::where("sensingDevice_id", "=", $device->id)->first(); $notificationCheck = MinMaxMonitor::where("sensor_id", "=", $sensor->id)->first(); if ($notificationCheck != null) { if ($notificationCheck->minHumidityPercentage != 0 && $notificationCheck->minHumidityPercentage > $humid) { $notificationController->sentMonitorNotification("Alert!! : " . $id . " reach minimum humidity <" . $notificationCheck->minHumidityPercentage . " %", $id); } if ($notificationCheck->maxHumidityPercentage != 0 && $notificationCheck->maxHumidityPercentage < $humid) { $notificationController->sentMonitorNotification("Alert!! : " . $id . " reach maximum humidity >" . $notificationCheck->maxHumidityPercentage . " %", $id); } if ($notificationCheck->minCelsius != 0 && $notificationCheck->minCelsius > $temp) { $notificationController->sentMonitorNotification("Alert!! : " . $id . " reach minimum temperature <" . $notificationCheck->minCelsius . " celsius", $id); } if ($notificationCheck->maxCelsius != 0 && $notificationCheck->maxCelsius < $temp) { $notificationController->sentMonitorNotification("Alert!! : " . $id . " reach minimum temperature >" . $notificationCheck->maxCelsius . " celsius", $id); } if ($notificationCheck->minSoilMoisture != 0 && $notificationCheck->minSoilMoisture > $soil) {