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
|
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 |
<?php // copy to /usr/local/issabel // create a cronjob. // Save the file missed_calls.cron that contains // * * * * * root /usr/bin/php -q /usr/local/issabel/missed_calls_to_email.php // to folder /etc/cron.d/ // 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@myemail.com"; $subject = "Missed calls"; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type:text/html;charset=UTF-8" . "\r\n"; $headers .= "From: info@myemail.com" . "\r\n"; mail($to, $subject, $txt, $headers); } |
and store it here
|
1 |
/usr/local/issabel |
Finally create an every minute cronjob named missed_calls.cron
|
1 |
* * * * * root /usr/bin/php -q /usr/local/issabel/missed_calls.php |
and store it here
|
1 |
/etc/cron.d/ |
