X-Git-Url: https://git.rvb.name/weathermon.git/blobdiff_plain/6c7c64de24a54d6bea09cb5a179d3a4c630c13ef..d5653b977ce2b9d0ef6e6c07b3a9b64c1462e601:/web/index.php?ds=inline diff --git a/web/index.php b/web/index.php deleted file mode 100644 index 37251e6..0000000 --- a/web/index.php +++ /dev/null @@ -1,103 +0,0 @@ - - - - - - - WeatherMon (Последние 24 часа) - - - - -
- false)))) { - die($err); - } - -$db -> exec('SET CHARACTER SET utf8'); - -$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 - order by s_description,st_description' - ); -$q -> execute(); - -while ($row = $q -> fetch(PDO::FETCH_ASSOC)) { - - 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 = "?"; -$value = "?"; - -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); - -} - -echo '
'.$printable_ts.'
'; -echo '
'.$val.' '.$param_unit.'
'; -?> -
-"; - -} - -?> -
-
-Архивные данные -Подробные графики -Настройки -
- - \ No newline at end of file