userSupportShowRelated.prg

<?php
/**
 * @package UserSupport (Subpackage show related)
 * @author SPB
 *
 * This script is run when the user opens up the show related card in the user hub.  It cannot be run independently of that.
 */
require_once("$admLibrary/userSearch.i"); // Needed for encryptUser
require_once("$admLibrary/aMemberSupport.i");
$parameters = array("a" => array("operation" => "", "payload" => "", "ft" => "", "userId" => ""));
$string = array("filter" => HCUFILTER_INPUT_STRING);
HCU_ImportVars($parameters, "a", array("operation" => $string, "payload" => $string, "ft" => $string, "userId" => $string));
extract($parameters["a"]);

$operation = is_null($operation) ? "" : trim($operation);
$showSQL = $SYSENV["devmode"];

try {
    $userId = HCU_PayloadDecode($Cu, $payload);
} catch(exception $e) { ?>
    <div class='noUserFound'><div>No User Found</div></div>
<?php exit;
}
printPage("$menu_link?ft=$ft", $userId["user_id"], getShowRelated($SYSENV, $dbh, $Cu, $userId["user_id"], $showSQL));

/**
 * function getShowRelated($dbh, $Cu, $userId)
 * This function shows the related users of the particular user
 *
 * @param integer $dbh -- the database connection
 * @param string $Cu -- the credit union
 * @param integer $userId -- the user id banking side
 * @param boolean $showSQL -- to turn off the SQL when not in DEVMODE.
 *
 * @return "sql" -- any sqls used, "code" -- zero if there is no errors; nonzero if there is an error found, "error" -- the last error or an empty array, "relatedData" -- the data to return
 */
function getShowRelated($pEnv, $dbh, $Cu, $userId, $showSQL) {
    $sqls = array();

    try {
        $sql = "select a.user_id, a.user_name, a.email, a.name, g.group_name, p.profile_code, g.group_id, p.profile_id, p.description as profile_desc,
               a.is_group_primary, a.lastlogin, a.employee from ${Cu}user u
               left join ${Cu}group g on u.group_id = g.group_id
               inner join ${Cu}user a on g.group_id = a.group_id
               left join cu_profile p on g.profile_id = p.profile_id
               where u.user_id = $userId and a.user_id is not null and u.user_id <> a.user_id order by a.user_name";
        $sqls[] = $sql;

        $sth = db_query($sql, $dbh);
        if (!$sth) {
            throw new exception("Show Related query failed.", 1);
        }

        $relatedData = array();
        for($i = 0; $row = db_fetch_assoc($sth, $i); $i++) {
            $row["isPrimary"] = isset($row["is_group_primary"]) ? trim($row["is_group_primary"]) == "t" : false;
            $row["subUsers"] = array();

            $row["name"] = isset($row["name"]) ? trim($row["name"]) : "";
            $row["profile_code"] = isset($row["profile_code"]) ? trim($row["profile_code"]) : "";
            $row["group_name"] = isset($row["group_name"]) ? trim($row["group_name"]) : "";
            $row["email"] = isset($row["email"]) ? trim($row["email"]) : "";
            $row["employee"] = isset($row["employee"]) ? trim($row["employee"]) : "";

            // payload for user selection in user hub
            $encryptedUser = encryptUser($Cu, $row, false);
            $encryptedUser = urlencode($encryptedUser);
            $row["encryption"] = $encryptedUser;

            $relatedData[intval($row["user_id"])] = $row;
        }
        $returnArray = array("sql" => $sqls, "code" => 0, "error" => array(), "relatedData" => array_values($relatedData));
    } catch(exception $e) {
        $returnArray =  array("sql" => $sqls, "code" => $e->getCode(), "error" => array($e->getMessage()));
    }

    if (!$showSQL) {
        unset($returnArray["sql"]);
    }
    return $returnArray;
}

/**
 * function printPage($self, $userId, $readData)
 * This function will print out the popup for the audit.
 */
function printPage($self, $userId, $readData) { ?>
    <script type="text/javascript">
    //# sourceURL=showRelated.js

    <?php
    /**
     * function init()
     * This initializes stuff including but not limited to the Big Bang.
     */
    ?>
    function init() {
        $.homecuValidator.setup({formValidate:'showRelatedDiv', formStatusField: 'formValidateDiv'});
        $("#externalTabWindow").data("preferredHeight", "auto");
        var showRelatedData = [];
        var columns = [
            {headerTemplate: "&nbsp;", headerAttributes: {"class": "hierarchyCell"}, width: 45},
            {field: "user_name", title: "User", attributes: {"class": "showEllipsis"}},
            {field: "name", title: "Name", attributes: {"class": "hidden-xs hidden-sm showEllipsis"}, headerAttributes: {"class": "hidden-xs hidden-sm"}},
            {field: "email", title: "Email", attributes: {"class": "showEllipsis"}},
            {field: "lastlogin", title: "Last Sign in", attributes: {"class": "hidden-xs hidden-sm"}, headerAttributes: {"class": "hidden-xs hidden-sm"}}
        ];

        var showRelatedGrid = $("#showRelatedGrid").kendoGrid({
            dataSource: {
                transport: {
                    read: function (options) {
                        options.success(showRelatedData);
                    }
                },
                schema: {
                    model: {
                        id: "user_id",
                        fields: {
                            user_id: {type: "number"},
                            user_name: {type: "string"},
                            name: {type: "string"},
                            email: {type: "email"},
                            lastlogin: {type: "string"},
                            isPrimary: {type: "boolean"},
                            subUsers: {type: "odata"},
                            group_name: {type: "string"},
                            profile_code: {type: "string"},
                            encryption: {type: "string"},
                        }
                    }
                }
            },
            columns: columns,
            rowTemplate: $("#rowTemplate").html(),
            noRecords: {
                template: "<tr><td colspan='5'><span class='hcu-secondary'><span class='vsgSecondary'>No Records Found</span></span></td></tr>"
            },
            height: 400,
            dataBound: function() {
                $("#showRelatedGrid").css({height: "initial", maxHeight: 400, overflowY: "auto", overflowX: "initial"});
                $("#showRelatedGrid .k-grid-content").css({height: "initial"});
            },
            autoBind: false
        }).data("kendoGrid");

        $("#showRelatedGrid colgroup").each(function() {
            $(this).find("col").each(function(index) {
                if ([2,5].indexOf(index) != -1) {
                    $(this).addClass("hidden-xs hidden-sm");
                }
            })
        });

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

        $(".showRelatedDiv").on("click", ".cancelBtn", function() {
            postPostPostPost();
            return false;
        });

        <?php printExtendShowOverflown(); ?>

        var toolTipProps = homecuTooltip.defaults;
        toolTipProps.filter = ".showEllipsis:visible:overflown";
        toolTipProps.content = function(e) {
            return $(e.target).text().trim();
        };

        $("#showRelatedGrid").kendoTooltip(toolTipProps);
    }

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

    init();
    </script>
    <script type="text/x-kendo-template" id="rowTemplate">
        <tr data-uid="#: uid #">
            <td># if (isPrimary) { # <i class="fa fa-asterisk"></i> # } else { # &nbsp; # } #</td>
            <td class="showEllipsis"># if (user_name == null) { # &nbsp; # } else { # <a href="main.prg?ft=22&payload=#: encryption #">#: user_name #<i class="fa fa-user fa-fw"></i></a>
                # } #</td>
            <td class="hidden-xs hidden-sm showEllipsis"># if (name == null) { # &nbsp; # } else { # #: name # # } #</td>
            <td class="showEllipsis"># if (email == null) { # &nbsp; # } else { # #: email # # } #</td>
            <td class="hidden-xs hidden-sm showEllipsis"># if (lastlogin == null) { # &nbsp; # } else { # #: lastlogin # # } #</td>
        </tr>
    </script>
    <div class="container hcu-all-100 showRelatedDiv vsgPrimary hcu-template" id="showRelatedDiv">
        <div class="row">
            <div id="formValidateDiv" class="k-block k-error-colored" style="display:none"></div>
        </div>
        <div class="hcu-secondary">
            <div class="row small vsgSecondary">
                Click a row to select.  <i class="fa fa-asterisk"></i> means that user is primary for the group.
                <div class="visible-xs-inline visible-sm-inline">  Rotate device to see more columns.</div>
            </div>
        </div>
        <div class="row">
            <div id="showRelatedGrid" class="overrideGridHeight"></div>
        </div>
        <div class="hcu-edit-buttons k-state-default row">
            <a class="cancelBtn" href="#">Cancel</a>
        </div>
    </div>
<?php }