contMaint.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("gridData" => ""));
$string= array("filter" => FILTER_DEFAULT);
HCU_ImportVars($parameters, "a", array("gridData" => $string));
extract($parameters["a"]); // dms_import doesn't work anymore because this isn't in global scope anymore.
$showSQL= $SYSENV["devmode"];

if ($operation != "")
{
    switch($operation)
    {
        case "readAfterHours":
            $sqls= array();
            $isValid= true;
            try
            {
                $records= readAfterHours($dbh, $sqls, $Cu, true);
            }
            catch(exception $e)
            {
                $returnArray= array("error" => array($e->getMessage()), "sql" => $sqls, "record" => array());
                $isValid= false;
            }
            if ($isValid)
                $returnArray= array("error" => array(), "sql" => $sqls, "record" => $records);
            break;
        case "saveAfterHours":
            $returnArray= saveAfterHours($dbh, $Cu, $Cn, $gridData);
            break;
        default: $returnArray= array("sql" => array(), "error" => array("Operation not recognized: $operation."), "record" => array());
        break;
    }

    header('Content-type: application/json');
    if (!$showSQL)
        unset($returnArray["sql"]);
    print json_encode($returnArray);
}
else
{
    printAfterHoursPage($self);
}

/**
 * function saveAfterHours($dbh, $Cu, $Cn)
 * Saves CU contacts
 *
 * @param integer $dbh -- the database connection
 * @param string $Cu -- the credit union
 * @param string $Cn -- the logged in user
 * @return array --
 *      $error -- one or zero errors encountered
 *      $sql -- the SQLs used
 *      $returnData -- the new data for the grid.  A requery is needed to capture the commentid for any added records.
 */
function saveAfterHours($dbh, $Cu, $Cn, $gridData)
{
    $sqls= array();
    try
    {
        if ($gridData == "")
            throw new exception("Grid Data is required!", 1);
        $gridData= HCU_JsonDecode($gridData);
        if (!is_array($gridData))
            throw new exception("Grid Data is not correct!", 2);

        $createArray= array();
        $updateArray= array();
        $deleteArray= array();
        $priorityMap= array();
        foreach($gridData as $record)
        {
            if (!isset($record["contactid"]) || !isset($record["priority"]) || !isset($record["name"]) || !isset($record["phone"]) || !isset($record["comments"]))
                throw new exception("gridData is not correct!", 3);
            if (isset($record["removed"]) && $record["removed"])
            {
                if ($record["contactid"] == 0)
                    continue; // Do nothing to this record.  It was added and then removed from the grid.
                $deleteArray[]= array("_action" => "delete", "contactid" => $record["contactid"], "user_name" => strtolower($Cu));
            }
            else
            {
                $priority= intval($record["priority"]);
                if (isset($priorityMap[$priority]))
                    throw new exception("Priority needs to be unique!", 7);
                $priorityMap[$priority]= true;

                $phone= trim($record["phone"]);
                if (!preg_match('/^\([0-9]{3}\) [0-9]{3}-[0-9]{4}$/', $phone))
                    throw new exception("Phone is not formatted correctly!", 8);

                $thisRecord= array("contactid" => $record["contactid"], "priority" => $priority, "name" => $record["name"], "phone" => $phone,
                    "comments" => $record["comments"], "user_name" => strtolower($Cu));
                if ($record["contactid"] == 0)
                {
                    $thisRecord["_action"]= "insert";
                    $createArray[]= $thisRecord;
                }
                else
                {
                    $thisRecord["_action"]= "update";
                    $updateArray[]= $thisRecord;
                }
            }
        }

        $sql= "select email from cuadminusers where user_name= '$Cn' and cu= '$Cu'";
        $sqls[]= $sql;
        $sth = db_query($sql, $dbh);
        if (!$sth)
            throw new exception("Email query failed!", 6);
        $email= db_fetch_row($sth)[0];

        // Delete and update needs to be first so unique index doesn't fail.
        if (count($deleteArray) > 0 && DataAdminTableUpdate($dbh, array("cu" => $Cu), array("cucontact" => $deleteArray), $Cn,
            "CCON_DEL", "notificationMaintenance.prg", "A", "Contact removed", $Cn, $email, trim($_SERVER["REMOTE_ADDR"])) === false)
            throw new exception("Delete audit function failed!", 5);
        if (count($updateArray) > 0 && DataAdminTableUpdate($dbh, array("cu" => $Cu), array("cucontact" => $updateArray), $Cn,
            "CCON_UPD", "notificationMaintenance.prg", "A", "Contact updated", $Cn, $email, trim($_SERVER["REMOTE_ADDR"])) === false)
            throw new exception("Update audit function failed!", 4);
        if (count($createArray) > 0 && DataAdminTableUpdate($dbh, array("cu" => $Cu), array("cucontact" => $createArray), $Cn,
            "CCON_ADD", "notificationMaintenance.prg", "A", "Contact added", $Cn, $email, trim($_SERVER["REMOTE_ADDR"])) === false)
            throw new exception("Create audit function failed!", 3);

        $returnData= readAfterHours($dbh, $sqls, $Cu, true);
    }
    catch(exception $e)
    {
        return array("error" => array($e->getMessage()), "sql" => $sqls, "returnData" => array());
    }
    return array("error" => array(), "sql" => $sqls, "returnData" => $returnData);
}

/**
 * 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, &$sqls, $Cu, $editable)
{
    $sql= "select contactid, priority, name, phone, comments from cucontact where user_name = '" . strtolower($Cu) . "' order by user_name, priority";
    $sqls[]= $sql;
    $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 printAfterHoursPage($self)
 * This prints out the after hours page.
 *
 * @param string $self -- the URL to this script.
 */
function printAfterHoursPage($self)
{ ?>
    <style>
        <?php printTopCenterCss(200); ?>
    </style>
    <script type="text/javascript">
        <?php // Library javascript functions
        getShowWaitFunctions(); ?>
        var nextPriority= 1;
        var nextPid= 1;

        <?php
        /**
         * function init()
         * This initializes the kendoGrid for the after hours page.  It is an incell-edited grid.  The priority DDL is a bit noncommon.
         */
        ?>
        function init()
        {
            var grid= $("#grid").kendoGrid({
                dataSource: {
                    transport: {
                        read: {
                            type: "POST",
                            dataType: "json",
                            url: "<?php echo $self; ?>&operation=readAfterHours"
                        },
                        parameterMap: function(data, type)
                        {
                            showWaitWindow();
                            return data;
                        }
                    },
                    schema: {
                        model: {
                            id: "pid",
                            fields: {
                                contactid: {type: "number"},
                                pid: {type: "number", defaultValue: function() { return nextPid++; }},
                                priority: {type: "number", defaultValue: function() { return nextPriority++; }},
                                name: {type: "string"},
                                phone: {type: "string", validation: {phone: function(input) {
                                    if (!$(input).is("[name='phone']"))
                                        return true;
                                    if (!$(input).val().trim().match(/^\([0-9]{3}\) [0-9]{3}-[0-9]{4}$/))
                                    {
                                        $(input).attr("data-phone-msg", "Phone Number is invalid!");
                                        return false;
                                    }
                                    return true;
                                }}},
                                comments: {type: "string"},
                                removed: {type: "boolean", defaultValue: false},
                                changed: {type: "boolean", defaultValue: true}
                            }
                        },
                        parse: function(data)
                        {
                            hideWaitWindow();

                            if (data.error.length > 0)
                                $.homecuValidator.displayMessage(data.error, $.homecuValidator.settings.statusError );
                            else if (data.record.length > 0)
                            {
                                var lastRecord= data.record[data.record.length-1];
                                nextPriority= Number(lastRecord.priority);
                                nextPid= Number(lastRecord.pid);
                            }

                            return data.record;
                        }
                    },
                    sort: {field: "priority", dir: "asc"},
                    filter: {field: "removed", operator: "neq", value: true}
                },
                editable: {
                    mode: "incell",
                    createAt: "bottom"
                },
                toolbar: ["create"],
                columns: [
                    {command: [{name: "custRemove", text: "Delete"}]},
                    {field: "priority", title: "Priority", editor: function(container, options) {
                        var oldPriority= options.model.priority;
                        var oldPid= options.model.pid;
                        var gridData= $("#grid").data("kendoGrid").dataSource.data();
                        var ddlOptions= [];

                        <?php
                        /* This is creating the DDL for the priority edit.  It is going to look like (if there are 5 records and the middle one is being changed):
                            * Keep Priority
                            * Move Top
                            * Move Bottom
                            * Move up 1
                            * Move up 2
                            * Move down 1
                            * Move down 2
                         */
                        ?>
                        for(var i=0; i!= gridData.length; i++)
                        {
                            if (gridData[i].removed)
                                continue;
                            var newPriority= gridData[i].priority;
                            var newPid= gridData[i].pid;
                            var difference= newPriority - oldPriority;
                            if (newPriority < oldPriority)
                                ddlOptions.push({text: "Move up " + (-difference), value: newPriority, pid: newPid});
                            else if (newPriority > oldPriority)
                                ddlOptions.push({text: "Move down " + difference, value: newPriority, pid: newPid});
                        }

                        <?php /* Sorts like the comment above.*/ ?>
                        ddlOptions.sort(function(a, b) {
                            return (a.value < 0 ? (b.value < 0 ? b.value - a.value : 1) : (b.value >= 0 ? a.value - b.value : -1));
                        });
                        if (oldPriority != gridData.length)
                            ddlOptions.unshift({text: "Move Bottom", value: gridData.length});
                        if (oldPriority != 1)
                            ddlOptions.unshift({text: "Move Top", value: 1});
                        ddlOptions.unshift({text: "Keep Priority", value: -1});

                        $("<div class='priorityDDL'></div>").appendTo(container).kendoDropDownList({
                            dataSource: {
                                data: ddlOptions
                            },
                            dataTextField: "text",
                            dataValueField: "value",
                            change: function()
                            {
                                var dataItem= this.dataItem();
                                if (dataItem.value == -1)
                                    return;

                                <?php
                                /* This is changing the whole grid based on changing the priority.  Through experimentation, I found that the priorities will change between the oldPriority
                                and the newPriority.  This is only going to be one more or one less depending on if the newPriority is higher or lower than the oldPriority.  Show this as changed.
                                 */
                                ?>
                                for(var i=0; i!= gridData.length; i++)
                                {
                                    if (gridData[i].removed)
                                        continue;
                                    if (oldPid == gridData[i].pid)
                                    {
                                        gridData[i].priority= dataItem.value;
                                        gridData[i].changed= true;
                                    }
                                    else if (dataItem.value <= gridData[i].priority && oldPriority >= gridData[i].priority)
                                    {
                                        gridData[i].priority++;
                                        gridData[i].changed= true;
                                    }
                                    else if (oldPriority <= gridData[i].priority && dataItem.value >= gridData[i].priority)
                                    {
                                        gridData[i].priority--;
                                        gridData[i].changed= true;
                                    }
                                }
                                $("#grid").data("kendoGrid").dataSource.data(gridData);
                            }
                        }).data("kendoDropDownList");
                    }},
                    {field: "name", title: "Name", editor: function(container, options) {
                        var input= $("<input type='text' class='k-input k-textbox' name='" + options.field + "' required data-required-msg='Name is required!' maxlength=35>").appendTo(container);
                    }},
                    {field: "phone", title: "Phone",  editor: function(container, options) {
                        var input= $("<input name='" + options.field + "'>").appendTo(container).kendoMaskedTextBox({
                            mask: "(000) 000-0000"
                        }).data("kendoMaskedTextBox")
                    }},
                    {field: "comments", title: "Comments", width: "40%", editor: function(container, options) {
                        var input= $("<input type='text' class='k-input k-textbox' name='" + options.field + "' maxlength=255>").appendTo(container);
                    }}
                ]
            }).data("kendoGrid");

            <?php
            /* This is creating a delete dialog when the delete button is clicked.  On a "yes" click, the record IS NOT removed from the grid.  Instead there is a removed boolean that is set to true.
            This is necessary because the record won't actually be deleted until the save button is clicked. */
            ?>
            $("#grid").on("click", ".k-grid-custRemove", function() {
                $("#formInfoDiv").hide();
                var deleteDialog= $("#deleteDialog").data("kendoWindow");
                if (deleteDialog == null)
                {
                    var template= "<div>\
                    <div>\
                    Are you sure you want to delete this record?\
                    </div>\
                    <div>\
                        <a href='\\#' class='k-button okBtn'>Yes</a>\
                        <a href='\\#' class='k-button cancelBtn'>No</a>\
                    </div>\
                    </div>";

                    deleteDialog= $("<div id='deleteDialog' style='text-align:left;'></div>").appendTo("body").kendoWindow({
                        content: {
                            template: template
                        },
                        modal: true,
                        title: "Delete?",
                        visible: false,
                        resizable: false,
                        width: 400,
                        close: function() {
                            activeWindows.pop();
                        }
                    }).data("kendoWindow");

                    <?php /* On this button click, the record is filtered out of the grid.  Now, any records with a priority lower (well, higher in number) are reduced by one.*/ ?>
                    $("#deleteDialog .okBtn").click(function() {
                        var grid= $("#grid").data("kendoGrid");

                        var gridData= grid.dataSource.data();
                        var dataItem= $("#deleteDialog").data("dataItem");
                        dataItem.removed= true;
                        dataItem.changed= true;

                        for(var i=0; i!= gridData.length; i++)
                        {
                            if (gridData[i].pid == dataItem.pid || gridData[i].removed)
                                continue;
                            if (gridData[i].priority >= dataItem.priority)
                            {
                                gridData[i].changed= true;
                                gridData[i].priority--;
                            }

                        }
                        nextPriority--;
                        grid.dataSource.data(gridData);
                        deleteDialog.close();
                        return false;
                    });

                    $("#deleteDialog .cancelBtn").click(function() {
                        deleteDialog.close();
                        return false;
                    });
                }

                var grid= $("#grid").data("kendoGrid");
                $("#deleteDialog").data("dataItem", grid.dataItem($(this).closest("tr")));
                deleteDialog.open();
                activeWindows.push(deleteDialog);
                return false;
            });

            <?php // Adds the save button click event.  The grid data is filtered by changed == true.  This is stringified and then set to the save call.  The save call returns the updated data. ?>
            $("#savePageBtn").click(function() {
                $("#formInfoDiv").hide();

                var changedData= [];
                var data= grid.dataSource.data();
                for(var i=0; i!=data.length; i++)
                {
                    if (data[i].changed)
                        changedData.push({contactid: data[i].contactid, priority: Number(data[i].priority), name: data[i].name, phone: data[i].phone, comments: data[i].comments,
                            removed: data[i].removed});
                }

                if (changedData.length > 0)
                {
                    showWaitWindow();
                    $.post("<?php echo $self; ?>&operation=saveAfterHours", {gridData: kendo.stringify(changedData)}, function(data) {
                        hideWaitWindow();
                        if (data.error.length > 0)
                            $.homecuValidator.displayMessage(data.error, $.homecuValidator.settings.statusError );
                        else
                        {
                            $.homecuValidator.displayMessage("Changes were saved successfully!", $.homecuValidator.settings.statusInfo );

                            $("#grid").data("kendoGrid").dataSource.data(data.returnData);
                        }
                    });
                }

                return false;
            });
        }

        var activeWindows= [];
        $(document).ready(function() {
            init();
            <?php printClickOverlayEvent(); ?>
        });
    </script>
    <div class="container-fluid">
        <div id="formValidateDiv" class="k-block k-error-colored formValidateDiv" style="display:none;"></div>
        <div class="form-horizontal form-widgets">
            <div id="grid" style="margin-bottom: 5px;"></div>
            <a href="#" id="savePageBtn" class="k-button">Save Changes</a>
        </div>
    </div>
<?php }