view_vend.prg

<?php
$monLibrary= dirname(__FILE__) . "/../library";
require_once("$monLibrary/cu_top.i");
require_once("$monLibrary/ck_hticket.i");
require_once("$monLibrary/cu_pass.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('vc'=>'string');

dms_import($dms_ok);

    $dbh = $link;

    //This form will view a vendor's information

    echo "<table border=0 cellpadding=3 cellspacing=0 width=\"80%\" class=\"dmsbg\"><tr><td>";
    if (!isset($vc)) {
        print <<< no_data
            <table border=0 cellpadding=1 cellspacing=0 width="100%" bgcolor=white>
                <tr>
                    <td width="100%" align=center>
                        Incorrect Form Information
                    </td>
                </tr>
            </table>
no_data;
        exit;
    }

    $sql = "SELECT *
                    FROM cuvendors
                    WHERE vendor = '$vc' ";

    $db_rs = db_query($sql, $dbh);

    cu_header("Vendor Information");
    print <<< js_code
        <script language="javascript">
            <!--
            function close_form() {
                self.close();
            }
            -->
        </script>
js_code;
    if($db_row = db_fetch_array($db_rs)) {
        // Vendor Code found, view the information


        // Loop through all values in the array and set them to be html ready
        foreach ($db_row as $key => $value) {
            if ($key == 'email') {
                // For email create a link so it will be a mailing link
                $db_row[$key] = "<a href=\"mailto:" . trim($db_row['email']) . "\">" . htmlspecialchars(trim($db_row['email'])) . "</a>&nbsp;";
            } else {
                $db_row[$key] = htmlspecialchars(trim($value)) . "&nbsp;";
            }
        }

        print <<< form
            <table border=0 cellpadding=1 cellspacing=0 width="100%" bgcolor=white>
                <tr>
                    <td colspan="2" align="center" class="bar">
                        Vendor Information
                    </td>
                </tr>
                <tr>
                    <td class="hdr" width="30%" nowrap>Vendor Name:</td>
                    <td nowrap width="70%" class='dtl'>{$db_row['venddesc']}</td>
                </tr>
                <tr>
                <tr>
                    <td class="hdr" width="30%" nowrap>VAR Info:</td>
                    <td nowrap width="70%" class='dtl'>{$db_row['vendvar']}</td>
                </tr>
                    <td class="hdr" nowrap>Addresss:</td>
                    <td nowrap class='dtl'>{$db_row['addr1']}</td>
                </tr>
                <tr>
                    <td class="hdr" nowrap>&nbsp;</td>
                    <td nowrap class='dtl'>{$db_row['addr2']}</td>
                </tr>
                <tr>
                    <td class="hdr" nowrap>City</td>
                    <td nowrap class='dtl'>{$db_row['city']}</td>
                </tr>
                <tr>
                    <td class="hdr" nowrap>State:</td>
                    <td nowrap class='dtl'>{$db_row['st']}</td>
                </tr>
                <tr>
                    <td class="hdr" nowrap>Zip:</td>
                    <td nowrap class='dtl'>{$db_row['zip']}</td>
                </tr>
                <tr>
                    <td class="hdr" nowrap>Phone:</td>
                    <td nowrap class='dtl'>{$db_row['phone']}</td>
                </tr>
                <tr>
                    <td class="hdr" nowrap>Fax:</td>
                    <td nowrap class='dtl'>{$db_row['fax']}</td>
                </tr>
                <tr>
                    <td class="hdr" nowrap>Email:</td>
                    <td nowrap class='dtl'>{$db_row['email']}</td>
                </tr>
                <tr>
                    <td class="hdr" nowrap>Contact:</td>
                    <td nowrap class='dtl'>{$db_row['contact']}</td>
                </tr>
                <tr>
                    <td class="hdr" valign="top" nowrap>Comments:</td>
                    <td class='dtl'>{$db_row['comments']}</td>
                </tr>
                <tr>
                    <td colspan="2" align="center" class='dtl'>
                        <a href="javascript:close_form()">Close Window</a>
                    </td>
                </tr>
            </table>
form;
    } else {
        // Vendor code NOT found, show error and exit;
        print <<< no_data
            <table border=0 cellpadding=1 cellspacing=0 width="100%" bgcolor=white>
                <tr>
                    <td width="100%" class="bar" align=center>
                        No Vendor Record
                    </td>
                </tr>
            </table>
no_data;
    }
    echo "</td></tr></table>";
?>