restart.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('cuhome'=>'string','cu'=>'string','nounpack'=>'digits','delhist'=>'digits','skipbal'=>'digits','truncate'=>'digits','RestartCU'=>'string');
dms_import($dms_ok);

    /* Constants */
    function no_dupes($estring) {
        foreach (explode(";",$estring) as $x => $ema) {
            $ema = trim($ema);
            if ($ema != "" && (strpos("$return","$ema") === false)) {
                $return .= "$ema;";
            }
        }
        return $return;
    }


    function Check_Lock_Status($pFile_to_Check) {
        // Function - Check_Lock_Status
        // Purpose  - This function will check the lock status of the file named in pFile_to_Check.
        // Return   - This will return 'true' if fuser stated it was locked and 'false' if was NOT in use
        $upl_in_process = false;
        // *** FIRST THING....  CHECK LOCK STATUS OF status.txt FILE
        $ret_fuser = exec("/bin/fuser " . escapeshellcmd($pFile_to_Check));
        if ($ret_fuser != false) {
            $upl_in_process = true;
        }
        return $upl_in_process;
    }
    // ** Set the database handle
    $dbh = $link;

    cu_header('Upload Restart');

    // ** MWS 5/12/2009 - Check here to see if the upload is already in process.. If it is, do NOT allow restarting of the process
    $upl_in_process = false;

    // ** Using the cu passed in by the GET or POST.. This ends up using GLOBAL cu value
    // $sql = "select cu, user_name from cuadmin where user_name = '" . $cu . "'";
    // ** MWS 6/8/09 -- Problem with the cu variable.. The first pass it is lowercase and the second pass it is uppercase...
    // ** causing issues.. So lookup the information from cuadmin using the cu value.. but use it uppercase..
    $sql = "select cu, user_name from cuadmin where cu = '" . strtoupper($cu) . "'";

    $sth = db_query($sql, $dbh);
    if ($sth) {
        $row = db_fetch_array($sth);
        $row['cu'] = trim($row['cu']);
        $row['user_name'] = trim($row['user_name']);
        $cu = $row['cu'];
        $cuhome ="/home/" . $row['user_name'];
    } else {
        // ** ERROR
        ?>
            <p>
            <center>
            <center>
            <table width="80%" border=0 cellpadding=3 cellspacing=0 class="dmsbg"><tr><td>
            <table width="100%" border=0 cellpadding=2 cellspacing=0 bgcolor=white>
            <tr><td colspan=1 class="bar" align="center">
                 Problem Accessing Credit Union</td>
            </tr>
            <tr><td class='dtlc'><span style="font-size: 12pt;color: #990000;">An error was encountered.  The Credit Union upload was NOT restarted.  Please try again by using the 'Upload Restart' link on the left.</span></td>
            </tr>
            </table>
            </td></tr></table>
            </body>
            </html>
        <?php
        exit;
    }

    // ** Only check if cuhome is set.. This gets set when they press 'GO'
    // *** CHECK FOR USER ON .txt FILE
    $txt_path_file = "{$cuhome}/public_html/status.txt";


    $upl_in_process = Check_Lock_Status($txt_path_file);

    if ($upl_in_process) {
        // ** HERE -- I want to display a message to the user telling them they may not make changes at this time and their is a process currently
        // * Locking the upload status.txt file

    ?>
            <p>
            <center>
            <center>
            <table width="80%" border=0 cellpadding=3 cellspacing=0 class="dmsbg"><tr><td>
            <table width="100%" border=0 cellpadding=2 cellspacing=0 bgcolor=white>
            <tr><td colspan=1 class="bar" align="center">
                 Upload Already Restarted</td>
            </tr>
            <tr><td class='dtlc'><span style="font-size: 12pt;color: #990000;">The upload for <?php echo $cu; ?> is currently being processed.  Please check back later.</span></td>
            </tr>
            </table>
            </td></tr></table>
            </body>
            </html>
    <?php

    } else {

        if (isset($RestartCU)) {


            // ** NO lock on the status.txt file.. Either allow them to have option

            /* UPLOAD CODE HERE */
            $cmdopt = "-";
            if (isset($nounpack)) {
                 $cmdopt=$cmdopt."U";
            }
            if (isset($delhist)) {
                 $cmdopt=$cmdopt."D";
            }
            if (isset($skipbal)) {
                 $cmdopt=$cmdopt."B";
            }
            if (isset($truncate)) {
                 $cmdopt=$cmdopt."T";
            }
            $cmdopt = ($cmdopt=="-" ? "" : $cmdopt);

            $cuhome = escapeshellcmd($cuhome); /* to be safe */
            $command = "mv $cuhome/public_html/status.old.txt $cuhome/public_html/status.older.txt";
            system ($command);
            $command = "mv $cuhome/public_html/status.txt $cuhome/public_html/status.old.txt";

            system ($command);


                $sql = "SELECT role, email
                                FROM cuadmnotify
                                WHERE cu = '" . strtoupper($cu) . "'
                                    AND role in ('upload', 'alert') ";
                $em_rs = db_query($sql, $dbh);
                for ($row=0; $em_row = db_fetch_array($em_rs,$row); $row++) {
                    $role = trim($em_row['role']);
                    $$role = trim($em_row['email']);
                }
                db_free_result($em_rs);

                putenv("ADMUSER=HCUrestart");
                if ("$upload" != "" ) { putenv("ADMMAIL=$upload"); }
                if ("$alert" != "" ) { putenv("ALERTMAIL=$alert"); }
            // ** MWS 6/8/09 -- cu should be upper cased already because this is the second pass...but I want to upper it anyways..
            // ** And because this wasn't looking up the information correctly it was not using the
            $sql = "SELECT liveserver
                            FROM cuadmin
                            WHERE cu = '" . strtoupper($cu) . "'";

            $em_rs = db_query($sql, $dbh);
            list($pgloadcmd) = db_fetch_array($em_rs, 0);
            db_free_result($em_rs);
            if (trim($pgloadcmd) == '') {
                $pgloadcmd = "/usr/local/bin/pgload.pl -h $cuhome ";
            }
            $command = (escapeshellcmd("$pgloadcmd $cmdopt") . " >" . escapeshellcmd("$cuhome/public_html/status.txt") . " 2>&1 &");

            system ($command);


        ?>
            <p>
            <center>
            <table width="80%" border=0 cellpadding=3 cellspacing=0 class="dmsbg"><tr><td>
            <table width="100%" border=0 cellpadding=2 cellspacing=0 bgcolor=white>
            <tr><td colspan=2 class="bar" align="center">
                 Upload Restarted</td>
            </tr>
            <tr><td width="30%" class="hdr">Credit Union:</td>
                    <td width="70%" class='dtl'><?php echo $cu; ?></td>
            <tr><td width="30%" class="hdr">Command:</td>
                    <td width="70%" class='dtl'><?php echo $command; ?></td>
            </table>
            </td></tr></table>
            </body>
            </html>
        <?php
            exit;
        } else {

        /* If the user has not filled out the body of the message yet, present the form */
            /*
            // ** -- The following code was moved at the top before any processing..
            $sql = "select cu, user_name from cuadmin where user_name = '" . $cu . "'";
            $sth = db_query($sql, $dbh);
            if ($sth) {
                 $row=db_fetch_array($sth);
                 $row['cu']=trim($row['cu']);
                 $row['user_name']=trim($row['user_name']);
                 $cuhome="/home/".$row['user_name'];
            }
            */
            ?>

            <p>
            <center>
            <form action="<?php echo $_SERVER['PHP_SELF']?>" method="POST">
            <table width="80%" border=0 cellpadding=3 cellspacing=0 class="dmsbg"><tr><td>
            <table width="100%" border=0 cellpadding=2 cellspacing=0 bgcolor=white>
            <tr><td colspan=2 class="bar" align="center">
                 Upload Restart</td>
            </tr>
            <tr><td width="30%" class="hdr">Credit Union:</td>
                    <td width="70%" class='dtl'><?php echo $cu?></td>
            </tr>
            <tr>
            <tr><td width="30%" class="hdr">Home Directory:</td>
                    <td width="70%" class='dtl'><?php echo $cuhome?></td>
            </tr>
            <tr><td width="30%" class="hdr">Upload Options:</td>
                    <td width="70%" class='dtl'>

            <input type=checkbox name="nounpack"
            checked value="1">Skip Unpack (recommended)<br>
            <input type=checkbox name="skipbal"
            checked value="1">Skip Loading Balance Files<br>
            <input type=checkbox name="delhist"
            value="1">Delete History Prior to Inserting<br>
            <input type=checkbox name="truncate"
            value="1">Truncate History Files<br>
            </center>
            <form action="<?php echo $_SERVER['PHP_SELF']?>" method="POST">
            <input type="hidden" name="cu" value="<?php echo $cu?>">
            <input type="hidden" name="cuhome" value="<?php echo $cuhome?>">
            <input type="submit" name="RestartCU" value="GO">
            </td></tr>
            </table>
            </td></tr></table>
            </center>
<?php
        }
    }
?>
</body></html>