sensor_data/view.php at main · dodosi/sensor_data · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8" />
  <meta name="viewport" content="width=device-width, initial-scale=1.0"/>
  <title>Sensor Data Visualization</title>
  <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet"/>
  <script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
</head>
<body>
  <!-- Navigation Bar -->
  <nav class="navbar navbar-expand-lg navbar-dark bg-primary">
    <div class="container-fluid">
      <a class="navbar-brand" href="#">Sensor Dashboard</a>
      <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarSupportedContent">
        <span class="navbar-toggler-icon"></span>
      </button>
    </div>
  </nav>

  <!-- Filters -->
  <div class="container mt-4">
    <div class="row align-items-center mb-4">
      <div class="col-md-4 mb-2">
        <label for="locationSelect" class="form-label fw-bold">Select Location</label>
        <select id="locationSelect" class="form-select">
          <option value="UR">University of Rwanda</option>
          <option value="CMU">Carnegie Mellon University</option>
          <option value="MAKERERE">Makerere University</option>
        </select>
      </div>
      <div class="col-md-4 mb-2">
        <label for="nodeSelect" class="form-label fw-bold">Select Node</label>
        <select id="nodeSelect" class="form-select">
          <option value="ENV_001">ENV_001</option>
          <option value="ENV_002">ENV_002</option>
          <option value="UR_KGL">UR_KGL</option>
          <option value="MAKERERE_A">MAKERERE_A</option>
        </select>
      </div>
      <div class="col-md-4 d-flex align-items-end">
        <button id="refreshButton" class="btn btn-outline-primary w-100">Refresh Data</button>
      </div>
    </div>

    <!-- Temperature Chart -->
    <div class="card mb-5">
      <div class="card-body">
        <h5 class="card-title">Temperature (AHT20)</h5>
        <canvas id="temperatureChart"></canvas>
      </div>
    </div>

    <!-- Humidity Chart -->
    <div class="card mb-5">
      <div class="card-body">
        <h5 class="card-title">Humidity (AHT20)</h5>
        <canvas id="humidityChart"></canvas>
      </div>
    </div>
  </div>

  <!-- Scripts -->
  <script>
    let temperatureChart, humidityChart;

    async function fetchDataAndUpdateCharts(nodeId) {
      try {
        const response = await fetch(`get_data.php?node_id=${encodeURIComponent(nodeId)}`);
        const data = await response.json();

        const labels = data.map(row => row.timestamp);
        const temperature = data.map(row => JSON.parse(row.data).temperature.aht20[0]);
        const humidity = data.map(row => JSON.parse(row.data).humidity.aht20[0]);

        if (temperatureChart) {
          temperatureChart.data.labels = labels;
          temperatureChart.data.datasets[0].data = temperature;
          temperatureChart.update();
        } else {
          temperatureChart = new Chart(document.getElementById('temperatureChart'), {
            type: 'line',
            data: {
              labels,
              datasets: [{
                label: 'Temperature (°C)',
                data: temperature,
                backgroundColor: 'rgba(255, 99, 132, 0.2)',
                borderColor: 'rgba(255, 99, 132, 1)',
                borderWidth: 1
              }]
            }
          });
        }

        if (humidityChart) {
          humidityChart.data.labels = labels;
          humidityChart.data.datasets[0].data = humidity;
          humidityChart.update();
        } else {
          humidityChart = new Chart(document.getElementById('humidityChart'), {
            type: 'line',
            data: {
              labels,
              datasets: [{
                label: 'Humidity (%)',
                data: humidity,
                backgroundColor: 'rgba(54, 162, 235, 0.2)',
                borderColor: 'rgba(54, 162, 235, 1)',
                borderWidth: 1
              }]
            }
          });
        }
      } catch (err) {
        console.error("Error fetching data:", err);
      }
    }

    const nodeSelect = document.getElementById('nodeSelect');
    const refreshButton = document.getElementById('refreshButton');

    refreshButton.addEventListener('click', () => {
      fetchDataAndUpdateCharts(nodeSelect.value);
    });

    // Load initial data
    fetchDataAndUpdateCharts(nodeSelect.value);

    // Auto-refresh every minute
    setInterval(() => {
      fetchDataAndUpdateCharts(nodeSelect.value);
    }, 1000);
  </script>
  <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>