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) {
