<?php
include_once('config.php');
include_once('dbmanager.php');

class sensores{
	
	 public function getSensores(){
		 $sql = "SELECT Arduino_Sensores.* ";
		 $sql .= " FROM Arduino_Sensores ";
		 $db = new dbmanager();
		 return $db->executeQuery($sql);
     }

     public function getJSONSensores(){
		 $json = "";
		 $i = 0; 
		 $result = $this->getSensores();
		 $json .= " { \"sensores\" : [ ";
		 while($row = mysql_fetch_array($result)){
		    if($i > 0)
		    $json .= ",";
		    $json .= " { \"Sensor\" : ".$row['Sensor'].", \"fecha\": ".$row['Fecha'].", 
			\"Valor\": ".$row['Valor'].", 
			\"valor_blob\": ".$row['Valor_BLOB']." ";    
		    $json .= "} ";   
		    $i++;
		}  
		$json .= " ] ";
	    $json .= " } ";  
	    return $json; 
		}

	public function getSensor($sensor){
		 $sql = "SELECT Arduino_Sensores.* ";
		 $sql .= " FROM Arduino_Sensores ";
		 $sql .= " where Sensor =".$sensor;
		 $db = new dbmanager();
		 return $db->executeQuery($sql);
     }

   public function getJSONSensor($sensor){
		 $json = "";
		 $i = 0; 
		 $result = $this->getSensor($sensor);
		 $json .= " { \"sensor\" : [ ";
		 while($row = mysql_fetch_array($result)){
		    if($i > 0)
		    $json .= ",";
		    $json .= " { \"Sensor\" : ".$row['Sensor'].", \"fecha\": ".$row['Fecha'].", 
			\"Valor\": ".$row['Valor'].", 
			\"valor_char\": ".$row['Valor_Char']." ";    
		    $json .= "} ";   
		    $i++;
		}  
		$json .= " ] ";
	    $json .= " } ";  
	    return $json; 
		}

  public function getLastSensor($sensor){
		 $sql = "SELECT Arduino_Sensores.* ";
		 $sql .= " FROM Arduino_Sensores ";
		 $sql .= " where Sensor = '".$sensor."' ";
         $sql .= " and fecha = (select max(fecha) from Arduino where Sensor = '".$sensor."' )";	
		 
		 $db = new dbmanager();
		 return $db->executeQuery($sql);
     }
     
  public function getlastJSONSensor($sensor){
		 echo $sensor;
		 $json = "";
		 $i = 0; 
		 $result = $this->getLastSensor($sensor);
		 $json .= " { \"sensor\" : [ ";
		 while($row = mysql_fetch_array($result)){
		    if($i > 0)
		    $json .= ",";
		    $json .= " { \"Sensor\" : ".$row['Sensor'].", \"fecha\": ".$row['Fecha'].", 
			\"Valor\": ".$row['Valor'].", 
			\"valor_char\": ".$row['Valor_Char']." ";    
		    $json .= "} ";   
		    $i++;
		}  
		$json .= " ] ";
	    $json .= " } ";  
	    return $json; 
		}


  public function insertSensor($sensor, $Valor,$Valor_Char){
		 $sql = "insert into Arduino_Sensores ";
		 $sql .= " (Sensor, Valor, Valor_Char) ";
		 $sql .= "VALUES ( '".$sensor."', ".$Valor.", '".$Valor_Char."' )" ;	
		 echo $sql;
		 $db = new dbmanager();
 	     $result = $db->executeQuery($sql);
         return $this->getLastSensor($sensor);
     }

  public function insertJSONSensor($sensor, $Valor,$Valor_Char){
		 $json = "";
		 $i = 0; 
		 $result = $this->insertSensor($sensor, $Valor,$Valor_Char);
		 $json .= " { \"sensor\" : [ ";
		 while($row = mysql_fetch_array($result)){
		    if($i > 0)
		    $json .= ",";
		    $json .= " { \"Sensor\" : ".$row['Sensor'].", \"fecha\": ".$row['Fecha'].", 
			\"Valor\": ".$row['Valor'].", 
			\"valor_Char\": ".$row['Valor_Char']." ";    
		    $json .= "} ";   
		    $i++;
		}  
		$json .= " ] ";
	    $json .= " } ";  
	    return $json; 
		}
	
  public function getLastSensorValue($sensor){
		 $sql = "SELECT Arduino_Sensores.Valor ";
		 $sql .= " FROM Arduino_Sensores ";
		 $sql .= " where Sensor = '".$sensor."' ";
         $sql .= " and fecha = (select max(fecha) from Arduino_Sensores where Sensor = '".$sensor."' )";			 
		 $db = new dbmanager();
		 $result = $db->executeQuery($sql);
		 return  mysql_result($result, 0);
     }  

   public function getLastSensorInput($sensor){
		 $sql = "SELECT max(Arduino_Sensores.fecha)";
		 $sql .= " FROM Arduino_Sensores ";
		 $sql .= " where Sensor = '".$sensor."' ";         
		 $db = new dbmanager();
		 $result = $db->executeQuery($sql);
		 return  mysql_result($result, 0);
     }

   public function getAlarma($sensor){
		 $sql = "SELECT Arduino_Alarma.Valor ";
		 $sql .= " FROM Arduino_Alarma ";
		 $sql .= " where Sensor ='".$sensor."' ";
		 $db = new dbmanager();
		 $result = $db->executeQuery($sql);
         return  mysql_result($result, 0);
     }

   public function getJSONAlarma($sensor){
		 $json = "";
		 $i = 0; 
		 $result = $this->getAlarma($sensor);
		 $json .= " { \"alarma\" : [ ";
		 while($row = mysql_fetch_array($result)){
		    if($i > 0)
		    $json .= ",";
		    $json .= " { \"Sensor\" : ".$row['Sensor'].",
			\"valor\": ".$row['Valor']." ";    
		    $json .= "} ";   
		    $i++;
		}  
		$json .= " ] ";
	    $json .= " } ";  
	    return $json; 
		}

  public function getLastIP(){
		 $sql = "SELECT Arduino_IP.IP";
		 $sql .= " FROM Arduino_IP ";
		 $db = new dbmanager();
		 $result = $db->executeQuery($sql);
		 return  mysql_result($result,0);
     }

  public function putLastIP(){
		 $sql = "delete FROM Arduino_IP ";
		 $db = new dbmanager();
		 $result = $db->executeQuery($sql);

         $IP  = $_SERVER['REMOTE_ADDR'];    
		 $sql = " insert into Arduino_IP (IP) values ('".$IP."') ";
		 
		 $db = new dbmanager();
		 $result = $db->executeQuery($sql);
		 return  $result;
     }






}