root/modules/branches/2.3/announcement/functions.inc.php

<?php

function announcement_destinations() {
    // return an associative array with destination and description
    foreach (announcement_list() as $row) {
        $extens[] = array('destination' => 'app-announcement-'.$row[0].',s,1', 'description' => $row[1]);
    }
    return $extens;
}

function announcement_get_config($engine) {
    global $ext;
    switch ($engine) {
        case 'asterisk':
            foreach (announcement_list() as $row) {
                if (! $row[6]) {
                    $ext->add('app-announcement-'.$row[0], 's', '', new ext_gotoif('$["${CDR(disposition)}" = "ANSWERED"]','begin'));
                    $ext->add('app-announcement-'.$row[0], 's', '', new ext_answer(''));
                    $ext->add('app-announcement-'.$row[0], 's', '', new ext_wait('1'));
                }
                $ext->add('app-announcement-'.$row[0], 's', 'begin', new ext_noop('Playing announcement '.$row[1]));
                if ($row[3] || $row[7]) {
                    // allow skip
                    if ($row[7]) {
                        $ext->add('app-announcement-'.$row[0], 's', '', new ext_responsetimeout(3));
                    }
                    $ext->add('app-announcement-'.$row[0], 's', 'play', new ext_background($row[2].'|nm'));
                    
                    if ($row[3]) {
                        $ext->add('app-announcement-'.$row[0], '_X', '', new ext_noop('User skipped announcement'));
                        if ($row[5]) {
                            $ext->add('app-announcement-'.$row[0], '_X', '', new ext_gotoif('$["x${IVR_CONTEXT}" = "x"]', $row[4].':${IVR_CONTEXT},return,1'));
                        } else {
                            $ext->add('app-announcement-'.$row[0], '_X', '', new ext_goto($row[4]));
                        }
                    }
                    if ($row[7]) {
                        $ext->add('app-announcement-'.$row[0], $row[7], '', new ext_goto('s,play'));
                    }
                } else {
                    $ext->add('app-announcement-'.$row[0], 's', '', new ext_playback($row[2].'|noanswer'));
                }

                // if repeat_msg enabled then set exten to t to allow for the key to be pressed, otherwise play message and go
                $exten = $row[7] ? 't':'s';
                if ($row[5]) {
                    $ext->add('app-announcement-'.$row[0], $exten, '', new ext_gotoif('$["x${IVR_CONTEXT}" = "x"]', $row[4].':${IVR_CONTEXT},return,1'));
                    if ($row[3] || $row[7])
                        $ext->add('app-announcement-'.$row[0], 'i', '', new ext_gotoif('$["x${IVR_CONTEXT}" = "x"]', $row[4].':${IVR_CONTEXT},return,1'));
                } else {
                    $ext->add('app-announcement-'.$row[0], $exten, '', new ext_goto($row[4]));
                    if ($row[3] || $row[7])
                        $ext->add('app-announcement-'.$row[0], 'i', '', new ext_goto($row[4]));
                }
                
            }
        break;
    }
}

function announcement_list() {
    global $db;
    $sql = "SELECT announcement_id, description, recording, allow_skip, post_dest, return_ivr, noanswer, repeat_msg FROM announcement ORDER BY description ";
    $results = $db->getAll($sql);
    if(DB::IsError($results)) {
        die($results->getMessage()."<br><br>Error selecting from announcement");    
    }
    return $results;
}

function announcement_get($announcement_id) {
    global $db;
    $sql = "SELECT announcement_id, description, recording, allow_skip, post_dest, return_ivr, noanswer, repeat_msg FROM announcement WHERE announcement_id = ".addslashes($announcement_id);
    $row = $db->getRow($sql);
    if(DB::IsError($row)) {
        die($row->getMessage()."<br><br>Errpr selecting row from announcement");    
    }
    return $row;
}

function announcement_add($description, $recording, $allow_skip, $post_dest, $return_ivr, $noanswer, $repeat_msg) {
    global $db;
    $sql = "INSERT INTO announcement (description, recording, allow_skip, post_dest, return_ivr, noanswer, repeat_msg) VALUES (".
        "'".addslashes($description)."', ".
        "'".addslashes($recording)."', ".
        "'".($allow_skip ? 1 : 0)."', ".
        "'".addslashes($post_dest)."', ".
        "'".($return_ivr ? 1 : 0)."', ".
        "'".($noanswer ? 1 : 0)."', ".
        "'".addslashes($repeat_msg)."')";
    $result = $db->query($sql);
    if(DB::IsError($result)) {
        die($result->getMessage().$sql);
    }
}

function announcement_delete($announcement_id) {
    global $db;
    $sql = "DELETE FROM announcement WHERE announcement_id = ".addslashes($announcement_id);
    $result = $db->query($sql);
    if(DB::IsError($result)) {
        die($result->getMessage().$sql);
    }
    
}

function announcement_edit($announcement_id, $description, $recording, $allow_skip, $post_dest, $return_ivr, $noanswer, $repeat_msg) { 
    global $db;
    $sql = "UPDATE announcement SET ".
        "description = '".addslashes($description)."', ".
        "recording = '".addslashes($recording)."', ".
        "allow_skip = '".($allow_skip ? 1 : 0)."', ".
        "post_dest = '".addslashes($post_dest)."', ".
        "return_ivr = '".($return_ivr ? 1 : 0)."', ".
        "noanswer = '".($noanswer ? 1 : 0)."', ".
        "repeat_msg = '".addslashes($repeat_msg)."' ".
        "WHERE announcement_id = ".addslashes($announcement_id);
    $result = $db->query($sql);
    if(DB::IsError($result)) {
        die($result->getMessage().$sql);
    }
}

?>