mUserList.prg

<?php
/**
 * File: mUserList.prg
 * This file will replace web stats.  It contains equivalent information for Odyssey clients only.
 */

// ********************************************************************************************************************************************************************************
// Top portion: includes and extracting parameters from commandline and/or post.
// ********************************************************************************************************************************************************************************

$monLibrary = dirname(__FILE__) . "/../library";
$sharedLibrary = dirname(__FILE__) . "../../shared/library";
require_once("$monLibrary/cu_top.i");
require_once("$monLibrary/ck_hticket.i");
require_once("$sharedLibrary/commonJsFunctions.i");

if (!CheckPerm($link, $Hu, basename($_SERVER['SCRIPT_NAME']), $_SERVER['REMOTE_ADDR'])) {
      header("Location: /hcuadm/hcu_noperm.prg");
      exit;
}

$string = array("filter" => FILTER_SANITIZE_STRING);
$params = array("cu" => $string);
$vars = array("cu" => "");
HCU_ImportVars($vars, "", $params);

$cu = HCU_array_key_value("cu", $vars);
$cu = $cu === false ? "" : trim($cu);

// Credit Union is required so prevent the script from executing if it doesn't exist.
if ($cu == "") {
    header("Location: /hcuadm/hcu_noperm.prg");
    exit;
}

// ********************************************************************************************************************************************************************************
// Common to .prg and .data (if there is enough lines of code, put it in an include file.)
// ********************************************************************************************************************************************************************************

/**
 * function GetMaxRowsList()
 * This function returns the specified options of the max rows kendoDropDownList.  It is used in the prg to set the kendo definition and in the data to verify that it is a correct option.
 */
function GetMaxRowsList() {
      return array("50", "100", "ALL");
}

// ********************************************************************************************************************************************************************************
// Top of the web page
// ********************************************************************************************************************************************************************************

// Imports the front end libraries: kendo, bootstrap, JQuery as well as formulates the top part of the web page.
printMonitorPageTop("User List", $homecuKendoVersion, $cloudfrontDomainName, $bootstrapVersion, $fontawesomeVersion, true);

// Writes out the top header.  Null means do not add anything to the options.
printMonitorPageMiddle("User List", null);

// ********************************************************************************************************************************************************************************
// Javascript code
// ********************************************************************************************************************************************************************************
?>

<script type="text/javascript">

<?php // Needed for the wait windows.
getShowWaitFunctions(); ?>

<?php
/**
 * function InitSearch() : javascript
 * This function sets up all the controls from the search part of the script.
 */ ?>
function InitSearch() {
    $.homecuValidator.setup({formValidate: "searchDiv", formStatusField: "searchStatusDiv"});

    <?php
    /**
     * @var memberNumberMTB
     * This creates a kendoMaskedTextBox.  It only allows up to 12 characters of digits (0-9).  The input rejects any other character.
     */
    ?>
    var memberNumberMTB = $("[name='memberNumber']").kendoMaskedTextBox({
      mask: "<?php echo str_repeat('0', 12); ?>"
    }).data("kendoMaskedTextBox");

    <?php
    /**
     * @var maxRowsDDL
     * This creates a kendoDropDownList.  Filter, dataTextField, and dataValueField are not needed.  There are only three options and it is a simple array.
     * Data comes from a PHP function.  This is necessary because it is used in both the prg and data scripts.
     */
    ?>
    var maxRowsDDL = $("#maxRowsDDL").kendoDropDownList({
        dataSource: {
            data: <?php echo HCU_JsonEncode(GetMaxRowsList()); ?>
        }
    }).data("kendoDropDownList");

    <?php
    /**
     * Anonymous jQuery function
     * When this link is clicked, all the text input controls are cleared.  The DropDownList is set to its default: "50."
     */
    ?>
    $(".clearBtn").click(function() {
        memberNumberMTB.value(null);
        $("[name='email']").val(null);
        $("[name='memberNumber']").val(null);
        maxRowsDDL.value("50");
    });

    <?php
    /**
     * Anonymous jQuery function
     * When this button is clicked, 1) the search DIV is hidden, 2) the results DIV is shown, and 3) there is a data call to get results.
     * If there is an error in the search DIV, an error is shown and nothing else happens.  Currently, that is only when the email field is not a valid email.
     */
    ?>
    $(".searchBtn").click(function() {
      if ($.homecuValidator.validate()) {
        $("#resultsGrid").data("kendoGrid").dataSource.read();
        $("#resultsDiv").show();
        $("#searchDiv").hide();
        $.homecuValidator.setup({formValidate: "resultsDiv", formStatusField: "searchResultsDiv"});
      }
    });
}

<?php
/**
 * function InitResults() : javascript
 * This function sets up all the controls from the results part of the script.
 */
?>
function InitResults() {
    <?php
    /**
     * @var resultsGrid
     * This creates a kendoGrid for the resultset.
     */
    ?>
    var resultsGrid = $("#resultsGrid").kendoGrid({
        dataSource: {
            transport: {
                read: {
                    url: "/hcuadm/mUserList.data",
                    dataType: "json",
                    type: "POST"
                },
          <?php
          /**
           * function parameterMap : javascript
           * This function gets all the parameters from the search DIV.  These parameters will be sent down to the data script.
           */
          ?>
                parameterMap: function(data, type) {
                    showWaitWindow();
                    var memberNumber = $("[name='memberNumber']").data("kendoMaskedTextBox").raw().trim();
                    var maxRows = $("#maxRowsDDL").data("kendoDropDownList").value();
                    var userName = $("[name='userName']").val().trim();
                    var email = $("[name='email']").val().trim();

                    return {memberNumber: memberNumber, numRows: maxRows, userName: userName, email: email, cu: "<?php echo $cu; ?>"};
                }
            },
            schema: {
                model: {
                    id: "login",
                    fields: {
                        login: {type: "number"},
                        user: {type: "string"},
                        member: {type: "string"},
                        email: {type: "string"},
                        lastLogin: {type: "string"},
                        <?php /* Even though this is a date, I will do the formatting and everything server-side.
              type: date will only be needed if filtering is needed. That is typical a no so keep the type as string. */ ?>
              hasEstmnt: {type: "boolean"},
              sort: {type: "number"}
                    }
                },
          <?php
          /**
           * function parse : javascript
           * This function gets the data from the data script.  It hides the wait window.  If there are any errors, then show them.  Then return the data portion to the grid.
           */
          ?>
                parse: function(data) {
                    hideWaitWindow();

                    if (data.error.length > 0)
                        $.homecuValidator.displayMessage(data.error, $.homecuValidator.settings.statusError);

                    return data.data;
                }
            }
        },
        columns: [
            {width: 35}, <?php // Icon (defined in rowTemplate) ?>
            {field: "user", title: "User Name"},
            {field: "member", title: "Member Number"},
            {field: "email", title: "Email"},
        {field: "hasEstmnt", title: "Estatement", width: 100}, <?php // Checkbox defined in rowTemplate ?>
            {field: "lastLogin", title: "Last Login", sortable: {
          <?php
          /**
           * compare : javascript
           * This function is needed because kendo treats nulls as before everything else.  Therefore, I check to see if it is null or not and if it is then it goes in the back of the list.
           */
          ?>
          compare: function (a, b) {
            var value = b.sort - a.sort;
            return value == 0 ? a.lastLogin.localeCompare(b.lastLogin) : value;
          }
        }}
        ],
        rowTemplate: $("#resultsRowTemplate").html(),
        autoBind: false, <?php // Do not want to do the read operation immediately. ?>
      sortable: {
        allowUnsort: false
      },
      noRecords: {
        template: "<tr><td>No records available</td></tr>"
      }
    }).data("kendoGrid");

    <?php
    /**
     * Anonymous jQuery function.
     * This function 1) clears out the search DIV, 2) hides the results DIV, and 3) shows the search DIV.
     */
    ?>
    $(".backBtn").click(function() {
      $("[name='memberNumber']").data("kendoMaskedTextBox").value(null);
      $("[name='userName']").val(null);
      $("[name='email']").val(null);
      $("[name='memberNumber']").val(null);
      $("#maxRowsDDL").data("kendoDropDownList").value("50");
      $("#resultsDiv").hide();
      $("#searchDiv").show();
      $.homecuValidator.setup({formValidate: "searchDiv", formStatusField: "searchStatusDiv"});
    });

    <?php
    /**
     * Anonymous jQuery function.
     * This function opens a new tab to log in as the user.
     */
    ?>
    $("#resultsGrid").on("click", "td:has(.loginBtn)", function() {
      var tr = $(this).closest("tr");
      var dataItem = resultsGrid.dataItem(tr);
      var url = "/hcuadm/suCuUser.prg?cucode=" + "<?php echo $cu; ?>" + "&obMbrLogin=CLS" + "&adminuser=" + dataItem.user;
      window.open(url, "_blank");
    });
}

<?php
/** Anonymous jQuery function.
 * When the document is ready, initialize controls in both the search and result DIVs.
 */
?>
$(document).ready(function() {
    InitSearch();
    InitResults();
});
</script>

<?php
// ********************************************************************************************************************************************************************************
// Kendo templates
// ********************************************************************************************************************************************************************************
?>

<?php
/**
 * @var resultsRowTemplate
 * This template is applied to every data row in the resultsGrid.
 */
?>
<script type="text/x-kendo-template" id="resultsRowTemplate">
  # var estatementString = hasEstmnt ? "checked" : ""; #
    <tr data-uid="#= uid #">
        <td><a href="\\#" class="loginBtn"><i class="fa fa-external-link"></i></a></td>
        <td>#: user #</td>
        <td>#: member #</td>
        <td>#: email #</td>
    <td><input type="checkbox" disabled readonly #: estatementString #></td>
        <td>#: lastLogin #</td>
    </tr>
</script>

<?php
// ********************************************************************************************************************************************************************************
// Local style
// ********************************************************************************************************************************************************************************
?>

<style>
<?php
/**
 * @var local-max-width
 * This class is so that the contents do not get too wide.
 */
?>
.local-max-width {
  max-width: 1000px;
}

<?php
/**
 * @var local-grid-cursor
 * This class overrides the cursor:pointer setting in hcu-no-td-border.  There are no actions in the body of this grid except for clicking on the icon to log in as a user.
 */
?>
.local-grid-cursor tbody {
  cursor: default;
}

.local-grid-cursor tbody tr td:eq(0) {
  cursor: pointer;
}
</style>

<?php
// ********************************************************************************************************************************************************************************
// HTML of page
// ********************************************************************************************************************************************************************************
?>

<?php
/**
 * @var searchDiv
 * This DIV contains all the inputs for searching.  There are two clickable links/buttons:
 *    "Clear" -- clears the text inputs and resets the kendoDropDownList.
 *    "Search" -- Makes this DIV invisible and the results DIV visible with the results grid populated.
 */
?>
<div class="local-max-width">
  <div id="searchDiv" class="container-fluid hcu-template form-horizontal">
    <div class="form-group">&nbsp;</div>
    <div class="well well-sm">
        <div id="searchStatusDiv"></div>
        <div class="form-group">
            <label class="col-xs-12 col-sm-3">Member Number</label>
            <div class="col-xs-12 col-sm-9"><input name="memberNumber" class="hcu-all-100"></div>
        </div>
        <div class="form-group">
          <label class="col-xs-12 col-sm-3">User Name</label>
            <div class="col-xs-12 col-sm-9"><input type="text" class="k-input k-textbox hcu-all-100" name="userName" maxlength="50"></div>
        </div>
        <div class="form-group">
            <label class="col-xs-12 col-sm-3">Email</label>
            <div class="col-xs-12 col-sm-9"><input name="email" type="email" class="k-input k-textbox hcu-all-100" maxlength="255" validationMessage="Email is invalid."></div>
        </div>
        <div class="form-group">
            <label class="col-xs-12 col-sm-3">Max Rows</label>
            <div class="col-xs-12 col-sm-9"><div id="maxRowsDDL" class="hcu-all-100"></div></div>
        </div>
      <div class="form-group">
        <div class="col-xs-12">
          <div class="hcu-edit-buttons">
              <a class="clearBtn" href="#">Clear</a>
                  &nbsp;&nbsp;&nbsp;
                <a class="searchBtn k-button k-primary" href="#"><i class="fa fa-check"></i>Search</a>
            </div>
        </div>
      </div>
    </div>
  </div>
</div>

<?php
/**
 * @var resultsDiv
 * This DIV contains the results grid.  There is one clickable link/button:
 *    "Search Again" -- this makes this DIV invisible and the search DIV visible and cleared/reset.
 */
?>
<div class="local-max-width">
  <div id="resultsDiv" class="container-fluid hcu-template form-horizontal local-max-width" style="display:none;"> <?php // Needs to match the search DIV for consistency. ?>
    <div id="searchResultsDiv"></div>
    <div class="form-group">&nbsp;</div>
    <div class="form-group">
      <div class="col-xs-12">
            <div id="resultsGrid" class="hcu-no-td-border local-grid-cursor"></div>
      </div>
    </div>
    <div class="form-group">
      <div class="col-xs-12">
        <div class="hcu-edit-buttons">
          <a class="backBtn k-button k-primary" href="#"><i class="fa fa-check"></i>Search Again</a>
        </div>
      </div>
    </div>
  </div>
</div>

<?php
// ********************************************************************************************************************************************************************************
// Bottom of page
// ********************************************************************************************************************************************************************************

// Will print out the closing tags created in the printMonitorPageTop function.
printMonitorPageBottom();
exit;