root/modules/branches/2.4/customappsreg/functions.inc.php

<?php

function customappsreg_destinations() {
  // return an associative array with destination and description
  foreach (customappsreg_customdests_list() as $row) {
    $extens[] = array('destination' => $row['custom_dest'], 'description' => $row['description']);
  }
  return $extens;
}

/** the 'exten' is the same as the destination for this module
 */
function customappsreg_customdests_getdest($exten) {
  return array($exten);
}

/** If this is ours, we return it, otherwise we return false
 *  We use just use customappsreg and not the display because it
 *  is a per-module routine
 */
function customappsreg_getdestinfo($dest) {
  global $active_modules;

  $thisexten = customappsreg_customdests_get($dest);
  if (empty($thisexten)) {
    return false;
  } else {
    $type = isset($active_modules['customappsreg']['type'])?$active_modules['customappsreg']['type']:'tool';
    return array('description' => 'Custom Destination: '.$thisexten['description'],
                 'edit_url' => 'config.php?display=customdests&type='.$type.'&extdisplay='.urlencode($dest),
                );
  }
}

function customappsreg_check_extensions($exten=true) {
  global $active_modules;

  $extenlist = array();
  if (is_array($exten) && empty($exten)) {
    return $extenlist;
  }
  $sql = "SELECT custom_exten, description FROM custom_extensions ";
  if (is_array($exten)) {
    $sql .= "WHERE custom_exten in ('".implode("','",$exten)."')";
  }
  $results = sql($sql,"getAll",DB_FETCHMODE_ASSOC);

  $type = isset($active_modules['customappsreg']['type'])?$active_modules['customappsreg']['type']:'tool';

  foreach ($results as $result) {
    $thisexten = $result['custom_exten'];
    $extenlist[$thisexten]['description'] = _("Custom Extension: ").$result['description'];
    $extenlist[$thisexten]['status'] = 'INUSE';
    $extenlist[$thisexten]['edit_url'] = 'config.php?display=customextens&extdisplay='.urlencode($thisexten);
  }
  return $extenlist;
}

function customappsreg_customdests_list() {
  global $db;
  $sql = "SELECT custom_dest, description, notes FROM custom_destinations ORDER BY description";
  $results = $db->getAll($sql, DB_FETCHMODE_ASSOC);
  if(DB::IsError($results)) {
    die_freepbx($results->getMessage()."<br><br>Error selecting from custom_destinations"); 
  }
  return $results;
}

function customappsreg_customextens_list() {
  global $db;
  $sql = "SELECT custom_exten, description, notes FROM custom_extensions ORDER BY custom_exten";
  $results = $db->getAll($sql, DB_FETCHMODE_ASSOC);
  if(DB::IsError($results)) {
    die_freepbx($results->getMessage()."<br><br>Error selecting from custom_extensions"); 
  }
  return $results;
}

function customappsreg_customdests_get($custom_dest) {
  global $db;
  $sql = "SELECT custom_dest, description, notes FROM custom_destinations WHERE custom_dest = ".q($custom_dest);
  $row = $db->getRow($sql, DB_FETCHMODE_ASSOC);
  if(DB::IsError($row)) {
    die_freepbx($row->getMessage()."<br><br>Error selecting row from custom_destinations"); 
  }
  return $row;
}

function customappsreg_customextens_get($custom_exten) {
  global $db;
  $sql = "SELECT custom_exten, description, notes FROM custom_extensions WHERE custom_exten = ".q($custom_exten);
  $row = $db->getRow($sql, DB_FETCHMODE_ASSOC);
  if(DB::IsError($row)) {
    die_freepbx($row->getMessage()."<br><br>Error selecting row from custom_extensions"); 
  }
  return $row;
}

function customappsreg_customdests_add($custom_dest, $description, $notes) {
  global $db;

  if (!ereg("[^,]+,[^,]+,[^,]+",$custom_dest)) {
    echo "<script>javascript:alert('"._('Invalid Destination, must not be blank, must be formatted as: context,exten,pri')."')</script>";
    return false;
  }
  if (trim($description) == '') {
    echo "<script>javascript:alert('"._('Invalid description specified, must not be blank')."')</script>";
    return false;
  }
  $usage_list = framework_identify_destinations($custom_dest, $module_hash=false);
  if (!empty($usage_list[$custom_dest])) {
    echo "<script>javascript:alert('"._('DUPLICATE Destination: This destination is already in use')."')</script>";
    return false;
  }

  $custom_dest = sql_formattext($custom_dest);
  $description = sql_formattext($description);
  $notes       = sql_formattext($notes);
  $sql = "INSERT INTO custom_destinations (custom_dest, description, notes) VALUES ($custom_dest, $description, $notes)";
  $results = $db->query($sql);
  if (DB::IsError($results)) {
    if ($results->getCode() == DB_ERROR_ALREADY_EXISTS) {
      echo "<script>javascript:alert('"._('DUPLICATE Destination: This destination is in use or potentially used by another module')."')</script>";
      return false;
    } else {
      die_freepbx($results->getMessage()."<br><br>".$sql);
    }
  }
  return true;
}

function customappsreg_customextens_add($custom_exten, $description, $notes) {
  global $db;

  if ($custom_exten == '') {
    echo "<script>javascript:alert('"._('Invalid Extension, must not be blank')."')</script>";
    return false;
  }
  if (trim($description) == '') {
    echo "<script>javascript:alert('"._('Invalid description specified, must not be blank')."')</script>";
    return false;
  }

  $custom_exten = sql_formattext($custom_exten);
  $description  = sql_formattext($description);
  $notes        = sql_formattext($notes);
  $sql = "INSERT INTO custom_extensions (custom_exten, description, notes) VALUES ($custom_exten, $description, $notes)";
  $results = $db->query($sql);
  if (DB::IsError($results)) {
    if ($results->getCode() == DB_ERROR_ALREADY_EXISTS) {
      echo "<script>javascript:alert('"._('DUPLICATE Extension: This extension already in use')."')</script>";
      return false;
    } else {
      die_freepbx($results->getMessage()."<br><br>".$sql);
    }
  }
  return true;
}

function customappsreg_customdests_delete($custom_dest) {
  global $db;

  $sql = "DELETE FROM custom_destinations WHERE custom_dest = ".q($custom_dest);
  $result = $db->query($sql);
  if(DB::IsError($result)) {
    die_freepbx($result->getMessage().$sql);
  }
}

function customappsreg_customextens_delete($custom_exten) {
  global $db;

  $sql = "DELETE FROM custom_extensions WHERE custom_exten = ".q($custom_exten);
  $result = $db->query($sql);
  if(DB::IsError($result)) {
    die_freepbx($result->getMessage().$sql);
  }
}

function customappsreg_customdests_edit($old_custom_dest, $custom_dest,  $description, $notes) { 
  global $db;

  if ($old_custom_dest != $custom_dest) {
    $usage_list = framework_identify_destinations($custom_dest, $module_hash=false);
    if (!empty($usage_list[$custom_dest])) {
      echo "<script>javascript:alert('"._('DUPLICATE Destination: This destination is in use or potentially used by another module')."')</script>";
      return false;
    }
  }

  $sql = "UPDATE custom_destinations SET ".
    "custom_dest = ".sql_formattext($custom_dest).", ".
    "description = ".sql_formattext($description).", ".
    "notes = ".sql_formattext($notes)." ".
    "WHERE custom_dest = ".sql_formattext($old_custom_dest);
  $result = $db->query($sql);
  if(DB::IsError($result)) {
    die_freepbx($result->getMessage().$sql);
  }
}

function customappsreg_customextens_edit($old_custom_exten, $custom_exten,  $description, $notes) { 
  global $db;

  $sql = "UPDATE custom_extensions SET ".
    "custom_exten = ".sql_formattext($custom_exten).", ".
    "description = ".sql_formattext($description).", ".
    "notes = ".sql_formattext($notes)." ".
    "WHERE custom_exten = ".sql_formattext($old_custom_exten);
  $result = $db->query($sql);
  if(DB::IsError($result)) {
    die_freepbx($result->getMessage().$sql);
  }
}

function customappsreg_customdests_getunknown() {

  $results = array();

  $my_probs = framework_list_problem_destinations($my_hash, false);

  if (!empty($my_probs)) {
    foreach ($my_probs as $problem) {
      if ($problem['status'] == 'CUSTOM') {
        $results[] = $problem['dest'];
      }
    }
  }
  return array_unique($results);
}

?>