Skip to content
Permalink
master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

Watersys/monthly.php

Go to file
 
 
Cannot retrieve contributors at this time
94 lines (83 sloc) 3.71 KB
Raw Blame
Open in GitHub Desktop
<?php
//This page displays a list of all Users Monthly Consumption
include('config.php');
// $req = mysqli_query($var,"select username,monthly_consumption from users");
$req = mysqli_query($var,"SELECT users.id, users.username,users.monthly_consumption, valve.water_flow FROM users INNER JOIN valve ON users.id = valve.v_id");
$user = $_SESSION['username'];
while($dnn = mysqli_fetch_array($req))
{
if($user === $dnn['username']) {
$username = $dnn['username'];
$consumption = $dnn['monthly_consumption'];
$qty= $dnn['monthly_consumption'];
$dailyUsage = $dnn['water_flow'];
}
}
$qty = $qty + $dailyUsage;
// $monthly_consumption = $consumption + $dailyUsage;
$updateData = mysqli_query($var,"UPDATE users SET monthly_consumption='$qty' WHERE username ='$user' ");
?>
<div id="usage" style="display: none;">
<?php echo $consumption ?>
</div>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css" integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous">
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.min.js" integrity="sha384-wfSDF2E50Y2D1uUdj0O3uMBJnjuUD4Ih7YwaYd1iqfktj0Uod8GCExl3Og8ifwB6" crossorigin="anonymous"></script>
<link href="<?php echo $design; ?>/style.css" rel="stylesheet" title="Style" />
<title>Monthly User Usage Chart</title>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript">
google.charts.load('current', {'packages':['corechart']});
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
var div = document.getElementById("usage");
var myData = div.textContent;
var data = google.visualization.arrayToDataTable([
['username', 'montlhly_consumption'],
// ['This Month', <?php echo $consumption?>],
['Current Month', <?php echo $consumption + $dailyUsage?>],
['Last Month',<?php echo $consumption * 1.2 ?>],
['Second Last', <?php echo $consumption * 0.92 ?>],
// ['Watch TV', 2],
// ['Sleep', 7]
]);
var options = {
title: 'Monthly Usage'
};
var chart = new google.visualization.PieChart(document.getElementById('piechart'));
chart.draw(data, options);
}
</script>
</head>
<body>
<div>
<div align="center">
<div class="header" style="width: 100%; margin: auto;margin-top: 10px">
<img width="80%" src="<?php echo $design; ?>/images/logo.png" alt="Espace Membre" />
</div></div>
<div class="contentusers">
<div class="box">
<div class="box_left">
<a href="<?php echo $url_home; ?>">WCSF Index</a> &gt; Monthly Usage
</div>
<div class="box_right">
<a href="profile.php?id=<?php echo $_SESSION['userid']; ?>"><?php echo htmlentities($_SESSION['username'], ENT_QUOTES, 'UTF-8'); ?></a> (<a href="login.php">Logout</a>)
</div>
<div class="clean">
</div>
</div>
<br>
Monthly Usage:
<div align="center">
<div id="piechart" style="width: 900px; height: 500px;"></div></div>
</div>
<!-- <div class="foot">
<p><b>Water Control System and Discussion Portal for Farmers</b></p>
</div> -->
</div>
</div>
</body>
</html>