showhavetrans.prg

<?php
$previousScript= "showhavetrans";
require_once("adm_reports.prg");
require_once("cu_flagconst.i");

dms_import(array("report" => "string", "operation" => "string", "servers" => "string", "showServer" => "string"));

$showSQL= false;
$title= "Allowed Transaction Settings";
$cookieName= "showhavetrans";
$url= $_SERVER["PHP_SELF"];
$defaultDateFormat= "MM/dd/yyyy";

$showhavetransSQLTemplate= "select a.cu, a.orgname, # from (select cu, orgname from cuadmin where livebatch <> 'C') a";
$createReportList= true;
$cookie= "";
$reportList= array();
$errors= array();
$sqls= array();

if (isset($_COOKIE[$cookieName]))
{
  parse_str($_COOKIE[$cookieName]);

  if ($transListEncoded == "")
  {
   $transList= setTransList($link, $cookieName, $errors, $sqls, $usedTransEncoded);

  }
  else
  {
    $transList= json_decode($transListEncoded, true);
  }

  $usedTrans= $usedTransEncoded == "" ? array() : json_decode($usedTransEncoded, true);

  createReportListFromFlags($link, $showSQL, $reportList, $errors, $sqls, $transList, $usedTrans, $cookieName, $showhavetransSQLTemplate);
}
else
{
  $transList= setTransList($link, $cookieName, $errors, $sqls, $cookieName);
}

function setTransList($link, $cookieName, &$errors, &$sqls, $usedTransEncoded="")
{
    $sql= "select trancode, trandesc from cutrans order by trancode";

    $results= runSelectStatementMap($sql, $link);
    $errors= array_merge($errors, $results["error"]);
    $sqls[]= $sql;
    $transList= $results["record"];

  $expiresInDay= time()+86400;
    $cookie= "usedTransEncoded=$usedTransEncoded&transListEncoded=" . urlencode(json_encode($transList));

  HCU_setcookie_env($SYSENV, $cookieName, $cookie, $expiresInDay);
  return $transList;
}

function createReportListFromFlags($link, $showSQL, &$reportList, &$errors, &$sqls, $transList, $usedTrans, $cookieName, $showhavetransSQLTemplate)
{
    $errors= array();
    $sqls= array();

    $joinList= array();
    $colList= array("CU" => "string", "Org Name" => "string");
    $values= array();
    $colSelectList= array();

    $index= 0;

    if (is_array($usedTrans)) {
      foreach($usedTrans as $trans)
      {
        $text= isset($transList[$trans]) ? $transList[$trans] : "t$index";
        $colSelectList[]= "t$index.trancode";
        $joinList[]= "left join (select * from cuhavetrans where trancode='$trans') as t$index on a.cu= t$index.cu";
        $colList[$text]= "string";
        $values[$text]= array(array("text" => "+", "value" => $trans), array("text" => " ", "value" => ""));
        $index++;
      }
    }

    if (count($colSelectList) == 0) // nothing selected so select all
    {
      $index= 0;
      foreach($transList as $value => $text)
      {
        $colSelectList[]= "t$index.trancode";
        $joinList[]= "left join (select * from cuhavetrans where trancode='$value') as t$index on a.cu= t$index.cu";
        $colList[$text]= "string";
        $values[$text]= array(array("text" => "+", "value" => $value), array("text" => " ", "value" => ""));
        $index++;
      }
    }

    $sql= str_replace("#", implode(", ", $colSelectList), $showhavetransSQLTemplate) . "\n" . implode("\n", $joinList);

    $reportList= array("loanAddon" => array("title" => "", "sql" => $sql, "cols" => $colList, "values" => $values));
}

function outputFlagRows($transList)
{
    print "<div class='grid_16 flagHeader'>Transcode</div>\n";

        $index= 0;
        $row= "";
        foreach($transList as $value => $text)
        {
            $modulus= $index % 4;
            if ($modulus == 0)
                $row= "<div class='grid_16'>
                        <div class='grid_4 alpha'>#0#</div>
                        <div class='grid_4'>#1#</div>
                        <div class='grid_4'>#2#</div>
                        <div class='grid_4 omega'>#3#</div>
                      </div>";
            $row= str_replace("#$modulus#", "<input type='checkbox' class='transFlag' value=$value>$text</input>", $row);
            if ($modulus == 3)
            {
                print "$row\n";
                $row= "";
            }
            $index++;
        }

        if ($row != "")
        {
            $row= preg_replace("/#[0-3]#/", "&nbsp;", $row);
            print "$row\n";
        }
        print "<div class='grid_16'><hr></div><div class='grid_16'>&nbsp;</div>\n";
}

function outputLegend($transList, $usedTrans)
{
      $data= array();
    $cols= 2;
    $rowIndex= 0;
    $row= "not started";
        foreach($usedTrans as $index => $value)
        {
      $modulus= $index % $cols;
      if ($modulus == 0)
        $row= array("rowIndex" => ++$rowIndex);
      $row["property$modulus"]= $transList[$value];
      $row["value$modulus"]= $value;

      if ($modulus == $cols-1)
      {
        $data[]= $row;
        $row= "not started";
      }
        }

    if ($row != "not started")
      $data[]= $row;

    if (count($data) == 0) // nothing selected so everything.
    {
      $data= array();
      $rowIndex= 0;
      $index= 0;
      $row= "not started";
      foreach($transList as $value => $text)
      {
        $modulus= $index % $cols;
        if ($modulus == 0)
          $row= array("rowIndex" => ++$rowIndex);
        $row["property$modulus"]= $text;
        $row["value$modulus"]= $value;

        if ($modulus == $cols-1)
        {
          $data[]= $row;
          $row= "not started";
        }
        $index++;
      }

      if ($row != "not started")
        $data[]= $row;
    }

        print "gridDefinition.dataSource.data= " . json_encode($data) . ";\n";
}

if (!isset($operation)) {$operation ="";}
if ($operation == "setReportCookie")
{
    $parameters= array();
    dms_import_v2($parameters, "BOTTOM_LEVEL", array("usedTrans" => "string"));

    $usedTrans= $parameters["BOTTOM_LEVEL"]["usedTrans"];

    $expiresInDay= time()+86400;
  $cookie= "usedTransEncoded=$usedTrans&transListEncoded=" . urlencode(json_encode($transList));
  HCU_setcookie_env($SYSENV, $cookieName, $cookie, $expiresInDay);

    header("Location: $url?report=loanAddon&servers=$servers&showServer=$showServer");
    exit;
}
else if ($operation != "")
{

    $errors= array();
    $sqls= array();

  switch ($operation)
  {
    case "readReport":
      readReport($link, $showSQL, $errors, $sqls, $reportList, $defaultDateFormat, $cookieName);
      break;
    case "readReportSQL":
      readReport($link, true, $errors, $sqls, $reportList, $defaultDateFormat, $cookieName);
      break;
    case "generateCSV":
      generateCSV($link, $errors, $sqls, $reportList, $defaultDateFormat, $cookieName);
      break;
    default: // Won't get here
      header('Content-type: application/json');
      $errors[]= "Operation not specified: '$operation'";
      $returnArray= array("error" => $errors, "record" => "", "operation" => "");
      print json_encode($returnArray);
  }
}
else
{


// Presentation layer
// ************************************

if (!isset($report)) {$report ="";}
$report= trim($report);

$reportMenuDDL= array("REDIRECT" => array("list" => array("Selection List" => array("url" => $presentationFile))),
    "Download CSV" => array("id" => "downloadCSVBtn"), "Help &nbsp;<img src=\"/monitor/images/q1.gif\" border=\"0\" alt=\"View Help\" align=\"top\">" => array("id" => "helpBtn"));

// Page for selecting the report.
// *****************************************************
if ($report == "")
{
    printMonitorPageTop($title, $homecuKendoVersion, $cloudfrontDomainName);
?>

<style>
  .flagHeader {
    background-color: #B2B3C2 !important;
    text-align: center !important;
    font-size: 120%;
  }
</style>

<script type="text/javascript">
<?php
getErrorsAreShownFunction();
getEscapeHTMLFunction();
?>
function initReportSelectPage()
{
  var localServer = "<?php echo $_SERVER['SERVER_NAME']; ?>";
  var serverMultiselect= $("#serverMultiselect").kendoMultiSelect({
    dataSource: {
      data: ["www3", "www5", "www6", localServer]
    },
    value: ["www3", "www5", "www6", localServer]
  }).data("kendoMultiSelect");

  $("#serverMultiselect").prev().css({height: 25});

  $("#runReportBtn").click(function() {

    var data= {error: []};
    if (!errorsAreShown(data, "formValidateMainDiv"))
    {
      var url= "<?php echo $url; ?>?operation=setReportCookie";
      var showServer= $("#showServerCheckbox:checked").length > 0 ? "Y" : "N";
      var servers= kendo.stringify(serverMultiselect.value());

      url+= "&showServer=" + showServer + "&servers=" + servers;

      var flags= [];
      $(".transFlag").each(function() {
        if ($(this).is(":checked"))
          flags.push($(this).val());
      });
      url+= "&usedTrans=" + kendo.stringify(flags);

      window.location.href= url;
    }

    return false;
  });
}

$(document).ready(function () {
  initReportSelectPage();
});
</script>
<?php printMonitorPageMiddle($title); ?>

      <div id='hideSubmitWait' style='position:relative; left:-2000px;top:-2000px;'>
        <div id='homecuSubmitWait' class='k-block' >
          <div class='k-loading-image'></div>
        </div>
      </div>
  <div class="container_16">
    <?php outputFlagRows($transList, $usedTrans); ?>
    <div class="grid_16">
      Include Data From: <div id="serverMultiselect"></div>
    </div>
    <div class="grid_16">
      Show Server: <input type="checkbox" id="showServerCheckbox">
    </div>
    <div class="grid_16">
      <a href="#" class="k-button k-button-icontext" id="runReportBtn">Go</a>
    </div>
  </div>
<?php }
// Page for displaying the reports.
// **************************************************************
else
{
    printMonitorPageTop($title, $homecuKendoVersion, $cloudfrontDomainName);
?>

<style>
    #legendDiv .k-grid-toolbar {
        background-color: #9BAFBE !important;
        font-weight: bold !important;
        text-align: center !important;
    }
  #legendDiv .firstGridToolbar {
    background-color: #B2B3C2 !important;
  }

  fieldset {
    border: 1px solid black;
    border-radius: 10px;
    margin: 5px;
    vertical-align: top;
    display: inline;
    width: 415px;
    padding: 5px;
  }
</style>

<script type="text/javascript">

<?php
// Include common functions
getErrorsAreShownFunction();
getEscapeHTMLFunction();
getShowSQLFunction($showSQL);
getShowWaitFunctions();
getIsFilterChanged();
initReportClientSide($presentationFile, $report, $title, array("servers" => $servers, "showServer" => $showServer), true, "addWidthsPre", "addWidthsPost"); // pass the variables down.
?>

function addWidthsPre(gridDefinition)
{
  gridDefinition.columns[0].width= "100px"; // CU
  gridDefinition.columns[1].width= "200px"; // orgName
}

function addWidthsPost(grid)
{
  for(var i=2, length=grid.columns.length; i!=length; i++)
  {
    grid.autoFitColumn(i);
  }

  $("#reportGrid").css({width: $("#reportGrid table").css("width")});
}

function initOptions()
{
    var gridDefinition= {
        dataSource: {
            schema: {
                model: {
                    id: "rowIndex",
                    fields: {
            rowIndex: {type: "number"},
                        property0: {type: "string"},
                        value0: {type: "string"},
            property1: {type: "string"},
            value1: {type: "string"}
                    }
                }
            }
        },
        columns: [
            {field: "property0", title: "Flag"},
            {field: "value0", title: "Value"},
      {title: " ", template: " ", width: "3px"},
      {field: "property1", title: "Flag"},
      {field: "value1", title: "Value"}
        ]
    };
    <?php outputLegend($transList, $usedTrans); ?>
  var legendGrid= $("#legendGrid").kendoGrid(gridDefinition).data("kendoGrid");

   $("#includeLegend").click(function () {
    if ($(this).is(":checked"))
        $("#legendDiv").show();
    else
        $("#legendDiv").hide();
  });

  $("#legendDiv .k-grid-toolbar:eq(0)").addClass("firstGridToolbar");

  var cuOptionsDDL= $("#cuOptionsDDL").kendoDropDownList({
    dataSource: {
        data: [{text: "Show Selected Flags for All Credit Unions", value: 1}, {text: "Show Credit Unions w/ All Selected Flags Set", value: 2},
            {text: "Show Credit Unions w/ Any Selected Flag Set", value: 3}]
    },
    dataTextField: "text",
    dataValueField: "value",
    change: function() {
        var filter= [];
      var dataRows = $("#reportGrid").data("kendoGrid").dataSource.data();
      var dataColumns = $("#reportGrid").data("kendoGrid").columns;

      if (this.value() != 1) {
        // Loop through all table rows
        for (var i = 0; i < dataRows.length; i++) {
          var hasAll = true;
          var hasOne = false;

          var row = dataRows[i];
          var rowCu = row.cu;

          // Loop through all columns in each row
          for (var j = 0; j < dataColumns.length; j++) {
            var column = dataColumns[j];
            var columnName = column.field.trim();

            // Skip these columns we don't need them
            if (columnName == "cu" || columnName == "orgName" || columnName == "server") {
              continue;
            }

            // Test when the field has a value
            if (row[columnName] == "") {
              hasAll = false;
            } else {
              hasOne = true;
            }
          }

          // The filtering dropdown has two main values:
          // 1: Show any rows where the credit union has all flags set
          // 2: Show any rows where the credit union has at least one flag set
          if (this.value() == 2 && hasAll) {
            filter.push({field: "cu", operator: "eq", value: rowCu});
          } else if (this.value() == 3 && (hasOne || hasAll)) {
            filter.push({field: "cu", operator: "eq", value: rowCu});
          }
        }

        // It is possible that no filters may be added, when this
        // happens kendo will display the entire record set when
        // we really want to display no results.

        // Create dummy filter to display no results.
        if (filter.length == 0) {
          filter.push({field: "cu", operator: "eq", value: ""});
        }

        filter= {logic: "or", filters: filter};
      }
        $("#reportGrid").data("kendoGrid").dataSource.filter(filter);
    }
  }).data("kendoDropDownList");

  cuOptionsDDL.value(1);
}

$(document).ready(function () {
  initReport();
  initOptions();
});
</script>
<?php
printMonitorPageMiddle($title, $reportMenuDDL); ?>
      <div id='hideSubmitWait' style='position:relative; left:-2000px;top:-2000px;'>
        <div id='homecuSubmitWait' class='k-block' >
          <div class='k-loading-image'></div>
        </div>
      </div>

  <div id="notification"></div>
  <div class="container_12">
    <div class="grid_12">
          <div id="sqlOutput"></div>
    </div>
    <fieldset id="optionsDiv">
      <div class="grid_12">
        <div class="grid_3">Include Legend:</div>
        <div class="grid_9"><input id="includeLegend" type="checkbox"></div>
      </div>
      <div class="grid_12">
        <div class="grid_3">Filter: </div>
        <div class="grid_9"><div id="cuOptionsDDL" style="width:100%"></div></div>
      </div>
    </fieldset>
    <div class="grid_12" id="legendDiv" style="display:none;">
      <div id="legendGrid" ></div>
    </div>
    <div class="grid_12" style="margin-bottom:5px;">
          <div id="formValidateMainDiv" class="k-block k-error-colored" style="display:none;"></div>
    </div>
    <div class="grid_12">
      <div id="reportGrid"></div>
    </div>
  </div>
<?php printMonitorPageBottom();
} // Report selected
} // No operation