aMemberImages.prg

<?php
/**
 *  @package MemberHub
 *  @author MGHandy
 *
 *  @uses this script facilitates in viewing check images associated
 *  with this member account.
 *
 *  @uses view and select users in the user hub
 *  @uses view and selected user accounts in the member hub
 *
 *  @param operation    string: requested operation for this script
 *  @param payload      string: encryption for the selected member
 *
 *  @return json
 */
require_once("$admLibrary/aMemberSupport.i");
require_once(dirname(__FILE__) . "/../../shared/library/hcuTranslate.i");
require_once(dirname(__FILE__) . "/../../shared/library/hcuCommon.i");

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

  $iOperation = isset($admVars["MEMBER_IMAGES"]["operation"]) ? $admVars["MEMBER_IMAGES"]["operation"] : null;
  $iPayload = isset($admVars["MEMBER_IMAGES"]["payload"]) ? $admVars["MEMBER_IMAGES"]["payload"] : null;
  $iData = isset($admVars["MEMBER_IMAGES"]["data"]) ? $admVars["MEMBER_IMAGES"]["data"] : null;

  $iMember = $iPayload ?
    MemberDecrypt($SYSENV, $Cu, $iPayload) :
    null;

  $iContext = $iPayload ?
    MemberContext($SYSENV, $Cu, $iMember['member']) :
    MemberContext($SYSENV, $Cu);

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

  switch ($iOperation) {
    case "":
      PrintMemberImages();
      break;
    case "memberReadData":
      header('Content-type: application/json');

      $iAccounts = MemberReadAccounts($SYSENV, $dbh, $iContext);
      $iRTNumbers = MemberReadRTNumbers($SYSENV, $dbh, $iContext);
      $iMicrs = MemberReadMicrs($SYSENV, $dbh, $iContext);

      $aryResult['data']['accounts'] = $iAccounts['accounts'];
      $aryResult['data']['rtnumbers'] = $iRTNumbers['rtnumbers'];
      $aryResult['data']['micrs'] = $iMicrs['micrs'];
      MemberReply($aryResult, $aryReply, $iOperation);
      break;
    case "memberReadImage":
      $iCheck = MemberValidateCheck($SYSENV, $iContext, $iData);
      $iVendor = MemberReadVendor($SYSENV, $dbh, $iContext);
      $iImage = $iMember['member']['m_image'];

      // if vendor has changed while visiting this card
      // use changed vendor instead.
      if ($iImage != $iVendor['vendor']['image']) {
        $iImage = $iVendor['vendor']['image'];
      }

      // if credit union not set up, don't get image.
      if ($iImage == "NO") {
        throw new Exception("Currently your credit union is not set up to view check images online.");
      }

      # pass micr as $sk (sortkey) 
      # for MidAt clients using tracenumber, not micr, for image retrieval
      /*
       * changed 12/19/12 if FEDIMAGE, send check_number; if MAC send check_micr; else send ''
       * so old legacy hacks for FEDIMAGE and MAC still work without breaking new alternate MICR for
       * WASATCH / ISUCU
       * 
       * Apparently lost these changes on the switch from ImageSRC to ImageSOLO (Mammoth upgrade)
       * but really do need them...
       */
      $sk='';
      if ($iImage == 'FEDIMAGE') {
          $sk = $iCheck['check'];
      } elseif ($iImage == 'MAC') {
          $sk = $iCheck['micr'];
      } else {
          $sk = '';
      }

      $CKINFOPARTS = "{$iContext['cu_code']}|{$iImage}|{$iCheck['check']}|{$iCheck['amount']}|{$iCheck['date']}|{$iCheck['rt']}|{$iCheck['micr']}|{$iContext['m_account']}|$sk";
      $CKITEM = hcu_encrypturl($CKINFOPARTS, $chk_key);
      $CKDMSKEY = sha1("{$iContext['cu_code']}{$iImage}{$iCheck['check']}{$iCheck['amount']}{$iCheck['date']}{$iCheck['rt']}{$iCheck['micr']}1{$iContext['m_account']}cierto");
      $CKURL = "{$http_scheme}://{$_SERVER['HTTP_HOST']}/banking/ImageSOLO.prg?cu=$Cu&CKITEM=$CKITEM&CKHASH=$CKDMSKEY&CKARCHIVE=1&adm=1";

      $aryResult['data']['url'] = $CKURL;
      MemberReply($aryResult, $aryReply, $iOperation);
      break;
    default:
      throw new Exception("Unknown server request: " . $iOperation);
      break;
  }

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

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

function MemberReadVendor($pEnv, $pDbh, $pContext) {
  $cuTable = $pContext['cu_table'];
  $cuCode = $pContext['cu_code'];

  $sqlReturn = array();
  $sqlSelect = "
    SELECT TRIM(img) AS image, flagset
    FROM cuadmin
    WHERE cu = '$cuCode'";
  $sqlSelectRs = db_query($sqlSelect, $pDbh);
  if (!$sqlSelectRs) {
    $pEnv['logger']->error(db_last_error());
    throw new Exception("Failed to read check image vendor.");
  }

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

function MemberValidateCheck($pEnv, $pContext, $pCheck) {

  $hCheck = html_entity_decode($pCheck, ENT_QUOTES);
  $jCheck = HCU_JsonDecode($hCheck);
  $jTime = strtotime($jCheck['date']);

  $mValidate = array(
    "micr" => prep_save($jCheck['micr'], 17),
    "check" => intval($jCheck['check']),
    "amount" => number_format(floatval($jCheck['amount']), 2, '.', ''),
    "date" => date("m/d/Y", $jTime),
    "rt" => prep_save($jCheck['rt'], 12)
  );

  return $mValidate;
}

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

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['rtnumbers'] = db_fetch_all($sqlSelectRs);
  return $sqlReturn;
}

function MemberReadMicrs($pEnv, $pDbh, $pContext) {
  $cuTable = $pContext['cu_table'];
  $cuCode = $pContext['cu_code'];
  $cuMember = $pContext['m_account'];

  $sqlReturn = array();
  $sqlColumns = "
    om.startcheck AS o_check,
    om.rt AS o_rt,
    om.micraccount AS o_micr,
    om.accounttype AS o_type";
  $sqlSelect = "
    SELECT $sqlColumns
    FROM cuovermicr om
    WHERE cu = '{$cuCode}'
      AND om.accountnumber = '$cuMember'";
  $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 PrintMemberImages
 *  @uses print neccessary html/javascript to run the selected card
 */
function PrintMemberImages() { ?>

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

  <div class="row hcuSpacer">
    <div class="col-sm-5">
      <label for="inpAcct">Sub-Account</label>
    </div>
    <div class="col-sm-7">
      <input type="text" id="inpAcct" class="hcu-all-100"
        data-role="dropdownlist"
        data-text-field="aView"
        data-value-field="aType"
        data-bind="
          source: sourceAccounts,
          value: source.aType,
          events: { change: changeDropDown }">
    </div>
  </div>

  <div class=""
    data-bind="visible: sourceVisible">
    <div class="hcuSpacer">
      <label for="miGrid">MICR Override List</label>
      <div id="miGrid"
        data-role="grid"
        data-no-records="
          { template: 'No MICR overrides were found for this account' }
        "
        data-bind="
          source: sourceMicrs"
        data-columns="[
          { field: 'oCheck', title: 'Starting Check Number' },
          { field: 'oRt', title: 'Routing &amp; Transit Number' },
          { field: 'oMicr', title: 'MICR Account Number' }
        ]"></div>
        &nbsp;
    </div>

    <div class="row hcuSpacer">
      <div class="col-sm-5">
        <label for="inpMicr">MICR Account Number</label>
      </div>
      <div class="col-sm-7">
        <input type="text" class="hcu-all-100" 
          id="inpMicr" name="inpMicr" 
          maxlength="17"
          data-role="numerictextbox"
          data-spinners="false"
          data-format="#"
          data-min="0"
          data-bind="
            value: source.aMicr,
            events: { change: changeInput }"
          data-required-msg="MICR account number is required"
          required>
      </div>
    </div>

    <div class="row hcuSpacer">
      <div class="col-sm-5">
        <label for="inpCheckNumber">Check Number</label>
      </div>
      <div class="col-sm-7">
        <input type="text" class="hcu-all-100" 
          id="inpCheckNumber" name="inpCheckNumber" 
          maxlength="9"
          data-role="numerictextbox"
          data-spinners="false"
          data-format="#"
          data-decimals="0"
          data-min="0"
          data-bind="
            events: { change: changeInput }"
          data-required-msg="Check number is required"
          required>
      </div>
    </div>

    <div class="row hcuSpacer">
      <div class="col-sm-5">
        <label for="inpCheckAmount">Check Amount</label>
      </div>
      <div class="col-sm-7">
        <input type="text" class="hcu-all-100" 
          id="inpCheckAmount" name="inpCheckAmount" 
          maxlength="14"
          data-role="numerictextbox"
          data-spinners="false"
          data-format="c2"
          data-decimals="2"
          data-min="0"
          data-bind="
            events: { change: changeInput }"
          data-required-msg="Check amount is required"
          required>
      </div>
    </div>

    <div class="row hcuSpacer">
      <div class="col-sm-5">
        <label for="inpCheckDate">Check Date</label>
      </div>
      <div class="col-sm-7">
        <input type="text" class="hcu-all-100" 
          id="inpCheckDate" name="inpCheckDate"
          homecu-match="date"
          data-role="datepicker"
          data-bind="
            events: { change: changeInput }"
          data-required-msg="Check date is required"
          data-homecuCustomMatch-msg="Check Date is not the correct format"
          required>
      </div>
    </div>

    <div class="row hcuSpacer">
      <div class="col-sm-5">
        <label for="inpCheckRTNumber">Routing &amp; Transit Number</label>
      </div>
      <div class="col-sm-7">
        <input type="text" class="hcu-all-100"
          id="inpCheckRTNumber" name="inpCheckRTNumber"
          data-role="dropdownlist"
          data-text-field="rtNumber"
          data-value-field="rtNumber"
          data-bind="
            source: sourceRTNumbers"
          data-required-msg="Routing number is required"
          required>
      </div>
    </div>
  </div>

  <div class="hcu-template">
    <div class="hcu-edit-buttons k-state-default">
      <span class="hcu-icon-delete">
        <!--<a href="##" id="lnkDelete">
          <i class="fa fa-trash fa-lg"></i>
        </a>-->
      </span>
      <a href="##" id="lnkCancel">Cancel</a>
      &ensp;
      <a href="##" id="btnUpdate" class="k-button k-primary">
        <i class="fa fa-search fa-lg"></i>
        View Image
      </a>
    </div>
  </div>
</div>

<div id="miImageView"></div>
<?php
/**
 *  @package MemberImages
 *  @uses this object is used to display and interact with the member check images
 *  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 Info*              private: success/error message display.
 *
 *  @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=memberRelated.js
var MemberImages = function() {
  var miCardContainer = null;
  var miCardWindows = null;

  var miPayload = null;
  var miMember = null;
  var miCall = null;
  var miAction = null;

  var miImages = null;
  var miImagesCancel = null;
  var miImagesSearch = null;
  var miObserve = null;

  var miDataSource = null;
  var miDataMicrs = null;
  var miDataAccounts = null;
  var miDataRTNumbers = null;

  var miImageView = null;

  var ShowCheckImage = function(url) {
    // Empty
    $("#miImageView").empty();
    $("#miImageView").kendoWindow({
      modal: true,
      visible: false,
      resizable: false,
      title: "Check Image",
      width: 700,
      height: 600,
      open: EventOpenWindow,
      close: EventCloseWindow,
      content: url,
      actions: ['Print', 'Close']
    });

    $("#miImageView").data("kendoWindow").wrapper
      .find(".k-i-print").parent().off();

    $("#miImageView").data("kendoWindow").wrapper
      .find(".k-i-print").parent().click(function(e) {
        e.preventDefault();
        window.open(url);
        miAction = "checkPrint";
      });


    $("#miImageView").data("kendoWindow").center().open();
  }

  var DataBuildMicrs = function(data) {
    miDataMicrs = [];
    for (var i = 0; i < data.length; i++) {
      var micr = {};

      micr.oType = data[i].o_type.trim();
      micr.oRt = data[i].o_rt.trim();
      micr.oMicr = data[i].o_micr.trim();
      micr.oCheck = data[i].o_check.trim();

      miDataMicrs.push(micr);
    }

    miObserve.set("sourceMicrs", miDataMicrs);
  }

  var DataBuildAccounts = function(data) {
    miDataAccounts = [];
    for (var i = 0; i < data.length; i++) {
      var acct = {};

      acct.aDesc = data[i].a_desc.trim();
      acct.aMicr = data[i].a_micr.trim();
      acct.aType = data[i].a_type.trim();
      acct.aView = acct.aType + " - " + acct.aDesc;

      miDataAccounts.push(acct);
    }

    miObserve.set("sourceAccounts", miDataAccounts);
    miObserve.setUp(miDataAccounts[0]);
  }

  var DataBuildRTNumbers = function(data) {
    miDataRTNumbers = [];
    for (var i = 0; i < data.length; i++) {
      var rtnum = {};

      rtnum.rtNumber = data[i].rt.trim();

      miDataRTNumbers.push(rtnum);
    }

    miObserve.set("sourceRTNumbers", miDataRTNumbers);
  }

  var EventSwapImages = function(e) {
    e.preventDefault();

    $("#miImageView").load($(this).attr("href"), function(e) {
      $("#miImageView").find("a#ckViewBtn").off();
      $("#miImageView").find("a#ckViewBtn").on("click", EventSwapImages);
    });
  }

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

    switch (windowId) {
      case "miImageView":

        break;
    }

    miCardWindows.push(this);
  }

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

    switch (miAction) {
      case "searchSubmit":
        e.preventDefault();
        if ($.homecuValidator.validate()) {
          var memberData = {
            micr: $("#inpMicr").data("kendoNumericTextBox").value(),
            check: $("#inpCheckNumber").data("kendoNumericTextBox").value(),
            amount: $("#inpCheckAmount").data("kendoNumericTextBox").value(),
            date: $("#inpCheckDate").data("kendoDatePicker").value(),
            rt: $("#inpCheckRTNumber").data("kendoDropDownList").value()
          };

          var request = {
            operation: "memberReadImage",
            payload: miPayload,
            data: JSON.stringify(memberData)
          };

          miDataSource.transport.read.type = "POST";
          miDataSource.read(request);
        }
        break;
      case "checkPrint":
        e.preventDefault();
        break;
      default:
        EventPopWindow(windowId);

        // set validator back to hub script
        $.homecuValidator.setup({
          formStatusField: "formStatus",
          formValidate: "cardContainerDiv"
        });
        break;
    }

    miAction = null;
  }

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

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

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

  var InitDataSources = function() {
    miDataSource = new kendo.data.DataSource({
      transport: {
        read: {
          url: "main.prg",
          dataType: "json",
          contentType: "application/x-www-form-urlencoded",
          type: "GET",
          cache: false,
          data: {
            ft: "103109"
          }
        }
      },
      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 "memberReadData":
                DataBuildMicrs(resultData.micrs);
                DataBuildRTNumbers(resultData.rtnumbers);
                DataBuildAccounts(resultData.accounts);

                miMember.cardTitle= "View Check Images";
                var template= kendo.template($("#titleTemplate").html());
                miImages.title(template(miMember)).center().open();
                break;
              case "memberReadImage":
                ShowCheckImage(resultData.url);
                break;
            }
          }, 500);

          return [];
        }
      }
    });
  }

  var InitDataViews = function() {
    miImages = $("#miImages").kendoWindow({
      title: "View Check Image",
      modal: true,
      minWidth: 500,
      maxWidth: 750,
      visible: false,
      resizable: false,
      activate: EventOpenWindow,
      close: EventCloseWindow,
      open: function(e) { this.wrapper.css({ top: 100 }); }
    }).data("kendoWindow");

    miImagesCancel = $("#lnkCancel");
    miImagesSearch = $("#btnUpdate");

    miObserve = new kendo.observable({
      sourceAccounts: [],
      sourceRTNumbers: [],
      sourceMicrs: [],
      source: null,
      sourceVisible: false,
      setUp: function(account) {
        if (account) {
          this.set("source", account);
          this.set("sourceVisible", true);

          var filter = { field: "oType", operator: "eq", value: account.aType };
          $("#miGrid").data("kendoGrid").dataSource.filter(filter);
        }
      },
      changeDropDown: function(e) {
        var index = e.sender.selectedIndex;
        var account = miDataAccounts[index];
        this.setUp(account);
      },
      changeInput: function(e) {
        if (!e.sender.value()) {
          e.sender.wrapper.css("border", "1px solid #d80000");
        } else {
          e.sender.wrapper.css("border", "none");
        }
      }
    });

    kendo.bind("#miImages", miObserve);
    miStatus = $("#miStatus");
    miStatus.hide();
  }

  var InitDataActions = function() {
    miImagesSearch.off();
    miImagesSearch.on("click", function(e) {
      miAction = "searchSubmit";
      miImages.close();
    });

    miImagesCancel.off();
    miImagesCancel.on("click", function(e) {
      miImages.close();
    });

    $("#inpCheckAmount").on("change", function(e) {
      var input = $(this);
      var value = input.val();
      var valueSplit = value.split(".");
      value = valueSplit[0].substring(0, 11);

      if (valueSplit[1]) {
        value += ".";
        value += valueSplit[1].substring(0, 2);
      }

      var kendoInput = $("#inpCheckAmount").data("kendoNumericTextBox");
      kendoInput.value(value);
    });
  }

  this.Data = function(message, member) {
    miPayload = message;
    miMember = member;
  }

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

    miCardWindows = windowStack;
    var memberRequest = {
      operation: "memberReadData",
      payload: miPayload
    };

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

  this.Close = function() {
    $("#inpAcct").data("kendoDropDownList").destroy();
    $("#inpCheckRTNumber").data("kendoDropDownList").destroy();
    $("#inpCheckDate").data("kendoDatePicker").destroy();

    if ($("#miImageView").data("kendoWindow")) {
      $("#miImageView").data("kendoWindow").destroy();
    }

    miImages.destroy();
  }

  this.Init = function(hubCall, cardContainer) {
    miCall = hubCall;
    miCardContainer = cardContainer;

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

    miCall("MemberImages", this);
  }
}
</script>
<?php }