Ejemplo n.º 1
0
function people_dial(&$call)
{
    global $db;
    $extension = $call->get_extension();
    $callerId = $call->get_cid();
    $callerIdFull = $call->get_cidFull();
    $query = "select Context " . "  from AsteriskGoto " . " where Extension = {$extension} ";
    $query = $db->query($query);
    check_db($query);
    if ($row = $query->fetchRow(DB_FETCHMODE_ORDERED)) {
        // ceci boycott complètement le fonctionnement d'obelisk
        agi_goto($row[0]);
    }
    return agi_notFound($call);
}
Ejemplo n.º 2
0
function geo_dial(&$call)
{
    global $db;
    $extension = $call->get_extension();
    $callerId = $call->get_cid();
    $callerIdFull = $call->get_cidFull();
    $query = "select destination.People_Extension " . "from Geographical_Alias as caller, " . " \tGeographical_Alias as destination, " . "\tGeographical_Group as grp " . "where caller.People_Extension = '" . $callerId . "' " . "  and caller.Geographical_Group_ID = grp.ID " . "  and grp.ID = destination.Geographical_Group_ID " . "  and destination.Extension = '" . $extension . "' ";
    $query = $db->query($query);
    check_db($query);
    if (!($row = $query->fetchRow(DB_FETCHMODE_ORDERED))) {
        agi_log(DEBUG_ERR, "geo/dial.inc.php: extension : " . $extension . " not found");
        return agi_notFound($call);
    }
    agi_log(DEBUG_INFO, "geo/dial.inc.php: {$extension} -> " . "People : " . $row[0]);
    $call->set_extension($row[0]);
    include_once 'modules/people/dial.inc.php';
    return people_dial($call);
}
Ejemplo n.º 3
0
function people_dial(&$call)
{
    global $db;
    $extension = $call->get_extension();
    $callerId = $call->get_cid();
    $callerIdFull = $call->get_cidFull();
    $query = "select ChanType, username, VoIPAccount.ID " . "  from People, VoIPAccount, VoIPChannel " . " where People.Extension = {$extension} " . "   and VoIPAccount.People_Extension = {$extension} " . "   and VoIPAccount.VoIPChannel_ID = VoIPChannel.ID " . "   and VoIPAccount.Enable = true ";
    $query = $db->query($query);
    check_db($query);
    if ($row = $query->fetchRow(DB_FETCHMODE_ORDERED)) {
        $dialStr = $row[0] . "/" . $row[1] . "-" . $row[2];
        while ($row = $query->fetchRow(DB_FETCHMODE_ORDERED)) {
            $dialStr .= "&";
            $dialStr .= $row[0] . "/" . $row[1] . "-" . $row[2];
        }
        agi_log(DEBUG_DEBUG, "people_dial(): {$callerId} : " . "{$extension} -> '{$dialStr}'");
        return agi_call($call, $dialStr, "r", 0, 0);
    }
    return agi_notFound($call);
}
Ejemplo n.º 4
0
function sample_dial(&$call)
{
    agi_log(DEBUG_ERR, "sample/dial.inc.php: Not yet implemented");
    return agi_notFound($call);
}
Ejemplo n.º 5
0
/**
 * agi_dial - write asterisk AGI code in order to call $extension as $callerID
 *			using the table dialplan
 *
 * PRE: $call : a complete ObjCall
 *
 * POST: look the extension & the caller Id in the database in order to write
 *		(agi_write) the AGI script 
 *	si l'extension n'est pas joignable ^ annonce vocale ^ 
 *			return a negative number.
 *		v joingnable ^ ouverture de communication ^ 
 * 			return a positive value (incl. 0)  which is 
 *				the price of the call
 * 		joignable = existe, traitée par un module et que le caller a le
 *			droit de joindre
 */
function agi_dial(&$call)
{
    global $db;
    $extension = $call->get_extension();
    $callerId = $call->get_cid();
    $callerIdFull = $call->get_cidFull();
    agi_log(DEBUG_DEBUG, "agi_dial({$extension}, {$callerId}, " . "{$callerIdFull})");
    // on recherche a quel module appartient l'extension et si le
    // responsable peut joindre cette extension
    $query = "Select name " . "from Extension, Module, Rights, Grp_has_People " . "where ((ext_end is not null and " . "extension_type_comp(extension,  '{$extension}') <= 0 " . "and extension_type_comp(ext_end,  '{$extension}') >= 0) or " . " (ext_end is null and extension = '{$extension}'))" . " and Extension.Module_ID = Module.ID " . "and Grp_has_People.People_Extension = " . $call->get_responsable() . " " . "and Grp_has_People.Grp_ID = Rights.Grp_ID " . "and Rights.Module_Action_ID = 0" . "and Rights.Module_ID = Module.ID";
    $query = $db->query($query);
    check_db($query);
    if ($row = $query->fetchRow(DB_FETCHMODE_ORDERED)) {
        agi_log(DEBUG_INFO, "agi_dial(): extension " . $extension . " is handeled by : " . $row[0]);
        // on tente d'inclure le dial du module en question
        include 'modules/' . $row[0] . '/dial.inc.php';
        // on génère le nom de la fonction dial
        $fct = $row[0] . '_dial';
        return $fct($call);
        agi_log(DEBUG_INF, "agi_obelisk.php: DONE");
    } else {
        return agi_notFound($call);
    }
}
Ejemplo n.º 6
0
function outside_dial(&$call)
{
    global $db;
    // 1°) trouver à quel réseau appartient l'extension
    $net = outside_getNetworkId($call);
    agi_log(DEBUG_DEBUG, 'outside_dial() : ' . $call->get_extension() . " -> {$net}");
    if ($net < 0) {
        return agi_notFound($call);
    }
    // 2°) faut-il annoncer le prix à l'utilisateur ?
    //	faut-il continuer plus cher ?
    $query = "select P.Announce, P.AskHigherCost " . "  from People_PrePay_Settings as P  " . " where People_Extension = " . $call->get_responsable();
    $query = $db->query($query);
    check_db($query);
    if (!($row = $query->fetchRow(DB_FETCHMODE_ORDERED))) {
        // not found : paramètre par défaut :
        $askHigher = false;
        $announce = true;
        agi_log(DEBUG_INFO, "outside_dial() : account not found");
    } else {
        $askHigher = $row[1];
        $announce = $row[0];
    }
    agi_log(DEBUG_DEBUG, "outside_dial() : {$announce} - {$askHigher}");
    // 3°) récupérer la liste des providers et leur prix
    $query = "select N.Name, N.channel, P.ConnectionPrice, P.Price, " . "       P.RmDigits, P.AddDigits, N.DialOpts " . " from  NetworkProvider as N, Price as P, " . "\t NetworkTimeZone_details as T " . " where P.Network_ID = {$net} " . "   and P.NetworkProvider_ID = N.ID " . "   and P.NetworkTimeZone_ID = T.NetworkTimeZone_ID " . "   and (" . date("i") . " between start_min and end_min )" . "   and (" . date("G") . " between start_hour and end_hour )" . "   and (" . date("n") . " between start_month and end_month )" . "   and (" . date("j") . " between start_dom and end_dom )" . "   and (" . date("w") . " between start_dow and end_dow )" . " order by P.Price, P.ConnectionPrice ";
    $query = $db->query($query);
    check_db($query);
    /*	0 : name	
     *	1 : channel
     *	2 : priceConn
     *	3 : price/min
     *	4 : RmDigits
     *	5 : AddDigits
     *	6 : DialOpts
     */
    if ($query->numRows() == 0) {
        return agi_notFound($call);
    }
    $provider = $query->fetchRow(DB_FETCHMODE_ORDERED);
    // 4°) on tente d'appeler
    $isFirst = true;
    // première tentative au prix le plus bas
    while (($isFirst || $askHigher) && $provider != NULL) {
        $price = $provider[3];
        // 5°) on annonce au besoin :
        if ($announce) {
            agi_play_soundSet(SOUNDSET_PRICE_ANNOUNCE, "");
            agi_sayNumber(ceil($price * 100));
            agi_play_soundSet(SOUNDSET_CURRENCY, "");
        }
        // on teste l'un à la suite de l'autre tout les providers
        // qui ont le même prix d'appel
        while ($provider[3] == $price && $provider != NULL) {
            $callStr = $provider[1] . $provider[5] . substr($call->get_extension(), $provider[4]);
            agi_log(DEBUG_DEBUG, "outside_dial() : trying : {$callStr}");
            $result = agi_call($call, $callStr, $provider[6], $provider[2], $provider[3], false);
            if ($result >= 0 || $call->get_lastTryStatus() != "CHANUNAVIL") {
                // succeed
                return $result;
            }
            $provider = $query->fetchRow(DB_FETCHMODE_ORDERED);
        }
        // annonce qu'il est impossible d'effectuer l'appel au prix
        // annoncé précédement
        agi_play_soundSet(SOUNDSET_UNAVAIL_AT_PRICE, "");
        $first = false;
        // téléchargement du provider suivant
        $provider = $query->fetchRow(DB_FETCHMODE_ORDERED);
    }
    agi_logCall($call, 0, 0, "NOT ROUTABLE");
    return -1;
}