userSupportAlerts.prg

<?php
/**
 * @package UserSupport (Subpackage alert)
 * @author SPB
 *
 * This script is run when the user opens up the alert card in the user hub.  It cannot be run independently of that.
 */
$string = array("filter" => HCUFILTER_INPUT_STRING);
$parameters = array("a" => array("operation" => "", "payload" => "", "alerts" => ""));
HCU_ImportVars($parameters, "a", array("operation" => $string, "payload" => $string, "alerts" => $string));
extract($parameters["a"]);

$operation = !isset($operation) ? "" : trim($operation);
$payload = isset($payload) ? trim($payload) : "";
$alerts = isset($alerts) ? trim($alerts) : "";
$userId = null;
try { $userId = HCU_PayloadDecode($Cu, $payload); } catch(exception $e) {}
$userId = isset($userId) ? intval($userId["user_id"]) : null;

if ($operation != "") {
    if (isset($userId)) {
        switch($operation) {
            case "saveAlert":
                $returnArray = saveAlert($dbh, $Cu, $userId, $Cn, $alerts);
                break;
            default: // Won't get here
              $returnArray = array("error" => array("Operation not specified: '$operation'"), "record" => array());
        }
    } else {
        $returnArray = array("error" => array("No User Found"), "record" => array());
    }

    header('Content-type: application/json');
    print HCU_JsonEncode($returnArray);
} else {
    if (isset($userId)) {
        printPage("$menu_link?ft=$ft", $userId, readAlerts($dbh, $Cu, $userId), $payload);
    } else { ?>
        <div class='noUserFound'><div>No User Found</div></div>
    <?php }
}

/**
 * function alert($dbh, $Cu, $showSQL)
 *
 * Gets data for the alert tab.
 *
 * @param integer $dbh          Database handle
 * @param string $Cu            The current credit union
 * @param integer $userId       The banking user id
 *
 * @return array("sql" => array(), "error" => array(), "record" => array())
 */
function readAlerts($dbh, $Cu, $userId) {
    $errors = array();
    $data = Get_AlertsDetailed($dbh, $Cu, $userId, GetFlagsetValue("CU3_PREPEND_MBR_DESC")); // For admin, account number is always shown and unmasked.
    $errors = array_merge($errors, $data["errors"]);

    $records = array();

    // Get what I need
    foreach($data["data"] as $record) {
        $isCell = $record["emailtype"] == "W";
        $newRecord = array("id" => $record["id"], "alertDescription" => $record["type_name"], "accntDescription" => $record["description"],
        "alerted" => $record["lastalert"], "isCell" => $isCell, "destinationEmail" => "", "destinationPhone" => 0, "checked" => $record["alertstatus"] == 1,
            "accountNumber" => trim($record["accountnumber"]));

        if ($isCell) {
            $newRecord["destinationPhone"] = intval($record["notifyto"]);
        } else {
            $newRecord["destinationEmail"] = $record["notifyto"];
        }
        $records[] = $newRecord;
    }
    $returnArray = array("error" => $errors, "record" => $records);

    return $returnArray;
}

/**
 * function alertSave($dbh, $Cu, $showSQL, $loggedInUser)
 *
 * Save database call that happens when user changes a row checkbox on the alert screen.
 *
 * @param integer $dbh      Database handle
 * @param string $Cu        The current credit union
 * @param integer $userId       The banking user id
 * @param string $Cn        The Logged in User.
 * @param string $alerts    The alerts to save (JSON)
 *
 * @return array("sql" => array(), "error" => array(), "record" => array())
 */
function saveAlert($dbh, $Cu, $userId, $Cn, $alerts) {
    $parameters = array();
    $data = Update_AlertStatuses($dbh, $Cu, $userId, $alerts, $Cn, true);

    $errors = $data["errors"];
    return array("error" => $errors);
}

/**
 * function printPage($self, $userId, $readData)
 * This function will print out the popup for the audit.
 *
 * @param string $self -- the URL of this script
 * @param integer $userId -- the user id banking side
 * @param array $readData -- the data to read
 * @param string $payload -- the payload for the data calls to use if from the userhub.
 */
function printPage($self, $userId, $readData, $payload) { ?>
    <script type="text/javascript">
    //# sourceURL=alerts.js

    <?php
    /**
     * function dirtify(dirty, container)
     * This function sets the dirty flag after the cell is changed.
     *
     * @param Boolean dirty -- if there are changes or not.
     * @param HTMLElement container -- this is the cell. (TD tag)
     */
    ?>
    function dirtify(dirty, container) {
        if (dirty) {
            $(container).addClass("k-dirty-cell");
            $(container).prepend("<span class='k-dirty'></span>");
        } else {
            $(container).removeClass("k-dirty-cell");
            $(container).find(".k-dirty").remove();
        }
    }

    <?php
    /**
     * function init()
     * This initializes the whole shebang.
     */
    ?>
    function init() {
        $.homecuValidator.setup({formValidate: "userAlertsDiv", formStatusField: "formValidateAlertsDiv"});
        $("#externalTabWindow").data("preferredHeight", 450);
        var alertData = [];
        var alertGrid = $("#alertGrid").kendoGrid({
            dataSource: {
                transport: {
                    read: function(options) {
                        options.success(alertData);
                    }
                },
                schema: {
                    model: {
                        id: "id",
                        fields: {
                            id: {type: "number"},
                            alertDescription: {type: "string"},
                            accntDescription: {type: "string"},
                            alerted: {type: "date"},
                            isCell: {type: "boolean"},
                            destinationEmail: {type: "string"},
                            destinationPhone: {type: "number"},
                            // destinationCarrier: {type: "string"},
                            checked: {type: "boolean"},
                            originalChecked: {type: "boolean"},
                            accountNumber: {type: "string"}
                        }
                    }
                }
            },
            autoBind: false,
            scrollable: false,
            columns: [
                {headerTemplate: "<center>Enabled</center>", width: 45, field: "checked"},
                {title: "Sub-Account"},
                {title: "Description", field: "alertDescription"},
                {title: "Last Alert", field: "alerted"},
                {title: "Destination"}
            ],
            rowTemplate: "# var alertDate= kendo.toString(alerted, 'MM/dd/yyyy'); var alertTime= kendo.toString(alerted, 'HH:mm:ss'); #"
                + "<tr data-uid='#: uid #'>"
                + "<td><center> # if (checked) { # <div class='restriction allow hcu-all-100'><i class='fa fa-check'></i></div> # } else { #"
                + "<div class='restriction ban hcu-all-100'><i class='fa fa-ban'></i></div> # } # </center></td>"
                + "<td>#: accntDescription #</td><td>#: alertDescription #<span class='hidden-xs hidden-sm'> Alert</span></td>"
                + "<td># if (alerted == null) { # &nbsp; # } else { # #: alertDate #<span class='hidden-xs hidden-sm'> #: alertTime #</span># } #</td>"
                + "<td># if (isCell) { #<i class='fa fa-phone-square'></i>&nbsp;&nbsp;&nbsp;#: destinationPhone #  # } else { #"
                +   "<i class='fa fa-envelope'></i>&nbsp;&nbsp;&nbsp;#: destinationEmail # # } #</td></tr>",
            noRecords: {
                template: "<tr><td colspan='5'><span class='hcu-secondary'><span class='vsgSecondary'>No Records Found</span></span></td></tr>"
            }
            // @ #: destinationCarrier #
        }).data("kendoGrid");

        $(".userAlertsDiv .cancelBtn").click(function() {
            userSupportDoOnClose();
            return false;
        });

        $(".userAlertsDiv .updateBtn").click(function() {
            var gridData = $("#alertGrid").data("kendoGrid").dataSource.data();
            var changedAlerts = [];
            for(var i = 0; i != gridData.length; i++) {
                var value = gridData[i].checked;
                var id = gridData[i].id;
                if (value == gridData[i].originalChecked) {
                    continue;
                }
                changedAlerts.push({id: id, alertstatus: value ? "1" : "0"});
            }

            showWaitWindow();
            $.post("<?php echo $self; ?>&operation=saveAlert", {alerts: kendo.stringify(changedAlerts), payload: "<?php echo $payload; ?>"}, function(data) {
                hideWaitWindow();
                if (data.error.length > 0) {
                    $.homecuValidator.displayMessage(data.error, $.homecuValidator.settings.statusError );
                } else {
                    for(var i = 0; i != gridData.length; i++) {
                        gridData[i].dirty = false;
                        gridData[i].originalChecked = gridData[i].checked;
                    }
                    postPostPostPost();
                }
            });
            return false;
        });

        $("#alertGrid").on("click", ".restriction.allow", function() {
            var td = $(this).closest("td");
            $(td).html("<center><div class='restriction ban hcu-all-100'><i class='fa fa-ban'></i></div></center>");
            var tr = $(td).closest("tr");
            var dataItem = alertGrid.dataItem(tr);
            dataItem.dirty = true;
            dataItem.checked = false;
            dirtify(dataItem.checked != dataItem.originalChecked, td);
            return false;
        });

        $("#alertGrid").on("click", ".restriction.ban", function() {
            var td = $(this).closest("td");
            $(td).html("<center><div class='restriction allow hcu-all-100'><i class='fa fa-check'></i></div></center>");
            var tr = $(td).closest("tr");
            var dataItem = alertGrid.dataItem(tr);
            dataItem.dirty = true;
            dataItem.checked = true;

            dirtify(dataItem.checked != dataItem.originalChecked, td);
            return false;
        });

        $("#alertGrid").on("click", "tbody tr", function(e) {
            $(this).find(".restriction").click();
        });

        var data= <?php echo HCU_JsonEncode($readData); ?>;
        if (data.error.length > 0) {
            $.homecuValidator.displayMessage(data.error, $.homecuValidator.settings.statusError );
        } else {
            for(var i = 0; i != data.record.length; i++) {
                var record = data.record[i];
                record.kendoIndex = i + 1;
                record.originalChecked = record.checked;
            }
            alertData = new kendo.data.ObservableArray(data.record);
            alertGrid.dataSource.read();
            $("#alertGrid").css({maxHeight: 300, overflowY: "auto"});
        }
    }

    <?php
    /**
     * function postPostPostPost()
     * This obviously happens after everything else.
     */
    ?>
    function postPostPostPost() {
        $("#externalTabWindow").data("isClosing", true);
        $("#externalTabWindow").data("kendoWindow").close();
        $("#externalTabWindow").data("isClosing", false);
    }

    <?php
    /**
     * function userSupportDoOnClose()
     * Whew! I saved a couple of lines.  No, this is needed as it is the hook function from the userSupportHead script.
     */
    ?>
    function userSupportDoOnClose() {
      potentiallyCancelChanges();
      $("#externalTabWindow").data("shouldClose", false);
    }

    <?php
    /**
     * function potentiallyCancelChanges()
     * This displays the discard changes dialog on close if there are changes made.
     */
    ?>
    function potentiallyCancelChanges() {
        if ($.grep($("#alertGrid").data("kendoGrid").dataSource.data(), function(n,i) { return n.originalChecked != n.checked; }).length == 0) {
            postPostPostPost();
        } else {
            var discardChangesDialog= $("#discardChangesDialog").data("kendoDialog");
            if (discardChangesDialog == null) {
              discardChangesDialog = $("<div id='discardChangesDialog'></div>").appendTo("body").kendoDialog({
                title: "Discard Changes",
                content: "<p>Changes have been made to this user's alerts.</p><p>Do you wish to discard your changes?</p>",
                actions: [
                  {text: "No"},
                  {text: "Yes", primary: true, action: function() {
                    postPostPostPost();
                  }}
                ],
                visible: false,
                open: function() {
                  if (window.activeWindows != null)
                    window.activeWindows.push(this);
                },
                close: function() {
                  if (window.activeWindows != null)
                    window.activeWindows.pop();
                }
              }).data("kendoDialog");
            }
            discardChangesDialog.open();
        }
    }

    init();
    </script>

    <div class="container userAlertsDiv vsgPrimary hcu-template hcu-all-100" id="userAlertsDiv">
        <div class="row">
            <div id="formValidateAlertsDiv" class="k-block k-error-colored formValidateDiv" style="display:none;"></div>
        </div>
        <div class="hcu-secondary">
            <div class="row small vsgSecondary hcu-note">
                Click on a row to change enabled status.
            </div>
        </div>
        <div class="row">
            <div id="alertGrid" class="hcu-all-100"></div>
        </div>
        <div class="hcu-edit-buttons k-state-default row">
            <a class="cancelBtn" href="#">Cancel</a>
            &nbsp;&nbsp;&nbsp;
            <a class="updateBtn k-button k-primary" href="#"><i class="fa fa-check"></i>Update</a>
        </div>
    </div>
<?php }