pdfupload.prg

<?php

/**
 * @author MWS <miki@homecu.net>
 * 4/1/2014
 * @package pdfupload
 *
 * Changed the MAX_FILE_SIZE from 4000000 to 10485760 for ALL pdf uploads
 *
 */

$parameters= array("a" => array("operation" => "", "filename" => ""));
$string= array("filter" => FILTER_SANITIZE_STRING);
HCU_ImportVars($parameters, "a", array("operation" => $string, "filename" => $string));
extract($parameters["a"]);

$self= "$menu_link?ft=$ft";

/**
 * @package Globals */

/**
 * @var integer $maxSize-- refers to the maximum size that the system will allow being uploaded to www3, www5, www6 */
$maxSize= 10485760;

/**
 * @var string $dataURL-- what is needed to reference this page. */
$dataURL= "$menu_link?ft=$ft";

/**
 * @var boolean $showSQL-- for debugging the sql. */
$showSQL= $SYSENV["devmode"];

/**
 * @var string $uploadPath-- the directory to save the files to. */
$uploadPath= "$home_path/public_html/pdf/";

/**
 * @var array $allowedFiles-- the particular files available.  Must be in this list to be uploaded.  $allowedFiles["files"]-- list of files (keys) and file to save (values),
 *      $allowedFiles["allowDelete"]-- boolean, if true, the removeFile button is visible when file is selected and the file is allowed to be deleted (if the URL is called directly)
 *      $allowedFiles["alwaysShow"]-- boolean, if true, the file allows shows in the list.  Normally, files are only shown if there is a version in the directory.  */

$allowedFiles= array(
    "HomeBanking" => array(
        "HomeBanking" => array(
            "Estatement Inserts" => "insert.pdf",
            "Privacy Policy" => "privacy.pdf",
            "Fee Schedule" => "fees.pdf"
        )
    ),
    "publicHTML" => array(
        "Newsletters" => array(
            "Regular Newsletter" => "newsletter.pdf",
            "Quarterly Newsletter" => "quarterlynews.pdf",
            "Youth Newsletter" => "kidsnews.pdf",
            "Prime Newsletter" => "primenews.pdf",
            "Senior Newsletter" => "seniornews.pdf",
            "Teen Newsletter" => "teennews.pdf",
            "Middle School Newsletter" => "middleschoolnews.pdf"
        ),
        "Miscellaneous (For information about linking documents, contact HomeCU.)" => array(
            "Loan Rates" => "lrates.pdf",
            "Savings Rates" => "srates.pdf",
            "Sales (Repo) List" => "forsale.pdf",
            "General Information" => "info.pdf",
            "Annual Report" => "annualreport.pdf",
            "Financial Statement" => "financials.pdf",
            "Skip-A-Payment Form" => "skip-pay.pdf",
            "Scholarship Application" => "scholarship.pdf",
            "Funds Availability" => "funds.pdf",
            "Holiday Schedule" => "holidays.pdf"
        )
    )
);

// DATABASE
$operation= trim($operation);
if ($operation != "")
{
    $notJSON= false;
    switch($operation)
    {
        case "uploadFile":
            $returnArray= uploadFile($uploadPath, $filename, $allowedFiles, $maxSize);
            break;
        case "removeFile":
            $returnArray= removeFile($uploadPath, $filename, $allowedFiles);
            break;
        case "readHomeBanking":
            $files= HCU_array_key_exists("HomeBanking", $allowedFiles) ? $allowedFiles["HomeBanking"] : array();
            $returnArray= getFileList($dbh, $Cu, $files, $uploadPath, "regular");
            break;
        case "readPublicHTML":
            $files= HCU_array_key_exists("publicHTML", $allowedFiles) ? $allowedFiles["publicHTML"] : array();
            $returnArray= getFileList($dbh, $Cu, $files, $uploadPath, "grouped");
            break;
        case "previewFile":
            printFilePreview($uploadPath, $filename, $allowedFiles);
            $notJSON= true;
            break;
        default: // Won't get here
            $returnArray= array("error" => array("Operation not specified: '$operation'"), "record" => array(), "sql" => array());
    }

    if (!$notJSON)
    {
        header('Content-type: application/json');
        print HCU_JsonEncode($returnArray);
    }

}
// Presentation
else
{
    ?>

    <script type="text/javascript">

    <?php
    // Include common functions
    getShowWaitFunctions();

    /**
     * @package Frontend */ ?>

    <?php
    /**
     * function openConfirmFileRemoval(tr)
     * Opens up the confirmation for deleting the file with options "No" and "Yes."  No resets the selection and does nothing else.  Yes removes the file from the table and the directory.
     *
     * @param HTMLElement tr -- the table row of the selection.  From this, I can get everything that I need.
     */
    ?>
    function openConfirmFileRemoval(tr)
    {
        var confirmFileRemoval= $("#confirmFileRemoval").data("kendoDialog");
        if (confirmFileRemoval == null)
        {
          confirmFileRemoval= $("<div id='confirmFileRemoval'></div>").appendTo("body").kendoDialog({
            title: "Confirm File Removal",
            actions: [
              {text: "No", action: function() {
                <?php // Action has been fired off.  Now reset to status before action. ?>
                var tr= $("#confirmFileRemoval").data("tr");
                var ddl= $(tr).closest(".k-grid").find(".k-grid-toolbar [data-role='dropdownlist']").data("kendoDropDownList");
                ddl.enable(false);
                ddl.value(1);
                $("[name='actionSelection']:checked").prop("checked", false);
              }},
              {text: "Yes", primary: true, action: function() {
                var tr= $("#confirmFileRemoval").data("tr");

                <?php // Action has been fired off.  Now reset to status before action. ?>
                var ddl= $(tr).closest(".k-grid").find(".k-grid-toolbar [data-role='dropdownlist']").data("kendoDropDownList");
                ddl.enable(false);
                ddl.value(1);

                $(tr).closest(".k-grid").data("kendoGrid").removeRow($(tr));
              }}
            ],
            visible: false,
            open: function() {
              if (window.activeWindows != null)
                window.activeWindows.push(this);
            },
            close: function() {
              if (window.activeWindows != null)
                window.activeWindows.pop();
            }
          }).data("kendoDialog");
        }

        var grid= $(tr).closest(".k-grid").data("kendoGrid");
        var dataItem= grid.dataItem(tr);
        confirmFileRemoval.content("<p>This file \"" + dataItem.filename + "\" will be deleted.</p><p>Are you sure you want to do this?</p>").open();
        $("#confirmFileRemoval").data("tr", tr);
    }

    <?php
    /**
     * function openUploadDialog(tr)
     * This opens up the dialog needed for upload.  If the uploader is not already initialized, then it intializes that.
     *
     * @param HTMLElement tr -- the table row of the selection.  From this, I can get everything that I need.
     */
    ?>
    function openUploadDialog(tr)
    {
        var uploadDialog= $("#uploadDialog").data("kendoDialog");
        var template= kendo.template($("#uploadTemplate").html());
        if (uploadDialog == null)
        {
          uploadDialog= $("<div id='uploadDialog'></div>").appendTo("body").kendoDialog({
            title: "Upload File",
            content: $("#uploadTemplate").html(),
            actions: [
              {text: "Cancel", action: function() {
                $("#uploader").data("kendoUpload").clearAllFiles();

                <?php // Action has been fired off.  Now reset to status before action. ?>
                var tr= $("#uploadDialog").data("tr");
                var ddl= $(tr).closest(".k-grid").find(".k-grid-toolbar [data-role='dropdownlist']").data("kendoDropDownList");
                ddl.enable(false);
                ddl.value(1);
                $("[name='actionSelection']:checked").prop("checked", false);
              }},
              {text: "Upload", primary: true, action: function() {
                $("#uploader").data("kendoUpload").upload(); <?php // Manually triggers the upload process. ?>
                return false;
              }}
            ],
            visible: false,
            open: function() {
                if (window.activeWindows != null)
                    window.activeWindows.push(this);
            },
            close: function() {
                $.homecuValidator.setup({formValidate:'pdfuploadDiv', formStatusField: 'statusDiv'});
                if (window.activeWindows != null)
                    window.activeWindows.pop();
            }
          }).data("kendoDialog");

          var uploader= $("#uploader").kendoUpload({
                async: {
                    saveUrl: "<?php echo $self; ?>&operation=uploadFile",
                    withCredentials: true,
                    autoUpload: false
                },
                multiple: false,
                showFileList: true,
                error: function(e)
                {
                    hideWaitWindow();
                    var response= e.XMLHttpRequest.responseText;

                    if (response.indexOf("PDFUploadFirstErrorLi") != -1)
                    {
                        $("#formValidateMainDiv").show();
                        $("#formValidateMainDiv").html("<p>The following errors were detected:</p><ul>" + response + "</ul>");
                    }
                    else
                    {
                        openAuthFailedDialog(response);
                    }

                    <?php // Action has been fired off.  Now reset to status before action. ?>
                    var tr= $("#uploadDialog").data("tr");
                    var ddl= $(tr).closest(".k-grid").find(".k-grid-toolbar [data-role='dropdownlist']").data("kendoDropDownList");
                    ddl.enable(false);
                    ddl.value(1);
                    this.clearAllFiles();
                },
                success: function(e)
                {
                    hideWaitWindow();
                    if (e.response.code == 0)
                    {
                        var tr= $("#uploadDialog").data("tr");
                        var grid= $(tr).closest(".k-grid").data("kendoGrid");
                        grid.dataSource.read();
                        this.clearAllFiles();
                        $("#uploadDialog").data("kendoDialog").close();
                    }
                    else
                    {
                        $.homecuValidator.displayMessage(e.response.error, $.homecuValidator.settings.statusError );
                        e.preventDefault();
                        return false;
                    }

                },
                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= "";
                    var tr= $("#uploadDialog").data("tr");

                    try
                    {
                        if ($(tr).length == 0)
                            throw "Please select a file.";

                        var file= e.files[0];
                        if (file.extension.toLowerCase() != ".pdf")
                            throw "File needs to be a PDF.";

                        if (file.size > <?php echo $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= "";
                    var tr= $("#uploadDialog").data("tr");

                    try
                    {
                        if ($(tr).length == 0)
                            throw "Please select a file.";

                        var file= e.files[0];
                        if (file.extension.toLowerCase() != ".pdf")
                            throw "File needs to be a PDF.";

                        if (file.size > <?php echo $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
                    {
                        showWaitWindow();
                        var grid= $(tr).closest(".k-grid").data("kendoGrid");
                        var dataItem= grid.dataItem($(tr));
                        e.data= {filename: dataItem.filename};
                        showWaitWindow();
                    }
                },
                localization: {
                    select: "Select File"
                }
            }).data("kendoUpload");

            $("#uploadBtn").click(function() { $("#uploader").click(); return false; });
            $("#uploadFileBtn").click(function() { $(".k-upload-selected").click(); return false; });
        }

        var grid= $(tr).closest(".k-grid").data("kendoGrid");
        var dataItem= grid.dataItem(tr);

        $("#uploadDialog").find(".filename").text(dataItem.filename);
        if (dataItem.modified == null)
            $("#uploadDialog").find(".modified").hide();
        else
        {
            $("#uploadDialog").find(".modified").show();
            $("#uploadDialog").find(".size").text(dataItem.size);
        }
        uploadDialog.open();
        $("#uploadDialog").data("tr", tr);
        $.homecuValidator.setup({formValidate:'uploadDialog', formStatusField: 'uploadStatusDiv'});
    }

    <?php
    /**
     * function openAuthFailedDialog(response)
     * This opens a dialog if the uploader fails.
     *
     * @param response -- the response from the uploader.
     */
    ?>
    function openAuthFailedDialog(response)
    {
        var authFailedDialog= $("#authFailedDialog").data("kendoWindow");
        if (authFailedDialog != null)
        {
            authFailedDialog.destroy();
            $("#authFailedDialog").empty();
        }

        authFailedDialog= $("#authFailedDialog").kendoWindow({
            content: {template: response.replace(/[#]/g, "\\#")}, // have to escape the # for kendo.
            draggable: false,
            visible: false,
            actions: [],
            modal: true,
            title: false,
            width: 400,
            resizable: false
        }).data("kendoWindow");

        authFailedDialog.open().center();
    }

    <?php
    /**
     * function openFileWindow(filename)
     * This opens the window for previewing the file.  The files are in PDF format so there is an iframe of the contents of the file.
     *
     * @param string filename -- the filename from the dataItem of the selection.
     */
    ?>
    function openFileWindow(filename)
    {
        var fileWindow= $("#fileWindow").data("kendoWindow");
        if (fileWindow == null)
        {
            var fileWindow= $("<div id='fileWindow'></div>").appendTo("body").kendoWindow({
                visible: false,
                open: function() {
                  if (window.activeWindows != null)
                    window.activeWindows.push(this);
                },
                close: function() {
                  if (window.activeWindows != null)
                    window.activeWindows.pop();
                },
                width: 600,
                title: "View File",
                modal: true
            }).data("kendoWindow");

            $("#fileWindow").on("click", ".closeBtn", function() {
                $("#fileWindow").data("kendoWindow").close();
            });
        }

        var template= kendo.template('<div class="hcu-template"><embed height="100%" width="100%" id="viewIframe" src="<?php echo $self; ?>&operation=previewFile&filename=#: filename #"'
            + 'type="application/pdf"><div class="hcu-edit-buttons k-state-default"><a class="closeBtn k-button k-primary" href="\\#"><i class="fa fa-check"></i>Close</a></div></div>');
        fileWindow.content(template({operation: "viewFile", filename: filename})).open().center();
    }

    <?php
    /**
     * function initGrids()
     * This function initializes the grids which is the first step.  All other functions run off of this one.
     */
    ?>
    function initGrids()
    {
        $.homecuValidator.setup({formValidate:'pdfuploadDiv', formStatusField: 'statusDiv'});
        var gridDefinition= {
            dataSource: {
                transport: {
                    read: null, <?php // There are two grids that are being created with different URLs. ?>
                    destroy: { url: "<?php echo $self; ?>&operation=removeFile", dataType: "json", type: "POST" },
                    parameterMap: function(data, type) {
                        switch(type)
                        {
                            case "read":
                                return {};
                            case "destroy":
                                return {filename: data.filename};
                        }
                    }
                },
                schema: {
                    model: {
                        id: "kendoId",
                        fields: {
                            kendoId: {type: "number"},
                            filename: {type: "string"},
                            modified: {type: "string"},
                            size: {type: "string"},
                            type: {type: "string"}
                        }
                    },
                    errors: "error",
                    data: "data",
                    groups: "data"
                },
                error: function(e) {
                    $.homecuValidator.displayMessage(e.errors, $.homecuValidator.settings.statusError );
                },
                requestEnd: function(e) {
                    hideWaitWindow();

                    <?php // Action has been fired off.  Now reset to status before action. ?>
                    var selected= $("[name='actionSelection']:checked");
                    if ($(selected).length > 0)
                    {
                        var ddl= $(selected).closest(".k-grid").find(".k-grid-toolbar [data-role='dropdownlist']").data("kendoDropDownList");
                        ddl.enable(false);
                        ddl.value(1);
                    }

                    if (e.type == "destroy" && this.options.serverGrouping)
                    {
                        this.read();
                    }
                }
            },
            columns: [
                {width: 30}, <?php // radio button. ?>
                {width: 30}, <?php // Preview icon. ?>
                {field: "filename", title: "Name"},
                {field: "modified", title: "Modified"},
                {field: "size", title: "Size"}
            ],
            editable: {
                mode: "inline",
                confirmation: false
            },
            remove: function(e) {
                this.dataSource.add({id: e.model.id, kendoId: e.model.kendoId, filename: e.model.filename, type: e.model.type, modified: null, size: null});
                this.dataSource.sync();
                <?php // Readds the record without modified and size. ?>
            }
        };

        var template= $("#rowTemplate").html();
        var hbTemplate= template.replace("#####", "");
        var phTemplate= template.replace("#####", "<td></td>"); <?php // for the grouping column. ?>
        gridDefinition.dataSource.transport.read= {url: "<?php echo $self; ?>&operation=readHomeBanking", dataType: "json", type: "POST"};
        gridDefinition.toolbar= "<div id='actionHomeBankingDDL'></div>";
        gridDefinition.rowTemplate= hbTemplate;
        var homeBankingGrid= $("#homeBankingGrid").kendoGrid(gridDefinition).data("kendoGrid");
        gridDefinition.dataSource.transport.read= {url: "<?php echo $self; ?>&operation=readPublicHTML", dataType: "json", type: "POST"};
        gridDefinition.toolbar= "<div id='actionPublicHTMLDDL'></div>";
        gridDefinition.rowTemplate= phTemplate;
        gridDefinition.columns.push({field: "type", hidden: true, groupHeaderTemplate: "#: value #"})
        gridDefinition.dataSource.group= {field: "type"};
        gridDefinition.dataSource.serverSorting= true;
        gridDefinition.dataSource.serverGrouping= true;
        gridDefinition.remove= undefined;
        var publicHTMLGrid= $("#publicHTMLGrid").kendoGrid(gridDefinition).data("kendoGrid");

        var ddlDefinition= {
            dataSource: [{text: "Action ...", value: 1}, {text: "Upload", value: 2}, {text: "Delete", value: 3}],
            enable: false,
            dataTextField: "text",
            dataValueField: "value",
            change: function(e) {

                var tr= $(this.wrapper).closest(".k-grid").find("tr:has([name='actionSelection']:checked)");
                switch(this.value())
                {
                    case 1: break; <?php // Nothing to do.  Shows the "placeholder." ?>
                    case 2:
                        openUploadDialog(tr);
                        break;
                    case 3:
                        openConfirmFileRemoval(tr);
                        break;
                }


            }
        };

        var actionHomeBankingDDL= $("#actionHomeBankingDDL").kendoDropDownList(ddlDefinition).data("kendoDropDownList");
        var actionPublicHTMLDDL= $("#actionPublicHTMLDDL").kendoDropDownList(ddlDefinition).data("kendoDropDownList");

        <?php // Here are click events on the radio buttons to activate the DDL and only show the valid options. ?>
        $("#homeBankingGrid,#publicHTMLGrid").on("click", "[name='actionSelection']", function() {
            var tr= $(this).closest("tr");
            var grid= $(tr).closest(".k-grid").attr("id");
            if (grid == "homeBankingGrid")
            {
                var ddl= $("#actionHomeBankingDDL").data("kendoDropDownList");
                var otherDDL= $("#actionPublicHTMLDDL").data("kendoDropDownList");
            }
            else
            {
                var otherDDL= $("#actionHomeBankingDDL").data("kendoDropDownList");
                var ddl= $("#actionPublicHTMLDDL").data("kendoDropDownList");
            }
            grid= $("#"+grid).data("kendoGrid");
            var dataItem= grid.dataItem($(tr));
            var filter= dataItem.modified == null ? {field: "value", operator: "neq", value: 3} : []; <?php // Cannot delete if there is no file there. ?>
            ddl.enable(true);
            ddl.dataSource.filter(filter);

            <?php // Make sure that other DDL is disabled.  (When the user selects one in one grid and then selects a row in the other grid.) ?>
            otherDDL.value(1);
            otherDDL.enable(false);
        });

        $("#homeBankingGrid,#publicHTMLGrid").on("click", ".pdfPreview", function() {
            var tr= $(this).closest("tr");
            var grid= $(tr).closest(".k-grid").data("kendoGrid");
            var dataItem= grid.dataItem($(tr));
            openFileWindow(dataItem.filename);
        });
    }

    $(document).ready(function() {
        initGrids();
    });
    </script>
    <?php printDeleteTemplate(); ?>
    <script id="rowTemplate" type="text/x-kendo-template">
        # var fileExists= modified != null; #
        <tr data-uid="#= uid #">
            #####
            <td><input type="radio" name="actionSelection"></td>
            <td># if (fileExists) { # <i class="fa fa-search pdfPreview showClickable"></i> # } else { # &nbsp; # } #</td>
            <td # if (!fileExists) { # colspan="3" # } #>#: filename #</td>
            # if (fileExists) { #
                <td>#= modified #</td>
                <td>#: size #</td>
            # } #
        </tr>
    </script>
    <script id="uploadTemplate" type="text/x-kendo-template">
        <div id="uploadStatusDiv"></div>
        <div class="container-fluid">
            <div class="row hcuSpacer vsgSecondary">Upload a file for <span class="filename"></span>.</div>
            <div class="modified" style="display:none;"><div class="row hcuSpacer vsgSecondary">Upload will overwrite another file with a size of <span class="size"></span>.</div></div>
            <div class="row hcuSpacer"><input type="file" name="files" id="uploader" accept="application/pdf" /></div>
        </div>
    </script>
    <style>
        .pdfuploadDiv ul{
            list-style-position: inside;
        }

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

    <div id="pdfuploadDiv" class="container-fluid pdfuploadDiv">
        <div id="statusDiv"></div>
        <div class="hcuSpacer hcu-no-padding">
            <div class="well well-sm col-xs-12">
                <div class="container-fluid">
                    <div class="row hcuSpacer h3">PDF File Upload</div>
                    <div class="row hcuSpacer">
                        Please Note:
                        <ul>
                            <li>Only one file of each type is allowed.  Prior copies will be overwritten.</li>
                            <li>File must be a valid <font color='red'>PDF document.</font></li>
                            <li>File must be no larger than <font color='red'>10MB</font> in size.</li>
                        </ul>
                        Contact HomeCU to set up additional upload links in the lists below. Supported uploadable files include:
                        <ul>
                            <li>Newsletters - General, Quarterly, Seniors, Teens, Kids, Middle School</li>
                            <li>Statement Inserts</li>
                            <li>Fee Schedule, Savings Rates, Loan Rates, Sales (Repo) Listing</li>
                            <li>Privacy Policy</li>
                            <li>Annual Report</li>
                            <li>Financial Statement</li>
                            <li>General Information</li>
                            <li>Skip-A-Payment Form</li>
                            <li>Scholarship Application</li>
                            <li>Funds Availability</li>
                            <li>Holiday Schedule</li>
                        </ul>
                    </div>
                </div>
            </div>
        </div>
        <div class="hcuSpacer hcu-no-padding">
            <div class="container-fluid">
                <div class="row hcuSpacer h4">Digital Banking Uploads</div>
                <div class="row hcuSpacer"><div id="homeBankingGrid"></div></div>
            </div>
        </div>
        <div class="hcuSpacer hcu-no-padding">
            <div class="container-fluid">
                <div class="row hcuSpacer h4">Public HTML Uploads</div>
                <div class="row hcuSpacer"><div id="publicHTMLGrid"></div></div>
            </div>
        </div>
    </div>
<?php }

/**
 * @package FUNCTIONS
 */

/**
 * function getFileList($dbh, $Cu, $files, $uploadPath, $mode)
 * Gets the list of file for the grids.
 *
 * @param $dbh -- the database connection
 * @param $Cu -- the credit union
 * @param $files -- array of files to look through
 * @param $uploadPath -- the path to look for files in
 * @param $mode --
 *      "grouped" -- if the kendoGrid uses grouping.
 *      "regular" -- the kendoGrid doesn't use grouping.
 *
 * @return array --
 *      $data -- List of files and attributes for the grid.
 *      $error -- List of errors encountered.
 *      $code -- Non-error if error encountered.
 */
function getFileList($dbh, $Cu, $files, $uploadPath, $mode)
{
    $fileList= array();
    $index= 0;
    $tz= null;
    $kbMin= 1024;
    $mbMin= 1024*1024;
    try
    {
        if (!is_writable($uploadPath))
            throw new exception("PDF Directory is not set up correctly.  Please contact HomeCU for assistance.");
        foreach($files as $typeName => $typeFiles)
        {
            foreach($typeFiles as $fileName => $filePath)
            {
                $fullPath= "${uploadPath}${filePath}";
                $modified= null;
                $size= null;

                if (is_readable($fullPath))
                {
                    // Get the modified timestamp from the file function and then convert it to the CU time in the right format.
                    $modified= DateTime::createFromFormat("U", filemtime($fullPath));
                    if (!isset($tz))
                        $tz= new DateTimeZone(GetCreditUnionTimezone($dbh, $Cu));
                    $modified->setTimezone($tz);
                    $modified= $modified->format("m/d/Y H:i:s");

                    $size= filesize($fullPath);
                    if ($size < $kbMin)
                        $size= "$size B";
                    else if ($size < $mbMin)
                        $size= round($size/$kbMin, 2) . " KB";
                    else
                        $size= round($size/$mbMin, 2) . " MB";
                }

                $row= array("kendoId" => ++$index, "filename" => $fileName, "type" => $typeName, "modified" => $modified, "size" => $size);
                if ($mode == "grouped")
                {
                    if (!HCU_array_key_exists($typeName, $fileList))
                        $fileList[$typeName]= array("field" => "type", "value" => $typeName, "items" => array(), "hasSubgroups" => false, "aggregates" => array());
                    $fileList[$typeName]["items"][]= $row;
                }
                else
                    $fileList[]= $row;
            }
        }

        if ($mode == "grouped")
            $fileList= array_values($fileList);

        return array("data" => $fileList);
    }
    catch(exception $e)
    {
        return array("error" => $e->getMessage(), "code" => $e->getCode());
    }
}

/**
 * function uploadFile($uploadPath, $filename, $allowedFiles, $maxSize)
 * This function uploads a file to the $uploadPath if validated.
 *
 * @param $uploadPath -- the path to upload file to.
 * @param $filename -- the title of the file.  This corresponds to the key in the array $allowedFiles.
 * @param $allowedFiles -- the array of files to search for filename in.
 * @param $maxSize -- if the size of the file is greater than this, this function returns an error message.
 *
 * @return array --
 *          $code -- zero if successful, non-zero otherwise.
 *          $error -- error message if not successful.
 */
function uploadFile($uploadPath, $filename, $allowedFiles, $maxSize)
{
    try
    {
        $fileErrors= array(
        "1" => "1: The file you tried to upload is just too big.  The allowable limit is 10MB.",
        "2" => "2: The file you tried to upload is just too big.  The allowable limit is 10MB.",
        "3" => "3: The file was only partially uploaded",
        "4" => "4: no file was uploaded");

        $thisFilePath= null;
        if (!isset($filename) || trim($filename) == "")
            throw new exception("Please select a file to upload.", 1);
        if (!is_writable($uploadPath))
            throw new exception("PDF Directory is not set up correctly.  Please contact HomeCU for assistance.", 2);
        foreach($allowedFiles as $gridType => $files)
        {
            foreach($files as $typeName => $typeFiles)
            {
                foreach($typeFiles as $fileName => $filePath)
                {
                    if (trim($fileName) == trim($filename))
                    {
                        $thisFilePath = $filePath;
                        break;
                    }
                }
                if (isset($thisFilePath))
                    break;
            }
        }

        if (!isset($thisFilePath))
            throw new exception("File isn't valid.", 3);

        $file = $_FILES['files'];

        if ($file["size"] > $maxSize)
            throw new exception("File exceeds the max size.", 4);
        if ($file["error"] != 0)
        {
            $errorInt= $file["error"];
            throw new exception(HCU_array_key_exists($errorInt, $fileErrors) ? $fileErrors[$errorInt] : "$errorInt: Unknown error.", 5);
        }

        $filetmp = $file['tmp_name'];
        $filemime = explode(";", trim(`file -bi $filetmp`));
        if (strtolower($filemime[0]) != "application/pdf")
            throw new exception("Wrong file type ( $filemime[0] ).  File must be PDF document.", 6);
        if (!@move_uploaded_file($filetmp, "${uploadPath}${thisFilePath}"))
        {
            @unlink ($filetmp);
            throw new exception("Couldn't post the file where it belongs.  Better call HomeCU.", 7);
        }

        @chmod("${uploadPath}${thisFilePath}", 0644);
        return array("code" => 0);
    }
    catch(exception $e)
    {
        return array("error" => $e->getMessage(), "code" => $e->getCode());
    }
}

/**
 * function removeFile($uploadPath, $filename, $allowedFiles)
 * This function removes a file if filename is found in $allowedFiles.  Otherwise, it does nothing.
 *
 * @param $uploadPath -- the path to remove file from.
 * @param $filename -- the title of the file.  This corresponds to the key in the array $allowedFiles.
 * @param $allowedFiles -- the array of files to search for filename in.
 *
 * @return array --
 *      $data -- If successful, this exists with two possibilities: "path found" or "path NOT found."
 *      $error -- the message text of an error if not successful.
 *      $code -- non-zero if not successful.
 */
function removeFile($uploadPath, $filename, $allowedFiles)
{
    try
    {
        $thisFilePath= null;
        if (!isset($filename) || trim($filename) == "")
            throw new exception("Please select a file to remove.", 3);
        if (!is_writable($uploadPath))
            throw new exception("PDF Directory is not set up correctly.  Please contact HomeCU for assistance.", 1);
        foreach($allowedFiles as $gridType => $files)
        {
            foreach($files as $typeName => $typeFiles)
            {
                foreach($typeFiles as $fileName => $filePath)
                {
                    if (trim($fileName) == trim($filename))
                    {
                        $thisFilePath= $filePath;
                        break;
                    }
                }
                if (isset($thisFilePath))
                    break;
            }
        }


        if (isset($thisFilePath)) // If file isn't find, treat that as a "success."  Nothing found so nothing deleted.
        {
            $fullPath= "${uploadPath}${thisFilePath}";
            if (@file_exists($fullPath) && !@unlink($fullPath)) // Not a problem if the file doesn't exist to begin with.
                throw new exception("File could not be deleted.  Better call HomeCU.", 2);
        }

        return array("data" => isset($thisFilePath) ? "path found" : "path NOT found");
    }
    catch(exception $e)
    {
        return array("error" => $e->getMessage(), "code" => $e->getCode());
    }
}

/**
 * function printFilePreview($uploadPath, $filename, $allowedFiles)
 * Shows the contents of a PDF if no errors.  Otherwise send JSON of errors.
 *
 * @param $uploadPath -- the path which the file is.
 * @param $filename -- the title of the file.  This corresponds to the key in the array $allowedFiles.
 * @param $allowedFiles -- the array of files to search for filename in.
 */
function printFilePreview($uploadPath, $filename, $allowedFiles)
{
    try
    {
        $thisFilePath= null;
        if (!isset($filename) || trim($filename) == "")
            throw new exception("Please select a file to remove.", 3);
        if (!is_writable($uploadPath))
            throw new exception("PDF Directory is not set up correctly.  Please contact HomeCU for assistance.", 1);
        foreach($allowedFiles as $gridType => $files)
        {
            foreach($files as $typeName => $typeFiles)
            {
                foreach($typeFiles as $fileName => $filePath)
                {
                    if (trim($fileName) == trim($filename))
                    {
                        $thisFilePath= $filePath;
                        break;
                    }
                }
                if (isset($thisFilePath))
                    break;
            }
        }

        if (!isset($thisFilePath))
            throw new exception("File doesn't exist.", 4);

        $fullPath= "${uploadPath}${thisFilePath}";
        if (!@is_readable($fullPath))
            throw new exception("File doesn't exist.", 2);

       $pdffile = fopen($fullPath, "r");
       $sArray=fstat($pdffile);
       $size=$sArray["size"];
       header("Content-Type: application/pdf");
       header("Content-length: $size");
       fpassthru($pdffile);
       pclose ($pdffile);
    }
    catch(exception $e)
    {
        header('Content-type: application/json');
        print HCU_JsonEncode( array("error" => $e->getMessage(), "code" => $e->getCode()));
    }
}