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

<?php
 /* $Id: functions.inc.php 4024 2007-06-09 03:09:16Z p_lindheimer $ */

// Class To Create, Access and Change DAYNIGHT objects in the dialplan
//
class dayNightObject {

  var $id;

  // contstructor
  function dayNightObject($item) {
    $this->id = $item;
  }
    
  function getState() {
    global $astman;

    if ($astman != null) {
      $mode = $astman->database_get("DAYNIGHT","C".$this->id);
      if ($mode != "DAY" && $mode != "NIGHT") {
        // TODO: should this return an error?
        return false;
      } else {
        return $mode;
      }
    } else {
      die_freepbx("No open connection to asterisk manager, can not access object.");
    }
  }

  function setState($state) {
    global $astman;

    if ($this->getState() === false) {
      die_freepbx("You must create the object before setting the state.");
      return false;
    } else {
      switch ($state) {
        case "DAY":
        case "NIGHT":
          if ($astman != null) {
            $astman->database_put("DAYNIGHT","C".$this->id,$state);
          } else {
            die_freepbx("No open connection to asterisk manager, can not access object.");
          }
          break;
        default:
          die_freepbx("Invalid state: $state");
          break;
      }
    }
  }

  function create($state="DAY") {
    global $astman;

    $current_state = $this->getState();
    if ($current_state !== false) {
      die_freepbx("Object already exists and is in state: $current_state, you must delete it first");
      return false;
    } else {
      switch ($state) {
        case "DAY":
        case "NIGHT":
          if ($astman != null) {
            $astman->database_put("DAYNIGHT","C".$this->id,$state);
          } else {
            die_freepbx("No open connection to asterisk manager, can not access object.");
          }
          break;
        default:
          die_freepbx("Invalid state: $state");
          break;
      }
    }
  }

  function del() {
    global $astman;

    if ($astman != null) {
      $astman->database_del("DAYNIGHT","C".$this->id);
    } else {
      die_freepbx("No open connection to asterisk manager, can not access object.");
    }
  }
}

// The destinations this module provides
// returns a associative arrays with keys 'destination' and 'description'
function daynight_destinations() {

  $list = daynight_list();
  foreach ($list as $item) {
    $dests = daynight_get_obj($item['ext']);
    if (!isset($dests['day']) || !isset($dests['night'])) {
      continue;
    }
    $description = $item['dest'] != ""?$item['dest']:"Day/Night Switch";
    $description = "(".$item['ext'].") ".$description;
    $extens[] = array('destination' => 'app-daynight,'.$item['ext'].',1', 'description' => $description);
  }

  // return an associative array with destination and description
  if (isset($extens)) 
    return $extens;
  else
    return null;
}

function daynight_getdest($exten) {
  return array('app-daynight,'.$exten.',1');
}

function daynight_getdestinfo($dest) {
  global $active_modules;

  if (substr(trim($dest),0,13) == 'app-daynight,') {
    $exten = explode(',',$dest);
    $exten = $exten[1];

    $thisexten = array();
    $thislist = daynight_list($exten);
    foreach ($thislist as $item) {
      if ($item['ext'] == $exten) {
        $thisexten = $item;
        break;
      }
    }
    if (empty($thisexten)) {
      return array();
    } else {
      //$type = isset($active_modules['announcement']['type'])?$active_modules['announcement']['type']:'setup';
      return array('description' => 'Day/Night ('.$exten.') : '.$thisexten['dest'],
                   'edit_url' => 'config.php?display=daynight&itemid='.urlencode($exten).'&action=edit',
                  );
    }
  } else {
    return false;
  }
}

function daynight_get_config($engine) {
  global $ext;

  switch($engine) {
    case "asterisk":

      $id = "app-daynight"; // The context to be included
      $ext->addInclude('from-internal-additional', $id); // Add the include from from-internal

      $list = daynight_list();

      foreach ($list as $item) {
        $dests = daynight_get_obj($item['ext']);
        $ext->add($id, $item['ext'], '', new ext_gotoif('$["${DB(DAYNIGHT/C${EXTEN})}" = "NIGHT"]',$dests['night'],$dests['day']));
      }

      daynight_toggle();

      break;
  }
}

function daynight_toggle() {
  global $ext;

  $fcc = new featurecode('daynight', 'toggle-mode');
  $c = $fcc->getCodeActive();
  unset($fcc);

  if (!empty($c)) {
    $id = "app-daynight-toggle"; // The context to be included

    $ext->addInclude('from-internal-additional', $id); // Add the include from from-internal

    $list = daynight_list();
    $passwords = daynight_passwords();
    foreach ($list as $item) {
      $index = $item['ext'];
      $ext->add($id, $c.$index, '', new ext_answer(''));
      $ext->add($id, $c.$index, '', new ext_wait('1'));

      if (isset($passwords[$index]) && trim($passwords[$index]) != "" && ctype_digit(trim($passwords[$index]))) {
        $ext->add($id, $c.$index, '', new ext_authenticate($passwords[$index]));
      }
      $ext->add($id, $c.$index, '', new ext_setvar('INDEX', $index)); 
      $ext->add($id, $c.$index, '', new ext_goto($id.',s,1'));
    }

    $c='s';
    $ext->add($id, $c, '', new ext_setvar('DAYNIGHTMODE', '${DB(DAYNIGHT/C${INDEX})}'));  
    $ext->add($id, $c, '', new ext_gotoif('$["${DAYNIGHTMODE}" = "NIGHT"]', 'day', 'night'));

    $ext->add($id, $c, 'day', new ext_setvar('DB(DAYNIGHT/C${INDEX})', 'DAY')); 
    $ext->add($id, $c, '', new ext_playback('beep&silence/1&day&reception&digits/${INDEX}&enabled'));
    $ext->add($id, $c, '', new ext_hangup(''));

    $ext->add($id, $c, 'night', new ext_setvar('DB(DAYNIGHT/C${INDEX})', 'NIGHT')); 
    $ext->add($id, $c, '', new ext_playback('beep&silence/1&beep&silence/1&day&reception&digits/${INDEX}&disabled'));
    $ext->add($id, $c, '', new ext_hangup(''));
  }
}

function daynight_get_avail() {
  global $db;

  $sql = "SELECT ext FROM daynight ORDER BY ext";
  $results = $db->getCol($sql);
  if(DB::IsError($results)) {
    $results = array();
  }

  for ($i=0;$i<=9;$i++) {
    if (!in_array($i,$results)) {
      $list[]=$i;
    }
  }
  return $list;
}

//get the existing daynight codes
function daynight_list() {
  $results = sql("SELECT ext, dest FROM daynight WHERE dmode = 'fc_description' ORDER BY ext","getAll",DB_FETCHMODE_ASSOC);
  if(is_array($results)){
    foreach($results as $result){
      $list[] = $result;
    }
  }
  if (isset($list)) {
    return $list;
  } else { 
    return array();
  }
}

//get the existing password codes
function daynight_passwords() {
  $results = sql("SELECT ext, dest FROM daynight WHERE dmode = 'password'","getAll",DB_FETCHMODE_ASSOC);
  if(is_array($results)){
    foreach($results as $result){
      $list[$result['ext']] = $result['dest'];
    }
  }
  if (isset($list)) {
    return $list;
  } else { 
    return array();
  }
}

function daynight_edit($post, $id=0) {

  // TODO: Probably have separate add and edit (and change in page.daynight.php also)
  //       Need to set the day/night mode in the system if new

  // Delete all the old dests
  sql("DELETE FROM daynight WHERE dmode IN ('day', 'night', 'password', 'fc_description') AND ext = '$id'");

  $day   = isset($post[$post['goto0'].'0'])?$post[$post['goto0'].'0']:'';
  $night = isset($post[$post['goto1'].'1'])?$post[$post['goto1'].'1']:'';

  sql("INSERT INTO daynight (ext, dmode, dest) VALUES ('$id', 'day', '$day')");
  sql("INSERT INTO daynight (ext, dmode, dest) VALUES ('$id', 'night', '$night')");

  if (isset($post['password']) && trim($post['password'] != "")) {
    $password = trim($post['password']);
    sql("INSERT INTO daynight (ext, dmode, dest) VALUES ('$id', 'password', '$password')");
  }
  $fc_description = isset($post['fc_description']) ? trim($post['fc_description']) : "";
  sql("INSERT INTO daynight (ext, dmode, dest) VALUES ('$id', 'fc_description', '$fc_description')");

  $dn = new dayNightObject($id);
  $dn->del();
  $dn->create($post['state']);

  needreload();
}

function daynight_del($id){

  // TODO: delete ASTDB entry when deleting the mode
  //
  $results = sql("DELETE FROM daynight WHERE ext = \"$id\"","query");

  $dn = new dayNightObject($id);
  $dn->del();
  unset($dn); 
}

function daynight_get_obj($id=0) {
  global $db;

  $sql = "SELECT dmode, dest FROM daynight WHERE dmode IN ('day', 'night', 'password', 'fc_description') AND ext = '$id' ORDER BY dmode";
  $res = $db->getAll($sql, DB_FETCHMODE_ASSOC);
  if(DB::IsError($res)) {
    return null;
  }
    foreach($res as $pair) {
      $dmodes[$pair['dmode']] = $pair['dest'];
    }
    $dn = new dayNightObject($id);
    $dmodes['state'] = $dn->getState();

    return $dmodes;
}


/*
SELECT s1.ext ext, dest, dmode, s2.description descirption FROM daynight s1 
INNER JOIN
    (
            SELECT ext, dest description FROM daynight WHERE dmode = 'fc_description') s2 
            ON s1.ext = s2.ext WHERE dmode in ('day','night')
            AND dest = '$dest'

Provides: ext, dest, dmode, description
*/
function daynight_check_destinations($dest=true) {
  global $active_modules;

  $destlist = array();
  if (is_array($dest) && empty($dest)) {
    return $destlist;
  }
  $sql = "
    SELECT s1.ext ext, dest, dmode, s2.description description FROM daynight s1 
    INNER JOIN
        (
          SELECT ext, dest description FROM daynight WHERE dmode = 'fc_description') s2 
          ON s1.ext = s2.ext WHERE dmode in ('day','night') 
    ";
  if ($dest !== true) {
    $sql .= "AND dest in ('".implode("','",$dest)."')";
  }
  $results = sql($sql,"getAll",DB_FETCHMODE_ASSOC);

  //$type = isset($active_modules['announcement']['type'])?$active_modules['announcement']['type']:'setup';

  foreach ($results as $result) {
    $thisdest = $result['dest'];
    $thisid   = $result['ext'];
    $destlist[] = array(
      'dest' => $thisdest,
      'description' => 'Daynight: '.$result['description'].' ('.$result['dmode'].')',
      'edit_url' => 'config.php?display=daynight&itemid='.urlencode($thisid).'&action=edit',
    );
  }
  return $destlist;
}
?>