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

require("header3.php");

// 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);
}

$SetAllOn = isset($_REQUEST["SetAllOn"]) ? $_REQUEST["SetAllOn"] : "";
$SetAllOff = isset($_REQUEST["SetAllOff"]) ? $_REQUEST["SetAllOff"] : "";
$ReSetAll = isset($_REQUEST["ReSetAll"]) ? $_REQUEST["ReSetAll"] : "";

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 ($SetAllOff == "Set All Off") {
        $sql  = "UPDATE sensors_info SET sensor_state = 'off', sensor_setup = 'no'";
}

if ($SetAllOn == "Set All On") {
        $sql  = "UPDATE sensors_info SET sensor_state = 'on', sensor_setup = 'yes'";

        $sid_sql = "SELECT sensor_id,sensor_type FROM sensors_info";
        $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") {
                        $create_rrd = '/opt/sensiplicity/bin/create_rrdtool.sh '.$row["sensor_id"].'';
                        exec($create_rrd);
                }
                else if($sensor_type_db == "Soil Sensor") {
                        $create_rrd = '/opt/sensiplicity/bin/create_rrdtool.sh '.$row["sensor_id"].'_atemp';
                        exec($create_rrd);
                        $create_rrd = '/opt/sensiplicity/bin/create_rrdtool.sh '.$row["sensor_id"].'_humidity';
                        exec($create_rrd);
                        $create_rrd = '/opt/sensiplicity/bin/create_rrdtool.sh '.$row["sensor_id"].'_light';
                        exec($create_rrd);
                        $create_rrd = '/opt/sensiplicity/bin/create_rrdtool.sh '.$row["sensor_id"].'_stemp1';
                        exec($create_rrd);
                        $create_rrd = '/opt/sensiplicity/bin/create_rrdtool.sh '.$row["sensor_id"].'_stemp2';
                        exec($create_rrd);
                        $create_rrd = '/opt/sensiplicity/bin/create_rrdtool.sh '.$row["sensor_id"].'_stemp3';
                        exec($create_rrd);
                        $create_rrd = '/opt/sensiplicity/bin/create_rrdtool.sh '.$row["sensor_id"].'_stemp4';
                        exec($create_rrd);
                        $create_rrd = '/opt/sensiplicity/bin/create_rrdtool.sh '.$row["sensor_id"].'_moist1';
                        exec($create_rrd);
                        $create_rrd = '/opt/sensiplicity/bin/create_rrdtool.sh '.$row["sensor_id"].'_moist2';
                        exec($create_rrd);
                        $create_rrd = '/opt/sensiplicity/bin/create_rrdtool.sh '.$row["sensor_id"].'_moist3';
                        exec($create_rrd);
                        $create_rrd = '/opt/sensiplicity/bin/create_rrdtool.sh '.$row["sensor_id"].'_moist4';
                        exec($create_rrd);
                }
            }
        }
	

}


$sql .= " WHERE 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");

?>