uploadHist.prg

<?php


    print <<< print_html
        <style style='text/css'>
            .upl_alert {
                 background: #dddddd;
         color: #990000;
            }
        </style>
        <center>
        <table border=0 cellpadding=2 cellspacing=0 width="420">
            <tr><td colspan="3" class="">&nbsp;</td></tr>
            <tr>
                <td colspan="3" class="bar" align="center">
          Upload Status
                </td>
            </tr>
            <tr>
                <td class='hdr' width="100">
                    Upload ID
                </td>
                <td class='hdr' width="220">
                    Date of Upload
                </td>
                <td class='hdr' width="100">
                    Admin User
                </td>
            </tr>
print_html;

    // Now open a pipe to the file if one exists, if not then print that on the screen
    // First create the file string
    $exp_file = "$home_path/tmp/exportid.log";

    if (file_exists($exp_file)) {
        // Now we need to open a pipe
        $pipe = @popen("sort -rn " . escapeshellcmd($exp_file) . " | head -30 ", "r");

        if ($pipe) {
            $lst_upl = "-1";
            while (!feof($pipe)) {
                $seq_str = "";
                $rgb = ($rgb == "odd" ? "even" : "odd");
                $line_buffer = fgets($pipe, 4096);
                // Now we have the line, but we now need to spit into array pieces
                list($last_upload, $prior_upload, $settings, $date_upload,$exp_batches,$cuuser) = explode("\t", $line_buffer);
                if (trim($prior_upload) == '') {$prior_upload = $last_upload;}
                if ($lst_upl == "-1") {
                    $lst_upl = $last_upload;
                } else {
                    // Check to see if we have gone out of sequence
                    if ((intval($lst_upl) - 1) != $last_upload && intval($last_upload) != 0 && intval($prior_upload) != 0)
                        $seq_str = "*";

                    $lst_upl = $last_upload;
                }

                /* ** DETERMINE the settings for the upload -- break the settings up into 3 pieces
                    *   0 - Balance Files Loaded
                    * 1 - Full Refresh Performed
                    * 2 - Delete ALL Rows
                */
                $upl_set = explode(",", $settings);
                if ($upl_set[1] == "1") {
                    $rgb = "upl_alert";
                }
                print "
                    <tr>
                        <td class='$rgb'>
                            $last_upload $seq_str
                        </td>
                        <td class='$rgb' align=right>
                            $date_upload
                        </td>
                        <td class='$rgb' align=left>
                            $cuuser
                        </td>
                    </tr>";
            }
            fclose ($pipe);
            print "
                <tr>
                    <td colspan=2 class='$rgb'>
                        *  denotes possible missing batch, <br><span class='upl_alert'>red</span> denotes full refresh
                    </td>
                </tr>";
        } else {
            // File does NOT exist print this message to the screen
            print "
                <tr>
                    <td colspan=\"2\" class=\"ahd\">
                        Currently your credit union does not have any upload history.
                    </td>
                </tr> ";
        }
    } else {
        // File does NOT exist print this message to the screen
        print "
            <tr>
                <td colspan=\"2\" class=\"ahd\">
                    Currently your credit union does not have any upload history.
                </td>
            </tr> ";

    }
    print "</table>";
?>