hcu_prod_save.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('home_cu_code'=>'string','form_err'=>'string','hcu_form'=>'string','home_cu_desc'=>'string','err_msg'=>'string');
dms_import($dms_ok);

    // Setup a function to go back to the CU Edit form, if anything went wrong
    function save_fail($msg){
        global $user_name;
        printf("<script language=\"javascript\">\n");
            printf("document.forms[0].elements[\"form_err\"].value = '%s';\n", $msg);
            printf("document.forms[0].action=\"hcu_prod_edit.prg?home_cu_code=%s\";\n",urlencode($home_cu_code));
            printf("document.forms[0].method=\"post\";\n");
            printf("document.forms[0].submit();\n");
        printf("</script>");
        printf("\n</form>\n </body>\n </html>\n");
        exit();
        }

    cu_header("HomeCU Products");
?>

    <form action="hcu_prod_edit.prg" 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 -->

    <!-- Name -->
    <input type="hidden" name="home_cu_desc" value="<?php echo set_string($home_cu_desc) ?>">

    <!-- 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.

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

        $num_rows = db_num_rows($db_result);
        if ($num_rows > 0 )
        {
            // UPDATE the information into the table
            $qry_stmt = sprintf("UPDATE cuprodlist\n");
            $qry_stmt .= sprintf("SET home_cu_desc ='%s'\n",prep_save($home_cu_desc));
            $qry_stmt .= sprintf("WHERE home_cu_code = '%s'; \n",$home_cu_code);
        }
        else
        {
            $qry_stmt = sprintf("INSERT INTO cuprodlist \n");
            $qry_stmt .= sprintf("(home_cu_code, home_cu_desc) \n");
            $qry_stmt .= sprintf(" VALUES (\n");
            $qry_stmt .= sprintf("'%s', '%s');  \n",prep_save($home_cu_code), prep_save($home_cu_desc));

        }

        // 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
            printError(sprintf("<br>"));
            printError(sprintf("Error in executing {%s} query", $qry_stmt));
            printError(sprintf("<font face=\"Arial\" size=\"2\">Unable to Save Home CU Product Information!</font><br>"));
            save_fail($form_err);
            }
        else {
            header ("Location: /hcuadm/hcu_prod_list.prg?msg=" . urlencode("HCU Product Saved Successfully"));
            exit;
            //printError(sprintf("HCU Product Saved Successfully.<br>
        //      <a href=\"hcu_prod_list\" target=\"CONTENT\">HCU Product List</a>"));
        }
            /*
            <script language="javascript">
                parent.location = "hcu_prod_list";
            </script>
            */
        ?>
    <?php endif; ?>
</form>
</body>
</html>