stmtupload.prg

<?php
    // This file will upload a file for the credit union
    // It will perform the following functions

    // Process File
    // Redirect User
    // Exit File Exists
    // Exist Size Error
    // Print a form for upload

    require_once ("$admLibrary/ck_aticket.i");        // Just a precaution to make sure that it is processed through the cookie

/**
 * function GetSelf()
 * @return The URL of this script.
 */
function GetSelf() {
    return "main.prg?ft=86";
}

$string= array("filter" => FILTER_DEFAULT);
$parameters = array("a" => array());
HCU_ImportVars($parameters, "a", array("action" => $string, "period" => $string));
extract($parameters["a"]);

$action = isset($action) ? trim($action) : "";
$period = isset($period) ? trim($period) : "";

    $ccname = 'CREDIT CARD';
    if (preg_match("/^$ccname/",$period)) {
        $saved_file = "$home_path/tmp/{$chome}ccard.daz";
    } else {
        $saved_file = "$home_path/tmp/{$chome}stmnt.daz";
    }

    // Check to make sure when they upload a file that a valid period is selected
    if ($action != '') {
        if (!$period || $period == 'Select') {
            $msg = "You must select a Statement Period.";
            $action = "";        // Force the action to blank so it falls through the default section
        }
    }
    switch ($action) {
        case "uploadFile":
            $fileArray = $_FILES["files"]; // With only one file, the array is that file.
            // Don't allow a file size of 0 bytes
            if (!is_uploaded_file($fileArray['tmp_name']) || ($fileArray['size'] < 1)) {
                // A problem occurred record the information that I know and mail it to mark@homecu.net
                // Gather msg together
                switch ($fileArray['error']) {
                    case 0:
                        $up_err = "0: No error, the file was uploaded successfully";
                        break;
                    case 1:
                        $up_err = "1: The upload is larger than the amount allowable by the upload_max_filesize directive in the php.ini";
                        break;
                    case 2:
                        $up_err = "2: The upload is larger than the MAX_FILE_SIZE directive that was specified via html";
                        break;
                    case 3:
                        $up_err = "3: The file was only partially uploaded";
                        break;
                    case 3:
                        $up_err = "4: no file was uploaded";
                        break;
                    default:
                        $up_err = "NOT SET";
                }
                $up_fe = (!file_exists("{$fileArray['tmp_name']}") ? "True" : "False");
                $msg = "
Upload File Error --\n
Client Information \n
    Client Filename: {$fileArray['name']}\n
    Client Filesize: {$fileArray['size']}\n
    Client Filetype: {$fileArray['type']}\n\n
    Client IP: {$_SERVER['REMOTE_ADDR']}\n\n
Web Server Information \n
    Temp File Name - {$fileArray['tmp_name']}
    Temp File exist - $up_fe\n
    Error Reported - $up_err\n\n

                            ";
                $notify = new ErrorMail;
                $notify->line = __LINE__;
                $notify->file = __FILE__;
                $notify->callingfunction = __FUNCTION__;
                $notify->sql = $msg;
                $notify->cu = "$Cu";
                $notify->survey = "";
                $notify->mailto = "mark@homecu.net";
                $notify->SendErr();
                // IF we got here, the file is NOT an uploaded file report an error

                // An error may occur here if the file is too large, this can be set in the php.ini file the variable is upload_max_filesize
                header('Content-type: text/plain');
                print HCU_JsonEncode(array("error" => array("File could not be uploaded.  Please retry.", "If the problem persists call HomeCU and report the problem."), "code" => 1));
            } else {
                $real_name = "";
        $find_ary = array("\\", "/", " ", ";");     // Create the list of characters for replacement
                $rpl_ary = array("", "", "", "");       // Create the list of characters that will be replacing

        $real_name = str_replace($find_ary, $rpl_ary, $fileArray['name']);

                // Now move the file from the temporary position into the credit unions /tmp directory
                if (!move_uploaded_file($fileArray['tmp_name'], $saved_file)) {
                    unlink ($fileArray['tmp_name']);
                } else {
                    // File was moved change the mod settings
                    $rc = @chmod($saved_file, 0644);
                }


                // MWS 2/27/03 -- before executing set the environment path for the users e-mail address
                $sql = "SELECT email FROM cuadmnotify
                                WHERE cu = '$Cu' AND role = 'esload'";
                $em_rs = db_query($sql, $dbh);
                list($esload) = db_fetch_array($em_rs, 0);
                db_free_result($em_rs);

                $sql = "SELECT email FROM cuadminusers
                                WHERE cu = '$Cu' AND user_name = '$Cn' ";
                $em_rs = db_query($sql, $dbh);
                list($email) = db_fetch_array($em_rs, 0);
                db_free_result($em_rs);
                if (trim($email) != '') { $esload = no_dupes("$email;$esload"); }
                putenv("ADMMAIL=$esload");

/*
 *  if $period starts with $ccname case insensitive, call the credcardload.pl script
 *  eventually, if $period is for tax forms (1099 or 1098) call the taxformload.pl script
 */

                $scriptDir = GetScriptDir();
                // The file was moved successfully
                if (preg_match("/^$ccname/",$period)) {
                    $command = "/usr/bin/nice -19 /usr/bin/env perl $scriptDir/ccardload.pl " . escapeshellcmd($home_path) ." \"{$period}\" >/dev/null &";
                } else {
                    $command = "/usr/bin/nice -19 /usr/bin/env perl $scriptDir/stmntload.pl " . escapeshellcmd($home_path) ." \"{$period}\" >/dev/null &";
                }

                $rc = exec ($command);

                // Now set a cookie for the filename that was last uploaded
                HCU_setcookie_env($SYSENV, "LastStmtName", $fileArray['name'], time()+60*60*24*30);


                header('Content-type: text/plain');
                print HCU_JsonEncode(array("error" => array(), "code" => 0, "data" => array("name" => $fileArray["name"], "size" => $fileArray["size"])));

            }
            break;
        default:

        // This is the default, which is to print the multi-part form for uploading
        # first, make sure the configuration file and the stmnt director exist
        if (!(is_readable("$home_path/bin/stmntload.cfg")
                    && is_dir("$home_path/stmnt"))) {
        # give error
            PrintFirstUploaded();

        } else {
                $lastUploadedFile = HCU_array_key_value('LastStmtName', $_COOKIE);
                $lastUploadedFile = $lastUploadedFile ? trim($lastUploadedFile) : "";

                $scriptDir = GetScriptDir();
                $command = "/usr/bin/nice -19 /usr/bin/env perl $scriptDir/stmntload_running_status.pl " . strtolower($Cu);
                $commandRs = exec($command);
                $commandStatusAry = explode("\t", $commandRs);
                $commandStatus = trim($commandStatusAry[0]);

                $lastUploadedStatus = 0;
                switch ($commandStatus) { // index 0 should always be our cases
                    case 'Error':
                    case 'Abort':
                        $lastUploadedStatus = 1; // failed during processing
                        break;
                    case 'Running':
                        $lastUploadedStatus = 2; // waiting or in processing
                        break;
                    case 'Norm/0':
                    case 'Undo/0':
                    default:
                        $lastUploadedStatus = 0; // success / no uploaded files
                        break;
                }

                // There is a 60 second delay before the upload process actually begins,
                // we must check for the existence of the .daz file.

                // If the .daz file exists, the upload process is currently running
                $cuLower = strtolower($Cu);
                if (is_dir("$home_path/tmp") && file_exists("$home_path/tmp/{$cuLower}stmnt.daz")) {
                    $lastUploadedStatus = 2;
                }

                PrintSelectUpload($lastUploadedFile, $lastUploadedStatus, GetPeriodData($home_path));
                break;
        }
    }

/**
 * function no_dupes($estring)
 * Function to check for duplicates in the eStatement string.
 *
 * @param $estring -- the eStatement string.
 * @return A string of eStatements.
 */
function no_dupes($estring) {
    $return = ""; // Prevent E_NOTICE.
    foreach (explode(";",$estring) as $x => $ema) {
        $ema = trim($ema);
        if ($ema != "" && (strpos("$return","$ema") === false)) {
            $return .= "$ema;";
        }
    }
    return $return;
}

/**
 * function return_bytes($val)
 * Function to return the bytes.
 *
 * @param $val -- the previous value.
 * @return The value in bytes.
 */
function return_bytes($val) {
    $val = trim($val);
    $last = strtolower($val[strlen($val)-1]);
    switch($last) {
        // The 'G' modifier is available since PHP 5.1.0
        case 'g':
            $val *= 1000;
        case 'm':
            $val *= 1000;
        case 'k':
            $val *= 1000;
    }
        return $val;
}

/**
 * function GetPeriodData($home_path)
 * This function replaces the old code for separating out data from the presentation.  Old code printed out HTML.  This is sent to a kendo Drop Down List.
 *
 * @param $home_path -- Where files for the CU live.
 * @return $periods -- Array of the options (text only.)  If credit cards are configured, then those show up in the list as well.
 */
function GetPeriodData($home_path) {
    $periodData = array();
    $ccname = GetCCName();

    $date = new DateTime();
    $thisyr = intval($date->format("Y"));
    $thisday = intval($date->format("d"));
    $thisMonthAbbrev = $date->format("M");
    $thismo = intval($date->format("n")) - 1;

    $date->modify("first day of last month");
    $lastmo = intval($date->format("n")) - 1;
    $lastMonthAbbrev = $date->format("M");
    $lastyr = intval($date->format("Y"));

    # Dec & after 24th, or Jan-May, or June & before 25th set 2nd half
    if (($thismo == 11 && $thisday > 24) || $thismo < 5 || ($thismo == 5 && $thisday < 25)) {
        $half = "2nd";
        $halfyr = ($thismo == 11 ? $thisyr : $thisyr - 1);
    } else {
        $half = "1st";
        $halfyr = $thisyr;
    }

    $periods = array("Select");
    $carpers = array();

    # if past mid month, show the current month
    if ($thisday > 15) {
        $periods[] = "$thisMonthAbbrev $thisyr";
        $carpers[] = "$ccname $thisMonthAbbrev $thisyr";
    }

    $periods[] = "$lastMonthAbbrev $lastyr";
    $carpers[] = "$ccname $lastMonthAbbrev $lastyr";

    $quarter = intval($thismo / 3);            // Get the calendar quarter we are in

    # if past mid month and current month ends a qtr, show the current quarter

    if ($thisday > 15 && $thismo % 3 == 2) {
        $periods[] = "Quarter " . ($quarter + 1) . " $thisyr";
        $carpers[] = "$ccname Quarter " . ($quarter + 1) . " $thisyr";
    }

    switch ($quarter) {
        case 0:
            $periods[] = "Quarter 4 ". ($thisyr - 1);
            $periods[] = "Quarter 3 ". ($thisyr - 1);
            $carpers[] = "$ccname Quarter 4 ". ($thisyr - 1);
            $carpers[] = "$ccname Quarter 3 ". ($thisyr - 1);
            break;
        case 1:
            $periods[] = "Quarter 1 $thisyr";
            $periods[] = "Quarter 4 ". ($thisyr - 1);
            $carpers[] = "$ccname Quarter 1 $thisyr";
            $carpers[] = "$ccname Quarter 4 ". ($thisyr - 1);
            break;
        default:
            $periods[] = "Quarter $quarter $thisyr";
            $periods[] = "Quarter " . ($quarter - 1) . " $thisyr";
            $carpers[] = "$ccname Quarter $quarter $thisyr";
            $carpers[] = "$ccname Quarter " . ($quarter - 1) . " $thisyr";
    }

    $periods[] = "$half Half $halfyr";
    $carpers[] = "$ccname $half Half $halfyr";

    # and now append so all Credit Card options are at the end of the list but only show if the credit card config is done
    if (is_readable(GetCCConfig($home_path))) {
        $periods = array_merge($periods, $carpers);
    }

    return $periods;
}

/**
 * function PrintSelectUpload($lastUploadedFile, $periodData)
 * Prints the page with kendo controls.
 *
 * @param $lastUploadedFile -- The value of the cookie to record that.  If it is non-empty, then there will be a "Last File Uploaded" line.
 * @param $periodData -- All the available options for the period Drop Down List.
 * @return nothing but prints out the page.
 */
function PrintSelectUpload($lastUploadedFile, $lastUploadedStatus, $periodData) { ?>
<script type="text/javascript">
    <?php getShowWaitFunctions(); ?>
    var maxSize = <?php echo return_bytes(ini_get("upload_max_filesize")); ?>;

    <?php
    /**
     * function OpenConfirmDialog(fileData)
     * Opens up a dialog to show that the file was successful.  If the dialog is not yet created, then also create it.
     *
     * @param fileData -- JSON array of the name and size of the file.
     */
    ?>
    function OpenConfirmDialog(fileData) {
        var dialog = $("#confirmDialog").data("kendoDialog");
        if (dialog == null) {
            dialog = $("<div id='confirmDialog'></div>").appendTo("body").kendoDialog({
                actions: [
                    {
                        text: "Okay", primary: true,
                        action: function() {
                            location.reload();
                        }
                    }
                ],
                visible: false,
                title: "File Successfully Uploaded"
            }).data("kendoDialog");
        }

        var template = kendo.template($("#confirmationTemplate").html());
        dialog.content(template(fileData)).open();
    }

    <?php
    /**
     * function Init()
     * Initializes all the controls for the page.
     */
    ?>
    function Init() {
        $.homecuValidator.setup({formValidate:'statementUploadDiv', formStatusField: 'formValidateDiv'});

        <?php
        /**
         * @var uploader
         * This is the kendo control for uploading the file.  It handles the call to upload and sends along the period selected.
         */
        ?>
        var uploader = $("#uploader").kendoUpload({
            async: {
                saveUrl: "<?php echo GetSelf(); ?>&action=uploadFile",
                withCredentials: true,
                autoUpload: false
            },
            multiple: false,
            showFileList: true,
            error: function(e)
            {
                hideWaitWindow();
                var response = e.XMLHttpRequest.responseText;
                $.homecuValidator.displayMessage("File upload failed.", $.homecuValidator.settings.statusError );
            },
            success: function(e)
            {
                hideWaitWindow();
                if (e.response.code != 0) {
                    $.homecuValidator.displayMessage(e.response.error, $.homecuValidator.settings.statusError );
                    e.preventDefault();
                    return false;
                } else {
                    OpenConfirmDialog(e.response.data);
                }

            },
            select: function(e) <?php // When a file is selected.  If we can prevent at this level, then the user doesn't have to click on the upload to know that the file is invalid. ?>
            {
                var error = "";

                try {
                      var file = e.files[0];

                      if (file.size > maxSize) {
                          throw "File exceeds the max size.";
                      }
                } catch(err) {
                    error = err;
                }

                if (error.length != "")
                {
                    $.homecuValidator.displayMessage(error, $.homecuValidator.settings.statusError );
                    e.preventDefault();
                    return false;
                }
            },
            upload: function(e) {
                var error = "";
                try {
                      if (periodDDL.value() == null || periodDDL.value() == "Select") {
                          throw "Period must be selected.";
                      }
                      var file = e.files[0];

                      if (file.size > maxSize) {
                          throw "File exceeds the max size.";
                      }
                } catch(err) {
                    error = err;
                }

                if (error.length != "") {
                    $.homecuValidator.displayMessage(error, $.homecuValidator.settings.statusError );
                    e.preventDefault();
                    return false;
                } else {
                    e.data = {period: periodDDL.value()};
                    showWaitWindow();
                }
            },
            localization: {
                select: "Select File"
            }
        }).data("kendoUpload");

        <?php
        /**
         * @var periodDDL
         * This is the kendo control for selecting the period.  It is checked to see if there is a selection on upload.
         */
        ?>
        var periodDDL = $("#periodDDL").kendoDropDownList({
            dataSource: {
                data: <?php echo HCU_JsonEncode($periodData); ?>
            },
            autoWidth: true
        }).data("kendoDropDownList");

        <?php
        /**
         * $(".clearBtn").click(function()
         * This is the click event for the clear button.  All it does is remove selections from the periodDDL and the uploader.
         */
        ?>
        $(".clearBtn").click(function() {
            uploader.clearAllFiles();
            periodDDL.value("Select");
            $.homecuValidator.validate(); <?php // Just clears the status div. ?>
        });

        <?php
        /**
         * $(".uploadBtn").click(function()
         * This is the click event for the upload button.  First it will check to see if there are selections.  After that, it starts the upload.
         */
        ?>
        $(".uploadBtn").click(function() {
            var errors = [];
            if (uploader.getFiles().length == 0) {
                errors.push("File must be selected.");
            }
            if (periodDDL.value() == null || periodDDL.value() == "Select") {
                errors.push("Period must be selected.");
            }

            if (errors.length > 0) {
                $.homecuValidator.displayMessage(errors, $.homecuValidator.settings.statusError );
            } else {
                $.homecuValidator.validate();
                uploader.upload();
            }
        });
    }

    $(document).ready(function() {
        Init();
    });
</script>
<style>
    #statementUploadDiv {
        max-width: 900px;
        margin-right: initial;
        margin-left: initial;
    }

    .k-clear-selected, .k-upload-selected, .k-upload-status {
        display: none !important;
    }
</style>

<?php
/**
 * <script type="text/x-kendo-template" id="confirmationTemplate">
 * This is a kendo template for the successful file upload dialog.
 */
?>
<script type="text/x-kendo-template" id="confirmationTemplate">
    <div class="container-fluid">
        <div class="row hcuSpacer">
            <div class="col-xs-12">
                Thank you for the upload.
            </div>
        </div>
        <div class="row hcuSpacer">
            <div class="col-xs-12">
                The file <b>#: name #</b> with a size of <b>#: size #</b> bytes was successfully uploaded.  It is now being processed.
            </div>
        </div>
        <div class="row hcuSpacer">
            <div class="col-xs-12">
                An email status will be sent to the Credit Union.
            </div>
        </div>
        <div class="row hcuSpacer">
            <div class="col-xs-12">
                If there are any errors, please do not resend your file.  Contact <b>HomeCU</b> for support.
            </div>
        </div>
    </div>
</script>
<div class="container-fluid vsgPrimary hcu-template" id="statementUploadDiv">
    <div class="row">
        <div id="formValidateDiv" class="k-block k-error-colored formValidateDiv" style="display:none;"></div>
    </div>
    <div class="row hcuSpacer">
        <h3 class="col-xs-12">Statement File Upload</h3>
    </div>
    <div class="well well-sm">
        <?php if ($lastUploadedFile != "") { ?>
        <div class="row hcuSpacer">
            <label class="col-xs-12 col-sm-3">Last File Uploaded</label>
            <div class="col-xs-12 col-sm-9">
                <?php echo $lastUploadedFile; ?>

                <?php if ($lastUploadedStatus == 2) { ?>
                <label>&nbsp;Processing...</label>
                <?php } else if ($lastUploadedStatus == 1) { ?>
                <label style="color: red;">&nbsp;Failed</label>
                <?php } ?>
            </div>
        </div>
            <?php if ($lastUploadedStatus == 2) { ?>
            <div class="row hcuSpacer hcu-secondary">
                <div class="col-xs-12 vsgSecondary hcu-note">Refresh the page to view the current processing status</div>
            </div>
            <?php } ?>
        <?php } ?>

        <?php if ($lastUploadedStatus < 2) { ?>
        <div class="row hcuSpacer">
            <label class="col-xs-12 col-sm-3">File Uploader</label>
            <div class="col-xs-12 col-sm-9">
                <input type="file" name="files" id="uploader" />
            </div>
        </div>
        <div class="row hcuSpacer">
            <label class="col-xs-12 col-sm-3">
                Statement Period
            </label>
            <div class="col-xs-12 col-sm-9">
                <div id="periodDDL"></div>
            </div>
        </div>
        <?php } ?>
    </div>
    <div class="row hcu-secondary hcuSpacer">
        <div class="col-xs-12 vsgSecondary hcu-note">
            The file you upload must include complete account numbers. If you have changed your settings to mask all or part of the account number,
            your file will not load correctly and may result in presenting eStatement information to the WRONG member!
        </div>
    </div>
    <?php if ($lastUploadedStatus < 2) { ?>
    <div class="hcu-edit-buttons k-state-default tabFooter">
        <a class="clearBtn" href="#">Clear</a>
        &nbsp;&nbsp;&nbsp;
        <a class="uploadBtn k-button k-primary" href="#">Upload</a>
    </div>
    <?php } ?>
</div>
<?php }

/**
 * function PrintFirstUploaded()
 * This function is called when the e-statement directory is not set up or the config file isn't readable.
 */
function PrintFirstUploaded() { ?>
<div class="container-fluid vsgPrimary hcu-template" id="statementUploadDiv">
    <div class="row hcuSpacer">
        <h3 class="col-xs-12">Statement File Upload</h3>
    </div>
    <div class="row hcuSpacer">
        <div class="col-xs-12">It looks like this is the first time you've uploaded eStatements.  The configuration files and directories could not be found.</div>
    </div>
    <div class="row hcuSpacer">
        <div class="col-xs-12">Please check with HomeCU first to get things set up right.</div>
    </div>
</div>
<?php }