root/contributed_modules/modules/cidpopup/functions.inc.php

<?php

/* cidpopup_get_config()
 *
 * generate the required gosub() target that will handle our script and provide feedback
 * to the agent (the beep).
**/
function cidpopup_get_config($engine) {
    global $ext;
    switch ($engine) {
        case 'asterisk':
            $context = 'sub-cidpost';
            $exten = 's';
            $ext->add($context, $exten, '', new ext_playback('beep'));
            $ext->add($context, $exten, '', new ext_agi('${DOPOSTAGI}'));
            $ext->add($context, $exten, '', new ext_return(''));
        break;
    }
}

/* cidpopup_hookGet_config()
 *
 * splice into the auto-confirm and auto-blkvm macros to launch our AGI script since these are
 * tacked onto every ringgoup.
**/
function cidpopup_hookGet_config($engine) {
    global $ext;
    switch($engine) {
        case "asterisk":
            // First splice the auto-confirm routines used by ringgoups
            //
            $priority = 'no_such_priority_end';
            $macro = 'macro-auto-confirm';
            $ext->splice($macro,'s',$priority,new ext_gosubif('$["${DOPOSTAGI}" != ""]','sub-cidpost,s,1'));
            $macro = 'macro-auto-blkvm';
            $ext->splice($macro,'s',$priority,new ext_gosubif('$["${DOPOSTAGI}" != ""]','sub-cidpost,s,1'));

            // Now splice each ringgoup that has this set
            //
            $context = 'ext-group';
            $priority = 'skipov';
            $groups = cidpopup_list('ringgroups');
            foreach ($groups as $group) {
                $exten = $group['id'];

                //Sanity check for blank extensions from past bug
                if ($exten == "") {
                    continue;
                }

                $popup_info = cidpopup_instance_get($group['postagi']);
                if (!empty($popup_info)) {
                    $ext->splice($context,$exten,$priority,new ext_setvar('_DOPOSTAGI',$popup_info['popup_script']));
                    $ext->splice($context,$exten,$priority,new ext_setvar('_POSTIPADDR',$popup_info['ipaddr']));
                    $ext->splice($context,$exten,$priority,new ext_setvar('_SAVEDCID','${CALLERID(all)}'));
                }
            }
        break;
    }
}

/* cidpopup_display_text()
 *
 * display the select box that is hooked into the Ring Group to choose a PopUp instance.
**/
function cidpopup_display_text($type, $viewing_itemid) {
    $cidpopup_id = cidpopup_get($type,$viewing_itemid);
    $html = '<tr><td colspan="2"><h5>';
    $html .= _("Post Answer CID PopUps");
    $html .= '<hr></h5></td></tr>';
    $html .= '<tr>';
    $html .= '<td valign="top"><a href="#" class="info">';
    $html .= _("PopUp Instance").'<span>'._("Select the PopUp Instance you want executed upon an agent answering a call.").'.</span></a>:</td>';

    $tresults = cidpopup_instance_list();
    $default = (isset($cidpopup_id) ? $cidpopup_id : '');

    $html .= '<td><select name="cidpopup_id" tabindex="<?php echo ++$tabindex;?>">';
    $html .= '<option value="">'._("None")."</option>";
    if (isset($tresults[0])) {
        foreach ($tresults as $tresult) {
            $html .=  '<option value="'.$tresult['cidpopup_id'].'"'.($tresult['cidpopup_id'] == $default ? ' SELECTED' : '').'>'.$tresult['description']."</option>\n";
        }
    }
    $html .= '</select></td></tr>';
    return $html;
}

/* cidpopup_hook_ringgroups()
 *
 * explicitly hook into ringgroups with the PopUp selections
**/
function cidpopup_hook_ringgroups($viewing_itemid, $target_menuid) {
    return cidpopup_display_text('ringgroups', ltrim($viewing_itemid, "GRP-"));
}

/* cidpopup_hookProcess_ringgroups()
 *
 * process the hook after being submitted from the ringgroup page
**/
function cidpopup_hookProcess_ringgroups($viewing_itemid, $request) {

    $viewing_itemid = ltrim($viewing_itemid, "GRP-");

    if (!isset($request['action'])) {
        return;
    }

    $cidpopup_id = isset($request['cidpopup_id'])?$request['cidpopup_id']:'';

    switch ($request['action'])    {
        case 'addGRP':
        case 'edtGRP':    
            cidpopup_update('ringgroups', $viewing_itemid, $cidpopup_id);
        break;
        case 'delGRP':
            cidpopup_del('ringgroups', $request['account']);
        break;
    }
}


/* cidpopup__XXXX() functions
 *
 * These functions are responsible for maintaining the list of Ring Groups
 * (or eventually other module types) that have been hooked with a popup and
 * the associated agi script/IP address instance to use.
**/

function cidpopup_get($type, $xtn) {
    global $db;

    $cidpopup_agi = $db->getOne("SELECT `postagi` FROM `cidpopup` WHERE `type` = '$type' AND `id` = '$xtn'");
    if(DB::IsError($cidpopup_arr)) {
        die_freepbx($cidpopup_arr->getDebugInfo()."<br><br>".'selecting from cidpopup table');    
    }
    return $cidpopup_agi;
}

function cidpopup_update($type, $ext, $cidpopup_id) {
    global $db;

    sql("DELETE FROM `cidpopup` WHERE `type` = '$type' AND `id` = '$ext'");

    $cidpopup_id = $db->escapeSimple(trim($cidpopup_id));
    if ($cidpopup_id != '') {
        $sql = "INSERT INTO `cidpopup` (`type`, `id`, `postagi`) VALUES ('$type','$ext','$cidpopup_id')";
        sql($sql);
    }
}

function cidpopup_del($type, $ext) {
    sql("DELETE FROM `cidpopup` WHERE `type` = '$type' AND `id` = '$ext'");
}

function cidpopup_list($type = '') {
    global $db;

    $sql = "SELECT * FROM `cidpopup`";
    if ($type != '') {
        $sql .= " WHERE `type` = '$type'";
    }
    $cidpopup_agi = sql($sql,'getAll',DB_FETCHMODE_ASSOC);
    return $cidpopup_agi;
}


/* cidpopup_instance_XXXX() functions
 *
 * These functions are responsible for maintaining the list of agi script / IP Address
 * pairs that are presented as a select box into the Ring Groups that use them to choose
 * if and where to send popup messages to.
**/

function cidpopup_instance_add($description, $popup_script, $ipaddr) {
    global $db;
    $sql = "INSERT INTO `cidpopup_instance` (`description`, `popup_script`, `ipaddr`) VALUES (".
        "'".$db->escapeSimple($description)."', ".
        "'".$db->escapeSimple($popup_script)."', ".
        "'".$db->escapeSimple($ipaddr)."')";
    $result = $db->query($sql);
    if(DB::IsError($result)) {
        die_freepbx($result->getMessage().$sql);
    }
}

function cidpopup_instance_edit($cidpopup_id, $description, $popup_script, $ipaddr) {
    global $db;
    $sql = "UPDATE `cidpopup_instance` SET ".
        "`description` = '".$db->escapeSimple($description)."', ".
        "`popup_script` = '".$db->escapeSimple($popup_script)."', ".
        "`ipaddr` = '".$db->escapeSimple($ipaddr)."' ".
        "WHERE `cidpopup_id` = ".$db->escapeSimple($cidpopup_id);
    $result = $db->query($sql);
    if(DB::IsError($result)) {
        die_freepbx($result->getMessage().$sql);
    }
}

function cidpopup_instance_delete($cidpopup_id) {
    global $db;
    $sql = "DELETE FROM `cidpopup_instance` WHERE `cidpopup_id` = ".$db->escapeSimple($cidpopup_id);
    $result = $db->query($sql);
    if(DB::IsError($result)) {
        die_freepbx($result->getMessage().$sql);
    }
}

function cidpopup_instance_list() {
    global $db;
    $sql = "SELECT `cidpopup_id`, `description`, `ipaddr`, `popup_script` FROM `cidpopup_instance` ORDER BY `description`";
    $results = $db->getAll($sql, DB_FETCHMODE_ASSOC);
    if(DB::IsError($results)) {
        die_freepbx($results->getMessage()."<br><br>Error selecting from cidpopup_instance in cidpopup_instance_list");    
    }
    return $results;
}

function cidpopup_instance_get($cidpopup_id) {
    global $db;
    $sql = "SELECT `cidpopup_id`, `description`, `ipaddr`, `popup_script` FROM `cidpopup_instance` WHERE `cidpopup_id` = ".$db->escapeSimple($cidpopup_id);
    $row = $db->getRow($sql, DB_FETCHMODE_ASSOC);
    if(DB::IsError($row)) {
        die_freepbx($row->getMessage()."<br><br>Error selecting row from cidpopup_instance in cidpopup_instance_get");    
    }
    return $row;
}

?>