GoTalk Limit Check: Difference between revisions
Created page with '= Introduction = This process checks for the number of calls and the number of minutes that have been used to GoTalk. If they exceed the default 100 calls and 500 minutes then t…' |
|||
Line 56: | Line 56: | ||
$agi = new AGI(); | $agi = new AGI(); | ||
$start = '5'; | $start = '5'; | ||
$mysql_host = 'localhost'; | $mysql_host = 'localhost'; | ||
$mysql_user = ' | $mysql_user = 'cdruser'; | ||
$mysql_password = ' | $mysql_password = 'passw0rd'; | ||
$my_database = 'asteriskcdr'; | $my_database = 'asteriskcdr'; | ||
$dbtable = ' | $dbtable = 'david'; | ||
Line 73: | Line 72: | ||
$minutes = '0'; | $minutes = '0'; | ||
$query_duration = "SELECT | $query_duration = "SELECT billsec FROM $dbtable WHERE calldate >= $from_date AND calldate <= $to_date AND disposition='ANSWERED' AND dst like '04%'"; | ||
$query_calls = "SELECT COUNT(dst) FROM $dbtable WHERE calldate >= $from_date AND calldate <= $to_date AND disposition='ANSWERED' AND dst like '04%'"; | $query_calls = "SELECT COUNT(dst) FROM $dbtable WHERE calldate >= $from_date AND calldate <= $to_date AND disposition='ANSWERED' AND dst like '04%'"; | ||
$query_cb_calls = "SELECT COUNT(dst) FROM $dbtable WHERE calldate >= $from_date AND calldate <= $to_date AND disposition='ANSWERED' AND dst like '04%' AND src like '04%'"; | $query_cb_calls = "SELECT COUNT(dst) FROM $dbtable WHERE calldate >= $from_date AND calldate <= $to_date AND disposition='ANSWERED' AND dst like '04%' AND src like '04%'"; | ||
Line 92: | Line 91: | ||
} | } | ||
} | } | ||
Line 102: | Line 102: | ||
$callnum = $callnum + $col_value; } | $callnum = $callnum + $col_value; } | ||
} | } | ||
Line 109: | Line 110: | ||
// Printing results in HTML | // Printing results in HTML | ||
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { | while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { | ||
foreach ($line as $col_value) { | foreach ($line as $col_value) | ||
{ | |||
$point = substr(round($col_value/60,1),-2,1); | |||
$deci = substr(round($col_value/60,1),-1); | |||
if ( $point == '.' & $deci <= 4 ) | |||
$minutes += round(($col_value/60)+.49); else $minutes += round($col_value/60); | |||
} | |||
} | } | ||
Revision as of 04:37, 23 December 2009
Introduction
This process checks for the number of calls and the number of minutes that have been used to GoTalk. If they exceed the default 100 calls and 500 minutes then the call is placed over another VSP. By default the failover is to Pennytel as they are the cheapest mobile phone provider with per second billing.
The script currently checks if the used minutes is actually larger than 470 minutes and not 500 as GoTalk round up all thier calls to the nearest minute.
extensions.ael
/etc/asterisk/extensions.ael
//04 Mobile Numbers context mobile-count { _04XXXXXXXX => { day=${STRFTIME(,,%d)}; if ( ${day} >= 5 ) { start=${STRFTIME(,,%G)}${STRFTIME(,,%m)}05000000; end=${STRFTIME(,,%G)}${STRFTIME(,,%m)}${day}235959; } else { if ( ${day} >= 1 & ${day} <= 4 ) { month=${STRFTIME(,,%m)}-1; start=${STRFTIME(,,%G)}${month}05000000; end=${STRFTIME(,,%G)}${STRFTIME(,,%m)}${day}235959; } } AGI(GoTalk.php,${start},${end}); NoOp(${calls} calls and ${minutes} minutes); if ( ${calls} > 100 | ${minutes} > 470 ) { Playback(beep&beep); PlayBack(announce/connection-to&announce/GoTalk&announce/failed-trying); PlayBack(announce/PennyTel); Dial(SIP/PennyTel/${EXTEN},${ringer}); HangUp(); } else Goto(mobiles,${EXTEN},1); }; };
GoTalk.php
Create the file in the folder /var/lib/asterisk/agi-bin
#!/usr/bin/php <?php require 'phpagi.php'; $agi = new AGI(); $start = '5'; $mysql_host = 'localhost'; $mysql_user = 'cdruser'; $mysql_password = 'passw0rd'; $my_database = 'asteriskcdr'; $dbtable = 'david'; $from_date = $argv[1]; $to_date = $argv[2]; $callnum = '0'; $minutes = '0'; $query_duration = "SELECT billsec FROM $dbtable WHERE calldate >= $from_date AND calldate <= $to_date AND disposition='ANSWERED' AND dst like '04%'"; $query_calls = "SELECT COUNT(dst) FROM $dbtable WHERE calldate >= $from_date AND calldate <= $to_date AND disposition='ANSWERED' AND dst like '04%'"; $query_cb_calls = "SELECT COUNT(dst) FROM $dbtable WHERE calldate >= $from_date AND calldate <= $to_date AND disposition='ANSWERED' AND dst like '04%' AND src like '04%'"; // Connecting, selecting database $link = mysql_connect($mysql_host, $mysql_user, $mysql_password) or die('Could not connect: ' . mysql_error()); mysql_select_db($my_database) or die('Could not select database'); // Performing SQL query $result = mysql_query($query_calls) or die('Query failed: ' . mysql_error()); // Printing results in HTML while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { foreach ($line as $col_value) { $callnum = $col_value; } } // Performing SQL query $result = mysql_query($query_cb_calls) or die('Query failed: ' . mysql_error()); // Printing results in HTML while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { foreach ($line as $col_value) { $callnum = $callnum + $col_value; } } // Performing SQL query $result = mysql_query($query_duration) or die('Query failed: ' . mysql_error()); // Printing results in HTML while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { foreach ($line as $col_value) { $point = substr(round($col_value/60,1),-2,1); $deci = substr(round($col_value/60,1),-1); if ( $point == '.' & $deci <= 4 ) $minutes += round(($col_value/60)+.49); else $minutes += round($col_value/60); } } // Free resultset mysql_free_result($result); // Closing connection mysql_close($link); $agi->set_variable("calls", $callnum); $agi->set_variable("minutes", $minutes); ?>
Pre-Requisite
To run a php AGI script you need to have three files phpagi-asmanager.php, phpagi-fastagi.php and phpagi.php. The files can be downloaded from sourceforge and be extracted to /var/lib/asterisk/agi-bin