aMemberSupport.i

<?php
/**
 *  Reply:
 *  @uses return data to client view print to json
 *  @param assoc $pResult: array contining results of search
 *  @param assoc $pReply: empty array to return to client
 *  @param assoc $pOperation: requested search operation
 */
function MemberReply($pResult, $pReply, $pOperation) {
  $pReply['operation'] = $pOperation;
  if (isset($pResult['data']) && count($pResult['data'])) $pReply['data'] = $pResult['data'];
  if (isset($pResult['info']) && count($pResult['info'])) $pReply['info'] = $pResult['info'];

  print json_encode(array("Results" => $pReply));
}

/**
 *  MemberContext:
 *  @uses create a context array holding any needed data for a member hub
 *  card function.
 *
 *  @param $pEnv array: $pEnv array: evironment object for debugging
 *  @param $pCu string: cu code used for accessing variables and database tables
 *  @param $member string | array: possible needed member values for member hub
 *  functions.
 *
 *  @return $vContext array: array of member hub function data
 */
function MemberContext($pEnv, $pCu, $pMember = null) {
  $mCu = prep_save($pCu, 20);

  $mContext = array(
    "cu_table" => strtolower($mCu),
    "cu_code" => strtoupper($mCu),
    "m_account" => $pMember ? ( isset($pMember['m_account']) ? prep_save($pMember['m_account'], 12) : null ) : null
  );

  return $mContext;
}

/**
 *  MemberValidate:
 *  @uses validate the json string of parameters submitted by the user.
 *  this function will prepare the data for submission to the database (if needed).
 *
 *  @param $pEnv array: evironment object for debugging
 *  @param $pParameters string: json string of field/value pairs from user submitted
 *  form.
 *
 *  @return $vParameters array: array of data valid for use in the database
 */
function MemberValidate($pEnv, $pParameters, $pJson = false) {
  $mParameters = $pParameters;
  $mValidate = array();
  // if parameters are in json string form
  // decode into array
  if ($pJson) {
    $mParameters = html_entity_decode($pParameters, ENT_QUOTES);
    $mParameters = HCU_JsonDecode($mParameters);
  }

  // validate member parameter if available
  if (isset($mParameters['m_account'])) {

    $mAccount = $mParameters['m_account'];
    $mAccount = strtolower($mAccount);
    $mAccount = prep_save($mAccount, 12);
    $mAccount = preg_replace('/[^0-9]/', "", $mAccount);
    $mAccount = trim($mAccount);

    $mValidate['m_account'] = $mAccount;
  }

  return $mValidate;
}

/**
 *  MemberSelect:
 *  @uses select a member by specific parameters, for now select only by
 *  member accountnumber stored in the context variable.
 *
 *  @param $pEnv array: evironment object for debugging
 *  @param $pDbh object: database access variable
 *  @param $pContext array: array of data needed for multiple member hub functions:
 *  in this case the member accountnumber.
 *
 *  @return $sqlReturn array: single data row, the selected member
 */
function MemberSelect($pEnv, $pDbh, $pContext) {
  $cuTable = $pContext['cu_table'];
  $cuCode = $pContext['cu_code'];
  $cuMember = $pContext['m_account'];

  $sqlReturn = array();

  // select number of users with this account
  $sqlCount = "
    SELECT COUNT(DISTINCT ua.user_id) m_count,
    CASE WHEN BOOL_OR(COALESCE(TRIM(u.employee), 'N') = 'Y')
         THEN 'Y'
         ELSE 'N' END m_employee
    FROM {$cuTable}useraccounts ua
    LEFT JOIN ${cuTable}user u ON ua.user_id = u.user_id
    WHERE ua.accountnumber = '$cuMember'";

  $sqlSelect = "
    SELECT TRIM(img) AS image
    FROM cuadmin
    WHERE cu = '$cuCode'";
  $sqlSelectRs = db_query($sqlSelect, $pDbh);
  if (!$sqlSelectRs) {
    if (isset($pEnv))
      $pEnv['logger']->error(db_last_error());
    throw new Exception("Failed to read credit union image vendor.");
  };
  $sqlData = db_fetch_array($sqlSelectRs, 0);
  $sqlSub = $sqlData['image'];
  if ($sqlSub == "NO" || $GLOBALS['CU_SHOWIMAGES'] == 0) {
    $sqlSub = "NO";
  }

  $sqlColumns = "
    u.accountnumber AS m_account,
    u.estmnt_flag AS m_stmnt,
    u.billpayid AS m_payid,
    u.rdcsetting AS m_rdc,
    u.restrictions AS m_restr,
    '$sqlSub' AS m_image,
    t.m_count,
    t.m_employee";
  $sqlSelect = "
    SELECT $sqlColumns
    FROM {$cuTable}memberacct u
    CROSS JOIN ($sqlCount) t
    WHERE u.accountnumber = '$cuMember'";

  $sqlSelectRs = db_query($sqlSelect, $pDbh);
  if (!$sqlSelectRs) {
    if (isset($pEnv))
      $pEnv['logger']->error(db_last_error());
    throw new Exception("Failed to select member.");
  }

  $sqlReturn['member'] = db_fetch_all($sqlSelectRs)[0];
  return $sqlReturn;
}

/**
 *  MemberEncrypt:
 *  @uses encode member data from anywhere given at least the member accountnumber. This function
 *  will also encode the string for url purposes.
 *
 *  @param $pEnv array: $pEnv array: evironment object for debugging
 *  @param $pCu string: cu code used for accessing variables and database tables
 *  @param $pMember array: member data to encode
 *  @param $pJson boolean: allows user to pass array or json string to be encoded (optional)
 *
 *  @return $sMemberEncrypt string: encoded data string
 */
function MemberEncrypt($pEnv, $pCu, $pMember, $pJson = false) {
  $sMemberEncode = $pMember;

  if ($pJson) {
    $sMemberEncode = html_entity_decode($sMemberEncode, ENT_QUOTES);
    $sMemberEncode = HCU_JsonDecode($sMemberEncode);
  }

  $sMemberEncrypt = HCU_PayloadEncode($pCu, $sMemberEncode);
  return $sMemberEncrypt;
}

/**
 *  MemberDecrypt:
 *  @uses decrypt member data from anywhere given the encrypted string, this function will
 *  decode any url characters if neccessary.
 *
 *  @param $pEnv array: $pEnv array: evironment object for debugging
 *  @param $pCu string: cu code used for accessing variables and database tables
 *  @param $pEncode string: encrypted data string
 *  @param $pJson boolean: allows user to return an array or json string (optional)
 *
 *  @return $sMemberDecode string | array: decrypted member data as string or array
 */
function MemberDecrypt($pEnv, $pCu, $pEncrypt, $rJson = false) {
  $sMemberDecrypt = HCU_PayloadDecode($pCu, $pEncrypt, $rJson);
  return $sMemberDecrypt;
}

?>