hcuUserActivity.data

<?php
  /**
   * @package hcuUserActivity.data
   *
   * This gets the data for hcuUserActivity.prg in a json format.
   */

  // ** SET SCRIPT LEVEL VARIABLES
  $serviceShowInfo = false;
  $serviceLoadMenu = false;
  $serviceShowMenu = false;
  $serviceAllowReadonly = true;

  // ** INCLUDE MAIN GLOBAL SCRIPT -- Handles security / global variable values
  require_once(dirname(__FILE__) . '/../library/hcuService.i');

  // Include transfer scheduled to get interval lookup.
  require_once(dirname(__FILE__) . '/../library/hcuTransferScheduled.i');
  require_once(dirname(__FILE__) . '/../library/hcuTransfer.i');
  require_once(dirname(__FILE__) . "/../library/hcuUserActivity.i");
  require_once(dirname(__FILE__) . "/../../shared/library/hcuCommon.i");
  $logger = $HB_ENV["SYSENV"]["logger"];

  try {
    // *****************************************
    // Step 1: get the confirm permissions for the features that we care about.  If there are no confirm permissions and there are multiple users in the group, then throw an error.
    $confirmPermissions = array();
    $permissions = privPermGetAllFeatureRights($HB_ENV["dbh"], $HB_ENV, array("Uid" => $HB_ENV["Uid"]));
    if (!intval($permissions["status"]["code"]) == 0) {
      throw new exception($permissions["status"]["error"], 3);
    }
    $permissions = $permissions["data"][$HB_ENV["Uid"]];

    // Prevent the page from being accessible when the user doesn't have approve access to at least one feature.
    $approvalFeatureList = getApprovalList();
    $approvalFound = false;
    foreach($permissions as $featureCode => $featureRecord) {
      if (!in_array($featureCode, $approvalFeatureList)) {
        continue; // Feature is irrelevant to this script.
      }

      $approvalFound = $approvalFound || $featureRecord["confirm"];
      $confirmPermissions[$featureCode] = $featureRecord["confirm"]; // Save the permission for later.
    }

    if (!$approvalFound) {
      $Cu = $HB_ENV["Cu"];
      $Uid = $HB_ENV["Uid"];

      $sql = "select 'FOUND' from ${Cu}user a inner join ${Cu}user b on a.user_id = $Uid and a.group_id = b.group_id and a.user_id <> b.user_id";
      $sth = db_query($sql, $HB_ENV["dbh"]);
      if (!$sth) {
        throw new exception("Check if multiple users found.", 5);
      }
      if (db_num_rows($sth) > 0) { // We care if there are multiple users.  If it is one user, then user has the permissions to view the page.
        throw new exception("No approval permissions found.", 4);
      }
    }

    // *******************************************
    // Step 2: check to make sure that the right script is calling this script.  This will only be the hcuUserActivity.prg script.
    if (basename(parse_url($_SERVER['HTTP_REFERER'])["path"]) != "hcuUserActivity.prg") {
      throw new exception("redirect check failed.", 2);
    }

    // Step 3: get parameters from the request array
    $string = array("filter" => FILTER_SANITIZE_STRING);
    $parameters = array("a" => array("operation" => "", "grid" => "", "filterFeature" => "", "filterStatus" => "", "filterFrom" => "", "filterTo" => "", "type" => "", "dataId" => "",
      "status" => "", "kendoId" => ""));
    HCU_ImportVars($parameters, "a", array("operation" => $string, "grid" => $string, "filterFeature" => $string, "filterStatus" => $string, "filterFrom" => $string, "filterTo" => $string,
      "type" => $string, "dataId" => $string, "status" => $string, "kendoId" => $string));
    $operation = HCU_array_key_exists("operation", $parameters["a"]) ? trim($parameters["a"]["operation"]) : "";

    $genErr = str_replace(".", ":", $HB_ENV["MC"]->msg("ACH Query Error", HCU_DISPLAY_AS_RAW));

    // *************************************************
    // Step 3: Find out which data call to actually do and do it.
    $aryReply = array();
    switch($operation) {
      case "read":
        $aryReply = readActivityGrid($HB_ENV, $genErr, $parameters["a"], $confirmPermissions, "read");
        break;
      case "filter":
        $aryReply = readActivityGrid($HB_ENV, $genErr, $parameters["a"], $confirmPermissions, "filter");
        break;
      case "clearFilter":
        $aryReply = readActivityGrid($HB_ENV, $genErr, $parameters["a"], $confirmPermissions, "clearFilter");
        break;
      case "setStatus":
        $aryReply = setStatus($HB_ENV, $genErr, $parameters["a"], $confirmPermissions);
        break;
      case "local":
        $aryReply = array("results" => array("mode" => "local", "homecuErrors" => array(), "homecuInfo" => array()));
        break;
      case "skipTransaction":
        $aryReply = skipTransaction($HB_ENV, $genErr, $parameters["a"], $confirmPermissions);
        break;
      default: // Won't get here
          throw new exception("operation undefined", 1);
    }
  }
  catch(exception $e) {
      $logger->error($e->getCode() . ": " . $e->getMessage());

      // Put dictionary entries in one place to throw whatever I want.
      $err = "";
      switch($e->getCode()) {
        case 2:
        case 3:
        case 4:
        case 5:
          $err = $HB_ENV["MC"]->msg("Feature Unavailable", HCU_DISPLAY_AS_RAW);
          break;
        case 1:
        default:
          $err = $HB_ENV["MC"]->msg("ACH Unknown Action", HCU_DISPLAY_AS_RAW);
      }
      $aryReply = array("homecuErrors" => array($err), "homecuInfo" => array(), "homecuData" => array());
  }
  // End of global scope
  // **********************************************

  // Functions for data calls
  // ******************************************

  /**
   * function skipTransaction($HB_ENV, $genErr, $parameters, $confirmPermissions)
   * will skip the next scheduled trigger date for the transaction.
   * Available statuses:
   *  0 or null -- Awaiting approval
   *  10 -- Approved
   *  90 -- Declined
   *  99 -- Cancelled
   *
   * @param $HB_ENV -- the environment variables.  Contains the whole shebang.
   * @param $genErr -- the error that the banking client will show if things aren't exactly stellar.
   * @param $parameters -- from the $_REQUEST.  array("type" => $type, "dataId" => $dataId, "status" => $status)
   *  $type -- from what table originally.
   *  $dataId -- the id of the table originally.
   *  $status -- the status to change the status to.  See the available statuses.
   * @param $confirmPermissions -- array of the confirm permissions of the features.
   *
   * @return array("results" => array("homecuInfo" => $homecuInfo, "homecuErrors" => $errors, "homecuData" => $gridData, "sqls" => $sqls));
   *    $results -- contains the whole shebang
   *    $homecuInfo -- contains one or zero messages ("successfully declined" or whatnot)
   *    $gridData -- contains the data for the grid to requery.
   *    $sqls -- the SQLs used.
   */
  function skipTransaction($HB_ENV, $genErr, $parameters, $confirmPermissions) {
    // Extract the values that we need.  Discard the rest.
      $Cu = $HB_ENV["Cu"];
      $MC = $HB_ENV["MC"];
      $dbh = $HB_ENV["dbh"];
      $Uid = $HB_ENV["Uid"];
      $dataId = intval($parameters['dataId']);
      $kendoId = intval($parameters['kendoId']);

      try {
        $changeList = array($dataId);
        $changeList = HCU_JsonEncode($changeList);
        $txSkipSchedule = SkipTrans($dbh, $Cu, $Uid, $changeList, $MC);

        if ($txSkipSchedule['status'] !== "000") {
          throw new Exception($MC->msg("Skip Transaction Error", HCU_DISPLAY_AS_RAW), $txSkipSchedule['status']);
        }

        $parameters["grid"] = "scheduledTransactions";
        $readResults = readActivityGrid($HB_ENV, $genErr, $parameters, $confirmPermissions, "filter")["results"];

        if (count($readResults["homecuErrors"]) > 0) {
          throw new exception("filter failed.", 112);
        }
        $gridData = $readResults["homecuData"];

        $returnArray = array("results" => array("homecuInfo" => $MC->msg("Skip Transaction Success", HCU_DISPLAY_AS_RAW), "homecuErrors" => array(), "sqls" => "", "mode" => "skipTransaction", "dataId" => $dataId,"homecuData" => $gridData,"kendoId" => $kendoId));

      } catch (Exception $e) {
        $returnArray = array("results" => array("homecuInfo" => array(), "homecuErrors" => array($e->getMessage()), "sqls" => "", "mode" => "skipTransaction", "dataId" => $dataId));
      }

      return $returnArray;
  }

  /**
   * function setStatus($HB_ENV, $genErr, $parameters, $confirmPermissions)
   * Changes the status from awaiting approval to something else.  At this time, this is the only status that you can change.
   * Available statuses:
   *  0 or null -- Awaiting approval
   *  10 -- Approved
   *  90 -- Declined
   *  99 -- Cancelled
   *
   * @param $HB_ENV -- the environment variables.  Contains the whole shebang.
   * @param $genErr -- the error that the banking client will show if things aren't exactly stellar.
   * @param $parameters -- from the $_REQUEST.  array("type" => $type, "dataId" => $dataId, "status" => $status)
   *  $type -- from what table originally.
   *  $dataId -- the id of the table originally.
   *  $status -- the status to change the status to.  See the available statuses.
   * @param $confirmPermissions -- array of the confirm permissions of the features.
   *
   * @return array("results" => array("homecuInfo" => $homecuInfo, "homecuErrors" => $errors, "homecuData" => $gridData, "sqls" => $sqls));
   *    $results -- contains the whole shebang
   *    $homecuInfo -- contains one or zero messages ("successfully declined" or whatnot)
   *    $gridData -- contains the data for the grid to requery.
   *    $sqls -- the SQLs used.
   */
  function setStatus($HB_ENV, $genErr, $parameters, $confirmPermissions) {

      // Extract the values that we need.  Discard the rest.
      $Cu = $HB_ENV["Cu"];
      $MC = $HB_ENV["MC"];
      $Cn = $HB_ENV["Cn"];
      $dbh = $HB_ENV["dbh"];
      $Uid = $HB_ENV["Uid"];
      $logger = $HB_ENV["SYSENV"]["logger"];

      $sqls = array();
      try {
        extract($parameters);

        $type = isset($type) ? trim($type) : "";
        $dataId = isset($dataId) ? intval($dataId) : 0;
        $status = isset($status) ? intval($status) : 0;
        $isSendCheck = isset($isSendCheck) ? $isSendCheck == "true" : false;

        switch($type) {
          case "transhdr":
            $table = "${Cu}transhdr";
            break;
          case "scheduled":
            $table = "cu_scheduledtxn";
            break;
          default:
            throw new exception("Table type is unexpected.", 101);
        }

        if ($dataId <= 0) {
          throw new exception("DataId needs to be greater than zero.", 102);
        }

        $postedBy = $table == "cu_scheduledtxn" ? "user_id" : "posted_by";

        $sql = "select feature_code, $postedBy as posted_by, approved_status from $table where id = $dataId";
        $sqls[] = $sql;
        $sth = db_query($sql, $dbh);
        if (!$sth) {
          throw new exception("Select query failed.", 105);
        }
        if (db_num_rows($sth) == 0) {
          throw new exception("Record is not found.", 106);
        }
        $record = db_fetch_assoc($sth, 0);
        $record["approved_status"] = isset($record["approved_status"]) ? $record["approved_status"] : 0;

        if (!in_array($record["feature_code"], getApprovalList())) {
          throw new exception("Feature code doesn't need approval.", 109);
        }

        //if status is not approved and not editing from scheduled transactions grid
        if ($record["approved_status"] != 0 && $parameters["grid"] != 'scheduledTransactions') {
          throw new exception("At this time, approved status changes can only be from 'Awaiting Approval.'", 111);
        }

        switch($status) {
          case 10: // Approved
          case 90: // Declined
            if ($record["posted_by"] == $Uid) {
              throw new exception("Cannot approve or decline a record posted by yourself.", 108);
            }
            if (!$confirmPermissions[$record["feature_code"]]) {
              throw new exception("You cannot approve this record.", 110);
            }
            break;
          case 99: // Cancelled
            if ($record["posted_by"] != $Uid) {
              throw new exception("Cannot cancel a record posted by someone else.", 107);
            }
            break;
          default:
            throw new exception("Status is unexpected.", 103);
        }

        $transferData = null;
        $repeatData = null;
        $aryApprovalResults = array();

        if (!db_work ($dbh, HOMECU_WORK_BEGIN)) {
          throw new exception("begin query failed.", 112);
        }

        if ($status == 10 && $type == "transhdr"
        && in_array(trim($record["feature_code"]), array(FEATURE_TRANSFERS, FEATURE_M2M_TRANSFERS))) { // If a regular transaction is approved, try to post it to the core.

          if (!ApproveTransfer($dbh, $HB_ENV, $MC, $dataId, $aryApprovalResults)) {
            throw new exception($aryApprovalResults["status"]["errors"][0], 203);
          }

          $HB_ENV["confirmationCode"] = $aryApprovalResults["status"]["confirm"];

          $transactionResults = array();
          if (!ProcessTransfer($dbh, $HB_ENV, $MC, $dataId, $transactionResults, true)) {
            // since there was an error posting to the core, we revert approval
            // and commit only the cucorerequest record
            RevertMarkAsApproved($dataId, $dbh, $Cu, 202);
            // throw exception regardless of the RevertMarkAsApproved function
            // would throw sql execution failure exception or not as we do not
            // want to execute the code logic for successful transfer below
            throw new exception($transactionResults["status"]["errors"][0], 202);
          }

            // ** Successful transfer -- Need to return information..

            // Return the information to display to the user. Use the Posted date and confirmation regardless if needed confirmation or not.
            $transferData = array(
              array("label" => $MC->msg('Date', HCU_DISPLAY_AS_RAW), 'caption' => $transactionResults["txn"]["data_date"]),
              array("label" => $MC->msg('Action', HCU_DISPLAY_AS_RAW), 'caption' => $transactionResults["txn"]["data_action"]),
              array("label" => $MC->msg('From', HCU_DISPLAY_AS_RAW), 'caption' => $transactionResults["txn"]["data_from"]),
              array("label" => $MC->msg('To', HCU_DISPLAY_AS_RAW), 'caption' => $transactionResults["txn"]["data_to"]),
              array("label" => $MC->msg('Amount', HCU_DISPLAY_AS_RAW), 'caption' => "$" . mobile_formatnumber($transactionResults["txn"]["data_amount"]), ","),
              array("label" => $MC->msg('Confirmation', HCU_DISPLAY_AS_RAW), 'caption' => $transactionResults["txn"]["data_confirm"])
            );

            $message = $MC->msg("record approved", HCU_DISPLAY_AS_RAW);
        } else if ($type == "scheduled") {

            $sql = "update cu_scheduledtxn set approved_by = " . intval($Uid) . ", approved_date = now(), approved_status = " . intval($status) . "
                    where id = " . intval($dataId) . " and cu = '" . prep_save(strtoupper($Cu), 10) . "'";
            $sth = db_query($sql, $dbh);
            if (!$sth) {
              throw new exception ("Update query failed.", 207);
            }

            $repeatData = $MC->msg('Repeating transfer scheduled', HCU_DISPLAY_AS_RAW) . ".";
        } else if ($type == "transhdr") { // Cancel, decline transaction

          $sql = "update ${Cu}transhdr set approved_by = '" . intval($Uid) . "', approved_date = now(), approved_status = " . intval($status) . "
                  where id = " . intval($dataId);
          $sth = db_query($sql, $dbh);
          if (!$sth) {
            throw new exception ("Update query failed.", 208);
          }
        }

        $status = $status == 10 ? "approved" : ($status == 99 ? "cancelled" : ($status == 90 ? "declined" : ""));
        $message = $MC->msg("record $status", HCU_DISPLAY_AS_RAW);

        if (!db_work($dbh, HOMECU_WORK_COMMIT)) {
          throw new exception("commit work failed.", 205);
        }

        $returnArray = array("results" => array("homecuInfo" => array($message), "homecuErrors" => array(), "sqls" => $sqls, "mode" => "setStatus",
                                                "dataId" => $dataId, "transferData" => $transferData, "repeatData" => $repeatData));
      }
      catch(exception $e) {
        $logger->error($e->getCode() . ": " . $e->getMessage());

        if ($e->getCode() > 200) {
          db_work($dbh, HOMECU_WORK_ROLLBACK); // Got greater problems if this fails.
          $errors = array($MC->msg("Trans processing failure", HCU_DISPLAY_AS_HTML) . "  " . $e->getMessage());
        } else {
          $errors = array("$genErr {$e->getCode()}.");
        }

        $returnArray = array("results" => array("homecuInfo" => array(), "homecuErrors" => $errors, "sqls" => $sqls, "mode" => "setStatus", "dataId" => $dataId));
      }

      $gridData = [];
      try {
        $parameters["grid"] = "priorActivity";
        $readResults = readActivityGrid($HB_ENV, $genErr, $parameters, $confirmPermissions, "filter")["results"];
        $sqls = array_merge($sqls, $readResults["sqls"]);

        if (count($readResults["homecuErrors"]) > 0) {
          throw new exception("filter failed.", 112);
        }
        $gridData = $readResults["homecuData"];

      } catch(exception $e) {
        $logger->error($e->getCode() . ": " . $e->getMessage());
      }

      $returnArray["results"]["homecuData"] = $gridData;
      $returnArray["results"]["kendoId"] = $kendoId;
      return $returnArray;
  }

  /**
   * function getDefaultFilter(&$whereTranshdr, &$whereSched, $dbh, $Cu, $Cn, &$sqls)
   * This function gets the default where clauses of the queries when the page is loaded.
   *
   * @param $whereTranshdr -- Overwrites this variable and sent to the query for getting regular transactions.
   * @param $whereSched -- Overwrites this variable and sent to the query for getting scheduled transactions.
   * @param $dbh -- the database connection.
   * @param $Cu -- the credit union
   * @param $Cn -- the logged in user
   * @param $sqls -- the list of SQLs for the data call
   */
  function getDefaultFilter(&$whereTranshdr, &$whereSched, $dbh, $Cu, $Cn, $validUserIds) {
      $approvalFeatureList = getApprovalList();
      $whereTranshdr = "(t.approved_date >= now() - interval '7 days' or t.posted_date >= now() - interval '7 days')"
            . "and t.feature_code in ('" . implode("','", $approvalFeatureList) . "') and t.posted_by in $validUserIds";
      $whereSched = "(s.approved_date >= now() - interval '7 days' or s.create_date >= now() - interval '7 days' or now() <= s.end_date)"
            . "and s.feature_code in ('" . implode("','", $approvalFeatureList) . "') and s.user_id in $validUserIds";
  }

  /**
   * function getFilter($parameters, $MC, $grid, &$whereTranshdr, &$whereSched)
   * This function gets the filter parameters from the REQUEST and then append them to the queries for getting regular transactions and scheduled transactions.
   *
   * @param $parameters -- an array of all the parameters from the REQUEST.
   * @param $MC -- the dictionary for translation.
   * @param $grid -- the grid to get filters for: either "pendingApproval", "scheduledTransactions", or "priorActivity."
   * @param $whereTranshdr -- the where clause for the regular transactions to append filter criteria to the query.
   * @param $whereSched -- the where clause for the scheduled transactions to append filter criteria to the query.
   * @param $dbh -- the database connection
   * @param $Cu -- the credit union
   */
  function getFilter($parameters, $MC, $grid, &$whereTranshdr, &$whereSched, $dbh, $Cu, $Uid) {
      $approvalFeatureList = getApprovalList();
      extract($parameters);

      $feature = isset($filterFeature) ? trim($filterFeature) : "";
      $status = isset($filterStatus) ? trim($filterStatus) : "";
      $from = isset($filterFrom) ? trim($filterFrom) : "";
      $to = isset($filterTo) ? trim($filterTo) : "";

      if ($from != "" && !DateTime::createFromFormat("Y-m-d", $from)) {
        throw new exception("From date is invalid.", 203);
      }
      if ($to != "" && !DateTime::createFromFormat("Y-m-d", $to)) {
        throw new exception("To date is invalid.", 206);
      }

      $whereTranshdr = array();
      $whereSched = array();
      $whereBaseTranshdr = array();
      $whereBaseSched = array();

      if ($status != "") {
        $statusesApproved = getApprovalStatuses($MC);
        $statusesActive = getActiveStatuses($MC);

        $statuses = array_merge(array(), $statusesApproved, $statusesActive);
        $found = false;
        foreach($statuses as $thisStatus) {
          if ($thisStatus["value"] == $status) {
            $found = true;
            break;
          }
        }
        if (!$found) {
          throw new exception("Status is invalid.", 205);
        }

        $whereBaseTranshdr[] = "t.approved_status = " . intval($status);

        if ($grid == "scheduledTransactions") {
          $whereBaseSched[] = "s.status = '" . trim($status) . "'";
        } else {
          $whereBaseSched[] = "s.approved_status = " . intval($status);
        }
      }

      if ($feature != "") {
        $features = getFeatures($dbh, $Cu, $sqls, $MC, $Uid);
        $found = false;
        foreach($features as $thisFeature) {
          if (trim($thisFeature["value"]) == $feature) {
            $found = true;
            break;
          }
        }
        if (!$found) {
          throw new exception("Feature is invalid.", 206);
        }

        $whereBaseTranshdr[] = "t.feature_code = '" . prep_save($feature, 10) . "'";
        $whereBaseSched[] = "s.feature_code = '" . prep_save($feature, 10) . "'";
      } else {
        $whereBaseTranshdr[] = "t.feature_code in ('" . implode("','", $approvalFeatureList) . "')";
        $whereBaseSched[] = "s.feature_code in ('" . implode("','", $approvalFeatureList) . "')";
      }

      switch($grid) {
        case "":
          throw new exception("Grid is not set.", 201);
          break;
        case "scheduledTransactions":
          if ($from != "") {
            if (!HCU_array_key_exists("next_trigger_date", $whereSched)) {
              $whereSched["next_trigger_date"] = array();
              $whereSched["approved_date"] = array();
              $whereSched["created_date"] = array();
            }
            $whereSched["next_trigger_date"][] = "s.next_trigger_date >= '$from'";
            $whereSched["approved_date"][] = "s.approved_date >= '$from'";
            $whereSched["created_date"][] = "s.create_date >= '$from'";
          }
          if ($to != "") {
            if (!HCU_array_key_exists("next_trigger_date", $whereSched)) {
              $whereSched["next_trigger_date"] = array();
              $whereSched["approved_date"] = array();
              $whereSched["created_date"] = array();
            }
            $whereSched["next_trigger_date"][] = "s.next_trigger_date <= '$to'";
            $whereSched["approved_date"][] = "s.approved_date <= '$to'";
            $whereSched["created_date"][] = "s.create_date <= '$to'";
          }
          break;
        case "priorActivity":
          if ($from != "") {
            if (!HCU_array_key_exists("approved_date", $whereTranshdr)) {
              $whereTranshdr["approved_date"] = array();
              $whereTranshdr["posted_date"] = array();
              $whereSched["approved_date"] = array();
              $whereSched["created_date"] = array();
            }

            $whereTranshdr["approved_date"][] = "t.approved_date >= '$from'";
            $whereTranshdr["posted_date"][] = "t.posted_date >= '$from'";
            $whereSched["approved_date"][] = "s.approved_date >= '$from'";
            $whereSched["created_date"][] = "s.create_date >= '$from'";
          }
          if ($to != "") {
            if (!HCU_array_key_exists("approved_date", $whereTranshdr)) {
              $whereTranshdr["approved_date"] = array();
              $whereTranshdr["posted_date"] = array();
              $whereSched["approved_date"] = array();
              $whereSched["created_date"] = array();
            }

            $whereTranshdr["approved_date"][] = "t.approved_date <= '$to'";
            $whereTranshdr["posted_date"][] = "t.posted_date <= '$to'";
            $whereSched["approved_date"][] = "s.approved_date <= '$to'";
            $whereSched["created_date"][] = "s.create_date <= '$to'";
          }
          break;
        default:
          throw new exception("Grid is invalid.", 207);
      }

      $whereTranshdr = parseWhere($whereTranshdr, $whereBaseTranshdr);
      $whereSched = parseWhere($whereSched, $whereBaseSched);
  }

  /**
   * function getScheduledTransactionsTable(&$sqls, &$records, $setSQL, $whereSched, $grid, $Uid, $dbh, $Cu, $MC, $confirmPermissions)
   * This function gets the results from the cu_scheduledtxn.  After the results are retrieved, then they are sent to various translate and detail functions to get the data for the grid.
   *
   * @param $sqls -- list of SQLs to append new SQL to.
   * @param $records -- list of records to append new records to.
   * @param $setSQL -- The SQL to set the timezone for times to show up as the CU's.
   * @param $whereSched -- the where clause gathered from other functions: getFilter and getDefaultFilter.
   * @param $grid -- the grid to get filters for: either "pendingApproval", "scheduledTransactions", or "priorActivity."
   * @param $Uid -- the id of the currently logged in user.
   * @param $dbh -- the database connection
   * @param $Cu -- the credit union
   * @param $MC -- the dictionary for translating.
   * @param $confirmPermissions -- map of users and what confirmation permissions they have.  (If they don't have TRN permissions, then they won't be able to see TRN records.)
   * @param $trans -- the array of transactions for the "other" TRN records.
   * @param $flagset3 -- needed to account descriptions.
   */
  function getScheduledTransactionsTable(&$sqls, &$records, $whereSched, $grid, $Uid, $dbh, $Cu, $MC, $confirmPermissions, $tz, $validUserIds, $trans, $flagset3) {
      $intervalLookup = getIntervalLookup($MC);
      switch($grid) {
        case "pendingApproval":
          $where = "coalesce(s.approved_by, 0) = 0 and coalesce(s.approved_status, 0) = 0 and s.user_id in $validUserIds and ($whereSched)";
          $sortable = "create_date";
          break;
        case "scheduledTransactions":
          $where = "(s.end_date is null or now() <= s.end_date or s.next_trigger_date < s.end_date) and s.approved_status = 10 and s.user_id = $Uid and ($whereSched)";
          $sortable = "next_trigger_date";
          break;
        case "priorActivity":
          // Prior activity: this where statement has the following structure
          // QUERY 1:
          //    user_id == Uid and approved_status == 90, 99
          //    OR
          //    user_id == Uid and approved_status == 10 and end_date not null, now > end_date, next_trigger_date >= end_date
          // Query 2:
          //    approved_by == Uid and user_id != Uid and approved_status == 10, 90
          // Query 3:
          //    filter/user input from getFilter()
          // WHERE -> ( QUERY 1 OR Query 2 ) AND Query 3
          $where = "((s.user_id = '$Uid' and (s.approved_status in (90, 99) or (s.approved_status = 10 and s.end_date is not null and now() > s.end_date and s.next_trigger_date >= s.end_date))) or (s.approved_by = $Uid and s.user_id <> '$Uid' and s.approved_status in (10, 90))) and ($whereSched)";
          $sortable = "approved_date";
          break;
        default: throw new exception("table is unknown.", 1);
      }
      /**
       * Modified ONLY the uato join for cross account records.  Based on  the record type of the useraccounts table {D, L, T, P} I join the appropriate columns for the lookup.
       */
      $sql = "with uaua as (
        select accountnumber, accounttype, display_name, certnumber,
        trim(recordtype) || '|' || trim(accountnumber) || '|' || trim(accounttype) || '|' || certnumber as key,
        user_id, recordtype from ${Cu}useraccounts),
      albalb as (select description, false as iscross, accountnumber as frommember, 'D|' || trim(accountnumber) || '|' || trim(accounttype) || '|' || certnumber as key
       from ${Cu}accountbalance
        union all select description, false, accountnumber, 'L|' || trim(accountnumber) || '|' || trim(loannumber) || '|0' as key from ${Cu}loanbalance
        union all select description, true, accountnumber, case when deposittype = 'L' or deposittype = 'C' then 'L' else 'D' end
         || '|' || trim(tomember) || '|' || trim(accounttype) || '|0' as key from ${Cu}crossaccounts
        )
      select txn.*, uafrom.display_name as from_displayname, albfrom.description as from_desc, uafrom.accountnumber as from_acct, uafrom.accounttype as from_accounttype,
      uafrom.certnumber as from_certnumber, uato.display_name as to_displayname, albto.description as to_desc, uato.accountnumber as to_acct, uato.accounttype as to_accounttype,
      uato.certnumber as to_certnumber from
      (select s.end_date is null or now() <= s.end_date as isscheduled, s.id as data_id, s.name, s.feature_code, s.user_id, s.create_date, s.start_date, s.end_date,
      s.next_trigger_date, s.status, s.approved_date, coalesce(a.user_name, s.user_id::text) as username, coalesce(b.user_name, s.approved_by::text) as approved_username,
      s.approved_by, coalesce(f.description, s.feature_code) as feature, s.approved_status, s.status as active_status, s.txn_data, s.repeating_parameters, s.last_edit_date,
      replace(s.txn_data::json->'txn'->>'from', 'C|', 'L|') as fromid, s.txn_data::json->'txn'->>'frommember' as frommember, s.txn_data::json->'txn'->>'fromsuffix' as fromsuffix,
      replace(s.txn_data::json->'txn'->>'to', 'C|', 'L|') as toid, s.txn_data::json->'txn'->>'tomember' as tomember, s.txn_data::json->'txn'->>'tosuffix' as tosuffix,
      strpos(s.txn_data::json->'txn'->>'transactioncode', 'X') > 0 as iscross,
      '' as processed_by from cu_scheduledtxn s
      left join ${Cu}user a on s.user_id = a.user_id
      left join ${Cu}user b on s.approved_by = b.user_id
      left join cu_feature f on s.feature_code = f.feature_code
      where s.cu = '$Cu' and ($where)
      ) txn
      left join uaua uafrom
        on (txn.fromid = uafrom.key or txn.fromid || '|0' = uafrom.key) and txn.user_id = uafrom.user_id
      left join albalb albfrom
        on (txn.fromid = albfrom.key or txn.fromid || '|0' = albfrom.key) and txn.iscross = albfrom.iscross and txn.frommember = albfrom.frommember
      left join uaua uato
        on
        CASE
          WHEN uato.recordtype = 'D' THEN
            txn.toid
          WHEN uato.recordtype in ('L', 'C') THEN
            txn.toid || '|0'
          WHEN uato.recordtype = 'T' THEN
            'T' || '|' || txn.frommember || '|' || txn.tosuffix || '#' || txn.tomember || '|0'
          WHEN uato.recordtype = 'P' THEN
            'P' || '|' || txn.frommember || '|' || txn.tosuffix || '#' || txn.tomember || '|0'
          ELSE
            txn.toid
        END = uato.key
        and txn.user_id = uato.user_id and uato.recordtype in ('T', 'P') = txn.iscross
      left join albalb albto
        on (txn.toid = albto.key or txn.toid || '|0' = albto.key) and txn.iscross = albto.iscross and txn.frommember = albto.frommember
      where (albto.key is null or uato.key is null)
      or (uato.recordtype in ('T', 'P') and albto.iscross and txn.iscross)
      or (uato.recordtype not in ('T', 'P') and not albto.iscross and not txn.iscross)";
      $sth = db_query($sql, $dbh);

      if (!$sth) {
          $error = pg_result_error($sth);
          throw new exception("Query(getScheduledTransactionsTable) failed: [$error] cu[$Cu] userIds[$validUserIds] where[$whereSched]", 303);
      }

      $isScheduled = true;
      $achcols = array();
      $achpmts = array();
      $exts = array();
      $stRecords = array();
      for($i = 0; $row = db_fetch_assoc($sth, $i); $i++) {

        if ($row["user_id"] != $Uid && !$confirmPermissions[$row["feature_code"]]) { // Do not process a record that isn't created by the user and the user doesn't have permissions.
          continue;
        }

        // Convert dates into dateTime with the timezone of the CU.
        $row["create_date"] = getValidDate($row["create_date"], $tz);
        $row["start_date"] = getValidDate($row["start_date"], $tz, false);
        $row["end_date"] = getValidDate($row["end_date"], $tz, false);
        $row["next_trigger_date"] = getValidDate($row["next_trigger_date"], $tz, false);
        $row["approved_date"] = getValidDate($row["approved_date"], $tz);
        $row["last_edit_date"] = getValidDate($row["last_edit_date"], $tz, false);

        $row["type"] = "scheduled";
        $row["approved_status"] = isset($row["approved_status"]) ? intval($row["approved_status"]) : 0;

        if (!isset($row["repeating_parameters"])) {
          throw new exception("Repeating parameters are not defined.", 304);
        }
        $repeatingInterval = HCU_JsonDecode($row["repeating_parameters"]);
        if (!is_array($repeatingInterval)) {
          throw new exception("Repeating parameters malformed.", 305);
        }
        if (!HCU_array_key_exists("interval", $repeatingInterval)) {
          throw new exception("Interval not found.", 306);
        }
        $row["recurringInterval"] = trim($repeatingInterval["interval"]);
        unset($row["repeating_parameters"]);
        $row["recurringIntervalText"] = HCU_array_key_exists($row["recurringInterval"], $intervalLookup) ? $intervalLookup[$row["recurringInterval"]] : "Unknown";

        $row["dateSortObj"] = $row[$sortable];
        $row["customData"] = HCU_JsonDecode($row["txn_data"]);

        switch($row["feature_code"]) {
          case "ACHCOL":
            $achcols[] = $row["data_id"];
            break;
          case "ACHPMT":
            $achpmts[] = $row["data_id"];
            break;
          case "TRNEXT":
          case "TRNM2M":
            $exts[] = $row["data_id"];
            break;
        }

        $stRecords[] = $row;
      }

      $sql = array();
      $achMap = array();
      if (count($achcols) > 0) {
        $sql[] = "select s.id as data_id, ap.ach_name, ap.display_name, ap.address, ap.dfi_data from cu_scheduledtxn s
             inner join ${Cu}achpartner ap on s.feature_code = 'ACHCOL' and cast(s.txn_data::json->'txn'->>'from' as int) = ap.id
             where s.id in (" . implode(", ", $achcols) . ") and s.cu = '$Cu'";
      }
      if (count($achpmts) > 0) {
        $sql[] = "select s.id as data_id, ap.ach_name, ap.display_name, ap.address, ap.dfi_data from cu_scheduledtxn s
             inner join ${Cu}achpartner ap on s.feature_code = 'ACHPMT' and cast(s.txn_data::json->'txn'->>'to' as int) = ap.id
             where s.id in (" . implode(", ", $achpmts) . ") and s.cu = '$Cu'";
      }

      if (count($sql) > 0) {
        $sql = implode(" union all ", $sql);
        $sqls[] = $sql;
        $sth = db_query($sql, $dbh);
        if (!$sth) {
          throw new exception("ach map query failed.", 307);
        }
        for($i = 0; $row = db_fetch_assoc($sth, $i); $i++) {
          $row["dfi_data"] = HCU_JsonDecode($row["dfi_data"]);
          $row["address"] = HCU_JsonDecode($row["address"]);

          $achMap[$row["data_id"]] = $row;
        }
      }

      $sql = array();
      $extMap = array();
      if (count($exts) > 0) {
        $sql[] = "select s.id as data_id, 'from' as dir, ea.display_name, ea.remote_info from cu_scheduledtxn s
            inner join ${Cu}extaccount ea on s.feature_code in ('TRNEXT') and s.txn_data::json->'txn'->>'type' in ('X2L') and cast(s.txn_data::json->'txn'->>'from' as int) = ea.id
            and ea.type = 'EXT' where s.id in (" . implode(", ", $exts) . ") and s.cu = '$Cu'"; // Member-to-member can only come from the local account.
        $sql[] = "select s.id as data_id, 'to', ea.display_name, ea.remote_info from cu_scheduledtxn s
            inner join ${Cu}extaccount ea on s.feature_code in ('TRNEXT', 'TRNM2M') and s.txn_data::json->'txn'->>'type' in ('L2X', 'L2M') and replace(s.feature_code, 'TRN', '') = ea.type
            and cast(s.txn_data::json->'txn'->>'to' as int) = ea.id where s.id in (" . implode(", ", $exts) . ") and s.cu = '$Cu'";
      }

      if (count($sql) > 0) {
        $sql = implode(" union all ", $sql);
        $sqls[] = $sql;
        $sth = db_query($sql, $dbh);
        if (!$sth) {
          throw new exception("ext map query failed.", 308);
        }
        for($i = 0; $row = db_fetch_assoc($sth, $i); $i++) {
          $row["remote_info"] = HCU_JsonDecode($row["remote_info"]);

          $extMap[$row["data_id"]] = $row;
        }
      }

      for($i = 0, $count = count($stRecords); $i != $count; $i++) {
        $row = $stRecords[$i];
        if ($row["user_id"] != $Uid && !$confirmPermissions[$row["feature_code"]]) { // Do not process a record that isn't created by the user and the user doesn't have permissions.
          continue;
        }

        $row["grid"] = $grid;

        translateCommonNeeded($row, $isScheduled, $Uid, $MC);
        detailsCommon($row, $isScheduled, $MC);

        $extAccount = HCU_array_key_exists($row["data_id"], $extMap) ? $extMap[$row["data_id"]] : null;
        $achAccount = HCU_array_key_exists($row["data_id"], $achMap) ? $achMap[$row["data_id"]] : null;

        switch($row["feature_code"]) {
          case "TRN":
            translateTRN($row, $isScheduled, $MC, $trans, $dbh, $Cu, $Uid, $flagset3);
            break;
          case "TRNEXT":
            translateTRNEXT($row, $isScheduled, $extAccount, $MC, $dbh, $Cu, $Uid, $flagset3);
            break;
          case "TRNM2M":
            translateTRNM2M($row, $isScheduled, $extAccount, $MC, $dbh, $Cu, $Uid, $flagset3);
            break;
          case "ACHCOL":
          case "ACHPMT":
            translateACH($row, $achAccount, $isScheduled, $row["feature_code"], $MC, $dbh, $Cu, $Uid, $flagset3);
            break;
        }

        translateCleanup($row, $isScheduled);
        $records[$i] = $row;
      }

  }

  /**
   * function getRegularTransactionsTable(&$sqls, &$records, $setSQL, $whereTranshdr, $grid, $Uid, $MC, $dbh, $Cu, $confirmPermissions)
   * This function gets the results from the ${Cu}transhdr and ${Cu}transdtl tables.
   * After the results are retrieved, then they are sent to various translate and detail functions to get the data for the grid.
   *
   * @param $sqls -- list of SQLs to append new SQL to.
   * @param $records -- list of records to append new records to.
   * @param $setSQL -- The SQL to set the timezone for times to show up as the CU's.
   * @param $whereTranshdr -- the where clause gathered from other functions: getFilter and getDefaultFilter.
   * @param $grid -- the grid to get filters for: either "pendingApproval", "scheduledTransactions", or "priorActivity."
   * @param $Uid -- the id of the currently logged in user.
   * @param $MC -- the dictionary for translating.
   * @param $dbh -- the database connection
   * @param $Cu -- the credit union
   * @param $confirmPermissions -- map of users and what confirmation permissions they have.  (If they don't have TRN permissions, then they won't be able to see TRN records.)
   * @param $trans -- the array of transactions for the "other" TRN records.
   * @param $flagset3 -- needed for getting account descriptions.
   */
  function getRegularTransactionsTable(&$sqls, &$records, $whereTranshdr, $grid, $Uid, $MC, $dbh, $Cu, $confirmPermissions, $tz, $validUserIds, $trans, $flagset3, $HB_ENV) {
      switch($grid) {
        case "pendingApproval":
          $where = "t.accountnumber is not null and coalesce(t.approved_by, 0) = 0 and coalesce(t.approved_status, 0) = 0 and t.posted_by in $validUserIds and ($whereTranshdr)";
          $sortable = "posted_date";
          break;
        case "scheduledTransactions": throw new exception("table doesn't use this database table.", 2); break;
        case "priorActivity":
          $where = "t.accountnumber is not null and (t.approved_by = '$Uid' or t.posted_by = '$Uid') and t.approved_status in (10, 90, 99) and ($whereTranshdr)";
          $sortable = "approved_date";
          break;
        default: throw new exception("table is unknown.", 1); break;
      }

      // Have to rename the id column because Kendo uses the id field by default in the grid.  Will need another id for the kendo grid because the grid is coming from two sources.
      // Only get entries that have an account number to avoid internal transactions (i.e. micro deposits for external accounts)
      $sql = "with uaua as (select accountnumber, accounttype, display_name, certnumber, trim(recordtype) || '|' || trim(accountnumber) || '|' || trim(accounttype) || '|' || certnumber as key,
        user_id, recordtype from ${Cu}useraccounts),
      albalb as (select false as iscross, description, accountnumber as frommember,
        'D|' || trim(accountnumber) || '|' || trim(accounttype) || '|' || certnumber as key from ${Cu}accountbalance
        union all
        select false as iscross, description, accountnumber,
        'L|' || trim(accountnumber) || '|' || trim(loannumber) || '|0' as key from ${Cu}loanbalance
        union all
        select true as iscross, description, accountnumber,
        case when deposittype = 'L' or deposittype = 'C' then 'L' else 'D' end || '|' || trim(tomember) || '|' || trim(accounttype) || '|0' as key
        from ${Cu}crossaccounts
        )
      select txn.*, uafrom.display_name as from_displayname, albfrom.description as from_desc, uafrom.accountnumber as from_acct, uafrom.accounttype as from_accounttype,
      uafrom.certnumber as from_certnumber, uato.display_name as to_displayname, albto.description as to_desc, uato.accountnumber as to_acct, uato.accounttype as to_accounttype,
      uato.certnumber as to_certnumber from
      (select t.id, t.accountnumber, t.accounttype, t.deposittype, t.transactioncode, t.feature_code, t.effective_date, t.posted_date, t.memo, t.posted_by, t.approved_date,
      coalesce(a.user_name, t.posted_by::text) as username, coalesce(b.user_name, t.approved_by::text) as approved_username, t.approved_by, t.id as data_id, t.approved_status,
      coalesce(f.description, t.feature_code) as feature, coalesce(d.amount, 0) as amount, d.transdata, t.processed_date, t.processed_status, t.processed_by,
      replace(d.transdata::json->>'acct_source', 'C|', 'L') as fromid, d.transdata::json->>'source_key' as fromkey, d.transdata::json->'source_key'->>'accountnumber' as frommember, d.transdata::json->'source_key'->>'accounttype' as fromsuffix,
      replace(d.transdata::json->>'acct_dest', 'C|', 'L|') as toid, d.transdata::json->'dest_key' as tokey, d.transdata::json->'dest_key'->>'accountnumber' as tomember,
      case when d.transdata::json->'dest_key'->>'recordtype' = 'L' or d.transdata::json->'dest_key'->>'recordtype' = 'C' then d.transdata::json->'dest_key'->>'loannumber' else d.transdata::json->'dest_key'->>'accounttype' end  as tosuffix

      from ${Cu}transhdr t
      left join ${Cu}user a on t.posted_by = a.user_id
      left join ${Cu}user b on t.approved_by = b.user_id
      left join cu_feature f on t.feature_code = f.feature_code
      left join ${Cu}transdtl d on t.id = d.transhdr_id
      where $where) txn
      left join uaua uafrom
        on (txn.fromid = uafrom.key or txn.fromid || '|0' = uafrom.key) and txn.posted_by = uafrom.user_id
      left join albalb albfrom
        on (txn.fromid = albfrom.key or txn.fromid || '|0' = albfrom.key)
        and txn.transactioncode in ('XP', 'XA') = albfrom.iscross and txn.frommember = albfrom.frommember
      left join uaua uato
        ON CASE WHEN txn.transactioncode in ('XP', 'XA') and uato.recordtype in ('T', 'P') THEN
            uato.recordtype || '|' || txn.frommember || '|' || txn.tosuffix || '#' || txn.tomember || '|0'
          WHEN txn.transactioncode not in ('XP', 'XA') and uato.recordtype = 'D' THEN
            txn.toid
          WHEN txn.transactioncode not in ('XP', 'XA') and uato.recordtype in ('L', 'C') THEN
            txn.toid || '|0'
          ELSE
            txn.toid END = uato.key AND txn.posted_by = uato.user_id AND uato.recordtype in ('T', 'P') = txn.transactioncode in ('XP', 'XA')
      left join albalb albto
        on (txn.toid = albto.key or txn.toid || '|0' = albto.key)
        and txn.transactioncode in ('XP', 'XA') = albto.iscross and txn.frommember = albto.frommember";

      $sqls[] = $sql;
      $sth = db_query($sql, $dbh);
      if (!$sth) {
        throw new exception("transhdr query failed.", 301);
      }

      $gtRecords = array();
      for($i = 0; $row = db_fetch_assoc($sth, $i); $i++) {
        if (!($row["posted_by"] == $Uid || $confirmPermissions[$row["feature_code"]])) { // Do not process a record that isn't created by the user and the user doesn't have permissions.
          continue;
        }

        // Need to get confirmation code, we need to call GetTransferConfirmation()
        // which needs HB_ENV, and getValidDate sets the dates we need as an object
        // where GetTransferConfirmCode needs a string.
        if ($row['processed_date'] != null) {
          $row['confirmation'] = GetTransferConfirmCode($HB_ENV, "process", $row);
        } else if ($row['approved_date'] != null) {
          $row['confirmation'] = GetTransferConfirmCode($HB_ENV, "approve", $row);
        } else {
          // not processed, not approved, get posted
          // confirmation code
          $row['confirmation'] = GetTransferConfirmCode($HB_ENV, "post", $row);
        }

        // Convert dates into dateTime with the timezone of the CU.
        $row["posted_date"] = getValidDate($row["posted_date"], $tz);
        $row["effective_date"] = getValidDate($row["effective_date"], $tz, false);
        $row["approved_date"] = getValidDate($row["approved_date"], $tz);
        $row["processed_date"] = getValidDate($row["processed_date"], $tz);
        $row["grid"] = $grid;

        $row["type"] = "transhdr";
        $row["approved_status"] = isset($row["approved_status"]) ? intval($row["approved_status"]) : 0;

        $row["dateSortObj"] = $row[$sortable];

        $customData = HCU_JsonDecode($row["transdata"]);
        $customData["amount"] = $row["amount"];

        $key = $row["data_id"] . "a"; // Add the "a" so it isn't mistaken as an indexed key.
        if (!isset($gtRecords[$key])) {
          $row["customData"] = array();
          $row["fullAmount"] = 0;
          $gtRecords[$key] = $row;
        }

        $gtRecords[$key]["customData"][] = $customData;
        $gtRecords[$key]["fullAmount"] += $row["amount"];
      }

      $isScheduled = false;
      foreach($gtRecords as $key => $row) {
        translateCommonNeeded($row, $isScheduled, $Uid, $MC);
        detailsCommon($row, $isScheduled, $MC);

        switch($row["feature_code"]) {
          case "TRN":
            translateTRN($row, $isScheduled, $MC, $trans, $dbh, $Cu, $Uid, $flagset3);
            break;
          case "TRNEXT":
            translateTRNEXT($row, $isScheduled, null, $MC, $dbh, $Cu, $Uid, $flagset3);
            break;
          case "TRNM2M":
            translateTRNM2M($row, $isScheduled, null, $MC, $dbh, $Cu, $Uid, $flagset3);
            break;
          case "ACHCOL":
          case "ACHPMT":
            translateACH($row, null, $isScheduled, $row["feature_code"], $MC, $dbh, $Cu, $Uid, $flagset3);
            break;
        }

        translateCleanup($row, $isScheduled);

        $records[$key] = $row;
      }
  }

  /**
   * function translateCommonNeeded(&$row, $isScheduled, $Uid, $MC)
   * This function gets the values for the grid that are needed for all transactions.
   *
   * @param $row -- the scheduled transaction or regular transaction record from the getRegularTransactionsTable or getScheduledTransactionsTable queries.
   * @param $isScheduled -- if true, the row comes from the scheduled transaction query versus the regular transaction query.
   * @param $Uid -- the id of the currently logged in user.
   * @param $MC -- the dictionary for translating.
   */
  function translateCommonNeeded(&$row, $isScheduled, $Uid, $MC) {

    $displayDate = $isScheduled ? $row["next_trigger_date"] : $row["posted_date"];
    $row["displayDateFull"] = isset($displayDate) ? $displayDate->format(getDFormat()) : "";
    $row["displayDateMonth"] = isset($displayDate) ? $displayDate->format("M") : "";
    $row["displayDateDay"] = isset($displayDate) ? $displayDate->format("d") : "";
    $row["displayDateYear"] = isset($displayDate) ? $displayDate->format("Y") : "";

    $postBy = $isScheduled ? $row["user_id"] : $row["posted_by"];
    $row["canApprove"] = $postBy != $Uid;

    switch($row["approved_status"]) {
      case 10:
        if (HCU_array_key_exists("processed_status", $row) && $row["processed_status"] == 99) {
          $row["approvedDescription"] = $MC->msg("Failed", HCU_DISPLAY_AS_JS);
          $row["infoClass"] = "failed";
        } else if ($row["grid"] == "scheduledTransactions" || $row["canApprove"]) { // If seeing transfer through approver's view, prior activity is also the ones that you've approved.
          if (HCU_array_key_exists("active_status", $row)) {
            if ($row["active_status"] == "A") {
              $row["approvedDescription"] = $MC->msg("Active", HCU_DISPLAY_AS_JS);
              $row["infoClass"] = "approved";
            } else { // active_status == I
              $row["approvedDescription"] = $MC->msg("Inactive", HCU_DISPLAY_AS_JS);
              $row["infoClass"] = "failed";
            }
          } else {
            $row["approvedDescription"] = $MC->msg("Completed", HCU_DISPLAY_AS_JS);
            $row["infoClass"] = "completed";
          }
        } else {
          $row["approvedDescription"] = $MC->msg("Completed", HCU_DISPLAY_AS_JS);
          $row["infoClass"] = "completed";
        }
        break;
      case 99:
        $row["approvedDescription"] = $MC->msg("Cancelled", HCU_DISPLAY_AS_JS);
        $row["infoClass"] = "cancelled";
        break;
      case 90:
        $row["approvedDescription"] = $MC->msg("Declined", HCU_DISPLAY_AS_JS);
        $row["infoClass"] = "declined";
        break;
      case 0:
        $row["approvedDescription"] = "";
        $row["infoClass"] = $row["canApprove"] ? "awaiting" : "awaiting-non";
        break;
    }

    // Translate the "Funds Transfer", "External Accounts", etc.
    $feature = $MC->msg("CU feature " . $row["feature_code"], HCU_DISPLAY_AS_RAW);
    $row["feature"] = isset($feature) ? $feature : $row["feature"]; // If the dictionary exists, use it.  Otherwise, use the value in the database.

    // Needed but should be overwritten by the other translate functions per transaction type.
    $row["area1Label"] = "";
    $row["area1Text"] = "";
    $row["area2Label"] = "";
    $row["area2Text"] = "";
    $row["area3"] = "";
    //adding label for interval
    $row["interval"] = "";
    $row["details"] = array();

    // Area4 labels.  Logic was duplicated in each of the transfer types and changes needed to be made for #1427 so move it here.
    $processDate = "";
    if (!$isScheduled && in_array($row["feature_code"], array("ACHCOL", "ACHPMT"))) {
      $processDate = $row["effective_date"];
      $processDate = isset($processDate) ? $processDate->format(getDFormat()) : $MC->msg("Online Deposits Pending", HCU_DISPLAY_AS_RAW);
    } else if ($row["grid"] == "pendingApproval") {
      $processDate = $isScheduled ? $row["start_date"] : $row["effective_date"];
      $processDate = isset($processDate) ? $processDate->format(getDFormat()) : "";
    } else if ($row["grid"] == "scheduledTransactions") {
      $processDate = $row["next_trigger_date"];
      $processDate = isset($processDate) ? $processDate->format(getDFormat()) : "";
    } else if ($row["grid"] == "priorActivity") {
      $processDate = $isScheduled ? $row["create_date"] : $row["posted_date"];
      $processDate = isset($processDate) ? $processDate->format(getDFormat()) : "";
    }

    // $completedDate = $isScheduled ? $row["last_edit_date"] : $row["approved_date"];
    $completedDate = $isScheduled ? $row["next_trigger_date"] : $row["approved_date"];
    $completedDate = isset($completedDate) ? $completedDate->format(getDFormat()) : "";

    $approvedDate = $row["approved_date"];
    $approvedDate = isset($approvedDate) ? $approvedDate->format(getDFormat()) : "";

    $row["area4Label"] = "";
    $row["area4Text"] = "";

    if ($row["processed_by"] == "*sched*") {
      $row["area4Label"] = "";
      $row["area4Text"] = $MC->msg("From Schedule", HCU_DISPLAY_AS_RAW);
    } else if (!$isScheduled && in_array($row["feature_code"], array("ACHCOL", "ACHPMT"))) { // ACHCOL and ACHPMT is special.  The regular transactions also have Effective Date.
      $row["area4Label"] = $MC->msg("ACH Effective Date", HCU_DISPLAY_AS_RAW);
      $row["area4Text"] = $processDate;
    } else if ($row["approved_status"] == 10) {

      if ($row["canApprove"]) {
        $row["area4Label"] = $MC->msg("Approved on", HCU_DISPLAY_AS_RAW);
        $row["area4Text"] = $approvedDate;
      } else if ($row["grid"] == "scheduledTransactions") {
        $row["area4Label"] = $MC->msg("Next Trigger", HCU_DISPLAY_AS_RAW);
        $row["area4Text"] = $processDate;
      } else if ($row["grid"] == "priorActivity") {
        $row["area4Label"] = $MC->msg("Completed on", HCU_DISPLAY_AS_RAW);
        $row["area4Text"] = $completedDate;
      }

    } else if ($row["approved_status"] == 99) {
      $row["area4Label"] = $MC->msg("Cancelled on", HCU_DISPLAY_AS_RAW);
      $row["area4Text"] = $approvedDate;
    } else if ($row["approved_status"] == 90) {
      $row["area4Label"] = $MC->msg("Declined on", HCU_DISPLAY_AS_RAW);
      $row["area4Text"] = $approvedDate;
    } else if ($isScheduled) {

      if ($row["grid"] == "pendingApproval") {
        $row["area4Label"] = $MC->msg("ACH Effective Date", HCU_DISPLAY_AS_RAW);
        $row["area4Text"] = $processDate;
      } else if ($row["grid"] == "scheduledTransactions") {
        $row["area4Label"] = $MC->msg("Next Trigger", HCU_DISPLAY_AS_RAW);
        $row["area4Text"] = $processDate;
      } else if ($row["grid"] == "priorActivity") {
        $row["area4Label"] = $MC->msg("Processed Date", HCU_DISPLAY_AS_RAW);
        $row["area4Text"] = $processDate;
      }

    } else { // Regular transfer that is not approved, cancelled, or declined.
      $row["area4Label"] = "";
      $row["area4Text"] = $MC->msg("Immediate", HCU_DISPLAY_AS_RAW);
    }

  }

  /**
   * function detailsCommon(&$row, $isScheduled, $MC)
   * This function creates the top portion of the details for the grid row that is common to all transactions.
   *
   * @param $row -- the scheduled transaction or regular transaction record from the getRegularTransactionsTable or getScheduledTransactionsTable queries.
   * @param $isScheduled -- if true, the row comes from the scheduled transaction query versus the regular transaction query.
   * @param $MC -- the dictionary for translating.
   */
  function detailsCommon(&$row, $isScheduled, $MC) {

    $createdOnDate = $isScheduled ? $row["create_date"] : $row["posted_date"];
    $createdOnDate = isset($createdOnDate) ? $createdOnDate->format(getGFormat()) : "";
    $processedDate = !$isScheduled ? ($row["grid"] == "priorActivity" ? $row["effective_date"] : $row["processed_date"]) : null;
    $processedDate = isset($processedDate) ? $processedDate->format(getDFormat()) : $MC->msg("Online Deposits Pending", HCU_DISPLAY_AS_JS);
    $approvedDate = $row["approved_date"];
    $approvedDate = isset($approvedDate) ? $approvedDate->format(getGFormat()) : "";

    // $completedDate = $isScheduled ? $row["last_edit_date"] : $row["approved_date"];
    $completedDate = $isScheduled ? $row["next_trigger_date"] : $row["approved_date"];
    $completedDate = isset($completedDate) ? $completedDate->format(getDFormat()) : "";

    // Put the confirmation code at the top of the list.
    // Scheduled transfers do not have confirmation codes
    // only add this detail for non-scheduled.
    if (!$isScheduled) {
      $confirmationCode = $row['confirmation'];
      $row["details"][] = array("label" => $MC->msg("Confirmation", HCU_DISPLAY_AS_RAW), "text" => $confirmationCode);
    }

    $row["details"][] = array("label" => $MC->msg("Created On", HCU_DISPLAY_AS_RAW), "text" => $createdOnDate);
    $row["details"][] = array("label" => $MC->msg("Created By", HCU_DISPLAY_AS_RAW), "text" => isset($row["username"]) ? trim($row["username"]) : "");

    $isCompleted = $row["grid"] == "priorActivity" && !$row["canApprove"];

    switch($row["approved_status"]) {
      case 10:
        $row["details"][] = array("label" => $MC->msg("Approved on", HCU_DISPLAY_AS_RAW), "text" => $approvedDate);
        $row["details"][] = array("label" => $MC->msg("Approved by", HCU_DISPLAY_AS_RAW), "text" => $row["approved_username"]);

        if ($isCompleted) {
          $row["details"][] = array("label" => $MC->msg("Completed on", HCU_DISPLAY_AS_RAW), "text" => $completedDate);
        }
      break;
      case 90:
        $row["details"][] = array("label" => $MC->msg("Declined on", HCU_DISPLAY_AS_RAW), "text" => $approvedDate);
        $row["details"][] = array("label" => $MC->msg("Declined by", HCU_DISPLAY_AS_RAW), "text" => $row["approved_username"]);
      break;
      case 99:
        $row["details"][] = array("label" => $MC->msg("Cancelled on", HCU_DISPLAY_AS_RAW), "text" => $approvedDate);
        $row["details"][] = array("label" => $MC->msg("Cancelled by", HCU_DISPLAY_AS_RAW), "text" => $row["approved_username"]);
      break;
    }

    if ($isScheduled) {
      $startDate = $row["start_date"];
      $startDate = isset($startDate) ? $startDate->format(getDFormat()) : "";
      $endDate = $row["end_date"];
      $endDate = isset($endDate) ? $endDate->format(getDFormat()) : "";


      $row["details"][] = array("label" => $MC->msg("Start Date", HCU_DISPLAY_AS_RAW), "text" => $startDate);
      $row["details"][] = array("label" => $MC->msg("End Date", HCU_DISPLAY_AS_RAW), "text" => $endDate);

      if (!$isCompleted) {
        $nextTriggerDate = $row["next_trigger_date"];
        $nextTriggerDate = isset($nextTriggerDate) ? $nextTriggerDate->format(getDFormat()) : "";
        $row["details"][] = array("label" => $MC->msg("Next Trigger", HCU_DISPLAY_AS_RAW), "text" => $nextTriggerDate);
      }

      if ($row["grid"] != "priorActivity") {
        $row["details"][] = array("label" => $MC->msg("Status", HCU_DISPLAY_AS_RAW), "text" => $MC->msg($row["status"] == "A" ? "Active" : "Inactive", HCU_DISPLAY_AS_JS));
      }

      $row["details"][] = array("label" => $MC->msg("Interval", HCU_DISPLAY_AS_RAW), "text" => $row["recurringIntervalText"]);
    } else {
      if (!$isCompleted && !in_array($row["approved_status"], array(90,99))) {
        $row["details"][] = array("label" => $MC->msg("ACH Effective Date", HCU_DISPLAY_AS_RAW), "text" => $processedDate);
      }
    }

  }

  /**
   * function translateTRN(&$row, $isScheduled, $MC)
   * This populates the four areas iff the feature_code is TRN.
   *
   * @param $row -- the scheduled transaction or regular transaction record from the getRegularTransactionsTable or getScheduledTransactionsTable queries.
   * @param $isScheduled -- if true, the row comes from the scheduled transaction query versus the regular transaction query.
   * @param $MC -- the dictionary for translating.
   * @param $trans -- the array of transactions for the "other" TRN records.
   */
  function translateTRN(&$row, $isScheduled, $MC, $trans, $dbh, $Cu, $Uid, $flagset3) {
    $srcAcctId = $dstAcctId = null;
    $srcAcctKey = $dstAcctKey = null;
    $srcAcctDesc = $dstAcctDesc = null;
    $hasDstDesc = false;

    if ($isScheduled) {
      $srcAcctId = explode("|", $row['customData']['txn']['from']);
      $srcAcctKey = array(
        "accountnumber" => $row['customData']['txn']['frommember'],
        "recordtype" => $row['customData']['txn']['fromtype'],
      );
      if ($srcAcctKey['recordtype'] == "D") {
        $srcAcctKey['accounttype'] = $row['customData']['txn']['fromsuffix'];
        $srcAcctKey['certnumber'] = $srcAcctId[3];
      } else if ($srcAcctKey['recordtype'] == "L" || $srcAcctKey['recordtype'] == "C") {
        $srcAcctKey['loannumber'] = $row['customData']['txn']['fromsuffix'];
      }

      $dstAcctId = explode("|", $row['customData']['txn']['to']);
      $dstAcctKey = array(
        "accountnumber" => $row['customData']['txn']['tomember'],
        "recordtype" => $row['customData']['txn']['totype']
      );
      if ($dstAcctKey['recordtype'] == "D") {
        $dstAcctKey['accounttype'] = $row['customData']['txn']['tosuffix'];
        $dstAcctKey['certnumber'] = $dstAcctId[3];
      } else if ($dstAcctKey['recordtype'] == "L" || $dstAcctKey['recordtype'] == "C") {
        $dstAcctKey['loannumber'] = $row['customData']['txn']['tosuffix'];
      }

      $row["area3"] = money_format('$%i', $row['customData']['txn']["amount"]) . " " . trim($row["recurringIntervalText"]);

      $row["interval"] = trim($row["recurringIntervalText"]);

    } else {
      $srcAcctId = explode("|", $row['customData'][0]['acct_source']);
      $srcAcctKey = HCU_array_key_value('source_key', $row['customData'][0]);

      $dstAcctId = explode("|", $row['customData'][0]['acct_dest']);
      $dstAcctKey = HCU_array_key_value('dest_key', $row['customData'][0]);

      $row["area3"] = money_format('$%i', $row["fullAmount"]);
    }

    $srcAcctDisp = GetMemberDescription($dbh, $Cu, $Uid, $srcAcctKey);
    if ($srcAcctKey['recordtype'] == "D") {
      $srcAcctDesc = getAccountDescription($dbh, $Cu, $srcAcctKey['accountnumber'], $srcAcctDisp['description'], $srcAcctKey['accounttype'],
                                           $srcAcctDisp['display_name'], $flagset3, $srcAcctId[3]);
    } else if ($srcAcctKey['recordtype'] == "L"  || $srcAcctKey['recordtype'] == "C") {
      $srcAcctDesc = getAccountDescription($dbh, $Cu, $srcAcctKey['accountnumber'], $srcAcctDisp['description'], $srcAcctKey['loannumber'], $srcAcctDisp['display_name'],
                                           $flagset3, $row["from_certnumber"]);
    }

    if ($dstAcctId[0] == "O") {
      if ($isScheduled) {
        $hasDstDesc = HCU_array_key_value($row['customData']['txn']["tosuffix"], $trans);
      } else {
        $hasDstDesc = HCU_array_key_value($dstAcctId[2], $trans);
      }
      if (!$hasDstDesc) {
        $dstAcctDesc = $MC->msg("Unknown", HCU_DISPLAY_AS_JS);
      } else {
        $cudesc = isset($hasDstDesc[2]) ? trim($hasDstDesc[2]) : "";
        $noncudesc = isset($hasDstDesc[0]) ? trim($hasDstDesc[0]) : "";
        $dstAcctDesc = $cudesc != "" ? $cudesc : $noncudesc;
      }
    } else {

      /*
       * Cross Account Lookup
       * if the transactioncode is in {XA, XP} then supply different values for looking up the Account Description
       */
      if ($isScheduled) {
        $recordTransCode = $row['customData']['txn']['transactioncode'];
        $recordToInfo = $row['customData']['txn'];
      } else {
        $recordTransCode = $row['transactioncode'];
        $recordToInfo = $row;
      }
      if (in_array($recordTransCode, Array("XA", "XP"))) {
        /*
         * Cross Account Transfers need to be made within the same "Member" account.  They can not cross over to a
         * different member number source.
         * Therefore, I should be able to use the 'frommember' as the member number to lookup in the useraccounts table.
         *
         * The lookup ONLY needs be modified for looking up the ORIGINAL description using the GetMemberDescription function
         * The normal process of displaying the description should be done using the AcctKey as is from the txn record.
         *
         */
        $acctTypeorLoan = ($dstAcctKey['recordtype'] == "L"  || $dstAcctKey['recordtype'] == "C" ? "loannumber" : "accounttype");
        $localAcctKey = Array(
                              "recordtype" => $dstAcctKey['recordtype'],
                              "accountnumber" => $recordToInfo['frommember'],
                              $acctTypeorLoan => $recordToInfo['tosuffix'] . '#' . $recordToInfo['tomember'],
                              "certnumber" => 0
                            );

      } else {
        $localAcctKey = $dstAcctKey;
      }
      // ** Gets the appropriate Core Description
      $dstAcctDisp = GetMemberDescription($dbh, $Cu, $Uid, $localAcctKey);
      if ($dstAcctKey['recordtype'] == "D") {
        $dstAcctDesc = getAccountDescription($dbh, $Cu, $dstAcctKey['accountnumber'], $dstAcctDisp['description'], $dstAcctKey['accounttype'], $dstAcctDisp['display_name'],
                                             $flagset3, $dstAcctId[3]);
      } else if ($dstAcctKey['recordtype'] == "L" || $dstAcctKey['recordtype'] == "C") {
        $dstAcctDesc = getAccountDescription($dbh, $Cu, $dstAcctKey['accountnumber'], $dstAcctDisp['description'], $dstAcctKey['loannumber'], $dstAcctDisp['display_name'],
                                             $flagset3, $row["to_certnumber"]);
      }


    }

    // setup row display
    $row["area1Label"] = $MC->msg("From", HCU_DISPLAY_AS_JS);
    $row['area1Text'] = $srcAcctDesc;
    $row["area2Label"] = $MC->msg("To", HCU_DISPLAY_AS_JS);
    $row['area2Text'] = $dstAcctDesc;

    // setup details view display
    $row["details"][] = array("label" => $MC->msg("From Account", HCU_DISPLAY_AS_RAW), "text" => $srcAcctDesc);
    $dstAcctId[0] == "O" ?
      $row["details"][] = array("label" => $MC->msg("Special Transfer", HCU_DISPLAY_AS_RAW), "text" => $dstAcctDesc) :
      $row["details"][] = array("label" => $MC->msg("To Account", HCU_DISPLAY_AS_RAW), "text" => $dstAcctDesc);
    $isScheduled ?
      $row["details"][] = array("label" => $MC->msg("Amount", HCU_DISPLAY_AS_RAW), "text" => money_format('$%i', $row["customData"]["txn"]["amount"])) :
      $row["details"][] = array("label" => $MC->msg("Amount", HCU_DISPLAY_AS_RAW), "text" => money_format('$%i', $row["amount"]));
    $isScheduled ?
      $row['details'][] = array("label" => $MC->msg("Comment", HCU_DISPLAY_AS_JS), "text" => $row["customData"]["txn"]['memo']) :
      $row['details'][] = array("label" => $MC->msg("Comment", HCU_DISPLAY_AS_JS), "text" => $row['memo']);
  }

  /**
   * function translateTRNEXT(&$row, $isScheduled, $extAccount, $MC)
   * This populates the four areas iff the feature_code is TRNEXT.
   *
   * @param $row -- the scheduled transaction or regular transaction record from the getRegularTransactionsTable or getScheduledTransactionsTable queries.
   * @param $isScheduled -- if true, the row comes from the scheduled transaction query versus the regular transaction query.
   * @param $extAccount -- the external account record for details.
   * @param $MC -- the dictionary for translating.
   * @param $dbh -- the database connection (needed for getting the mask variable.)
   * @param $Cu -- the credit union
   * @param $flagset3 -- contains the two flags needed for determining account descriptions.
   */
  function translateTRNEXT(&$row, $isScheduled, $extAccount, $MC, $dbh, $Cu, $Uid, $flagset3) {
    $localAcctId = $localAcctKey = $localAcctDisp = $localAcctDesc = null;
    $externalAcctId = $externalAcctDesc = $externalAcctRouting = $externalAcctAccount = null;
    $trnAmnt = $trnMemo = null;

    $mask = GetMask($dbh, $Cu);
    $mask = $mask["code"] != 0 ? array("start" => -2) : $mask["data"]; // Just return the default mask in this case.

    $trnDir = $isScheduled ?
      ($extAccount['dir'] == "to" ? "to" : "from") :
      ($row['fromkey'] ? "to" : "from");

    if ($isScheduled) {
      $row["area1Label"] = $MC->msg($extAccount["dir"] == "from" ? "ACH From Account" : "From", HCU_DISPLAY_AS_JS);
      $row["area2Label"] = $MC->msg($extAccount["dir"] == "to" ? "ACH To Account" : "To", HCU_DISPLAY_AS_JS);

      if ($trnDir == "from") {
        $localAcctId = explode("|", $row["customData"]["txn"]["to"]);
        $localAcctKey = array(
          "accountnumber" => $row['customData']['txn']['tomember'],
          "recordtype" => $row['customData']['txn']['totype']
        );
        if ($localAcctKey['recordtype'] == "D") {
          $localAcctKey['accounttype'] = $row['customData']['txn']['tosuffix'];
          $localAcctKey['certnumber'] = $localAcctId[3];
        } else if ($localAcctKey['recordtype'] == "L" || $localAcctKey['recordtype'] == "C") {
          $localAcctKey['loannumber'] = $row['customData']['txn']['tosuffix'];
        }
        $localAcctDisp = GetMemberDescription($dbh, $Cu, $Uid, $localAcctKey);
        if ($localAcctKey['recordtype'] == "D") {
          $localAcctDesc = getAccountDescription($dbh, $Cu, $localAcctKey['accountnumber'], $localAcctDisp['description'], $localAcctKey['accounttype'], $localAcctDisp['display_name'],
            $flagset3, $localAcctKey['certnumber']);
        } else if ($localAcctKey['recordtype'] == "L" || $localAcctKey['recordtype'] == "C") {
          $localAcctDesc = getAccountDescription($dbh, $Cu, $localAcctKey['accountnumber'], $localAcctDisp['description'], $localAcctKey['loannumber'], $localAcctDisp['display_name'],
            $flagset3, $row["to_certnumber"]);
        }
      }
      else
      {
        $localAcctId = explode("|", $row["customData"]["txn"]["from"]);
        $localAcctKey = array(
          "accountnumber" => $row['customData']['txn']['frommember'],
          "recordtype" => $row['customData']['txn']['fromtype']
        );
        if ($localAcctKey['recordtype'] == "D") {
          $localAcctKey['accounttype'] = $row['customData']['txn']['fromsuffix'];
          $localAcctKey['certnumber'] = $localAcctId[3];
        } else if ($localAcctKey['recordtype'] == "L" || $localAcctKey['recordtype'] == "C") {
          $localAcctKey['loannumber'] = $row['customData']['txn']['fromsuffix'];
        }
        $localAcctDisp = GetMemberDescription($dbh, $Cu, $Uid, $localAcctKey);
        if ($localAcctKey['recordtype'] == "D") {
          $localAcctDesc = getAccountDescription($dbh, $Cu, $localAcctKey['accountnumber'], $localAcctDisp['description'], $localAcctKey['accounttype'], $localAcctDisp['display_name'],
            $flagset3, $localAcctKey['certnumber']);
        } else if ($localAcctKey['recordtype'] == "L" || $localAcctKey['recordtype'] == "C") {
          $localAcctDesc = getAccountDescription($dbh, $Cu, $localAcctKey['accountnumber'], $localAcctDisp['description'], $localAcctKey['loannumber'], $localAcctDisp['display_name'],
            $flagset3, $row["from_certnumber"]);
        }
      }
      $externalAcctDesc = trim($extAccount["display_name"]);
      $externalAcctRouting = trim($extAccount["remote_info"]["rdfi"]["routing"]);
      $externalAcctAccount = trim($extAccount["remote_info"]["rdfi"]["account"]);
      $trnAmnt = money_format('$%i', $row['customData']['txn']["amount"]);
      $trnMemo = $row['customData']['txn']["memo"];
    } else {
      $row["area1Label"] = $MC->msg($trnDir == "from" ? "ACH From Account" : "From", HCU_DISPLAY_AS_JS);
      $row["area2Label"] = $MC->msg($trnDir == "to" ? "ACH To Account" : "To", HCU_DISPLAY_AS_JS);

      if ($trnDir == "from")
      {
        $externalAcctId = $row["customData"][0]["acct_source"];

        $localAcctKey = $row['customData'][0]['dest_key'];
        $localAcctDisp = GetMemberDescription($dbh, $Cu, $Uid, $localAcctKey);
        if ($localAcctKey['recordtype'] == "D") {
          $localAcctDesc = getAccountDescription($dbh, $Cu, $localAcctKey['accountnumber'], $localAcctDisp['description'], $localAcctKey['accounttype'], $localAcctDisp['display_name'],
            $flagset3, $localAcctKey['certnumber']);
        } else if ($localAcctKey['recordtype'] == "L" || $localAcctKey['recordtype'] == "C") {
          $localAcctDesc = getAccountDescription($dbh, $Cu, $localAcctKey['accountnumber'], $localAcctDisp['description'], $localAcctKey['loannumber'], $localAcctDisp['display_name'],
            $flagset3, $row["to_certnumber"]);
        }
      } else {
        $externalAcctId = $row["customData"][0]["acct_dest"];

        $localAcctKey = $row['customData'][0]['source_key'];
        $localAcctDisp = GetMemberDescription($dbh, $Cu, $Uid, $localAcctKey);
        if ($localAcctKey['recordtype'] == "D") {
          $localAcctDesc = getAccountDescription($dbh, $Cu, $localAcctKey['accountnumber'], $localAcctDisp['description'], $localAcctKey['accounttype'], $localAcctDisp['display_name'],
            $flagset3, $localAcctKey['certnumber']);
        } else if ($localAcctKey['recordtype'] == "L" || $localAcctKey['recordtype'] == "C") {
          $localAcctDesc = getAccountDescription($dbh, $Cu, $localAcctKey['accountnumber'], $localAcctDisp['description'], $localAcctKey['loannumber'], $localAcctDisp['display_name'],
            $flagset3, $row["to_certnumber"]);
        }
      }

      $externalAcctDesc = trim($externalAcctId["remote_entity"]["name"]);
      $externalAcctRouting = trim($externalAcctId["rdfi"]["rdfi_routing"]);
      $externalAcctAccount = trim($externalAcctId["rdfi"]["rdfi_account"]);
      $trnAmnt = money_format('$%i', $row["fullAmount"]);
      $trnMemo = $row["memo"];
    }

    if ($trnDir == "from") {
      $row['area1Text'] = $externalAcctDesc;
      $row['area2Text'] = $localAcctDesc;

      // setup details display
      $row["details"][] = array("type" => "wellStart");
      $row["details"][] = array("type" => "header", "text" => $MC->msg("ACH From Account", HCU_DISPLAY_AS_RAW));
      $row["details"][] = array("label" => $MC->msg("ACH Routing Number", HCU_DISPLAY_AS_RAW), "text" => $externalAcctRouting);
      $row["details"][] = array("label" => $MC->msg("Account #", HCU_DISPLAY_AS_RAW), "text" => ApplyMask($externalAcctAccount, $mask));
      $row["details"][] = array("label" => $MC->msg("Description", HCU_DISPLAY_AS_RAW), "text" => $externalAcctDesc);
      $row["details"][] = array("type" => "wellEnd");
    } else {
      $row["details"][] = array("label" => $MC->msg("ACH From Account", HCU_DISPLAY_AS_RAW), "text" => $localAcctDesc);
    }

    if ($trnDir == "to") {
      $row['area1Text'] = $localAcctDesc;
      $row['area2Text'] = $externalAcctDesc;

      // setup details display
      $row["details"][] = array("type" => "wellStart");
      $row["details"][] = array("type" => "header", "text" => $MC->msg("ACH To Account", HCU_DISPLAY_AS_RAW));
      $row["details"][] = array("label" => $MC->msg("ACH Routing Number", HCU_DISPLAY_AS_RAW), "text" => $externalAcctRouting);
      $row["details"][] = array("label" => $MC->msg("Account #", HCU_DISPLAY_AS_RAW), "text" => ApplyMask($externalAcctAccount, $mask));
      $row["details"][] = array("label" => $MC->msg("Description", HCU_DISPLAY_AS_RAW), "text" => $externalAcctDesc);
      $row["details"][] = array("type" => "wellEnd");
    } else {
      $row["details"][] = array("label" => $MC->msg("ACH To Account", HCU_DISPLAY_AS_RAW), "text" => $localAcctDesc);
    }

    $row["area3"] = $trnAmnt;
    if ($isScheduled) {
      $row["area3"] .= " " . trim($row["recurringIntervalText"]);
      //adding label for interval
      $row["interval"] = trim($row["recurringIntervalText"]);
    }

    // setup details display
    $row["details"][] = array("label" => $MC->msg("Amount", HCU_DISPLAY_AS_RAW), "text" => $trnAmnt);
    $row["details"][] = array("label" => $MC->msg("Comment", HCU_DISPLAY_AS_RAW), "text" => $trnMemo);
  }

  /**
   * function translateTRNM2M(&$row, $isScheduled, $extAccount, $MC)
   * This populates the four areas iff the feature_code is TRNM2M. The FROM account
   * will always be a local account; only the TO account is an external member.
   *
   * @param $row -- the scheduled transaction or regular transaction record from the getRegularTransactionsTable or getScheduledTransactionsTable queries.
   * @param $isScheduled -- if true, the row comes from the scheduled transaction query versus the regular transaction query.
   * @param $extAccount -- the external account record for details.
   * @param $MC -- the dictionary for translating.
   * @param $dbh -- the database connection (needed for getting the mask variable.)
   * @param $Cu -- the credit union
   * @param $flagset3 -- contains the two flags needed for determining account descriptions.
   */
  function translateTRNM2M(&$row, $isScheduled, $extAccount, $MC, $dbh, $Cu, $Uid, $flagset3) {
    $localAcctId = $localAcctKey = $localAcctDisp = $localAcctDesc = null;
    $externalAcctId = $externalAcctDesc = $externalAcctRouting = $externalAcctAccount = null;
    $trnAmnt = $trnMemo = null;

    $mask = GetMask($dbh, $Cu);
    $mask = $mask["code"] != 0 ? array("start" => -2) : $mask["data"]; // Just return the default mask in this case.

    $trnDir = "to";

    $row["area1Label"] = $MC->msg("From", HCU_DISPLAY_AS_JS);
    $row["area2Label"] = $MC->msg("To", HCU_DISPLAY_AS_JS);

    if ($isScheduled) {
      // M2M accounts only go from local to M2M
      $localAcctId = explode("|", $row["customData"]["txn"]["from"]);
      $localAcctKey = array(
        "accountnumber" => $row['customData']['txn']['frommember'],
        "recordtype" => $row['customData']['txn']['fromtype']
      );
      if ($localAcctKey['recordtype'] == "D") {
        $localAcctKey['accounttype'] = $row['customData']['txn']['fromsuffix'];
        $localAcctKey['certnumber'] = $localAcctId[3];
      } else if ($localAcctKey['recordtype'] == "L" || $localAcctKey['recordtype'] == "C") {
        $localAcctKey['loannumber'] = $row['customData']['txn']['fromsuffix'];
      }
      $localAcctDisp = GetMemberDescription($dbh, $Cu, $Uid, $localAcctKey);
      if ($localAcctKey['recordtype'] == "D") {
        $localAcctDesc = getAccountDescription($dbh, $Cu, $localAcctKey['accountnumber'], $localAcctDisp['description'], $localAcctKey['accounttype'], $localAcctDisp['display_name'],
          $flagset3, $localAcctKey['certnumber']);
      } else if ($localAcctKey['recordtype'] == "L" || $localAcctKey['recordtype'] == "C") {
        $localAcctDesc = getAccountDescription($dbh, $Cu, $localAcctKey['accountnumber'], $localAcctDisp['description'], $localAcctKey['loannumber'], $localAcctDisp['display_name'],
          $flagset3, $row["from_certnumber"]);
      }

      $externalAcctDesc = trim($extAccount["display_name"]);
      $externalAcctAccount = trim($extAccount["remote_info"]["rdfi"]["account"]);
      $externalAcctName = trim($extAccount["remote_info"]["rdfi"]["name"]);

      $trnAmnt = money_format('$%i', $row['customData']['txn']["amount"]);
      $trnMemo = $row['customData']['txn']["memo"];
    } else {
      // M2M accounts only go from local to M2M
      $externalAcctId = $row["customData"][0]["acct_dest"];

      $localAcctKey = $row['customData'][0]['source_key'];
      $localAcctDisp = GetMemberDescription($dbh, $Cu, $Uid, $localAcctKey);
      if ($localAcctKey['recordtype'] == "D") {
        $localAcctDesc = getAccountDescription($dbh, $Cu, $localAcctKey['accountnumber'], $localAcctDisp['description'], $localAcctKey['accounttype'], $localAcctDisp['display_name'],
          $flagset3, $localAcctKey['certnumber']);
      } else if ($localAcctKey['recordtype'] == "L" || $localAcctKey['recordtype'] == "C") {
        $localAcctDesc = getAccountDescription($dbh, $Cu, $localAcctKey['accountnumber'], $localAcctDisp['description'], $localAcctKey['loannumber'], $localAcctDisp['display_name'],
          $flagset3, $row["to_certnumber"]);
      }

      $externalAcctDesc = trim($row['customData'][0]["dest_key"]["display_name"]);
      $externalAcctAccount = trim($row['customData'][0]["dest_key"]["accountnumber"]);
      $externalAcctName = trim($row['customData'][0]["dest_key"]["name"]);

      $trnAmnt = money_format('$%i', $row["fullAmount"]);
      $trnMemo = $row["memo"];
    }

    $row["details"][] = array("label" => $MC->msg("From Account", HCU_DISPLAY_AS_RAW), "text" => $localAcctDesc);

    $row['area1Text'] = $localAcctDesc;
    $row['area2Text'] = $externalAcctDesc;

    // setup details display
    $row["details"][] = array("type" => "wellStart");
    $row["details"][] = array("type" => "header", "text" => $MC->msg("ACH To Account", HCU_DISPLAY_AS_RAW));
    $row["details"][] = array("label" => $MC->msg("Account #", HCU_DISPLAY_AS_RAW), "text" => ApplyMask($externalAcctAccount, $mask));
    $row["details"][] = array("label" => $MC->msg("Description", HCU_DISPLAY_AS_RAW), "text" => $externalAcctDesc);
    $row["details"][] = array("label" => $MC->msg("EXT Name On Account", HCU_DISPLAY_AS_RAW), "text" => $externalAcctName);
    $row["details"][] = array("type" => "wellEnd");

    $row["area3"] = $trnAmnt;
    if ($isScheduled) {
      $row["area3"] .= " " . trim($row["recurringIntervalText"]);
      //adding label for interval
      $row["interval"] = trim($row["recurringIntervalText"]);
    }

    // setup details display
    $row["details"][] = array("label" => $MC->msg("Amount", HCU_DISPLAY_AS_RAW), "text" => $trnAmnt);
    $row["details"][] = array("label" => $MC->msg("Comment", HCU_DISPLAY_AS_RAW), "text" => $trnMemo);
  }

  /**
   * function translateACH(&$row, $isScheduled, $MC)
   * This populates the four areas iff the feature_code is ACHCOL or ACHPMT.
   *
   * @param $row -- the scheduled transaction or regular transaction record from the getRegularTransactionsTable or getScheduledTransactionsTable queries.
   * @param $isScheduled -- if true, the row comes from the scheduled transaction query versus the regular transaction query.
   * @param $featureCode -- the feature code.  Can only be ACHCOL or ACHPMT.
   * @param $MC -- the dictionary for translating.
   * @param $dbh -- the database connection (needed for getting the mask variable.)
   * @param $Cu -- the credit union
   * @param $flagset3 -- contains the two flags needed for determining account descriptions.
   */
  function translateACH(&$row, $partnerRow, $isScheduled, $featureCode, $MC, $dbh, $Cu, $Uid, $flagset3) {
    $localAcctId = $localAcctKey = $localAcctDisp = $localAcctDesc = $localAcctNum = null;
    $externalAcctId = $externalAcctDesc = $externalAcctRouting = $externalAcctAccount = null;
    $trnAmnt = $trnMemo = null;

    $mask = GetMask($dbh, $Cu);
    $mask = $mask["code"] != 0 ? array("start" => -2) : $mask["data"]; // Just return the default mask in this case.

    $row["area1Label"] = $MC->msg($featureCode == "ACHCOL" ? "Deposit into" : "Withdrawal from", HCU_DISPLAY_AS_JS);
    if ($isScheduled) {
      $localAcctId = $row["area1Text"] = $featureCode == "ACHCOL" ?
        explode("|", $row['customData']['txn']['to']) :
        explode("|", $row['customData']['txn']['from']);

      $localAcctKey = array(
        "accountnumber" => $localAcctId[1],
        "recordtype" => $localAcctId[0]
      );

      if ($localAcctKey['recordtype'] == "D") {
        $localAcctKey['accounttype'] = $localAcctId[2];
        $localAcctKey['certnumber'] = $localAcctId[3];
      } else if ($localAcctKey['recordtype'] == "L" || $localAcctKey['recordtype'] == "C") {
        $localAcctKey['loannumber'] = $localAcctId[2];
      }

      $localAcctNum = ApplyMask($localAcctKey['accountnumber'], $mask);
      $localAcctDisp = GetMemberDescription($dbh, $Cu, $Uid, $localAcctKey);
      if ($localAcctKey['recordtype'] == "D") {
        $localAcctDesc = getAccountDescription($dbh, $Cu, $localAcctKey['accountnumber'], $localAcctDisp['description'], $localAcctKey['accounttype'], $localAcctDisp['display_name'],
                                               $flagset3, $localAcctKey['certnumber']);
      } else if ($localAcctKey['recordtype'] == "L" || $localAcctKey['recordtype'] == "C") {
        $localAcctDesc = getAccountDescription($dbh, $Cu, $localAcctKey['accountnumber'], $localAcctDisp['description'], $localAcctKey['loannumber'], $localAcctDisp['display_name'],
                                              $flagset3, $row["to_certnumber"]);
      }

      $trnAmnt = money_format('$%i', $row["customData"]["txn"]["amount"]) . " " . trim($row["recurringIntervalText"]);

      $trnMemo = $row["customData"]['txn']['memo'];
      $externalAcctDesc = ApplyMask($partnerRow["dfi_data"]["dfi_account"], $mask);
    } else {

      $localAcctKey = $row["area1Text"] = $featureCode == "ACHCOL" ?
        $row['customData'][0]['dest_key'] :
        $row['customData'][0]['source_key'];

      $localAcctNum = ApplyMask($localAcctKey['accountnumber'], $mask);
      $localAcctDisp = GetMemberDescription($dbh, $Cu, $Uid, $localAcctKey);
      if ($localAcctKey['recordtype'] == "D") {
        $localAcctDesc = getAccountDescription($dbh, $Cu, $localAcctKey['accountnumber'], $localAcctDisp['description'], $localAcctKey['accounttype'], $localAcctDisp['display_name'],
                                               $flagset3, $localAcctKey['certnumber']);
      } else if ($localAcctKey['recordtype'] == "L" || $localAcctKey['recordtype'] == "C") {
        $localAcctDesc = getAccountDescription($dbh, $Cu, $localAcctKey['accountnumber'], $localAcctDisp['description'], $localAcctKey['loannumber'], $localAcctDisp['display_name'],
                                              $flagset3, $row["to_certnumber"]);
      }

      $externalAcctDesc = isset($row["memo"]) ? trim($row["memo"]) : "";
      $notSoLocal = $featureCode == "ACHCOL" ? $row["customData"][0]["acct_source"] : $row["customData"][0]["acct_dest"];

      if ($row["area2Text"] == "") {
          $acct = ApplyMask($notSoLocal["rdfi"]["rdfi_account"], $mask);

        if (count($row["customData"]) > 1) {
          $externalAcctDesc = $MC->msg("ACH Batch", HCU_DISPLAY_AS_JS);
        } else {
          $externalAcctDesc = $acct;
        }
      }
      $trnAmnt = money_format('$%i', $row["fullAmount"]);
      $trnMemo = $row['memo'];
    }

    $row['area1Text'] = $localAcctDesc;
    $row['area2Text'] = $externalAcctDesc;
    $row['area3'] = $trnAmnt;

    // SETUP DETAILS DISPLAY
    $localAccountLabel = $MC->msg($featureCode == "ACHCOL" ? "ACH To Account" : "ACH From Account", HCU_DISPLAY_AS_RAW);
    $localSubaccountLabel = $MC->msg($featureCode == "ACHCOL" ? "ACH To Sub-Account" : "ACH From Sub-Account", HCU_DISPLAY_AS_RAW);

    $row["details"][] = array("type" => "wellStart");
    $row["details"][] = array("type" => "header", "text" => $row["feature"]);
    $row["details"][] = array("label" => $localAccountLabel, "text" => $localAcctNum);
    $row["details"][] = array("label" => $localSubaccountLabel, "text" => $localAcctDesc);
    $row["details"][] = array("label" => $MC->msg("Total Amount", HCU_DISPLAY_AS_RAW), "text" => $trnAmnt);
    $row["details"][] = array("label" => $MC->msg("ACH Memo", HCU_DISPLAY_AS_RAW), "text" => $trnMemo);
    $row["details"][] = array("type" => "wellEnd");

    $customDataCount = count($row["customData"]);
    foreach($row["customData"] as $index => $partner) {
      $row["details"][] = array("type" => "altGroupStart");

      if ($isScheduled) {
        $email = $partnerRow["address"]["email"];
        $address1 = $partnerRow["address"]["address1"];
        $address2 = $partnerRow["address"]["address2"];
        $city = trim($partnerRow["address"]["city"]);
        $state = trim($partnerRow["address"]["state"]);
        $zip = trim($partnerRow["address"]["zip"]);
        $address3 = $city == "" ? ($state == "" ? "" : $state) : ($state == "" ? $city : "$city, $state");
        $address3 = $address3 == "" ? $zip : "$address3 $zip";
        $routing = $partnerRow["dfi_data"]["dfi_routing"];
        $account = ApplyMask($partnerRow["dfi_data"]["dfi_account"], $mask);
        $accounttype = $partnerRow["dfi_data"]["dfi_account_type"];
        $addenda = $row['customData']['txn']['addenda'];
        $amount = $partner["amount"];
      } else {
        $notSoLocal = $featureCode == "ACHCOL" ? "acct_source" : "acct_dest";
        $dfi = $partner[$notSoLocal]["rdfi"];
        $rem = $partner[$notSoLocal]["remote_entity"];
        $name = $rem["name"];
        $email = $rem["email"];
        $address1 = $rem["address1"];
        $address2 = $rem["address2"];
        $address3 = ""; // TODO: this information is not saved here.
        $routing = $dfi["rdfi_routing"];
        $account = ApplyMask($dfi["rdfi_account"], $mask);
        $accounttype = $dfi["rdfi_account_type"];
        $addenda = $dfi["addenda"];
        $amount = $partner["amount"];
      }

      switch($accounttype) {
        case 10: $accounttype = $MC->msg("ACH Checking", HCU_DISPLAY_AS_JS); break;
        case 20: $accounttype = $MC->msg("ACH Savings", HCU_DISPLAY_AS_JS); break;
        default: $accounttype = "";
      }

      if (!$isScheduled && $customDataCount > 1) {
        $row["details"][] = array("type" => "header", "text" => $name);
      }

      $row["details"][] = array("label" => $MC->msg("Amount", HCU_DISPLAY_AS_RAW), "text" => money_format('$%i', $amount));
      $row["details"][] = array("label" => $MC->msg("Email", HCU_DISPLAY_AS_RAW), "text" => $email);
      $row["details"][] = array("type" => "address", "label" => $MC->msg("ACH Address", HCU_DISPLAY_AS_RAW), "addresses" => array($address1, $address2, $address3));
      $row["details"][] = array("label" => $MC->msg("ACH Routing Number", HCU_DISPLAY_AS_RAW), "text" => $routing);
      $row["details"][] = array("label" => $MC->msg("Account", HCU_DISPLAY_AS_RAW), "text" => $account);
      $row["details"][] = array("label" => $MC->msg("Account Type", HCU_DISPLAY_AS_RAW), "text" => $accounttype);
      $row["details"][] = array("label" => $MC->msg("ACH Addenda", HCU_DISPLAY_AS_RAW), "text" => $addenda);

      $row["details"][] = array("type" => "altGroupEnd");
    }
  }

  /**
   * function translateCleanup(&$row, $isScheduled)
   * This function removes all attributes of the row that were needed to calculate the details and areas and are not being used for the actual grid.
   * It also adds attributes needed to parse details.
   *
   * @param $row -- the scheduled transaction or regular transaction record from the getRegularTransactionsTable or getScheduledTransactionsTable queries.
   * @param $isScheduled -- if true, the row comes from the scheduled transaction query versus the regular transaction query.
   */
  function translateCleanup(&$row, $isScheduled) {
    unset($row["customData"]);
    unset($row["amount"]);
    unset($row["to_desc"]);
    unset($row["from_desc"]);
    unset($row["fromid"]);
    unset($row["toid"]);
    unset($row["from_accounttype"]);
    unset($row["from_acct"]);
    unset($row["from_certnumber"]);
    unset($row["from_displayname"]);
    unset($row["to_accounttype"]);
    unset($row["to_acct"]);
    unset($row["to_certnumber"]);
    unset($row["to_displayname"]);
    unset($row["processed_by"]);
    unset($row["grid"]);

    if ($isScheduled) {
      unset($row["name"]);
      unset($row["user_id"]);
      unset($row["create_date"]);
      unset($row["start_date"]);
      unset($row["end_date"]);
      unset($row["next_trigger_date"]);
      unset($row["status"]);
      unset($row["approved_date"]);
      unset($row["username"]);
      unset($row["approved_username"]);
      unset($row["approved_by"]);
      unset($row["txn_data"]);
      unset($row["repeating_parameters"]);
      unset($row["last_edit_date"]);
    } else {
      unset($row["accountnumber"]);
      unset($row["accounttype"]);
      unset($row["deposittype"]);
      unset($row["transactioncode"]);
      unset($row["effective_date"]);
      unset($row["posted_date"]);
      unset($row["memo"]);
      unset($row["posted_by"]);
      unset($row["approved_date"]);
      unset($row["username"]);
      unset($row["approved_username"]);
      unset($row["approved_by"]);
      unset($row["transdata"]);
      unset($row["processed_date"]);
      unset($row["processed_status"]);
    }

    // Need to set all possible attributes or kendo template will fail.
    for($i = 0, $count = count($row["details"]); $i != $count; $i++) {
      $detail = $row["details"][$i];
      $detail["type"] = !HCU_array_key_exists("type", $detail) || !isset($detail["type"]) ? "normalRow" : trim($detail["type"]);
      $detail["label"] = !HCU_array_key_exists("label", $detail) || !isset($detail["label"]) ? "" : trim($detail["label"]);
      $detail["text"] = !HCU_array_key_exists("text", $detail) || !isset($detail["text"]) ? "" : trim($detail["text"]);
      $detail["addresses"] = !HCU_array_key_exists("addresses", $detail) || !isset($detail["addresses"]) ? array() : $detail["addresses"];

      $addresses = array();
      foreach($detail["addresses"] as $address) {
        $addresses[] = isset($address) ? trim($address) : "";
      }
      $detail["addresses"] = $addresses;
      $row["details"][$i] = $detail;
    }
  }

  /**
   * function readActivityGrid($HB_ENV, $genErr, $parameters, $confirmPermissions, $mode="read")
   * This function gets the resultset for a particular grid.  It is the main function that calls everything for read, filter, and clearFilter data calls.
   *
   * @param $HB_ENV -- the global environment variables.
   * @param $genErr -- the generic error to return if there is any sort of error.
   * @param $parameters -- the parameters from the REQUEST.
   * @param $confirmPermissions -- map of users and what confirmation permissions they have.  (If they don't have TRN permissions, then they won't be able to see TRN records.)
   * @param $mode -- the mode to use: either "read", "clearFilter", or "filter."  Corresponds with the particular data call.
   *
   * @return array
   *         -> Results -- Has to be packaged as such because rules.
   *            :    -> homecuInfo -- The message to return saying that everything was okay (if it actually was.)
   *            :    -> homecuErrors -- This will be the generic error plus the error code
   *            :    -> homecuData -- The records returned for the grid in question
   *            :    -> sqls -- All SQL used
   */
  function readActivityGrid($HB_ENV, $genErr, $parameters, $confirmPermissions, $mode = "read") {
      // Extract the values that we need.  Don't discard the environment information because it could be needed later.
      $Cu = $HB_ENV["Cu"];
      $MC = $HB_ENV["MC"];
      $Cn = $HB_ENV["Cn"];
      $dbh = $HB_ENV["dbh"];
      $Uid = $HB_ENV["Uid"];
      $tz = $HB_ENV["tz"];
      $logger = $HB_ENV["SYSENV"]["logger"];

      if (!HCU_array_key_exists("grid", $parameters)) {
        throw new exception("Grid is not specified.", 1);
      }
      $grid = $parameters["grid"];

      $sqls = array();
      // Buffer to write own errors and see what translates into the dictionary.

      try {
        $whereTranshdr = array();
        $whereSched = array();

        $validUserIds = getValidUserIds($dbh, $Cu, $Cn, $sqls);
        $validUserIds = $validUserIds["validUserIds"];

        switch ($mode) {
          case "read": getDefaultFilter($whereTranshdr, $whereSched, $dbh, $Cu, $Cn, $validUserIds); break;
          case "clearFilter": getFilter(array(), $MC, "scheduledTransactions", $whereTranshdr, $whereSched, $dbh, $Cu, $Uid); break;
          case "filter": getFilter($parameters, $MC, "scheduledTransactions", $whereTranshdr, $whereSched, $dbh, $Cu, $Uid); break;
          default: throw new exception("Mode is not valid.", 1); break;
        }

        $tz = new DateTimeZone($tz);

        $trans = Get_HaveTrans($dbh,$HB_ENV);

        $records = array();
        getScheduledTransactionsTable($sqls, $records, $whereSched, $grid, $Uid, $dbh, $Cu, $MC, $confirmPermissions, $tz, $validUserIds, $trans, $HB_ENV["Fset3"]);

        if ($grid != "scheduledTransactions") {
          getRegularTransactionsTable($sqls, $records, $whereTranshdr, $grid, $Uid, $MC, $dbh, $Cu, $confirmPermissions, $tz, $validUserIds, $trans, $HB_ENV["Fset3"], $HB_ENV);
        }

        usort($records, $grid == "pendingApproval" ? "cmp" : "revCmp");
        gridModify($records);
      } catch(exception $e) {
        $logger->error($e->getCode() . ": " . $e->getMessage());
        return array("results" => array("homecuInfo" => array(), "homecuErrors" => array("$genErr {$e->getCode()}."), "homecuData" => array(), "sqls" => $sqls, "mode" => $mode,
          "grid" => $grid));
      }
      return array("results" => array("homecuInfo" => array(), "homecuErrors" => array(), "homecuData" => $records, "sqls" => $sqls, "mode" => $mode, "grid" => $grid));
  }

  // Align with banking's usual data returns
  // ******************************************

  header('Content-type: application/json');
  if (!$HB_ENV["SYSENV"]["devmode"])
    unset($aryReply["results"]["sqls"]);
  print HCU_JsonEncode($aryReply);