hcuRDCStatus.prg

<?php
/**
* @package hcuRDCStatus (RDC Status Table Inquiry)
*
* Purpose:  Shows content of CURDCSTATUS table records to assist in customer support for RDC from apps.
*
* NOTES:
* 1. No Updates allowed -- just read, filter, expand the json array
* 2. SPB 10/30/2015-- now uses monitorView.i
* 3. SPB 6/3/2016-- restyling to be consistent with loggingReport.  Added saving filter.
*/

  $monLibrary = dirname(__FILE__) . "/../library";
  $sharedLibrary = dirname(__FILE__) . "/../../shared/library";
  $bankingLibrary = dirname(__FILE__) . "/../../banking/library";
  require_once("$monLibrary/cu_top.i");
  require_once("$monLibrary/monitorView.i");
  require_once("$sharedLibrary/reporting.i");
  require_once("$sharedLibrary/commonJsFunctions.i");
  require_once("$sharedLibrary/commonPhpFunctions.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;
// }

$parameters = array("a" => array("operation" => "", "cu" => ""));
$string = array("filter" => FILTER_SANITIZE_STRING);
HCU_ImportVars($parameters, "a", array("operation" => $string, "cu" => $string));

$operation = HCU_array_key_exists("operation", $parameters["a"]) ? trim($parameters["a"]["operation"]) : "";
$cu = HCU_array_key_exists("cu", $parameters["a"]) ? strtoupper(trim($parameters["a"]["cu"])) : "";

$report = "rdcstatus";
$pageSize = 20;

/**
 * This might seem stupid but it is defined to use reports.i which is designed to have a whole list of possible reports.
 * @see the info block at the top of {@link hcuinc/reports.i}
 */
$reportList = array("rdcstatus" => array(
                      "title" => "Mobile RDC Inquiry",
                      "sql" => "select depositid, status, cu, accountnumber, amount, acctid, rdcvendor, starttime, lastupdate, frontaccept,
                                backaccept, vendorinfo, frontpath, backpath from curdcstatus where  (current_timestamp - lastupdate) < interval '20 days'",
                      "cols" => array("Deposit ID" => "number", "Status" => "list", "Cu" => "string", "Member" => "number", "Amount" => "currency",
                                      "Account" => "string", "Vendor" => "string", "Start" => "date", "Update" => "date", "Front" => "string", "Back" => "string",
                                      "info" => "ignore", "frontpath" => "ignore", "backpath" => "ignore"),
                      "ddl" => array("Status" => array("O" => "Open", "S" => "Session Started", "T" => "Terms Pending", "R" => "Rejected", "C" => "Completed",
                                                       "B" => "Blocked", "F" => "Failed")),
                      "defaultSort" => array(
                        array("field" => "update", "dir" => "desc"),
                        array("field" => "start", "dir" => "desc")
                      )
                    ));

// Configuration for data operations & presentation layer.
$self = $_SERVER["PHP_SELF"];
$defaultDateFormat = "MM/dd/yyyy HH:mm:ss";

// DATABASE
if ($operation != "") {
  switch ($operation) {
    case "readReport":
      ReadReport($cu, $dbh, $reportList, $defaultDateFormat);
      break;
    case "getImage":
      GetImage($dbh);
      break;
    default: // Won't get here
      header('Content-type: application/json');
      $returnArray = array("error" => array("Operation not specified: '$operation'"), "record" => "", "operation" => "");
      print HCU_JsonEncode($returnArray);
  }
} else {
// PRESENTATION
// Page for displaying the reports.
// **************************************************************
  $reportRecord = $reportList[$report];
  $title = !isset($reportRecord) ? "Unrecognized Report" : (isset($reportRecord["title"]) ? $reportRecord["title"] : $report);
  printMonitorPageTop($title, $homecuKendoVersion, $cloudfrontDomainName, $bootstrapVersion, $fontawesomeVersion, true);

  $filter = $cu == "" ? "" : HCU_JsonEncode(array("field" => "cu", "operator" => "eq", "value" => $cu));
?>

<style>
  .k-notification-wrap {
    overflow-x: scroll;
    overflow-y: visible;
  }

  .loggingArea {
    margin-left: 10px;
  }
  .loggingInfo {
    white-space: pre-wrap;
    width: 100%;
    margin-left: 10px;
  }

  .overflowDiv {
    overflow-x: auto;
    overflow-y: auto;
    max-height: 600px;
  }
</style>

<script type="text/javascript">

<?php
// Include common functions
getShowWaitFunctions();
GetIsFilterChanged();
InitReport($self, $report, $reportList, $defaultDateFormat, true, $pageSize, false, "", $filter);
?>

var inNotification = true;
var inShowClick = true;
var activeWindows = [];

<?php
/**
 * function OpenPopup(dataItem)
 * Opens up the detail modal for a row.
 *
 * @param Object dataItem -- the data for the row.
 */
?>
function OpenPopup(dataItem) {
  var template = kendo.template($("#popupTemplate").html());

  var popup = $("#detailPopup").data("kendoWindow");
  if (popup == null) {
    popup = $("<div id='detailPopup'></div>").appendTo("body").kendoWindow({
          modal: true,
          title: "Deposit Details",
          visible: false,
          draggable: false,
          resizable: false,
          maxWidth: 700,
          minWidth: 350,
          open: function() {
            if (window.activeWindows != null) {
              window.activeWindows.push(this);
            }
          },
          close: function() {
            if (window.activeWindows != null) {
              window.activeWindows.pop();
            }
          }
    }).data("kendoWindow");

    $("#detailPopup").on("click", ".imageLink", function() {
      var depositId = "depositId=" + Number($("#detailPopup").data("depositid"));
      var imageType = "imageType=" + ($(this).hasClass("front") ? "front" : "back");
      var content = "<img src='<?php echo $self; ?>?operation=getImage&" + depositId + "&" + imageType + "' width='100%'>";
      var imagePopup = $("#imagePopup").data("kendoWindow");
      if (imagePopup == null) {
        imagePopup = $("<div id='detailPopup'></div>").appendTo("body").kendoWindow({
              modal: true,
              title: "",
              visible: false,
              draggable: false,
              resizable: false,
              width: 400,
              open: function() {
                if (window.activeWindows != null) {
                  window.activeWindows.push(this);
                }
              },
              close: function() {
                if (window.activeWindows != null) {
                  window.activeWindows.pop();
                }
              }
        }).data("kendoWindow");
      }
      imagePopup.content(content).open().center();
      return false;
    });
  }
  $("#detailPopup").data("depositid", dataItem.depositId);
  popup.content(template(dataItem)).open().center();
}

/**
 * This makes sure that the count is included in the case that more records are being added to list, previously it would subbornly assert that there are no new records.
 */
var inRefresh = false;
function ForceRefresh(data, parameters, filterChanged) {
  if (inRefresh) {
    parameters.includeCount = "Y";
    inRefresh = false;
  }
  <?php if ($cu == "") { ?>
    parameters.saveFilter = "Y";
  <?php } ?>
}

$(document).ready(function () {
  InitReport({parameterMapFunc: ForceRefresh, preInitFunc: function(gridDefinition) {
    gridDefinition.columns[0] = {command: [{name: "details", text: "Details"}], width: "30px"};
    <?php if ($cu != "") { // Cannot unfilter CU if coming in through the CU ?>
    gridDefinition.columns[2].filterable = false;
    gridDefinition.columns[2].sortable = false;
  <?php } ?>
  }});

  $("#refreshBtn").click(function() {
    var grid = $("#reportGrid").data("kendoGrid");
    inRefresh = true;
    grid.dataSource.read();
    return false;
  });

  $("#clearAllBtn").click(function() {
    var grid = $("#reportGrid").data("kendoGrid");
    <?php // If you clear the sort and then the filter, it is two calls versus one here.  // The cookie will be changed in the call. ?>
    inRefresh = true;
    grid.dataSource.query({
      sort: {field:"depositId", dir:"asc"},
      <?php if ($cu == "") { ?>
      filter: [],
      <?php } else { ?>
      filter: {field: "cu", operator: "eq", value: "<?php echo $cu; ?>"},
      <?php } ?>
      pageSize: <?php echo $pageSize; ?>,
      page: 1
    });
    return false;
  });

  $("#reportGrid").on("click", ".k-grid-details", function() {
    var grid = $("#reportGrid").data("kendoGrid");
    OpenPopup(grid.dataItem($(this).closest("tr")));
  });

  <?php printClickOverlayEvent(); ?>

});
</script>
<script type="text/x-kendo-template" id="popupTemplate">
  # var frontHTML = frontpath == "" ? "No Image" : "(<a href='\\#' class='imageLink front'>Image</a>)"; #
  # var backHTML = backpath == "" ? "No Image" : "(<a href='\\#' class='imageLink back'>Image</a>)"; #
  <div class="overflowDiv">
    <div class="container-fluid">
      <div class="row hcuSpacer">
        <div class="col-xs-6"><label>Deposit ID</label></div>
        <div class="col-xs-6">#: depositId #</div>
      </div>
      <div class="row hcuSpacer">
        <div class="col-xs-6"><label>Vendor</label></div>
        <div class="col-xs-6">#: vendor #</div>
      </div>
      <div class="row hcuSpacer">
        <div class="col-xs-6"><label>Front Accepted</label></div>
        <div class="col-xs-6"># if (front == "") { # # } else if (front == "Y") { # Yes # } else { # No # } # #= frontHTML #</div>
      </div>
      <div class="row hcuSpacer">
        <div class="col-xs-6"><label>Back Accepted</label></div>
        <div class="col-xs-6"># if (back == "") { # # } else if (back == "Y") { # Yes # } else { # No # } # #= backHTML #</div>
      </div>
      # if (info && info.trim() != "") { #
      <div class="row hcuSpacer">
        <div class="col-xs-12">#= info #</div>
      </div>
      # } #
    </div>
  </div>
</script>
<?php printMonitorPageMiddle($title, array("Refresh" => array("id" => "refreshBtn"), "Clear All" => array("id" => "clearAllBtn"))); ?>

  <div class="loggingReportDiv container hcu-all-100 vsgPrimary" id="loggingReportDiv">

    <div id="notification"></div>

    <div class="row hcuSpacer">
      <div class="col-xs-12">
        <div id="formValidateMainDiv" class="k-block k-error-colored formValidateDiv" style="display:none;"></div>
      </div>
    </div>

    <div class="row hcuSpacer">
      <div class="col-xs-12">
        <div class="reportGridOverflow">
          <div id="reportGrid"></div>
        </div>
      </div>
    </div>
  </div>
<?php printMonitorPageBottom();
} // No operation

// FUNCTIONS

/**
 * function ReadReport($dbh, $reportList, $defaultDateFormat)
 * Returns the data needed from the parameters for the report:
 *
 * "report" -- the report to read.  Refers to the $reportKey in the function getReportList().  The frontend sends the variable down as a javascript literal.
 * "initial" -- {true/false}  If initial, then also figure out the boolean DDLs and send those to the frontend to recreate the grid with those parameters.  (There is no re-read.)
 * "limit" -- How many records to return.
 * "offset" -- Where to start in the resultset.
 * "newFilter" -- {true/false}  If newFilter, then also find out the count of the resultset.  Also, ignore the offset.  It will get the first page.
 * "sort" -- This is a json encoded string of the current sort in the grid.
 * "filter" -- This is a json encoded string of the current filter in the grid.
 * "printerFriendly" -- printer friendly doesn't have paging.
 *
 * @param $Cu -- the credit union
 * @param $dbh -- the database connection
 * @param $reportList -- the reportList from the getReportList() above.
 * @param $defaultDateFormat -- This is what the date will be formatted as.
 */
function ReadReport($Cu, $dbh, $reportList, $defaultDateFormat) {
  $parameters = array("a" => array("report" => "", "initial" => "", "limit" => "", "offset" => "", "newFilter" => "", "sort" => "", "filter" => "", "printerFriendly" => ""));
  $string = array("filter" => HCUFILTER_INPUT_STRING);
  HCU_ImportVars($parameters, "a", array("report" => $string, "initial" => $string, "limit" => $string, "offset" => $string, "newFilter" => $string, "sort" => $string,
    "filter" => $string, "printerFriendly" => $string));

  $report = HCU_array_key_exists("report", $parameters["a"]) ? trim($parameters["a"]["report"]) : "";
  $initial = HCU_array_key_exists("initial", $parameters["a"]) ? trim($parameters["a"]["initial"]) == "true" : false;
  $limit = HCU_array_key_exists("limit", $parameters["a"]) ? intval($parameters["a"]["limit"]) : -1;
  $offset = HCU_array_key_exists("offset", $parameters["a"]) ? intval($parameters["a"]["offset"]) : 0;
  $newFilter = HCU_array_key_exists("newFilter", $parameters["a"]) ? trim($parameters["a"]["newFilter"]) == "true" : false;
  $sort = HCU_array_key_exists("sort", $parameters["a"]) ? trim($parameters["a"]["sort"]) : "";
  $filter = HCU_array_key_exists("filter", $parameters["a"]) ? trim($parameters["a"]["filter"]) : "";
  $printerFriendly = HCU_array_key_exists("printerFriendly", $parameters["a"]) ? trim($parameters["a"]["printerFriendly"]) == "true" : false;

  $includeCount = !$printerFriendly && $newFilter;
  $limit = $printerFriendly ? -1 : $limit;
  $offset = $printerFriendly || $newFilter ? 0 : $offset;

  $returnArray = ReadReportData($Cu, $reportList[$report], $dbh, $limit, $offset, $includeCount, false, $initial, false, $sort, $filter, $report, "loggingReport");

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

/**
 * function GetImage($dbh)
 * @param $dbh -- the database connection
 * Get the image from the filepath.  If it doesn't exist, shows "Image doesn't exist."
 */
function GetImage($dbh) {
  $parameters = array("a" => array("depositId" => "", "imageType" => ""));
  $string = array("filter" => HCUFILTER_INPUT_STRING);
  HCU_ImportVars($parameters, "a", array("depositId" => $string, "imageType" => $string));

  $depositId = HCU_array_key_exists("depositId", $parameters["a"]) ? intval($parameters["a"]["depositId"]) : 0;
  $imageType = HCU_array_key_exists("imageType", $parameters["a"]) ? trim($parameters["a"]["imageType"]) : "";

  try {
    if (!in_array($imageType, array("front", "back"))) {
      throw new exception ("Image type is invalid", 3);
    }
    $sql = "select " . ($imageType == "front" ? "frontpath" : "backpath") . " from curdcstatus where depositid = $depositId";
    $sth = db_query($sql, $dbh);
    if (!$sth) {
      throw new exception("Query invalid", 4);
    }
    $filepath = trim(db_fetch_row($sth,0)[0]);
    if (!file_exists($filepath)) {
      throw new exception ("Image is not found", 1);
    }
    if (!is_readable($filepath)) {
      throw new exception ("Image is readable", 2);
    }
    header('Content-Type: image/jpeg');
    readfile($filepath);
  } catch(exception $e) {
    // Create a blank image and add some text
    $image = imagecreatetruecolor(120, 20);

    $textColor = imagecolorallocate($image, 46, 46, 46);
    $backgroundColor = imagecolorallocate($image, 255, 255, 255);

    imagefill($image, 0, 0, $backgroundColor);
    imagestring($image, 1, 5, 5,  $e->getMessage(), $textColor);

    header('Content-Type: image/png');
    imagepng($image);
    imagedestroy($image);
  }
}