cuStatus.prg

<?php
$monLibrary= dirname(__FILE__) . "/../library";
$sharedLibrary= dirname(__FILE__) . "/../../shared/library";
require_once("$monLibrary/cu_top.i");
require_once("$monLibrary/ck_hticket.i");
require_once("$monLibrary/cu_pass.i");
require_once("$sharedLibrary/errormail.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('action'=>'string','msg'=>'string','offlinestat'=>'string','offlineblurb'=>'string','rowid'=>'string','livebatch'=>'string');

dms_import($dms_ok);

$self = $_SERVER['PHP_SELF'];

    $dbh = $link;
if (isset($action)) {
  $msg="";
# validate entries if needed; set $msg for error conditions

  if (empty($msg)){
    $sql= "update cuadmin set offlinestat='$offlinestat',
                     offlineblurb='" . prep_save($offlineblurb) . "'
           where  user_name='$rowid'";
    $sth = db_query($sql,$dbh);
    if (!$sth) {
      $msg= "Unable to update status";
      $notify = new ErrorMail;
      $notify->mailto='miki@homecu.net';
      $notify->replyto='miki@homecu.net';
      $notify->subject='Error updating status';
      $notify->msgbody =  "\tUnable to update status\n\n";
      $notify->msgbody .= "Cu:   $rowid\n";
      $notify->msgbody .= $sql;
      $notify->file = __FILE__;
      $notify->cu = $rowid;
      $notify->SendMail();

    } else {
      db_free_result($sth);

            cu_header("Status Updated");
      cu_message("Succeeded<br>Status successfully updated");
            cu_footer();
    exit;

      }
  }
}
            $sql = "select offlinestat, offlineblurb, livebatch
                            from cuadmin where user_name ='$rowid';";
            $sth = db_query($sql, $dbh);
      if ($sth) {
                $row=db_fetch_array($sth);
cu_header("$rowid Status Change");

print <<<EOF
  <script language="javascript">
        function val_save() {
        var err_msg = "";

            if (document.forms['status'].elements['offlinestat'].selectedIndex == 0)
                    err_msg += "Offline Status must be selected.\\n";

            if (document.forms['status'].elements['offlinestat'].value == 'R' && document.forms['status'].elements['livebatch'].value == 'L')
                    err_msg += "Read-Only Status is for Batch Systems only.\\n";

            if (err_msg != "") {
                    err_msg += "\\nPlease correct errors to continue.\\n";
                    window.alert(err_msg);
                    return false;
            }
            else {
                    return true;
            }
        }
        function showblurb() {

            var idx= document.forms['status'].elements['reason'].selectedIndex;
            var msg= document.forms['status'].elements['reason'][idx].text;
            document.forms['status'].elements['offlineblurb'].value =
                '<h2>' + msg + '</h2>';

            return true;
        }
</script>
<CENTER>
      <FORM NAME=status ACTION="${self}" METHOD=post>
      <TABLE BORDER=0 width="90%" cellpadding=3 cellspacing=0 class='dmsbg'><tr><td>
      <TABLE BORDER=0 width="100%" cellpadding=2 cellspacing=0 bgcolor=white>
      <TR><TD CLASS="bar" align="center" colspan=3>$rowid Status Change</TD></TR>

EOF;
            if (db_num_rows($sth) == 0) {
                print <<<EOF
                    <tr>
                        <td class='dtl' align=center>Missing cuadmin record for $rowid</td>
                    </tr>
     </table>
         </td></tr></table>
      </FORM>
      </BODY></HTML>
EOF;
            } else {
                print <<<EOF
                    <tr><td class='hdr' align=right valign='top'>Offline Status: </td>
                        <td class='dtl' align=left><select name="offlinestat" size="5">
                            <option value=""
EOF;
                    if (trim($row['offlinestat']) == '') { print ' selected'; }
                    print ">&lt;&lt;Select&gt;&gt;</option>
                            <option value='N'";
                    if (trim($row['offlinestat']) == 'N') { print ' selected'; }
                    print ">Active</option>
                            <option value='U'";
                    if (trim($row['offlinestat']) == 'U') { print ' selected'; }
                    print ">Offline (Auto Up)</option>
                            <option value='Y'";
                    if (trim($row['offlinestat']) == 'Y') { print ' selected'; }
                    print ">Offline (Stay Down)</option>
                            <option value='R'";
                    if (trim($row['offlinestat']) == 'R') { print ' selected'; }
                    print ">Read-Only</option>
                        </select>";
print <<<EOF
                            <font color="green" size="2">Read-Only is for Batch systems</font>
</td></tr>
                    <tr><td class='hdr' align=right valign='top'>Offline Message: </td>
                        <td class='dtl' align=left>
<select name='reason' size='4' onChange='showblurb(this)'>
<option value='noconnect'>We are unable to access your information at this time. Please try back later.</option>
<option value='working'>We are working on the system.  Please try again later.</option>
<option value='maintenance'> We are currently down for system maintenance.  Please try again later.</option>
<option value='upgrade'> We are currently down for a system upgrade.  We expect to be back at               .  Please try again then.</option>
<option value='badlink'>You have followed an outdated link.  Please return to the credit union home page for home banking access.</option>
</select>
<br><input type="text" size=110 maxlength=255 name="offlineblurb" value="${row['offlineblurb']}"></td></tr>
                    <tr><td colspan="2" class='bar'>&nbsp;</td></tr>

      <TR>
            <td class='dtl'>&nbsp;</td>
      <TD CLASS="dtl" colspan=2>
      <input type=hidden name="action" value="Change Status">
      <input type=hidden name="rowid" value="$rowid">
      <input type=hidden name="livebatch" value="${row['livebatch']}">
            <input type="submit" value="Change Status" name="BtnSubmit" onclick="return val_save();">
     </table>
         </td></tr></table>
      </FORM>
      </BODY></HTML>

EOF;
}
}
?>