<?php

/*
 * ****************************************************************************************
 * Copyright (c) 2016 Christopher W. Olsen <cwolsen@uBixStudios.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: did_json.php 201 2015-12-06 00:52:48Z reddawg $
 *
 * ***************************************************************************************
 */

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

$ubF->libs ['session']->Validate_JSON ( 'U_V_', 1 );

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

switch ( $form_data ['req'] ) {
  case 'did_update' :
    $query = "UPDATE voip_did SET account_number = '" . $form_data ['account_number'] . "', caller_id = '" . $form_data ['cid_out'] . "', exten = '" . $form_data ['dst_dialplan'] . "', rec_in = " . $form_data ['rec_calls'] . ", modified = 1 WHERE did = '" . $form_data ['did'] . "'";
    if ( $ubF->DB ['main']->query ( $query ) )
      $ubF->json_return ( 1, 'Success', $query );
    else
      $ubF->json_return ( 0, 'Error Saving Changes' );
    
    break;
  case 'dial_plan_list' :
    $query = "SELECT vdp_id, label, description, did FROM voip_dialplan WHERE account_number = '" . $ubF->session->account_number . "' ORDER BY label";
    
    $result = $ubF->DB ['main']->query ( $query );
    
    if ( $result !== false && $result->num_rows > 0 ) {
      while ( $qData = $result->fetch_assoc () ) {
        $rows [] = array (
          '<a class="edit_dial_plan" id="' . $qData ['vdp_id'] . '">' . $qData ['label'] . '</a>',
          $qData ['description'],
          $qData ['did'] 
        );
      }
      $result->free ();
    }
    else {
      $rows [] = 0;
    }
    $ubF->json_return ( 1, 'Success', $rows );
    break;
  case 'did_info' :
    $query = "SELECT * FROM voip_did WHERE did = '" . $form_data ['did'] . "'";
    $result = $ubF->DB ['main']->query ( $query );
    
    if ( $result !== false && $result->num_rows > 0 ) {
      $qData = $result->fetch_assoc ();
      $result->free ();
      
      $ubF->json_return ( 1, 'Success', $qData );
    }
    break;
  default :
    $ubF->json_return ( 0, "Invalid Command" );
    break;
}

?>