aMemberMicrs.prg

<?php
/**
 *  @package MemberHub
 *  @author MGHandy
 *
 *  @uses admin member micr: edit mirc valus for member accounts
 *
 *  @param operation    string: requested operation for this script
 *  @param payload      string: encryption for the selected member
 *  @param mMicrs       string: list of micr values to create/update/delete
 */

require_once("$admLibrary/aMemberSupport.i");

/**
 * function GetMicrSize()
 * This was 9 and is changed to 17.
 */
function GetMicrSize() {
  return 17;
}

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

  HCU_ImportVars($admVars, "MEMBER_MICR", $admOk);

  $mOperation = isset($admVars["MEMBER_MICR"]["operation"]) ? $admVars["MEMBER_MICR"]["operation"] : null;
  $mPayload = isset($admVars["MEMBER_MICR"]["payload"]) ? $admVars["MEMBER_MICR"]["payload"] : null;
  $mMicrs = isset($admVars["MEMBER_MICR"]["mMicrs"]) ? $admVars["MEMBER_MICR"]["mMicrs"] : null;

  $mMember = $mPayload ?
    MemberDecrypt($SYSENV, $Cu, $mPayload) :
    null;

  $mContext = $mPayload ?
    MemberContext($SYSENV, $Cu, $mMember['member']) :
    MemberContext($SYSENV, $Cu);

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

  switch ($mOperation) {
    case "":
      PrintMemberMicrs();
      break;
    case "memberReadMicrs":
      header('Content-type: application/json');

      $mRTNumbers = MemberReadRTNumbers($SYSENV, $dbh, $mContext);
      $mAccounts = MemberReadAccounts($SYSENV, $dbh, $mContext);
      $mMicrs = MemberReadMicrs($SYSENV, $dbh, $mContext);
      $aryResult['data']['numbers'] = $mRTNumbers['numbers'];
      $aryResult['data']['accounts'] = $mAccounts['accounts'];
      $aryResult['data']['micrs'] = $mMicrs['micrs'];
      MemberReply($aryResult, $aryReply, $mOperation);
      break;
    case "memberUpdateMicrs":
      header('Content-type: application/json');

      $mValidateMicrs = MemberValidateMicrs($SYSENV, $mContext, $mMicrs);
      $mDelete = MemberDeleteMicrs($SYSENV, $dbh, $mContext, $mValidateMicrs['delete']);
      $mCreate = MemberCreateMicrs($SYSENV, $dbh, $mContext, $mValidateMicrs['create']);
      $mUpdate = MemberUpdateMicrs($SYSENV, $dbh, $mContext, $mValidateMicrs['update']);
      $mMicrs = MemberReadMicrs($SYSENV, $dbh, $mContext);

      $aryResult['data']['micrs'] = $mMicrs['micrs'];
      $aryResult['info'][] = isset($mDelete['message']) ? $mDelete['message'] : "" ;
      $aryResult['info'][] = isset($mCreate['message']) ? $mCreate['message'] : "" ;
      $aryResult['info'][] = isset($mUpdate['message']) ? $mUpdate['message'] : "" ;
      MemberReply($aryResult, $aryReply, $mOperation);
      break;
    default:
      throw new Exception("Unknown server request: " . $mOperation);
      break;
  }

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

/**
 *  @package MemberValidateMicrs
 *  @uses validate incoming parameters for insertion into database
 *
 *  @param  pEnv      array: environment variable for debugging
 *  @param  pContext  array: array of common data needed accross the member hub
 *  @param  pMicrs    string: json string list of micrs to validate for database
 *
 *  @return sqlReturn array: array of micr account overrides
 */
function MemberValidateMicrs($pEnv, $pContext, $pMicrs) {
  $sList = html_entity_decode($pMicrs, ENT_QUOTES);
  $dList = HCU_JsonDecode($sList);

  $mValidate = array();

  foreach ($dList as $action => $set) {
    $mValidate[$action] = array();
    foreach ($set as $key => $value) {
      $mValidate[$action][] = array(
        "_action" => "$action",
        "micrid" => intval($value['mId']),
        "accounttype" => prep_save($value['mType'], 12),
        "micraccount" => prep_save($value['mMicr'], 17),
        "startcheck" => intval($value['mCheck']),
        "rt" => prep_save($value['mRt'], 12),
        "cu" => $pContext['cu_code']
      );
    }
  }

  return $mValidate;
}

/**
 *  @package MemberCreateMicrs
 *  @uses insert new micr override values into the database
 *
 *  @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  pMicrs    string: json string list of micrs to add to the database
 *
 *  @return sqlReturn array: array of inserted micr overrides
 */
function MemberCreateMicrs($pEnv, $pDbh, $pContext, $pMicrs) {
  if (count($pMicrs) == 0) { return array(); }

  $cuTable = $pContext['cu_table'];
  $cuCode = $pContext['cu_code'];
  $cuMember = $pContext['m_account'];

  $sqlReturn = array();
  $sqlCreate = "";
  $sqlColumns = "
    accountnumber,
    accounttype,
    micraccount,
    startcheck,
    rt,
    cu";

  foreach ($pMicrs as $key => $value) {
    $sqlValues = "
      '$cuMember',
      '{$value['accounttype']}',
      '{$value['micraccount']}',
      '{$value['startcheck']}',
      '{$value['rt']}',
      '$cuCode'";

    $sqlCreate .= "
      INSERT INTO cuovermicr
      ($sqlColumns) VALUES ($sqlValues);";
  }

  $sqlCreateRs = db_query($sqlCreate, $pDbh);
  if (!$sqlCreateRs) {
    $pEnv['logger']->error(db_last_error());
    throw new Exception("Failed to create MICR settings.");
  }

  $sqlReturn['message'] = "MICR settings have been created successfully.";
  return $sqlReturn;
}

/**
 *  @package MemberUpdateMicrs
 *  @uses update micr override values in the database
 *
 *  @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  pMicrs    string: json string list of micrs to update
 *
 *  @return sqlReturn array: array of updated micr overrides
 */
function MemberUpdateMicrs($pEnv, $pDbh, $pContext, $pMicrs) {
  if (count($pMicrs) == 0) { return array(); }

  $cuTable = $pContext['cu_table'];
  $cuCode = $pContext['cu_code'];
  $cuMember = $pContext['m_account'];

  $sqlReturn = array();
  $sqlUpdate = "";
  $sqlColumns = "
    accounttype,
    micraccount,
    startcheck,
    rt";

  foreach ($pMicrs as $key => $value) {
    $sqlValues = "
      '{$value['accounttype']}',
      '{$value['micraccount']}',
      '{$value['startcheck']}',
      '{$value['rt']}'";

    $sqlUpdate .= "
      UPDATE cuovermicr
      SET ($sqlColumns) = ($sqlValues)
      WHERE micrid = {$value['micrid']}
        AND accountnumber = '$cuMember'
        AND cu = '$cuCode';";

  }

  $sqlUpdateRs = db_query($sqlUpdate, $pDbh);
  if (!$sqlUpdateRs) {
    $pEnv['logger']->error(db_last_error());
    throw new Exception("Failed to update MICR settings.");
  }

  $sqlReturn['message'] = "MICR settings have been updated successfully.";
  return $sqlReturn;
}

/**
 *  @package MemberDeleteMicrs
 *  @uses delete micr override values in the database
 *
 *  @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  pMicrs    string: json string list of micrs to remove
 *
 *  @return sqlReturn array: array of removed micr overrides
 */
function MemberDeleteMicrs($pEnv, $pDbh, $pContext, $pMicrs) {
  if (count($pMicrs) == 0) { return array(); }

  $cuTable = $pContext['cu_table'];
  $cuCode = $pContext['cu_code'];
  $cuMember = $pContext['m_account'];

  $sqlReturn = array();
  $sqlDelete = "";

  foreach ($pMicrs as $key => $value) {
    $sqlDelete .= "
      DELETE FROM cuovermicr
      WHERE micrid = {$value['micrid']}
        AND accountnumber = '$cuMember';";
  }

  $sqlDeleteRs =  db_query($sqlDelete, $pDbh);
  if(!$sqlDeleteRs) {
    $pEnv['logger']->error(db_last_error());
    throw new Exception("Failed to delete MICR settings.");
  }

  $sqlReturn['message'] = "MICR settings have been deleted successfully.";
  return $sqlReturn;
}

/**
 *  @package MemberReadRTNumbers
 *  @uses get list of ann routing and transit numbers used by this credit union
 *
 *  @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 r/t number for the cu
 */
function MemberReadRTNumbers($pEnv, $pDbh, $pContext) {
  $cuTable = $pContext['cu_table'];
  $cuCode = $pContext['cu_code'];
  $cuMember = $pContext['m_account'];

  $sqlReturn = array();

  $sqlSelect = "
    SELECT rt, 'P' AS pri FROM cuadmin WHERE cu ='$cuCode'
    UNION ALL
    SELECT rt, 'X' AS pri FROM cualtroute WHERE cu ='$cuCode'
    ORDER BY 2,1";

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

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

/**
 *  @package MemberReadAccounts
 *  @uses get list of deposit accounts for this member
 *
 *  @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 deposit accounts
 */
function MemberReadAccounts($pEnv, $pDbh, $pContext) {
  $cuTable = $pContext['cu_table'];
  $cuCode = $pContext['cu_code'];
  $cuMember = $pContext['m_account'];

  $sqlReturn = array();
  $sqlColumns = "
    ab.accounttype AS a_type,
    ab.description AS a_desc,
    ab.micraccount AS a_micr";
  $sqlSelect = "
    SELECT $sqlColumns
    FROM {$cuTable}accountbalance ab
    WHERE ab.accountnumber = '$cuMember'
      AND ab.deposittype = 'Y'
    ORDER BY ab.accounttype";
  $sqlSelectRs = db_query($sqlSelect, $pDbh);
  if (!$sqlSelectRs) {
    $pEnv['logger']->error(db_last_error());
    throw new Exception("Failed to read member sub accounts.");
  }

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

/**
 *  @package MemberReadMicrs
 *  @uses get list of micr overrides for this 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 micr account overrides
 */
function MemberReadMicrs($pEnv, $pDbh, $pContext) {
  $cuTable = $pContext['cu_table'];
  $cuCode = $pContext['cu_code'];
  $cuMember = $pContext['m_account'];

  $sqlReturn = array();
  $sqlColumns = "
    om.micrid AS o_id,
    om.startcheck AS o_check,
    om.rt AS o_rt,
    om.micraccount AS o_micr,
    ab.accounttype AS a_type,
    ab.description AS a_desc,
    ab.micraccount AS a_micr";
  $sqlSelect = "
    SELECT $sqlColumns
    FROM cuovermicr om
    JOIN {$cuCode}accountbalance ab
      ON ab.accountnumber = om.accountnumber
      AND ab.accounttype = om.accounttype
    WHERE cu = '{$cuCode}'
      AND om.accountnumber = '$cuMember'
    ORDER BY om.accounttype, om.startcheck";
  $sqlSelectRs = db_query($sqlSelect, $pDbh);
  if (!$sqlSelectRs) {
    $pEnv['logger']->error(db_last_error());
    throw new Exception("Failed to read member mict values.");
  }

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

?>

<?php
/**
 *  @package PrintMemberMicrs
 *  @uses print neccessary html/javascript to run the selected card
 */
function PrintMemberMicrs() { ?>

<style type="text/css">
#mmMicrGrid .k-grid-content tr:hover {
  background: transparent;
  cursor: pointer;
}

</style>

<div id="mmMicrs">
  <div id="status"></div>

  <div class="h4">Core Info</div>

  <div class="hcu-secondary">
    <div class="small vsgSecondary">
      <span>This is the information from your core data provider.</span>
    </div>
  </div>

  <div id="mmCoreInfoGrid"></div>

  <div>&nbsp;</div>
  <div class="h4">MICR Overrides</div>

  <div class="hcu-secondary">
    <div class="small vsgSecondary">
      <span>Click inside a row field to edit the selected field.</span><br>
      <span>Delete a MICR override by clicking the checkbox to the left of each row.</span>
    </div>
  </div>

  <div id="mmMicrGrid"></div>

  <div class="hcu-template">
    <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="mmDiscard">
  <p>This member's MICR settings have been changed.</p>
  <p>Do you wish to discard the changes?</p>
</div>

<div id="mmEmpty">
  <p>There are one or more MICR settings with empty fields.</p>
  <p>Please review your changes and resubmit the form.</p>
</div>

<div id="mmDuplicates">
  <p>There are multiple MICR settings for a sub-account with one or more of the following errors:</p>
  <ul style="margin-left: 25px;">
    <li>the routing/transit numbers are the same</li>
    <li>the starting check numbers are the same</li>
  </ul>
  <p>Please review your changes and re-submit the form.</p>
</div>

<?php
/**
 *  @package MemberMICR
 *  @uses this object is used to display and interact with the member MICR 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
 *   MemberRelated 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 Validate*          private: validation functions for fors and other user
 *    input interactions.
 */
?>
<script type="text/javascript">
//# sourceURL=micrs.js

var MemberMicrs = function() {
  var mmCardContainer = null;
  var mmCardWindows = null;

  var mmPayload = null;
  var mmMember = null;
  var mmCall = null;
  var mmAction = null;

  var mmDataSource = null;
  var mmDataAccounts = null;
  var mmDataNumbers = null;
  var mmDataMicrs = null;
  var mmDataCoreInfo= null;

  var mmMicrGrid = null;
  var mmCoreInfoGrid= null;
  var mmMicrTip = null;

  var mmMicrs = null;
  var mmDiscard = null;
  var mmEmpty = null;
  var mmDuplicates = null;
  var mmUpdate = null;
  var mmCancel = null;

  var DataBuildCoreInfo= function(accounts, rts) {
    mmDataCoreInfo= [];

    var rt= rts.length >= 1 ? rts[0].rt.trim() : "";
    var kendoId= 0;
    for (var i=0; i!= accounts.length; i++) {
      var row= accounts[i];

      for (var j=0; j!= rts.length; j++) {
        var rrow= rts[j];
        if ((typeof(rrow['pri']) !== 'undefined') && (rrow['pri'] === 'P')) {
          mmDataCoreInfo.push({kendoId: ++kendoId, account: row.a_type.trim() + " - " +
            row.a_desc.trim(), coreMicr: row.a_micr != null ? row.a_micr.trim() : ""});
        }
      }

    }

    mmCoreInfoGrid.dataSource.data(mmDataCoreInfo);
  }

  var DataBuildMicrs = function(data) {
    mmDataMicrs = [];

    for (var i = 0; i < data.length; i++) {
      var micr = {};

      micr.oId = parseInt(data[i].o_id);
      micr.oAcct = data[i].a_type.trim() + " - " + data[i].a_desc.trim();
      micr.oRt = data[i].o_rt.trim();
      micr.oMicr = data[i].o_micr.trim();
      micr.oMicr = micr.oMicr == "0" ? "" : micr.oMicr;
      micr.oCheck = data[i].o_check.trim();
      micr.eAcct = data[i].a_type.trim() + " - " + data[i].a_desc.trim();
      micr.eRt = data[i].o_rt.trim();
      micr.eMicr = data[i].o_micr.trim();
      micr.eCheck = data[i].o_check.trim();
      micr.eDirty = false;
      micr.eDelete = false;
      micr.eNew = false;
      micr.eAdd = false;
      micr.eaMicr= data[i].a_micr != null ? data[i].a_micr.trim() : ""; <?php // Because of internal rules, it must start with e and o version is needed even though it never changes. ?>
      micr.oaMicr= micr.eaMicr;

      mmDataMicrs.push(micr);
    }

    mmDataMicrs.push({
      oId: -1,
      oAcct: " ",
      oRt: " ",
      oMicr: " ",
      oCheck: " ",
      eAcct: " ",
      eRt: " ",
      eMicr: " ",
      eCheck: " ",
      eaMicr: " ",
      oaMicr: " ",
      eDirty: false,
      eDelete: false,
      eNew: false,
      eAdd: true
    });

    mmMicrGrid.dataSource.data(mmDataMicrs);
    $("#mmMicrGrid").find("input[type=checkbox]").prop("checked", false);
  }

  var DataBuildNumbers = function(data) {
    mmDataNumbers = [{
      value: " ",
      text: "Select an r/t number"
    }];

    for (var i = 0; i < data.length; i++) {
      var number = {
        value: data[i].rt.trim(),
        text: data[i].rt.trim()
      };

      mmDataNumbers.push(number);
    }
  }

  var DataBuildAccounts = function(data) {
    mmDataAccounts = [{
      value: " ",
      text: "Select an account",
      micr: " "
    }];

    for (var i = 0; i < data.length; i++) {
      var account = {};
      account.value = data[i].a_type.trim() + " - " + data[i].a_desc.trim();
      account.text = data[i].a_type.trim() + " - " + data[i].a_desc.trim();

      var micr= data[i].a_micr.trim();
      micr= micr == "0" ? "" : micr;
      account.micr= micr;

      mmDataAccounts.push(account);
    }
  }

  var ValidateMicrsDuplicate = function() {
    var valid = true;
    var data = mmMicrGrid.dataSource.data();
    var checks = {};

    for (var i = 0; i < data.length-1; i++) {
      var item = data[i];
      if (data[i].eDelete) { continue; }
      if (data[i].eNew && !data[i].eDirty) { continue; }

      var acct= item.eAcct.trim();
      var checkRt= (item.eCheck+"").trim() + "-" + item.eRt.trim(); <?php // Needed because eCheck can now be a number with the trim doesn't work with. ?>

      if (checks[acct]) {
        if (checks[acct][checkRt]) {
          checks[acct][checkRt] ++;
        } else {
          checks[acct][checkRt] = 1;
        }
      } else {
        checks[acct] = {};
        checks[acct][checkRt] = 1;
      }
    }

    for (keyAcct in checks) {
      for (keyCheck in checks[keyAcct]) {
        if (checks[keyAcct][keyCheck] > 1) {
          valid = false;
        }
      }
    }

    return valid;
  }

  var ValidateMicrsEmpty = function() {
    var valid = true;
    var data = mmMicrGrid.dataSource.data();
    for (var i = 0; i < data.length-1; i++) {
      var item = data[i];
      if (!item.eDirty) { continue; }

      if (item.eAcct.trim() == "") { valid = false; }
      else if (item.eRt.trim() == "") { valid = false; }
      else if ((item.eMicr+"").trim() == "") { valid = false; }
      else if ((item.eCheck+"").trim() == "") { valid = false; }
      else { valid = true; }
    }

    return valid;
  }

  var ValidateMicrsDirty = function(mode) {
    var valid = false;
    var data = mmMicrGrid.dataSource.data();

    for (var i = 0; i < data.length-1; i++) {
      var item = data[i];
      if (item.eNew) { item.eDirty = true; }
      else if (item.eAcct != item.oAcct) { item.eDirty = true; }
      else if (item.eRt != item.oRt) { item.eDirty = true; }
      else if (item.eMicr != item.oMicr) { item.eDirty = true; }
      else if (item.eCheck != item.oCheck) { item.eDirty = true; }
      else if (item.eDelete) { item.eDirty = true; }
      else { item.eDirty = false; }

      if (!valid && item.eDirty) { valid = true; }
    }

    return valid;
  }

  var EditorDropDown = function(container, options) {
    if (container.hasClass("vsgDisabled") || options.model.eAdd) {
      mmMicrGrid.closeCell();
      return false;
    }

    if (container.attr("name") == "eAcct" && mmDataAccounts.length == 2 ||
      container.attr("name") == "eRt" && mmDataNumbers.length == 2) {

      mmMicrGrid.closeCell();
      return;
    }

    $('<input required name="' + options.field + '"/>')
      .appendTo(container)
      .kendoDropDownList({
        dataTextField: "text",
        dataValueField: "value",
        dataSource: options.field == "eAcct" ?
          mmDataAccounts :
          mmDataNumbers,
        change: function() {
          var valueKeyE = options.field;
          var valueKeyO = options.field.replace("e", "o");
          var valueO = options.model[valueKeyO];
          var valueE = options.model[valueKeyE];

          if (options.field == "eAcct") { <?php // Set the core MICR. ?>
            var dataItem= this.dataItem();
            options.model.eaMicr= dataItem.micr;
            options.model.oaMicr= dataItem.micr;
            $(this.wrapper).closest("tr").find("[name='eaMicr']").text(dataItem.micr);
          }

          if (valueO == valueE) {
            $(container).removeClass("k-dirty-cell");
            $(container).find(".k-dirty").remove();
          } else {
            $(container).addClass("k-dirty-cell");
            $(container).prepend("<span class='k-dirty'></span>");
          }

          EventPreservState();
        },
        select: function() {}
      }).closest(".k-dropdown.k-widget").on("keydown", function(e) {
        var key = e.which || e.keyCode;
        if (key == 9) {
          e.preventDefault();

          var gridCell = null;
          if (options.field == "eAcct") {
            if (mmDataNumbers.length == 2) {
              gridCell = $(this).closest("tr").find("td:eq(3)");
            } else {
              gridCell = $(this).closest("tr").find("td:eq(2)");
            }
          } else if (options.field == "eRt") {
            gridCell = $(this).closest("tr").find("td:eq(3)");
          }
          mmMicrGrid.editCell(gridCell);
        }
      });

      container.find("input").data("kendoDropDownList").open();
  }

  var EditorNumeric = function(container, options) {
    if (container.hasClass("vsgDisabled") || options.model.eAdd) {
      mmMicrGrid.closeCell();
      return false;
    }

    $('<input name="' + options.field + '" maxlength=\"<?php echo GetMicrSize(); ?>\"/>')
      .appendTo(container)
      .on("change", function(e) {
        var name = $(this).closest("td").attr("name");
        if (name == "eCheck") {
          var valueE = $(this).val();
          valueE = valueE.replace(/^0+/, '');
          if (valueE == "") {
            valueE = "0";
          }
          $(this).val(valueE);
        }
      })
      .on("keypress", function(e) {
        var key = e.which || e.keyCode;
        if (key == 46 || key == 8 || (key > 47 && key < 58) || (key > 36 && key < 41)) { <?php // Adding special characters and numbers. ?>

        } else {
          e.preventDefault();
        }
      })
      .on("keydown", function(e) {
        var key = e.which || e.keyCode;
        if (key == 9) {
          e.preventDefault();

          var gridCell = null;
          var gridRow = null;
          if (options.field == "eMicr") {
            gridCell = $(this).closest("tr").find("td:eq(4)");
          } else if (options.field == "eCheck") {
            gridRow = $(this).closest("tr").next("tr");

            if (mmDataAccounts.length == 2) {
              if (mmDataNumbers.length == 2) {
                gridCell = gridRow.find("td:eq(3)");
              } else {
                gridCell = gridRow.find("td:eq(2)");
              }
            } else {
              gridCell = gridRow.find("td:eq(1)");
            }
          }
          $(this).trigger("change");
          mmMicrGrid.editCell(gridCell);
        }
      })
      .on("blur", function() {
        var valueKeyE = options.field;
        var valueKeyO = options.field.replace("e", "o");
        var valueO = options.model[valueKeyO];
        var valueE = options.model[valueKeyE];

        if (valueO == valueE) {
          $(container).removeClass("k-dirty-cell");
          $(container).find(".k-dirty").remove();
        } else {
          $(container).addClass("k-dirty-cell");
          $(container).prepend("<span class='k-dirty'></span>");
        }

        EventPreservState();
      });
  }

  var EventUpdateMicrs = function() {
    var data = mmMicrGrid.dataSource.data();
    var dataU = {
      create: [],
      update: [],
      delete: []
    };

    for (var i = 0; i < data.length-1; i++) {
      var item = data[i];

      if (item.eDirty) {
        var itemU = {};
        itemU.mId = item.oId;
        itemU.mAcct =  item.eDelete ? item.oAcct : item.eAcct,
        itemU.mRt = item.eDelete ? item.oRt : item.eRt,
        itemU.mMicr = item.eDelete ? item.oMicr : item.eMicr,
        itemU.mCheck = item.eDelete ? item.oCheck : item.eCheck

        var account = itemU.mAcct.split("-");
        var mType = account[0].trim();
        itemU.mType = mType;

        if (item.eNew) {
          dataU.create.push(itemU);
        } else if (item.eDelete) {
          dataU.delete.push(itemU);
        } else {
          dataU.update.push(itemU);
        }
      }
    }

    var memberRequest = {
      operation: "memberUpdateMicrs",
      payload: mmPayload,
      mMicrs: JSON.stringify(dataU)
    };

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

  var EventPreservState = function() {
    var rowCheckAll = true;
    $("#mmMicrGrid").find("tr").each(function(i) {

      // skip the header row, the added row and the add row
      if (i > 0 && i < mmMicrGrid.dataSource.data().length) {
        var rowItem = mmMicrGrid.dataItem(this);
        var rowValueO = null;
        var rowValueE = null;

        $(this).find("td").each(function(j) {
          var field = $(this);
          var fieldKeyE = null;
          var fieldKeyO = null;

          if (j > 0) {
            fieldKeyE = field.attr("name");
            fieldKeyO = fieldKeyE.replace("e", "o");

            rowValueO = rowItem[fieldKeyO];
            rowValueE = rowItem[fieldKeyE];

            if (rowValueO != rowValueE) {
              $(this).addClass("k-dirty-cell");
              $(this).prepend("<span class='k-dirty'></span>");
            }
          }

          if (rowItem.eDelete) {
            $(this).addClass("vsgDisabled");
            $(this).addClass("mark-for-delete");
            $(this).find("input[type=checkbox]").prop("checked", true);
          }
        });

        if (!rowItem.eDelete) {
          rowCheckAll = false;
        }
      }
    });

    if (rowCheckAll) {
      $("#chk_ALL").prop("checked", true);
    }
  }

  var EventShowTip = function(e) {
    var target = $(e.target);
    var targetContent = "";

    if (target.hasClass("mark-for-delete")) {
      targetContent = "This micr setting has been marked for removal.";
    } else {
      targetContent = $(e.target).text().trim();
    }

    return targetContent;
  }

  var EventCheckBoxChange = function(e) {
    var box = $(this);
    var boxId = box.attr("id");
    var boxValue = box.prop("checked");

    if (!boxValue) {
      $("#mmMicrGrid input[id=chk_ALL]").prop("checked", false);
    }

    if (boxId == "chk_ALL") {
      $("#mmMicrGrid input[type=checkbox]").each(function(e) {
        if (e > 0) {
          $(this).prop("checked", boxValue);
          $(this).trigger("change");
        }
      });
    } else {
      var row = box.closest("tr");
      var rowIndex = mmDataMicrs[row[0].rowIndex];
      var rowItem = mmMicrGrid.dataItem(row);
      var rowFields = $(row).find("td");

      $(rowFields).each(function(e) {
        var field = $(this);
        var fieldClass = "";

        if (e > 0) {

          if (boxValue) {
            field.addClass("vsgDisabled");
            field.addClass("mark-for-delete");
            rowItem.eDelete = true;

            var ntb= field.find("[id^='ntb_']");
            ntb.length == 0 ? null : ntb.data("kendoNumericTextBox").enable(false);

            var mtb= field.find("[id^='mtb_']");
            mtb.length == 0 ? null : mtb.data("kendoMaskedTextBox").enable(false);
          } else {
            field.removeClass("vsgDisabled");
            field.removeClass("mark-for-delete");
            rowItem.eDelete = false;

            var ntb= field.find("[id^='ntb_']");
            ntb.length == 0 ? null : ntb.data("kendoNumericTextBox").enable(true);

            var mtb= field.find("[id^='mtb_']");
            mtb.length == 0 ? null : mtb.data("kendoMaskedTextBox").enable(true);
          }
        }
      });

      EventPreservState();
    }
  }

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

    switch (windowId) {

    }

    mmCardWindows.push(this);
  }

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

    switch (mmAction) {
      case "micrsUpdate":
        e.preventDefault();
        if (ValidateMicrsDirty()) {

          if (!ValidateMicrsEmpty()) { mmEmpty.open(); }
          else if (!ValidateMicrsDuplicate()) { mmDuplicates.open(); }
          else { EventUpdateMicrs(); }
        }
        break;
      case "discardConfirm":
        EventPopWindow(windowId);
        mmMicrGrid.dataSource.data(mmDataMicrs);
        mmAction = null;
        mmMicrs.close();
        break;
      default:
        if (windowId == "mmMicrs") {
          if (ValidateMicrsDirty()) {
            e.preventDefault();
            mmDiscard.open();
          } else {
            EventPopWindow(windowId);
            $.homecuValidator.setup({
              formStatusField: "formStatus",
              formValidate: "cardContainerDiv"
            });
          }
        } else {
          EventPopWindow(windowId);
        }
        break;
    }

    mmAction = null;
  }

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

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

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

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

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

            if (results.hasOwnProperty("error")) {
              $.homecuValidator.homecuResetMessage = true;
              $.homecuValidator.displayMessage(results.error, $.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;
          } else {
            return [];
          }

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

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

          setTimeout(function() {
            switch (resultOperation) {
              case "memberReadMicrs":
                if (!resultData.accounts) { <?php // Destroy and give no account message. ?>
                  kendo.destroy($("#mmMicrs *")); <?php // Destroy everything inside the window. ?>
                  $("#mmMicrs").html("<div class='vsgSecondary'>No checking accounts available.</div>"
                      + "<div class='hcu-template'><div class='hcu-edit-buttons k-state-default'><a href='#' id='btnClose' class='k-button k-primary'>"
                      + "<i class='fa fa-check fa-lg'></i>Close</a></div></div>");
                  $("#btnClose").click(function() { mmMicrs.close(); });
                } else {
                  DataBuildMicrs(resultData.micrs);
                  DataBuildNumbers(resultData.numbers);
                  DataBuildAccounts(resultData.accounts);
                  DataBuildCoreInfo(resultData.accounts, resultData.numbers);
                }

                mmMember.cardTitle= "Member MICR";
                var template= kendo.template($("#titleTemplate").html());
                mmMicrs.title(template(mmMember)).center().open();
                break;
              case "memberUpdateMicrs":
                DataBuildMicrs(resultData.micrs);
                break;
            }
          }, 500);

          return [];
        }
      }
    });
  }

  var InitDataViews = function() {
    mmMicrs = $("#mmMicrs").kendoWindow({
      title: "Member MICR",
      minWidth: "75%",
      maxWidth: "90%",
      modal: true,
      visible: false,
      resizable: false,
      activate: EventOpenWindow,
      close: EventCloseWindow,
      open: function() {
        this.wrapper.css({ top: 100 });
      }
    }).data("kendoWindow");

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

    mmEmpty = $("#mmEmpty").kendoDialog({
      title: "Empty Fields",
      modal: true,
      visible: false,
      resizable: false,
      minWidth: 300,
      maxWidth: 500,
      show: EventOpenWindow,
      close: EventCloseWindow,
      actions: [
        { text: "Ok", primary: true }
      ]
    }).data("kendoDialog");

    mmDuplicates = $("#mmDuplicates").kendoDialog({
      title: "Duplicate Values",
      modal: true,
      visible: false,
      resizable: false,
      minWidth: 300,
      maxWidth: 500,
      show: EventOpenWindow,
      close: EventCloseWindow,
      actions: [
        { text: "Ok", primary: true }
      ]
    }).data("kendoDialog");

    mmUpdate = $("#btnUpdate");
    mmCancel = $("#lnkCancel");
    mmStatus = $("#mmStatus");
    mmStatus.hide();

    mmCoreInfoGrid= $("#mmCoreInfoGrid").kendoGrid({
      dataSource: {
        data: [],
        schema: {
          model: {
            id: "kendoId",
            fields: {
              kendoId: {type: "number"},
              account: {type: "string"},
              coreMicr: {type: "string"}
            }
          }
        }
      },
      columns: [
        {field: "account", title: "Account", width: "400px", attributes: {"class":"showEllipsis" }},
        {field: "coreMicr", title: "Core MICR"}
      ]
    }).data("kendoGrid");

    mmMicrGrid = $("#mmMicrGrid").kendoGrid({
      dataSource: {
        data: []
      },
      dataBound: function() {
        $("#mmMicrGrid input[type=checkbox]").off();
        $("#mmMicrGrid input[type=checkbox]").change(EventCheckBoxChange);

        $("td[name='eCheck'] input").each(function() { <?php // Numeric validation. ?>
          var name= $(this).closest("td").attr("name");
          $(this).kendoNumericTextBox({
            spinners: false, <?php // This keeps the numericTextBox looking like a normal input field without any visible effects. ?>
            decimals: 0,
            restrictDecimals: true,
            format: "#", <?php // Number without commas or decimals. ?>
            placeholder: "Enter a check number",
            min: 0,
            max: 2147483647,
            change: function() { <?php // Now that the input is divorced from the kendo mechanism for going into edit mode, I need to manually update the dataItem. ?>
              var tr= $(this.wrapper).closest("tr");
              var dataItem= mmMicrGrid.dataItem(tr);
              dataItem.dirty= true;
              dataItem.eDirty= true;
              dataItem[name]= this.value();
            }
          });
        });

        $("td[name='eMicr'] input").each(function() { <?php // Numeric validation. ?>
          var name= $(this).closest("td").attr("name");
          $(this).kendoMaskedTextBox({
            promptChar: " ",
            mask: "<?php echo str_repeat('0', GetMicrSize()); ?>",
            placeholder: "Enter a micr value",
             change: function() { <?php // Now that the input is divorced from the kendo mechanism for going into edit mode, I need to manually update the dataItem. ?>
              var tr= $(this.wrapper).closest("tr");
              var dataItem= mmMicrGrid.dataItem(tr);
              dataItem.dirty= true;
              dataItem.eDirty= true;
              dataItem[name]= this.value();
            }
          });
        });
      },
      change: function() {
        var cell = this.select();
        var cellIndex = cell.index();
        var row = cell.closest("tr");
        var rowIndex = row[0].rowIndex;
        var rowItem = mmMicrGrid.dataItem(row);

        if (rowItem.eAdd) {
          var rowNew = {
            oId: -1,
            oAcct: " ", oRt: " ", oMicr: " ", oCheck: "0", oaMicr: " ",
            eAcct: " ", eRt: " ", eMicr: " ", eCheck: "0", eaMicr: " ",
            eDirty: false, eDelete: false,
            eNew: true, eAdd: false
          }

          if (mmDataAccounts.length == 2) {
            rowNew.oAcct = mmDataAccounts[1].value;
            rowNew.eAcct = mmDataAccounts[1].value;
          }

          if (mmDataNumbers.length == 2) {
            rowNew.oRt = mmDataNumbers[1].value;
            rowNew.eRt = mmDataNumbers[1].value;
          }

          mmMicrGrid.dataSource.insert(rowIndex, rowNew);
          EventPreservState();
        } else {
          if (cellIndex == 0) {

            if (rowItem.eNew) {
              mmMicrGrid.dataSource.remove(rowItem);
              EventPreservState();
            } else {
              var box = cell.find("input[type=checkbox]")[0];
              $(box).trigger("click");
            }

          }
        }

        $(cell).removeClass("k-state-selected");
      },
      editable: true,
      selectable: "cell",
      columns: [
        { width: "30px",
          template: "#if(eAdd){#<span class=\"fa fa-plus\"></span>#}else if(eNew){#<span class=\"fa fa-minus\"></span>#}else{#<input type=\"checkbox\" style=\"margin-top: -2px;\" />#}#",
          headerTemplate: "<input type=\"checkbox\" style=\"margin-top: -2px;\" id=\"chk_ALL\" />" },
        { field: "eAcct", title: "Account", editor: EditorDropDown, width: "400px",
          attributes: { "name":"eAcct", "class":"showEllipsis" },
          template: "#if(eAdd){#<span>Add Row</span>#}else if(eAcct.trim() == \"\"){#<span>Select an account</span>#}else{##=eAcct##}#" },
        { field: "eRt", title: "R/T", editor: EditorDropDown, attributes: { "name":"eRt" },
          template: "#if(eAdd){#<span></span>#}else if(eRt.trim() == \"\"){#<span>Select an r/t number</span>#}else{##=eRt##}#"},
        { field: "eaMicr", title: "Core MICR", editable: function() { return false; }, template: "#if (eAdd) { #<span></span># } else { # #=eaMicr# # } #", attributes: { "name" : "eaMicr"}},
        { field: "eMicr", title: "MICR #", editable: function() { return false; },
          attributes: { "name":"eMicr" },
          template: "#if(eAdd){#<span></span>#}else {#<span><input id='mtb_#=oId#_1' class='hcu-all-100' value='#=eMicr#'></span>#}#"},
          <?php // Just need to reference the input. Rule from kendo: all attributes are copied from the element into the wrapper for the control EXCEPT for the id.
          // If I need to reference it generically, I can set the id to something unique and use the JQuery starts with selector. ?>
        { field: "eCheck", title: "Starting Check #", editable: function() { return false; },
          attributes: { "name":"eCheck" },
          template: "#if(eAdd){#<span></span>#}else {#<span><input id='ntb_#=oId#_2' class='hcu-all-100' value='#=eCheck#'></span>#}#"}
      ]
    }).data("kendoGrid");



    // 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;
      }
    });

    mmMicrTip = homecuTooltip.defaults;
    mmMicrTip.filter = ".showEllipsis:overflown, .vsgDisabled";
    mmMicrTip.content = EventShowTip
    $("#mmMicrGrid").kendoTooltip(mmMicrTip);
  }

  var InitDataActions = function() {
    mmUpdate.off();
    mmUpdate.on("click", function() { mmAction = "micrsUpdate"; mmMicrs.close(); });
    mmCancel.off();
    mmCancel.on("click", function() { mmMicrs.close(); });
  }

  this.Open = function(windowStack) {
    // setup validator
    $.homecuValidator.setup({
      formStatusField: "status",
      formValidate: "mmMicrs"
    });

    mmCardWindows = windowStack;
    var memberRequest = {
      operation: "memberReadMicrs",
      payload: mmPayload
    };

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

  this.Close = function() {
    mmMicrs.destroy();
    mmDiscard.destroy();
    mmEmpty.destroy();
    mmDuplicates.destroy();
  }

  this.Data = function(payload, member) {
    mmPayload = payload;
    mmMember = member;
  }

  this.Init = function(hubCall, cardContainer) {
    mmCall = hubCall;
    mmCardContainer = cardContainer;

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

    mmCall("MemberMicr", this);
  }
}
</script>
<?php }