hcuArchiveCheck.prg

<?php
  /*
   * File: hcuArchiveCheck
   *
   * Purpose:  Let the user view older checkes obtained from the check image vendor (because core system
   *            doesn't keep enough history)
   *
   */

  // ** SET SCRIPT LEVEL VARIABLES
  $serviceShowInfo = true;
  $serviceLoadMenu = true;
  $serviceShowMenu = true;

  // ** INCLUDE MAIN GLOBAL SCRIPT -- Handles security / global variable values
  require_once(dirname(__FILE__) . '/../library/hcuService.i');

    /*
     * ** CHECK USER FEATURE PERMISSIONS **
     * NOTE: DOES NOT RETURN ON FAILURE
     */
    PermCheckFeatureScreen($dbh, $HB_ENV, $MC, FEATURE_BASIC);


  // ** INSERT BUSINESS LOGIC FOR THIS FORM


  // ** SET VARIABLES FOR WEBSITE FLAGS

  // ** INCLUDE PRE CONTENT SCRIPT
  require_once(dirname(__FILE__) . '/../includes/hcuPreContent.i');

try {
  $Cu = $HB_ENV["Cu"];
  $Cn = $HB_ENV["Cn"];

  /*
   * ** START CONTENT
   */
    // Always perform the check to see if check images are available for this credit union

    $sql = "SELECT img, rt, flagset
                    FROM cuadmin
                    WHERE cu = '$Cu' ";

    $img_rs = db_query($sql, $dbh);

    list($img_vendor, $cu_rt, $flagset) = db_fetch_row($img_rs, 0);
    $img_vendor = trim($img_vendor);
    $cu_rt = trim($cu_rt);
    db_free_result($img_rs);

    if ( (trim($img_vendor) == '' || strtoupper(trim($img_vendor)) == 'NO') || (($flagset & GetFlagsetValue("CU_SHOWIMAGES")) == 0)) {
    // * Feature NOT set
    // * Include the Error page and exit
    $serviceErrorMsg = $MC->msg('Feature Not Set', HCU_DISPLAY_AS_HTML) . ".<BR>" . $MC->msg('Contact CU', HCU_DISPLAY_AS_HTML);
    $serviceErrorCode = '915';

    require_once(dirname(__FILE__) . '/../includes/hcuErrorPage.i');
    // ** DO NOT CONTINUE
    exit;
    }

  # find out how many valid checking accounts the user can access:
    $sql = "SELECT description, trim(display_name), trim(ab.accounttype), trim(micraccount), trim(ab.accountnumber)
          FROM {$Cu}useraccounts ua
          INNER JOIN {$Cu}accountbalance ab ON ab.accountnumber = ua.accountnumber
            AND ab.accounttype = ua.accounttype
            and ab.certnumber = ua.certnumber
            AND upper(deposittype) = 'Y'
            AND trim(micraccount) > ''
          WHERE ua.user_id = {$HB_ENV["Uid"]}
            AND ua.recordtype = 'D'";

    $acctRS = db_query($sql, $dbh);

    if (db_num_rows($acctRS) == 0) {
    // * Include the Error page and exit
    $serviceErrorMsg = $MC->msg('No Valid Accounts', HCU_DISPLAY_AS_HTML) . "<BR>" . $MC->msg('Contact CU', HCU_DISPLAY_AS_HTML);
    $serviceErrorCode = '915';

    require_once(dirname(__FILE__) . '/../includes/hcuErrorPage.i');
    // ** DO NOT CONTINUE
    exit;
  }


  $row = 0;
  $accountList = array();
  while ( list($desc, $display, $atype, $micr, $acct) = db_fetch_row($acctRS, $row++) ) {
    $displayName = getAccountDescription($dbh, $HB_ENV["Cu"], $acct, $desc, $atype, $display, $HB_ENV["Fset3"]);
    $accountList[] = array( "text" => $displayName, "value" => "$micr|$acct|$atype" );
  }

  db_free_result($acctRS);

  ?>
  <script type="text/javascript">
  var windowStack = [];
  var accountList = <?php echo HCU_JsonEncode( $accountList ) ?>;
  $(document).ready(function() {
      var dsGetArchive = new kendo.data.DataSource({
        autoSync: false,
        batch: false,
        pageSize: 10,
        error: function(e) {
          // displays "error"
        },
        transport: {
          read: {
            url: "hcuArchiveCheck.data?cu=<?php echo $HB_ENV["cu"] ?>",
            dataType: "json",
            contentType: "application/json",
            type: "GET",
            data: {
              action: "thisshouldgetoverwritten"
            },
            cache: false
          }
        },
        schema: {
          parse: function(response) {
            // not showing data, so return empty array
            var display = [];
            return display;
          }
        },
        requestStart: function(e) {
          kendo.ui.progress($("#archive"), true);
        },
        requestEnd: function(e) {
          var error = null;

          // stop the progress bar
          kendo.ui.progress($("#archive"), false);

          // see if there is an error
          if ( e.response && e.response.homecuErrors )
            error = e.response.homecuErrors;

          if ( error && error.length > 0 ) {
            e.preventDefault();
            // make sure only old data
            this.cancelChanges();
            // show the error information
            $.homecuValidator.displayMessage(error, $.homecuValidator.settings.statusError);
          } else {
            if ( e.response && e.response.homecuData && (e.response.homecuData.img_url.length > 0) ) {
              CreateWindow(e.response.homecuData.img_url);
            }
          }
        }

      });

      $('#dateCleared').kendoDatePicker({format: "MM/dd/yyyy"});
      $('#dateCleared').data('kendoDatePicker').value(kendo.toString(new Date(), 'MM/dd/yyyy'));

      // create DropDownList from input HTML element
      $("#accountChoice").kendoDropDownList({
          dataTextField: "text",
          dataValueField: "value",
          dataSource: accountList
      });

      var checkNumber = $("#checkNumber").kendoMaskedTextBox({
        mask: "<?php echo str_repeat('0', 20); ?>",
        placeholder: "<?php echo $MC->msg('Check Number', HCU_DISPLAY_AS_HTML); ?>"
      }).data("kendoMaskedTextBox");

      var amount = $("#amount").kendoNumericTextBox({
        placeholder: "####.##",
        format: "$####.##",
        decimals: 2,
        spinners: false
      }).data("kendoNumericTextBox");

      $("#viewCheck").click( function() {
        if ( $.homecuValidator.validate() ) {
          var request = { action: "create_url", check_number: checkNumber.raw(),
                          amount: $("#amount").val(), date_cleared: $("#dateCleared").val(),
                          account: $("#accountChoice").val() };

          dsGetArchive.transport.read.type = "POST";
          dsGetArchive.read( request );
        }
      });

      // set up some validation, using the default error location
      $.homecuValidator.setup({formValidate: "formArchive",
                               formErrorTitle: "<?php echo $MC->msg("Error Occurred", HCU_DISPLAY_AS_JS) ?>"});

      function CreateWindow(url) {
          $('#checkWindow').kendoWindow({
              visible: false,
              actions: [ "Close" ],
              iframe: true,
              modal: true,
              title: "<?php echo $MC->msg("View Check Image", HCU_DISPLAY_AS_JS) ?>",
              resizable: true,
              width: 700,
              height: 650,
              open: function(e) {
                windowStack.push(this);
              },
              close: function(e) {
                windowStack.pop();
                this.content('');
                this.refresh('');
              },
              content: url
          });

          // doing it this way for IE8
          var dialog = $("#checkWindow").data('kendoWindow');
          dialog.center().open();
      }

  });

  $(document).on("click", ".k-overlay", function () {
    // close the currently open window
    if ( windowStack.length > 0 ) {
      windowStack[windowStack.length-1].close();
    }
  });

  </script>
  <style>
    #archive {
      max-width: 600px;
      margin-right: initial;
      margin-left: initial;
    }

    .hcu-edit-buttons {
      bottom: -10px !important;
    }
  </style>
  <div class="container" id="archive">

  <form class='formInputx well well-sm col-xs-12' id='formArchive' name='formArchive'>
    <div class="row">
      <div class="col-xs-12 hcuSpacer">
        <h3><?php echo $MC->msg('View Check Image', HCU_DISPLAY_AS_HTML); ?> <span id="displayStatus"></span></h3>
      </div>
    </div>

    <div class="row">
      <div class="col-xs-12 hcuSpacer">
          <label for="checkNumber"><?php echo $MC->msg('Check Number', HCU_DISPLAY_AS_HTML); ?>: </label>
          <div>
            <input id="checkNumber"
                   name="checkNumber"
                   value=""
                   required
                   data-required-msg="<?php echo "'{$MC->msg('Check Number', HCU_DISPLAY_AS_HTML)}' {$MC->msg('is a Required Field', HCU_DISPLAY_AS_HTML)}" ?>"
                   class="hcu-all-100" />
          </div>
      </div>
    </div>

    <div class="row">
      <div class="col-xs-12 hcuSpacer">
          <label for="amount"><?php echo $MC->msg('Amount', HCU_DISPLAY_AS_HTML); ?>: </label>
          <div>
            <input type="number"
                   id="amount"
                   name="amount"
                   value=""
                   required
                   data-required-msg="<?php echo "'{$MC->msg('Amount', HCU_DISPLAY_AS_HTML)}' {$MC->msg('is a Required Field', HCU_DISPLAY_AS_HTML)}" ?>"
                   class="hcu-all-100" />
          </div>
      </div>
    </div>

    <div class="row">
      <div class="col-xs-12 hcuSpacer">
          <label for="dateCleared"><?php echo $MC->msg('Date Cleared', HCU_DISPLAY_AS_HTML); ?>: </label>
          <div>
             <input type="text" class="hcu-all-100" id='dateCleared' name='dateCleared' value='' homecu-match="date"
             required data-required-msg="<?php echo "'{$MC->msg('Date Cleared', HCU_DISPLAY_AS_HTML)}' {$MC->msg('is a Required Field', HCU_DISPLAY_AS_HTML)}"; ?>"
             data-homecuCustomMatch-msg="<?php echo "'{$MC->msg('Date Cleared', HCU_DISPLAY_AS_HTML)}' {$MC->msg('is not a valid date', HCU_DISPLAY_AS_HTML)}"; ?>" />
          </div>
      </div>
    </div>

    <div class="row">
      <div class="col-xs-12 hcuSpacer">
          <label for="accountChoice"><?php echo $MC->msg('Account', HCU_DISPLAY_AS_HTML); ?>: </label>
          <div>
             <input class="hcu-all-100" id='accountChoice' />
          </div>
      </div>
    </div>
  </form>

  <div class="hcu-template">
    <div class="hcu-edit-buttons k-state-default">
        <a href="##" id="viewCheck" name="btnView" class="k-button k-primary">
          <span class="fa fa-eye"></span>&nbsp;<?php print $MC->msg('View', HCU_DISPLAY_AS_HTML); ?>
        </a>
     </div>
  </div>

</div>
<div id="checkWindow"></div>
<?php
} catch (Exception $ex) {
    //Return error message
    $thisPageErrors = $ex->getMessage();
    $errorObject = HCU_JsonDecode($thisPageErrors, true, false);
    $serviceErrorMsg = strlen( $errorObject->content ) > 0 ? $errorObject->content : $thisPageErrors;

    $serviceErrorTitle = "";
    if ( strlen( $errorObject->title ) ) {
      $serviceErrorTitle = $errorObject->title;
    }

    // * Include the Error page and finish
    $serviceErrorCode = '916';

    require_once(dirname(__FILE__) . '/../includes/hcuErrorPage.i');
}

  /*
   * ** END CONTENT
   */

  // ** INCLUDE POST CONTENT SCRIPT
  require_once(dirname(__FILE__) . '/../includes/hcuPostContent.i');

?>