<?php

/*
 * ****************************************************************************************
 * Copyright (c) 2013, 2014 Christopher W. Olsen <cwolsen@ubixtechnologies.com>
 * All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without modification, are
 * permitted provided that the following conditions are met:
 *
 * Redistributions of source code must retain the above copyright notice, this list of
 * conditions, the following disclaimer and the list of authors. Redistributions in binary
 * form must reproduce the above copyright notice, this list of conditions, the following
 * disclaimer and the list of authors in the documentation and/or other materials provided
 * with the distribution. Neither the name of the uBix Cube Project nor the names of its
 * contributors may be used to endorse or promote products derived from this software
 * without specific prior written permission.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY
 * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
 * MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL
 * THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT
 * OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
 * HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR
 * TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
 * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * $Id: extension_json.php 943 2017-09-07 20:16:43Z reddawg $
 *
 * ***************************************************************************************
 */

/* Main include info */
ini_set ( 'include_path', $_SERVER ['DOCUMENT_ROOT'] . "/include/" );
include ("config.php");

$ubF->session->Validate_JSON ( 'A_V_', 0 );

if (! isset ( $form_data ['req'] ))
  $form_data ['req'] = - 1;

$rData ['authenticated'] = $ubF->session->auth_data ['authenticated'];

$recOpt = Array (
  'None',
  'Outbound',
  'Inbound',
  'In & Out' 
);

switch ($form_data ['req']) {
  case 'extension_list' :

    /* START: Get Extension List */
    if (isset ( $form_data ['account_code'] ) && ($form_data ['account_code'] != ''))
      $query = "SELECT name,accountcode,callerid,mailbox,ext_recording,ext_active FROM sippeers WHERE accountcode = '" . $form_data ['account_code'] . "' ORDER BY name";
    else
      $query = "SELECT name,accountcode,callerid,mailbox,ext_recording,ext_active FROM sippeers ORDER BY name";
    
    $result = $ubF->DB ['voip']->query ( $query );
    
    if ($result->num_rows == 0)
      $rData ['data'] = null;
    else {
      
      while ( $qData = $result->fetch_assoc () ) {
        $ext = substr ( $qData ['name'], strlen ( $qData ['accountcode'] ) );
        
        $rData ['data'] [] = array (
          "<a class=\"edit_extension\" id=\"" . $qData ['name'] . "\">" . $ext . "</a>",
          $qData ['accountcode'],
          $qData ['callerid'],
          explode('@', $qData ['mailbox'])[0],
          $recOpt [$qData ['ext_recording']],
          ($qData['ext_active'] == 0)? 'Disabled': 'Active',
          "<input type=\"submit\" name=\"data[del][" . $qData ['name'] . "]\" value=\"Delete\" onClick=\"return dV('" . $qData ['name'] . "');\">",
          "<a href=\"#\" onClick=\"openVoIP('" . $qData ['name'] . "');\">Launch</a>" 
        );
      }
    }
    
    /* END: Get Extension List */
    break;
  case 'mailbox_list' :
    $rData ['data'] = $data->libs ['voip']->getMailboxes ( $form_data ['account_code'] );
    break;
  case 'recording_options' :
    foreach ( $recOpt as $key => $val ) {
      $rData ['data'] [] = Array (
        'label' => $val,
        'id' => $key 
      );
    }
    break;
  case 'extension_info' :
    $query = "SELECT * FROM sippeers WHERE name = '" . $form_data ['ext'] . "'";
    $result = $ubF->DB ['voip']->query ( $query );
    $rData ['data'] = $result->fetch_assoc ();
    $result->free ();
    break;
  case 'extension_edit' :
    $cid = $form_data ['callerid_name'] . " <" . $form_data ['callerid_number'] . ">";
    $query = "UPDATE sippeers SET secret = '" . $form_data ['secret'] . "', callerid = '" . $cid . "', mailbox = '" . $form_data ['mailbox'] . "', ext_recording = " . $form_data['ext_recording'] . ", ext_active = " . $form_data['ext_active'] . " WHERE name = '" . $form_data ['ext'] . "'";
    if ($ubF->DB ['voip']->query ( $query ) == true) {
      $rData ['data'] = Array (
        'ret' => 1,
        'ret_string' => 'Extension Updated' 
      );
    }
    else {
      $rData ['data'] = Array (
        'ret' => 0,
        'ret_string' => 'Extension Failed To Update' 
      );
    }
    break;
  case 'extension_existing' :
    
    $erows = "";
    
    $query = "SELECT name, callerid FROM sippeers WHERE accountcode = '" . $form_data ['account_code'] . "' ORDER BY name";
    $result = $ubF->DB ['voip']->query ( $query );
    $offset = strlen($form_data['account_code']);
    while ( $qData = $result->fetch_row () ) {
      $erows .= "<tr><td>" . substr($qData [0], $offset) . "</td><td>" . $qData [1] . "</td></tr>\n";
    }
    
    $result->free ();
    
    $rData ['data'] = $erows;
    break;
  default :
    $rData ['data'] = Array (
      0 
    );
    break;
}

print json_encode ( $rData );

?>