userSupportScheduledTransactions.prg

<?php
/**
 * @package userSupportRepeatingTransfers
 * @author SPB
 *
 * This script is run when the user opens up the delete card in the user hub.  It cannot be run independently of that.  You can activate inactive scheduled transfers.
 *  Or you can skip or cancel active transfers.
 */

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

$operation = !isset($operation) ? "" : trim($operation);
$payload = !isset($payload) ? "" : trim($payload);
$changeList = !isset($changeList) ? "" : trim($changeList);

// Need to translate to translate list.
require_once("$sharedLibrary/hcuTranslate.i");
require_once("$bankingLibrary/hcuTransferScheduled.i");
$MC = new hcu_talk_base("en_US");

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

if ($operation != "") {
    if (isset($userId)) {
        switch($operation) {
            case "cancelTrans":
                $returnArray = SetStatusTrans($dbh, $Cu, $userId, $changeList, $MC, true);
                break;
            case "activateTrans":
                $returnArray = SetStatusTrans($dbh, $Cu, $userId, $changeList, $MC, false);
                break;
            case "skipTrans":
                $returnArray = SkipTrans($dbh, $Cu, $userId, $changeList, $MC);
                break;
            default: // Won't get here
              $returnArray = array("error" => array("Operation not specified: '$operation'"), "record" => array());
        }
    } else {
        $returnArray = array("error" => "No User Found", "record" => array(), "sql" => array());
    }

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

/**
 * function SetStatusTrans($dbh, $Cu, $userId, $changeList, $MC, $isCancel = true)
 * Data call to update the status to "A" for active or "I" for inactive.
 *
 * @param $dbh -- the database connection
 * @param $Cu -- the credit union
 * @param $userId -- the banking user
 * @param $changeList -- a JSON list of ids to change
 * @param $MC -- the dictionary (since I am using a DDL from the banking side, I need this to translate into English.)
 * @param $isCancel -- If the operation is to cancel records or to activate records
 *
 * @return "status" -- "000" if successful, nonzero otherwise
 * @return "error" -- "" if successful, nonempty otherwise
 * @return "repeatingTransfers" -- a list of repeating transfers
 * @return "info" -- if successful, give a success message
 */
function SetStatusTrans($dbh, $Cu, $userId, $changeList, $MC, $isCancel = true) {
    try {
        if ($changeList == "") {
            throw new exception("Nothing to change.", 301);
        }
        $changeList = HCU_JsonDecode($changeList);
        if (!is_array($changeList)) {
            throw new exception("Change List is malformed.", 302);
        }
        if (count($changeList) == 0) {
            throw new exception("Nothing to change.", 304);
        }
        foreach($changeList as $changeListId) {
            if (!is_integer($changeListId)) {
                throw new exception("Change List is malformed.", 303);
            }
        }

        // SQL to check that records are valid for skipping.
        $sql = "select id, approved_status, status from cu_scheduledtxn where cu = '$Cu' and user_id = $userId and id in (" . implode(", ", $changeList) . ")";
        $sth = db_query($sql, $dbh);
        if (!$sth) {
            throw new exception("Select query failed.", 305);
        }
        $updateList = array();
        for($i = 0; $row = db_fetch_assoc($sth, $i); $i++) {
            if ($isCancel && $row["status"] != "A") {
                throw new exception("Cancel can only happen on active records.", 306);
            }
            if (!$isCancel && $row["status"] == "A") {
                throw new exception("Reactivate can only happen on inactive records.", 307);
            }
            if ($row["approved_status"] != 10) {
                throw new exception(($isCancel ? "Cancel" : "Reactivate") . " can only happen on approved records.", 308);
            }
            $updateList[] = $row["id"];
        }
        if (count($updateList) != count($changeList)) { // Some ids do not exist or are attached to the wrong user/Cu.
            throw new exception("Some ids in the changeList are invalid.", 309);
        }
        unset($changeList);

        $sql = "update cu_scheduledtxn set status= '" . ($isCancel ? "I" : "A") . "' where id in (" . implode(", ", $updateList) . ") and cu = '$Cu' and user_id = $userId";
        $sth = db_query($sql, $dbh);
        if (!$sth) {
            throw new exception("Update query failed.", 310);
        }

        $readResults = ReadTrans($dbh, $Cu, $userId, $MC);

        if ($readResults["status"] != "000") {
            throw new exception($readResults["error"][0], $readResults["code"]);
        }
        $repeatingTransfers = $readResults["repeatingTransfers"];
        unset($readResults);

        $returnArray = array("status" => "000", "error" => "", "repeatingTransfers" => $repeatingTransfers,
                             "info" => (count($updateList) == 1 ? "Transfer was " : "Transfers were ") . ($isCancel ? "cancelled" : "reactivated") . " successfully.");
    } catch(exception $e) {
        $returnArray = array("status" => $e->getCode(), "error" => $e->getMessage());
    }
    return $returnArray;
}

/**
 * function PrintPage($self, $readData, $payload)
 * This function will print out the repeating transfers card.
 *
 * @param $self -- the URL of this script
 * @param $readData -- the results from the read function.  (@see the ReadTrans function.)
 * @param $payload -- the payload to send the data calls
 */
function PrintPage($self, $readData, $payload) { ?>
    <script type="text/javascript">
    //# sourceURL=repeatingTransfers.js

    <?php
    /**
     * function Init()
     * This will define the scheduled transfers grid and any click events that are also necessary.
     */
    ?>
    function Init() {
        $.homecuValidator.setup({formValidate: "repeatingDiv", formStatusField: "formValidateDiv"});
        $("#externalTabWindow").data("preferredHeight", "auto");

        $(".repeatingDiv").on("click", ".closeBtn", function() {
            postPostPostPost();
            return false;
        });

        var dateTemplateTemplate = kendo.template("\\# if (#: column # == null) { \\# &nbsp; \\# } else { \\# \\#= kendo.toString(#: column #, 'MM/dd/yyyy') \\# \\# } \\#");

        window.repeatingTransfers = [];
        var repeatingTransfersGrid = $("#repeatingTransfersGrid").kendoGrid({
            dataSource: {
                transport: {
                    read: function(options) {
                        options.success(window.repeatingTransfers);
                    }
                },
                schema: {
                    model: {
                        id: "id",
                        fields: {
                            id: {type: "number"},
                            feature_code: {type: "string"},
                            feature: {type: "string"},
                            create_date: {type: "date"},
                            next_trigger_date: {type: "date"},
                            start_date: {type: "date"},
                            end_date: {type: "date"},
                            status: {type: "string"},
                            statusText: {type: "string"},
                            interval: {type: "string"},
                            intervalText: {type: "string"},
                            details: {type: "string"},
                            checked: {type: "boolean", defaultValue: false}
                        }
                    }
                }
            },
            autoBind: false,
            columns: [
                {headerTemplate: "<input type='checkbox' class='allCheckbox'>", width: 40},
                {field: "feature", title: "Feature", width: 200},
                {field: "details", title: "Details", width: 300},
                {field: "create_date", title: "Created", width: 50, headerAttributes: {"class": "hidden-xs hidden-sm"}},
                {field: "start_date", title: "Range", width: 150, headerAttributes: {"class": "hidden-xs hidden-sm hidden-md"}},
                {field: "next_trigger_date", title: "Next Trigger Date", width: 50},
                {field: "intervalText", title: "Interval", width: 200, headerAttributes: {"class": "hidden-xs hidden-sm"}},
                {field: "statusText", title: "Status", width: 100, attributes: {"class": "statusTD"}}
            ],
            sortable: true,
            toolbar: "<div id='actionDDL'></div>",
            rowTemplate: $("#rowTemplate").html(),
            scrollable: false
        }).data("kendoGrid");

        var actionDDL = $("#actionDDL").kendoDropDownList({
            dataSource: {
                data: [{value: "", text: "Action"}]
            },
            dataTextField: "text",
            dataValueField: "value",
            change: function(e) {
                var text = this.text();
                if (text != "") {
                    OpenConfirm(text.toLowerCase(), this.value());
                }
            }
        }).data("kendoDropDownList");

        actionDDL.select(0);
        actionDDL.enable(false);

        var data = <?php echo HCU_JsonEncode($readData); ?>;
        if (data.error.length > 0) {
            $.homecuValidator.displayMessage(data.error, $.homecuValidator.settings.statusError );
        } else {
            window.repeatingTransfers = new kendo.data.ObservableArray(data.repeatingTransfers);
            repeatingTransfersGrid.dataSource.read();
        }

        <?php printCheckboxEvents("#repeatingTransfersGrid"); ?>

        var inThisEvent = false;
        $("#repeatingTransfersGrid").on("click", ".allCheckbox, .rowCheckbox", function() {
            if (inThisEvent) { <?php // Prevent this logic from being executed more than once.  ?>
                return;
            }
            inThisEvent = true;
            actionDDL.select(0);

            var checkedList = $("#repeatingTransfersGrid .rowCheckbox:checked");

            if ($("#repeatingTransfersGrid .rowCheckbox:checked").length == 0) {
                actionDDL.enable(false);
            } else {
                var activate = false;
                var cancel = false;
                var skip = false;
                var hasNull = false;

                $(checkedList).each(function() {

                    var record = repeatingTransfersGrid.dataItem($(this).closest("tr"));

                    activate = activate || record.status == "I";
                    cancel = cancel || record.status == "A";
                    skip = skip || record.status == "A";
                    hasNull = hasNull || record.next_trigger_date == null;

                    if (activate && cancel && skip && hasNull) {
                        return false; <?php // No need to continue. ?>
                    }

                });

                if (activate && cancel) { <?php // Records are there for both so neither action is true. ?>
                    actionDDL.enable(false);
                } else {
                    actionDDL.enable(true);
                    var ddlData = [{value: "", text: "Action"}];
                    if (activate) {
                        ddlData.push({value: "activateTrans", text: "Activate"});
                    }
                    if (cancel) {
                        ddlData.push({value: "cancelTrans", text: "Cancel"});
                    }
                    if (skip && !hasNull) {
                        ddlData.push({value: "skipTrans", text: "Skip"});
                    }

                    actionDDL.dataSource.data(ddlData);
                    actionDDL.select(0);
                }
            }

            inThisEvent = false;
        });

        $("#repeatingTransfersGrid").on("click", "tbody tr", function(e) {
            if ($(e.target).is(".rowCheckbox")) {
                return;
            }

            $(this).find(".rowCheckbox").click();
        });

        $("#repeatingTransfersGrid").find("colgroup").each(function() {
            $(this).find("col:eq(4)").addClass("hidden-xs hidden-sm hidden-md");
            $(this).find("col:eq(3), col:eq(6)").addClass("hidden-xs hidden-sm"); <?php // hide details, created, and interval on iPad. ?>
        });

        $("#repeatingTransfersGrid thead tr").addClass("showClickable");
    }

    <?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 OpenConfirm()
     * This opens up the confirmation message.
     */
    ?>
    function OpenConfirm(actionText, actionValue) {
        var confirmDialog = $("#confirmActionDialog").data("kendoDialog");

        if (confirmDialog == null) {
            var content = "Do you wish to continue?";
            confirmDialog = $("<div id='confirmActionDialog'></div>").appendTo("body").kendoDialog({
                content: content,
                actions: [{text: "No", action: function() {
                    confirmDialog.close();
                    var actionDDL = $("#actionDDL").data("kendoDropDownList");
                    actionDDL.value("");
                    return false;
                }}, {text: "Yes", primary: true, action: function() {
                    confirmDialog.close();

                    var actionValue = $("#confirmActionDialog").data("actionValue");
                    var repeatingTransfersGrid = $("#repeatingTransfersGrid").data("kendoGrid");
                    var actionDDL = $("#actionDDL").data("kendoDropDownList");

                    var gridData = repeatingTransfersGrid.dataSource.data();
                    var changeList = [];
                    for(var i = 0, length = gridData.length; i != length; i++) {
                        var record = gridData[i];
                        if (record.checked) {
                            changeList.push(record.id);
                        }
                    }
                    var parameters = {changeList: kendo.stringify(changeList), payload: "<?php echo $payload; ?>"};
                    showWaitWindow();
                    $.post("<?php echo $self; ?>&operation=" + actionValue, parameters, function(data) {
                        hideWaitWindow();
                        if (data.error.length > 0) {
                            $.homecuValidator.displayMessage(data.error, $.homecuValidator.settings.statusError );
                        } else {
                            if (data.info != "") {
                                $.homecuValidator.displayMessage(data.info, $.homecuValidator.settings.statusInfo );
                            }

                            repeatingTransfers = new kendo.data.ObservableArray(data.repeatingTransfers);
                            repeatingTransfersGrid.dataSource.read();

                            actionDDL.value("");
                            actionDDL.enable(false);
                            $("#repeatingTransfersGrid .allCheckbox").prop("checked", false);
                        }
                    });
                    return false;
                }}],
                visible: false,
                open: function() {
                    if (window.activeWindows != null) {
                        window.activeWindows.push(this);
                    }
                },
                close: function() {
                    if (window.activeWindows != null) {
                        window.activeWindows.pop();
                    }
                },
                visible: false,
                modal: true,
                minWidth: 300
            }).data("kendoDialog");
        }

        $("#confirmActionDialog").data("actionText", actionText);
        $("#confirmActionDialog").data("actionValue", actionValue);

        var count = 0;
        var gridData = $("#repeatingTransfersGrid").data("kendoGrid").dataSource.data();
        for(var i = 0, length = gridData.length; i != length; i++) {
            if (gridData[i].checked) {
                count++;
            }
        }

        var contents = "<p>You are about to " + actionText + " " + count + " scheduled transaction" + (count == 1 ? "" : "s") + "." + (actionText == "skip" ? "  This cannot be undone." : "")
        + "</p><p>Are you sure you want to " + actionText + (count == 1 ? " this record" : " these records") + "?</p>";
        confirmDialog.title("Confirm "+ actionText[0].toUpperCase() + actionText.slice(1)).content(contents).open();
    }

    Init();

    </script>

    <?php
    /**
     * <script id="rowTemplate" ...
     * This is the script for the kendoGrid's rowTemplate.  The main addition is the removal of some columns on the smaller sizes.
     */
    ?>
    <script id="rowTemplate" type="text/x-kendo-template">
        <tr uid='#= uid #' class="showClickable">
            <td class="checkboxTD"><input type='checkbox' class='rowCheckbox'></td>
            <td># if (feature == '') { # &nbsp; # } else { # #: feature # # } #</td>
            <td>#= details #</td> <?php // Put together on the backend depending on the txnData according to feature. Uses htmlentities.  May add a <br>. ?>
            <td class="hidden-xs hidden-sm"># if (create_date == null) { # &nbsp; # } else { # #: kendo.toString(create_date, "d") # # } #</td>
            <td class="hidden-xs hidden-sm hidden-md"><b>From</b> # if (start_date == null) { # &nbsp; # } else { # #: kendo.toString(start_date, "d") # # } #
                # if (end_date != null) { # <br><b>To</b> #: kendo.toString(end_date, "d") # # } #</td>
            <td># if (next_trigger_date == null) { # &nbsp; # } else { # #: kendo.toString(next_trigger_date, "d") # # } #</td>
            <td class="hidden-xs hidden-sm"># if (intervalText == '') { # &nbsp; # } else { # #: intervalText # # } #</td>
            <td class="restriction # if (status == 'A') { # allow # } else { # ban # } #"># if (statusText == '') { # &nbsp; # } else { # #: statusText # # } #</td>
        </tr>
    </script>

    <div class="container hcu-all-100 repeatingDiv vsgPrimary hcu-template" id="repeatingDiv">
        <div class="row">
            <div class="col-xs-12 hcu-secondary">
                <div class="small vsgSecondary">Click on a row to select/unselect.  Actions are skip and cancel for active records.
                    For inactive records, there is an option to reactivate.<span class="hidden-md hidden-lg">  Rotate to see more columns.</span></div>
            </div>
        </div>
        <div class="row notificationRow hcuSpacer"></div>
        <div class="row">
            <div id="formValidateDiv" class="k-block k-error-colored formValidateDiv" style="display:none"></div>
        </div>
        <div class="row">
            <div class="hcu-all-100" id="repeatingTransfersGrid"></div>
        </div>
        <div class="hcu-edit-buttons k-state-default row">
            <a class="closeBtn k-button k-primary" href="#"><i class="fa fa-check"></i>Close</a>
        </div>
    </div>
<?php }