cuAdmUsers_8prg_source.html

<?php
/* This is a helper routine that is called by an iFrame to supply contact info from the cuadminusers table.
 * History:
 * 05/02/13 mbl - created.
 */
    $monLibrary= dirname(__FILE__) . "/../library";
    require_once("$monLibrary/cu_top.i");
    require_once("$monLibrary/ck_hticket.i");

    if (!CheckPerm($link, $Hu, basename($_SERVER['SCRIPT_NAME']), $_SERVER['REMOTE_ADDR'])) {
        // ** Permissions failed
        // ** redirect to new page
        header("Location: /hcuadm/hcu_noperm.prg");
        exit;
    }

    $dms_ok=array('cu'=>'string');
    dms_import($dms_ok);

    $dbh = $link;

  $cu = strtoupper($cu);
    $contactsArray = Array();
    if ($cu != '') {

        $sql = "SELECT user_name, realname, email
                        FROM cuadminusers
                        WHERE cu = '" . prep_save($cu, 12) . "'
                        ORDER by user_name ";
        $contact_rs = db_query($sql, $dbh);

        $row_idx = 0;
        while ($contact_row = db_fetch_array($contact_rs, $row_idx)) {
            $contactsArray[] = Array( "username"=>trim($contact_row['user_name']),
                                "realname"=>trim($contact_row['realname']),
                                                                "email"=>trim($contact_row['email']));
            $row_idx++;
        }
    }

    if ($row_idx > 0) {
        print <<< print_html
            <html>
                <title>Credit Union Admin Contacts</title>
            <body>
            <LINK REL=stylesheet HREF="/monitor/css/monitor.css" TYPE="text/css">
            <table width="100%" border=0 cellspacing=0 cellpadding=2>
                <tr>
                    <td class="dtl">
                        <span style="font-weight:bold">Login Name</span>
                    </td>
                    <td class="dtl">
                        <span style="font-weight:bold">Full Name</span>
                    </td>
                    <td class="dtl" nowrap>
                        <span style="font-weight:bold">E-Mail</span>
                    </td>
                </tr>
print_html;

        // ** LOOP THROUGH EACH OF THE items in the array
        foreach ($contactsArray as $key=>$ContactInfo) {

            $disp_login = dms_disphtml($ContactInfo['username']);
            $disp_name = dms_disphtml($ContactInfo['realname']);
            $disp_email = dms_disphtml($ContactInfo['email']);
            $class_tr = (isset($class_tr) && $class_tr == "odd" ? "even" : "odd");
            print <<< print_html
                <tr class='$class_tr'>
                    <td class="dtl $class_tr">$disp_login</td>
                    <td class="dtl $class_tr">$disp_name</td>
                    <td class="dtl $class_tr">$disp_email</td>
                </tr>
print_html;


        }

    print "</table></body></html>";
    } else {
        // * NO ROWS -- DISPLAY SUCH
        print "There are no credit union maintained contacts.";
    }

?>