'; echo '

'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; while($row = $result->fetch_assoc()) { $soil_sensor = exec('/opt/sensiplicity/bin/sn-util-rpi get '.$row["sensor_bus"].' '.$row["sensor_id"].' | grep '.$row["sensor_id"].''); if ($soil_sensor) { $status = ""; } else { $soil_sensor1 = exec('/opt/sensiplicity/bin/sn-util-rpi get 1 '.$row["sensor_id"].' | grep '.$row["sensor_id"].''); $soil_sensor2 = exec('/opt/sensiplicity/bin/sn-util-rpi get 2 '.$row["sensor_id"].' | grep '.$row["sensor_id"].''); $soil_sensor3 = exec('/opt/sensiplicity/bin/sn-util-rpi get 3 '.$row["sensor_id"].' | grep '.$row["sensor_id"].''); if ($soil_sensor1) { $status = ""; $sql_bus = "UPDATE sensors_info SET sensor_bus = '1' WHERE `sensor_id` ='".$row["sensor_id"]."'"; $result_bus = $conn->query($sql_bus); $row["sensor_bus"] = 1; } else if ($soil_sensor2) { $status = ""; $sql_bus = "UPDATE sensors_info SET sensor_bus = '3' WHERE `sensor_id` ='".$row["sensor_id"]."'"; $result_bus = $conn->query($sql_bus); $row["sensor_bus"] = 2; } else if ($soil_sensor3) { $status = ""; $sql_bus = "UPDATE sensors_info SET sensor_bus = '3' WHERE `sensor_id` ='".$row["sensor_id"]."'"; $result_bus = $conn->query($sql_bus); $row["sensor_bus"] = 3; } else { $status = ""; } } $low = $ini_array['low']; $high = $ini_array['high']; if(($row["sensor_limit1"] != "") && ($row["sensor_limit2"] != "")) { $low = $row["sensor_limit1"]; $high = $row["sensor_limit2"]; } else if(($row["sensor_limit3"] != "") && ($row["sensor_limit4"] != "")) { $low = $row["sensor_limit3"]; $high = $row["sensor_limit4"]; } $state = 'on'; if ($row["sensor_state"] == "on"){ $state = 'off'; } $name = $row["sensor_id"]; if ($row["sensor_name"] != "") { $name = $row["sensor_name"]; } $raw_soil = exec('/opt/sensiplicity/bin/sn-util-rpi get '.$row["sensor_bus"].' '.$row["sensor_id"].' | grep '.$row["sensor_id"].' | grep -v Node '); $soil_data = explode(",", $raw_soil); $temp_value_air = ""; $temp_valueC_air = $soil_data[6]; $temp_valueC_soil0 = $soil_data[7]; $temp_valueC_soil1 = $soil_data[8]; $temp_valueC_soil2 = $soil_data[9]; $temp_valueC_soil3 = $soil_data[10]; $temp_valueF_air = round(($soil_data[6] * (9/5) + 32), 1); $temp_valueF_soil0 = round(($soil_data[7] * (9/5) + 32) ,1); $temp_valueF_soil1 = round(($soil_data[8] * (9/5) + 32) ,1); $temp_valueF_soil2 = round(($soil_data[9] * (9/5) + 32) ,1); $temp_valueF_soil3 = round(($soil_data[10] * (9/5) + 32) ,1); if ($temp_type == "Celsius") { $temp_value_soil0 = $temp_valueC_soil0; $temp_value_soil1 = $temp_valueC_soil1; $temp_value_soil2 = $temp_valueC_soil2; $temp_value_soil3 = $temp_valueC_soil3; $temp_value_air = $temp_valueC_air; } else { $temp_value_soil0 = $temp_valueF_soil0; $temp_value_soil1 = $temp_valueF_soil1; $temp_value_soil2 = $temp_valueF_soil2; $temp_value_soil3 = $temp_valueF_soil3; $temp_value_air = $temp_valueF_air; } $temp_values_soil0 = explode(".", $temp_value_soil0); if ($temp_values_soil0[0] > $high ) { $state_of_sensor = 'HIGH TEMP'; } elseif ($temp_values_soil0[0] < $low ) { $state_of_sensor = 'LOW TEMP'; } else { $state_of_sensor = 'GOOD'; } $temp_values_soil1 = explode(".", $temp_value_soil1); if ($temp_values_soil1[0] > $high ) { $state_of_sensor = 'HIGH TEMP'; } elseif ($temp_values_soil1[0] < $low ) { $state_of_sensor = 'LOW TEMP'; } else { $state_of_sensor = 'GOOD'; } $temp_values_soil2 = explode(".", $temp_value_soil2); if ($temp_values_soil2[0] > $high ) { $state_of_sensor = 'HIGH TEMP'; } elseif ($temp_values_soil2[0] < $low ) { $state_of_sensor = 'LOW TEMP'; } else { $state_of_sensor = 'GOOD'; } $temp_values_soil3 = explode(".", $temp_value_soil3); if ($temp_values_soil3[0] > $high ) { $state_of_sensor = 'HIGH TEMP'; } elseif ($temp_values_soil3[0] < $low ) { $state_of_sensor = 'LOW TEMP'; } else { $state_of_sensor = 'GOOD'; } $temp_values_air = explode(".", $temp_value_air); if ($temp_values_air[0] > $high ) { $state_of_sensor = 'HIGH TEMP'; } elseif ($temp_values_air[0] < $low ) { $state_of_sensor = 'LOW TEMP'; } else { $state_of_sensor = 'GOOD'; } $moisture1 = 0; $moisture2 = 0; $moisture3 = 0; $moisture4 = 0; if ($soil_data[16]) { $moisture1 = $soil_data[16]; #$moisture1 = ((-0.00078 * $soil_data[16]) + 3.41); #$moisture1 = number_format((float)$moisture1, 2, '.', ''); #if ($moisture1 < 0 ) { # $moisture1 = 0.01; #} } if ($soil_data[17]) { $moisture2 = $soil_data[17]; #$moisture2 = ((-0.078 * $soil_data[17]) + 3.41); } if ($soil_data[18]) { $moisture3 = $soil_data[18]; #$moisture3 = ((-0.078 * $soil_data[18]) + 3.41); } if ($soil_data[19]) { $moisture4 = $soil_data[19]; #$moisture4 = ((-0.078 * $soil_data[19]) + 3.41); } echo ' '; } echo '

Sensor ID

Status

State

Air Temp

Humidity (%)

Light (nW/(cm)^2)

Soil Temp 1

Soil Temp 2

Soil Temp 3

Soil Temp 4

Moisture 1

Moisture 2

Moisture 3

Moisture 4

'.$name.'

'.$status.'

'.$state_of_sensor.'

'.$temp_value_air.'°'.$deg.'

'.$soil_data[5].'%

'.$soil_data[11].'%

'.$temp_value_soil0.'°'.$deg.'

'.$temp_value_soil1.'°'.$deg.'

'.$temp_value_soil2.'°'.$deg.'

'.$temp_value_soil3.'°'.$deg.'

'.$moisture1.'

'.$moisture2.'

'.$moisture3.'

'.$moisture4.'

'; #echo '