| Server IP : 93.86.61.54 / Your IP : 216.73.216.60 Web Server : Apache/2.4.62 (Ubuntu) System : Linux rasin.ddns.net 6.8.0-124-generic #124~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Tue May 26 21:05:19 UTC x86_64 User : www-data ( 33) PHP Version : 8.4.22 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/projects/meteoca/ |
Upload File : |
<!DOCTYPE html>
<!--
******************************
Project: MeteoCA, 2017-2020
Version: PHP-7
Author : M. Kukic
Note :
******************************
-->
<html>
<style>
table, th, td {
border: 1px solid black;
}
th, td {
padding: 4px;
text-align: center;
}
</style>
<head>
<link rel='shortcut icon' type='image/png' href='favicon.png'/>
<title>AMS METEOCA</title>
<script>var dan = new Date();
document.write('CET '+dan.getDate()+'.'+(dan.getMonth()+1)+'.'+dan.getFullYear()+'. - '+dan.getHours()+':'+dan.getMinutes()+':'+dan.getSeconds());
</script>
</head>
<div style="width:720px; word-wrap:break-word;">
<?php
//
// GET metod prenosa
//
$ys = $_GET["ys"];
$ms = $_GET["ms"];
$ds = $_GET["ds"];
$hs = $_GET["hs"];
//$ns = $_GET["ns"];
//$ss="00";
//
$ye = $_GET["ye"];
$me = $_GET["me"];
$de = $_GET["de"];
$he = $_GET["he"];
//$ne = $_GET["ne"];
//$se="00";
include "config.php";
//
$ts=$ys."-".$ms."-".$ds." ".$hs.":00:00";
$te=$ye."-".$me."-".$de." ".$he.":00:00";
//
//$myfile = fopen($putanja."tste.txt", "w") or die("Unable to open file!");
//fwrite($myfile, $ts."\n");
//fwrite($myfile, $te."\n");
//fclose($myfile);
// brisanje
$sql="truncate dataext";
$result = mysqli_query($dbh, $sql) or die(mysqli_error());
//upis
$sql = "INSERT INTO dataext (id,vreme) VALUES ('0','$ts')";
mysqli_query($dbh, $sql) or die(mysqli_error());
$sql = "INSERT INTO dataext (id,vreme) VALUES ('0','$te')";
mysqli_query($dbh, $sql) or die(mysqli_error());
//citanje
//$sql="SELECT * FROM dataext";
//$result=mysqli_query($dbh,$sql) or die(mysqli_error($con));
// $row = mysqli_fetch_array($result);
// $ts=$row[1];
// $row = mysqli_fetch_array($result);
// $te=$row[1];
//stampanje
//echo "<br>";
//echo $ts." # ".$te;
//
$summerenja=0;
//
echo "
<hr>
<fieldset>
<legend><h3>Mreza AMS - Čačak</h3></legend>
<table border=\"0\"></legend>";
echo $ts." # ".$te;
echo "<h4>Set Data and Time!</h4>";
//echo "<br><br>";
//
$sql="truncate datatim";
$result = mysqli_query($dbh, $sql) or die(mysqli_error());
//
$sql="INSERT INTO datatim SELECT * FROM datalog WHERE tim < '".$te."' AND tim > '".$ts."' ORDER BY id";
$result = mysqli_query($dbh, $sql) or die(mysqli_error());
//
$merenja = array(0, 0, 0, 0);
$baro = array(0, 0, 0, 0);
$temp = array(0, 0, 0, 0);
$sun = array(0, 0, 0, 0);
$wind = array(0, 0, 0, 0);
$tim = array('', '', '', '');
$last = array('', '', '', '');
//
// PARAMETAR MIN-MAX
$parmin = array(0, 0, 0, 0);
$parmax = array(0, 0, 0, 0);
$partimmin = array(" ", " ", " ", " ");
$partimmax = array(" ", " ", " ", " ");
//
// Clean and Data copy
for ($i = 0; $i<$nams; $i++)
{
$sql="truncate ".$data[$i];
$result = mysqli_query($dbh, $sql) or die(mysqli_error());
$sql="INSERT INTO ".$data[$i]." SELECT * FROM datatim WHERE amsid='".$ams[$i]."'";
$result = mysqli_query($dbh, $sql) or die(mysqli_error());
}
// Merenja
for ($i = 0; $i<$nams; $i++) {
$sql ="select count(*) from ".$data[$i];
$result=mysqli_query($dbh,$sql) or die(mysqli_error($con));
$row = mysqli_fetch_array($result);
$merenja[$i]=$row[0];
//$merenja[$i]=mysqli_num_rows($result); xxx
if ($merenja[$i]==0){
$sql = "INSERT INTO ".$data[$i]." (id,amsid,tim,baro,temp,humi,sun,wind,p6,p7,p8) VALUES ('0','-',NOW(),'0','0','0','0','0','0','0','0')";
mysqli_query($dbh, $sql) or die(mysqli_error());
}
// Ukupno
$summerenja=$summerenja+$merenja[$i];
}
// Statistika Merenja
echo "<h4>Sample:</h4>";
// TAB Merenja
echo "<table border='1'>";
echo "<tr>";
echo "<th>Stanica</th>";
echo "<th>No</th>";
echo "</tr>";
for ($i = 0; $i<$nams; $i++)
{
echo "<tr>";
echo "<td>".$amsnam[$i]."</td>";
echo "<td>".$merenja[$i]."</td>";
echo "</tr>";
}
echo "<tr>";
echo "<td>Sum</td>";
echo "<td>$summerenja</td>";
echo "</tr>";
echo "</table>";
echo "<br>";
if ($nams==2) echo "<img src='datapia.php?c1=".$merenja[0]."&c2=".$merenja[1]."&c3=0&c4=0&c5=0&c6=0'>";
if ($nams==3) echo "<img src='datapia.php?c1=".$merenja[0]."&c2=".$merenja[1]."&c3=".$merenja[2]."&c4=0&c5=0&c6=0'>";
if ($nams==4) echo "<img src='datapia.php?c1=".$merenja[0]."&c2=".$merenja[1]."&c3=".$merenja[2]."&c4=".$merenja[3]."&c5=0&c6=0'>";
if ($nams==5) echo "<img src='datapia.php?c1=".$merenja[0]."&c2=".$merenja[1]."&c3=".$merenja[2]."&c4=".$merenja[3]."&c5=".$merenja[4]."&c6=0'>";
if ($nams==6) echo "<img src='datapia.php?c1=".$merenja[0]."&c2=".$merenja[1]."&c3=".$merenja[2]."&c4=".$merenja[3]."&c5=".$merenja[4]."&c6=".$merenja[5]."'>";
mysqli_close($dbh);
?>
<hr>
<a href='javascript:history.go(-1)'><img src='img/back.png'></a><a href='ams.php'><img src='img/hom.png'><a href='wemos-d1.htm'><img src='img/info.png'></a>
</div>
</body>
</html>