tr_hist.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('w'=>'digits','user_name'=>'string','wc'=>'string','set_trunc'=>'string','unset_trunc'=>'string');

dms_import($dms_ok);

    if (isset($w) == false || $w > 2) $w = "1";

    $dbh = $link;

    switch ($w):

        case "1":
            cu_header("Truncate History");
            $sql = "SELECT histtrunc FROM cuadmin WHERE user_name = '$user_name'";
            $sql_rs = db_query($sql, $dbh);
            $sql_row = db_fetch_array($sql_rs, 0);
            $tr_hist = $sql_row['histtrunc'];

?>
            <form action="tr_hist.prg" method="post">
            <input type="hidden" value="<?php echo $user_name; ?>" name="user_name">
            <input type="hidden" value="<?php echo $wc; ?>" name="wc">
            <input type="hidden" value="2" name="w">
            <table border=0 align=center cellpadding=3 cellspacing=0 width=500 class="dmsbg"><tr><td>
            <table border=0 cellpadding=1 cellspacing=0 width="100%" bgcolor=white>
                <tr>
                    <td class='bar' align=center>
                        Truncate History
                    </td>
                </tr>
                <tr>
                    <td align=center class='dtl'>
                        <font size="4" color="red">
                            WARNING!<br>
                          This will delete the history records of this Credit Union.  <br>Be sure this is what you want to do
                        </font>
                    </td>
                </tr>
                <tr>
                    <td class='dtl'>
                        Currently truncate history is set to <span style="font-weight: bold; color: red;" class="err2"><?php echo ($tr_hist == 1 ? "YES" : "NO"); ?></span>
                    </td>
                </tr>
                <tr>
                    <td class='dtl'>
                        Truncate history the next time this credit union is uploaded?
                    </td>
                </tr>
                <tr>
                    <td class='dtl'>
                        <input type="submit" value="Yes" name="set_trunc">
                        <input type="submit" value="No" name="unset_trunc">
                    </td>
                </tr>
            </table>
            </td></tr></table>
<?php
            break;
        case "2":
            // This part of the form will be used for saving the flag
            if ((isset($set_trunc) || isset($unset_trunc)) && isset($user_name)) {
                if (isset($set_trunc))
                    $val= "1";
                else
                    $val = "0";
                $sql = "UPDATE cuadmin SET histtrunc = '$val' WHERE user_name = '$user_name'";
                if (!$sql_rs = db_query($sql, $dbh))
                    $err = true;
                else
                    $err = false;
            }
            else
                $err = true;

            if ($err == true) {
                cu_header("Truncate History");
                print ("<form>");
                cu_message("Unexpected errors!<br>Try again.");
            }
            else {
                // Redirect to the main page
                header("Location: $infourl/hcuadm/cuview.prg?user_name=$user_name&wc=$wc");
                exit;
            }
?>

<?php
        break;
    endswitch;
?>

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