aMemberSettings.prg

<?php
/**
 *  @package MemberHub
 *  @author MGHandy
 *
 *  @uses this script facilitates in viewing /editing member settings, sub-accounts
 *  and security values associated with the select member account.
 *
 *  @uses view/edit rdc, billpay id and e-statement flag values
 *  @uses view sub-accounts associated with the select member accounts
 *  @uses view/edit restrictions value
 *
 *  @param operation    string: requested operation for this script
 *  @param payload      string: encryption for the selected member
 *  @param mParameters  string: json encoded string of all values to be updated
 *
 *  @return json
 */
require_once("$admLibrary/aMemberSupport.i");

try {
  $admVars = array();
  $admOk = array(
    "operation" => array("filter" => FILTER_SANITIZE_STRING),
    "payload" => array("filter" => FILTER_SANITIZE_STRING),
    "mParameters" => array("filter" => FILTER_SANITIZE_STRING)
  );
  HCU_ImportVars($admVars, "MEMBER_SETTINGS", $admOk);

  $aOperation = isset($admVars["MEMBER_SETTINGS"]["operation"]) ? $admVars["MEMBER_SETTINGS"]["operation"] : null;
  $aPayload = isset($admVars["MEMBER_SETTINGS"]["payload"]) ? $admVars["MEMBER_SETTINGS"]["payload"] : null;
  $aParameters = isset($admVars["MEMBER_SETTINGS"]["mParameters"]) ? $admVars["MEMBER_SETTINGS"]["mParameters"] : null;

  $aMember = $aPayload ?
    MemberDecrypt($SYSENV, $Cu, $aPayload) :
    null;

  $aContext = $aPayload ?
    MemberContext($SYSENV, $Cu, $aMember['member']) :
    MemberContext($SYSENV, $Cu);

  $aryResult = array();
  $aryReply = array();

  switch ($aOperation) {
    case "":
      PrintMemberSettings();
      break;
    case "memberReadSettings":

      header('Content-type: application/json');

      $aSettings = MemberReadSettings($SYSENV, $dbh, $aContext);
      $aAccounts = MemberReadAccounts($SYSENV, $dbh, $aContext);

      $aryResult['data']['settings'] = $aSettings['settings'];
      $aryResult['data']['accounts'] = $aAccounts['accounts'];
      MemberReply($aryResult, $aryReply, $aOperation);
      break;
    case "memberUpdateSettings":
      header('Content-type: application/json');

      $aValidate = MemberValidateSetings($SYSENV, $aParameters);
      $aSettings = MemberUpdateSettings($SYSENV, $dbh, $aContext, $aValidate, $Cn);

      // re-select the group for all new data
      $aMember = MemberSelect($SYSENV, $dbh, $aContext);
      // get member payload
      $aMemberEncrypt = MemberEncrypt($SYSENV, $Cu, $aMember);

      $aryResult['data']['member'] = $aMember;
      $aryResult['data']['encrypt'] = $aMemberEncrypt;
      $aryResult['info'] = $aSettings['message'];
      MemberReply($aryResult, $aryReply, $aOperation);
      break;
    default:
      throw new Exception("Unknown server request: " . $aOperation);
      break;
  }

} catch (Exception $e) {
  $aryReply['errors'][] = $e->getMessage();
  $aryResult['data'] = array();
  $aryResult['info'] = array();

  MemberReply($aryResult, $aryReply, $aOperation);
  exit;
}

/**
 *  @package MemberValidateSetings
 *  @uses validate incoming values to update member settings for input
 *  into the database.
 *
 *  @param  pEnv      array:  environment variable for debugging
 *  @param  pSettings array:  json string of updatable settings values
 *  to be updated.
 *
 *  @return sqlReturn array:  array of validated settings
 */
function MemberValidateSetings($pEnv, $pSettings) {
  $mValidate = array();

  $mSettings = html_entity_decode($pSettings, ENT_QUOTES);
  $mSettings = HCU_JsonDecode($mSettings);

  //if (isset($mSettings['m_stmnt'])) {
  if (array_key_exists("m_stmnt", $mSettings)) {
    $mStmnt = $mSettings['m_stmnt'];
    $mStmnt = $mStmnt ? "Y" : "N";

    $mValidate['m_stmnt'] = $mStmnt;
  }

  if (array_key_exists("m_rdc", $mSettings)) {
    $mRdc = $mSettings['m_rdc'] ?
      intval($mSettings['m_rdc']) :
      null;

    $mValidate['m_rdc'] = $mRdc;
  }

  if (array_key_exists("m_payid", $mSettings)) {
    $mPayId = prep_save($mSettings['m_payid'], 12);
    $mPayId = preg_replace('/[^0-9a-zA-Z]/', "", $mPayId);
    $mPayId = trim($mPayId);

    $mValidate['m_payid'] = strlen($mPayId) > 0 ?
      $mPayId : null;
  }

  if (array_key_exists("m_restr", $mSettings)) {
    $mRestr = strtoupper($mSettings['m_restr']);
    $mRestr = prep_save($mRestr, 1);
    $mRestr = trim($mRestr, 1);

    $mValidate['m_restr'] = strlen($mRestr) > 0 ?
      $mRestr : null;
  }

  return $mValidate;
}

/**
 *  @package MemberReadAccounts
 *  @uses read all sub-accounts associated with the selected member account
 *
 *  @param  pEnv      array: environment variable for debugging
 *  @param  pDbh      object: database access object
 *  @param  pContext  array: array of common data needed accross the member hub
 *
 *  @return sqlReturn array: array of sub-accounts
 */
function MemberReadAccounts($pEnv, $pDbh, $pContext) {
  $cuTable = $pContext['cu_table'];
  $cuCode = $pContext['cu_code'];
  $cuMember = $pContext['m_account'];

  $sqlReturn = array();

  // select all balance sub accounts for this member account.
  $sqlColumns = "
    ab.description AS a_desc,
    ab.accounttype AS a_type,
    ab.may_deposit AS m_deposit,
    ab.may_withdraw AS m_withdraw,
    ma.balance_stamp AS b_stamp,
    ma.balance_attempt AS b_attempt,
    ab.history_stamp AS h_stamp,
    ab.history_attempt AS h_attempt";
  $sqlSelect = "
    SELECT $sqlColumns
    FROM {$cuTable}accountbalance ab
    LEFT JOIN {$cuTable}memberacct ma
      ON ma.accountnumber = ab.accountnumber
    WHERE ab.accountnumber = '$cuMember'
    ORDER BY ab.accounttype ASC";
  $sqlSelectRs = db_query($sqlSelect, $pDbh);
  if (!$sqlSelectRs) {
    $pEnv['logger']->error(db_last_error());
    throw new Exception("Failed to read member deposit accounts.");
  }

  // set deposit accounts
  $sqlData = db_fetch_all($sqlSelectRs);
  if (is_array($sqlData)) {
    foreach ($sqlData as $key => $value) {
      // convert timestamps
      $cuTimeZone = GetCreditUnionTimezone($pDbh, $cuCode);

      $value['b_stamp'] = ($value['b_stamp'] && abs($value['b_stamp']) > 1) ?
        GetDateFormatTimezone(abs($value['b_stamp']), "m/d/Y h:i A", $cuTimeZone) :
        null;
      $value['b_attempt'] = ($value['b_attempt'] && abs($value['b_attempt']) > 1) ?
        GetDateFormatTimezone(abs($value['b_attempt']), "m/d/Y h:i A", $cuTimeZone) :
        null;
      $value['h_stamp'] = ($value['h_stamp'] && abs($value['h_stamp']) > 1) ?
        GetDateFormatTimezone(abs($value['h_stamp']), "m/d/Y h:i A", $cuTimeZone) :
        null;
      $value['h_attempt'] = ($value['h_attempt'] && abs($value['h_attempt']) > 1) ?
        GetDateFormatTimezone(abs($value['h_attempt']), "m/d/Y h:i A", $cuTimeZone) :
        null;

      $sqlReturn['accounts']['deposit'][] = $value;
    }
  } else {
    $sqlReturn['accounts']['deposit'] = array();
  }


  // select all loan sub accounts for this member account.
  $sqlColumns = "
    lb.description AS a_desc,
    lb.loannumber AS a_type,
    lb.may_addon AS m_addon,
    lb.may_payment AS m_payment,
    ma.balance_stamp AS b_stamp,
    ma.balance_attempt AS b_attempt,
    lb.history_stamp AS h_stamp,
    lb.history_attempt AS h_attempt";
  $sqlSelect = "
    SELECT $sqlColumns
    FROM {$cuTable}loanbalance lb
    LEFT JOIN {$cuTable}memberacct ma
      ON ma.accountnumber = lb.accountnumber
    WHERE lb.accountnumber = '$cuMember'
    ORDER BY lb.loannumber ASC";
  $sqlSelectRs = db_query($sqlSelect, $pDbh);
  if (!$sqlSelectRs) {
    $pEnv['logger']->error(db_last_error());
    throw new Exception("Failed to read member loan accounts.");
  }

  // determine if loan typ 18 = credit
  $dataType = ($GLOBALS['Fset2'] & $GLOBALS['CU2_SPEC18']) == $GLOBALS['CU2_SPEC18'];
  $sqlData = db_fetch_all($sqlSelectRs);
  if (is_array($sqlData)) {
    foreach ($sqlData as $key => $value) {
      $cuTimeZone = GetCreditUnionTimezone($pDbh, $cuCode);

      $value['b_stamp'] = ($value['b_stamp'] && abs($value['b_stamp']) > 1) ?
        GetDateFormatTimezone(abs($value['b_stamp']), "m/d/Y h:i A", $cuTimeZone) :
        null;
      $value['b_attempt'] = ($value['b_attempt'] && abs($value['b_attempt']) > 1) ?
        GetDateFormatTimezone(abs($value['b_attempt']), "m/d/Y h:i A", $cuTimeZone) :
        null;
      $value['h_stamp'] = ($value['h_stamp'] && abs($value['h_stamp']) > 1) ?
        GetDateFormatTimezone(abs($value['h_stamp']), "m/d/Y h:i A", $cuTimeZone) :
        null;
      $value['h_attempt'] = ($value['h_attempt'] && abs($value['h_attempt']) > 1) ?
        GetDateFormatTimezone(abs($value['h_attempt']), "m/d/Y h:i A", $cuTimeZone) :
        null;

      // loan type is credit
      if ($value['a_type'] == 18 && $dataType) {
        // set credit account
        $sqlReturn['accounts']['credit'][] = $value;
      } else {
        $sqlReturn['accounts']['loan'][] = $value;
      }
    }
  } else {
    $sqlReturn['accounts']['credit'] = array();
    $sqlReturn['accounts']['loan'] = array();
  }

  return $sqlReturn;
}

/**
 *  @package MemberReadSettings
 *  @uses read rdc, billpay id and e-statement values for the
 *  selected member account.
 *
 *  @param  pEnv      array: environment variable for debugging
 *  @param  pDbh      object: database access object
 *  @param  pContext  array: array of common data needed accross the member hub
 *
 *  @return sqlReturn array: array of settings values
 */
function MemberReadSettings($pEnv, $pDbh, $pContext) {
  $cuTable = $pContext['cu_table'];
  $cuCode = $pContext['cu_code'];
  $cuMember = $pContext['m_account'];

  $sqlReturn = array();
  $sqlColumns = "
    TRIM(estmnt_flag) AS m_stmnt,
    TRIM(billpayid) AS m_payid,
    rdcsetting AS m_rdc";
  $sqlSelect = "
    SELECT $sqlColumns
    FROM {$cuTable}memberacct ma
      WHERE accountnumber = '$cuMember'";
  $sqlSelectRs = db_query($sqlSelect, $pDbh);
  if (!$sqlSelectRs) {
    $pEnv['logger']->error(db_last_error());
    throw new Exception("Failed to read member settings.");
  }

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

/**
 *  @package MemberUpdateSettings
 *  @uses update rdc, bill pay id, e-statement and restrictions values
 *
 *  @param  pEnv        array: environment variable for debugging
 *  @param  pDbh        object: database access object
 *  @param  pContext    array: array of common data needed accross the member hub
 *  @param  pParameters array: array of values to update.
 *  @param  $Cn         The logged in user (for auditing)
 *
 *  @return sqlReturn array: updated values
 */
function MemberUpdateSettings($pEnv, $pDbh, $pContext, $pParameters, $Cn) {
  $cuTable = $pContext['cu_table'];
  $cuCode = $pContext['cu_code'];
  $cuMember = $pContext['m_account'];

  $sqlReturn = array();
  $sqlColumns = "";
  $sqlValues = "";

  $updateArray = array("_action" => "update", "accountnumber" => $cuMember);

  // check which fields to update
  if (HCU_array_key_exists("m_stmnt", $pParameters)) {
    $column = $pParameters['m_stmnt'] ? trim($pParameters['m_stmnt']) : "";
    $updateArray ["estmnt_flag"] = $column == "" ? null : $column;
    $sqlReturn['message'][] = "eStatement Flag successfully updated.";
  }

  if (HCU_array_key_exists("m_rdc", $pParameters)) {
    $column = $pParameters['m_rdc'] ? trim($pParameters['m_rdc']) : "";
    $updateArray ["rdcsetting"] = $column == "" ? null : $column;
    $sqlReturn['message'][] = "RDC Setting successfully updated.";
  }

  if (HCU_array_key_exists("m_restr", $pParameters)) {
    $column = $pParameters['m_restr'] ? trim($pParameters['m_restr']) : "";
    $updateArray ["restrictions"] = $column == "" ? null : $column;
    $sqlReturn['message'][] = "Restrictions successfully updated.";
  }

  // must update billpay on it's own because it must be unique in the database
  if (HCU_array_key_exists("m_payid", $pParameters)) {
    // 06-19: when there are records with empy values for billpayid, matching on empty
    // input will throw the exception below, even if those records aren't associated
    // with this member account. Added and clause to select to exclude empty values.
    $sqlSelect = "
      SELECT COUNT(billpayid)
      FROM {$cuTable}memberacct
      WHERE billpayid = '{$pParameters['m_payid']}'
      AND billpayid <> '' AND billpayid is not null";
    $sqlSelectRs = db_query($sqlSelect, $pDbh);
    $sqlData = db_fetch_all($sqlSelectRs);
    if ($sqlData[0]['count'] > 0) {
      // notify of unable to update, must be unique billpayid
      throw new Exception("Failed to update Bill Pay ID, the selected id already exists.");
    }

    $column = $pParameters['m_payid'] ? trim($pParameters['m_payid']) : "";
    $updateArray ["billpayid"] = $column == "" ? null : $column;
    $sqlReturn['message'][] = "Bill Pay ID successfully updated.";
  }

  $updateArray = array("memberacct" => array($updateArray));

  $context = "admin";
  $script = "userSupport.prg";

  $sql = "select email from cuadminusers where user_name = '$Cn' and cu = '$cuCode'";
  $sqls[] = $sql;
  $sth = db_query($sql, $pDbh);
  if (!$sth)
    throw new exception("email query failed.", 7);
  $email = db_fetch_row($sth)[0];

  if (!db_work ($pDbh, HOMECU_WORK_BEGIN))
    throw new exception("begin query failed.", 32);

  $pEnv ["cu"] = $cuCode;

  if (DataUserTableUpdate($pDbh, $pEnv, null, $updateArray, 0, "A_UPD", $context, $script, "A", "Member Settings", $Cn, $email, trim($_SERVER["REMOTE_ADDR"]), false, $cuMember) === false) {
    throw new exception ("Unable to update member settings.");
  }

  if (!db_work ($pDbh, HOMECU_WORK_COMMIT))
    throw new exception("commit query failed.", 32);

  $sql = "select accountnumber AS m_account, estmnt_flag AS m_stmnt, billpayid AS m_payid, rdcsetting AS m_rdc, restrictions AS m_restr
          from ${cuTable}memberacct where accountnumber = '" . prep_save($cuMember, 12) . "'";

  $sth = db_query($sql, $pDbh);
  if (!$sth) {
    throw new exception ("Select query failed.");
  }

  $sqlReturn['settings'] = db_fetch_assoc($sth, 0);
  return $sqlReturn;
}
?>

<?php
/**
 *  @package PrintMemberSettings
 *  @uses print neccessary html/javascript to run the selected card
 */
function PrintMemberSettings() { ?>
<style type="text/css">
.k-grid-content {
  max-height: 165px;
}
</style>
<div id="settings">
  <div id="status"></div>
  <!--TABS: -->
  <div class="container-fluid">
    <div id="tabs"></div>
  </div>

  <!--TAB VIEW: SECURITY-->
  <div class="well well-sm col-sm-12" id="tabSecurity">
    <div class="row">
      <div class="col-xs-5 col-sm-4 col-md-3">
        <label for="inpRestriction">
          <span>Restrictions</span>
          <span class="fa fa-asterisk" style="color: #f0ad4e;"
            data-bind="visible: dirty"></span>
        </label>
      </div>

      <div class="col-xs-7 col-sm-4 col-md-3">
        <input class="hcu-all-100" id="inpRestriction"
          data-role="dropdownlist"
          data-value-field="value"
          data-text-field="text"
          data-bind="
            source: list,
            value: source.e_restr,
            events: { change: change }">
      </div>
    </div>
  </div>

  <!--TAB VIEW: ACCOUNTS-->
  <div class="well well-sm col-sm-12" id="tabAccounts">
    <div data-bind="visible: showNoRecords">
      <div class="hcu-secondary">
        <div class="vsgSecondary">No Records Found</div>
      </div>
    </div>
    <div data-bind="visible: showDeposit">
      <h3>Deposit Accounts</h3><br>
      <div id="depositGrid"
        data-role="grid"
        data-bind="source: deposit"
        data-columns="[
          { title: 'Accounts', columns: [
            { field: 'a_type', title: 'Type', width: '150px' },
            { field: 'a_desc', title: 'Name', width: '150px',
              attributes: { 'class': 'showEllipsis' }
            }
          ]},
          { title: 'May', columns: [
            { field: 'm_withdraw', title: 'Withdraw', width: '90px',
              template: '<span class=\'vsgSecondary\'># if (m_withdraw == \'t\') { # <div class=\'restriction allow readonly hcu-all-100\'><i class=\'fa fa-check\'></i></div> # } else { #<div class=\'restriction ban readonly hcu-all-100\'><i class=\'fa fa-ban\'></i></div> # } #</span>'
            },
            { field: 'm_deposit', title: 'Deposit', width: '90px',
              template: '<span class=\'vsgSecondary\'># if (m_deposit == \'t\') { # <div class=\'restriction allow readonly hcu-all-100\'><i class=\'fa fa-check\'></i></div> # } else { #<div class=\'restriction ban readonly hcu-all-100\'><i class=\'fa fa-ban\'></i></div> # } #</span>'
            },
          ]},
          <?php if ($GLOBALS['live'] == 'Y'): ?>
          { title: 'Balance', columns: [
            { field: 'b_stamp', title: 'Retrieved', width: '150px', },
            { field: 'b_attempt', title: 'Attempted', width: '150px', }
          ]},
          { title: 'History', columns: [
            { field: 'h_stamp', title: 'Retrieved', width: '150px', },
            { field: 'h_attempt', title: 'Attempted', width: '150px', }
          ]}
          <?php endif; ?>
        ]"></div>
    </div>
    &nbsp;
    <div data-bind="visible: showLoan">
      <h3>Loan Accounts</h3><br>
      <div id="loanGrid"
        data-role="grid"
        data-bind="source: loan"
        data-columns="[
          { title: 'Accounts', columns: [
            { field: 'a_type', title: 'Type', width: '150px', },
            { field: 'a_desc', title: 'Name', width: '150px',
              attributes: { 'class': 'showEllipsis' }
            }
          ]},
          { title: 'May', columns: [
            { field: 'm_addon', title: 'Add-on', width: '90px',
              template: '<span class=\'vsgSecondary\'># if (m_addon == \'t\') { # <div class=\'restriction allow readonly hcu-all-100\'><i class=\'fa fa-check\'></i></div> # } else { #<div class=\'restriction ban readonly hcu-all-100\'><i class=\'fa fa-ban\'></i></div> # } #</span>'
            },
            { field: 'm_payment', title: 'Pay', width: '90px',
              template: '<span class=\'vsgSecondary\'># if (m_payment == \'t\') { # <div class=\'restriction allow readonly hcu-all-100\'><i class=\'fa fa-check\'></i></div> # } else { #<div class=\'restriction ban readonly hcu-all-100\'><i class=\'fa fa-ban\'></i></div> # } #</span>'
            }
          ]},
          <?php if ($GLOBALS['live'] == 'Y'): ?>
          { title: 'Balance', columns: [
            { field: 'b_stamp', title: 'Retrieved', width: '150px', },
            { field: 'b_attempt', title: 'Attempted', width: '150px', }
          ]},
          { title: 'History', columns: [
            { field: 'h_stamp', title: 'Retrieved', width: '150px', },
            { field: 'h_attempt', title: 'Attempted', width: '150px', }
          ]}
          <?php endif; ?>
        ]"></div>
    </div>
    &nbsp;
    <div data-bind="visible: showCredit">
      <h3>Credit Accounts</h3><br>
      <div id="creditGrid"
        data-role="grid"
        data-bind="source: credit"
        data-columns="[
          { title: 'Accounts', columns: [
            { field: 'a_type', title: 'Type', width: '150px' },
            { field: 'a_desc', title: 'Name', width: '150px',
              attributes: { 'class': 'showEllipsis' }
            }
          ]},
          { title: 'May', columns: [
            { field: 'm_addon', title: 'Add-on', width: '90px',
              template: '<span class=\'vsgSecondary\'># if (m_addon == \'t\') { # <div class=\'restriction allow readonly hcu-all-100\'><i class=\'fa fa-check\'></i></div> # } else { #<div class=\'restriction ban readonly hcu-all-100\'><i class=\'fa fa-ban\'></i></div> # } #</span>'
            },
            { field: 'm_payment', title: 'Pay', width: '90px',
              template: '<span class=\'vsgSecondary\'># if (m_payment == \'t\') { # <div class=\'restriction allow readonly hcu-all-100\'><i class=\'fa fa-check\'></i></div> # } else { #<div class=\'restriction ban readonly hcu-all-100\'><i class=\'fa fa-ban\'></i></div> # } #</span>'
            }
          ]},
          <?php if ($GLOBALS['live'] == 'Y'): ?>
          { title: 'Balance', columns: [
            { field: 'b_stamp', title: 'Retrieved', width: '150px', },
            { field: 'b_attempt', title: 'Attempted', width: '150px', }
          ]},
          { title: 'History', columns: [
            { field: 'h_stamp', title: 'Retrieved', width: '150px', },
            { field: 'h_attempt', title: 'Attempted', width: '150px', }
          ]}
          <?php endif; ?>
        ]"></div>
    </div>
  </div>

  <!--TAB VIEW: SETTINGS-->
  <div class="well well-sm col-sm-12" id="tabSettings">
    <div class="row">
      <div class="col-xs-5 col-sm-4 col-md-3">
        <label for="inpEstmnt">
          <span>eStatements</span>
          <span class="fa fa-asterisk" style="color: #f0ad4e;"
            data-bind="visible: source.e_dirty"></span>
        </label>
      </div>

      <div class="col-xs-7 col-sm-4 col-md-3">
        <input id="inpEstmnt" type="checkbox" data-bind="checked: source.e_stmnt, events: { change: change }">
      </div>
    </div>
    &nbsp;
    <div class="row">
      <div class="col-xs-5 col-sm-4 col-md-3">
        <label for="inpRdc">
          <span>RDC Setting</span>
          <span class="fa fa-asterisk" style="color: #f0ad4e;"
            data-bind="visible: source.e_dirty"></span>
        </label>
      </div>

      <div class="col-xs-5 col-sm-4 col-md-3">
        <input id="inpRdc"
          data-role="numerictextbox"
          data-format="#"
          data-decimals="0"
          data-spinners="false"
          data-max="2147483647"
          data-min="0"
          data-bind="
            value: source.e_rdc,
            events: { change: change }">
      </div>
    </div>
    &nbsp;
    <div class="row">
      <div class="col-xs-5 col-sm-4 col-md-3">
        <label for="inpBpay">
          <span>Bill Pay ID</span>
          <span class="fa fa-asterisk" style="color: #f0ad4e;"
            data-bind="visible: source.e_dirty"></span>
        </label>
      </div>

      <div class="col-xs-7 col-sm-4 col-md-3">
        <input id="inpBpay"
          data-role="maskedtextbox"
          data-mask="AAAAAAAAAAAA"
          data-prompt-char=""
          data-min="0"
          data-bind="
            value: source.e_payid,
            events: { change: change }">
      </div>
    </div>
  </div>

  <div class="bottomButtons">
    <div class="hcu-edit-buttons k-state-default">
      <span class="hcu-icon-delete">
      </span>
      <a href="##" id="lnkCancel">Cancel</a>
      &ensp;
      <a href="##" id="btnUpdate" class="k-button k-primary">
        <i class="fa fa-check fa-lg"></i>
        Update
      </a>
    </div>
  </div>
</div>

<div id="settingsCancel">
  <p>This member's information has been changed.</p>
  <p>Do you wish to discard the changes?</p>
</div>

<?php

  // JQUERY PLUGIN FOR TABS: update from groupinfo
  printTabPlugin();
/**
 *  @package MemberSettings
 *  @uses this object is used to display and interact with the member account settings feature.
 *
 *  @var Init               public: call to initialize data/view/action objects
 *  @var Open               public: call to open the mamber search module/window
 *  @var Close              public: call to close the member search module/window
 *  @var Data               public: call to load payload and member display into
 *   MemberSettings object for later use.
 *
 *  @var InitDataSources    private: initialize all data sources/objects
 *  @var InitDataViews      private: initialize all data views/objects
 *  @var InitDataActions    private: initialize all user actions on html.
 *
 *  @var EventOpenWindow    private: open kendoDialog/kendoWindow objects
 *  @var EventCloseWindow   private: close kendoDialog/kendoWindow objects
 *  @var EventPopWindow     private: remove the correct window from the window stack.
 *
 *  @var Event*             private: other event functions explained by name.
 *    Some are entensions of kendo objects, others just help with events of html objects.
 *
 *  @var DataBuild*         private: these functions build up datasources for
 *    arrays, json objects and observables for use in manipulation and display.
 *
 *  @var Validate*          private: validation functions for forms, inputs, observables
 *    and any other data that could be altered.
 */
?>
<script type="text/javascript">
//# sourceURL=memberSettings.js
var MemberSettings = function() {
  var maLive = <?php echo json_encode($GLOBALS['live']); ?>;
  var maCardContainer = null;
  var maCardWindows = null;

  var maPayload = null;
  var maMember = null;
  var maCall = null;
  var maAction = null;

  var maSettings = null;
  var maCancel = null;
  var maUpdate = null;

  var maDataSource = null;

  var maTabs = null;
  var maTabSettings = null;
  var maDataSettings = null;
  var maObserveSettings = null;

  var maTabAccounts = null;
  var maDataAccounts = null;
  var maObserveAccounts = null;
  var maTooltipAccounts = null;

  var maTabSecurity = null;
  var maDataSecurity = null;
  var maListSecurity = null;
  var maObserveSecurity = null;

  var maDiscard = null;

  var ValidateSettings = function() {
    var label = null;
    var warning = null;
    var source = maObserveSettings.source;

    // validate e statement field
    label = $("label[for=inpEstmnt]");
    warning = $(label.find("span")[1]);
    if (source.e_stmnt != source.o_stmnt) {
      warning.show();
    } else {
      warning.hide();
    }

    // validate rdc field
    label = $("label[for=inpRdc]");
    warning = $(label.find("span")[1]);
    if (source.e_rdc != source.o_rdc) {
      warning.show();
    } else {
      warning.hide();
    }

    // validate billpay id field
    label = $("label[for=inpBpay]");
    warning = $(label.find("span")[1]);
    if (source.e_payid != source.o_payid) {
      warning.show();
    } else {
      warning.hide();
    }

    source.e_dirty =
      (source.e_stmnt != source.o_stmnt) ||
      (source.e_rdc != source.o_rdc) ||
      (source.e_payid != source.o_payid);

    return !source.e_dirty;
  }

  var ValidateSecurity = function() {
    var label = null;
    var warning = null;
    var source = maObserveSecurity.source;

    // validate restriction field
    label = $("label[for=inpRestriction]");
    warning = $(label.find("span")[1]);

    var value_e = null;
    var value_o = source.o_restr;
    if (source.e_restr) {
      if (typeof source.e_restr == "string") {
        value_e = source.e_restr;
      } else {
        value_e = source.e_restr.value;
      }
    } else {
      value_e = "";
    }

    source.e_dirty = value_e != value_o;
    if (value_e != value_o) {
      warning.show();
    } else {
      warning.hide();
    }

    return !source.e_dirty;
  }

  var DataBuildSettings = function(data) {
    maDataSettings = {
      o_payid: data.m_payid,
      o_stmnt: data.m_stmnt == "Y" ? true : false,
      o_rdc: data.m_rdc ? parseInt(data.m_rdc) : null,
      e_payid: data.m_payid,
      e_stmnt: data.m_stmnt == "Y" ? true : false,
      e_rdc: data.m_rdc ? parseInt(data.m_rdc) : null,
      e_dirty: false
    };

    maObserveSettings.set("source", maDataSettings);
  }

  var DataBuildAccounts = function(data) {
    if (data.deposit) {
      maObserveAccounts.set("deposit", data.deposit);
      maObserveAccounts.set("showDeposit", data.deposit.length > 0);
    }

    if (data.loan) {
      maObserveAccounts.set("loan", data.loan);
      maObserveAccounts.set("showLoan", data.loan.length > 0);
    }

    if (data.credit) {
      maObserveAccounts.set("credit", data.credit);
      maObserveAccounts.set("showCredit", data.credit.length > 0);
    }

    if (data.deposit.length == 0 && data.loan.length == 0 && data.credit.length == 0) {
      maObserveAccounts.set("showNoRecords", true);
    }
  }

  var DataBuildSecurity = function() {
    maListSecurity = [
      { text: "Locked", value: "L" },
      { text: "Read Only", value: "R" },
      { text: "Unlocked", value: "" }
    ];

    maDataSecurity = {
      o_restr: maMember.m_restr,
      e_restr: maMember.m_restr,
      e_dirty: false
    };

    maObserveSecurity.set("source", maDataSecurity);
    maObserveSecurity.set("list", maListSecurity);
  }

  var EventUpdateMember = function() {

    if (!maTabs.validate()) {
      var sourceSettings = maObserveSettings.source;
      var sourceSecurity = maObserveSecurity.source;
      var memberData = {};

      // check for update to e statements
      if (sourceSettings.e_stmnt != sourceSettings.o_stmnt) {
        memberData.m_stmnt = sourceSettings.e_stmnt;
      }

      // check for update to bill pay id
      if (sourceSettings.e_payid != sourceSettings.o_payid) {
        memberData.m_payid = sourceSettings.e_payid;
      }

      // check for update to rdc setting
      if (sourceSettings.e_rdc != sourceSettings.o_rdc) {
        memberData.m_rdc = sourceSettings.e_rdc;
      }

      // check for update to restrictions
      var value_e = null;
      if (sourceSecurity.e_restr) {
        if (typeof sourceSecurity.e_restr == "string") {
          value_e = sourceSecurity.e_restr;
        } else {
          value_e = sourceSecurity.e_restr.value;
        }
      } else {
        value_e = "";
      }

      if (sourceSecurity.e_dirty) {
        memberData.m_restr = value_e;
      }

      var stringData = JSON.stringify(memberData);
      var memberRequest = {
        operation: "memberUpdateSettings",
        payload: maPayload,
        mParameters: stringData
      };

      maDataSource.transport.options.read.type = "POST";
      maDataSource.read(memberRequest);
    }
  }

  var EventOpenWindow = function(e) {
    var windowElement = this.element[0];
    var windowId = windowElement.id;

    switch (windowId) {

    }

    maCardWindows.push(this);
  }

  var EventCloseWindow = function(e) {
    var windowElement = this.element[0];
    var windowId = windowElement.id;

    switch (maAction) {
      case "discardConfirm":
        EventPopWindow(windowId);

        var sourceSettings = maObserveSettings.source;
        var sourceSecurity = maObserveSecurity.source;
        // reset settings
        sourceSettings.e_stmnt = sourceSettings.o_stmnt;
        sourceSettings.e_rdc = sourceSettings.o_rdc;
        sourceSettings.e_payid = sourceSettings.o_payid;
        sourceSettings.e_dirty = false;

        // reset security
        sourceSecurity.e_restr = sourceSecurity.o_restr;
        sourceSecurity.e_dirty = false;

        // must set action to null to avoid infinite loop
        // if not null it will continue to drop into
        // this case and call close until stack overflow
        maAction = null;
        maSettings.close();
        break;
      default:
        if (windowId == "settings") {
          if (!maTabs.validate()) {
            e.preventDefault();
            maDiscard.open();
          } else {
            EventPopWindow(windowId);
            // setup validator, send back to hub
            $.homecuValidator.setup({
              formStatusField: "formStatus",
              formValidate: "cardContainerDiv"
            });
          }
        } else {
          EventPopWindow(windowId);
        }
        break;
    }

    maAction = null;
  }

  var EventPopWindow = function(windowId) {
    var popIndex = -1;
    for (var i = 0; i < maCardWindows.length; i++) {
      var openWindow = maCardWindows[i].element[0];
      var openId = openWindow.id;

      if (openId == windowId) {
        popIndex = i;
        break;
      }
    }

    if (popIndex > -1) {
      maCardWindows.splice(popIndex, 1);
    }
  }

  var InitDataSources = function() {
    maDataSource = new kendo.data.DataSource({
      transport: {
        read: {
          url: "main.prg",
          dataType: "json",
          contentType: "application/x-www-form-urlencoded",
          type: "GET",
          data: {
            ft: "103104"
          },
          cache: false
        }
      },
      requestStart: function(request) {
        showWaitWindow();
        //InfoClear();
      },
      requestEnd: function(response) {
        setTimeout(hideWaitWindow, 500);

        if (response.hasOwnProperty("response")) {
          if (response.response.hasOwnProperty("Results")) {
            var results = response.response.Results;

            if (results.hasOwnProperty("errors")) {
              $.homecuValidator.homecuResetMessage = true;
              $.homecuValidator.displayMessage(results.errors, $.homecuValidator.settings.statusError);
            } else if (results.hasOwnProperty("info")) {
              $.homecuValidator.homecuResetMessage = true;
              $.homecuValidator.displayMessage(results.info, $.homecuValidator.settings.statusSuccess);
            }
          } else {
            $.homecuValidator.displayMessage("Error Parsing Server", $.homecuValidator.settings.statusError);
          }
        } else {
          $.homecuValidator.displayMessage("Error Parsing Server", $.homecuValidator.settings.statusError);
        }
      },
      schema: {
        parse: function(response) {

          var results = null;
          var resultData = null;
          var resultOperation = null;

          if (response.hasOwnProperty("Results")) {
            results = response.Results;
            resultData = results.data;
            resultOperation = results.operation;
          }

          if (results.hasOwnProperty("errors")) {
            return [];
          }

          if (resultData == undefined || resultData == null) {
            return [];
          }

          setTimeout(function() {
            switch (resultOperation) {
              case "memberReadSettings":
                DataBuildSettings(resultData.settings);
                DataBuildAccounts(resultData.accounts);
                DataBuildSecurity();
                //InfoClear();
                maMember.cardTitle= "Account Settings";
                var template= kendo.template($("#titleTemplate").html());
                maSettings.title(template(maMember)).center().open();
                break;
              case "memberUpdateSettings":
                maMember = resultData.member.member;
                maMember.m_account = maMember.m_account == null ? null : maMember.m_account.trim();
                maMember.m_stmnt = maMember.m_stmnt == null ? null : maMember.m_stmnt.trim();
                maMember.m_payid = maMember.m_payid == null ? null : maMember.m_payid.trim();
                maMember.m_rdc = maMember.m_rdc == null ? null : maMember.m_rdc;
                maMember.m_restr = maMember.m_restr == null ? null : maMember.m_restr.trim();

                maCall("updateMemberInfo", resultData.member);
                maCall("updateMemberEncrypt", resultData.encrypt);

                DataBuildSettings(maMember);
                DataBuildSecurity();

                // revalidate to remove flags
                maTabs.validate();
                break;
            }
          }, 500);

          return [];
        }
      }
    });
  }

  var InitDataViews = function() {
    maSettings = maCardContainer.find("#settings").kendoWindow({
      title: "Member Settings",
      minWidth: "75%",
      maxWidth: "90%",
      width: 500,
      modal: true,
      visible: false,
      resizable: false,
      activate: EventOpenWindow,
      close: EventCloseWindow,
      open: function() {
        this.wrapper.css({ top: 100 });
      }
    }).data("kendoWindow");

    maCancel = $("#lnkCancel");
    maUpdate = $("#btnUpdate");

    maTabSettings = $("#tabSettings");
    maTabAccounts = $("#tabAccounts");
    maTabSecurity = $("#tabSecurity");
    maTabs = $("#tabs").hcuTabs({
      tabs: [
        { title: "Settings", text: "Settings", icon: "fa-check", selected: true, content: maTabSettings, validate: ValidateSettings },
        { title: "Accounts", text: "Sub-Accounts", icon: "fa-info-circle", content: maTabAccounts },
        { title: "Security", text: "Security", icon: "fa-lock", content: maTabSecurity, validate: ValidateSecurity }
      ],
      select: function(e) {
        maSettings.center();
        maSettings.wrapper.css({ top: 100 });
      },
      footer: $(".bottomButtons")
    });

    maObserveSettings = new kendo.observable({
      source: null,
      change: function() {
        maTabs.validate();
      }
    });

    maObserveAccounts = new kendo.observable({
      deposit: [],
      load: [],
      credit: [],
      showDeposit: false,
      showLoan: false,
      showCredit: false,
      showNoRecords: false,
    });

    maObserveSecurity = new kendo.observable({
      list: [],
      source: null,
      change: function() {
        maTabs.validate();
      }
    });

    kendo.bind(maTabSettings, maObserveSettings);
    kendo.bind(maTabAccounts, maObserveAccounts);
    kendo.bind(maTabSecurity, maObserveSecurity);

    // USE THIS TO SELECT OVERFLOW IN JQUERY SELECTORS FOR TOOLTIP BELOW
    jQuery.extend(jQuery.expr[':'], {
      overflown: function (el) {
        return el.offsetHeight < el.scrollHeight || el.offsetWidth < el.scrollWidth;
      }
    });

    maTooltipAccounts = homecuTooltip.defaults;
    maTooltipAccounts.filter = ".showEllipsis:overflown, .vsgDisabled";
    maTooltipAccounts.content = function(e) {
      return $(e.target).text().trim();
    }
    $("#depositGrid").kendoTooltip(maTooltipAccounts);
    $("#loanGrid").kendoTooltip(maTooltipAccounts);
    $("#creditGrid").kendoTooltip(maTooltipAccounts);

    maDiscard = $("#settingsCancel").kendoDialog({
      title: "Discard Changes",
      modal: true,
      visible: false,
      resizable: false,
      minWidth: 300,
      maxWidth: 500,
      show: EventOpenWindow,
      close: EventCloseWindow,
      actions: [
        { text: "No",
          action: function() { maAction = "discardDeny"; }
        },
        { text: "Yes", primary: true,
          action: function() { maAction = "discardConfirm"; }
        }
      ]
    }).data("kendoDialog");
  }

  var InitDataActions = function() {
    maUpdate.on("click", EventUpdateMember);
    maCancel.on("click", function() {
      maSettings.close();
    });
  }

  var InitWindowStack = function() {

  }

  this.Open = function(windowStack) {

    // setup validator
    $.homecuValidator.setup({
      formStatusField: "status",
      formValidate: "settings"
    });

    maCardWindows = windowStack;
    var memberRequest = {
      operation: "memberReadSettings",
      payload: maPayload
    };

    maDataSource.transport.options.read.type = "POST";
    maDataSource.read(memberRequest);
  }

  this.Close = function() {
    maSettings.destroy();
  }

  this.Data = function(payload, member) {
    maPayload = payload;
    maMember = member;
  }

  this.Init = function(hubCall, cardContainer) {
    maCall = hubCall;
    maCardContainer = cardContainer;

    InitDataSources();
    InitDataViews();
    InitDataActions();

    maCall("AccountSettings", this);
  }
}
</script>
<?php }