cutrans.prg

<?php
    $monLibrary= dirname(__FILE__) . "/../library";
    $monIncludes= dirname(__FILE__) . "/../includes";
    require_once("$monLibrary/cu_top.i");
    require_once("$monLibrary/ck_hticket.i");
    require_once("$monIncludes/cu_remote_top.prg");

    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('trancode'=>'string','trandesc'=>'string','transpec'=>'string',
'Save'=>'string','form_err'=>'string','act'=>'string','tc'=>'string',
'msg'=>'string','Remote_Update'=>'array');

dms_import($dms_ok);

    if (!isset($act)) $act = "2";

    switch ($act):
        case "1":           // Edit Cu Transactions
            cu_header("Edit CU Transactions");
?>
            <form action="cutrans.prg?act=3" method="post">
            <?php
                // Connect to the database - get the team information from the database
                $query = "select *
                        from cutrans
                        where trancode = '$tc'";
                $result = db_query($query, $link);
                // Now fetch the row
                $cutrans_row = db_fetch_object($result);
                $num_rows = db_num_rows($result);
            ?>
            <p>&nbsp;
            <p>
            <?php
                if (isset($form_err) && strlen($form_err) > 0)
                    printf("\n<font color=\"red\">Errors found before saving the information.  Please review errors at bottom of screen.\n<p></font>");
            ?>
            <center>
            <table cellpadding="3" cellspacing="0" border="0" class="dmsbg" width="500"><tr><td>
            <table cellpadding="2" cellspacing="0" border="0" bgcolor=white width="100%">
                <tr>
                    <td colspan="2" class="bar" align="center">
                        <?php if($num_rows > 0): ?>
                            EDIT CU TRANSACTION CODE
                        <?php else: ?>
                            ADD CU TRANSACTION CODE
                        <?php endif; ?>
                    </td>
                </tr>
                <tr>
                    <td nowrap align="right" class="hdr">
                        CU Transaction Code:
                    </td>
                    <td nowrap  class='dtl'>
                        <?php if ($num_rows == 0): ?>
                            <?php
                                if ( isset($trancode))
                                    $cu_info = set_string($trancode);
                                else
                                    $cu_info = htmlspecialchars(trim($cutrans_row->home_cu_code));
                            ?>
                            <input type="text" name="trancode" size="4" maxlength="2" value="<?php echo $cu_info ?>">
                        <?php else: ?>
                            <?php echo $cutrans_row->trancode ?>
                            <input type="hidden" name="trancode" value="<?php echo htmlspecialchars(trim($cutrans_row->trancode)) ?>">
                        <?php endif; ?>
                    </td>
                </tr>
                <tr>
                    <td nowrap align="right" class="hdr">
                        Description:
                    </td>
                    <td nowrap  class='dtl'>
                        <?php
                            if ( isset($trandesc))
                                $cu_info = set_string($trandesc);
                            else
                                $cu_info = htmlspecialchars(trim($cutrans_row->trandesc));
                        ?>
                        <input type="text" name="trandesc" size="40" maxlength="40" value="<?php echo $cu_info ?>"><font color="green" size="2"><br>New descriptions should also be added to the message dictionary <br>for internationalized version.</font>
                    </td>
                </tr>
                <tr>
                    <td nowrap align="right" class="hdr">
                        Special Processing:
                    </td>
                    <td nowrap  class='dtl'>
                        <?php
                            if ( isset($transpec))
                                $cu_info = set_string($transpec);
                            else
                                $cu_info = htmlspecialchars(trim($cutrans_row->specialproc));
                        ?>
                        <input type="text" name="transpec" size="4" maxlength="1" value="<?php echo $cu_info ?>"><font color="green" size="2"><br>Set to 1 for Credit Card and other payments to outside entities.</font>
                    </td>
                </tr>
                <tr>
                    <td class='dtl'>&nbsp;</td>
                    <td nowrap class='dtl'>
                        <?php remote_update_list(); ?>
                    </td>
                </tr>
                <tr>
                    <td class='dtl'>&nbsp;</td>
                    <td nowrap class='dtl'>
                        <input type="submit" name="Save" Value="Save">
                        <input type="button" name="Cancel" Value="Cancel" onClick="document.location='cutrans.prg'">
                    </td>
                </tr>
            <?php // If the error value is here then print it at the end
                if (isset($form_err)) {
                    echo "<tr><td colspan=2 class='err'>$form_err</td></tr>";
                }
            echo "
                </table>
                </td></tr></table> ";
            break;
        case "2":
            cu_header("CU Transaction Codes");
            ?>
            <form>

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

                ?>

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

            <table border="0" cellpadding="3" cellspacing="0" align="center" width="500" class="dmsbg"><tr><td>
            <table border="0" cellpadding="2" cellspacing="0" align="center" width="100%" bgcolor=white>
                <tr>
                    <td colspan="4" class="bar" align="center">
                        CU TRANSACTION CODES LIST
                    </td>
                </tr>
                <?php if (isset($msg)): ?>
                    <tr>
                        <td colspan="5" class="msg" align="center">
                            <?php echo $msg; ?>
                        </td>
                    </tr>
                <?php endif; ?>
                <tr>
                    <td colspan="5" style="background:#f8f8f8;color: #ee5555;font-style:italic" align="left">
                        ** NOTE: The description for any 'Special Processing' transcation code MUST be added to the translation table
                    </td>
                </tr>
                <tr>
                    <td class="hdr" align="center">
                        CU Tranasction Code
                    </td>
                    <td class="hdr" align="center">
                        Description
                    </td>
                    <td class="hdr" align="center">
                        Special Processing
                    </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->trancode) ?>
                    </td>
                    <td nowrap >
                        <?php echo trim($prod_row->trandesc) ?>
                    </td>
                    <td nowrap align='center'>
                        <?php echo (trim($prod_row->specialproc) == '0' ? '' : trim($prod_row->specialproc)) ?>
                    </td>
                    <td nowrap >
                        <a href="cutrans.prg?act=1&tc=<?php echo trim($prod_row->trancode) ?>">Edit</a>
                        <?php /*&nbsp;|&nbsp;
                        <a href="">Delete</a>
                        */ ?>
                    </td>
                </tr>
                <?php
                    $RGB = ($RGB == "odd" ? "even" : "odd");
                    endwhile; ?>

                <tr>
                    <td colspan="3">
                        <a href="cutrans.prg?act=1">Add CU Transaction Code</a>
                        &nbsp;|&nbsp;
            <a href="<?php echo $infourl ?>/hcuadm/cuilist.prg" target="parent">Credit Union List</a>
                    </td>
                </tr>
            </table>
            </td></tr></table>
<?php
            break;
        case "3":
            cu_header("Save Transaction Code");
            // Setup a function to go back to the CU Edit form, if anything went wrong
            function save_fail($msg){
                global $trancode;
                printf("<script language=\"javascript\">\n");
                    printf("document.forms[0].elements[\"form_err\"].value = '%s';\n", $msg);
                    printf("document.forms[0].action=\"cutrans.prg?act=1&tc=%s\";\n", $trancode);
                    printf("document.forms[0].method=\"post\";\n");
                    printf("document.forms[0].submit();\n");
                printf("</script>");
                printf("\n</form>\n </body>\n </html>\n");
                exit();
                }

        ?>

            <form action="cutrans.prg?act=1" method="post">
            <?php
                $errors_found = "No";
                $err_msg = "";


                /* VALIDATE THE INFORMATION - whether it's been saved before or NOT
                    After validation fails it will send the information back to the edit form
                    So it looks like it did before, the fail information will be at the bottom of the
                    screen.

                */
                $err_msg="";

                // Now we need to load all the fields from the CU form, and post them back
                // So the user does not have to press the back button.
                // Load all the Fields from the previous form into hidden fields on this form
            ?>
                <!-- LOAD ALL HIDDEN FIELDS -->

                <!-- Description -->
                <input type="hidden" name="trancode" value="<?php echo set_string($trancode) ?>">
                <input type="hidden" name="trandesc" value="<?php echo set_string($trandesc) ?>">
                <input type="hidden" name="transpec" value="<?php echo set_string($transpec) ?>">

                <!-- Create a hidden field  for the form error -->
                <input type="hidden" name="form_err" value="">

                <?php if (strlen($err_msg) > 0): ?>
                    <?php
                     //If an error was found post the information back to the CU edit form here
                    $form_err = sprintf("<font size=\"+1\">ERROR!  Problems with the credit union information found: <BR></font>");
                    $form_err .= sprintf("The following errors will need to be corrected before you will be allowed to save the form.");
                    $form_err .= sprintf("<P> <font color=red>%s</font>", $err_msg);
                    save_fail($form_err);
                    ?>
                <?php else: ?>

                    <?php
                // Everything was validated, we now need to save the information, either insert for new or update for edited.

                    $save_sql = "SELECT trancode FROM cutrans WHERE trancode = '$trancode'";
                    // Execute the query and find out how many rows are in the query
                    $db_result = db_query($save_sql, $link);

                    $num_rows = db_num_rows($db_result);
                    if ($num_rows > 0 )
                    {
                        // UPDATE the information into the table
                        $qry_stmt = sprintf("UPDATE cutrans ");
                        $qry_stmt .= sprintf("SET trandesc ='%s', ",prep_save($trandesc));
                        $qry_stmt .= sprintf("specialproc ='%s' ",prep_save($transpec));
                        $qry_stmt .= sprintf("WHERE trancode = '%s'; ",$trancode);
                    }
                    else
                    {
                        $qry_stmt = sprintf("INSERT INTO cutrans ");
                        $qry_stmt .= sprintf("(trancode, trandesc, specialproc) ");
                        $qry_stmt .= sprintf(" VALUES (");
                        $qry_stmt .= sprintf("'%s', '%s', %s);  ",strtoupper(prep_save($trancode)), prep_save($trandesc), prep_save($transpec));

                    }
                    // Now pass the query to the Database
                    if (!($db_result=db_query($qry_stmt, $link))) {
                        // A problem was encoutered with saving the data - report the message
                        $form_err = sprintf("<br>");
                        $form_err .= sprintf("<font face=\"Arial\" size=\"2\">Unable to Save Home CU Transaction Code!</font><br>");
                        save_fail($form_err);
                    } else {
                        printError(sprintf("Transaction Code Saved Successfully.<br>
                            <a href=\"cutrans.prg?act=2\" target=\"CONTENT\">CU Transaction Code List</a>"));


                        if (Remote_Update_Selected()) {
                            // ** NOW CHECK FOR SAVING TO A REMOTE SERVER
                            // ** Add Each field that will be updated
                            Remote_Field_Add("cutrn", "trancode", $trancode);
                            Remote_Field_Add("cutrn", "trandesc", $trandesc);
                            Remote_Field_Add("cutrn", "transpec", $transpec);
                            // ** Need to create the url I am going to send to the remote server
                            $Remote_Results = Remote_Update_Send("U", "cutrn");
                            echo $Remote_Results;

                        }
                    }
                    header ("Location: " . $_SERVER['PHP_SELF'] . "?msg=" . urlencode($Remote_Results));

/*
                        print <<< js
                            <script language="javascript">
                                document.location = "cutrans.prg";
                            </script>
js;
*/
                    ?>
                <?php endif; ?>

    <?php
            break;
        default:
            cu_header("Error Displaying Form");
            print ("<form>");
            printError("Requested form not found!<br>Cancelling action.");
    endswitch;
    ?>
    </form>
    </body>
</html>