unlockbulk.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','chkCULock'=>'string');
$chkCULock = isset($chkCULock) ? trim($chkCULock) : "";

dms_import($dms_ok);

    // *** FIRST GET THE CREDIT UNION ID
    $sql = "SELECT cu, coalesce(retrylimit,5), coalesce(gracelimit,3)
                    FROM cuadmin
                    WHERE user_name = '" . prep_save($cu) . "'";
    $cu_rs = db_query($sql, $dbh);
    list($cu_code, $retry, $grace) = db_fetch_array($cu_rs);
    $cu_code = trim($cu_code);
    db_free_result($cu_rs);

    switch ($w):

        case "1":
            cu_header("Unlock Member Accounts");

            $sql = "SELECT COUNT(user_name) FROM {$cu_code}user
                WHERE failedremain = 0 OR (forcechange = 'Y' AND forceremain <= 0) OR ((userflags & 2::int = 2) AND forceremain <= 0)";
            $cnt_rs = db_query($sql, $dbh);
            list($login_fails) = db_fetch_array($cnt_rs);
            db_free_result($cnt_rs);

            $sql = "SELECT COUNT(user_name) FROM {$cu_code}user WHERE failedremain < 0";
            $cnt_rs = db_query($sql, $dbh);
            list($login_culock) = 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>
                        Unlock Members
                    </td>
                </tr>
                <?php if (isset($msg)): ?>
                    <tr>
                        <td class='dtl' align=center>
                            I have a message for you:<br><br><?php echo $msg; ?>
                        </td>
                    </tr>
                <?php endif; ?>
                <tr>
                    <td align=center class='dtl'>
                        <font size="4" color="red">
                            WARNING!<br>
                          This will unlock the members for <?php echo $cu; ?>.  <br>Be sure this is what you want to do.
                        </font>
                    </td>
                </tr>
                <tr>
                    <td class='dtl' align=center>
                        <table border=1 cellpadding=0 cellspacing=0>
                            <tr>
                                <td colspan="2" class="hdr" align="center">
                                    &nbsp;Current Locked Members&nbsp;
                                </td>
                            </tr>
                            <tr>
                                <td class="dtl" align="left">
                                    &nbsp;Failed Logins&nbsp;
                                </td>
                                <td class="dtl" align="right">
                                    &nbsp;<?php echo $login_fails; ?>&nbsp;
                                </td>
                            </tr>
                            <tr>
                                <td class="dtl" align="left">
                                    &nbsp;Credit Union Locked&nbsp;
                                </td>
                                <td class="dtl" align="right">
                                    &nbsp;<?php echo $login_culock; ?>&nbsp;
                                </td>
                            </tr>
                            <tr>
                                <td class="dtl" align="left">
                                    &nbsp;Total:&nbsp;
                                </td>
                                <td class="dtl" align="right">
                                    &nbsp;<?php echo ($login_fails + $login_culock); ?>&nbsp;
                                </td>
                            </tr>
                        </table>
                    </td>
                </tr>
                <tr>
                    <td class='dtl' align=center>
                        <input type='checkbox' name='chkCULock' value='Y'>Include members 'Locked by Credit Union'?
                    </td>
                </tr>
                <tr>
                    <td class='dtl' align=center>
                        <hr>
                    </td>
                </tr>
                <tr>
                    <td class='dtl'>
                        Are you sure you want to unlock the members for <?php echo strtoupper($cu); ?>?
                    </td>
                </tr>
                <tr>
                    <td class='dtl'>
                        <input type="submit" value="Yes, please do it NOW!!" name="btnUnlock">
                        <!-- <input type="submit" value="No" name="keep_daz"> -->
                    </td>
                </tr>
            </table>
            </td></tr></table>
                </form>
            </body>
            </html>
<?php
            break;
        case "2":


            // *** FIRST GET THE CREDIT UNION ID
            $sql = "SELECT cu, coalesce(retrylimit,5), coalesce(gracelimit,3)
                            FROM cuadmin
                            WHERE user_name = '" . prep_save($cu) . "'";
            $cu_rs = db_query($sql, $dbh);
            list($cu_code, $retry, $grace) = db_fetch_array($cu_rs);
            $cu_code = trim($cu_code);
            db_free_result($cu_code);

            if ($cu_code != "") {
                // ** I HAVE THE CODE -- UPDATE THE cuusers table

                // ** CREATE QUERY BASED ON OPTIONS
                if ($chkCULock == "Y") {
                    $sql_opr = "<=";
                } else {
                    $sql_opr = "=";
                }

                $upd_sql = "UPDATE {$cu_code}user SET forceremain = $grace, failedremain = $retry
                    WHERE failedremain $sql_opr 0 OR (forcechange = 'Y' AND forceremain <= 0) OR ((userflags & 2::int = 2) AND forceremain <= 0)";

                if ($upd_rs = db_query($upd_sql, $dbh)) {
                    $upd_msg = "I have unlocked " . db_affected_rows($upd_rs) . " members.  I hope this helped.";
                } else {
                    $upd_msg = "The members were NOT unlocked.  Please contact a system administrator to unlock the members.";
                }
            } else {
                // *** CU CODE NOT VALID
                $upd_msg = "The credit union code is NOT valid.  Please contact a system administrator to unlock the members.";
            }

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