ivr_mntc_msg.data

<?php

  /*
   * ivr_mntc_msg.data
   *
   * Data scripts for CRUD operations needed for ivr_mntc_msg
   *
   */


  // ** Include these scripts, mostly to ensure that the Monitor security is maintained

$monLibrary= dirname(__FILE__) . "/../library";
require_once("$monLibrary/cu_top.i");
require_once("$monLibrary/ck_hticket.i");

  // ** Use the permmissions from the main script siteSettings
  if (!CheckPerm($link, $Hu, 'ivr_mntc_msg', $_SERVER['REMOTE_ADDR'])) {
    // ** Permissions failed
    // ** redirect to new page
    header("Location: /hcuadm/hcu_noperm.prg");
    exit;
  }



  /* Expecting the following fields
   * action - The action to be taken
     *          new
     *          update
     *          read
     *          delete
   * loadSettings - This will determine which directory the settings will be saved
   *                - The options are
   *                production - saved to the production directory
   *                preview - saved to the preview directory
   *                savetoproduction - the preview hcuSettings.i will be copied to the production directory
   * langSelect - Languages selected for Home Banking
   * postMenuOptions - This will be a JSON string of the array for the full menu
   * postScriptProxy - This will be a JSON string of the array for the script proxies being used
   * postContentTheme - A string of the content theme that is selected
   * postLogout - A JSON string containing the name to put at the footer and an http link to go to when any logout clicked
   */

  $HB_ENV = Array();
  $dms_ok = Array('action' => 'string', 'msg_code' => 'string', 'msg_desc' => 'string',
                  'msg_filename' => 'string', 'msg_level' => 'string');

  dms_import_v2($HB_ENV, "HCUPOST", $dms_ok);

  $retStatus_ary = Array(
                       'homecuInfo' => '',
                       'homecuErrors' => Array(),
                       'homecuData' => ''
                       );


  try {
    $returnMsgData = Array();
    switch ($HB_ENV['HCUPOST']['action']) {
      case 'read':
        $sql = "SELECT trim(msg_code) as msg_code,
                       trim(msg_desc) as msg_desc,
                       trim(msg_filename) as msg_filename,
                       msg_level
                FROM ars_audio_message
                ORDER BY msg_code ";
        $sqlRs = db_query($sql, $link);
        $sIdx = 0;
        while ($msgRecord = db_fetch_assoc($sqlRs, $sIdx)) {
          $returnMsgData[] = $msgRecord;
          $sIdx++;
        }

        $retStatus_ary['homecuData'] = $returnMsgData;
        break;
      case 'new':
      case 'update':
        /*
         * Validate the data coming in
         */
        // ** The msg_code must not be used already
        $sql = "SELECT count(*) as count_msg
                FROM ars_audio_message
                WHERE msg_code = '" . prep_save($HB_ENV['HCUPOST']['msg_code'], 3) . "' ";
        $cntRs = db_query($sql, $link);
        list($recordCount) = db_fetch_array($cntRs);
        if ($HB_ENV['HCUPOST']['action'] == 'new') {
          // ** NEW
          if ($recordCount > 0) {
            throw new Exception('Message code must be unique.');
          }
        } else {
          // ** UPDATE - MUST EXIST **
          if ($recordCount == 0) {
            throw new Exception('Message code was not found.');
          }
        }


        // ** All fields entered
        if ($HB_ENV['HCUPOST']['msg_code'] == '' ||
            $HB_ENV['HCUPOST']['msg_desc'] == '' ||
            $HB_ENV['HCUPOST']['msg_filename'] == '') {
          throw new Exception('All fields must be entered to continue.');
        }

        // ** the msg_level must be in {1, 2, 3}
        if (!in_array($HB_ENV['HCUPOST']['msg_level'], array('1', '2', '3'))) {
        $retStatus_ary['homecuInfo'][] = $HB_ENV['HCUPOST'];
        $retStatus_ary['homecuInfo'][] = $HB_ENV['HCUPOST']['msg_level'];
        $retStatus_ary['homecuInfo'][] = array('1', '2', '3');
          throw new Exception('Message level was not valid.');
        }


        if ($HB_ENV['HCUPOST']['action'] == 'new') {
          $sql = "INSERT INTO ars_audio_message
                  (msg_code, msg_desc, msg_filename, msg_level)
                  VALUES
                  ('" . prep_save($HB_ENV['HCUPOST']['msg_code'], 3) . "',
                   '" . prep_save($HB_ENV['HCUPOST']['msg_desc'], 50) . "',
                   '" . prep_save($HB_ENV['HCUPOST']['msg_filename'], 20) . "',
                   '" . intval($HB_ENV['HCUPOST']['msg_level']) . "') ";

        } else {
          $sql = "UPDATE ars_audio_message
                  SET msg_desc = '" . prep_save($HB_ENV['HCUPOST']['msg_desc'], 50) . "',
                      msg_filename = '" . prep_save($HB_ENV['HCUPOST']['msg_filename'], 20) . "',
                      msg_level = '" . intval($HB_ENV['HCUPOST']['msg_level']) . "'
                  WHERE msg_code = '" . prep_save($HB_ENV['HCUPOST']['msg_code'], 3) . "' ";
        }
        $updRs = db_query($sql, $link);
        if (!$updRs) {
          // ** FAILED
          throw new Exception('A problem occurred saving your changes.');
        } else {
          // ** SUCCESS
          $retStatus_ary['homecuInfo'][] = "Change was successfully saved.";
        }
        break;
      case 'delete':
        $sql = "SELECT count(*) as count_msg
                FROM ars_audio_message
                WHERE msg_code = '" . prep_save($HB_ENV['HCUPOST']['msg_code'], 3) . "' ";
        $cntRs = db_query($sql, $link);
        list($recordCount) = db_fetch_array($cntRs);
        // ** UPDATE - MUST EXIST **
        if ($recordCount == 0) {
          throw new Exception('Message code was not found.');
        }

        $sql = "DELETE FROM ars_audio_message
                WHERE msg_code = '" . prep_save($HB_ENV['HCUPOST']['msg_code'], 3) . "' ";

        $updRs = db_query($sql, $link);
        if (!$updRs) {
          // ** FAILED
          throw new Exception('A problem occurred saving your changes.');
        } else {
          // ** SUCCESS
          $retStatus_ary['homecuInfo'][] = "Change was successfully saved.";
        }

        break;
      default:
        throw new Exception('Invalid parameter setting.  Action cancelled.');

        break;
    }

  } catch (Exception $ex) {
    $retStatus_ary['homecuErrors'][] = "Unexpected error while saving.  <br/>" . $ex->getMessage();
  }
  // ** Prepare the package for returning
  header('Content-type: application/json');

  print json_encode(Array("Results" => Array($retStatus_ary)));