<?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: rate_decks_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'];

switch ($form_data ['req']) {
  case 'rate_deck_list' :
    /* Get List Of Groups */
    if (! isset ( $form_data ['account_number'] ) || $form_data ['account_number'] == "")
      $query = "SELECT c.name as carrier,r.ratedeck_id,r.name,r.notes FROM rate_decks r LEFT JOIN carriers c ON r.carrier_id=c.carrier_id ORDER BY c.name,r.name";
    else
      $query = "SELECT c.name as carrier,r.ratedeck_id,r.name,r.notes FROM rate_decks r LEFT JOIN carriers c ON r.carrier_id=c.carrier_id ORDER BY c.name,r.name WHERE carrier_id = '" . $form_data ['account_number'] . "' ORDER BY gid";
    
    $result = $ubF->DB ['main']->query ( $query );
    
    while ( $qData = $result->fetch_assoc () ) {
      
      $rData [] = array (
          '<a class="edit_rate_deck" id="' . $qData ['ratedeck_id'] . '">' . $qData ['ratedeck_id'] . '</a>',
          $qData ['carrier'],
          $qData ['name'],
          $qData ['notes'] 
      );
    }
    
    break;
  case 'rate_deck_data':
    $query = "SELECT prefix,inter,intra FROM rate_deck_data WHERE ratedeckdata_id = " . $form_data['rdd'] . " ORDER BY prefix";
    $result = $ubF->DB['main']->query($query);

    while ($qData = $result->fetch_row()) {
      $rData[] = $qData;
    }
    break;
  case 'load_rate_deck':
    $rData = array('result' => "File: " . json_encode($_FILES) .  basename($_FILES['data_file']['name']),'rc' => 0);
    exec("echo 'TEST' >> /tmp/Portal.log");
    break;
  case 'group_info' :
    $query = "SELECT * FROM vi_groups WHERE gid = " . $form_data ['gid'];
    $result = $ubF->DB ['main']->query ( $query );
    $rData = $result->fetch_assoc ();
    $result->free ();
    break;
  case 'group_update' :
    $query = "UPDATE vi_groups SET account_number = '" . $form_data ['account_number'] . "', name = '" . $form_data ['name'] . "', notes = '" . $form_data ['notes'] . "' WHERE gid = " . $form_data ['gid'];
    $result = $ubF->DB ['main']->query ( $query );
    
    if ($result) {
      $rData = array (
          'result' => "Updated",
          'rc' => 1 
      );
    }
    else {
      $rData = array (
          'result' => "Failed",
          'rc' => 0 
      );
    }
    
    break;
  default :
    $rData ['data'] = Array (
        0 
    );
    break;
}

$ubF->json_return ( 1, 'Success', $rData );

?>