resetPktstamp.prg

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

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

$dbh = $link;

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('cu' => 'string', 'w' => 'string', 'msg' => 'string');

dms_import($dms_ok);

switch ($w):

    case "1":
        cu_header("Set Packet Stamps for Full-packet Refresh");

        $sql = "SELECT COUNT(user_name) FROM {$cu}user";
        $cnt_rs = db_query($sql, $dbh);
        list($usercount) = db_fetch_array($cnt_rs);
        db_free_result($cnt_rs);

        $sql = "SELECT COUNT(accountnumber) FROM {$cu}memberacct";
        $cnt_rs = db_query($sql, $dbh);
        list($memcount) = db_fetch_array($cnt_rs);
        db_free_result($cnt_rs);
        ?>
        <form action="<?php echo $_SERVER['PHP_SELF']; ?>?cu=<?php echo $cu; ?>" method="post">
            <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>
                                    Set Packet Stamps for Full-packet Refresh
                                </td>
                            </tr>
                            <?php if ($memcount == 0): ?>
                                <tr>
                                    <td class='dtl' align=center>
                                        <br>No member accounts found!<br>Please check CU code and try again
                                    </td>
                                </tr>
                            <?php else: ?>
                                <?php if (isset($msg)): ?>
                                    <tr>
                                        <td class='dtl' align=center>
                                            <br><?php echo $msg; ?>
                                        </td>
                                    </tr>
                                <?php else: ?>
                                    <tr>
                                        <td align=center class='dtl'>
                                            <font size="3" color="red">
                                            WARNING!<br>
                                            This will set all member accounts at <?php echo $cu; ?> to request a full-refresh packet.<br>Be sure this is what you want to do.
                                            </font>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class='dtl' align=center>
                                            <table border=0 cellpadding=0 cellspacing=0>
                                                <tr>
                                                    <td class="dtl" align="left">
                                                        &nbsp;Current Users:&nbsp;
                                                    </td>
                                                    <td class="dtl" align="right">
                                                        &nbsp;<?php echo $usercount; ?>&nbsp;
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td class="dtl" align="left">
                                                        &nbsp;Current Member Accounts:&nbsp;
                                                    </td>
                                                    <td class="dtl" align="right">
                                                        &nbsp;<?php echo $memcount; ?>&nbsp;
                                                    </td>
                                                </tr>
                                            </table>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class='dtl' align=center>
                                            <hr>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class='dtl'>
                                            Are you sure you want to reset packet stamps for member accounts at <?php echo strtoupper($cu); ?>?
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class='dtl'>
                                            <input type="submit" value="Yes, please do it NOW!!" name="btnVerify">
                                        </td>
                                    </tr>
                                <?php endif; ?>
                            <?php endif; ?>
                        </table>
                    </td></tr></table>
        </form>
        </body>
        </html>

        <?php
        break;
    case "2":

        // *** SANITY CHECK THE CREDIT UNION ID
        $sql = "SELECT trim(cu) FROM cuadmin WHERE user_name = '" . prep_save($cu) . "'";
        $cu_rs = db_query($sql, $dbh);
        list($cu_code) = db_fetch_array($cu_rs);
        db_free_result($cu_rs);

        if ($cu_code != "") {
            // ** I HAVE THE CODE -- UPDATE THE memberacct, accountbalance and loanbalance tables
            $upd_sql = "";
            $upd_sql .= "UPDATE {$cu_code}accountbalance SET balance_stamp = 1, history_stamp = 1;";
            $upd_sql .= "UPDATE {$cu_code}loanbalance SET balance_stamp = 1, history_stamp = 1;";
            $upd_sql .= "UPDATE {$cu_code}memberacct SET balance_stamp = 1;";            

            if ($upd_rs = db_query($upd_sql, $dbh)) {
                $upd_msg = "I have reset packet stamps for  " . db_affected_rows($upd_rs) . " member accounts.  I hope this helped.";
            } else {
                $upd_msg = "The member accounts were NOT updated.  Please contact a system administrator to update the member accounts.";
            }
        } else {
            // *** CU CODE NOT VALID
            $upd_msg = "The credit union code is NOT valid.  Please contact a system administrator to update the member accounts.";
        }

        header("Location: {$_SERVER['PHP_SELF']}?cu={$cu}&msg=" . urlencode($upd_msg));
        exit;
        break;
endswitch;
?>