mCorerequestsReport.prg

<?php
/*
* File: mCorerequestsReport.prg (corerequests_report ported from Mammoth)
*
* Purpose:  display contents of core requests from the cucorerequests table
*/

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


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

printMonitorPageTop("Core Requests Report", $homecuKendoVersion, $cloudfrontDomainName);
printMonitorPageMiddle("Core Requests Report");
?>

<script type="text/javascript">

<?php
// Include common functions
getShowWaitFunctions();
?>

    var requestTypes = [
        {"value":"", "text":"Select Type"},
        {"value":"I", "text":"I - Account Inquiry"},
        {"value":"X", "text":"X - Cross Accounts"},
        {"value":"T", "text":"T - Transactions related"},
        {"value":"MIR", "text":"MIR - Member Info Inquiry"},
        {"value":"ETOC", "text":"ETOC - eStatement Table of Contents"},
        {"value":"ESTM", "text":"ESTM - eStatement Request"},
        {"value":"NEWAPP", "text":"NEWAPP - Submit New Loan App"},
        {"value":"INQAPP", "text":"INQAPP - Loan App Inquiry"},
    ];

    $(document).ready(function(e) {

        $.homecuValidator.setup({formValidate:'searchFrm', formStatusField: 'formErrorDiv'});

        //autocomplete for cu code input
    $("#cuCode").kendoAutoComplete({
      minlength: 2,
      clearButton: false,
      dataSource: new kendo.data.DataSource({
        transport: {
          read: {
                        url: "mCorerequestsReport.data",
                        data: { action: "read_cus"},
                        type: "POST"
          }
        },
        schema: {
          data: "Results.data"
        }
      }),
      placeholder: "Start typing...",
      change: function() {
        var found = false;
        var value = $("#cuCode").val();
                var data = this.dataSource.view();
        for( var i = 0, length = data.length; i < length; i++ ) {
          if( data[i] === value) {
            found = true;
            break;
          }
        }

        if( !found ) {
          this.value("");
          alert("Please select a value from the list.");
        }
      }
    });

        // Hide error div until needed
        $("#formErrorDiv").hide();

        $("#requestType").kendoDropDownList({
            dataTextField: "text",
            dataValueField: "value",
            dataSource: requestTypes
        });

        $("#timeStart, #timeEnd").kendoDateTimePicker({
            format: "yyyy-MM-dd HH:mm:ss",
        });

        var todayDate = kendo.toString(kendo.parseDate(new Date()), 'yyyy-MM-dd');
        var endDate = kendo.toString(kendo.parseDate(new Date()), 'yyyy-MM-dd 23:59:59');
    $("#timeStart").data("kendoDateTimePicker").value(todayDate);
        $("#timeEnd").data("kendoDateTimePicker").value(endDate);

        $("#gridRequests").kendoGrid({
            dataSource: {
                data: [],
                pageSize: 10
            },
            noRecords: {
                template: "No core requests were found."
            },
            columns: [
                { field: "cu", title: "Credit Union" },
                { field: "accountnumber", title: "Member" },
                { field: "appliance_ip", title: "Appliance IP", hidden: true },
                { field: "remote_ip", title: "Remote IP", hidden: true },
                { field: "request_type", title: "Request Type" },
                { field: "request_url", title: "Request Url", hidden: true, template: kendo.template($("#templateURL").html()) },
                { field: "request_start", title: "Start Time" },
                { field: "request_end", title: "End Time", hidden: true },
                { field: "request_elapsed", title: "Elapsed (including Retry Delays)" },
                { field: "request_status", title: "Status", template: kendo.template($("#templateStatus").html()) }
            ],
            sortable: true,
            filterable: true,
            columnMenu: true,
            pageable: true
        });

        $("#search").on("click", function(e) {

            var cuCode = $("#cuCode").val();
            var member = $("#member").val();
            var applianceIp = $("#applianceIp").val();
            var requestType = $("#requestType").data("kendoDropDownList").value();
            var timeStart = $("#timeStart").data("kendoDateTimePicker").value();
            var timeEnd = $("#timeEnd").data("kendoDateTimePicker").value();

            var error = "";
            // Validate parameters: Time
            if (timeEnd != null && timeStart == null) {
                error = "Start Time is required with End Time";
            } else if (timeEnd != null && timeStart != null) {
                // End time cannot be before start time
                if (timeEnd <= timeStart) {
                    error = "End Time cannot be less than Start Time";
                }
            }

            // Validate CU Code
            if (cuCode == '') {
                error = "CU Code is required.";
            }

            if (error.length > 0) {
                $.homecuValidator.displayMessage(error, $.homecuValidator.settings.statusError);
                return;
            } else {
                $.homecuValidator.hideMessage();
            }

            var request = {
                action: "search",
                cucode: cuCode,
                member: member,
                applianceip: applianceIp,
                requesttype: requestType,
                timestart: (timeStart == null ? "" : kendo.toString(timeStart, 's')),
                timeend: (timeEnd == null ? "" : kendo.toString(timeEnd, 's'))
            };

            showWaitWindow();

            // disable the button
            $(this).prop("disabled", "disabled");

            $.ajax({
                type: "POST",
                url: "mCorerequestsReport.data",
                data: request
            })
            .done(function (data, textStatus, jqXHR) {
                // Show the result
                var error = "";
                if (data.Results.requests) {
                    var requests = data.Results.requests;
                  var dropdown = $("#gridRequests").data("kendoGrid").dataSource.data(requests);
                    $.homecuValidator.hideMessage();
                } else {
                    error = "Failed to retrieve results";
                    $.homecuValidator.displayMessage(error, $.homecuValidator.settings.statusError);
                }
            })
            .fail(function (jqXHR, textStatus, errorThrown) {
                $.homecuValidator.displayMessage(errorThrown, $.homecuValidator.settings.statusError);
                $("#search").removeProp("disabled");
            })
            .always(function (jqXHR, textStatus, errorThrown) {
                hideWaitWindow();
                $("#search").removeProp("disabled");
      });
        });

        // Setup viewdetails checkbox
        // Show detail columns when checked.
        $("#viewDetails").on('change', function(e) {
            var checked = $(this).prop("checked");
            var grid = $("#gridRequests").data("kendoGrid");
            if (checked) {
                grid.showColumn(2);
                grid.showColumn(3);
                grid.showColumn(5);
                grid.showColumn(7);
            } else {
                grid.hideColumn(2);
                grid.hideColumn(3);
                grid.hideColumn(5);
                grid.hideColumn(7);
            }
        });

    });

</script>

<script type="text/x-kendo-template" id="templateURL">
    # if (data && data.request_url) { #
        # var url = decodeURIComponent(data.request_url); #
        <span>#= url #</span>
    # } #
</script>

<script type="text/x-kendo-template" id="templateStatus">
    # if (data && data.request_status) { #
        # var request_status = data.request_status; #
        # if (request_status) { #
            <span><strong>Code: </strong>#: request_status.status.code #</span><br>
            <span><strong>Description: </strong>#: request_status.status.desc #</span><br>
            <span><strong>Extra: </strong>#: request_status.status.extra #</span><br>
            <span><strong>Packet Size: </strong>#: request_status.status.packetsize #</span><br>
            <span><strong>Message: </strong>#: request_status.error.messages #</span><br>
            <span><strong>DB Error: </strong>#: request_status.note.dberror #</span><br>
            # if (request_status.status.attempted_core_conns) { #
                <span><strong>Attempted Core Connections: </strong>#: request_status.status.attempted_core_conns #</span><br>
            # } #
            <span><strong>Curl Error Code(s): </strong>#: request_status.status.curl_errno #</span><br>
        # } #
    # } #

</script>

<style type="text/css">

    body {
        font-family: Arial, Helvetica, sans-serif;
        background-color: #EFEFEF;
                font-size: 14px;
  }

    * {
        padding: 0;
        margin: 0;
    }

    [class*='col-'] {
        float: left;
    }

    .row {
        margin-bottom: 15px;
        margin-right: 15px;
        margin-left: 15px;
    }

    .row:after {
        content: "";
        clear: both;
        display: table;
    }

    .col-1 { width: 8.33%; }
    .col-2 { width: 16.67%; }
    .col-3 { width: 25%; }
    .col-4 { width: 33.33% }
    .col-5 { width: 41.67%; }
    .col-6 { width: 50%; }
    .col-7 { width: 58.33%; }
    .col-8 { width: 66.67%; }
    .col-9 { width: 75%; }
    .col-10 { width: 83.33%; }
    .col-11 { width: 91.67%; }
    .col-12 { width: 100%; }

    .k-grid tbody td {
        text-overflow: clip; /* prevent the ellipsis behavior */
        overflow-wrap: break-word;
     }

    #timeStart, #timeEnd {
        margin-top:5px;
    }

</style>

<div class="container-fluid" id="searchFrm">
    <div class="form-horizontal form-widgets well well-sm">
    <div class="row k-block k-error-colored" id="formErrorDiv"></div>

        <div class="row">
            <div class="form-group">
                <label class="col-2" for="cuCode">Credit Union:</label>
                <input name="cuCode" id="cuCode" class="k-textbox col-3" maxlength="12">
            </div>
        </div>

        <div class="row">
            <div class="form-group">
                <label class="col-2" for="member">Member:</label>
                <input name="member" id="member" class="k-textbox col-3" maxlength="12">
            </div>
        </div>

        <div class="row">
            <div class="form-group">
                <label class="col-2" for="applianceIp">Appliance IP:</label>
                <input name="applianceIp" id="applianceIp" class="k-textbox col-3">
            </div>
        </div>

        <div class="row">
            <div class="form-group">
                <label class="col-2" for="requestType">Request Type:</label>
                <input name="requestType" id="requestType" class="col-3">
            </div>
        </div>

        <div class="row">
            <div class="form-group">
                <label class="col-2">Date:</label>
                    <div class="col-6">
                        <div style="display: inline-block;">
                            <label for="timeStart">From:</label><br>
                            <input type="" name="timeStart" id="timeStart" class="">
                        </div>
                        <div style="display: inline-block;">
                            <label for="timeEnd">To:</label><br>
                            <input type="" name="timeEnd" id="timeEnd" class="">
                        </div>
                    </div>
            </div>
        </div>

        <div class="row">
            <div class="form-group">
                <label class="col-2" for="viewDetails">View Details:</label>
                <div class="col-6">
                    <input type="checkbox" name="viewDetails" id="viewDetails" >
                </div>
            </div>
        </div>

        <div class="row">
            <div class="form-group">
                <div class="col-6">
                    <button class="k-button k-primary" id="search">Search</button>
                </div>
            </div>
        </div>

    </div>
</div>

<div class="container-fluid">
    <div class="row">
        <div id="gridRequests"></div>
    </div>
</div>

<?php printMonitorPageBottom(); ?>