<?php
include('lock.php');
$value = isset($login_session) ? $login_session : '';
  if($value == "") {
        header("location: login.php");
  }


$ini_array = parse_ini_file("/opt/tempberrypi/etc/TBp1.conf");

// Create connection
$conn = new mysqli($ini_array['servername'], $ini_array['username'], $ini_array['password'], $ini_array['dbname']);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sid = $_REQUEST["sid"];
$UpdateSensor = isset($_REQUEST["Update"]) ? $_REQUEST["Update"] : "";
$ResetSensor = isset($_REQUEST["Reset"]) ? $_REQUEST["Reset"] : "";
$RemoveSensor = isset($_REQUEST["Remove"]) ? $_REQUEST["Remove"] : "";
$sensor_name = isset($_REQUEST["sensor_name"]) ? $_REQUEST["sensor_name"] : "";
$sensor_state = isset($_REQUEST["sensor_state"]) ? $_REQUEST["sensor_state"] : "";
$sensor_setup = isset($_REQUEST["sensor_setup"]) ? $_REQUEST["sensor_setup"] : "";
$sensor_type = isset($_REQUEST["sensor_type"]) ? $_REQUEST["sensor_type"] : "";
$sensor_error = isset($_REQUEST["sensor_error"]) ? $_REQUEST["sensor_error"] : "";
$sensor_geotag = isset($_REQUEST["sensor_geotag"]) ? $_REQUEST["sensor_geotag"] : "";
$sensor_group = isset($_REQUEST["sensor_group"]) ? $_REQUEST["sensor_group"] : "";
$sensor_limit1 = isset($_REQUEST["sensor_limit1"]) ? $_REQUEST["sensor_limit1"] : "";
$sensor_limit2 = isset($_REQUEST["sensor_limit2"]) ? $_REQUEST["sensor_limit2"] : "";
$sensor_limit3 = isset($_REQUEST["sensor_limit3"]) ? $_REQUEST["sensor_limit3"] : "";
$sensor_limit4 = isset($_REQUEST["sensor_limit4"]) ? $_REQUEST["sensor_limit4"] : "";
$sensor_comment = isset($_REQUEST["sensor_comment"]) ? $_REQUEST["sensor_comment"] : "";
$sensor_id = "";
$sensor_type_db = "";
$geotag = str_replace(array('\\', "\0", "\n", "\r", "'", '"', "\x1a"), array('\\\\', '\\0', '\\n', '\\r', "\\'", '\\"', '\\Z'), $sensor_geotag);

$sql  = "UPDATE sensors_info SET ";
$sql .= "sensor_setup = 'yes' ";

if($sensor_name != "") {
	$sql .= ", sensor_name = '".$sensor_name."' ";
}
if($sensor_state != "") {
	$sid_sql = "SELECT sensor_id,sensor_type FROM sensors_info WHERE sid = '".$sid."'";
	$result = $conn->query($sid_sql);
	if ($result->num_rows > 0) {
	    while($row = $result->fetch_assoc()) {
		$sensor_id = $row["sensor_id"];
		$sensor_type_db = $row["sensor_type"];
		if($sensor_type_db == "Temperature") {
			if($sensor_state == "on") {
				$create_rrd = '/opt/tempberrypi/bin/create_rrdtool.sh '.$row["sensor_id"].'';
				exec($create_rrd);
	    		}
		}
		else if($sensor_type_db == "Soil Sensor") {
			if($sensor_state == "on") {
				$create_rrd = '/opt/tempberrypi/bin/create_rrdtool.sh '.$row["sensor_id"].'_atemp';
				exec($create_rrd);
				$create_rrd = '/opt/tempberrypi/bin/create_rrdtool.sh '.$row["sensor_id"].'_stemp';
				exec($create_rrd);
				$create_rrd = '/opt/tempberrypi/bin/create_rrdtool.sh '.$row["sensor_id"].'_humidity';
				exec($create_rrd);
				$create_rrd = '/opt/tempberrypi/bin/create_rrdtool.sh '.$row["sensor_id"].'_light';
				exec($create_rrd);
				$create_rrd = '/opt/tempberrypi/bin/create_rrdtool.sh '.$row["sensor_id"].'_moist1';
				exec($create_rrd);
				$create_rrd = '/opt/tempberrypi/bin/create_rrdtool.sh '.$row["sensor_id"].'_moist2';
				exec($create_rrd);
				$create_rrd = '/opt/tempberrypi/bin/create_rrdtool.sh '.$row["sensor_id"].'_moist3';
				exec($create_rrd);
				$create_rrd = '/opt/tempberrypi/bin/create_rrdtool.sh '.$row["sensor_id"].'_moist4';
				exec($create_rrd);
	    		}
		}
	    }
	}
	$all_plots = "/opt/tempberrypi/bin/create_rrdtool.py";
	exec($all_plots);
	
	$sql .= ", sensor_state = '".$sensor_state."' ";
}
if($sensor_setup != "") {
	$sql .= ", sensor_setup = '".$sensor_setup."' ";
}
if($sensor_type!= "") {
	$sql .= ", sensor_type = '".$sensor_type."' ";
}
if($geotag!= "") {
	$sql .= ", sensor_geotag = '".$geotag."' ";
}
if($sensor_limit1!= "") {
	$sql .= ", sensor_limit1 = '".$sensor_limit1."' ";
}
if($sensor_limit2!= "") {
	$sql .= ", sensor_limit2 = '".$sensor_limit2."' ";
}
if($sensor_limit3!= "") {
	$sql .= ", sensor_limit3 = '".$sensor_limit3."' ";
}
if($sensor_limit4!= "") {
	$sql .= ", sensor_limit4 = '".$sensor_limit4."' ";
}
if($sensor_group!= "") {
	$sql .= ", sensor_group = '".$sensor_group."' ";
}
if($sensor_comment!= "") {
	$sql .= ", sensor_comment = '".$sensor_comment."' ";
}

if ($ResetSensor == "Reset Sensor") {
	$sql  = "UPDATE sensors_info SET sensor_name = '', sensor_state = 'off', sensor_setup = 'no', sensor_type = '', sensor_geotag = '', sensor_limit1 = '', sensor_limit2 = '', sensor_limit3 = '', sensor_limit4 = '', sensor_comment = ''";
}

if ($RemoveSensor == "Remove Sensor") {
	$sql  = "DELETE FROM sensors_info";
}


$sql .= " WHERE sid = ".$sid." ";

#echo "sql = ".$sql."<br>";

if ($conn->query($sql) === TRUE) {
    #echo "Records added successfully.";
} else {
    #echo "Could not find the entry your requested.";
}

$conn->close();

header("Location: update_ebutton.php");
#header("Location: list_sensors.php");

?>