Missed calls Notification on Email (Issabel, FreePBX, Elastix, Asterisk)

This is a simple cronJob to send automatic a custom CDR email every 10 minutes that will include all missed calls of this period.

Create a php file named missed_calls.php

PHP

<?php //error_reporting(0); /*------------------------------------------------------------------------ # copyright Copyright (C) 2018 sbzsystems.com. All Rights Reserved. # @license - http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL # Websites: https://www.sbzsystems.com -------------------------------------------------------------------------*/ header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1 header('Content-Type: text/html; charset=UTF-8'); //error_reporting(0); $host = 'localhost'; $user = 'root'; $password = 'XXXXXXXX'; $db = 'asteriskcdrdb'; $logfile='/usr/local/issabel/missed_calls.log'; // Connects to your Database $link=mysqli_connect("$host", $user, $password) or die(mysqli_error($link)); mysqli_select_db($link,"$db") or die(mysqli_error($link)); mysqli_set_charset($link,'utf8'); //GET SQL TIME INTERVAL 10 MINUTE $query=" select calldate AS Timestamp, src AS CallerID from cdr where calldate > date_sub(now(), interval 1 MINUTE) /*and dst=600*/ group by CallerID, Timestamp "; $data = mysqli_query($link,$query) or die(mysqli_error($link)); //AND disposition like 'NO ANSWER' $txt=''; while($alldata = mysqli_fetch_array( $data )) { if (strlen($alldata['CallerID'])>5) { $txt=$txt. $alldata['Timestamp'].' <a href="tel:'.$alldata['CallerID'].'">'.$alldata['CallerID'].'</a><br>'; } } // mysqli_close($link); //file_put_contents($logfile, '#'.$txt.'#'.$query.'#'."\n", FILE_APPEND | LOCK_EX); if ($txt) { $to = "info@bikemall.gr"; $subject = "Missed calls"; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type:text/html;charset=UTF-8" . "\r\n"; $headers .= "From: info@bikemall.gr" . "\r\n"; mail($to,$subject,$txt,$headers); } ?>

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

<?php //error_reporting(0); /*------------------------------------------------------------------------ # copyright Copyright (C) 2018 sbzsystems.com. All Rights Reserved. # @license - http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL # Websites: https://www.sbzsystems.com -------------------------------------------------------------------------*/ header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1 header('Content-Type: text/html; charset=UTF-8'); //error_reporting(0); $host = 'localhost'; $user = 'root'; $password = 'XXXXXXXX'; $db = 'asteriskcdrdb'; $logfile='/usr/local/issabel/missed_calls.log'; // Connects to your Database $link=mysqli_connect("$host", $user, $password) or die(mysqli_error($link)); mysqli_select_db($link,"$db") or die(mysqli_error($link)); mysqli_set_charset($link,'utf8'); //GET SQL TIME INTERVAL 10 MINUTE $query=" select calldate AS Timestamp, src AS CallerID from cdr where calldate > date_sub(now(), interval 1 MINUTE) /*and dst=600*/ group by CallerID, Timestamp "; $data = mysqli_query($link,$query) or die(mysqli_error($link)); //AND disposition like 'NO ANSWER' $txt=''; while($alldata = mysqli_fetch_array( $data )) { if (strlen($alldata['CallerID'])>5) { $txt=$txt. $alldata['Timestamp'].' <a href="tel:'.$alldata['CallerID'].'">'.$alldata['CallerID'].'</a><br>';   } } // mysqli_close($link); //file_put_contents($logfile, '#'.$txt.'#'.$query.'#'."\n", FILE_APPEND | LOCK_EX); if ($txt) { $to = "info@bikemall.gr"; $subject = "Missed calls"; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type:text/html;charset=UTF-8" . "\r\n"; $headers .= "From: info@bikemall.gr" . "\r\n"; mail($to,$subject,$txt,$headers); } ?>

and store it here

/usr/local/issabel

1	/usr/local/issabel

Finally create an every minute cronjob named missed_calls.cron

* * * * * root /usr/bin/php -q /usr/local/issabel/missed_calls.php

1	* * * * *  root /usr/bin/php -q /usr/local/issabel/missed_calls.php

and store it here

/etc/cron.d/

1	/etc/cron.d/