hcu_prod_list.prg

<?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('mode'=>'string','hcu_code'=>'string','form_err'=>'string');
dms_import($dms_ok);

    if (!isset($mode) || $mode == '')
        $mode = "MENU";

    if ($mode == "DELETE") {
            // Delete Alert
            $sql = "DELETE
                            FROM cuprodlist
                            WHERE home_cu_code = '" . prep_save($hcu_code) . "' ";
            $del_rs = db_query($sql, $link);

            if ($del_rs)
                $msg = "Home CU Product deleted successfully!";
            else
                $msg = "Problem deleting product, please try again.";

            $mode = "MENU";
    }

    switch ($mode) {
        case "CONF":
            // Confirm Deletion of the Product Code
            print <<< print_html
                <form action="/hcuadm/hcu_prod_list.prg" method="post">
                    <input type="hidden" name="mode" value="DELETE">
                    <input type="hidden" name="hcu_code" value="{$hcu_code}">

                    <table width="50%" cellpadding=3 cellspacing=0 align="center" class='dmsbg'><tr><td>
                    <table width="100%" cellpadding=1 cellspacing=0 align="center" bgcolor=white>
                        <tr>
                            <td CLASS="barb" nowrap>
                                Delete Homecu Product Code
                            </td>
                        </tr>
                        <tr>
                            <td class="">
                                <table border=0 cellpadding=2 cellspacing=0 width="100%">
                                    <tr>
                                        <td class="hdr" align="center">
                                            You are about to delete a home cu product code, <br>
                                            this may cause irratic behavior.<br>
                                            <br>Are you sure you want to continue?
                                            <br>
                                            <hr>
                                            <input type="submit" name="btnDelete" value="Sure">
                                            <input type="button" name="btnCancel" value="I better think twice" onClick="document.location='/hcuadm/hcu_prod_list.prg'">
                                        </td>
                                    </tr>
                                </table>
                            </td>
                    </table>
                    </td></tr></table>
                </form>
print_html;
            break;
        case "DELETE":

            break;
        case "MENU":

            cu_header('Home CU - Products');
?>
    <form>

        <?php
            // Connect to the data and retrieve the current list of Home CU Products
            $query = "SELECT * FROM cuprodlist ORDER BY home_cu_desc";
            $prod_result = db_query($query, $link);

        ?>

    <!-- Print out the top of the table -->

    <table border="0" cellpadding="3" cellspacing="0" align="center" class="dmsbg"><tr><td>
    <table border="0" cellpadding="1" cellspacing="0" align="center" bgcolor=white
        <?php if (isset($msg) && strlen($msg) > 0): ?>
            <tr>
                <td colspan="4" class="dtl" align="center">
                    <font color="red"><?php echo $msg; ?></font>
                </td>
            </tr>
        <?php endif; ?>
        <tr>
            <td colspan="4" class="bar" align="center">
                HOME CU PRODUCTS LIST
            </td>
        </tr>
        <tr>
            <td class="hdr" align="center">
                Home CU Product Code
            </td>
            <td class="hdr" align="center">
                Product Description
            </td>
            <td class="hdr" align="center">
                Select
            </td>
        </tr>
        <?php
            $RGB = "odd";
            $row = 0;
      while ($prod_row = db_fetch_object($prod_result, $row)):
            $row++;
        ?>
        <tr class="<?php echo $RGB; ?>">
            <td nowrap >
                <?php echo trim($prod_row->home_cu_code) ?>
            </td>
            <td nowrap >
                <?php echo trim($prod_row->home_cu_desc) ?>
            </td>
            <td nowrap >
                <a href="hcu_prod_edit.prg?home_cu_code=<?php echo trim($prod_row->home_cu_code) ?>">Edit</a>
                &nbsp;|&nbsp;
                <a href="/hcuadm/hcu_prod_list.prg?mode=CONF&hcu_code=<?php echo trim($prod_row->home_cu_code) ?>">Delete</a>
            </td>
        </tr>
        <?php
            $RGB = ($RGB == "odd" ? "even" : "odd");
            endwhile; ?>

        <tr>
            <td colspan="3">
                <a href="home_cu_prod.prg">Add Home CU Product</a>
                <br>
                <a href="/monitor/mindex.html" target="_top">Main Credit Union List</a>
            </td>
        </tr>
    </table>
    </td></tr></table>

    </form>
    </body>
</html>
<?php
        break;
    }
?>