cucontactafter_8prg_source.html

<?php
$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;

    $chome = $cu;

    $AfterHoursAry = Array();
    if ($chome != '') {

        $sql = "SELECT *
                        FROM cucontact
                        WHERE user_name = '" . prep_save($chome, 12) . "'
                        ORDER by user_name, priority ";
        $contact_rs = db_query($sql, $dbh);


        $row_idx = 0;
        while ($contact_row = db_fetch_array($contact_rs, $row_idx)) {
            $AfterHoursAry[] = Array("Priority"=>trim($contact_row['priority']),
                                                                "Name"=>trim($contact_row['name']),
                                                                "Phone"=>trim($contact_row['phone']),
                                                                "Comments"=>trim($contact_row['comments']));
            $row_idx++;
        }
    }

    if ($row_idx > 0) {
        print <<< print_html
            <html>
                <title>After Hours 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">Priority</span>
                    </td>
                    <td class="dtl">
                        <span style="font-weight:bold">Name</span>
                    </td>
                    <td class="dtl" nowrap>
                        <span style="font-weight:bold">Phone</span>
                    </td>
                    <td class="dtl">
                        <span style="font-weight:bold">Comments</span>
                    </td>
                </tr>
print_html;

        // ** LOOP THROUGH EACH OF THE items in the array

        foreach ($AfterHoursAry as $key=>$ContactInfo) {

            $disp_priority = dms_disphtml($ContactInfo['Priority']);
            $disp_name = dms_disphtml($ContactInfo['Name']);
            $disp_phone = dms_disphtml($ContactInfo['Phone']);
            $disp_comments = dms_disphtml($ContactInfo['Comments']);
            $class_tr = (isset($class_tr) && $class_tr == "odd" ? "even" : "odd");
            print <<< print_html
                <tr class='$class_tr'>
                    <td class="dtl $class_tr">$disp_priority</td>
                    <td class="dtl $class_tr">$disp_name</td>
                    <td class="dtl $class_tr">$disp_phone</td>
                    <td class="dtl $class_tr">$disp_comments</td>
                </tr>
print_html;


        }


        print "</table></body></html>";
    } else {
        // * NO ROWS -- DISPLAY SUCH
        print "There are no entries for after hours support.";
    }

?>