hcuUserActivity.i

<?php
/**
 * @package hcuUserActivity.data
 *
 * Packages functions needed for both hcuUserActivity.data and hcuUserActivity.prg plus the ones that would sort of be considered utility in this locale.
 */

// Drop Down List data
// *******************************

/**
 * function getActiveStatuses
 * Gets the statuses for setting the Active status filtering.
 *
 * @param $MC -- the dictionary object.
 * @return the DDL of statuses.
 */
function getActiveStatuses($MC) {
  return array(array("value" => "", "text" => $MC->msg("Any", HCU_DISPLAY_AS_HTML)),
    array("value" => "A", "text" => $MC->msg("Active", HCU_DISPLAY_AS_HTML)),
    array("value" => "I", "text" => $MC->msg("Inactive", HCU_DISPLAY_AS_HTML)));
}

/**
 * function getApprovalStatuses($MC)
 * Gets the statuses for setting the Approval status filtering.
 *
 * @param $MC -- the dictionary object.
 * @return the DDL of statuses.
 */
function getApprovalStatuses($MC)
{
  return array(array("value" => "", "text" => $MC->msg("Any", HCU_DISPLAY_AS_HTML)),
    array("value" => 10, "text" => $MC->msg("Approved", HCU_DISPLAY_AS_HTML)),
    array("value" => 99, "text" => $MC->msg("Cancelled", HCU_DISPLAY_AS_HTML)),
    array("value" => 90, "text" => $MC->msg("Declined", HCU_DISPLAY_AS_HTML)));
}

/**
 * function getActions($MC)
 * Gets the actions with filters and whatnot.
 *
 * @param $MC -- the dictionary object.
 * @return the DDL of actions.
 */
function getActions($MC) {
  return array(
    array("value" => "action", "text" => $MC->msg("Action", HCU_DISPLAY_AS_HTML)),
    array("value" => "viewDetails", "text" => $MC->msg("View Details", HCU_DISPLAY_AS_HTML)),
    array("value" => "approve", "text" => $MC->msg("Approve", HCU_DISPLAY_AS_HTML), "grids" => array("pendingApprovalGrid"), "uid" => array("without")),
    array("value" => "decline", "text" => $MC->msg("Decline", HCU_DISPLAY_AS_HTML), "grids" => array("pendingApprovalGrid"), "uid" => array("without")),
    array("value" => "cancel", "text" => $MC->msg("Cancel", HCU_DISPLAY_AS_HTML), "grids" => array("pendingApprovalGrid", "scheduledTransactionsGrid"), "uid" => array("with")),
    array("value" => "skip", "text" => $MC->msg("Skip", HCU_DISPLAY_AS_HTML), "grids" => array("scheduledTransactionsGrid"), "uid" => array("with")));
}

/**
 * function getApprovalList()
 * Gets the approved features for approval and whatnot.
 *
 * @return the list of approved features for approval.
 */
function getApprovalList() {
  return array("TRN", "ACHPMT", "ACHCOL", "TRNEXT", "TRNM2M");
}

// Helper functions
// *******************************

/**
 * function parseWhere($where, $whereBase, $whereBase)
 * This helps with the where clauses in the filter.
 *
 * @param $where -- the list of to/from pairs or singles.
 * @param $whereBase -- the list of feature/statuses.
 * @return string of the full where clause.
 */
function parseWhere($where, $whereBase) {
  foreach($where as $whereCode => $whereRecord) {
    $where[$whereCode] = implode(" and ", $whereRecord);
  }

  $where = (count($where) > 0 ? "((" . implode(") or (", $where) . ")) " : "");
  $whereBase = (count($whereBase) > 0 ? implode(" and ", $whereBase) : "");
  $whereAll = $where != "" ? ($whereBase != "" ? "$where and $whereBase" : $where) : ($whereBase != "" ? $whereBase : "");
  return $whereAll;
}

/**
 * function addCustomData($key, &$row)
 * Adds the custom data to the row.
 *
 * @param $key -- the key to append.
 * @param $row -- the row to append the key to.
 */
function addCustomData($key, &$row) {
  if ($row[$key] == null) {
    $customData = array("string" => "");
  } else {
    $customData = HCU_JsonDecode($row[$key]);
    if (!is_array($customData)) {
      $customData = array("string" => trim($row[$key]));
    } else if (count($customData) == 0) {
      $customData = array("string" => "");
    }
  }

  unset($row[$key]);
  return $customData;
}

/**
 * function gridModify(&$grid)
 * Modifies the grid to add kendoId to the recordset.  This is done after the sort so it is the real order.
 *
 * @param $grid -- the grid data to modify.
 */
function gridModify(&$grid) {
  for($i = 0, $count = count($grid); $i != $count; $i++) {
    unset($grid[$i]["dateSortObj"]);
    unset($grid[$i]["isscheduled"]);

    foreach($grid[$i] as $key => $value) {
      $grid[$i][$key] = isset($value) ? (!is_array($value) ? trim($value) : $value) : "";
    }

    $grid[$i]["kendoId"] = $i + 1;
    $grid[$i]["amount"] = isset($grid[$i]["amount"]) ? floatval($grid[$i]["amount"]) : 0; // Set to zero.  Use this value in the template which throws an exception if it is null.
  }
}

/**
 * function getIntervalLookup($MC)
 * Converts the TxIntervalList in an format for usage in a DDL.
 *
 * @param $MC -- the dictionary for translation.
 * @return array(array("text" => $text, "value" => $value), ...)
 */
function getIntervalLookup($MC) {
  $intervalList = TxIntervalList($MC);
  foreach($intervalList as $interval) {
    $value = trim($interval["value"]);
    $intervalLookup[$value] = trim($interval["text"]);
  }
  return $intervalLookup;
}


/**
 * getFeatures($dbh, $Cu, &$sqls, $MC)
 * Gets the enabled features for the credit union.
 *
 * @param $dbh -- the database connection
 * @param $Cu -- the credit union
 * @param $sqls -- the list of SQLs
 * @param $MC -- the dictionary object
 *
 * @return a DDL of all the relevant features.
 */
function getFeatures($dbh, $Cu, &$sqls, $MC, $Uid) {
    // Get a list of features that currently used by the Credit Union.
    $sql = "
      SELECT DISTINCT f.feature_code AS value, f.description AS text
      FROM cu_feature f
      RIGHT JOIN cu_featuremenu fm ON f.feature_code = fm.feature_code
      INNER JOIN cu_profilerights pr ON fm.feature_code = pr.feature_code
      INNER JOIN {$Cu}group g ON pr.profile_id = g.profile_id
      INNER JOIN {$Cu}user u ON g.group_id = u.group_id
      WHERE u.user_id = $Uid
        AND fm.feature_code IN ('TRN', 'TRNEXT', 'TRNM2M', 'ACHPMT', 'ACHCOL', 'TRNWIRE')
      ORDER BY f.description";
    $sqls[] = $sql;
    $sth = db_query($sql, $dbh);
    if (!$sth) {
      throw new exception("feature query failed.", 504);
    }
    $featureDDL = array(array("value" => "", "text" => $MC->msg("All", HCU_DISPLAY_AS_HTML)));
    for($i = 0; $row = db_fetch_assoc($sth, $i); $i++) {
      // Translate the "Funds Transfer", "External Accounts", etc.
      $feature = $MC->msg("CU feature " . $row["value"], HCU_DISPLAY_AS_RAW);
      $row["text"] = isset($feature) ? $feature : $row["text"]; // If the dictionary exists, use it.  Otherwise, use the value in the database.

      $featureDDL[] = $row;
    }
    return $featureDDL;
}

/**
 * function getValidUserIds($dbh, $Cu, $Cn, &$sqls)
 * Gets the valid user ids (from the group of the current user.)
 *
 * @param $dbh -- the database connection
 * @param $Cu -- the credit union
 * @param $Cn -- the logged in user
 * @param $sqls -- the SQLs used
 *
 * @return the list of all valid users.
 */
function getValidUserIds($dbh, $Cu, $Cn, &$sqls) {
    // Query to see the users in a particular group.  Other queries will be limited to these users.
    $sql = "select b.user_id from ${Cu}user a inner join ${Cu}user b on a.user_name = '" . prep_save($Cn, 50) . "' and a.group_id = b.group_id";
    $sqls[] = $sql;
    $sth = db_query($sql, $dbh);
    if (!$sth) {
      throw new exception("group query failed.", 602);
    }
    $validUserIds = array();

    for($i = 0; $row = db_fetch_row($sth, $i); $i++) {
      $validUserIds[] = intval($row[0]);
    }
    $showPendingApprovalGrid = count($validUserIds) > 1;
    return array("showPendingApprovalGrid" => $showPendingApprovalGrid, "validUserIds" => "(" . implode(",", $validUserIds) . ")");
}

/**
 * function getDateTime($datestring)
 * Gets the dateTime object for a date string.  This is needed to sort on the PHP side.
 *
 * @param $datestring -- the date in string format
 * @return DateTime $dateTime -- the dateTime object
 */
function getDateTime($datestring) {
  // Date may appear without the microseconds or without the timepart.
  $dateTime = DateTime::createFromFormat("Y-m-d h:i:s.u+", $datestring);
  $dateTime = !$dateTime ? DateTime::createFromFormat("Y-m-d h:i:s+", $datestring) : $dateTime;
  $dateTime = !$dateTime ? DateTime::createFromFormat("Y-m-d+", $datestring) : $dateTime;

  // If it doesn't fit that, set it to 1970 for comparison.
  $dateTime = !$dateTime ? new DateTime("@1") : $dateTime;
  return $dateTime;
}

function getValidDate($datestring, $tz, $setTimezone = true) {
  $dateTime = isset($datestring) && trim($datestring) != "" ? new DateTime($datestring) : null;
  // If it is a type of "date" in the database, timezone is set to zero so display shows as the previous day.
  // If it is a type of "timestamp" in the database, then we do need to adjust.
  if ($setTimezone && isset($dateTime)) {
    $dateTime->setTimezone($tz);
  }
  return $dateTime;
}

// Sort functions
// ********************************

/**
 * function cmp($a, $b)
 * compares two dates and puts the oldest first
 * @param $a -- the first object to compare
 * @param $b -- the second object to compare
 * @return 1, 0, -1
 */
function cmp($a, $b) {
  $aCmp = $a["dateSortObj"];
  $bCmp = $b["dateSortObj"];

  return $aCmp > $bCmp ? 1 : ($aCmp < $bCmp ? -1 : 0);
}

/**
 * function revCmp($a, $b)
 * compares two dates and puts the newest first
 * @param $a -- the first object to compare
 * @param $b -- the second object to compare
 * @return 1, 0, -1
 */
function revCmp($a, $b) {
  $aCmp = $a["dateSortObj"];
  $bCmp = $b["dateSortObj"];

  return $aCmp > $bCmp ? -1 : ($aCmp < $bCmp ? 1 : 0);
}

/**
 * function getGFormat($dateString)
 * This function gets a string version of the date that looks like "kendo.toString(date, 'g')."
 *
 * @param $dateString -- the string of the date coming from the database.
 * @return formatted date string.
 */
function getGFormat() {
  return "n/j/Y g:i A";
}

/**
 * function getDFormat($dateString)
 * This function gets a string version of the date that looks like "kendo.toString(date, 'd')."
 *
 * @param $dateString -- the string of the date coming from the database.
 * @return formatted date string.
 */
function getDFormat() {
  return "n/j/Y";
}

/************* New Entrypoints **************/

/**
 * function GetUserActivity
 * After checking permissions, figure out what the user wants and get that information. This
 * function does not get details.
 *
 * @param $pHBEnv -- the current environment
 * @param $pWhichActivity -- the requested operation (e.g. scheduled, details, prior, pending)
 * @param $pParams -- paramters for the operation
 *
 * filter info:
 *  $pParams["filter"]["start"]     - date start (needed if not detail) - this is the earlier date
 *  $pParams["filter"]["end"]       - date ended (needed if not detail) - this is the later date
 *  $pParams["filter"]["type"]      - type of transaction (feature_code: eg TRNEXT)
 *
 * @return The requested information
 */
function GetUserActivity( $pHBEnv, $pWhichActivity, $pParams ) {
  $returnData = array( "code" => "000", "error" => "", "data" => array() );

  try {
    // Check 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();
    $results = Perm_FeatureAccessList( $pHBEnv["dbh"], $pHBEnv );
    if ( !intval($results["status"]["code"] ) == 0) {
      throw new exception($results["status"]["error"] . " 1404");
    }

    // the rights for this user will be returned
    $permissions = $results["data"][$pHBEnv["Uid"]];

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

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

    if ( !$confirmFound )
    {
      $sql= "SELECT 'FOUND' FROM {$pHBEnv["Cu"]}user a
             INNER JOIN {$pHBEnv["Cu"]}user b ON a.user_id = {$pHBEnv["Uid"]}
               AND a.group_id = b.group_id
               AND a.user_id <> b.user_id";
      $sth = db_query($sql, $pHBEnv["dbh"]);
      if (!$sth) {
        throw new exception("Error checking if multiple users found" . " 1403");
      }
      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" . " 1402");
      }
    }

    // get the requested information
    if ( $pWhichActivity == "prior" ) {
      $result = _GetUserActivityPrior( $pHBEnv, $pParams );
    } else if ( $pWhichActivity == "scheduled" ) {
      $result = _GetUserActivityScheduled( $pHBEnv, $pParams );
    } else if ( $pWhichActivity == "pending" ) {
      $result = _GetUserActivityPending( $pHBEnv, $pParams, $confirmPermissions );
    } else {
      // unexpected activity
      throw new exception( $pHBEnv["MC"]->msg( "Feature Unavailable", HCU_DISPLAY_AS_RAW ) . " 1401");
    }

    if ( $result["code"] != "000" ) {
      throw new exception( $result["error"] );
    }

    $returnData["data"] = $result["data"];

  } catch (Exception $e) {
    // get the message
    $message = $e->getMessage();

    $returnData["code"] = "999";
    $returnData["error"] = $message;
  }

  return $returnData;
} // end GetUserActivity

/**
 * function GetActivityDetail
 * Get the detail for the given type of transaction from the cu_scheduledtxn table.
 *
 * @param $pHBEnv       -- the current environment
 * @param $pTxnId       -- the transaction item wanting detail for
 * @param $pIsScheduled -- flag if scheduled or not (to know which table)
 *
 * @return The requested information
 */
function GetActivityDetail( $pHBEnv, $pTxnId, $pIsScheduled ) {
  if ( $pIsScheduled ) {
    $returnInfo = _GetActivityDetailScheduled( $pHBEnv, $pTxnId );
  } else {
    $returnInfo = _GetActivityDetailRegular( $pHBEnv, $pTxnId );
  }

  return $returnInfo;
} // end GetActivityDetail

/**
 * function _GetActivityDetailRegular
 * Get the detail for the given type of transaction from the {cu}transhdr/dtl tables.
 *
 * @param $pHBEnv -- the current environment
 * @param $pTxnId -- the transaction item wanting detail for
 *
 * @return The requested information
 */
function _GetActivityDetailRegular( $pHBEnv, $pTxnId ) {
  $returnData = array( "code" => "000", "error" => "", "data" => array() );

  try {
    // get the account number mask, in case we need it
    $accountMask = GetMask( $pHBEnv["dbh"], $pHBEnv["Cu"] );

    // get the requested information, making sure it really is for this user
    $sql = "SELECT h.*, u.user_name, a.user_name as approve_name, u.group_id as user_group, t.group_id as test_group
            FROM {$pHBEnv["Cu"]}transhdr h
            INNER JOIN {$pHBEnv["Cu"]}user u ON u.user_id = h.posted_by
            INNER JOIN {$pHBEnv["Cu"]}user t ON t.user_id = {$pHBEnv["Uid"]}
            LEFT JOIN {$pHBEnv["Cu"]}user a ON a.user_id = h.approved_by
            WHERE h.id = $pTxnId";

    $sth = db_query( $sql, $pHBEnv["dbh"] );
    if (!$sth) {
      throw new exception($pHBEnv["MC"]->msg( "ACH Query Error", HCU_DISPLAY_AS_RAW ) . " 1412");
    }

    $headerRow = db_fetch_assoc($sth, 0);

    if ( $headerRow["user_group"] != $headerRow["test_group"] ) {
      throw new exception($pHBEnv["MC"]->msg( "Invalid account access", HCU_DISPLAY_AS_RAW ) . " 1413");
    }

    $approvedStatus = intval( $headerRow["approved_status"] );

    // get all the details for this transaction
    $sql = "SELECT d.*
            FROM {$pHBEnv["Cu"]}transdtl d
            WHERE transhdr_id = $pTxnId";

    $sth = db_query( $sql, $pHBEnv["dbh"] );
    if (!$sth) {
      throw new exception($pHBEnv["MC"]->msg( "ACH Query Error", HCU_DISPLAY_AS_RAW ) . " 1414");
    }

    $detailRows = db_fetch_all($sth);

    // this information is common to all types
    $transDetail = array();

    $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Created On", HCU_DISPLAY_AS_RAW ),
                       "value" => date( "m/d/Y g:ia", strtotime( $headerRow["posted_date"] ) ) );
    $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Created By", HCU_DISPLAY_AS_RAW ),
                       "value" => $headerRow["user_name"] );
    if ( $approvedStatus == 90 ) {
      $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Declined on", HCU_DISPLAY_AS_RAW ),
                         "value" => date( "m/d/Y g:ia", strtotime( $headerRow["approved_date"] ) ) );
      $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Declined by", HCU_DISPLAY_AS_RAW ),
                         "value" => $headerRow["approve_name"] );

    } else if ( $approvedStatus == 99 ) {
      $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Cancelled on", HCU_DISPLAY_AS_RAW ),
                         "value" => date( "m/d/Y g:ia", strtotime( $headerRow["approved_date"] ) ) );
      $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Cancelled by", HCU_DISPLAY_AS_RAW ),
                         "value" => $headerRow["approve_name"] );
    } else if ( $approvedStatus > 0 ) {
      // only show approval info if different user
      if ( $headerRow["approved_by"] != $headerRow["posted_by"] ) {
        $approveTime = strtotime( $headerRow["approved_date"] );
        $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Approved on", HCU_DISPLAY_AS_RAW ),
                           "value" => date( "m/d/Y", $approveTime ) );

        $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Approved by", HCU_DISPLAY_AS_RAW ),
                           "value" => $headerRow["approve_name"] );
      }

      $processTime = strtotime( $headerRow["processed_date"] );
      if ( $processTime == 0 ) {
        $dateString = $pHBEnv["MC"]->msg( "Not processed", HCU_DISPLAY_AS_RAW );
      } else {
        $dateString = date( "m/d/Y", $processTime );
      }
      $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Processed Date", HCU_DISPLAY_AS_RAW ),
                         "value" => $dateString );
    } else if ( $approvedStatus == 0 ) {
      $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Approved by", HCU_DISPLAY_AS_RAW ),
                              "value" => $pHBEnv["MC"]->msg( "Pending Approval", HCU_DISPLAY_AS_RAW ) );
    }

    // this is used to hold the transcode in case there is an "other" type transaction.
    $trans = null;

    $transactionCode = $headerRow["transactioncode"];

    // should only be one row for now
    $txnInfo = HCU_JsonDecode( $detailRows[0]["transdata"] );

    $fromDesc = "";
    if ( in_array( $transactionCode, array("2W","2P") ) ) {
      // get the external account info; use the name on account since that is common for creator and approver
      $fromDesc = $txnInfo["acct_source"]["remote_entity"]["name"];

      $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "From", HCU_DISPLAY_AS_RAW ),
                         "value" => $fromDesc );

      // add routing and masked account number
      $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "ACH Routing Number", HCU_DISPLAY_AS_RAW ),
                         "value" => $txnInfo["acct_source"]["rdfi"]["rdfi_routing"] );

      $fromAcct = ApplyMask( $txnInfo["acct_source"]["rdfi"]["rdfi_account"], $accountMask["data"] );

      $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Account", HCU_DISPLAY_AS_RAW ),
                              "value" => $fromAcct );
    } else {
      // "1W","1P","AT","LP","LA","MM","OT","CW" - source account is internal
      $acctParts = explode( "|", $txnInfo["acct_source"] );
      $certNumber = isset( $acctParts[3] ) && $acctParts[3] > 0 ? $acctParts[3] : 0;
      $accountType = $txnInfo['source_key']['recordtype'] == "L" ? $txnInfo['source_key']['loannumber'] : $txnInfo['source_key']['accounttype'];

      $fromDesc = FindAccountDisplay( $pHBEnv, $pHBEnv["dbh"], $pHBEnv['Cu'], $txnInfo['source_key']['accountnumber'], $accountType, $txnInfo['source_key']['recordtype'], $certNumber );

      if ( $fromDesc == "" ) {
        $fromDesc = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
      }

      $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "From", HCU_DISPLAY_AS_RAW ),
                         "value" => $fromDesc );
    }

    if ( in_array( $transactionCode, array("1W","1P") ) ) {
      // get the external account info; use the name on account since that is common for creator and approver
      $toDesc = $txnInfo["acct_dest"]["remote_entity"]["name"];

      $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "To", HCU_DISPLAY_AS_RAW ),
                         "value" => $toDesc );

      // add routing and masked account number
      $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "ACH Routing Number", HCU_DISPLAY_AS_RAW ),
                         "value" => $txnInfo["acct_dest"]["rdfi"]["rdfi_routing"] );

      $toAcct = ApplyMask( $txnInfo["acct_dest"]["rdfi"]["rdfi_account"], $accountMask["data"] );

      $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Account", HCU_DISPLAY_AS_RAW ),
                              "value" => $toAcct );
    } else if ( $transactionCode == "MM" ) {
      // use the account number, masked
      // NOTE: The mask logic should all be below this routine and we shouldn't have to know the data structure.
      $toAcct = ApplyMask( $txnInfo["dest_key"]["accountnumber"], $accountMask["data"] );

      // add on the name
      $toName = $txnInfo["dest_key"]["name"];

      $toDesc = "$toAcct ($toName)";

      $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "To", HCU_DISPLAY_AS_RAW ),
                         "value" => $toDesc );

    } else if ( in_array( $transactionCode, array("OT","CW") ) ) {
      // Need to check if destination is an other
      $acctParts = explode( "|", $txnInfo["acct_dest"] );
      if ( $acctParts[0] == "O" ) {
        if ( $trans == null ) {
          $trans = Get_HaveTrans( $pHBEnv["dbh"], $pHBEnv );
        }

        $otherDesc = HCU_array_key_value($acctParts[2], $trans);

        $cuDesc = isset($otherDesc[2]) ? trim($otherDesc[2]) : "";
        $nonCUDesc = isset($otherDesc[0]) ? trim($otherDesc[0]) : "";

        $toDesc = $cuDesc != "" ? $cuDesc : $nonCUDesc;
      }

      if ( $toDesc == "" ) {
        $toDesc = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
      }

      $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "To", HCU_DISPLAY_AS_RAW ),
                         "value" => $toDesc );
    } else {
      // "2W","2P","AT","LP","LA" - destination account is internal
      $acctParts = explode( "|", $txnInfo["acct_dest"] );
      $certNumber = isset( $acctParts[3] ) && $acctParts[3] > 0 ? $acctParts[3] : 0;
      $accountType = $txnInfo['dest_key']['recordtype'] == "L" ? $txnInfo['dest_key']['loannumber'] : $txnInfo['dest_key']['accounttype'];

      $toDesc = FindAccountDisplay( $pHBEnv, $pHBEnv["dbh"], $pHBEnv['Cu'], $txnInfo['dest_key']['accountnumber'], $accountType, $txnInfo['dest_key']['recordtype'], $certNumber );

      if ( $toDesc == "" ) {
        $toDesc = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
      }

      $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "To", HCU_DISPLAY_AS_RAW ),
                         "value" => $toDesc );
    }

    // what to return depends on the type of transaction
    switch( $headerRow["feature_code"] ) {
      case "TRN":
        break;
      case "TRNEXT":
        break;
      case "TRNM2M":
        break;
      case "ACHCOL":
        break;
      case "ACHPMT":
        break;
      default:
        throw new exception($pHBEnv["MC"]->msg( "Unknown feature type", HCU_DISPLAY_AS_RAW ) . " 1415");
    }

    // these go at the end
    $amount = number_format( $detailRows[0]["amount"], 2 );
    $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Amount", HCU_DISPLAY_AS_RAW ),
                       "value" => "$" . $amount, "type" => "currency" );

    $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Comment", HCU_DISPLAY_AS_RAW ),
                            "value" => $headerRow["memo"] );


    // confirmation code is different depending on how far the txn has progressed
    $confCodeBuilder["id"] = $headerRow["id"];
    if ( $headerRow["processed_by"] != "" ) {
      // based the confirmation code on the processed info
      $confCodeBuilder["processed_by"] = "*immed*";
      $confCodeBuilder["posted_by"] = $headerRow["posted_by"];     // immediate transfers need the posted by id
      $confCodeBuilder["processed_date"] = $headerRow["processed_date"];
      $confirmationCode = GetTransferConfirmCode( $pHBEnv, "process", $confCodeBuilder );
    } else if ( $headerRow["approved_by"] != "" ) {
      // based the confirmation code on the approved info
      $confCodeBuilder["approved_by"] = $headerRow["approved_by"];
      $confCodeBuilder["approved_date"] = $headerRow["approved_date"];
      $confirmationCode = GetTransferConfirmCode( $pHBEnv, "approve", $confCodeBuilder );
    } else if ( $headerRow["posted_by"] != "" ) {
      // based the confirmation code on the posted info
      $confCodeBuilder["posted_by"] = $headerRow["posted_by"];
      $confCodeBuilder["posted_date"] = $headerRow["posted_date"];
      $confirmationCode = GetTransferConfirmCode( $pHBEnv, "post", $confCodeBuilder );
    } else {
      $confirmationCode = "";
    }

    if ( $confirmationCode != "" ) {
      $transDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Confirmation", HCU_DISPLAY_AS_RAW ),
                              "value" => $confirmationCode );
    }

    // return as ["detail"] = array( "name", "value" );
    for ( $i = 0; $i < count( $transDetail ); $i++ ) {
      $returnData["data"][]["detail"] = $transDetail[$i];
    }

  } catch (Exception $e) {
    // get the message
    $message = $e->getMessage();

    $returnData["code"] = "999";
    $returnData["error"] = $message;
  }

  return $returnData;
} // end _GetActivityDetailRegular

/**
 * function _GetActivityDetailScheduled
 * Get the detail for the given type of transaction from the cu_scheduledtxn table.
 *
 * @param $pHBEnv -- the current environment
 * @param $pTxnId -- the transaction item wanting detail for
 *
 * @return The requested information
 */
function _GetActivityDetailScheduled( $pHBEnv, $pTxnId ) {
  $returnData = array( "code" => "000", "error" => "", "data" => array() );

  try {
    // get the account number mask, in case we need it
    $accountMask = GetMask( $pHBEnv["dbh"], $pHBEnv["Cu"] );

    // get the list of transfer features to get the name
    $transferFeatureList = GetTransferFeatureList( $pHBEnv );

    // make it a lookup array
    $transferFeatures = ConvertToLookupArray( $transferFeatureList );

    // get the list of schedule intervals for display
    $recurringIntervals = getIntervalLookup( $pHBEnv["MC"] );

    // get the requested information, making sure it really is for this user
    $sql = "SELECT s.*, c.user_name as created, a.user_name as approved,
                   c.group_id as user_group, t.group_id as test_group
            FROM cu_scheduledtxn s
            INNER JOIN {$pHBEnv["Cu"]}user c ON c.user_id = s.user_id
            INNER JOIN {$pHBEnv["Cu"]}user t ON t.user_id = {$pHBEnv["Uid"]}
            LEFT JOIN {$pHBEnv["Cu"]}user a ON a.user_id = s.approved_by
            WHERE s.id = $pTxnId";

    $sth = db_query( $sql, $pHBEnv["dbh"] );
    if (!$sth) {
      throw new exception($pHBEnv["MC"]->msg( "ACH Query Error", HCU_DISPLAY_AS_RAW ) . " 1416");
    }

    $schedRow = db_fetch_assoc( $sth, 0 );

    if ( $schedRow["user_group"] != $schedRow["test_group"] ) {
      throw new exception($pHBEnv["MC"]->msg( "Invalid account access", HCU_DISPLAY_AS_RAW ) . " 1417");
    }

    /*
     * Need this info:
     * Created date/time, created by (user), approved by / date /time, start date, end date,
     * next trigger date, status, repeatingParams, scheduled transaction
     */

    $txnInfo = HCU_JsonDecode( $schedRow["txn_data"] );

    // this is the return info
    $schedDetail = array();

    // show the status first, if it is inactive
    if ( $schedRow["status"] == "I" ) {
      $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Status", HCU_DISPLAY_AS_RAW ),
                              "value" => $pHBEnv["MC"]->msg( "Inactive", HCU_DISPLAY_AS_RAW ) );
    }

    // look up the feature name
    $featureName = $transferFeatures[$schedRow["feature_code"]];
    $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Transfer", HCU_DISPLAY_AS_RAW ),
                            "value" => $featureName );

    $createTime = date( "m/d/Y g:ia", strtotime( $schedRow["create_date"] ) );
    $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Created On", HCU_DISPLAY_AS_RAW ),
                            "value" => $createTime );

    $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Created By", HCU_DISPLAY_AS_RAW ),
                            "value" => $schedRow["created"] );

    $status = $schedRow["approved_status"];

    if ( strlen( trim( $schedRow["approved"] ) ) > 0 ) {
      // only show who approved if it was a different user
      // only choices are approved or declined
      if ( $schedRow["user_id"] != $schedRow["approved_by"] ) {
        $approveTime = date( "m/d/Y g:ia", strtotime( $schedRow["approved_date"] ) );
        if ( $status == 90 ) {
          $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Declined on", HCU_DISPLAY_AS_RAW ),
                                  "value" => $approveTime );

          $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Declined by", HCU_DISPLAY_AS_RAW ),
                                  "value" => $schedRow["approved"] );
        } else {
          $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Approved on", HCU_DISPLAY_AS_RAW ),
                                  "value" => $approveTime );

          $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Approved by", HCU_DISPLAY_AS_RAW ),
                                  "value" => $schedRow["approved"] );
        }

      }
    } else {
      $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Approved by", HCU_DISPLAY_AS_RAW ),
                              "value" => $pHBEnv["MC"]->msg( "Pending Approval", HCU_DISPLAY_AS_RAW ) );
    }

    $startDate = date( "m/d/Y", strtotime( $schedRow["start_date"] ) );
    $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Start Date", HCU_DISPLAY_AS_RAW ),
                            "value" => $startDate );

    $endDate = empty( trim( $schedRow["end_date"] ) ) ? $pHBEnv["MC"]->msg( "Transfer does not stop", HCU_DISPLAY_AS_RAW) : date( "m/d/Y", strtotime( $schedRow["end_date"] ) );
    $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "End Date", HCU_DISPLAY_AS_RAW ),
                            "value" => $endDate );

    $nextTriggerDate = date( "m/d/Y", strtotime( $schedRow["next_trigger_date"] ) );
    $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Next Date", HCU_DISPLAY_AS_RAW ),
                            "value" => $nextTriggerDate );

    // only show the "status" field if the approved_status is not 0 (awaiting approval)
    if ( $status > 0 ) {
      if ( $status == 10 ) {
        $statusString = $pHBEnv["MC"]->msg( $schedRow["status"] == "A" ? "Active" : "Inactive", HCU_DISPLAY_AS_RAW );
      } else {
        $allowedStatuses = _GetAllowedStatuses( $pHBEnv["MC"] );

        $statusString = $allowedStatuses[$schedRow["approved_status"]];
      }

      $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Status", HCU_DISPLAY_AS_RAW),
                              "value" => $statusString );
    }

    $repeatingParams = HCU_JsonDecode( $schedRow["repeating_parameters"], false, true );
    $intervalName = $recurringIntervals[$repeatingParams["interval"]];
    $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Interval", HCU_DISPLAY_AS_RAW),
                            "value" => $intervalName );

    // determine the "from" and "to" based on the transaction code
    $transactionCode = $txnInfo["txn"]["transactioncode"];

    if ( in_array( $transactionCode, array("2W","2P") ) ) {
      // read the external account info
      $extId = $txnInfo["txn"]["from"];
      $fromInfo = _GetExternalAccount( $pHBEnv, $extId );

      $fromDesc = $fromInfo["display"];

      $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "From Account", HCU_DISPLAY_AS_RAW ),
                              "value" => $fromDesc );

      // add the routing and masked account
      $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "ACH Routing Number", HCU_DISPLAY_AS_RAW ),
                              "value" => $fromInfo["routing"] );

      $fromAcct = ApplyMask( $fromInfo["account"], $accountMask["data"] );

      $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Account", HCU_DISPLAY_AS_RAW ),
                              "value" => $fromAcct );
    } else {
      // "1W","1P","AT","LP","LA","MM" - source account is internal
      $acctParts = explode( "|", $txnInfo["txn"]["from"] );
      $certNumber = isset( $acctParts[3] ) && $acctParts[3] > 0 ? $acctParts[3] : 0;
      $fromDesc = FindAccountDisplay( $pHBEnv, $pHBEnv["dbh"], $pHBEnv['Cu'], $txnInfo['txn']['frommember'], $txnInfo['txn']['fromsuffix'], $txnInfo['txn']['fromtype'], $certNumber );

      if ( $fromDesc == "" ) {
        $fromDesc = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
      }

      $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "From Account", HCU_DISPLAY_AS_RAW ),
                              "value" => $fromDesc );
    }

    if ( in_array( $transactionCode, array("1W","1P") ) ) {
      // read the external account info
      $extId = $txnInfo["txn"]["to"];
      $toInfo = _GetExternalAccount( $pHBEnv, $extId );

      $toDesc = $toInfo["display"];
      $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "To Account", HCU_DISPLAY_AS_RAW ),
                              "value" => $toDesc );

      // add the routing number
      $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "ACH Routing Number", HCU_DISPLAY_AS_RAW ),
                                "value" => $toInfo["routing"] );

      // add masked account number
      $toAcct = ApplyMask( $toInfo["account"], $accountMask["data"] );

      $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Account", HCU_DISPLAY_AS_RAW ),
                              "value" => $toAcct );
    } else if ( $transactionCode == "MM" ) {
      // scheduled M2M is only for pre-defined
      $extId = $txnInfo["txn"]["to"];
      $toInfo = _GetExternalAccount( $pHBEnv, $extId );

      // NOTE: The mask logic should all be below this routine and we shouldn't have to know the data structure.
      $toAcct = ApplyMask( $toInfo["account"], $accountMask["data"] );

      // add on the name
      $toName = $toInfo["name"];

      $toDesc = "$toAcct ($toName)";

      $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "To Account", HCU_DISPLAY_AS_RAW ),
                              "value" => $toDesc );
    } else {
      // "2W","2P","AT","LP","LA" - destination account is internal
      $acctParts = explode( "|", $txnInfo["txn"]["to"] );
      $certNumber = isset( $acctParts[3] ) && $acctParts[3] > 0 ? $acctParts[3] : 0;
      $toDesc = FindAccountDisplay( $pHBEnv, $pHBEnv["dbh"], $pHBEnv['Cu'], $txnInfo['txn']['tomember'], $txnInfo['txn']['tosuffix'], $txnInfo['txn']['totype'], $certNumber );

      if ( $toDesc == "" ) {
        $toDesc = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
      }

      $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "To Account", HCU_DISPLAY_AS_RAW ),
                              "value" => $toDesc );
    }

    $amount = number_format( $txnInfo["txn"]["amount"], 2 );
    $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Amount", HCU_DISPLAY_AS_RAW ),
                            "value" => "$" . $amount, "type" => "currency" );

    $memo = trim( $txnInfo["txn"]["memo"] );
    $schedDetail[] = array( "name" => $pHBEnv["MC"]->msg( "Comment", HCU_DISPLAY_AS_RAW ),
                            "value" => $memo );

    // return as ["detail"] = array( "name", "value" );
    for ( $i = 0; $i < count( $schedDetail ); $i++ ) {
      $returnData["data"][]["detail"] = $schedDetail[$i];
    }

  } catch (Exception $e) {
    // get the message
    $message = $e->getMessage();

    $returnData["code"] = "999";
    $returnData["error"] = $message;
  }

  return $returnData;
} // end _GetActivityDetailScheduled

/**
 * GetTransferFeatureList will return name/value pairs of the transfer features.
 */
function GetTransferFeatureList( $pHBEnv ) {
  // get the list of transfer features that User Activity shows
  $allowedTranfers = getApprovalList();
  $transLimitStr = "'" . implode( "','", $allowedTranfers ) . "'";

  // Get a list of features that currently used by the Credit Union.
  $sql = "SELECT distinct f.feature_code AS name, f.description AS value
          FROM cu_feature f
          INNER JOIN cu_profilerights pr ON f.feature_code = pr.feature_code
            AND f.enabled
          INNER JOIN cu_profile p ON pr.profile_id = p.profile_id
            AND p.cu='{$pHBEnv["Cu"]}'
          INNER JOIN {$pHBEnv["Cu"]}group g ON p.profile_id = g.profile_id
          WHERE f.feature_code IN ($transLimitStr)
          ORDER BY f.description";
  $sth = db_query($sql, $pHBEnv["dbh"]);
  if ( !$sth ) {
    throw new exception($pHBEnv["MC"]->msg( "ACH Query Error", HCU_DISPLAY_AS_RAW ) . " 1405" );
  }

  $featureList = array();
  $row = 0;
  while ( $featureRow = db_fetch_assoc( $sth, $row++ ) ) {
    $featureList[] = array( "name" => $featureRow["name"], "value" => $featureRow["value"] );
  }

  return $featureList;
} // end GetTransferFeatureList

/**
 * ConvertToLookupArray will take a key/value array and make it into a [key]=value array. All
 * the elements of the list need the same structure.
 * For example, $input[0] = array( "name" => "this", "value" => "thing" ) becomes $result["this"] = "thing";
 */
function ConvertToLookupArray( $inputArray ) {
  $outputArray = array();

  // get the keys
  $keys = array_keys( $inputArray[0] );

  for ( $i = 0; $i < count( $inputArray ); $i++ ) {
    $newKey = $inputArray[$i][$keys[0]];
    $newValue = $inputArray[$i][$keys[1]];

    $outputArray[$newKey] = $newValue;
  }

  return $outputArray;
} // end ConvertToLookupArray


/**
 * Only show pending approval grid if there is more than one user and if a Needs Approval right is set.
 */
function ShowPendingApproval( $pHBEnv ) {
    $showPending = false;

    // Query to see the users in a particular group.  Other queries will be limited to these users.
    $sql = "SELECT b.user_id, b.group_id
            FROM {$pHBEnv["Cu"]}user a
            INNER JOIN {$pHBEnv["Cu"]}user b ON b.group_id = a.group_id
            WHERE a.user_id = {$pHBEnv["Uid"]}";
    $sth = db_query( $sql, $pHBEnv["dbh"] );
    if (!$sth) {
      throw new exception($pHBEnv["MC"]->msg( "ACH Query Error", HCU_DISPLAY_AS_RAW ) . " 1407");
    }

    $groupId = 0;
    $groupUserIds = array();
    for( $i = 0; $row = db_fetch_row($sth, $i); $i++ ) {
      // they are all in the same group, by definition
      $groupId = intval( $row[1] );

      $groupUserIds[] = intval( $row[0] );
    }

    // see if checking the "needs approval rights"
    if ( count( $groupUserIds ) > 1 ) {
      // check the profile rights
      $sql = "SELECT 1
              FROM {$pHBEnv["Cu"]}group g
              INNER JOIN cu_profilerights p ON p.profile_id = g.profile_id
                AND p.confirm_required
              WHERE g.group_id = $groupId
              LIMIT 1";

      $sth = db_query( $sql, $pHBEnv["dbh"] );
      if (!$sth) {
        throw new exception($pHBEnv["MC"]->msg( "ACH Query Error", HCU_DISPLAY_AS_RAW ) . " 1409");
      }

      $row = db_fetch_row($sth, 0);
      $showPending = $row[0] > 0;

      if ( !$showPending ) {
        // check the group rights
        $sql = "SELECT 1
                FROM {$pHBEnv["Cu"]}grouprights g
                WHERE g.group_id = $groupId
                  AND g.confirm_required
                LIMIT 1";

        $sth = db_query( $sql, $pHBEnv["dbh"] );
        if (!$sth) {
          throw new exception($pHBEnv["MC"]->msg( "ACH Query Error", HCU_DISPLAY_AS_RAW ) . " 1410");
        }

        $row = db_fetch_row($sth, 0);
        $showPending = $row[0] > 0;
      }

      if ( !$showPending ) {
        // check the user rights
        $userIdList = "'" . implode( "','", $groupUserIds ) . "'";
        $sql = "SELECT 1
                FROM {$pHBEnv["Cu"]}userrights u
                WHERE u.user_id IN ($userIdList)
                  AND u.confirm_required
                LIMIT 1";

        $sth = db_query( $sql, $pHBEnv["dbh"] );
        if (!$sth) {
          throw new exception($pHBEnv["MC"]->msg( "ACH Query Error", HCU_DISPLAY_AS_RAW ) . " 1411");
        }

        $row = db_fetch_row($sth, 0);
        $showPending = $row[0] > 0;
      }
    }

    return $showPending;
} // end ShowPendingApproval

/**
 * function GetUserActivityMetaData
 * Gather and return the one-time meta data used by the user-facing screen. This would be the
 *  actions, features, and statuses. No need to check permissions because this function should
 *  only be called in addition to the GetUserActivity, which is checking permissions. The data
 *  is returned in a name=value format, where the "name" is an internal code (i.e. do not present to user).
 *
 * @param $pHBEnv -- the current environment
 *
 * @return The requested information
 */

function GetUserActivityMetaData( $pHBEnv ) {
  $returnData = array( "code" => "000", "error" => "", "data" => array() );

  try {
    // list all the actions that can be done to a transaction
    $actionList = array();
    $actionList[] = array("name" => "details", "value" => $pHBEnv["MC"]->msg("View Details", HCU_DISPLAY_AS_RAW));
    $actionList[] = array("name" => "approve", "value" => $pHBEnv["MC"]->msg("Approve", HCU_DISPLAY_AS_RAW));
    $actionList[] = array("name" => "decline", "value" => $pHBEnv["MC"]->msg("Decline", HCU_DISPLAY_AS_RAW));
    $actionList[] = array("name" => "cancel", "value" => $pHBEnv["MC"]->msg("Cancel", HCU_DISPLAY_AS_RAW));

    $actions = array();
    for ( $i = 0; $i < count( $actionList ); $i++ ) {
      $actions[] = array( "action" => $actionList[$i] );
    }

    $returnData["data"]["actions"] = $actions;

    $transferFeatures = GetTransferFeatureList( $pHBEnv );

    // create a feature list with the "all" choice
    $featureList = array();
    $featureList[] = array( "feature" => array("name" => "", "value" => $pHBEnv["MC"]->msg("All", HCU_DISPLAY_AS_RAW)) );
    for ( $i = 0; $i < count( $transferFeatures ); $i++ ) {
      $featureList[] = array( "feature" => $transferFeatures[$i] );
    }

    $returnData["data"]["features"] = $featureList;

    // get the statuses
    $statuses = _GetAllowedStatuses( $pHBEnv["MC"] );

    $statusList = array();
    $keys = array_keys( $statuses );
    foreach( $keys as $key ) {
      $statusList[] = array( "status" => array( "name" => $key, "value" => $statuses[$key] ) );
    }

    $returnData["data"]["statuses"] = $statusList;

    // see if need to show pending
    $settingsList = array();
    $showPending = ShowPendingApproval( $pHBEnv ) ? 1 : 0;
    $settingsList[] = array( "setting" => array( "name" => "showpending", "value" => $showPending ) );

    $returnData["data"]["settings"] = $settingsList;

  } catch( Exception $e ) {
    // get the message and error code
    $message = $e->getMessage();

    $returnData["code"] = "999";
    $returnData["error"] = $message;
  }

  return $returnData;
} // end GetUserActivityMetaData

/**
 * Get a list of the allowed statuses for activities.
 */
function _GetAllowedStatuses( $MC ) {

  $statusList = array( 0 => $MC->msg("Any", HCU_DISPLAY_AS_RAW),
                       10 => $MC->msg("Approved", HCU_DISPLAY_AS_RAW),
                       90 => $MC->msg("Declined", HCU_DISPLAY_AS_RAW),
                       99 => $MC->msg("Cancelled", HCU_DISPLAY_AS_RAW) );

  return $statusList;
} // end _GetAllowedStatuses

/**
 * Get the scheduled user activity information.  Filter is passed through from GetUserActivity().
 */
function _GetUserActivityScheduled( $pHBEnv, $pParams ) {
  $returnData = array( "code" => "000", "error" => "", "data" => array() );

  try {
    // get the list of transfer features to get the name
    $transferFeatureList = GetTransferFeatureList( $pHBEnv );

    // make it a lookup array
    $transferFeatures = ConvertToLookupArray( $transferFeatureList );

    // get the list of schedule intervals for display
    $recurringIntervals = getIntervalLookup( $pHBEnv["MC"] );

    // validate the filters
    $allowedTypes = getApprovalList();

    // see if there are any filters
    $filterTransferType = isset( $pParams["filter"]["type"] ) && in_array( $pParams["filter"]["type"], $allowedTypes ) ? $pParams["filter"]["type"] : "";

    // date filter is: start is included and is earlier than end which is a ceiling (start<= data < end)
    $filterStartDate = isset( $pParams["filter"]["start"] ) ? $pParams["filter"]["start"] : "";
    $filterEndDate = isset( $pParams["filter"]["end"] ) ? $pParams["filter"]["end"] : "";

    // see if getting all statuses and dates
    $getAllScheduled = ( isset( $pParams["filter"]["scheduled"] ) && $pParams["filter"]["scheduled"] == "all" );

    // making sure getting all dates
    if ( $getAllScheduled ) {
      $filterStartDate = "";
      $filterEndDate = "";
    }

    // get the allowed statuses, default is any
    $allowedStatuses = _GetAllowedStatuses( $pHBEnv["MC"] );

    $filterStatus = isset( $pParams["filter"]["status"] ) && in_array( $pParams["filter"]["status"], $allowedStatuses ) ? $pParams["filter"]["status"] : 0;

    // dates need to be yyyy-mm-dd
    if ( $filterStartDate != "" ) {
      $filterStartDate = date( "Y-m-d", strtotime( $filterStartDate ) );
    }

    if ( $filterEndDate != "" ) {
      $filterEndDate = date( "Y-m-d", strtotime( $filterEndDate ) );
    }

    // get the requested information, based on the parameters
    $sql = "SELECT id, user_id, feature_code, next_trigger_date as date, repeating_parameters,
                   txn_data, approved_status
            FROM cu_scheduledtxn sched
            WHERE cu = '{$pHBEnv["Cu"]}'
              AND user_id = {$pHBEnv["Uid"]} ";

    // see if getting all
    if ( $getAllScheduled ) {
      // don't get the ones not yet approved
      $sql .= "  AND approved_status != 0";
    } else {
      // ones that haven't completed
      $sql .= "  AND (end_date is NULL OR current_date <= end_date OR next_trigger_date < end_date)";
      $sql .= "  AND approved_status = 10";
    }

    // add the filters
    if ( $filterTransferType != "" ) {
      $sql .= "  AND feature_code = '$filterTransferType'";
    } else {
      $sql .= "  AND feature_code IN ('" . implode("','", $allowedTypes) . "')";
    }

    if ( $filterStartDate != "" ) {
      $sql .= "  AND next_trigger_date >= '$filterStartDate'";
    } else {
      // allow older transactions that haven't triggered for some reason
      $sql .= "";
    }

    if ( $filterEndDate != "" ) {
      $sql .= "  AND next_trigger_date <= '$filterEndDate'";
    } else {
      // get all newer transaction (e.g. showing all scheduled)
    }

    $sql .= " ORDER BY next_trigger_date ASC";

    $sth = db_query( $sql, $pHBEnv["dbh"] );
    if (!$sth) {
      throw new exception( $pHBEnv["MC"]->msg( "ACH Query Error", HCU_DISPLAY_AS_RAW ) . " 1408" );
    }

    /*
     * Need this info:
     * <actions>value,value,...,value</actions>    - this depends on if the user has rights, etc
     * <type>feature name</type>
     * <status>activity status</status>
     * <date>date</date>
     * <id>id</id>
     * <area1_label></area1_label><area1_value></area1_value>
     * <area2_label></area2_label><area2_value></area2_value>
     * <area3_label></area3_label><area3_value></area3_value>
     * <area4_label></area4_label><area4_value></area4_value>
     */
    $row = 0;
    $schedInfo = array();
    while ( $schedRow = db_fetch_assoc( $sth, $row++ ) ) {
      $schedRow["table"] = "sched";

      $txnInfo = HCU_JsonDecode( $schedRow["txn_data"] );

      // save the type and look up the feature name
      $schedRow["type"] = $schedRow["feature_code"];
      $featureName = $transferFeatures[$schedRow["feature_code"]];
      $schedRow["feature"] = $featureName;

      // next_trigger_date is directly queried as "date"

      // return approved_status meaning as a string
      $status = $schedRow["approved_status"];
      $schedRow["status"] = $allowedStatuses[$status];

      // get the allowed actions based on rights, etc.
      // for scheduled transfers they are only getting their own
      $schedRow["actions"] = ( $status == 10 ? "cancel" : "" );

      // the status color depends on the state of the activity and who owns it
      if ( $status == 0 ) {
        // cannot approve own items
        $statusColor = ( $schedRow["user_id"] == $pHBEnv["Uid"] ) ? "info" : "warning";
      } else if ( $status == 10 ) {
        $statusColor = "success";
      } else if ( $status == 90 || $status == 99 ) {
        $statusColor = "danger";
      } else {
        $statusColor = "unknown";
      }
      $schedRow["color"] = $statusColor;

      $transactionCode = $txnInfo["txn"]["transactioncode"];

      if ( $transactionCode == "2W" ) {
        // read the external account info
        $extId = $txnInfo["txn"]["from"];

        $fromInfo = _GetExternalAccount( $pHBEnv, $extId );

        $fromDesc = $fromInfo["display"];
      } else {
        $acctParts = explode( "|", $txnInfo["txn"]["from"] );
        $certNumber = isset( $acctParts[3] ) && $acctParts[3] > 0 ? $acctParts[3] : 0;
        $fromDesc = FindAccountDisplay( $pHBEnv, $pHBEnv["dbh"], $pHBEnv['Cu'], $txnInfo['txn']['frommember'], $txnInfo['txn']['fromsuffix'], $txnInfo['txn']['fromtype'], $certNumber );
      }

      if ( $transactionCode == "1W" || $transactionCode == "MM" ) {
        // read the external account info
        $extId = $txnInfo["txn"]["to"];

        $toInfo = _GetExternalAccount( $pHBEnv, $extId );

        $toDesc = $toInfo["display"];
      } else {
        $acctParts = explode( "|", $txnInfo["txn"]["to"] );
        $certNumber = isset( $acctParts[3] ) && $acctParts[3] > 0 ? $acctParts[3] : 0;
        $toDesc = FindAccountDisplay( $pHBEnv, $pHBEnv["dbh"], $pHBEnv['Cu'], $txnInfo['txn']['tomember'], $txnInfo['txn']['tosuffix'], $txnInfo['txn']['totype'], $certNumber );
      }

      // area1 -> From description
      $schedRow["area1_label"] = $pHBEnv["MC"]->msg( "From", HCU_DISPLAY_AS_RAW );
      $schedRow["area1_value"] = $fromDesc;

      // area2 -> To description
      $schedRow["area2_label"] = $pHBEnv["MC"]->msg( "To", HCU_DISPLAY_AS_RAW );
      $schedRow["area2_value"] = $toDesc;

      // area3 -> amount and recurring option
      $repeatingParams = HCU_JsonDecode( $schedRow["repeating_parameters"], false, true );
      $intervalName = $recurringIntervals[$repeatingParams["interval"]];
      $amount = number_format( $txnInfo["txn"]["amount"], 2 );
      $schedRow["area3_label"] = "";
      $schedRow["area3_value"] = "\${$amount} {$intervalName}";

      // area4 -> next trigger date
      $nextTrigger = strtotime( $schedRow["date"] );
      if ( $nextTrigger == 0 ) {
        // this should never happen
        $dateString = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
      } else {
        $dateString = date( "m/d/Y", $nextTrigger );
      }
      $schedRow["area4_label"] = $pHBEnv["MC"]->msg( "Next Date", HCU_DISPLAY_AS_RAW );
      $schedRow["area4_value"] = $dateString;

      // don't return these
      unset( $schedRow["txn_data"] );
      unset( $schedRow["repeating_parameters"] );

      $schedInfo[]["txn"] = $schedRow;
    }

    $returnData["data"] = $schedInfo;

  } catch( Exception $e ) {
    // get the message and error code
    $message = $e->getMessage();

    $returnData["code"] = "999";
    $returnData["error"] = $message;
  }

  return $returnData;
} // end _GetUserActivityScheduled

// Get the ids of all the users in the current user's group.
// Returns an array of user ids, including the current user.
function GetUserIdsForGroup( $pHBEnv ) {

  try {
    $sql = "SELECT u2.user_id
            FROM {$pHBEnv["Cu"]}user u1
            INNER JOIN {$pHBEnv["Cu"]}user u2 ON u2.group_id = u1.group_id
            WHERE u1.user_id = {$pHBEnv["Uid"]}";

    $sth = db_query( $sql, $pHBEnv["dbh"] );
    if (!$sth) {
      throw new exception( $pHBEnv["MC"]->msg( "ACH Query Error", HCU_DISPLAY_AS_RAW ) . " 1423" );
    }

    $row = 0;
    $userIdList = array();
    while ( $userRow = db_fetch_assoc( $sth, $row++ ) ) {
      $userIdList[] = $userRow["user_id"];
    }
  } catch( Exception $e ) {
    // return nothing
    $userIdList = array();
  }

  return $userIdList;
} // end GetUserIdsForGroup

/**
 * Get the "Need to be approved" pending user activity information. These are in both the
 * cu_scheduledtxn table and the <cu>transhdr table. The only filter is the type.
 * Only show other user's transactions that this user has the right to confirm.
 */
function _GetUserActivityPending( $pHBEnv, $pParams, $pConfirmPermissions ) {
  $returnData = array( "code" => "000", "error" => "", "data" => array() );

  try {
    // get the list of transfer features to get the name
    $transferFeatureList = GetTransferFeatureList( $pHBEnv );

    // make it a lookup array
    $transferFeatures = ConvertToLookupArray( $transferFeatureList );

    // get the list of schedule intervals for display
    $recurringIntervals = getIntervalLookup( $pHBEnv["MC"] );

    // validate the filters
    $allowedTypes = getApprovalList();

    // get all the user ids in the group
    $userIdList = GetUserIdsForGroup( $pHBEnv );
    $userIdStr = implode( ",", $userIdList );

    // see if there are any filters
    $filterTransferType = isset( $pParams["filter"]["type"] ) && in_array( $pParams["filter"]["type"], $allowedTypes ) ? $pParams["filter"]["type"] : "";

    // get the requested information, based on the parameters
    // NOTE: right now getting the single detail with the header; may need to re-work when Batch ACH shows up.
    $sql = "SELECT hdr.posted_date as sortkey, 'trans' as table_type, hdr.id, hdr.feature_code,
                   hdr.posted_date as create_date, hdr.effective_date as process_date, hdr.posted_by as create_id,
                   hdr.approved_status, dtl.amount, '' as repeating_parameters, hdr.transactioncode,
                   dtl.transdata as txn_data, '' as status
            FROM {$pHBEnv["Cu"]}transhdr hdr
            INNER JOIN {$pHBEnv["Cu"]}transdtl dtl ON dtl.transhdr_id = hdr.id
            WHERE hdr.posted_by IN ($userIdStr)
              AND coalesce( hdr.approved_by, 0 ) = 0";

    // add the filters
    if ( $filterTransferType != "" ) {
      $sql .= "  AND feature_code = '$filterTransferType'";
    } else {
      $sql .= "  AND feature_code IN ('" . implode("','", $allowedTypes) . "')";
    }

    // columns need to match with a union; amount is a placeholder since it is in the txn_data
    $sql .= " UNION
             SELECT sched.create_date as sortkey, 'sched' as table_type, sched.id, sched.feature_code,
                    sched.create_date as create_date, next_trigger_date as process_date, user_id as create_id,
                    sched.approved_status, 0 as amount, repeating_parameters, '' as transactioncode,
                    txn_data, status
             FROM cu_scheduledtxn sched
             WHERE sched.cu = '{$pHBEnv["Cu"]}'
               AND sched.user_id IN ($userIdStr)
               AND coalesce( sched.approved_by, 0 ) = 0";

    // add the filters
    if ( $filterTransferType != "" ) {
      $sql .= "  AND feature_code = '$filterTransferType'";
    } else {
      $sql .= "  AND feature_code IN ('" . implode("','", $allowedTypes) . "')";
    }

    $sql .= " ORDER BY 1 ASC";

    $sth = db_query( $sql, $pHBEnv["dbh"] );
    if (!$sth) {
      throw new exception( $pHBEnv["MC"]->msg( "ACH Query Error", HCU_DISPLAY_AS_RAW ) . " 1424" );
    }

    // this is used to hold the transcode in case there is an "other" type transaction.
    $trans = null;

    /*
     * Need this info:
     * <actions>value,value,...,value</actions>    - this depends on if the user has rights, etc
     * <type>feature name</type>
     * <status>activity status</status>
     * <date>date</date>
     * <id>id</id>
     * <area1_label></area1_label><area1_value></area1_value>
     * <area2_label></area2_label><area2_value></area2_value>
     * <area3_label></area3_label><area3_value></area3_value>
     * <area4_label></area4_label><area4_value></area4_value>
     */
    $row = 0;
    $approveInfo = array();
    while ( $approveRow = db_fetch_assoc( $sth, $row++ ) ) {
      // only keep transaction if the current user can approve it
      if ( $approveRow["create_id"] != $pHBEnv["Uid"] ) {
        if ( !$pConfirmPermissions[$approveRow["feature_code"]] ) {
          continue;
        }
      }

      $txnInfo = HCU_JsonDecode( $approveRow["txn_data"] );

      // get the allowed actions based on rights, etc.
      // for transactions needing approval, cancel your own or approve/decline someone elses
      $approveRow["actions"] = ( $approveRow["create_id"] == $pHBEnv["Uid"] ) ? "cancel" : "approve,decline";

      // save the type and look up the feature name
      $approveRow["type"] = $approveRow["feature_code"];
      $featureName = $transferFeatures[$approveRow["feature_code"]];
      $approveRow["feature"] = $featureName;

      // the status color is really either cancelled/declined, or completed
      if ( $approveRow["create_id"] == $pHBEnv["Uid"] ) {
        $statusColor = "info";
      } else if ( $approveRow["create_id"] != $pHBEnv["Uid"] ) {
        $statusColor = "warning";
      } else {
        $statusColor = "unknown";
      }
      $approveRow["color"] = $statusColor;

      // the scheduled transactions may be active or inactive
      $txnStatus = "";
      if ( $approveRow["status"] == "A" ) {
        $txnStatus = $pHBEnv["MC"]->msg( "Active" );
      } else if ( $approveRow["status"] == "I" ) {
        $txnStatus = $pHBEnv["MC"]->msg( "Inactive" );
      }

      // overwrite the field since this is what will be picked up by the client
      $approveRow["status"] = $txnStatus;


      // the below information is different for transaction history vs a scheduled txn
      if ( $approveRow["table_type"] == "sched" ) {
        $approveRow["table"] = "sched";

        $transactionCode = $txnInfo["txn"]["transactioncode"];

        // the sort key is the <date>
        $approveRow["date"] = date( "m/d/Y", strtotime( $approveRow["sortkey"] ) );

        $fromDesc = "";
        if ( $transactionCode == "2W" ) {
          // read the external account info
          $extId = $txnInfo["txn"]["from"];

          $fromInfo = _GetExternalAccount( $pHBEnv, $extId );

          $fromDesc = $fromInfo["display"];
        } else {
          $acctParts = explode( "|", $txnInfo["txn"]["from"] );
          $certNumber = isset( $acctParts[3] ) && $acctParts[3] > 0 ? $acctParts[3] : 0;

          $fromDesc = FindAccountDisplay( $pHBEnv, $pHBEnv["dbh"], $pHBEnv['Cu'], $txnInfo['txn']['frommember'], $txnInfo['txn']['fromsuffix'], $txnInfo['txn']['fromtype'], $certNumber );
        }

        if ( $fromDesc == "" ) {
          $fromDesc = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
        }

        $toDesc = "";
        if ( $transactionCode == "1W" || $transactionCode == "MM" ) {
          // read the external account info
          $extId = $txnInfo["txn"]["to"];

          $toInfo = _GetExternalAccount( $pHBEnv, $extId );
          $toDesc = $toInfo["display"];
        } else {
          $acctParts = explode( "|", $txnInfo["txn"]["to"] );

          // NOTE: "Other" type transactions cannot be scheduled

          $certNumber = isset( $acctParts[3] ) && $acctParts[3] > 0 ? $acctParts[3] : 0;
          $toDesc = FindAccountDisplay( $pHBEnv, $pHBEnv["dbh"], $pHBEnv['Cu'], $txnInfo['txn']['tomember'], $txnInfo['txn']['tosuffix'], $txnInfo['txn']['totype'], $certNumber );
        }

        if ( $toDesc == "" ) {
          $toDesc = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
        }

        $repeatingParams = HCU_JsonDecode( $approveRow["repeating_parameters"], false, true );
        $intervalName = $recurringIntervals[$repeatingParams["interval"]];
        $amount = number_format( $txnInfo["txn"]["amount"], 2 );

        $amountLabel = "";
        $amountString = "\${$amount} {$intervalName}";

        $dateLabel = $pHBEnv["MC"]->msg( "ACH Effective Date", HCU_DISPLAY_AS_RAW );
        $processTime = strtotime( $approveRow["process_date"] );
        if ( $processTime == 0 ) {
          // this should never happen
          $dateString = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
        } else {
          $dateString = date( "m/d/Y", $processTime );
        }
      } else {
        // from the <cu>transdtl table
        $approveRow["table"] = "trans";

        $transactionCode = $approveRow["transactioncode"];

        $fromDesc = "";
        if ( in_array( $transactionCode, array("1W","1P","AT","LP","LA","MM","CW","OT") ) ) {
          $acctParts = explode( "|", $txnInfo["acct_source"] );
          $certNumber = isset( $acctParts[3] ) && $acctParts[3] > 0 ? $acctParts[3] : 0;
          $accountType = $txnInfo['source_key']['recordtype'] == "L" ? $txnInfo['source_key']['loannumber'] : $txnInfo['source_key']['accounttype'];

          $fromDesc = FindAccountDisplay( $pHBEnv, $pHBEnv["dbh"], $pHBEnv['Cu'], $txnInfo['source_key']['accountnumber'], $accountType, $txnInfo['source_key']['recordtype'], $certNumber );
        } else if ( in_array( $transactionCode, array("2W","2P") ) ) {
          // get the external account info; use the name on account since that is common for creator and approver
          $fromDesc = $txnInfo["acct_source"]["remote_entity"]["name"];
        }

        if ( !$fromDesc ) {
          $fromDesc = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
        }

        $toDesc = "";
        if ( in_array( $transactionCode, array("2W","2P","AT","LP","LA") ) ) {
          $acctParts = explode( "|", $txnInfo["acct_dest"] );
          $certNumber = isset( $acctParts[3] ) && $acctParts[3] > 0 ? $acctParts[3] : 0;
          $accountType = $txnInfo['dest_key']['recordtype'] == "L" ? $txnInfo['dest_key']['loannumber'] : $txnInfo['dest_key']['accounttype'];

          $toDesc = FindAccountDisplay( $pHBEnv, $pHBEnv["dbh"], $pHBEnv['Cu'], $txnInfo['dest_key']['accountnumber'], $accountType, $txnInfo['dest_key']['recordtype'], $certNumber );
        } else if ( in_array( $transactionCode, array("1W","1P") ) ) {
          // get the external account info; use the name on account since that is common for creator and approver
          $toDesc = $txnInfo["acct_dest"]["remote_entity"]["name"];
        } else if ( in_array( $transactionCode, array( "MM" ) ) ) {
          // get the member account info; use the name on account since that is common for creator and approver
          $toDesc = $txnInfo["dest_key"]["name"];
        } else if ( in_array( $transactionCode, array( "OT","CW" ) ) ) {
          $acctParts = explode( "|", $txnInfo["acct_dest"] );

          if ( $acctParts[0] == "O" ) {
            if ( $trans == null ) {
              $trans = Get_HaveTrans( $pHBEnv["dbh"], $pHBEnv );
            }

            $otherDesc = HCU_array_key_value($acctParts[2], $trans);

            $cuDesc = isset($otherDesc[2]) ? trim($otherDesc[2]) : "";
            $nonCUDesc = isset($otherDesc[0]) ? trim($otherDesc[0]) : "";

            $toDesc = $cuDesc != "" ? $cuDesc : $nonCUDesc;
          }
        }

        if ( !$toDesc ) {
          $toDesc = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
        }

        $amount = number_format( $approveRow["amount"], 2 );

        $amountLabel = "";
        $amountString = "\${$amount}";

        $dateLabel = $pHBEnv["MC"]->msg( "ACH Effective Date", HCU_DISPLAY_AS_RAW );
        $processTime = strtotime( $approveRow["process_date"] );
        if ( $processTime == 0 ) {
          // this should never happen
          $dateString = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
        } else {
          $dateString = date( "m/d/Y", $processTime );
        }
      }

      // area1 -> From description
      $approveRow["area1_label"] = $pHBEnv["MC"]->msg( "From", HCU_DISPLAY_AS_RAW );
      $approveRow["area1_value"] = $fromDesc;

      // area2 -> To description
      $approveRow["area2_label"] = $pHBEnv["MC"]->msg( "To", HCU_DISPLAY_AS_RAW );
      $approveRow["area2_value"] = $toDesc;

      // area3 -> amount and possibly recurring option
      $approveRow["area3_label"] = $amountLabel;
      $approveRow["area3_value"] = $amountString;

      // area4 -> next trigger date
      $approveRow["area4_label"] = $dateLabel;
      $approveRow["area4_value"] = $dateString;

      // status for some of them
      $approveRow["status"] = $txnStatus;

      // don't return these
      unset( $approveRow["txn_data"] );
      unset( $approveRow["repeating_parameters"] );
      unset( $approveRow["sortkey"] );
      unset( $approveRow["amount"] );
      unset( $approveRow["transactioncode"] );

      $approveInfo[]["txn"] = $approveRow;
    }

    $returnData["data"] = $approveInfo;

  } catch( Exception $e ) {
    // get the message and error code
    $message = $e->getMessage();

    $returnData["code"] = "999";
    $returnData["error"] = $message;
  }

  return $returnData;
} // end _GetUserActivityPending


/**
 * Get the prior history user activity information.
 *
 * NOTE: Date range is required. Start date is earliest, end is latest. Start
 *  must be before end. End date is a ceiling (i.e. less than), start date is included.
 */
function _GetUserActivityPrior( $pHBEnv, $pParams ) {
  $returnData = array( "code" => "000", "error" => "", "data" => array() );

  try {
    // date filter is: start is included and is earlier than end which is a ceiling (start<= data < end)
    $filterStartDate = isset( $pParams["filter"]["start"] ) ? $pParams["filter"]["start"] : "";
    $filterEndDate = isset( $pParams["filter"]["end"] ) ? $pParams["filter"]["end"] : "";

    $startDate = strtotime( $filterStartDate );
    $endDate = strtotime( $filterEndDate );

    // dates need to be yyyy-mm-dd
    if ( $filterStartDate == "" || $startDate == 0 ) {
      throw new exception( $pHBEnv["MC"]->msg( "Please provide a Start Date", HCU_DISPLAY_AS_RAW ) . " 1420" );
    }

    if ( $filterEndDate == "" || $endDate == 0 ) {
      throw new exception( $pHBEnv["MC"]->msg( "Please provide an End Date", HCU_DISPLAY_AS_RAW ) . " 1421" );
    }

    if ( $startDate > $endDate ) {
      throw new exception( $pHBEnv["MC"]->msg( "Please provide an End Date", HCU_DISPLAY_AS_RAW ) . " 1422" );
    }

    $formattedStartDate = date( "Y-m-d ", $startDate );
    $formattedEndDate = date( "Y-m-d", $endDate );

    // get the list of transfer features to get the name
    $transferFeatureList = GetTransferFeatureList( $pHBEnv );

    // make it a lookup array
    $transferFeatures = ConvertToLookupArray( $transferFeatureList );

    // get the list of schedule intervals for display
    $recurringIntervals = getIntervalLookup( $pHBEnv["MC"] );

    // validate the filters
    $allowedTypes = getApprovalList();

    // see if there are any filters
    $filterTransferType = isset( $pParams["filter"]["type"] ) && in_array( $pParams["filter"]["type"], $allowedTypes ) ? $pParams["filter"]["type"] : "";

    // get the allowed statuses, default is any
    $allowedStatuses = _GetAllowedStatuses( $pHBEnv["MC"] );

    $filterStatus = isset( $pParams["filter"]["status"] ) && in_array( $pParams["filter"]["status"], $allowedStatuses ) ? $pParams["filter"]["status"] : 0;

    // get the requested information, based on the parameters
    // NOTE: right now getting the single detail with the header; may need to re-work when Batch ACH shows up.
    // NOTE: We don't care how far forward in time (there shouldn't be any future approvals, anyway)
    $sql = "SELECT hdr.posted_date as sortkey, 'trans' as table_type, hdr.id, hdr.feature_code,
                   hdr.posted_date as create_date, hdr.approved_status, hdr.processed_date,
                   hdr.processed_status, hdr.transactioncode,
                   dtl.amount, '' as repeating_parameters, dtl.transdata as txn_data
            FROM {$pHBEnv["Cu"]}transhdr hdr
            INNER JOIN {$pHBEnv["Cu"]}transdtl dtl ON dtl.transhdr_id = hdr.id
            WHERE (hdr.posted_by = {$pHBEnv["Uid"]} OR hdr.approved_by = {$pHBEnv["Uid"]})
              AND hdr.posted_date > '$formattedStartDate 23:59:59'
              AND hdr.posted_date <= '$formattedEndDate 23:59:59'
              AND hdr.approved_by IS NOT NULL";

    // add the filters
    if ( $filterTransferType != "" ) {
      $sql .= "  AND feature_code = '$filterTransferType'";
    } else {
      $sql .= "  AND feature_code IN ('" . implode("','", $allowedTypes) . "')";
    }

    // columns need to match with a union; amount is a placeholder since it is in the txn_data
    // NOTE: We don't care how far forward in time because it would be a cancelled record, and prior is
    //       only worried about looking back in time.
    // Currently (04/19/2018) only showing other users' scheduled txns
    $sql .= " UNION
             SELECT sched.approved_date as sortkey, 'sched' as table_type, sched.id, sched.feature_code,
                    sched.create_date as create_date, sched.approved_status, sched.approved_date as processed_date,
                    0 as processed_status, '' as transactioncode, 0 as amount, repeating_parameters, txn_data
             FROM cu_scheduledtxn sched
             WHERE sched.cu = '{$pHBEnv["Cu"]}'
               AND sched.user_id != {$pHBEnv["Uid"]}
               AND sched.approved_by = {$pHBEnv["Uid"]}
               AND sched.approved_date > '$formattedStartDate 23:59:59'
               AND sched.approved_date <= '$formattedEndDate 23:59:59'";

    // add the filters
    if ( $filterTransferType != "" ) {
      $sql .= "  AND feature_code = '$filterTransferType'";
    } else {
      $sql .= "  AND feature_code IN ('" . implode("','", $allowedTypes) . "')";
    }

    $sql .= " ORDER BY 1 DESC";

    $sth = db_query( $sql, $pHBEnv["dbh"] );
    if (!$sth) {
      throw new exception( $pHBEnv["MC"]->msg( "ACH Query Error", HCU_DISPLAY_AS_RAW ) . " 1419" );
    }

    // this is used to hold the transcode in case there is an "other" type transaction.
    $trans = null;

    /*
     * Need this info:
     * <actions>value,value,...,value</actions>    - this depends on if the user has rights, etc
     * <type>feature name</type>
     * <status>activity status</status>
     * <date>date</date>
     * <id>id</id>
     * <area1_label></area1_label><area1_value></area1_value>
     * <area2_label></area2_label><area2_value></area2_value>
     * <area3_label></area3_label><area3_value></area3_value>
     * <area4_label></area4_label><area4_value></area4_value>
     */

    $row = 0;
    $priorInfo = array();
    while ( $priorRow = db_fetch_assoc( $sth, $row++ ) ) {
      // the sort key is the <date>
      $priorRow["date"] = date( "m/d/Y", strtotime( $priorRow["sortkey"] ) );

      $txnInfo = HCU_JsonDecode( $priorRow["txn_data"] );

      // don't show micro deposits
      if ( $priorRow["transactioncode"] == "1P" ||
           $priorRow["transactioncode"] == "2P" ) {
        if ( (isset( $txnInfo["acct_source"] ) && $txnInfo["acct_source"] == "micro") ||
             (isset( $txnInfo["acct_dest"] ) && $txnInfo["acct_dest"] == "micro")  ) {
          continue;
        }
      }

      if ( $priorRow["table_type"] == "trans" &&
           !isset( $txnInfo["source_key"] ) && !isset( $txnInfo["dest_key"] ) ) {
        continue;
      }

      // get the allowed actions based on rights, etc.
      // for prior transactions, there are no actions currently
      $priorRow["actions"] = "";

      // save the type and look up the feature name
      $priorRow["type"] = $priorRow["feature_code"];
      $featureName = $transferFeatures[$priorRow["feature_code"]];
      $priorRow["feature"] = $featureName;

      // return approved_status meaning as a string
      $status = $priorRow["approved_status"];
      $priorRow["status"] = $allowedStatuses[$status];

      // the status color is really either cancelled/declined, or completed
      if ( $status == 10 ) {
        $statusColor = "success";
      } else if ( $status == 90 || $status == 99 ) {
        $statusColor = "danger";
      } else {
        $statusColor = "unknown";
      }
      $priorRow["color"] = $statusColor;

      // the below information is different for transaction history vs a scheduled txn
      if ( $priorRow["table_type"] == "sched" ) {
        $priorRow["table"] = "sched";

        $transactionCode = $txnInfo["txn"]["transactioncode"];

        $fromDesc = "";
        if ( $transactionCode == "2W" ) {
          // read the external account info
          $extId = $txnInfo["txn"]["from"];

          $fromInfo = _GetExternalAccount( $pHBEnv, $extId );

          $fromDesc = $fromInfo["display"];
        } else {
          $acctParts = explode( "|", $txnInfo["txn"]["from"] );
          $certNumber = isset( $acctParts[3] ) && $acctParts[3] > 0 ? $acctParts[3] : 0;
          $fromDesc = FindAccountDisplay( $pHBEnv, $pHBEnv["dbh"], $pHBEnv['Cu'], $txnInfo['txn']['frommember'], $txnInfo['txn']['fromsuffix'], $txnInfo['txn']['fromtype'], $certNumber );
        }

        if ( !$fromDesc ) {
          $fromDesc = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
        }

        $toDesc = "";
        if ( $transactionCode == "1W" || $transactionCode == "MM" ) {
          // read the external account info
          $extId = $txnInfo["txn"]["to"];

          $toInfo = _GetExternalAccount( $pHBEnv, $extId );

          $toDesc = $toInfo["display"];
        } else {
          $acctParts = explode( "|", $txnInfo["txn"]["to"] );

          if ( $acctParts[0] == "O" ) {
            if ( $trans == null ) {
              $trans = Get_HaveTrans( $pHBEnv["dbh"], $pHBEnv );
            }

            $otherDesc = HCU_array_key_value($acctParts[2], $trans);

            $cuDesc = isset($otherDesc[2]) ? trim($otherDesc[2]) : "";
            $nonCUDesc = isset($otherDesc[0]) ? trim($otherDesc[0]) : "";

            $toDesc = $cuDesc != "" ? $cuDesc : $nonCUDesc;

            if ( !$toDesc ) {
              $toDesc = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
            }
          } else {
            $certNumber = isset( $acctParts[3] ) && $acctParts[3] > 0 ? $acctParts[3] : 0;
            $toDesc = FindAccountDisplay( $pHBEnv, $pHBEnv["dbh"], $pHBEnv['Cu'], $txnInfo['txn']['tomember'], $txnInfo['txn']['tosuffix'], $txnInfo['txn']['totype'], $certNumber );
          }
        }

        if ( !$toDesc ) {
          $toDesc = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
        }

        $repeatingParams = HCU_JsonDecode( $priorRow["repeating_parameters"], false, true );
        $intervalName = $recurringIntervals[$repeatingParams["interval"]];
        $amount = number_format( $txnInfo["txn"]["amount"], 2 );

        $amountLabel = "";
        $amountString = "\${$amount} {$intervalName}";

        // only show if approved status is 10 (not declined or cancelled)
        if ( $priorRow["approved_status"] == 10 ) {
          $dateLabel = $pHBEnv["MC"]->msg( "Processed Date", HCU_DISPLAY_AS_RAW );
          $processTime = strtotime( $priorRow["processed_date"] );
          if ( $processTime == 0 ) {
            $dateString = $pHBEnv["MC"]->msg( "Not processed", HCU_DISPLAY_AS_RAW );
          } else {
            $dateString = date( "m/d/Y", $processTime );
          }
        } else {
          $dateLabel = "";
          $dateString = "";
        }
      } else {
        // from the <cu>transdtl table
        $priorRow["table"] = "trans";

        $transactionCode = $priorRow["transactioncode"];

        $fromDesc = "";
        if ( in_array( $transactionCode, array("1W","1P","AT","LP","LA","MM","CW","OT") ) ) {
          $acctParts = explode( "|", $txnInfo["acct_source"] );
          $certNumber = isset( $acctParts[3] ) && $acctParts[3] > 0 ? $acctParts[3] : 0;
          $accountType = $txnInfo['source_key']['recordtype'] == "L" ? $txnInfo['source_key']['loannumber'] : $txnInfo['source_key']['accounttype'];

          $fromDesc = FindAccountDisplay( $pHBEnv, $pHBEnv["dbh"], $pHBEnv['Cu'], $txnInfo['source_key']['accountnumber'], $accountType, $txnInfo['source_key']['recordtype'], $certNumber );
        } else if ( in_array( $transactionCode, array("2W","2P") ) ) {
          // get the external account info; use the name on account since that is common for creator and approver
          $fromDesc = $txnInfo["acct_source"]["remote_entity"]["name"];
        }

        if ( !$fromDesc ) {
          $fromDesc = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
        }

        $toDesc = "";
        if ( in_array( $transactionCode, array("2W","2P","AT","LP","LA") ) ) {
          $acctParts = explode( "|", $txnInfo["acct_dest"] );
          $certNumber = isset( $acctParts[3] ) && $acctParts[3] > 0 ? $acctParts[3] : 0;
          $accountType = $txnInfo['dest_key']['recordtype'] == "L" ? $txnInfo['dest_key']['loannumber'] : $txnInfo['dest_key']['accounttype'];

          $toDesc = FindAccountDisplay( $pHBEnv, $pHBEnv["dbh"], $pHBEnv['Cu'], $txnInfo['dest_key']['accountnumber'], $accountType, $txnInfo['dest_key']['recordtype'], $certNumber );
        } else if ( in_array( $transactionCode, array("1W","1P") ) ) {
         // get the external account info; use the name on account since that is common for creator and approver
         $toDesc = $txnInfo["acct_dest"]["remote_entity"]["name"];
        } else if ( in_array( $transactionCode, array( "MM" ) ) ) {
          // get the member account info; use the name on account since that is common for creator and approver
          $toDesc = $txnInfo["dest_key"]["name"];
        } else if ( in_array( $transactionCode, array( "OT","CW" ) ) ) {
          $acctParts = explode( "|", $txnInfo["acct_dest"] );

          if ( $acctParts[0] == "O" ) {
            if ( $trans == null ) {
              $trans = Get_HaveTrans( $pHBEnv["dbh"], $pHBEnv );
            }

            $otherDesc = HCU_array_key_value($acctParts[2], $trans);

            $cuDesc = isset($otherDesc[2]) ? trim($otherDesc[2]) : "";
            $nonCUDesc = isset($otherDesc[0]) ? trim($otherDesc[0]) : "";

            $toDesc = $cuDesc != "" ? $cuDesc : $nonCUDesc;
          }
        }

        if ( !$toDesc ) {
          $toDesc = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
        }

        $amount = number_format( $priorRow["amount"], 2 );

        $amountLabel = "";
        $amountString = "\${$amount}";


        $dateLabel = $pHBEnv["MC"]->msg( "Processed Date", HCU_DISPLAY_AS_RAW );
        $processTime = strtotime( $priorRow["processed_date"] );
        if ( $processTime == 0 || $priorRow["processed_status"] == 90 ) {
          $dateString = $pHBEnv["MC"]->msg( "Not processed", HCU_DISPLAY_AS_RAW );
        } else {
          $dateString = date( "m/d/Y", $processTime );
        }
      }

      // area1 -> From description
      $priorRow["area1_label"] = $pHBEnv["MC"]->msg( "From", HCU_DISPLAY_AS_RAW );
      $priorRow["area1_value"] = $fromDesc;

      // area2 -> To description
      $priorRow["area2_label"] = $pHBEnv["MC"]->msg( "To", HCU_DISPLAY_AS_RAW );
      $priorRow["area2_value"] = $toDesc;

      // area3 -> amount and possibly recurring option
      $priorRow["area3_label"] = $amountLabel;
      $priorRow["area3_value"] = $amountString;

      // area4 -> next trigger date (scheduled) or processed date (tranhdr)
      $priorRow["area4_label"] = $dateLabel;
      $priorRow["area4_value"] = $dateString;

      // don't return these
      unset( $priorRow["txn_data"] );
      unset( $priorRow["repeating_parameters"] );
      unset( $priorRow["sortkey"] );

      $priorInfo[]["txn"] = $priorRow;
    }

    $returnData["data"] = $priorInfo;

  } catch( Exception $e ) {
    // get the message and error code
    $message = $e->getMessage();

    $returnData["code"] = "999";
    $returnData["error"] = $message;
  }

  return $returnData;
} // end _GetUserActivityPrior

/**
 * function DoActivityAction
 * Perform the given action on the activity. If successful, read the activity detail and return that information.
 * The action can be an approve or decline of a pending transfer, or the cancel of own scheduled or pending
 * transfer.
 *
 * @param array $pHBEnv         - Home banking settings
 * @param int $pDetailId        - The detail id to act upon
 * @param boolean $pIsScheduled - The type of txn acting upon is a scheduled txn
 * @param string $pAction       - The specific action
 *
 * @return The activity detail
 */
function DoActivityAction( $pHBEnv, $pDetailId, $pIsScheduled, $pAction ) {
  $returnData = array( "code" => "000", "error" => "", "data" => array() );

  try {
    // get list of userIds for group
    $userIdList = GetUserIdsForGroup( $pHBEnv );
    $userIdStr = implode( ",", $userIdList );


    // make sure this user has the rights to do the approval
    $confirmPermissions = array();
    $results = Perm_FeatureAccessList( $pHBEnv["dbh"], $pHBEnv );
    if ( !intval($results["status"]["code"] ) == 0) {
      throw new exception($results["status"]["error"] . " 1404");
    }

    // the rights for this user will be returned
    $permissions = $results["data"][$pHBEnv["Uid"]];

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

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

    // if this user is the only person in group then can confirm (but shouldn't be here, really)
    if ( !$confirmFound ) {
      if ( in_array( $pHBEnv["Uid"], $userIdList ) &&
           count( $userIdList ) == 1 ) {
        $confirmFound = true;
      }
    }

    if ( !$confirmFound ) {
      throw new exception( $pHBEnv["MC"]->msg( "Trans approval failure", HCU_DISPLAY_AS_RAW ) . " 1427");
    }

    // get the feature code to see if this user has permissions to approve
    $table = $pIsScheduled ? "cu_scheduledtxn" : "{$pHBEnv["Cu"]}transhdr";
    $postedField = $pIsScheduled ? "user_id" : "posted_by";
    $sql = "SELECT feature_code, $postedField as user_id, approved_status
            FROM $table
            WHERE id = $pDetailId
              AND $postedField IN ($userIdStr)";

    $sth = db_query( $sql, $pHBEnv["dbh"] );
    if (!$sth) {
      throw new exception( $pHBEnv["MC"]->msg( "ACH Query Error", HCU_DISPLAY_AS_RAW ) . " 1428" );
    }

    $txnRow = db_fetch_assoc($sth, 0);
    $transferFeatureCode = trim( $txnRow["feature_code"] );

    // can they approve this type of transaction?
    if ( !$confirmPermissions[$transferFeatureCode] ) {
      throw new exception( $pHBEnv["MC"]->msg( "Trans approval failure", HCU_DISPLAY_AS_RAW ) . " 1429");
    }

    // get the action code
    $actionStatus = 0;
    if ( $pAction == "approve" ) {
      $actionStatus = 10;
    } else if ( $pAction == "decline" ) {
      $actionStatus = 90;
    } else if ( $pAction == "cancel" ) {
      $actionStatus = 99;
    } else {
      throw new exception( $pHBEnv["MC"]->msg( "ACH Unknown Action", HCU_DISPLAY_AS_RAW ) . " 1425");
    }

    // are they confirming their own transaction?
    if ( ($actionStatus == 10 || $actionStatus == 90) &&
         ($txnRow["user_id"] == $pHBEnv["Uid"]) ) {
      throw new exception( $pHBEnv["MC"]->msg( "Trans approval failure", HCU_DISPLAY_AS_RAW ) . " 1430");
    }

    // are they cancelling someone else's transaction?
    if ( ($actionStatus == 99) &&
         ($txnRow["user_id"] != $pHBEnv["Uid"]) ) {
      throw new exception( $pHBEnv["MC"]->msg( "Trans approval failure", HCU_DISPLAY_AS_RAW ) . " 1436");
    }

    // is this a transaction waiting to be approved/declined?
    if ( ($actionStatus == 10 || $actionStatus == 90) &&
         $txnRow["approved_status"] != 0 ) {
      throw new exception( $pHBEnv["MC"]->msg( "Trans approval failure", HCU_DISPLAY_AS_RAW ) . " 1431");
    }

    if ( $pIsScheduled ) {
      // is this a scheduled transaction to be cancelled? (Okay if already cancelled)
      if ( $actionStatus == 99 &&
           $txnRow["approved_status"] != 0 &&
           $txnRow["approved_status"] != 10 &&
           $txnRow["approved_status"] != 99 ) {
        throw new exception( $pHBEnv["MC"]->msg( "Trans approval failure", HCU_DISPLAY_AS_RAW ) . " 1437");
      }

      // for scheduled transactions, just set it to the new approved_status
      $sql = "UPDATE cu_scheduledtxn SET approved_by = {$pHBEnv["Uid"]}, approved_date = now(), approved_status = $actionStatus WHERE id = $pDetailId AND user_id IN ($userIdStr)";

      $sth = db_query( $sql, $pHBEnv["dbh"] );
      if (!$sth) {
        throw new exception( $pHBEnv["MC"]->msg( "ACH Query Error", HCU_DISPLAY_AS_RAW ) . " 1426" );
      }

      $resultDetail = _GetActivityDetailScheduled( $pHBEnv, $pDetailId );
    } else {
      if ( $actionStatus == 10 ) {
        // need to submit as a transfer
        $aryApprovalResults = array();
        if (!ApproveTransfer($pHBEnv["dbh"], $pHBEnv, $pHBEnv["MC"], $pDetailId, $aryApprovalResults)) {
          throw new exception($aryApprovalResults["status"]["errors"][0] . "1432");
        }

        // save the approval confirmation code
        $confirmationCode = $aryApprovalResults["status"]["confirm"];

        // If a regular transaction is approved, try to post it to the core.
        if ( in_array( $transferFeatureCode, array(FEATURE_TRANSFERS, FEATURE_M2M_TRANSFERS) ) ) {
          $aryProcessResults = array();
          if (!ProcessTransfer($pHBEnv["dbh"], $pHBEnv, $pHBEnv["MC"], $pDetailId, $aryProcessResults, true)) {
            // since there was an error posting to the core, we revert approval
            // and commit only the cucorerequest record
            RevertMarkAsApproved($pDetailId, $pHBEnv["dbh"], $pHBEnv["Cu"], "1433");
            // 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($aryProcessResults["status"]["errors"][0] . "1433");
          }

          // use the processing confirmation code
          $confirmationCode = $aryProcessResults["txn"]["data_confirm"];
        }

        // return the confirmation code
        $returnData["data"]["confirm"] = $confirmationCode;
      } else {
        // apply the status because it is either a cancel or decline
        // make sure it is someone in the group
        $sql = "UPDATE {$pHBEnv["Cu"]}transhdr SET approved_by = {$pHBEnv["Uid"]}, approved_date = now(), approved_status = $actionStatus WHERE id = $pDetailId AND posted_by IN ($userIdStr)";

        $sth = db_query( $sql, $pHBEnv["dbh"] );
        if (!$sth) {
          throw new exception( $pHBEnv["MC"]->msg( "ACH Query Error", HCU_DISPLAY_AS_RAW ) . " 1426" );
        }
      }

      $resultDetail = _GetActivityDetailRegular( $pHBEnv, $pDetailId );
    }

    $returnData["data"]["details"] = $resultDetail["data"];
  } catch( Exception $e ) {
    // get the message and error code
    $message = $e->getMessage();

    $returnData["code"] = "999";
    $returnData["error"] = $message;
  }

  return $returnData;
} // end DoActivityAction


/**
 * Utility function to reset approved* attributes from ${CU}transhdr table
 * when the transfer process fails.
 *
 * @param $transferId - transfer id to delete
 * @param $dbh - database handler
 * @param $Cu - CU code
 *
 * @throws Exception if the transhdr record update fails
 *
 */
function RevertMarkAsApproved($transferId, $dbh, $Cu, $errCode) {

    try {
        $transHdrTbl = trim(strtolower($Cu)) . "transhdr";

        // reset approved* attributes
        $sqlUpdateHdr = "UPDATE ${transHdrTbl} SET".
                      " approved_by = NULL,".
                      " approved_date = NULL,".
                      " approved_status = NULL".
                      " WHERE id = ${transferId}";

        $sqlUpdateHdrRs = db_query($sqlUpdateHdr, $dbh);

        if (!$sqlUpdateHdrRs) {
            if ($errCode == "1433") {
                throw new exception("Transfer approval reset failed.". $errCode);
            } else {
                throw new exception("Transfer approval reset failed.", $errCode);
            }
        } else {
            // commit the transhdr update including cucorerequests record
            db_work($dbh, HOMECU_WORK_COMMIT);
        }
    } catch (Exception $ex) {
        throw $ex;
    }
}

// Get the information from the given external account. This can be an external ACH or a m2m account.
// NOTE: any error has the function just returning "unknown" as the account.
function _GetExternalAccount( $pHBEnv, $pExtId ) {
  $returnData = array( "display" => "000", "name" => "", "routing" => "", "account" => "" );

  try {
    // get the requested information, making sure it really is for this user (or at least in this user's group)
    $sql = "SELECT e.*, u.group_id as user_group, t.group_id as test_group
            FROM {$pHBEnv["Cu"]}extaccount e
            INNER JOIN {$pHBEnv["Cu"]}user u ON u.user_id = e.user_id
            INNER JOIN {$pHBEnv["Cu"]}user t ON t.user_id = {$pHBEnv["Uid"]}
            WHERE e.id = $pExtId";

    $sth = db_query( $sql, $pHBEnv["dbh"] );
    if (!$sth) {
      throw new exception($pHBEnv["MC"]->msg( "ACH Query Error", HCU_DISPLAY_AS_RAW ) . " 1434");
    }

    $accountRow = db_fetch_assoc($sth, 0);

    if ( $accountRow["user_group"] != $accountRow["test_group"] ) {
      throw new exception($pHBEnv["MC"]->msg( "Invalid account access", HCU_DISPLAY_AS_RAW ) . " 1435");
    }

    $acctInfo = HCU_JsonDecode( $accountRow["remote_info"] );

    $returnData["display"] = $accountRow["display_name"];

    if ( $accountRow["type"] == "EXT" ) {
      $returnData["name"] = $acctInfo["rdfi"]["name"];
      $returnData["routing"] = $acctInfo["rdfi"]["routing"];
      $returnData["account"] = $acctInfo["rdfi"]["account"];
    } else {
      $returnData["name"] = $acctInfo["rdfi"]["name"];
      $returnData["account"] = $acctInfo["rdfi"]["account"];
    }
  } catch( Exception $e ) {
    // not worring about message and error code

    $returnData["display"] = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
    $returnData["name"] = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
    $returnData["routing"] = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
    $returnData["account"] = $pHBEnv["MC"]->msg( "Unknown", HCU_DISPLAY_AS_RAW );
  }

  return $returnData;

} // end _GetExternalAccount