aMemberAccounts.prg

<?php
/**
 *  @package MemberHub
 *  @author MGHandy
 *
 *  @uses this script facilitates in viewing users related to the selected
 *  member account along with all accounts each of those users has access to.
 *
 *  @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
 *  @param mAccount     string: operation= select member account, this
 *  is the requested member account to selected in the member hub.
 *
 *  @return json
 */
require_once("$admLibrary/aMemberSupport.i");
require_once("$admLibrary/userSearch.i");

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

  $aOperation = isset($admVars["MEMBER_ACCOUNTS"]["operation"]) ? $admVars["MEMBER_ACCOUNTS"]["operation"] : null;
  $aPayload = isset($admVars["MEMBER_ACCOUNTS"]["payload"]) ? $admVars["MEMBER_ACCOUNTS"]["payload"] : null;
  $aSelect = isset($admVars["MEMBER_ACCOUNTS"]["mSelect"]) ? $admVars["MEMBER_ACCOUNTS"]["mSelect"] : null;

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

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

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

  switch ($aOperation) {
    case "":
      PrintMemberAccounts();
      break;
    case "readMemberAccounts":
      header('Content-type: application/json');
      $aRelated = ReadMemberAccounts($SYSENV, $dbh, $aContext);
      $aryResult['data']['accounts'] = $aRelated['accounts'];
      MemberReply($aryResult, $aryReply, $aOperation);
      break;
    default:
      throw new Exception("Unknown server request: " . $aOperation);
      break;
  }

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

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

/**
 *  @package ReadMemberAccounts
 *  @uses read all users related to the selected member with all accounts
 *  each user has access to.
 *
 *  @param array      $pEnv:  envirinment variable for debugging
 *  @param object     $pDbh: database asccess object
 *  @param array      $pContext:  context variable holding common data needed
 *  for member hub functions.
 *  @throws Exception
 *
 *  @return array sqlReturn: related users and accounts
 */
function ReadMemberAccounts($pEnv, $pDbh, $pContext) {
  $cuTable = $pContext['cu_table'];
  $cuCode = $pContext['cu_code'];
  $cuAccount = $pContext['m_account'];

  $sqlReturn = [
    'accounts' => []
  ];

  //$sqlReturn = array();
  $sqlColumns = "
    distinct on (ua.accountnumber)
    ua.accountnumber AS m_account,
    ua.user_id AS u_id,
    u.user_name AS u_name,
    u.is_group_primary AS u_primary";
  $sqlSub = "
    SELECT DISTINCT ON (us.user_id) us.user_id
    FROM {$cuTable}useraccounts us
    WHERE us.accountnumber = '$cuAccount'";
  $sqlSelect = "
    SELECT $sqlColumns
    FROM {$cuTable}useraccounts ua
    LEFT JOIN {$cuTable}memberacct ma
      ON ma.accountnumber = ua.accountnumber
    LEFT JOIN {$cuTable}user u 
      ON u.user_id = ua.user_id
    WHERE ua.user_id IN ($sqlSub)";

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

  $sqlData    = [];
  $result_arr = db_fetch_all($sqlSelectRs);

  if (! $result_arr) {
    return $sqlReturn;
  }

  foreach ($result_arr as $key => $value) {
    $sqlData[$key] = $value;

    // add payload for each user name
    // when user name is clicked it iwll go to the user hub
    $uPayload = readUserSearch($pDbh, $cuCode, array(
      "a" => array ("username"=>$value['u_name'])
    ));

    $mContext = MemberContext($pEnv, $cuCode, array("m_account" => $value['m_account']));
    $mSelect = MemberSelect($pEnv, $pDbh, $mContext);
    $mPayload = MemberEncrypt($pEnv, $cuCode, $mSelect);

    // must url encode or spaces will appear and break
    // the user hub script
    $mPayload = urlencode($mPayload);
    $uPayload = urlencode($uPayload['encryption']);

    // add payload to user data
    $sqlData[$key]['m_payload'] = $mPayload;
    $sqlData[$key]['u_payload'] = $uPayload;

  }

  $sqlReturn['accounts'] = $sqlData;
  return $sqlReturn;
}
?>


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

<div id="accounts">
  <div id="status">

  </div>
  <div class="hcu-secondary">
    <div class="small vsgSecondary">
      <span>The <span class="fa fa-asterisk"></span> means that the user is primary for a group.</span><br>
      <span>Click a user's name to select that user in the User Hub.</span><br>
      <span>Click a user's account number to select the member account in the Account Hub.</span>
    </div>
  </div>
  <div id="accountsGrid"></div>

  <div class="hcu-template">
    <div class="hcu-edit-buttons k-state-default">
      <span class="hcu-icon-delete">
      </span>
      <a href="##" id="lnkCancel" style="">Cancel</a>
    </div>
  </div>
</div>
<?php
/**
 *  @package MemberAccounts
 *  @uses this object is used to display and interact with the member related accounts
 *  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=memberAccounts.js
var MemberAccounts = function() {
  var maCardContainer = null;
  var maCardWindows = null;

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

  var maDataSource = null;

  var maAccounts = null;
  var maAccountsGrid = null;
  var maAccountsData = null;

  var maCancel = null;

  var DataBuildAccounts = function(data) {
    var row = 0;
    var currName = null;

    for (var i = 0; i < data.length; i++) {
      if (currName != data[i].u_name) {
        currName = data[i].u_name;
        row = 0;
      } else {
        row ++;
      }

      var account = {
        u_row: row,
        m_payload: data[i].m_payload.trim(),
        u_payload: data[i].u_payload.trim(),
        u_name: data[i].u_name.trim(),
        m_account: data[i].m_account.trim(),
        u_primary: data[i].u_primary == "t" ? true : false
      };

      maAccountsData.push(account);
    }

    maAccountsGrid.dataSource.data(maAccountsData);
  }

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

    switch (windowId) {

    }

    maCardWindows.push(this);
  }

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

    switch (maAction) {
      default:
        EventPopWindow(windowId);
        break;
    }

    maAction = null;
  }

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

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

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

  var InitDataSources = function() {
    maAccountsData = [];
    maDataSource = new kendo.data.DataSource({
      transport: {
        read: {
          url: "main.prg",
          dataType: "json",
          contentType: "application/x-www-form-urlencoded",
          type: "GET",
          data: {
            ft: "103105"
          },
          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("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;
          }

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

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

          setTimeout(function() {
            switch (resultOperation) {
              case "readMemberAccounts":
                DataBuildAccounts(resultData.accounts);
                maMember.cardTitle= "Related Accounts";
                var template= kendo.template($("#titleTemplate").html());
                maAccounts.title(template(maMember)).center().open();
                break;
            }
          }, 500);
          return [];
        }
      }
    });
  }

  var InitDataViews = function() {
    maAccounts = $("#accounts").kendoWindow({
      title: "Related Accounts",
      minWidth: 300,
      maxWidth: 768,
      maxHeight: 900,
      modal: true,
      visible: false,
      resizable: false,
      activate: EventOpenWindow,
      close: EventCloseWindow,
      open: function(e) {
        this.wrapper.css({ top: 100 });
      }
    }).data("kendoWindow");

    maAccountsGrid = $("#accountsGrid").kendoGrid({
      dataSource: {
        data: maAccountsData
      },
      dataBound: function() {
        $("a[id^=ACCT_]").each(function(i) {
          var tag = $(this);
          var tagText = tag.text().trim();
          var tagParent = tag.parent();
          if (tagText == maMember.m_account) {
            tag.remove();
            tagParent.append(
              "<div class=\"hcu-secondary\">" +
              "<span>" + maMember.m_account + "</span>" +
              "<span class=\"small vsgSecondary\"> (selected)</span>" +
              "</div>"
            );
          }
        });
      },
      noRecords: {
        template: "<span class=\"hcu-secondary\"><span class=\"vsgSecondary\">No Records Found</span></span>"
      },
      columns: [
        { title: " ", width: "35px",
          template: "#if(u_primary && u_row == 0){#<span class=\"fa fa-asterisk\"></span>#}#" },
        { field: "u_name", title: "User Name",
          template: "#if(u_row == 0) {#<a href=\"main.prg?ft=22&payload=#=u_payload#\">#= u_name #<i class=\"fa fa-user fa-fw\"></i></span>#}#" },
        { field: "a_type", title: "Account Number",
          template: "<a href=\"main.prg?ft=103101&payload=#=m_payload#\" id=\"ACCT_#= m_account #\">#= m_account #<i class=\"fa fa-book fa-fw\"></i></a>" }
      ]
    }).data("kendoGrid");

    maCancel = $("#lnkCancel");
    maStatus = $("#status");
    maStatus.hide();
  }

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

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

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

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

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

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

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

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

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

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