X-Git-Url: https://git.rvb.name/weathermon.git/blobdiff_plain/e4e1557426f8e5ca10ca616140528939d86426cd..43054b4dc0965871a36730c619ee2cde76540a38:/web/graphs.php diff --git a/web/graphs.php b/web/graphs.php new file mode 100644 index 0000000..850d9d7 --- /dev/null +++ b/web/graphs.php @@ -0,0 +1,78 @@ +<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> +<html> +<head> + <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> + <meta name="GENERATOR" content="Mozilla/4.72 (X11; U; Linux 2.2.12-20smp i686) [Netscape]"> + <title>WeatherMon (ÐоÑледние 24 ÑаÑа)</title> + <link rel="icon" href="favicon.png" /> + <style type="text/css"> + a:visited { text-decoration: none; color:darkblue; } + a:link { text-decoration: none; color:blue; } + a:hover { text-decoration: underline; color:navy; } + </style> +</head> +<body text="black" bgcolor="silver" link="blue" vlink="#000080" alink="#FF0000"> +<?php + +include('config_local.php'); + +$client_ip = $_SERVER["REMOTE_ADDR"]; + +if ((strpos($client_ip, "192.168.") === 0) || (strpos($client_ip, "10.8.") === 0) + || (strpos($client_ip, "2a02:578:5002:8174:") === 0) + || (strpos($client_ip, "2a02:578:5002:196::2") === 0)) { + + $local_net = True; + +} else { + + $local_net = False; + +} + + +if (! ($db = new PDO("mysql:host=$mysql_host;port=$mysql_port;dbname=$mysql_schema",$mysql_user,$mysql_pwd,array( PDO::ATTR_PERSISTENT => false)))) { + die($err); + } + +$db -> exec('SET CHARACTER SET utf8'); + +if (!$local_net) { + + $filter = ' and s.is_public=1'; + +} else { + + $filter = ''; + +} + +$q = $db -> prepare( + 'select + distinct v.sensor_id,s.s_description,p.id as param_id,p.st_description + from + sensor_values v,st_parameters p,sensors s + where + v.timestamp>adddate(now(), -1) + and v.sensor_id=s.id + and s.st_id=p.st_id + and p.id>=0'.$filter.' + order by s_description,st_description' + ); +$q -> execute(); + +while ($row = $q -> fetch(PDO::FETCH_ASSOC)) { + + echo '<h3 align="center">'.$row['s_description'].'/'.$row['st_description'].'</h3>'; +?> +<center><img src="image.php?sensor=<?php echo $row['sensor_id']; ?>¶m=<?php echo $row['param_id']?>&type=last24"></center> +<?php + +} + +?> +<a href="archive.php">ÐÑÑ Ð¸Ð²Ð½Ñе даннÑе</a> +<br> +<a href="setup.php">ÐаÑÑÑойки</a> +</body> + \ No newline at end of file