aMemberUsers.prg

<?php
/**
 *  @package MemberHub
 *  @author MGHandy
 *
 *  @uses this script facilitates in viewing users related to the selected
 *  member account along with all sub-accounts.
 *
 *  @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_USERS", $admOk);

  $rOperation = isset($admVars["MEMBER_USERS"]["operation"]) ? $admVars["MEMBER_USERS"]["operation"] : null;
  $rPayload = isset($admVars["MEMBER_USERS"]["payload"]) ? $admVars["MEMBER_USERS"]["payload"] : null;
  $rSelect = isset($admVars["MEMBER_USERS"]["mSelect"]) ? $admVars["MEMBER_USERS"]["mSelect"] : null;

  $rMember = $rPayload ?
    MemberDecrypt($SYSENV, $Cu, $rPayload) :
    null;

  $rContext = $rPayload ?
    MemberContext($SYSENV, $Cu, $rMember['member']) :
    MemberContext($SYSENV, $Cu);

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

  switch ($rOperation) {
    case "":
      PrintMemberUsers();
      break;
    case "readMemberUsers":
      header('Content-type: application/json');

      $rRelated = readMemberUsers($SYSENV, $dbh, $rContext);
      $aryResult['data']['users'] = $rRelated['users'];
      MemberReply($aryResult, $aryReply, $rOperation);
      break;
    default:
      throw new Exception("Unknown server request: " . $rOperation);
      break;
  }

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

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

/**
 *  readMemberUsers:
 *  @uses read all users which have access to this member account in some way.
 *
 *  @param array $pEnv: evironment object for debugging
 *  @param object $pDbh: database access variable
 *  @param array $pContext: array of data needed for multiple member hub functions:
 *  @throws Exception
 *  in this case the member accountnumber.
 *
 *  @return array $sqlReturn: list of related users
 */
function readMemberUsers($pEnv, $pDbh, $pContext) {
  $cuTable = $pContext['cu_table'];
  $cuCode = $pContext['cu_code'];
  $cuAccount = $pContext['m_account'];

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

  //$sqlReturn = array();
  $sqlColumns = "
    u.user_name AS u_name,
    u.is_group_primary AS u_primary,
    ua.accounttype AS a_type,
    ua.recordtype AS a_record,
    ua.view_balances AS a_balances,
    ua.view_transactions AS a_transactions";

  // main query will grab all sub accounts related to each user with
  // access to this member account
  $sqlSelect = "
    SELECT $sqlColumns
    FROM {$cuTable}useraccounts ua
    INNER JOIN {$cuTable}user u ON u.user_id = ua.user_id
    WHERE ua.accountnumber = '$cuAccount'
    ORDER BY u.user_name, ua.accounttype";
  $sqlSelectRs = db_query($sqlSelect, $pDbh);
  if (!$sqlSelectRs) {
    $pEnv['logger']->error(db_last_error());
    throw new Exception("Failed to read related users.");
  }

  $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 will go to the user hub.
    $sqlPayload = readUserSearch($pDbh, $cuCode, array(
      "a" => array ("username"=>$value['u_name'])
    ));

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

    // add payload to user data
    $sqlData[$key]['u_payload'] = $sqlPayload;
  }

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

<?php
/**
 *  @package PrintMemberUsers
 *  @uses print neccessary html/javascript to run the selected card
 */
function PrintMemberUsers() { ?>
<div id="related">
  <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>
    </div>
  </div>
  <div id="relatedGrid"></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>
    </div>
  </div>
</div>

<?php
/**
 *  @package MemberRelated
 *  @uses this object is used to display and interact with the member related users
 *  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.
 *
 *  @var Action*            private: these functions are calls from kendoDialog
 *    actions, each explained by function name.
 */

?>

<script type="text/javascript">
//# sourceURL=memberUsers.js
var MemberUsers = function() {
  var mrCardContainer = null;
  var mrCardWindows = null;

  var mrPayload = null;
  var mrMember = null;
  var mrCall = null;
  var mrAction = null;

  var mrDataSource = null;

  var mrRelated = null;
  var mrRelatedGrid = null;
  var mrRelatedGridData = null;

  var mrCancel = null;

  var DataBuildUsers = function(data) {
    mrRelatedGridData = [];

    var row = 0;
    var currName = null;
    var nextName = 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 user = {
        u_row: row,
        u_payload: data[i].u_payload.trim(),
        u_name: data[i].u_name.trim(),
        u_primary: data[i].u_primary == "t" ? true : false,
        a_type: data[i].a_type.trim(),
        a_record: data[i].a_record.trim(),
        a_balances: data[i].a_balances == "t" ? "Y" : "N",
        a_transactions: data[i].a_transactions == "t" ? "Y" : "N"
      };

      mrRelatedGridData.push(user);
    }

    mrRelatedGrid.dataSource.data(mrRelatedGridData);
  }

  var EventMemberSelect = function(member) {
    var memberRequest = {
      operation: "selectMemberRelated",
      mSelect: JSON.stringify(member)
    };

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

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

    switch (windowId) {

    }

    mrCardWindows.push(this);
  }

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

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

    mrAction = null;
  }

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

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

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

  var InitDataSources = function() {
    mrDataSource = new kendo.data.DataSource({
      transport: {
        read: {
          url: "main.prg",
          dataType: "json",
          contentType: "application/x-www-form-urlencoded",
          type: "GET",
          data: {
            ft: "103103"
          },
          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 "readMemberUsers":
                DataBuildUsers(resultData.users);
                mrMember.cardTitle= "Group Info";
                var template= kendo.template($("#titleTemplate").html());
                mrRelated.title(template(mrMember)).center().open();
                break;
            }
          }, 500);
          return [];
        }
      }
    });
  }

  var InitDataViews = function() {
    mrRelated = mrCardContainer.find("#related").kendoWindow({
      title: "Related Users",
      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");

    var restrictionTemplate= kendo.template("<span>\\# if (#: code # == 'Y') { \\# <div class='restriction allow readonly hcu-all-100'><i class='fa fa-check'></i></div> "
      + "\\# } else { \\#<div class='restriction ban readonly hcu-all-100'><i class='fa fa-ban'></i></div> \\# } \\#</span>");

    mrRelatedGrid = $("#relatedGrid").kendoGrid({
      dataSource: {
        data: mrRelatedGridData
      },
      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",
          template: "<span>#= a_type #</span>" },
        { field: "a_record", title: "Type",
          template: "<span># if(a_record == \"L\"){# Loan #}else{# Deposit #}#</span>" },
        { field: "a_balances", title: "Balances",
          template: restrictionTemplate({code: "a_balances"}) },
        { field: "a_transactions", title: "History",
          template: restrictionTemplate({code: "a_transactions"}) }
      ]
    }).data("kendoGrid");

    mrCancel = $("#lnkCancel");
    mrInfoBar = $("#relatedInfo");
    mrInfoBar.hide();
  }

  var InitDataActions = function() {
    mrCancel.off();
    mrCancel.on("click", function() {
      mrRelated.close();
    });
  }

  this.Data = function(message, member) {
    mrPayload = message;
    mrMember = member;
  }

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

    mrCardWindows = windowStack;
    var memberRequest = {
      operation: "readMemberUsers",
      payload: mrPayload
    };

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

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

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

  this.Init = function(hubCall, cardContainer) {
    mrCall = hubCall;
    mrCardContainer = cardContainer;

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

    mrCall("MemberUsers", this);
  }
}
</script>
<?php }