Select Git revision
Code owners
Assign users and groups as approvers for specific file changes. Learn more.
index.php 2.26 KiB
<?php
require_once("classes/SQL.php");
include("include/_head.php");
?>
<!-- Page Header -->
<div class="row">
<div class="col-lg-12">
<h1 class="page-header">Dashboard
</h1>
</div>
</div>
<?php
$sql = new SQL();
$link = $sql->getLink();
$query = "SELECT * FROM (tbl_register INNER JOIN tbl_parameter ON tbl_register.id = tbl_parameter.fid_register) INNER JOIN tbl_data ON tbl_parameter.id = tbl_data.fid_parameter WHERE tbl_register.id IN (SELECT max(id) FROM tbl_register group by clientAddress) AND tbl_data.id IN (SELECT max(id) FROM tbl_data group by fid_parameter) GROUP BY name";
$result = $link->query($query);
while($row = $result->fetch_assoc()) {
echo '<!-- Projects Row -->
<div class="row">
<div class="col-lg-12">
<h3 class="page-header">'.$row["name"].'
<small>Secondary Text</small>
</h3>
</div>
</div>
<div class="row">';
$query2 = "SELECT * FROM (tbl_register INNER JOIN tbl_parameter ON tbl_register.id = tbl_parameter.fid_register) INNER JOIN tbl_data ON tbl_parameter.id = tbl_data.fid_parameter WHERE tbl_register.id = ".$row["fid_register"]." AND tbl_data.id IN (SELECT max(id) FROM tbl_data group by fid_parameter)";
$result2 = $link->query($query2);
while($row2 = $result2->fetch_assoc()) {
echo '
<div class="col-md-4 portfolio-item">';
if ($row2["type"] == "string"){
echo '
<a href="details.php?param='.$row2["fid_parameter"].'">
<img class="img-responsive" src="img/table.png" alt="">
</a>';
}else{
echo '
<a href="details.php?param='.$row2["fid_parameter"].'">
<img class="img-responsive" src="graph.php?param='.$row2["fid_parameter"].'" alt="">
</a>';
}
echo '
<h3>
<a href="details.php?param='.$row2["fid_parameter"].'">'.$row2["param"].'</a>
</h3>
<p>'.$row2["value"].'</p>
</div>';
}
echo '</div>
<!-- /.row -->';
}
?>
<?php
include("include/_foot.php");
?>