ringzone.php

<?php


/*
* Project Name:  FusionBells for FusionPBX
* 
* Description: Multicast Bell Notification for 
* education environments. Uses FFMPEG for transcoding 
* and network delivery.
*
* Requirements: FusionPBX, SQLite and Multicast  network
* configuration.
*
* Developer: FikesMedia.com 
* Contact: support@fikesmedia.com
* Copyright: Copyright 2017 FikesMedia All Right Reserved
*/



/*
* Checks this moment for bells and rings in this zone
*
* Christopher Fikes
* 03/05/2017
*/
if (empty($_POST) || $_POST['key'] == "" || is_null($_POST['key'])) {
	exit("No Valid POST");
}
$UUID = $_POST['key'];
//If Database Exist continue...
if (file_exists("$UUID.db")) {

	$dateNow = date("Y-m-d");
	$timeNow = date("H:i");
		try {
			
			/*
			* Look at Changing to nested Selects, por exemplo
			*   SELECT * FROM schedules WHERE Schedule = (select Schedule from calendar where Date = "2017-03-20") AND Time > "10:00"
			*/
			
			//Connect to DB
			$fusionBellDB = new PDO("sqlite:$UUID.db");
			//Am I Acting ZoneBOX
			$ActingZB = $fusionBellDB->prepare('SELECT SettingValue FROM Settings WHERE SettingName = ?');
			$ActingZB->execute(array("Acting ZoneBOX"));
			while ($row = $ActingZB->fetch(PDO::FETCH_ASSOC)) {
				$isActingZB = $row['SettingValue'];
			}
			if ($isActingZB != "Enabled") {
				exit("Not Acting ZB");
			}

			//Is Today Special.
			$Special = $fusionBellDB->prepare('SELECT calendar.Schedule,schedules.Time,schedules.Tone,schedules.Zone FROM schedules inner join calendar ON schedules.Schedule = calendar.Schedule WHERE calendar.Date = ? AND schedules.Time >= ? ORDER BY schedules.Time LIMIT 1');
			$Special->execute(array($dateNow,$timeNow));
			//Assign Values to use from results
			if(count($Special,0) != 0) {
				foreach ($Special as $row) {
					$Schedule = $row['Schedule'];
					$Tone = $row['Tone'];
					$Time = $row['Time'];
					$Zone = $row['Zone'];
				}
			}
			//If Results Set Values This is a calendar identified bell time
			if ( isset($Tone) && isset($Time) && isset($Schedule) ) {
				//Query Multicast address to use
				$Result = $fusionBellDB->prepare("SELECT ZoneValue FROM zones WHERE ZoneName = ? LIMIT 1");
				$Result->execute(array($Zone));
				//Set value is any return given
				if(count($Result,0) != 0) {
					foreach($Result as $row){
						$Address = $row['ZoneValue'];
					}
				}
				if ( $Time == $timeNow ) {
					//Call System command with specified parameters
					$exec="./ffmpeg -re -i ./tones/$UUID/$Tone -filter_complex 'aresample=16000,asetnsamples=n=160' -acodec g722 -ac 1 -vn -f rtp udp://$Address &"; 
					exec($exec);
				}
			} else {
				//Not calendar specified schedule, check for default bell
				$Default = $fusionBellDB->prepare('SELECT settings.SettingValue,schedules.Time,schedules.Tone,schedules.Zone FROM schedules inner join settings ON schedules.Schedule = settings.SettingValue WHERE schedules.Time = ? ORDER BY schedules.Time LIMIT 1');
				$Default->execute(array($timeNow));
				//Set value is any return given
				if(count($Default,0) != 0){
					foreach($Default as $row){
						$Schedule = $row['SettingValue'];
						$Tone = $row['Tone'];
						$Time = $row['Time'];
						$Zone = $row['Zone'];
					}
				}
				if ( isset($Tone) && isset($Time) && isset($Schedule) ) {
					//Query Multicast address to use
					$Result = $fusionBellDB->prepare("SELECT ZoneValue FROM zones WHERE ZoneName = ? LIMIT 1");
					$Result->execute(array($Zone));
					//Set value is any return given
					if(count($Result,0) != 0) {
						foreach($Result as $row){
							$Address = $row['ZoneValue'];
						}
					}
					//Call System command with specified parameters
					$exec="./ffmpeg -re -i ./tones/$UUID/$Tone -filter_complex 'aresample=16000,asetnsamples=n=160' -acodec g722 -ac 1 -vn -f rtp udp://$Address &"; 
					exec($exec);
				} else {
					echo "NOTING SETUP FOR THIS MOMENT\n";
				}
			}
		}
		//Issues connecting
		catch (PDOException $e) {
			//Print Error Message
			print 'Exception : ' . $e->getMessage();
		}
}

?>