<?php

/*
 * ****************************************************************************************
 * Copyright (c) 2013, 2014, 2015, 2016 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: did_json.php 931 2017-09-07 19:18:33Z reddawg $
 *
 * ***************************************************************************************
 */

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

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

if ( !isset ( $form_data ['dtype'] ) )
  $form_data ['dtype'] = 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 'did_list' :
    $qFields = "vdid_id, account_number, did, network, recording, cnam_dip, cnam, e911, e411, t38, vfax, sms";
    
    if ( isset ( $form_data ['account_number'] ) && $form_data ['account_number'] != "" )
      $query = "SELECT " . $qFields . " type = " . $form_data ['dtype'] . " AND account_number = '" . $form_data ['account_number'] . "' ORDER BY did";
    else
      $query = "SELECT " . $qFields . " FROM voip_did WHERE type = " . $form_data ['dtype'] . " ORDER BY did";
    
    $result = $ubF->DB ['main']->query ( $query );
    
    if ( $result !== false && $result->num_rows > 0 ) {
      while ( $qData = $result->fetch_assoc () ) {
        
        $rows [] = array (
          '<a class="edit_did" id="' . $qData ['did'] . ':' . $qData ['account_number'] . '">' . $qData ['did'] . '</a>',
          $qData ['account_number'],
          $qData ['network'],
          ($qData ['recording'] == 1) ? 'Y' : 'N',
          ($qData ['cnam_dip'] == 1) ? 'Y' : 'N',
          ($qData ['cnam'] == 1) ? 'Y' : 'N',
          ($qData ['e911'] == 1) ? 'Y' : 'N',
          ($qData ['e411'] == 1) ? 'Y' : 'N',
          ($qData ['t38'] == 1) ? 'Y' : 'N',
          ($qData ['vfax'] == 1) ? 'Y' : 'N',
          ($qData ['sms'] == 1) ? 'Y' : 'N' 
        );
      }
      $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;
}

?>