aMemberEstmt.prg

<?php
/**
 *  @package MemberHub
 *  @author MGHandy
 *
 *  @uses this script facilitates in viewing e-statements associated with the
 *  selected 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");
require_once(dirname(__FILE__) . "/../../shared/library/hcuTranslate.i");
require_once(dirname(__FILE__) . "/../../shared/library/sAPIAppl.i");

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

  $eOperation = isset($admVars["MEMBER_ESTMT"]["operation"]) ? $admVars["MEMBER_ESTMT"]["operation"] : null;
  $ePayload = isset($admVars["MEMBER_ESTMT"]["payload"]) ? $admVars["MEMBER_ESTMT"]["payload"] : null;
  $ePdf = isset($admVars["MEMBER_ESTMT"]["mPdf"]) ? $admVars["MEMBER_ESTMT"]["mPdf"] : null;

  $eMember = $ePayload ?
    MemberDecrypt($SYSENV, $Cu, $ePayload) :
    null;

  $eContext = $ePayload ?
    MemberContext($SYSENV, $Cu, $eMember['member']) :
    MemberContext($SYSENV, $Cu);

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

  switch ($eOperation) {
    case "":
      PrintMemberEStatements();
      break;
    case "memberReadEStatements":
      header('Content-type: application/json');

      ValidatePermissions($ePayload, $eMember["member"], $Cn, $Cu);
      $eMemberStmt = MemberReadEStatements($SYSENV, $dbh, $eContext);
      $aryResult['data']['news'] = $eMemberStmt['estmt']['news'];
      $aryResult['data']['stmts'] = $eMemberStmt['estmt']['stmts'];
      MemberReply($aryResult, $aryReply, $eOperation);
      break;
    case "memberReadPdf":
      header('Content-type: application/pdf');
      ValidatePermissions($ePayload, $eMember["member"], $Cn, $Cu);
      $eValidate = MemberValidatePdf($SYSENV, $eContext, $ePdf);
      $eMemberStmt = MemberReadPdf($SYSENV, $dbh, $eContext, $eValidate);
      MemberReply($aryResult, $aryReply, $eOperation);
      break;
    default:
      throw new Exception("Unknown server request: " . $eOperation);
      break;
  }

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

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

/**
 * function ValidatePermissions($ePayload, $eMember, $Cn, $Cu)
 * Validates the permissions for eStatement flag and employee flag.
 *
 * @param $ePayload -- the payload: checking if it exists.
 * @param $eMember -- the data to extract the flags.
 * @param $Cn -- the logged in user.
 * @param $Cu -- the credit union.
 *
 * @throws an exception if the permissions are not met.
 */
function ValidatePermissions($ePayload, $eMember, $Cn, $Cu) {
  if (isset($ePayload)) {
    // Now, apply permissions:
    // Needs to have the eStatement flag set (account's estatements are ON.)
    // Needs to either be the master user OR also has the employee flag set.
    // This employee flag is true if one of the user's employee flag is true.
    // It is set on the payload during account search or through the related account link.
    $isMasterUser = $Cn == strtolower(trim($Cu));
    $hasPermissions = true;
    $hasPermissions = $hasPermissions && HCU_array_key_value("m_stmnt", $eMember) === "Y";
    if (!$isMasterUser) {
      $hasPermissions = $hasPermissions && HCU_array_key_value("m_employee", $eMember) !== "Y";
    }
    if (!$hasPermissions) {
      throw new exception ("You do not have permissions to view eStatements.");
    }
  }
}

function MemberValidatePdf($pEnv, $pContext, $pPdf) {
  $sList = html_entity_decode($pPdf, ENT_QUOTES);
  $dList = HCU_JsonDecode($sList);

  return $dList;
}

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

  $HB_ENV['Flang'] = "en_US";
  $HB_ENV['Fset3'] = $GLOBALS['Fset3'];
  $HB_ENV['Cu'] = $GLOBALS['Cu'];
  $HB_ENV['Cn'] = $GLOBALS['Cn'];
  $HB_ENV['chome'] = $GLOBALS['chome'];
  $HB_ENV['CU3_ESTMNT_CORE'] = $GLOBALS['CU3_ESTMNT_CORE'];
  $HB_ENV['dbh'] = $pDbh;
  $HB_ENV['SYSENV'] = $pEnv;

  // get translate object
  $MC = new hcu_talk_base($HB_ENV['Flang']);
  $eStmt = Create_PDF_Statement($pPdf['pdfKey'], $HB_ENV, $MC, $cuMember);
  if ($eStmt["status"]["code"] == "999" && count( $eStmt["errors"] ) > 0) {
    throw new Exception($eStmt["errors"][0]);
  }
}

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

  $sqlReturn = array();
  $sqlSelect = "
    SELECT email
    FROM {$cuTable}user u
    INNER JOIN {$cuTable}memberacct m ON m.primary_user = u.user_id
    WHERE m.accountnumber = '$cuMember'";
  $sqlSelectRs = db_query($sqlSelect, $pDbh);
  if (!$sqlSelectRs) {
    $pEnv['logger']->error(db_last_error());
    throw new Exception("Failed to read member email.");
  }
  $sqlData = db_fetch_all($sqlSelectRs)[0];

  // $http_scheme is defined in main.prg but we would have to include
  // it as a global in this function. Instead, we already have
  // the system environment, just define it locally the same way as main.prg.
  $http_scheme = $pEnv['require_encryption'] ? 'https' : 'http';

  // build ENV VARIABLE
  $HB_ENV['fi_path'] = "$http_scheme://{$GLOBALS['_SERVER']['HTTP_HOST']}/fi/{$cuTable}/";
  $HB_ENV['Flang'] = "en_US";
  $HB_ENV['Fset3'] = $GLOBALS['Fset3'];
  $HB_ENV['Cu'] = $GLOBALS['Cu'];
  $HB_ENV['Cn'] = $GLOBALS['Cn'];
  $HB_ENV['chome'] = $GLOBALS['chome'];
  $HB_ENV['live'] = $GLOBALS['live'];
  $HB_ENV['Ml'] = $sqlData['email'];
  $HB_ENV['CU3_ESTMNT_CORE'] = $GLOBALS['CU3_ESTMNT_CORE'];
  $HB_ENV['dbh'] = $pDbh;
  $HB_ENV['SYSENV'] = $pEnv;

  // get translate object
  $MC = new hcu_talk_base($HB_ENV['Flang']);

  // get e-statements
  $eStmt = Get_Estmt($pDbh, $HB_ENV, $MC, $cuMember);
  if ($eStmt["status"]["code"] == "999" && count( $eStmt["status"]["errors"] ) > 0) {
    throw new Exception($eStmt["status"]["errors"][0]);
  }

  $sqlReturn['estmt']['news'] =
    isset($eStmt["estmt"]["pdflinks"]) ? $eStmt["estmt"]["pdflinks"] : array();
  $sqlReturn['estmt']['stmts'] =
    isset($eStmt["estmt"]["toclinks"]) ? $eStmt["estmt"]["toclinks"] : array();
  return $sqlReturn;
}
?>

<?php
/**
 *  @package MemberEStatements
 *  @uses print neccessary html/javascript to run the selected card
 */
function PrintMemberEStatements() { ?>
<style type="text/css">
.hcu-pdf-link {
  cursor: pointer;
  display: block;

  margin-top: 15px;
  margin-bottom: 15px;
}

.hcu-pdf-link .hcu-pdf-icon,
.hcu-pdf-link .hcu-pdf-info {
  display: table-cell;
}

.hcu-pdf-link .hcu-pdf-info {
  vertical-align: middle;
  text-align: center;
  width: 100%;
}
</style>

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

  <div class="well well-sm col-sm-12">
    <h3>Newsletters</h3>
  </div>

  <div class="row" id="meNewsView"></div>

  <div class="well well-sm col-sm-12">
    <h3>eStatements</h3>
  </div>

  <div class="row" id="meStmtView"></div>

  <div class="hcu-template">
    <div class="hcu-edit-buttons k-state-default">
      <a href="##" id="btnUpdate" class="k-button k-primary">
        <i class="fa fa-times fa-lg"></i>
        Close
      </a>
    </div>
  </div>
</div>

<script type="text/x-kendo-template" id="meTemplate">
    <a class="hcu-pdf-link col-sm-4 col-lg-3"
      data-index="#= pdfIndex #"
      data-source="#= pdfType #">
      <div class="well well-sm">
        <div class="hcu-pdf-icon">
          <span class="fa fa-3x fa-file-pdf-o"></span>
        </div>
        <div class="hcu-pdf-info">
          <span><strong>#= pdfTitle #</strong></span>
          #if(pdfType == "stmt") {#
          <br>
          <span>#= pdfStmt #</span>
          #}#
        </div>
      </div>
    </a>
</script>
<?php
/**
 *  @package MemberEStatements
 *  @uses this object is used to display and interact with the member e-statements 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
 *   MemberEStatements 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">
var MemberEStatements = function() {
  var meCardContainer = null;
  var meCardWindows = null;

  var mePayload = null;
  var meMember = null;
  var meCall = null;

  var meAction = null;
  var meDataSource = null;
  var meStmts = null;
  var meStmtsOpened = false;

  var meStmtView = null;
  var meStmtData = null;
  var meNewsView = null;
  var meNewsData = null;
  var meTemplate = null;

  var meClose = null;

  var DataBuildNews = function(data) {
    meNewsData = [];
    for (var i = 0; i < data.length; i++) {
      var letter = {
        pdfIndex: i,
        pdfTitle: data[i].pdftitle.trim(),
        pdfPath: data[i].pdfpath.trim(),
        pdfType: "news"
      };

      meNewsData.push(letter);
      meNewsView.append(meTemplate(letter));
    }
  }

  var DataBuildStmt = function(data) {
    meStmtData = [];
    for (var i = 0; i < data.length; i++) {
      var stmt = {
        pdfIndex: i,
        pdfTitle: data[i].PerDesc.trim(),
        pdfStmt: data[i].PerType.trim(),
        pdfEnd: data[i].PerEnd.trim(),
        pdfTokn: data[i].PerTokn.trim(),
        pdfKey: data[i].PerKey.trim(),
        pdfType: "stmt"
      };

      meStmtData.push(stmt);
      meStmtView.append(meTemplate(stmt));
    }
  }

  var DataBuildLinks = function() {
    $(".hcu-pdf-link").each(function(i) {
      $(this).on("click", EventReadPdf);
    });
  }

  var EventReadPdf = function(e) {
    var pdfIndex = $(this).data("index");
    var pdfType = $(this).data("source");
    var pdfData = null;
    var pdfPath = "";

    switch (pdfType) {
      case "news":
        pdfData = meNewsData[pdfIndex];
        pdfPath = pdfData.pdfPath;
        break;
      case "stmt":
        pdfData = meStmtData[pdfIndex];
        pdfPath += "main.prg?ft=103108";
        pdfPath += "&operation=memberReadPdf";
        pdfPath += "&payload=" + encodeURIComponent(mePayload);
        pdfPath += "&mPdf=" + encodeURIComponent(JSON.stringify(pdfData));
        break;
    }

    window.open(pdfPath);
  }

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

    switch (windowId) {
      default:
        meStmtsOpened = true;
        break;
    }

    meCardWindows.push(this);
  }

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

    switch (meAction) {
      default:
        meStmtsOpened = false;
        break;
    }

    meAction = null;
  }

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

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

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

  var InitDataSources = function() {
    meDataSource = new kendo.data.DataSource({
      transport: {
        read: {
          url: "main.prg",
          dataType: "json",
          contentType: "application/x-www-form-urlencoded",
          type: "GET",
          data: {
            ft: "103108"
          },
          cache: false
        }
      },
      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("errors")) {
              if (meStmtsOpened == false) {
                $.homecuValidator.setup({ formStatusField: "formStatus", formValidate: "cardContainerDiv" });
              }
              $.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")) {
            hideWaitWindow();
            return [];
          }

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

          setTimeout(function() {
            hideWaitWindow();

            switch (resultOperation) {
              case "memberReadEStatements":
                DataBuildStmt(resultData.stmts);
                DataBuildNews(resultData.news);
                DataBuildLinks();

                meMember.cardTitle= "Member eStatements";
                var template= kendo.template($("#titleTemplate").html());
                meStmts.title(template(meMember)).center().open();
            }
          }, 500);

          return [];
        }
      }
    });
  }

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

    meNewsView = $("#meNewsView");
    meStmtView = $("#meStmtView");
    meTemplate = kendo.template($("#meTemplate").html());

    meStatus = $("#meStatus");
    meStatus.hide();

    meClose = $("#btnUpdate");
  }

  var InitDataActions = function() {
    meClose.on("click", function(e) {
      meStmts.close();
    });
  }

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

    meCardWindows = windowStack;
    var memberRequest = {
      operation: "memberReadEStatements",
      payload: mePayload
    };

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

  this.Close = function() {
    meStmts.destroy();

    // reset validator for hub script
    $.homecuValidator.setup({
      formStatusField: "formStatus",
      formValidate: "cardContainerDiv"
    });
  }

  this.Data = function(payload, member) {
    mePayload = payload;
    meMember = member;
  }

  this.Init = function(hubCall, cardContainer) {
    meCall = hubCall;
    meCardContainer = cardContainer;

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

    meCall("MemberEStatements", this);
  }
}
</script>
<?php }