/
cronjobPM2.php
50 lines (41 loc) · 1.71 KB
/
cronjobPM2.php
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
<?php
$con = new mysqli("103.21.59.166:3306", "appcom_sensor", "sensor123", "appcom_sensor_data");
if ($con->connect_errno) {
printf("Connect failed: %s\n", $mysqli->connect_error);
exit();
}
$con->options(MYSQLI_OPT_CONNECT_TIMEOUT, 500);
$queryOfDeviceNo = "SELECT DISTINCT device_serial_no FROM trial_pollution";
$sql=mysqli_query($con,$queryOfDeviceNo);
$device_serial_no=array();
while($rowdata = mysqli_fetch_assoc($sql)){
$device_serial_no[]=$rowdata;
}
//mysqli_close($con);
//echo json_encode($device_serial_no);
date_default_timezone_set('Asia/Kolkata');
$currentDateTime = date("Y-m-d H:i:s");
foreach($device_serial_no as $value){
$deviceSerailNo=implode(",",$value);
$con->options(MYSQLI_OPT_CONNECT_TIMEOUT, 500);
$queryOfAVG = "SELECT avg(pm2)as pm2 FROM trial_pollution
WHERE sen_time >= DATE_SUB('$currentDateTime', INTERVAL 24 HOUR) AND device_serial_no='$deviceSerailNo' ";
$isAvarage = mysqli_query($con,$queryOfAVG);
$avgValue=mysqli_fetch_row($isAvarage);
$Pm2AvgValue= $avgValue[0];
$currentDateTime = date("Y-m-d H:i:s");
$count=mysqli_num_rows($isAvarage);
if($count==1) {
$con->options(MYSQLI_OPT_CONNECT_TIMEOUT, 500);
$query = "INSERT INTO sensorAverage(pm2,device_serial_no,time) VALUES ('$Pm2AvgValue','$deviceSerailNo','$currentDateTime') ";
$isInserted = mysqli_query($con,$query);
if($isInserted) {
echo "inserted";
} else{
echo "Error";
}
} else{
echo"Cant Calculate Avg";
}
}
?>