alarmModule.php

<?php
include '/home/pi/UNICEF_VACCINE_MONITOR/hilink_smsGateway.php';

// Global variables
$fridgeMax = 7.5;
$fridgeLow = 2.5;
$freezerMax = -15;
$freezerLow = -25;


$db = new mysqli('localhost', 'root', 'raspberry', 'emoncms');

if($db->connect_errno > 0){
	die('Unable to connect to database [' . $db->connect_error . ']');
}

$alarms = "";

// Check Power source
$input = $db->query("SELECT * FROM feeds WHERE tag = 'power-source'");

while($row = $input -> fetch_assoc()) {
	if($row['value'] == '0') {
		$time = strtotime($row['time']);
		
		if(time()-$time < 10 * 60) { // if reading is less than 10 min old
			$alarms = $alarms."The power-grid seems to be down! - ";
		}
	}
}

// Check Fridges
$input = $db->query("SELECT * FROM feeds WHERE tag = 'fridge'");

while($row = $input -> fetch_assoc()) {
	$name = $row['name'];
	$val = floatval($row['value']);
	$time = strtotime($row['time']);

	if(time()-$time < 10 * 60) { // if reading is less than 10 min old
		if($val > $fridgeMax OR $val < $fridgeLow) {
			$alarms = $alarms."[".$name."] ".$row['value'].", ";
		}
	}
}


if(strlen($alarms) > 0) {
	$mutetime = time() - 30 * 60;
	$users = $db -> query("SELECT * FROM event WHERE lasttime < '$mutetime'");
	
	while($row = $users -> fetch_assoc()) {
		$phoneNumber = $row['setphonenumber'];
		$message = "ALARM: ".substr($alarms, 0, -2);
		echo $message;
		sendMessage($phoneNumber, $message);
		$id = $row['id'];
		$updateTime = time();
		$db -> query("UPDATE event SET lasttime = '$updateTime' WHERE id = '$id'");
	}
}?>