<?php // content="text/plain; charset=utf-8"

error_reporting(E_ALL & ~E_STRICT & ~E_NOTICE);

include ('config_local.php');

require_once ('jpgraph/jpgraph.php');
require_once ('jpgraph/jpgraph_line.php');
require_once ('jpgraph/jpgraph_date.php');
require_once ('jpgraph/jpgraph_scatter.php');
require_once ('jpgraph/jpgraph_regstat.php');

if (! ($db = new PDO("mysql:host=$mysql_host;port=$mysql_port;dbname=$mysql_schema",$mysql_user,$mysql_pwd,array( PDO::ATTR_PERSISTENT => false)))) {

  die('Не могу подключиться к БД');

}  

$db -> exec('SET CHARACTER SET utf8');
  
$type = $_REQUEST['type'];
$sensor=$_REQUEST['sensor'];
$param=$_REQUEST['param'];

if ($type and $param) {
  
  $sensor = intval($sensor);
  $param = intval($param);

  $q = $db -> prepare(
    'select s_description from sensors where id='.$sensor
  );
  $q -> execute();

  while ($row = $q -> fetch(PDO::FETCH_ASSOC)) {
    $sensor_name = $row['s_description'];
  }                                                                

  $q = $db -> prepare(
    'select st.st_dot_color,st.st_line_color,st.st_description,u.id,u.unit_group from st_parameters st,units u where st.id='.$param.' and st.st_unit=u.id'
  );
  $q -> execute();

  while ($row = $q -> fetch(PDO::FETCH_ASSOC)) {
    $param_name = $row['st_description'];
    $from_unit = $row['id'];
    $unit_group = $row['unit_group'];
    $dot_color = $row['st_dot_color'];
    $line_color = $row['st_line_color'];
  }                                                                

  if (!empty($_COOKIE['unit_'.$unit_group])) {
    $to_unit=intval($_COOKIE['unit_'.$unit_group]);
  } else {
    $to_unit=$from_unit;
  }  

  $q = $db -> prepare(
    'select u.name_short from units u where u.id='.$to_unit
  );
  $q -> execute();

  while ($row = $q -> fetch(PDO::FETCH_ASSOC)) {
    $param_unit = $row['name_short'];
  }                                                                
  
  $xdata = array();
  $ydata = array();

  if ($type == 'last24') { 

    $q = $db -> prepare(
      'select unix_timestamp(timestamp) as x,unitconv(value,'.$from_unit.','.$to_unit.') as y from sensor_values where timestamp>adddate(now(), -1) and sensor_id='.$sensor.' and parameter_id='.$param.' order by timestamp'
    );

    $height = 130;
    
  } elseif ($type == 'range') {

    $from = intval($_REQUEST['fromdate']);
    $to = intval($_REQUEST['todate']);

    $q = $db -> prepare(
      'select unix_timestamp(timestamp) as x,unitconv(value,'.$from_unit.','.$to_unit.') as y from sensor_values where timestamp>=str_to_date("'.$from.'","%Y%m%d%H%i%s") and timestamp<=str_to_date("'.$to.'","%Y%m%d%H%i%s") and sensor_id='.$sensor.' and parameter_id='.$param.' order by timestamp'
    );
  
    $height = 60;
  
  }

  $q -> execute();
    
  while ($row = $q -> fetch(PDO::FETCH_ASSOC)) {
    
    $xdata[] = $row['x'];
    $ydata[] = $row['y'];
    
  }                                                                


  for ($i = 0; $i < count($xdata); ++$i) {

    $total_weight=0;
    $sum=0;
    $maxdelta = 900;
    
    for ($j = $i; $j < count($xdata); ++$j) {
    
      $delta = abs($xdata[$i]-$xdata[$j]);
      if ($delta > $maxdelta) { break; }
    
      $weight = 1-$delta/$maxdelta;
      $total_weight += $weight;
      $sum += $weight*$ydata[$j];
      
    }

    for ($j = $i-1; $j >=0 ; --$j) {
    
      $delta = abs($xdata[$i]-$xdata[$j]);
      if ($delta > $maxdelta) { break; }
    
      $weight = 1-$delta/$maxdelta;
      $total_weight += $weight;
      $sum += $weight*$ydata[$j];
      
    }
    
    $new_val = $sum/$total_weight;
    $f_ydata[$i] = $new_val; 
    
  }

  // Create the graph
  $g = new Graph(640,480);
  $g->graph_theme = null;

  //$g->img->SetAntiAliasing();

  // We need a linlin scale since we provide both
  // x and y coordinates for the data points.
  $g->SetScale('datlin');
  $g->xaxis->SetLabelAngle(90);
  $g->xaxis->SetPos("min");

  // We use a scatterplot to illustrate the original
  // contro points.
  $splot = new ScatterPlot($ydata,$xdata);
  $g->Add($splot);

  // 
  $splot->mark->SetFillColor($dot_color);
  $splot->mark->SetColor($dot_color);
  $splot->mark->SetType(MARK_FILLEDCIRCLE);
  $splot->mark->SetSize(2);

  $fplot = new LinePlot($f_ydata,$xdata);
  $g->Add($fplot);
  $fplot->SetColor($line_color);
  $fplot->SetWeight(2);

  $g->SetMargin(50,30,40,$height);
  $g->title->Set($sensor_name.'/'.$param_name.', '.$param_unit);
  $g->title->SetFont(FF_DV_SANSSERIF,FS_BOLD,12);
  $g->SetMarginColor('silver');

  // Add the plots to the graph and stroke
  $g->Stroke();
  
} else {

  header("Content-Type: text/html; charset=UTF-8");
  die('Сенсор не выбран!');

}  

?>