userSupportAudit.prg

<?php
/**
 * @package UserSupport (Subpackage audit)
 * @author SPB
 *
 * This script is run when the user opens up the audit card in the user hub.  It cannot be run independently of that.
 */
require_once("$admLibrary/aAudit.i");

$string = array("filter" => HCUFILTER_INPUT_STRING);
HCU_ImportVars($parameters, "a", array("operation" => $string, "payload" => $string, "ft" => $string, "userId" => $string));
extract($parameters["a"]);

$operation = is_null($operation) ? "" : trim($operation);

try {
    $userId = HCU_PayloadDecode($Cu, $payload);
} catch(exception $e) { ?>
    <div class='noUserFound'><div>No User Found</div></div>
<?php exit;
}
PrintPage("$menu_link?ft=$ft", $userId["user_id"], GetAuditRecords($dbh, $Cu, $userId["user_id"], $SYSENV["logger"]));

/**
 * function GetAuditRecords($dbh, $Cu, $userId, $logger)
 * Gets the audit records
 *
 * @param $dbh -- the database connection
 * @param string $Cu -- the credit union
 * @param integer $userId -- the userId
 * @param object $logger -- for logging an error that shouldn't go to the admin user.
 * @return [date:"", actioncode:"", user:"", script:"", action:"", rown:0, details: [{table:"", label:"", type:"",
 *      rows: [{type: "", values: [{col: "", before: "", after: "", label: "", same: false}, ...]}, ...]}, ... ]]
 *      Type can be "mixed", "add", "delete", or "update" at the table level.  It cannot be "mixed" at the column level.
 */
function GetAuditRecords($dbh, $Cu, $userId, $logger) {

    try {
        $sql = "select auditdate as date, auditaction as actioncode, auditsrcuser_name as srcuser, auditrecbefore as before, auditrecafter as after, auditsrccode_context as script,
               auditfulldesc as action, row_number() over (order by auditdate desc) as rown from ${Cu}audituser where user_id = " . intval($userId);
        $sth = db_query($sql, $dbh);
        if (!$sth) {
            throw new exception("Audit query failed.", 12);
        }
        $auditRecords = array();
        $tz = null;
        for($i = 0; $row = db_fetch_assoc($sth, $i); $i++) {

            $results = ParseUserAuditRow($row, $Cu, $dbh);
            if ($results["status"] !== "000") { // Audit row is invalid in the database.  DO NOT KILL THE PAGE.  Instead DO NOT DISPLAY and log error in Kibana.
                $logger->error("Banking audit is invalid in the database.  CU: $Cu, Audit Date: " . $row["date"]);
                continue;
            }

            unset($row["before"]);
            unset($row["after"]);
            $row["details"] = $results["details"];

            // Do date stuff
            $tz = GetCreditUnionTimezone($dbh, $Cu);
            $dateTime = new DateTime($row["date"]);
            $dateTime->setTimezone(new DateTimeZone($tz));
            $row["date"] = $dateTime->format("Y-m-d H:i:s.u") . "Z";

            $auditRecords[] = $row;
        }
        $returnArray = array("status" => "000", "error" => array(), "auditRecords" => $auditRecords);
    } catch(exception $e) {
        $returnArray = array("status" => $e->getCode(), "error" => array($e->getMessage()));
    }
    return $returnArray;
}

/**
 * function PrintPage($self, $userId, $readData)
 * This function will print out the popup for the audit.
 *
 * @param $self -- the URL of this page
 * @param $userId -- the user id to get audits for.
 * @param $readData -- Audit data.
 */
function PrintPage($self, $userId, $readData) { ?>
    <script type="text/javascript">
    //# sourceURL=audit.js

    <?php
    /**
     * function Init()
     * Initializes kendo widgets for the page.
     */
    ?>
    function Init() {
        $.homecuValidator.setup({formValidate: "auditPrintForm", formStatusField: "formValidateDiv"});
        $("#externalTabWindow").data("preferredHeight", "auto");
        var record = <?php echo HCU_JsonEncode($readData); ?>;
        if (record.error.length > 0) {
            $.homecuValidator.displayMessage(record.error, $.homecuValidator.settings.statusError );
        } else {
            var auditData = record.auditRecords;
          $.homecuValidator.setup({formValidate:'auditPrintForm', formStatusField: 'formValidateStatusDiv'});

          var grid = $("#auditGrid").kendoGrid({
            dataSource: {
              transport: {
                read: function(options) {
                  options.success(auditData);
                }
              },
              schema: {
                model: {
                  id: "rown",
                  fields: {
                    rown: {type: "number"},
                    date: {type: "date"},
                    action: {type: "string"},
                    actioncode: {type: "string"},
                    details: {type: "odata"},
                    script: {type: "string"},
                    checked: {type: "boolean"},
                    srcuser: {type: "string"}
                  }
                }
              }
            },
            columns: [
              {template: "<input type='checkbox' class='rowCheckbox'>", attributes: {"class": "checkboxTD"},
              headerTemplate: "<input type='checkbox' class='allCheckbox'>", width: "45px", sortable: false, filterable: false},
              {field: "date", title: "Date", format: "{0:G}"},
              {field: "srcuser", title: "Changed By"},
              {field: "action", title: "Action Type"},

            ],
            noRecords: {
              template: "<tr class='noRecordsDiv'><td colspan='4'>No Records Found</td></tr>"
            },
            scrollable: false,
            sortable: true,
            toolbar: [{name: "print", text: "Print"}],
            detailTemplate: ReturnAuditDetailTemplate,
          }).data("kendoGrid");

          $("#auditGrid").on("click", ".auditDetailContainer .auditShowAllBtn", function() {
            if ($(this).text().trim() == "Show All") {
              $(this).closest(".auditDetailContainer").removeClass("hideAA");
              $(this).text("Show Changed");
            } else {
              $(this).closest(".auditDetailContainer").addClass("hideAA");
              $(this).text("Show All");
            }

            return false;
          });

          <?php printCheckboxEvents("#auditGrid", ".k-grid-print"); ?>

          $(".k-grid-print").addClass("k-state-disabled");

          $(".k-grid-print").click(function() {
            if (!$(this).hasClass("k-state-disabled")) {
              PrintAudits();
            }
            return false;
          });

          $(".k-grid-show").click(function() {
            if ($(this).text().trim() == "Show Filter") {
              $(".auditFilterDiv").show();
              $(this).text("Hide Filter");
            } else {
              $(".auditFilterDiv").hide();
              $(this).text("Show Filter");
            }
          });
        }
    }

    <?php
    /**
     * function AuditOpenPopup(auditData)
     * Opens up the popup for the audit.
     *
     * @param auditData -- the data for the audit.
     */
    ?>
    function AuditOpenPopup(auditData) {
      var dialog = $("#auditDetailWindow").data("kendoDialog");
      var template = kendo.template($("#auditDetailTemplate").html());

      if (dialog == null) {
        dialog = $("#previewWindow").kendoDialog({
          title: "Preview",
          actions: [{text: "Okay", primary: true}],
          visible: false,
          maxWidth: "99%",
          minWidth: 333,
          open: function() {
            if (window.activeWindows != null) {
              window.activeWindows.push(this);
            }
          },
          close: function() {
            if (window.activeWindows != null) {
              window.activeWindows.pop();
            }
          }
        }).data("kendoDialog");
      }

      dialog.content(template(auditData)).open();

      var maxHeight1 = 600;
      var maxHeight2 = $(window).height() - 150;
      var maxHeight = maxHeight2 >= maxHeight1 ? maxHeight1 : maxHeight2;
      $(dialog.wrapper).css({top: 5});
      $("#previewWindow .auditMaxHeight").css({maxHeight: maxHeight, overflowY: "auto", overflowX: "hidden"});
    }

    <?php
    /**
     * function PrintAudits()
     * This function prints the audits.
     */
    ?>
    function PrintAudits() {
        $("<div id='tempAudit' style='display:none;'><div class='container'><div class='row form-group mockKendoTable auditInsertion'></div></div></div>").appendTo("body");

        var gridData = $("#auditGrid").data("kendoGrid").dataSource.view();

        for(var i = 0; i != gridData.length; i++) {
          var record = gridData[i];
          if (record.checked) {
            var rowTemplate = "<div class='tr nobottom'><span class='col-xs-4'>" + record.action + "</span><span class='col-xs-4'>" + record.srcuser + "</span>"
                + "<span class='col-xs-4'>" + kendo.toString(record.date, 'd') + "</span></div><div class='tr notop'><span class='col-xs-12'><div class='container-fluid'><div class=' col-xs-12'>"
                + ReturnAuditDetailTemplate(record, true) + "</div></div></span></div>";
            $(".auditInsertion").append(rowTemplate);
          }
        }
        var newWindow = window.open("", "auditPrint");
        $("#auditPrintForm [name='shell']").val($("#tempAudit").html());
        $("#auditPrintForm [name='title']").val("User Audit of " + $(".kWindowCard .k-window-title").text().split("/")[2].trim());
        $("#auditPrintForm").submit();
        $("#tempAudit").remove();
    }

    <?php
    /**
     * function ReturnAuditDetailTemplate(row, isPrinting)
     * This function returns the detail template and is used in the grid.
     *
     * @param $row -- the row to display
     * @param isPrinting -- if true, display/hide some things
     * @return string of the whole HTML to paste
     */
    ?>
    function ReturnAuditDetailTemplate(row, isPrinting) {
        var returnString = '<div class="auditMaxHeight"><div class="container-fluid auditDetailContainer hideAA">';

        for (var i = 0, iLength = row.details.length; i != iLength; i++) {
            var tableRow = row.details[i];
            if (iLength > 1) {
                var message = tableRow.label + (tableRow.type != "mixed" ? "(" + tableRow.type + " records)" : "");
                returnString += '<div class="row form-group"><div class="col-xs-12"><h4 class="h4 hcuSpacerx">' + message + '</h4></div></div>';
            }

            if (tableRow.altDesc != null && tableRow.altDesc != "") {
                returnString += tableRow.altDesc;
                continue;
            }

            for (var j = 0, jLength = tableRow.rows.length; j != jLength; j++) {
                var rowRow = tableRow.rows[j];

                if (rowRow.altDesc != null && rowRow.altDesc != "") {
                    returnString += '<div class="row"><div class="col-xs-12">' + rowRow.altDesc + '</div></div>';
                    continue;
                }

                var showBefore = true;
                var showAfter = true;
                switch (rowRow.type) {
                    case "add": showBefore = false; break;
                    case "remove": showAfter = false; break;
                }
                var theseClasses = showBefore && showAfter ? "col-xs-4 col-md-4" : "col-xs-8 col-md-8";
                if (tableRow.type == "mixed") {
                    var message = rowRow.type + " record:";
                    returnString += '<div class="row form-group"><div class="col-xs-12"><h4 class="h4 hcuSpacerx">' + message + '</h4></div></div>';
                }
                returnString += '<div class="row form-group mockKendoTable">';
                if (!isPrinting && i == 0 && j == 0) {
                    returnString += '<a href="#" class="auditShowAllBtn">Show All</a><br>';
                }
                returnString += '<div class="th">';
                returnString += '<span class="col-xs-3 col-md-4">Column</span>';

                if (showBefore) {
                    returnString += '<span class="' + theseClasses + '">Before</span>';
                }
                if (showAfter) {
                    returnString += '<span class="' + theseClasses + '">After</span>';
                }

                returnString += '<div class="clearfix hidden-xs-block"></div>';
                returnString += '</div>'; <?php // Ends TH. ?>

                for (var k = 0, kLength = rowRow.values.length; k != kLength; k++) {
                    var colRow = rowRow.values[k];
                    var same = !isPrinting && colRow.same ? "aa" : "";

                    returnString += '<div class="tr ' + same + '">';
                    returnString += '<span class="col-xs-3 col-md-4">' + colRow.label + '</span>';

                    if (showBefore) {
                        returnString += '<span class="' + theseClasses + '">';
                        if (colRow.before == "") {
                            returnString += "&nbsp;";
                        } else {
                            returnString += colRow.before;
                        }
                        returnString += "</span>";
                    }

                    if (showAfter) {
                        returnString += '<span class="' + theseClasses + '">';
                        if (colRow.after == "") {
                            returnString += "&nbsp;";
                        } else {
                            returnString += colRow.after;
                        }
                        returnString += "</span>";
                    }

                    returnString += '<div class="clearfix hidden-xs-block"></div>';
                    returnString += '</div>'; <?php // Ends TR. ?>
                }

                returnString += "</div>"; <?php // Ends mockKendoTable. ?>
            }
        }

        returnString += "</div></div>"; <?php // Ends auditMaxHeight, container-fluid. ?>
        return returnString;
    }

    Init();
    </script>

    <div id="formValidateDiv" class="k-block k-error-colored" style="display:none"></div>
    <div id="auditGrid" class="hcu-all-100 pointerGrid"></div>
    <form id="auditPrintForm" method="post" action="shell.prg" target="auditPrint">
        <input type="hidden" name="shell" value="">
        <input type="hidden" name="title" value="">
    </form>
    <div id="previewWindow"></div>
<?php }