aMemberSearch.prg

<?php 
/**
 *  @package MemberHub
 *  @author MGHandy
 *
 *  @uses admin member search
 *    * search for member by strict member account number: meaning there will be no
 *    partial searches or full searches because of the possibility of thousands of results.
 *
 *  @var string $mOperation: requested search action
 *  @var string $mParameters: json string of form fields submitted by user
 *  @var string $mMember: requested member number
 */

require_once("$admLibrary/aMemberSupport.i");

try {
  $admVars = array();
  $admOk = array(
    "operation" => array("filter" => FILTER_SANITIZE_STRING),
    "mParameters" => array("filter" => FILTER_SANITIZE_STRING)
  );

  HCU_ImportVars($admVars, "MEMBER_SEARCH", $admOk);

  $sOperation = isset($admVars["MEMBER_SEARCH"]["operation"]) ? $admVars["MEMBER_SEARCH"]["operation"] : null;
  $sParameters = isset($admVars["MEMBER_SEARCH"]["mParameters"]) ? $admVars["MEMBER_SEARCH"]["mParameters"] : null;

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

  switch ($sOperation) {
    case "":
      PrintMemberSearch();
      break;
    case "memberSearch": 
      header('Content-type: application/json');

      $sValidate = MemberValidate($SYSENV, $sParameters, true);
      $sContext = MemberContext($SYSENV, $Cu, $sValidate);
      $sMembers = MemberSearch($SYSENV, $dbh, $sContext);

      if ($sMembers['members'] && count($sMembers['members']) == 1) {
        // single member found
        $sMember = $sMembers['members'][0];

        // validate member
        // update context
        // select display information
        // encrypt member
        $sMemberValidate = MemberValidate($SYSENV, $sMember);
        $sMemberContexet = MemberContext($SYSENV, $Cu, $sMemberValidate);
        $sMemberSelect = MemberSelect($SYSENV, $dbh, $sMemberContexet);
        $sMemberEncrypt = MemberEncrypt($SYSENV, $Cu, $sMemberSelect);

        $aryResult['data']['member'] = $sMemberSelect;
        $aryResult['data']['encrypt'] = $sMemberEncrypt;
      } else {
        $aryResult['data']['members'] = $sMembers['members'];
      }
      MemberReply($aryResult, $aryReply, $sOperation);
      break;
    default: 
      throw new Exception("Unknown server request: " . $sOperation);
      break;
  }

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

/**
 *  MemberSearch:
 *  @uses search for member by list of parameters:
 *  * member account number
 *
 *  @param $pEnv array: environment object for debugging
 *  @param $pDbh object: database access object
 *  @param $pContext array: context variable holding decrypted info and cu codes
 *  for use to access tables and values.
 *  @param $pParameters array: list of data fields to search on, validated for
 *  proper database use.
 *
 *  @return $sqlReturn array: list of members matching the search criteria
 */
function MemberSearch($pEnv, $pDbh, $pContext) {
  $cuTable = $pContext['cu_table'];
  $cuCode = $pContext['cu_code'];
  $cuAccount = $pContext['m_account'];

  $sqlReturn = array();
  $sqlColumns = "
    accountnumber AS m_account";
  $sqlSelect = "
    SELECT $sqlColumns
    FROM {$cuTable}memberacct
      WHERE accountnumber = '$cuAccount'";

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

  $sqlReturn['members'] = db_fetch_all($sqlSelectRs);
  return $sqlReturn;
}
?>

<?php 
/**
 *  @package PrintMemberSearch
 *  @uses print neccessary html/javascript to run the selected card
 */
function PrintMemberSearch() { ?>
<div id="search">
  <div id="status"></div>
  <div class="row hcuSpacer">
    <div class="col-sm-5">
      <label for="inpMbrAccount"> Account #</label>
    </div>
    <div class="col-sm-7">
      <input type="text" class="k-input k-textbox hcu-all-100" id="inpMbrAccount" name="inpMbrAccount"
        maxlength="12" 
        homecu-maxlen="12"
        data-homecuCustomMaxLen-msg="Account number must be at most 12 characters"
        data-required-msg="Account number is required" 
        required>
    </div>
  </div>
</div>

<div id="noResults" class="row">
  <div class="col-sm-12">
    <p>No accounts were found.</p>
  </div>
</div>

<?php
/**
 *  @package MemberSearch
 *  @uses this object is used to display and interact with the member searchfeature.
 *
 *  @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 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">

var MemberSearch = function() {
  var msCardContainer = null;
  var msCardWindows = null;

  var msCall = null;
  var msAction = null;

  var msSearch = null;
  var msNoResults = null;
  var msDataSource = null;

  var mrInputMember = null;

  var ValidateSearch = function() {
    var memberValue = mrInputMember.val().trim();
    var memberLength = memberValue.length;

    if (memberLength == 0) {
      mrInputMember.addClass("k-invalid");
      mrInputMember.focus();

      return false;
    } else {
      mrInputMember.removeClass("k-invalid");
      return true;
    }
  }

  var EventSendSearch = function() {
    var memberValue = mrInputMember.val();
    var memberData = {
      m_account: memberValue
    };

    var memberString = JSON.stringify(memberData);
    var memberRequest = {
      operation: "memberSearch",
      mParameters: memberString
    };

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

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

    switch (windowId) {
      case "search":
        mrInputMember.removeClass("k-invalid");
        mrInputMember.val("");
        mrInputMember.focus();
        break;
    }

    msCardWindows.push(this);
  }

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

    switch (msAction) {
      case "searchSubmit":
        if ($.homecuValidator.validate()) {
          EventSendSearch();
        } else {
          e.preventDefault();
        }
        break;
      case "searchStart":
        EventPopWindow(windowId);
        msSearch.open();
        break;
      default:
        EventPopWindow(windowId);
        break;
    }

    msAction = null;
  }

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

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

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

  var InitDataSources = function() {
    msDataSource = new kendo.data.DataSource({
      transport: {
        read: {
          url: "main.prg",
          dataType: "json",
          contentType: "application/x-www-form-urlencoded",
          type: "GET",
          cache: false,
          data: {
            ft: "103102"
          }
        }
      },
      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 "memberSearch":
                if (resultData.encrypt) {
                  // single member found
                  msCall("updateMemberInfo", resultData.member);
                  msCall("updateMemberEncrypt", resultData.encrypt);
                } else {
                  if (resultData.members) {
                    // if any results
                  } else {
                    msNoResults.open();
                  }
                }
                break;  
            }
          }, 500);
            
          return [];
        }
      }
    });
  }

  var InitDataViews = function() {
    msSearch = msCardContainer.find("#search").kendoDialog({
      title: "Account Search",
      modal: true,
      minWidth: 300,
      maxWidth: 900,
      visible: false,
      resizable: false,
      show: EventOpenWindow,
      close: EventCloseWindow,
      actions: [
        { text: "Cancel", 
          action: function() { msAction = "searchCancel"; }
        },
        { text: "Search", primary: true, 
          action: function() { msAction = "searchSubmit"; }
        }
      ]
    }).data("kendoDialog");

    msNoResults = msCardContainer.find("#noResults").kendoDialog({
      title: "Select Account",
      modal: true,
      minWidth: 300,
      maxWidth: 900,
      maxHeight: 500,
      visible: false,
      resizable: false,
      show: EventOpenWindow,
      close: EventCloseWindow,
      actions: [
        { text: "Cancel", 
          action: function() { msAction = "searchCancel"; }
        },
        { text: "Start Over", primary: true, 
          action: function() { msAction = "searchStart"; }
        }
      ]
    }).data("kendoDialog");

    mrInputMember = $("#inpMbrAccount");
  }

  var InitDataActions = function() {
    mrInputMember.on("keyup", function(e) {
      if (e.keyCode == 13) { 
        msAction = "searchSubmit";
        msSearch.close(); 
      }
    });
  }

  this.Open = function(windowStack) {
    msCardWindows = windowStack;
    msSearch.open();

    // setup validator on open
    $.homecuValidator.setup({
      formStatusField: "status",
      formValidate: "search"
    });
  }

  this.Close = function() {
    msSearch.destroy();
    msNoResults.destroy();

    $.homecuValidator.setup({
      formStatusField: "formStatus",
      formValidate: "cardContainerDiv"
    });
  }

  this.Init = function(hubCall, cardContainer) {
    msCall = hubCall;
    msCardContainer = cardContainer;

    InitDataSources();
    InitDataViews();
    InitDataActions();
  }
}
</script>
<?php }