X-Git-Url: https://git.rvb.name/weathermon.git/blobdiff_plain/3a48d89e76fd2ab87dabf08632474c529cf77ad4..76cb925db11bf98d7fc7030401f05f68043cc89a:/web/index.php?ds=inline diff --git a/web/index.php b/web/index.php index d513251..92a8e8e 100644 --- a/web/index.php +++ b/web/index.php @@ -2,14 +2,42 @@ - + + WeatherMon (Последние 24 часа) + - + +
false)))) { die($err); @@ -17,6 +45,16 @@ if (! ($db = new PDO("mysql:host=$mysql_host;port=$mysql_port;dbname=$mysql_sche $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 @@ -24,23 +62,69 @@ $q = $db -> prepare( 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 v.sensor_id=s.id + and v.parameter_id=p.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 '

'.$row['s_description'].'/'.$row['st_description'].'

'; + echo '
'; + echo '
'.$row['s_description'].'/'.$row['st_description'].'
'; + +$ql = $db -> prepare( + ' + SELECT unix_timestamp(timestamp) timestamp,DATE_FORMAT(timestamp,"%H:%i") printable,value + FROM + meteo.sensor_values + WHERE + sensor_id='.$row['sensor_id'].' and parameter_id='.$row['param_id'].' and timestamp>addtime(now(), -3600) + ORDER BY + timestamp desc + ' + ); + +$ql -> execute(); + +$printable_ts = "?"; +$val = "?"; + +if ($rowl = $ql -> fetch(PDO::FETCH_ASSOC)) { + + $timestamp = $rowl['timestamp']; + $printable_ts = $rowl['printable']; + $value = $rowl['value']; + + $units = get_unit($db,$row['param_id']); + $from_unit = $units['from']; + $to_unit = $units['to']; + $param_unit = $units['name']; + + $val = convert_unit($db,$value,$from_unit,$to_unit); + +} + +if ($printable_ts != '?') { + echo '
'.$printable_ts.'
'; + echo '
'.$val.' '.$param_unit.'
'; +} ?> -
+
"; + } ?> +
+ \ No newline at end of file