cuhavetrans.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'=>'digits','rowid'=>'string','cu_types'=>'array');

dms_import($dms_ok);

    if (!isset($act)) $act = 1;

    switch ($act):
        case 1:         // Edit Cu Transactions
            cu_header("Edit CU Transactions");
?>
            <form action="cuhavetrans.prg?act=2" method="post">
                <input type="hidden" name="rowid" value="<?php echo $rowid; ?>">
                <table border=0 cellpadding=1 cellspacing=1>
                    <tr><td colspan="2" align="center" class="bar">
                        Maintain Transaction Types
                    </td></tr>
                    <tr><td align=right class="hdr" valign="top">
                        Transcation Types Allowed:
                    </td>

                    <td valign="top" nowrap >
                        <select name="cu_types[]" multiple size="6">
                            <?php       // Create a query here to query the available
                                            // products from the cuprodlist table

                                $sql = "SELECT * FROM cutrans ORDER BY trandesc";
                                if ($sql_rs = db_query($sql, $link))
                                {
                                    //Items were found in the table so print them, otherwise leave options empty
                                    while($sql_row = db_fetch_object( $sql_rs, $row++)) {
                                        // For each row we'll need to add it to the list, and look it up in the cuproducts table to see if the user has it selected
                                        $trancode = htmlspecialchars(trim($sql_row->trancode));
                                        $trandesc = htmlspecialchars(trim($sql_row->trandesc));

                                        $item_select = "";
                                        $have_sql = "SELECT * FROM cuhavetrans WHERE cu = '$rowid' AND trancode = '$trancode'";

                                        if ($have_rs = db_query($have_sql, $link))
                                            if (db_num_rows( $have_rs) > 0)
                                                $item_select = "SELECTED";
                                        printf("<option value=\"%s\" %s>%s\n",$trancode, $item_select, $trandesc);
                                    }
                                }

                            ?>
                        </select>
                    </td></tr>
                    <tr><td class='hdr'>&nbsp;</td>
                    <td class='hdr'>
                        <input type="submit" value="Save" name="save">
                        <!-- <input type="button" value="Cancel" name="cancel" onclick="document.location='cumntc?action=fetch&rowid=<?php echo $rowid; ?>'"> -->
                        <input type="button" value="Cancel" name="cancel" onclick="document.location='$infourl/hcuadm/cuilist.prg'">
                    </td></tr>
                </table>
<?php
                break;
            case 2:
                // The purpose of this section is to save the items the user selected



                // Always delete any possible items from the cuproducts table for the specified user_name
                $save_sql = "DELETE FROM cuhavetrans WHERE cu = '$rowid'; ";

                // Now add back any selected items to the table
                if (isset($cu_types)) {
                    foreach ($cu_types as $value) {
                        $save_sql .= " INSERT INTO cuhavetrans VALUES ('$rowid', '$value'); ";
                    }
                }

                if (! db_query($save_sql, $link)) {
                    // Query Failed
                    printError(sprintf("<br>"));
                    printError(sprintf("Error in executing query<br>"));
                    printError(sprintf("<font face=\"Arial\" size=\"2\">Unable to Save Transcation Types!</font><br>"));
                }
                else {
                    // Query was successful
                // Go back to the Update Credit union screen
                    print <<< js_code
                    <script language="javascript">
                        //document.location = "cumntc?action=fetch&rowid=$rowid";
                        document.location = "$infourl/hcuadm/cuilist.prg";
                    </script>
js_code;
                }

                break;
            default:
        endswitch; ?>

    </form>
</body>
</html>