cualtroutes.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('act'=>'string','cu'=>'string','route'=>'digits');

dms_import($dms_ok);

$self = $_SERVER['PHP_SELF'];

    switch ($act){
        case "delete":
        case "show":
        case "save":
        break;
    default:
        $act = "show";
    }
if (!isset($cu)) $act = "getcu";
$cu = strtoupper($cu);

    switch ($act){
#
            case "getcu":
                // Enter a cu code
            cu_header("CU Alternate R&amp;T Numbers");
                print <<< EOF
                    <form name="cucode" method="post" action="$self?act=show">
                        <input type="hidden" name="act" value="show">
                    <br>
                    <table width="350" border=0 cellpadding=0 cellspacing=0 align='center'>
                        <tr>
                            <td colspan="2" class="hdrc" align="center">
                                View CU Alternate R&amp;T Numbers
                            </td>
                        </tr>
                        <tr>
                            <td class="dtlr">
                                Credit Union:
                            </td>
                            <td class="dtll">
                                <input type="text" name="cu" value="" size="12" maxlength="12">
                            </td>
                        </tr>
                        <tr>
                            <td colspan="2" class="dtl"><hr></td>
                        </tr>
                        <tr>
                            <td class="dtl">&nbsp;</td>
                            <td class="dtll">
                                <input type="submit" value="Show &nbsp;&gt;&gt;" name="btnStmnt">
                            </td>
                        </tr>
            </table></form>
   <script language="javascript">
            <!--
            document.forms[0].cu.focus();
            // -->
          </script>
EOF;

            break;
#
        case "delete":          // Delete existing
                if (trim($route) == '') { $form_err = "Can't Delete Blank R&amp;T Number"; }
                if (trim($form_err) == "") {
                    $query = "delete from cualtroute where cu = '$cu'
                                        and rt = '$route'";
                    $result = db_query($query, $link);
                    if ($result) {
                        $form_err = "R&amp;T $route Deleted";
                    } else {
                        $form_err = "Error encountered Deleting R&amp;T with sql $query";
                    }
                }
                break;
        case "save":
                if (trim($route) == '') { $form_err = "Can't Add Blank R&amp;T"; }
                if (preg_match("/\D/",$route)) { $form_err = "R&amp;T must be numeric"; }
                if (trim($form_err) == "") {
                    $query = "insert into cualtroute values ('$cu','$route')";
                    $result = db_query($query, $link);
                    if ($result) {
                        $form_err = "R&amp;T $route Added";
                    } else {
                        $form_err = "Error encountered Adding R&amp;T with sql $query";
                    }
                }
                break;
    }
if ($act != 'getcu') {
# Fall through for 'show' or if nothing else picked

                $query = "select * from cualtroute where cu = '$cu'";
                $result = db_query($query, $link);

                $num_rows = db_num_rows($result);

                $query = "select rt, count(*) from cuovermicr where cu = '$cu'
                                    group by rt";
                $cnt_res = db_query($query, $link);

                $used=array();
          for ($row=0;list($usedrt, $count) =
                      db_fetch_array($cnt_res,$row); $row++) {
                    $usedrt = trim($usedrt);
          $used["$usedrt"]++;
        }


            cu_header("CU Alternate R&amp;T");

            print <<<EOF
                    <div align='right'>
          <form name='clwin'>
                    <script language='JavaScript'>
<!--
                    if (window.close)
                    document.write('<input type=\"button\" value=\"Close Window\" onClick=\"window.close()\">');
                    //-->
</script>
              </form>&nbsp;</div>
            <form name='rtform' action="$self?act=save" method="post">
            <center>
            <table cellpadding="1" cellspacing="0" border="0" width="350">
                <tr>
                    <td colspan="3" class="hdrc">$cu Alternate R&amp;T
                    </td>
                </tr>
                <tr><td class='dtll' colspan='3'><font color='red'>$form_err</font></td></tr>
                <tr>
                    <td class="dtlr">
                        Add R&amp;T Number:
                    </td>
                    <td class='dtll'>
                            <input type="hidden" name="cu" value="$cu">
                            <input type="text" name="route" size="15" maxlength="9" value="">
                    <td class='dtlc'>
                        <input type="submit" name="Save" Value="Save">
                    </td>
                </tr>
EOF;
if ($result) {
            print "<tr><td class='hdrc' colspan='3'><hr></td></tr>";
   for ($row=0;list($cu, $route) = db_fetch_array($result,$row); $row++) {
                $cu = trim($cu);
                $route = trim($route);
                print "<tr>
                    <td class='dtlr'>";
                    if ($used["$route"]) {
                        print "[In Use]&nbsp;";
                    } else {
                        print
                            "<a href='$self?act=delete&cu=$cu&route=$route'>Remove</a>&nbsp;";
                    }
                    print "</td>
                    <td nowrap class='dtll'> $route </td>
                    <td class='dtlr'>&nbsp;</td>
                </tr>";
        }
}
            print <<<EOF
            </table>
    </form>
    </body>
</html>
EOF;

}