aBankingAudit.prg

<?php
/**
 * @package aBankingAudit.prg
 * Shows all banking audits.
 */

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

$string = array("filter" => HCUFILTER_INPUT_STRING);
HCU_ImportVars($SYSENV, "IMPORTS", array("operation" => $string, "duration" => $string, "auditUser" => $string, "loggedInUser" => $string, "actionType" => $string,
                                         "startOn" => $string, "account" => $string, "limit" => $string, "offset" => $string, "sort" => $string, "showThis" => $string,
                                         "changedOnly" => $string, "endOn" => $string));

$operation = HCU_array_key_value("operation", $SYSENV["IMPORTS"]);
if ($operation !== false) {
    switch($operation) {
        case "readAudits":
            $returnArray = GetAuditRecords($dbh, $Cu, $SYSENV["IMPORTS"], $SYSENV["logger"]);
            break;
        default: // Won't get here
          $returnArray = array("error" => array("Operation not specified: '$operation'"), "record" => array());
    }

    header('Content-type: application/json');
    print HCU_JsonEncode($returnArray);
} else {
    PrintPage("$menu_link?ft=$ft", GatherPageData($dbh, $Cu));
}

/**
 * function GatherPageData($dbh, $Cu)
 * Retrieves the data that the page needs immediately for dropdownlists.
 *
 * @param $dbh -- the database connection.
 * @param $Cu -- the credit union
 *
 * @return $status -- "000" if successful, nonzero otherwise.
 * @return $error -- "" if successful, nonempty otherwise.
 * @return $data.types -- A list of types available.
 * @return $data.shows -- A list of all/admin/banking.
 * @return $data.prints -- data for the print dropdownlist
 */
function GatherPageData($dbh, $Cu) {
    try {

        $results = GetAuditTypesList($dbh, $Cu);
        if ($results["status"] !== "000") {
            throw new exception($results["error"], 1);
        }
        $types = $results["ddl"];

        $shows = array(
                        array("value" => "all", "text" => "Banking and Admin User Changes"),
                        array("value" => "admin", "text" => "Admin User Changes Only"),
                        array("value" => "banking", "text" => "Banking User Changes")
                    );

        $prints = array(
                        array("value" => "", "text" => "Print Events"),
                        array("value" => "selected", "text" => "Selected Events Only"),
                        array("value" => "changed", "text" => "All Events (Changes Only)"),
                        array("value" => "all", "text" => "All Events")
                    );


        $returnArray = array("status" => "000", "error" => "", "data" => array("types" => $types, "shows" => $shows, "prints" => $prints));
    } catch (exception $e) {
        $returnArray = array("status" => $e->getCode(), "error" => $e->getMessage());
    }
    return $returnArray;
}


/**
 * Return the list of audit types. This has changed to a hardcoded list
 * as returning values from the database returned too many duplicates
 * from having the same text description for different audit type values.
 * NOTE: this is formatted for use with a Kendo DropdownList.
 */
function GetAuditTypesList(){
    $types = [
      ["text"=>'All Types', "value"=>''],
      ["text"=>'Account Delete', "value"=>'Account Delete'],
      ["text"=>'Activate User', "value"=>'Activate User'],
      ["text"=>'Add New Account', "value"=>'Add New Account'],
      ["text"=>'Alert Status Update', "value"=>'Alert Status Update'],
      ["text"=>'Auto Add User Accounts', "value"=>'Auto Add User Accounts'],
      ["text"=>'Correct Restrictions', "value"=>'Correct Restrictions'],
      ["text"=>'Delete Account', "value"=>'Delete Account'],
      ["text"=>'E-Statement Update', "value"=>'E-Statement Update'],
      ["text"=>'Forgot Password', "value"=>'Forgot Password'],
      ["text"=>'Group Add', "value"=>'Group Add'],
      ["text"=>'Group Deleted', "value"=>'Group Deleted'],
      ["text"=>'Member Account Rights Change', "value"=>'Member Account Rights Change'],
      ["text"=>'Member Settings', "value"=>'Member Settings'],
      ["text"=>'Phone Add', "value"=>'Phone Add'],
      ["text"=>'Primary User Access Add', "value"=>'Primary User Access Add'],
      ["text"=>'Primary User Access Delete', "value"=>'Primary User Access Delete'],
      ["text"=>'Required Profile Update', "value"=>'Required Profile Update'],
      ["text"=>'Reset Password', "value"=>'Reset Password'],
      ["text"=>'Rights Add', "value"=>'Rights Add'],
      ["text"=>'Rights Delete', "value"=>'Rights Delete'],
      ["text"=>'Rights Update', "value"=>'Rights Update'],
      ["text"=>'Status Update', "value"=>'Status Update'],
      ["text"=>'Update Account', "value"=>'Update Account'],
      ["text"=>'Update User Security', "value"=>'Update User Security'],
      ["text"=>'User Accounts Add', "value"=>'User Accounts Add'],
      ["text"=>'User Accounts Update', "value"=>'User Accounts Update'],
      ["text"=>'User Add', "value"=>'User Add'],
      ["text"=>'User Login Deleted', "value"=>'User Login Deleted'],
      ["text"=>'User Member Add', "value"=>'User Member Add']
    ];
    $returnArray = array("status" => "000", "error" => "", "ddl" => $types);
    return $returnArray;

  }


/**
 * function GetAuditRecords($dbh, $Cu, $parameters, $logger)
 * Gets the audit records
 *
 * @param $dbh -- the database connection
 * @param string $Cu -- the credit union
 * @param array $parameters -- the parameters for the audit record.
 * @param object $logger -- logs to kibana
 * @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, $parameters, $logger) {
    try {
        extract($parameters);

        $duration = strtolower(isset($duration) ? trim($duration) : "");
        $auditUser = strtolower(isset($auditUser) ? trim($auditUser) : "");
        $account = strtolower(isset($account) ? trim($account) : "");
        $loggedInUser = strtolower(isset($loggedInUser) ? trim($loggedInUser) : "");
        $actionType = strtolower(isset($actionType) ? trim($actionType) : "");

        $startOn = isset($startOn) ? trim($startOn) : "";
        $endOn = isset($endOn) ? trim($endOn) : "";
        $showThis = isset($showThis) ? trim($showThis) : "";
        $changedOnly = isset($changedOnly) ? trim($changedOnly) == "Y" : false;

        $limit = isset($limit) ? intval($limit) : 0;
        $offset = isset($offset) ? intval($offset) : 0;
        $limitSQL = $limit == 0 && $offset == 0 ? "" : "limit $limit offset $offset";

        $sort = isset($sort) ? trim($sort) : "";
        $sortSQL = array();
        if ($sort != "") {
            $sort = HCU_JsonDecode($sort);
            foreach($sort as $sortItem) {
                if (!HCU_array_key_exists("field", $sortItem) || !HCU_array_key_exists("dir", $sortItem)) {
                    throw new exception ("Sort is invalid.", 24);
                }
                $field = $sortItem["field"];
                $dir = $sortItem["dir"];

                if (!in_array($dir, array("asc", "desc"))) {
                    throw new exception ("Sort is invalid.", 25);
                }

                $field = $field == "user" ? "1" : ($field == "account" ? "2" : $field);
                // There is special logic to show user and account as in the report so have to use the calculated column.

                $sortSQL[] = "$field $dir";
            }
        }
        $sortSQL = count($sortSQL) > 0 ? "order by " . implode(", ", $sortSQL) : "";

        $outerWhere = array();
        $innerWhere = array();

        if ($duration == "") {
            throw new exception("Duration is required.", 20);
        }

        $cuTzString = GetCreditUnionTimezone($dbh, $Cu);
        $cuTz = new DateTimeZone($cuTzString);

        switch($duration) {
            case "all":
                break;
            case "30":
            case "60":
            case "90":
                // In the case that we have a CU on the other side of the world where the date is different than UTC (database.)
                $today = new DateTime("now", $cuTz);
                $today->setTime(0,0); // Now that the date is converted to UTC, remove the time part.
                $today->modify("-$duration days"); // Now go back in time for the starting date.  No need to worry about the end date.
                $today = $today->format("Y-m-d");
                $innerWhere[] = "aut.auditdate >= '$today'";
                break;
            case "on":
                // Make it a bit more lenient than the frontend so that either the start or end date has to be required.

                if ($startOn == "" && $endOn == "") {
                    throw new exception("Invalid duration.", 21);
                }

                if ($startOn != "") {
                    $startOnDate = DateTime::createFromFormat("Y-m-d", $startOn, $cuTz);
                    if ($startOnDate === false) {
                        throw new exception("Start On is invalid.", 22);
                    }
                    $startOn = $startOnDate->format("Y-m-d");

                    $innerWhere[] = "aut.auditdate >= '$startOn'";
                }

                if ($endOn != "") {
                    $endOnDate = DateTime::createFromFormat("Y-m-d", $endOn, $cuTz);
                    if ($endOnDate === false) {
                        throw new exception("End On is invalid.", 27);
                    }
                    $endOnDate->setTime(0,0);
                    $endOnDate->modify("+1 days");
                    $endOn = $endOnDate->format("Y-m-d"); // Does not include this day.

                    $innerWhere[] = "aut.auditdate < '$endOn'";
                }

                break;
            default:
                throw new exception("Duration is invalid.", 23);
                break;
        }

        switch($showThis) {
            case "all":
                break;
            case "admin":
                $innerWhere[] = "aut.auditsrctype = 'A'";
                break;
            case "banking":
                $innerWhere[] = "aut.auditsrctype = 'U'";
                break;
            default:
                throw new exception ("Show option is invalid.", 28);
        }

        $auditString = "aut.auditrecbefore::text || aut.auditrecafter::text";
        $lowerAuditString = "lower($auditString)";

        if ($auditUser != "") {

            // Get the user_id so that we don't have to join in to the user table in the inner join and save time.
            $sql = "select user_id from ${Cu}user where lower(user_name) = '" . prep_save($auditUser, 50) . "'";
            $sth = db_query($sql, $dbh);
            if (!$sth) {
                throw new exception ("user query failed.", 26);
            }
            $userId = db_num_rows($sth) > 0 ? intval(db_fetch_row($sth, 0)[0]) : -1;

            $innerWhere[] = "(aut.user_id = $userId
                             or strpos($lowerAuditString, '\"user_name\":\"" . prep_save($auditUser, 50) . "') > 0)";
            $outerWhere[] = "t.userl ? '" . prep_save($auditUser, 50) . "'";
        }
        if ($account != "") {
            $innerWhere[] = "(aut.accountnumber = '" . prep_save($account, 50) . "'
                               or strpos($lowerAuditString, '\"accountnumber\":\"" . prep_save($account, 50) . "') > 0)";
            $outerWhere[] = "t.account ? '" . prep_save($account, 50) . "'";
        }
        if ($loggedInUser != "") {
            $innerWhere[] = "lower(aut.auditsrcuser_name) = '" . prep_save($loggedInUser, 50) . "'";
        }
        if ($actionType != "") {
            $innerWhere[] = "lower(aut.auditfulldesc) = '" . prep_save($actionType, 255) . "'";
        }

        // This part will make a cartesian product based on the value.
        // In the case of {"user":[{"user_name":"177701"}]}, there will be two parts: {"user":[{ AND :"177701"}]}.  This will cause two records in the resultset.
        $unnest = 'unnest(string_to_array(AUDIT, \'"VALUE"\'))';
        $unnestL = str_replace("AUDIT", $lowerAuditString, $unnest);
        $unnestU = str_replace("AUDIT", $auditString, $unnest);
        $userUnnest = str_replace("VALUE", "user_name", $unnestU);
        $userUnnestL = str_replace("VALUE", "user_name", $unnestL);
        $accountUnnest = str_replace("VALUE", "accountnumber", $unnestU);

        // For the string parts that start with :", remove that part and return the string before the second ".  Otherwise return null.
        // In the case of {"user":[{"user_name":"177701"}]}, the string is split on "user_name" so it starts with :" if it is valid.
        $agg = 'jsonb_agg(trim(case when strpos(COLUMN1, \':"\') = 1 then substr(replace(COLUMN1, \':"\', \'\'), 1, strpos(replace(COLUMN1, \':"\', \'\'), \'"\') - 1) else null end))';
        $agg .= ' || jsonb_agg(trim(COLUMN2))';
        $userAgg = str_replace("COLUMN2", "u.user_name", str_replace("COLUMN1", "au.userun", $agg));
        $userAggL = str_replace("COLUMN2", "lower(u.user_name)", str_replace("COLUMN1", "au.userunl", $agg));
        $accountAgg = str_replace("COLUMN2", "au.accountnumber", str_replace("COLUMN1", "au.accountun", $agg));

        // This part is for the display.
        // Coming in the results look like ["177701","177701",null,null,"616888","177701","616888"].
        // Going out the results look like 177701, 616888.  (Nulls are filtered out, results are deduplicated, and it has pretty display.)
        // Before, this part was done in PHP.  It is needed here because account or username could be filtered and there is server-side pagination.
        $selectCol = "select string_agg(val, ', ')
                      from (select val->>0, row_number() over (partition by lower(val->>0) order by val->>0 = lower(val->>0)) as rown
                      from jsonb_array_elements(COLUMN::jsonb) as t(val)
                      where val->>0 is not null and trim(val->>0) <> ''
                      order by 1) as u (val) where rown = 1";

        $selectUser = str_replace("COLUMN", "t.user", $selectCol);
        $selectAccount = str_replace("COLUMN", "t.account", $selectCol);

        $select = "select ($selectUser) as user, ($selectAccount) as account, t.date, t.actioncode, t.srcuser, t.before, t.after, t.script, t.action, t.accountnumber, t.rown ";

        $sql = "from (select au.date, au.actioncode, au.srcuser, au.before, au.after, au.script, au.action, au.accountnumber, row_number() over (order by au.date) as rown,
            $userAgg as user,
            $userAggL as userl,
            $accountAgg as account
            from (
                select aut.auditdate as date, aut.auditaction as actioncode, aut.auditsrcuser_name as srcuser, aut.auditrecbefore as before, aut.auditrecafter as after,
                aut.accountnumber, aut.auditsrccode_context as script, aut.auditfulldesc as action, aut.user_id,
                $userUnnest as userun, $userUnnestL as userunl, $accountUnnest as accountun from ${Cu}audituser aut "
                . ((count($innerWhere) > 0) ? "where " . implode(" and ", $innerWhere) : "") . "
            ) au
            left join ${Cu}user u on au.user_id = u.user_id
            group by au.date, au.actioncode, au.srcuser, au.before, au.after, au.script, au.action, au.accountnumber) t "
            . ((count($outerWhere) > 0) ? "where " . implode(" and ", $outerWhere) : "");

        $countSQL = "select count(*) $sql";
        $mainSQL = "set time zone '$cuTzString'; $select $sql $sortSQL $limitSQL;";

        $sth = db_query($countSQL, $dbh);
        if (!$sth) {
            throw new exception("Count query failed.", 12);
        }

        $count = intval(db_fetch_row($sth, 0)[0]);

        $sth = db_query($mainSQL, $dbh);
        if (!$sth) {
            throw new exception("Audit query failed.", 13);
        }

        $auditRecords = array();
        for($i = 0; $row = db_fetch_assoc($sth, $i); $i++) {
            $results = ParseUserAuditRow($row, $Cu, $dbh, $changedOnly);
            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
            $dateTime = new DateTime($row["date"], $cuTz);
            $row["date"] = $dateTime->format("Y-m-d H:i:s.u") . "Z";

            $auditRecords[] = $row;
        }

        $returnArray = array("status" => "000", "error" => "", "auditRecords" => array("total" => $count, "data" => $auditRecords));
    } catch(exception $e) {
        $returnArray = array("status" => $e->getCode(), "error" => $e->getMessage(), "auditRecords" => array("total" => 0, "data" => array()));
    }
    return $returnArray;
}

/**
 * function RemoveEmptyValues($string)
 * Removes strings from an array that are null or are empty.
 *
 * @param $string -- the string element to check.
 * @return boolean -- false if the element is removed from the array, true otherwise.
 */
function RemoveEmptyValues($string) {
    return isset($string) && trim($string) != "";
}

/**
 * function PrintPage($self, $readData)
 * This function will print out the popup for the audit.
 *
 * @param $self -- the URL of this page.
 * @param $readData -- the data needed for this page's load.
 */
function PrintPage($self, $readData) { ?>
    <script type="text/javascript">
    <?php // Library javascript functions
        getShowWaitFunctions(); ?>

    <?php
    /**
     * Globals (in javascript): this should be a short list
     */
    ?>
    var isInitial = true;
    var pageSize = 30;

    <?php
    /**
     * function AddDays(date, numberofDays)
     * @param Date $date -- the starting date
     * @param Int $numberofDays -- the number of days to add to the date.
     * @return Date $date -- new date from the previous date + the number of days.
     */
    ?>
    function AddDays(date, numberofDays) {
        var d = new Date(date);
        return new Date(d.getFullYear(), d.getMonth(), (d.getDate() + numberofDays));
    }

    var gridDataSource = null;
    var printDataSource = null;
    var isInitial = true;

    <?php
    /**
     * function InitDataSources()
     * Sets up the datasources.
     */
    ?>
    function InitDataSources() {
        var readConf = {
          url: "<?php echo $self; ?>&operation=readAudits",
          dataType: "json",
          type: "POST"
        };

        var GetDataFromSearch = function(data) {
              var duration = $("#durationDDL").data("kendoDropDownList").value();
              var startOn = $("#startingDatePicker").data("kendoDatePicker").value();
              var endOn = $("#endingDatePicker").data("kendoDatePicker").value();
              startOn = startOn == null || duration != "on" ? "" : kendo.toString(startOn, "yyyy-MM-dd");
              endOn = endOn == null || duration != "on" ? "" : kendo.toString(endOn, "yyyy-MM-dd");

              data.duration = duration;
              data.startOn = startOn;
              data.endOn = endOn;
              data.auditUser = $("[name='auditUser']").val().trim();
              data.loggedInUser = $("[name='loggedInUser']").val().trim();
              data.actionType = $("#actionDDL").data("kendoDropDownList").value();
              data.account = $("[name='account']").val().trim();
              data.showThis = $("#showDDL").data("kendoDropDownList").value();

              return data;
        };

        var gridParameterMap = function(data, type) {
              showWaitWindow();

              if (isInitial) { <?php // Start out with the default filter and sort. ?>
                  data.duration = "30";
                  data.showThis = "all";
                  isInitial = false;
              } else {
                  data = GetDataFromSearch(data);
              }

              <?php // Return this easier for me ?>
              data.sort = kendo.stringify(data.sort);

              <?php // Pagination ?>
              data.limit = data.pageSize;
              data.offset = data.skip;
              delete data.pageSize;
              delete data.skip;
              delete data.page;
              delete data.take;

              return data;
        };

        var printParameterMap = function(data, type) {
            showWaitWindow();

            data = GetDataFromSearch(data);

            <?php // Return this easier for me ?>
            data.sort = kendo.stringify(gridDataSource.sort());

            data.limit = 0;
            data.offset = 0;

            return data;
        };

        gridDataSource = new kendo.data.DataSource({
              transport: {
                  read: readConf,
                  parameterMap: gridParameterMap
              },
              schema: {
                model: {
                  id: "rown",
                  fields: {
                    rown: {type: "number"},
                    date: {type: "date"},
                    action: {type: "string"},
                    actioncode: {type: "string"},
                    details: {type: "odata"},
                    user: {type: "string"},
                    srcuser: {type: "string"},
                    script: {type: "string"},
                    checked: {type: "boolean"},
                    account: {type: "string"}
                  }
                },
                data: "data",
                total: "total",
                parse: function (data) {
                    hideWaitWindow();

                    if (data.status !== "000") {
                        $.homecuValidator.displayMessage(data.error, $.homecuValidator.settings.statusError);
                        return [];
                    } else {
                        return data.auditRecords;
                    }

                }
              },
              serverSorting: true,
              serverPaging: true,
              pageSize: pageSize,
              sortable: true,
              sort: {field: "date", dir: "desc"}
        });

        printDataSource = new kendo.data.DataSource({
              transport: {
                  read: readConf,
                  parameterMap: printParameterMap
              },
              schema: {
                model: {
                  id: "rown",
                  fields: {
                    rown: {type: "number"},
                    date: {type: "date"},
                    action: {type: "string"},
                    actioncode: {type: "string"},
                    details: {type: "odata"},
                    user: {type: "string"},
                    srcuser: {type: "string"},
                    script: {type: "string"},
                    checked: {type: "boolean"},
                    account: {type: "string"}
                  }
                },
                parse: function (data) {
                    hideWaitWindow();

                    if (data.status !== "000") {
                        $.homecuValidator.displayMessage(data.error, $.homecuValidator.settings.statusError);
                    } else {
                        PrintAudits(data.auditRecords.data);
                    }

                    $("#printDDL").data("kendoDropDownList").value("");
                    return []; <?php // Don't actually save anything in the dataSource. ?>
                }
              }
        });
    }

    <?php
    /**
     * function Init()
     * Initializes all controls.  This includes the search bar controls and the grid itself.
     */
    ?>
    function Init() {
        $.homecuValidator.setup({formValidate: "searchForm", formStatusField: "formValidateDiv"});
        if ("<?php echo $readData["status"]; ?>" !== "000") {
            $.homecuValidator.displayMessage("<?php echo $readData["error"]; ?>", $.homecuValidator.settings.statusError);
        } else {
            $.homecuValidator.setup({formValidate: "searchForm", formStatusField: "formValidateDiv"});

            InitDataSources();

            var grid = $("#auditGrid").kendoGrid({
                dataSource: gridDataSource,
                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: "user", title: "Banking User"},
                  {field: "account", title: "Account"},
                  {field: "srcuser", title: "Changed by"},
                  {field: "action", title: "Action Type"},

                ],
                noRecords: {
                  template: "<tr class='noRecordsDiv'><td colspan='4'>No Records Found</td></tr>"
                },
                detailTemplate: ReturnAuditDetailTemplate,
                scrollable: false,
                sortable: true,
                toolbar: $("#toolbarTemplate").html(),
                pageable: {
                    alwaysVisible: false <?php // Do not show pagination when there are 30 or less results. ?>
                }
          }).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"); ?>

          var printDDL = $("#printDDL").kendoDropDownList({
                dataSource: {
                    data: <?php echo HCU_JsonEncode($readData["data"]["prints"]); ?>,
                    filter: {field: "value", operator: "neq", value: "selected"}
                },
                dataTextField: "text",
                dataValueField: "value",
                change: function(e) {
                    switch(this.value()) {
                        case "":
                            break;
                        case "selected":
                            var shownData = $("#auditGrid").data("kendoGrid").dataSource.view();
                            var selectedData = $.grep(shownData, function(n, i) { return n.checked; });
                            PrintAudits(selectedData);
                            printDDL.value("");
                            break;
                        case "changed":
                            printDataSource.read({changedOnly: "Y"});
                            break;
                        case "all":
                            printDataSource.read();
                            break;
                    }
                }
          }).data("kendoDropDownList");

          $("#auditGrid").on("click", ".allCheckbox,.rowCheckbox", function() {
              var checked = $(this).prop("checked");
              var doFilter = false;
              if (checked && $(this).is(".rowCheckbox")) {
                  doFilter = false;
              } else {
                  var gridData = $("#auditGrid").data("kendoGrid");
                  var shownData = grid.dataSource.view();
                  var checkedData = $.grep(shownData, function(n, i) {
                      return n.checked;
                  });

                  doFilter = checkedData.length <= 0;
              }

              var ddl = $("#printDDL").data("kendoDropDownList");
              if (doFilter) {
                  ddl.dataSource.filter({field: "value", operator: "neq", value: "selected"});
              } else {
                  ddl.dataSource.filter(null);
              }
          });

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

        var actionDDL = $("#actionDDL").kendoDropDownList({
            dataSource: {
                data: <?php echo HCU_JsonEncode($readData["data"]["types"]); ?>
            },
            dataTextField: "text",
            dataValueField: "value"
        }).data("kendoDropDownList");

        var showDDL = $("#showDDL").kendoDropDownList({
            dataSource: {
                data: <?php echo HCU_JsonEncode($readData["data"]["shows"]); ?>
            },
            dataTextField: "text",
            dataValueField: "value"
        }).data("kendoDropDownList");

        $("#okayBtn").click(function() {
            if ($.homecuValidator.validate()) {
                grid.dataSource.query({page: 1, pageSize: pageSize, sort: grid.dataSource.sort()}); <?php // Make sure to reset the page number when the filter changes. ?>
            }
            return false;
        });

        $("[name='durationCheck']").click(function() {
            var thisElement = this;
            startingDatePicker.enable(($(thisElement).data("val") + "").trim() == "on");
        });

        var now = new Date();
        now.setHours(0, 0, 0, 0);
        var all = new Date();
        all.setHours(0, 0, 0, 0);
        all.setDate(1);
        all.setMonth((all.getMonth() - 1) % 12);
        all.setFullYear(all.getFullYear() - 1);

        var minx = new Date();
        minx.setHours(0, 0, 0, 0);
        var min30 = AddDays(minx, -30);
        var min60 = AddDays(minx, -60);
        var min90 = AddDays(minx, -90);

        var startingDatePicker = $("#startingDatePicker").kendoDatePicker({
            max: now,
            min: all,
            format: "MM/dd/yyyy", <?php // Add zeroes so that MTB looks okay. ?>
            change: function() {
                $("#durationDDL").data("kendoDropDownList").value("on"); <?php // Now doesn't align with the duration options. ?>
            }
        }).data("kendoDatePicker");

        var endingDatePicker = $("#endingDatePicker").kendoDatePicker({
            max: now,
            min: all,
            format: "MM/dd/yyyy", <?php // Add zeroes so that MTB looks okay. ?>
            change: function() {
                $("#durationDDL").data("kendoDropDownList").value("on"); <?php // Now doesn't align with the duration options. ?>
            }
        }).data("kendoDatePicker");

        $("#startingDatePicker").focus(function() { <?php // Clear out when selecting the date. ?>
            $(this).val(null);
            startingDatePicker.value(null);
        });

        $("#endingDatePicker").focus(function() { <?php // Clear out when selecting the date. ?>
            $(this).val(null);
            endingDatePicker.value(null);
        });

        $("#startingDatePicker").blur(function() {
            if ($(this).hasClass("k-invalid")) {
                $(startingDatePicker.wrapper).css("border", "1px solid #d80000");
            } else {
                $(startingDatePicker.wrapper).css("border", "inherit");
            }
        });

        $("#endingDatePicker").blur(function() {
            if ($(this).hasClass("k-invalid")) {
                $(endingDatePicker.wrapper).css("border", "1px solid #d80000");
            } else {
                $(endingDatePicker.wrapper).css("border", "inherit");
            }
        });

        var durationDDL = $("#durationDDL").kendoDropDownList({
            dataSource: {
                data: [
                    {text: "Last 30 days", value: "30"},
                    {text: "Last 60 days", value: "60"},
                    {text: "Last 90 days", value: "90"},
                    {text: "All Available", value: "all"},
                    {text: "Custom", value: "on"}
                ]
            },
            dataTextField: "text",
            dataValueField: "value",
            change: function() {
                switch(this.value()) {
                    case "custom": break; <?php // Nothing to do.  The date is whatever they want. ?>
                    case "all": startingDatePicker.value(all); endingDatePicker.value(now); break;
                    case "30": startingDatePicker.value(min30); endingDatePicker.value(now); break;
                    case "60": startingDatePicker.value(min60); endingDatePicker.value(now); break;
                    case "90": startingDatePicker.value(min90); endingDatePicker.value(now); break;
                }
            }
        }).data("kendoDropDownList");

        startingDatePicker.value(min30); <?php // Starting value: previous 30 days. ?>
        endingDatePicker.value(now); <?php // It ends today! ?>
    }

    var activeWindows = [];
    $(document).ready(function() {
        Init();
        <?php printClickOverlayEvent(); ?>
    });

      <?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;
      }

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

        for(var i = 0; i != gridData.length; i++) {
            var record = gridData[i];
            var rowTemplate = "<div class='tr nobottom'><span class='col-xs-4'>" + record.action + "</span><span class='col-xs-4'>"
                  + (record.user == null ? "&nbsp;" : record.user) + "</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("View User Events");
        $("#auditPrintForm").submit();
        $("#tempAudit").remove();
      }
    </script>
    <style>
        .auditFilterDiv > div {
            max-width: 950px;
        }
    </style>
    <script type="text/x-kendo-template" id="toolbarTemplate">
        <div id='printDDL' style='width:200px;'></div>
        <a role="button" class="k-button k-button-icontext k-grid-show" href="\#">Show Filter</a>
    </script>
    <div id="formValidateDiv" class="k-block k-error-colored formValidateDiv" style="display:none"></div>
    <div class="container-fluid">
        <form id="searchForm"><div class="well well-sm container-fluid auditFilterDiv" style="display:none;"><div>
            <div class="col-xs-12 hcuSpacer hcu-no-padding">
                <div class="container-fluid">
                    <div class="row hcuSpacer"><label class="col-xs-12 col-sm-5">Date Search Range</label>
                        <div class="col-xs-12 col-sm-7"><div id="durationDDL" class="hcu-all-100"></div></div>
                    </div>
                    <div class="row hcuSpacer"><label class="col-xs-12 col-sm-5">From</label>
                        <div class="col-xs-12 col-sm-7">
                            <input type="text" id="startingDatePicker" homecu-match="date" data-homecuCustomMatch-msg="Date is invalid."> &nbsp; To &nbsp;
                            <input type="text" id="endingDatePicker" homecu-match="date" data-homecuCustomMatch-msg="Date is invalid."
                                   homecu-dategtvalue="startingDatePicker" homecu-dategttype="field" data-homecuCustomDateGTValue-msg="Date range is invalid.">
                        </div>
                    </div>
                </div>
            </div>

            <div class="col-xs-12 hcuSpacer hcu-no-padding">
                <div class="container hcu-all-100">
                    <div class="row hcuSpacer">
                        <label class="col-xs-12 col-sm-5">Changes for Banking User</label>
                        <div class="col-xs-12 col-sm-7"><input type="text" class="k-input k-textbox hcu-all-100" name="auditUser"></div>
                    </div>
                    <div class="row hcuSpacer">
                        <label class="col-xs-12 col-sm-5">Changes for Account</label>
                        <div class="col-xs-12 col-sm-7"><input type="text" class="k-input k-textbox hcu-all-100" name="account"></div>
                    </div>
                    <div class="row hcuSpacer">
                        <label class="col-xs-12 col-sm-5">Changed by User</label>
                        <div class="col-xs-12 col-sm-7"><input type="text" class="k-input k-textbox hcu-all-100" name="loggedInUser"></div>
                    </div>
                    <div class="row hcuSpacer">
                        <label class="col-sm-5 col-xs-12">Action Type</label>
                        <div class="col-sm-7 col-xs-12"><div id="actionDDL" class="hcu-all-100"></div></div>
                    </div>
                    <div class="row hcuSpacer">
                        <label class="col-sm-5 col-xs-12">Show</label>
                        <div class="col-sm-7 col-xs-12"><div id="showDDL" class="hcu-all-100"></div></div>
                    </div>
                </div>
            </div>

            <div class="col-xs-12 hcuSpacer hcu-no-padding"><div class="container hcu-all-100"><div class="row"><div class="col-xs-12">
                <a href="#" class="k-button k-primary floatRight" id="okayBtn">Show</a>
            </div></div></div></div>
        </div></div></form>
        <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>
    <div id="previewWindow"></div>
<?php }