welcome.prg

<?php
/**
 * @package welcome.prg -- Shows survey questions and messages from HomeCU as well as after hour support and special email notification for the CU.
 * This replaces welcome.prg, cu_notify.prg, ContMaint.prg
 */
$main = $menu_link;
$self = "$menu_link?ft=$ft";

$parameters = array("a" => array("email" => ""));
$string = array("filter" => FILTER_DEFAULT);
HCU_ImportVars($parameters, "a", array("email" => $string));
extract($parameters["a"]); // dms_import doesn't work anymore because this isn't in global scope anymore.

require_once("$sharedLibrary/sFeatureMnu.i");
require_once(dirname(__FILE__) . "/cu_notify.data"); // The update function is used here.

if ($operation != "") {
    switch($operation) {
        case "readWelcome":
            $returnArray = readWelcome($dbh, $Cu, $live);
            break;
        case "updateSpecialNotification":
            $returnArray = UpdateEmailNotify($dbh, $Cu, $Cn, "hcunotice", $email, true);
            break;
        default: $returnArray = array("sql" => array(), "error" => array("Operation not recognized: $operation."), "record" => array());
        break;
    }

    header('Content-type: application/json');
    print HCU_JsonEncode($returnArray);
} else {
    printWelcomePage($self, $main, $live);
}

/**
 * function readWelcome ($dbh, $Cu, $live)
 * Gets data for the welcome screen which includes the special contact email, the after hours support, and any HomeCU notes.
 *
 * @param integer $dbh -- the database connection
 * @param string $Cu -- the credit union
 * @param string $live -- if the credit union is live or batch
 * @return array --
 *      $error -- one or zero errors encountered
 *      $sql -- the SQLs used
 *      $messages -- the HomeCU notes found
 *      $afterHoursSupport -- the after hours support grid data
 *      $specialNotificationEmail -- the email for special notifications
 */
function readWelcome ($dbh, $Cu, $live) {
    $returnArray = array();

    try {
        $sql = "select cu, email from cuadmnotify where role = 'hcunotice' and cu = '$Cu' limit 1";
        $sth = db_query($sql, $dbh);
        if (!$sth) {
            throw new exception("Special notification email query failed.", 1);
        }
        $row = db_fetch_assoc($sth, 0);
        $specialNotificationEmail = trim($row["email"]);

        $liveSQL = isset($live) ? ($live == "Y" ? "L" : "B") : "";
        $liveSQL = $liveSQL == "" ? "" : " and (livebatch = 'A' or livebatch = '$liveSQL') ";
        $sql = "select id as mid, active_date, message, subject, active_date >= now() - interval '30 days' as important from cuadmin_message where (expires_on is null or now() < expires_on)
                $liveSQL and active_date <= now() order by active_date desc, id desc, subject";
        $sth = db_query($sql, $dbh);
        if (!$sth) {
            throw new exception("cuadmin message query failed.", 2);
        }
        $messages = array();
        for($i = 0; $row = db_fetch_assoc($sth, $i); $i++) {
            $row["important"] = trim($row["important"]) == "t";
            $row["subject"] = strtr(hcu_displayHtml($row['subject'], ENT_QUOTES), array("\\r" => "\r", "\\n" => "\n"));
            $row["message"] = strtr(trim($row['message']), array("\\r" => "\r", "\\n" => "\n"));
            $messages[] = $row;
        }

        $afterHoursSupport = readAfterHours($dbh, $Cu, false);

        // Check if the temporary email is still used in the from emails for cu notify.  If it is, then show a popup message.
        $results = ReadEmailNotify($dbh, $Cu);
        if ($results ["status"] != "000") {
            throw new exception ("Read email notify failed.", 3);
        }
        $nagPlease = false;
        foreach($results["data"]["gridData"] as $record) {

            // It is sorted by the from email address at first.  Do not care about the other emails.
            if (!$record["single"]) {
                break;
            }

            if (trim(strtolower($record["email"])) == GetTemporaryEmail()) {
                $nagPlease = true; // Oh my gosh!  There is a temporary email left!  Must nag the credit union then!
                break;
            }
        }


    } catch(exception $e) {
        return array("error" => array($e->getMessage()), "messages" => array(), "afterHoursSupport" => array(), "specialNotificationEmail" => "", "nagPlease" => false);
    }
    return array("error" => array(), "messages" => $messages, "afterHoursSupport" => $afterHoursSupport, "specialNotificationEmail" => $specialNotificationEmail, "nagPlease" => $nagPlease);
}

/**
 * function readAfterHours($dbh, &$sqls, $Cu, $editable)
 * Gets the after hour support data
 *
 * @param integer $dbh -- the database connection
 * @param array $sqls -- the array to append the SQLs to
 * @param string $Cu -- the credit union
 * @param boolean $editable -- if true, we need an index apparently
 * @return array -- the data for the after hours support grid
 * @throws "phone is invalid" or "After Hours Support query failed!"
 */
function readAfterHours($dbh, $Cu, $editable) {
    $sql = "select contactid, priority, name, phone, comments from cucontact where user_name = '" . strtolower($Cu) . "' order by user_name, priority";
    $sth = db_query($sql, $dbh);
    if (!$sth) {
        throw new exception("After Hours Support query failed.", 3);
    }
    $afterHoursSupport = array();
    for($i = 0; $row = db_fetch_assoc($sth, $i); $i++) {
        $row["phone"] = preg_replace('/[^0-9]*/', "", $row["phone"]);
        if ($editable) {
            $row["pid"] = $i + 1;
        }
        $length = strlen($row["phone"]);
        $row["phone"] = $length == 10 ? "(" . substr($row["phone"], 0, 3) . ") " . substr($row["phone"], 3, 3) . "-" . substr($row["phone"], 6)
            : ($length == 7 ? substr($row["phone"], 0, 3) . "-" . substr($row["phone"], 3) : "");

        if (trim($row["phone"]) == "") {
            throw new exception("Phone is invalid.", 4);
        }
        $row["name"] = trim($row["name"]);
        $row["comments"] = trim($row["comments"]);
        $afterHoursSupport[] = $row;
    }
    return $afterHoursSupport;
}

/**
 * function printWelcomePage($self, $main, $live)
 * Prints out the welcome page
 *
 * @param string $self -- the URL of this script
 * @param string $main -- the URL to the main script
 * @param string $live -- if the Credit Union is live or batch (If live, the after hours support is shown.  Otherwise it is not included in the page.)
 */
function printWelcomePage($self, $main, $live) {
    ?>

    <style type="text/css">
    <?php printTopCenterCss(300); ?>
    </style>

    <script type="text/javascript">
        <?php getShowWaitFunctions(); ?>

        var live = "<?php echo $live; ?>";
        var activeWindows = [];
        var action = "";

        var admDataSource = null;
        var admDataWelcomeAHS = null;
        var admDataWelcomeMSG = null;
        var admDataWelcomeSNE = null;

        var admActionAddSpecialEmail = null;
        var admActionEditSpecialEmail = null;
        var admActionSaveSpecialEmail = null;
        var admActionCancelSpecialEmail = null;
        var admInputSpecialEmail = null;

        var admViewWhatsNew = null;
        var admViewSpecialEmail = null;
        var admViewSpecialEmailPopup = null;
        var admViewSpecialEmailValidator = null;
        var admViewAfterHours = null;
        var admViewMessagesDialog = null;

        var admTemplateWhatsNew = null;
        var admTemplateSpecialEmail = null;
        var admTemplateSpecialEmailPopup = null;
        var admTemplateMessagesPopup = null;

        function SaveSpecialEmail(e) {
            var emailValue = admDataWelcomeSNE.email;
            var emailNew = admInputSpecialEmail.val();

            if (emailValue != emailNew) {
                if ($.homecuValidator.validate()) {
                    var updateEmailRequest = {
                        operation: "updateSpecialNotification",
                        email: emailNew
                    };

                    admDataSource.transport.options.read.type = "POST";
                    admDataSource.read(updateEmailRequest);
                    admViewSpecialEmailPopup.close();
                }
            } else {
                admViewSpecialEmailPopup.close();
            }
        }

        function OpenSpecialEmailPopup() {
            admViewSpecialEmailPopup.center();
            admViewSpecialEmailPopup.open();
        }

        <?php
        /**
         * function BuildViewNagPlease()
         * This creates and pops up a dialog to nag the CU when the temporary email is still set for one of the from emails in the CU Email Notify screen.
         */
        ?>
        function BuildViewNagPlease() {
            var address = "main.prg?ft=46";
            var template = "";
                template += "<p>There are emails that have not been verified.  Please go to the <a href='" + address + "'>CU Email Notifications</a> screen ";
                template += "and verify the email(s) you would like to use for sending Digital Banking emails to users.</p>";
                template += "<p>Once the email is verified, select the email form the list where you see <?php echo GetTemporaryEmail(); ?>.";

            var nagPleaseDialog = $("<div id='nagPleaseDialog'></div>").appendTo("body").kendoDialog({
                title: "Unverified Feature Emails",
                content: template,
                actions: [
                    {text: "Okay", primary: true}
                ],
                modal: true,
                visible: false,
                maxWidth: 700 <?php // Make sure that the dialog does not get too wide. ?>
            }).data("kendoDialog");

            nagPleaseDialog.open().center();
        }

        function BuildViewAfterHours() {
            admViewAfterHours = $("#viewAfterHours").kendoGrid({
                    dataSource: {
                        data: admDataWelcomeAHS,
                        schema: {
                            model: {
                                id: "priority",
                                fields: {
                                    priority: {type: "number"},
                                    name: {type: "string"},
                                    phone: {type: "string"},
                                    comments: {type: "string"}
                                }
                            }
                        },
                        filter: {field: "priority", operator: "le", value: 3} <?php // Start with the top three options. ?>
                    },
                    columns: [
                        {field: "priority", title: "Priority"},
                        {field: "name", title: "Name"},
                        {field: "phone", title: "Phone"},
                        {field: "comments", title: "Comments"}
                    ]
                }).data("kendoGrid");
        }

        function BuildViewSpecialEmailPopup() {

            admViewSpecialEmailPopup = $("#viewSpecialEmailPopup").kendoWindow({
                title: "Special Email Notification",
                width: "400px",
                modal: true,
                visible: false,
                resizable: false,
                content: {
                    template: admTemplateSpecialEmailPopup
                },
                open: function(e) {
                    // on open set validator to use popup status bar
                    $.homecuValidator.setup({
                        formStatusField: 'viewSpecialEmailStatus',
                        formValidate:'viewSpecialEmailPopup'
                    });

                    this.wrapper.css({ top: 100 });
                    admInputSpecialEmail.val(admDataWelcomeSNE.email);
                    activeWindows.push(this);
                },
                close: function(e) {

                    // on close reset validator to use screen status bar
                    $.homecuValidator.setup({
                        formStatusField: 'admInfoBar',
                        formValidate:'welcomeDiv'
                    });

                    admInputSpecialEmail.val("");
                    activeWindows.pop();
                }
            }).data("kendoWindow");
            admActionSaveSpecialEmail = $("#viewSpecialEmailPopup #btnSpecialEmailSave");
            admInputSpecialEmail = $("#viewSpecialEmailPopup #inpSpecialEmail");
        }

        function BuildViewWhatsNew() {
            for (var i = 0; i < admDataWelcomeMSG.length; i++) {
                var templateData = admDataWelcomeMSG[i];
                var templateResult = admTemplateWhatsNew(templateData);
                admViewWhatsNew.append(templateResult);
            }
        }

        function BuildViewSpecialEmail() {

            admViewSpecialEmail.empty();
            var templateData = admDataWelcomeSNE;
            var templateResult = admTemplateSpecialEmail(templateData);
            admViewSpecialEmail.append(templateResult);
            admActionAddSpecialEmail = $("#btnSpecialEmailAdd");
            admActionEditSpecialEmail = $("#btnSpecialEmailEdit");
            admActionAddSpecialEmail.on("click", OpenSpecialEmailPopup);
            admActionEditSpecialEmail.on("click", OpenSpecialEmailPopup);
        }

        function InitDataActions() {
            $(".specialEmailBtn").on("click", OpenSpecialEmailPopup);
            admActionSaveSpecialEmail.on("click", SaveSpecialEmail);

            <?php // bash clients do not have $("#viewAfterHours") so need that check. ?>
            var grid = $("#viewAfterHours").data("kendoGrid");
            if (grid && grid.dataSource.data().length <= 3) {
                $("#expandAfterHoursBtn").remove();
            } else if (grid && $("#expandAfterHoursBtn:visible").length > 0) {
                $("#expandAfterHoursBtn").on("click", function() {
                    var filter = $(this).text().trim() == "Show All" ? null : {field: "priority", operator: "le", value: 3};
                    grid.dataSource.filter(filter);
                    $(this).text($(this).text() == "Show All" ? "Show Top 3" : "Show All");
                });
            }

        }

        function InitDataViews(nagPlease) {
            var templateData = null;
            var templateResult = null;

            admViewWhatsNew = $("#viewWhatsNew");
            admTemplateWhatsNew = kendo.template($("#templateWhatsNew").html());
            BuildViewWhatsNew();

            admViewSpecialEmail = $("#viewSpecialEmail");
            admTemplateSpecialEmail = kendo.template($("#templateSpecialEmail").html());
            BuildViewSpecialEmail();

            admTemplateSpecialEmailPopup = $("#templateSpecialEmailPopup").html();
            BuildViewSpecialEmailPopup();

            admTemplateMessagesPopup = kendo.template($("#templateMessagesPopup").html());

            if (live == "Y") {
                BuildViewAfterHours();
            }

            if (nagPlease) {
                BuildViewNagPlease();
            }
        }

        function InitDataSources() {
            admDataWelcomeAHS = [];
            admDataWelcomeMSG = [];
            admDataWelcomeSNE = {};

            admDataSource = new kendo.data.DataSource({
                transport: {
                    read: {
                        url: "<?php echo $self; ?>&operation=readWelcome",
                        dataType: "json",
                        contentType: "application/x-www-form-urlencoded",
                        type: "GET"
                    }
                },
                requestStart: function(request) {
              showWaitWindow();
            },
            requestEnd: function(response) {
                try {
                    $.homecuValidator.setup({formValidate:'welcomeDiv', formStatusField: 'admInfoBar'});
                    if (response.hasOwnProperty("response")) {

                        var results = response.response;
                        if (results.error.length > 0) {
                            throw response.response.error;
                        } else {
                            $.homecuValidator.displayMessage(results.info, $.homecuValidator.settings.statusInfo );
                        }
                    } else {
                        throw "Error Parsing Server";
                    }
                } catch (error) {
                    $.homecuValidator.displayMessage(error, $.homecuValidator.settings.statusError);
                }
            },
            schema: {
                parse: function(response) {

                    if (response.error.length == 0) {
                        if (response.hasOwnProperty("record")) {
                            admDataWelcomeSNE.email = response.record[0].email;
                            BuildViewSpecialEmail();
                        } else {
                            admDataWelcomeAHS = response.afterHoursSupport;
                            admDataWelcomeMSG = response.messages;
                            admDataWelcomeSNE = { email: response.specialNotificationEmail };
                            InitDataViews(response.nagPlease);
                            InitDataActions();
                        }
                    }

                    hideWaitWindow();
                    setTimeout(function() {
                        if (admViewMessagesDialog) {
                            admViewMessagesDialog.open();
                        }
                    }, 500);
                    return [];
                }
              }
            });
        }

        $(document).ready(function() {
            admInfoBar = $("#admInfoBar");

            InitDataSources();
            admDataSource.read();

            <?php printClickOverlayEvent(); ?>
        });
    </script>

    <?php // **********************************
         // **** local styles ****************?>
    <style>

        <?php // Needed for the edit links to be inline with the header. ?>
        .local-h3 {
            display: inline;
        }
    </style>

    <div class="container-fluid" style="margin-bottom: 50px;" id="welcomeDiv">

        <div>&nbsp;</div>
        <div class="well well-sm col-sm-12" id="admInfoBar" style="display: none;"></div>

        <?php if ($live == "Y") { ?>
        <div class="well well-sm col-sm-12">
            <h3 class="local-h3">After Hours Support</h3>&nbsp;&nbsp;&nbsp;<a href="<?php echo $main; ?>?ft=28">Edit</a>
            <div class="col-sm-12">
                <div>&nbsp;</div>
                <div id="viewAfterHours"></div>
                <a href="#" id="expandAfterHoursBtn">Show All</a>
            </div>
        </div>
        <?php } ?>


        <div class="well well-sm col-sm-12">

            <h3 class="local-h3">Special Notification Email</h3>&nbsp;&nbsp;&nbsp;<a class="specialEmailBtn" href="#">Edit</a>
            <div id="viewSpecialEmail"></div>
        </div>

        <div class="well well-sm col-sm-12">

            <h2>What's New at HomeCU?</h2>
            <div id="viewWhatsNew"></div>
        </div>
    </div>

    <div id="viewSpecialEmailPopup" style="display: none;"></div>
    <div id="viewMessagesDialog"></div>

    <script type="text/x-kendo-template" id="templateMessagesPopup">
        <div class="well well-sm col-sm-12 k-success-colored">
            <span>#= subject #</span>
        </div>
    </script>

    <script type="text/x-kendo-template" id="templateSpecialEmailPopup">
        <div id="viewSpecialEmailStatus"></div>
        <div class="col-sm-12 hcu-container-margin">
            <div class="hcu-secondary">
                <div class="small vsgSecondary">
                    <span>To enter a list of addresses, use a semi-colon (;) to separate multiple addresses.</span>
                </div>
            </div>
            <br>
            <label>Email:</label>
            <input type="text" class="k-textbox hcu-full-width" id="inpSpecialEmail" name="inpSpecialEmail"
                homecu-match-plus="email"
                data-homecuCustomMatchPlus-msg="One of the emails is invalid."
                data-required-msg="Special Email is required"
                required>
        </div>

        <div class="col-sm-4 hcu-container-margin"></div>
        <div class="col-sm-4 hcu-container-margin">
            <button id="btnSpecialEmailSave" class="k-button k-primary hcu-full-width">
                <span class="fa fa-check"></span>
                <span>Save</span>
            </button>
        </div>
        <div class="col-sm-4 hcu-container-margin"></div>
    </script>

    <script type="text/x-kendo-template" id="templateSpecialEmail">

        <div>&nbsp;</div>
        <div class="col-sm-12">
        # if (email == "") { #
            <span>Special email notifications will not be sent. </span>
        # } else { #
            <span>Special email notifications will be sent to: </span>
            <span id="emailText"><strong>#= email #</strong></span>
        # } #
        </div>

    </script>

    <script type="text/x-kendo-template" id="templateWhatsNew">

        <div>&nbsp;</div>
        <div class="col-sm-12" id="msg#= mid #">
            # if (important) { #
            <div class="hcu-blog-post hcu-blog-post-important col-sm-12">
            # } else { #
            <div class="hcu-blog-post col-sm-12">
            # } #
                <h4 class="hcu-blog-title">#= subject #</h4>
                <p class="hcu-blog-date">#= kendo.toString(active_date, "MMMM dd, yyyy") #</p>
                <p>#= message #</p>
            </div>
        </div>

    </script>
    <?php
}