adm_reports.prg

<?php
/**
 * Change History:
 * 05/01/13 mbl - Added fname, lname, decider to monitor_contact table.
 * 11/16/15 SPB - updated to Kendo look
 */

$monLibrary= dirname(__FILE__) . "/../library";
$monIncludes= dirname(__FILE__) . "/../includes";
$sharedLibrary= dirname(__FILE__) . "/../../shared/library";
require_once("$monLibrary/cu_top.i");
require_once("$monLibrary/ck_hticket.i");
require_once("$monIncludes/cu_remote_top.prg");
require_once("$monLibrary/monitorView.i");
require_once("$sharedLibrary/reports.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;
  }

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

// Configuration for data operations & presentation layer.
$showSQL= false;
$dataFile= $_SERVER["PHP_SELF"];
$presentationFile= $dataFile;
$defaultDateFormat= "MM/dd/yyyy";

// Some reports use the cuusers table which is no cu
// specific, we must get a list of cu's before we can
// build the queries for the report list below.

// Each of the 3 queries below reuiqred the livebatch <> 'C'
// so it was moved out.
$sql = "SELECT cu FROM cuadmin WHERE livebatch IN ('L', 'B');";
$sqlRs = db_query($sql, $dbh);

$eStmtQuery = "";
$eStmtSatQuery = "";
$callahanQuery = "";

$numRecords = db_num_rows($sqlRs);
for ($i = 0; $i < $numRecords; $i++) {
  $row = db_fetch_assoc($sqlRs, $i);
  $cu = strtoupper($row['cu']);
  $cu = trim($cu);

  // Build eStatement query.
  $eStmtQuery .= "select '{$cu}', a.vendor from {$cu}memberacct m, cuadmin a where m.estmnt_flag = 'Y' and a.cu = '{$cu}'";

  $eStmtSatQuery .= "select '{$cu}', estmt, members, (case when members > 0 then round(((estmt::float * 100 ) / members::float)::numeric,1) else 0 end) from (select COUNT(estmnt_flag) as estmt from {$cu}memberacct where estmnt_flag = 'Y') as estmt, (select COUNT(accountnumber) as members from {$cu}memberacct) as members";

  $callahanQuery .= "select '{$cu}', orgname, (case when exists (select estmnt_flag from {$cu}memberacct where estmnt_flag = 'Y') then 'ES' else '' end), (case when exists (select role from cuadmnotify where cu = '{$cu}' and role = 'txtbanking') then 'TXT' else '' end), (case when trim(bp_vendor) not in ('', 'NO') then bp_vendor else '' end) from cuadmin where cu = '{$cu}'";

  if ($i < $numRecords - 1) {
    $eStmtQuery .= " UNION ";
    $eStmtSatQuery .= " UNION ";
    $callahanQuery .= " UNION ";
  }
}

// title => , sql => , cols =>
$reportList= array(
    // 2
    "estatementClients" => array("title" => "E-Statements Clients",
       "sql" => "{$eStmtQuery}",
       "cols" => array("Credit Union" => "string", "Vendor" => "string")),
    // 3
    "alphaCheck" => array("title" => "Alpha Check List",
      "sql" => "select cu, user_name, orgname from cuadmin a where livebatch <> 'C' ",
      "cols" => array("CU Code" => "string", "CU Home" => "string", "Org Name" => "string")),
    // 4
    "checkImaging" => array("title" => "Check Imaging Clients",
      "sql" => "select cu, orgname, rt, img, case when (flagset & 2::int8)>0 then '+' else '' end, ckhexkey, ckorgid, ckurl from cuadmin where trim(img) not in ('','NO') and livebatch <> 'C' ",
      "cols" => array("CU Code" => "string", "Org Name" => "string", "Routing#" => "number", "Image Vendor" => "string", "On" => "string", "Ck Hex Key" => "string",
        "Ck ID" => "string", "Ck URL" => "string")),
    // 5
    "download" => array("title" => "Download Formats",
      "sql" => "select cu, orgname, rt, tranformat::int, case when tranfldsep=1 then 'SP' else 'TAB' end,
        case when traneol=1 then 'NONE' when traneol=2 then 'CRLF' else 'NL' end from cuadmin where livebatch <> 'C' ",
      "cols" => array("CU Code" => "string", "Org Name" => "string", "R/T" => "number", "Format" => "number", "Fld" => "string", "EOL" => "string")),
    // 6
    "alertUsage" => array("title" => "Alert Usage Summary",
      "sql" =>  "select cuadmin.cu, coalesce(sq_bal_join.bal_count, 0), coalesce(sq_chk_join.chk_count, 0), coalesce(sq_loan_join.ln_count, 0), coalesce(sq_trnx_join.trnx_count, 0) from cuadmin left join (select cu, count(*) as bal_count from cu_alerts where alerttype = 'B' group by cu) as sq_bal_join on cuadmin.cu = sq_bal_join.cu left join (select cu, count(*) as chk_count from cu_alerts where alerttype = 'C'  group by cu) as sq_chk_join on cuadmin.cu = sq_chk_join.cu left join (select cu, count(*) as ln_count from cu_alerts where alerttype = 'L'  group by cu) as sq_loan_join ON cuadmin.cu = sq_loan_join.cu left join (select cu, count(*) as trnx_count from cu_alerts where alerttype = 'T'  group by cu) as sq_trnx_join ON cuadmin.cu = sq_trnx_join.cu where livebatch <> 'C' and (coalesce(sq_bal_join.bal_count, 0) > 0 or coalesce(sq_chk_join.chk_count, 0) > 0 or coalesce(sq_loan_join.ln_count, 0) > 0 or coalesce(sq_trnx_join.trnx_count, 0) > 0) ",
      "cols" => array("CU" => "string", "Bal" => "number", "Check" => "number", "Loan" => "number", "Trans" => "number")),
    // 7
    "billPayCross" => array("title" => "Bill Pay Cross-Authentication Settings",
      "sql" => "select cu, orgname, rt, bp_vendor, bp_cuid, bp_secret from cuadmin where trim(bp_vendor) > '' and trim(bp_vendor) <> 'NO' and livebatch <> 'C' ",
      "cols" => array("CU Code" => "string", "Org Name" => "string", "RT Transit" => "number", "Bill Pay Vendor" => "string", "Bill Pay CUID" => "string", "Bill Pay Secret" => "string")),
    // 8
    "security" => array("title" => "Security Method Settings",
      "sql" => "select cu, orgname, case when cookie_ver = 'L' then 'Legacy' else '2-Factor' end, loginscript, min_chlng_qst from cuadmin where livebatch <> 'C' ",
      "cols" => array("CU Code" => "string", "Org Name" => "string", "Security Method" => "string", "Login Script" => "string", "Questions" => "string")),
    // 9
    "offlineStatus" => array("title" => "Offline Status Settings",
      "sql" => "select cu, orgname, case when offlinestat = 'Y' then 'Offline (Stay Down)' when offlinestat = 'U' then 'Offline (Auto Up)' when offlinestat = 'R' then 'Read-Only' else 'Active' end,
        offlineblurb from cuadmin where livebatch <> 'C' ",
      "cols" => array("CU Code" => "string", "Org Name" => "string", "Offline Status" => "string", "Offline Message" => "string")),
    // 10
    "trustedAccess" => array("title" => "Trusted Access Settings",
      "sql" => "select cu, orgname, ssovendor from cuadmin where trim(ssovendor) not in ('','NO') and livebatch <> 'C' ",
      "cols" => array("CU Code" => "string", "Org Name" => "string", "Trusted Access Vendor" => "string")),
    // 13
    "loginFailure" => array("title" => "Admin User Login Failure Status",
      "sql" => "select a.cu, u.user_name, lastlogin, failedlogin, case when coalesce(userflags, 0) & 8::int4 = 8  then 'Email' when coalesce(userflags, 0) & 16::int4 = 16  then 'Challenge'
        when coalesce(userflags, 0) & 32::int4 = 32  then 'Password' else '' end from cuadminusers u, cuadmin a where u.cu = a.cu and a.livebatch <> 'C' and coalesce(userflags,0) & 56::int4 > 0 ",
      "cols" => array("CU Code" => "string", "Admin User" => "string", "Last Login" => "date", "Last Failed" => "date", "Reason" => "string")),
    // 14
    "creditCard" => array("title" => "Credit Card Settings",
      "sql" => "select cu, orgname, case when (flagset2 & 8::int8)>0 then '+' else '' end, case when (flagset2 & 16::int8)>0 then '+' else '' end, case when (flagset2 & 1024::int8)>0 then '+' else '' end, case when exists (select * from cuhavetrans where cu=cuadmin.cu and trancode='CC') then 'CC' else 'LP' end, ccinfourl from cuadmin where (flagset2 & 4::int8) > 0 and livebatch <> 'C' ",
      "cols" => array("CU Code" => "string", "Org Name" => "string", "Show Interest" => "string", "Show Last Pd" => "string", "Show Stmnt Bal" => "string", "TranCode" => "string",
        "Card Info URL" => "string")),
    // 16
    "txtBanking" => array("title" => "TXT Banking Clients",
      "sql" => "select a.cu, a.orgname, n.email from cuadmnotify n join cuadmin a on a.cu = n.cu where a.livebatch <> 'C' and n.role = 'txtbanking' ",
      "cols" => array("CU Code" => "string", "Org Name" => "string", "CU TXT Mail Address" => "string")),
    // 17
    "cuAlerts" => array("title" => "CU Alerts Clients",
      "sql" => "select a.cu, a.orgname, n.email, a.liveserver from cuadmnotify n join cuadmin a on a.cu = n.cu where a.livebatch <> 'C' and n.role = 'alert' ",
      "cols" => array("CU Code" => "string", "Org Name" => "string", "CU Alert Mail Address" => "string", "PGLoad Command" => "string")),
    // 18
    "callahan" => array("title" => "Callahan Details",
      "sql" => "{$callahanQuery}",
      "cols" => array("CU Code" => "string", "Name" => "string", "ES" => "string", "TXT" => "string", "Bill Pay" => "string")),
    // 19
    "fid" => array("title" => "FID Settings",
      "sql" => "select cu, orgname, rt, fid, tz from cuadmin where livebatch in ('B','L') ",
      "cols" => array("CU Code" => "string", "Name" => "string", "Routing" => "number", "FID" => "number", "TimeZone" => "date")),
    // 20
    "overrideMcir" => array("title" => "Override MICR Usage",
      "sql" => "select om.cu, count(*) from cuovermicr om join cuadmin a on om.cu = a.cu where a.livebatch in ('B','L') group by om.cu ",
      "cols" => array("CU Code" => "string", "Count" => "number")),
    // 21
    "classicMobile" => array("title" => "Clients using Classic Mobile Banking",
      "sql" => "select cu, user_name, orgname from cuadmin where cu in ('#cus#')", "cols" => array("CU Code" => "string", "CU Home" => "string", "Org Name" => "string"),
      "replaceString" => "#cus#", "replaceCode" => 'return implode("\', \'", runPipe("clmobile.mp"));'),
    // 22
    "mobileWeb" => array("title" => "Clients using Mobile Web Banking",
      "sql" => "select cu, user_name, orgname from cuadmin where cu in ('#cus#')", "cols" => array("CU Code" => "string", "CU Home" => "string", "Org Name" => "string"),
      "replaceString" => "#cus#", "replaceCode" => 'return implode("\', \'", runPipe("gomobile.mp"));'),
    // 23
    "estatementSat" => array("title" => "E-Statement Saturation",
      "sql" => "{$eStmtSatQuery}",
      "cols" => array("Credit Union" => "string", "E-Stmnt" => "string", "Members" => "string", "Percent" => "number"))
  );

$reportMenu= array("Administrative Info Reports" => array_keys($reportList));

// Data layer
// **************************************

// This ALWAYS returns an array like the original so there is no need checking to see if it is an array.
function runPipe($file)
{
  $response= array();
  if ($handle = popen("../usr-bin/$file", 'r'))
  {
    while (!feof ($handle))
    {
      $getLine = fgets($handle, 4096);
      if (trim($getLine) != "")
        $response[] = strtoupper(trim($getLine));
    }
    pclose($handle);
  }
  return $response;
}

// All the internal functions are in reports.i
function readReport($dbh, $showSQL, &$errors, &$sqls, $reportList, $defaultDateFormat, $cookieName="")
{
  $parameters= array();
  dms_import_v2($parameters, "BOTTOM_LEVEL", array("report" => "string", "initial" => "string", "limit" => "string", "offset" => "string", "includeSchema" => "string", "includeCount" => "string",
    "excludeData" => "string", "sortCols" => "string", "sortDirs" => "string", "filterCols" => "string", "filterOps" => "string", "filterValues" => "string", "dontIncludeId" => "string",
    "servers" => "string", "showServer" => "string", "excludeSort" => "string", "limitId" => "string"));

  array_merge($errors, cleanValuesForDatabase($parameters["BOTTOM_LEVEL"],
    array("initial" => array("type" => "boolean", "required" => false),
          "report" => array("type" => "string", "required" => true),
          "limit" => array("type" => "int", "required" => true, "allowNegatives" => true),
          "offset" => array("type" => "int", "required" => false),
          "includeSchema" => array("type" => "boolean", "required" => false),
          "includeCount" => array("type" => "boolean", "required" => false),
          "excludeData" => array("type" => "boolean", "required" => false),
          "dontIncludeId" => array("type" => "boolean", "required" => false),
          "showServer" => array("type" => "boolean", "required" => false),
          "excludeSort" => array("type" => "boolean", "required" => false))));
  $report= $parameters["BOTTOM_LEVEL"]["report"];
  $limit= $parameters["BOTTOM_LEVEL"]["limit"];
  $offset= intval($parameters["BOTTOM_LEVEL"]["offset"]);

  // Will be validated later
  $sortCols= trim($parameters["BOTTOM_LEVEL"]["sortCols"]);
  $sortDirs= trim($parameters["BOTTOM_LEVEL"]["sortDirs"]);
  $filterCols= trim($parameters["BOTTOM_LEVEL"]["filterCols"]);
  $filterOps= trim($parameters["BOTTOM_LEVEL"]["filterOps"]);
  $filterValues= trim($parameters["BOTTOM_LEVEL"]["filterValues"]);
  $servers= trim($parameters["BOTTOM_LEVEL"]["servers"]);
  $limitId= trim($parameters["BOTTOM_LEVEL"]["limitId"]);

  $theseParameters= array("report" => $report, "includeSchema" => $parameters["BOTTOM_LEVEL"]["includeSchema"], "includeCount" => $parameters["BOTTOM_LEVEL"]["includeCount"],
          "limit" => $limit, "offset" => $offset, "excludeData" => $parameters["BOTTOM_LEVEL"]["excludeData"], "sortCols" => $sortCols, "sortDirs" => $sortDirs, "servers" => $servers,
          "filterCols" => $filterCols, "filterOps" => $filterOps, "filterValues" => $filterValues, "dontIncludeId" => $parameters["BOTTOM_LEVEL"]["dontIncludeId"],
          "showServer" => $parameters["BOTTOM_LEVEL"]["showServer"], "excludeSort" => $parameters["BOTTOM_LEVEL"]["excludeSort"], "limitId" => $limitId);

  $printThis = readReportMonitor($dbh, $theseParameters, $errors, $sqls, $reportList, $defaultDateFormat, $cookieName);
  header('Content-type: application/json');
  print json_encode($printThis);
}

function readReportMonitor($dbh, $theseParameters, &$errors, &$sqls, $reportList, $defaultDateFormat, $cookieName="")
{
    // Must push local server name to match what's in the www_server
    // value in cuinfo.
    $validServers= array("www3", "www5", "www6", $_SERVER['SERVER_NAME']);
    $serverArray= $validServers;
    $serverCount= 3;

    $servers= $theseParameters["servers"];
    $showServer= $theseParameters["showServer"] == "Y";
    $limit= $theseParameters["limit"];
    $offset= $theseParameters["offset"];
    $sortCols= $theseParameters["sortCols"];
    $sortDirs= $theseParameters["sortDirs"];

    global $SYS_TYPE_CLOSED;
    $sql= "select trim(upper(user_name)) as user_name, trim(www_server) as www_server from cuinfo where system_options & $SYS_TYPE_CLOSED = 0 order by user_name";
    $sqls[]= $sql;
    $results= runSelectStatementMap($sql, $dbh);
    $cuMap= $results["record"];
    $errors= array_merge($errors, $results["error"]);

    if ($servers != "")
    {
      $theseServers= json_decode($servers, true);
      if (!is_array($theseServers))
        $errors[]= "Servers are not formatted correctly.";
      else
      {
        $serverCount= count($theseServers);
        if ($serverCount != 0)
          $serverArray= $theseServers;
      }
    }

    unset($theseParameters["servers"]);
    unset($theseParameters["showServer"]);

    $theseParameters["limit"]= -1;
    $theseParameters["offset"]= 0;
    $theseParameters["excludeSort"]= "Y";

    $serverData= array();
    $columnData= array();
    $modelData= array();
    $reportData= array();
    $response = null;
    foreach($serverArray as $server)
    {
      if (!in_array($server, $validServers))
        $errors[]= "$server is not a valid server.";
      if (count($errors) == 0)
      {
        // Instead of making a curl call to get local data,
        // check which server needs the curl call and default to local data
        // because the local odyssey server can have different possible names.
        if ($server == "www3" || $server == "www5" || $server == "www6") {
          $response = runCurl($server, $theseParameters, $cookieName);
        } else {
          $response = readReportCommon($theseParameters["report"], $errors, $sqls, $dbh, $theseParameters["limit"], $theseParameters["offset"], $theseParameters["includeSchema"] == "Y", $theseParameters["includeCount"] == "Y", $theseParameters["excludeData"] == "Y", $theseParameters["dontIncludeId"] == "Y", $theseParameters["excludeSort"] == "Y", $theseParameters["sortCols"], $theseParameters["sortDirs"], $theseParameters["filterCols"], $theseParameters["filterOps"], $theseParameters["filterValues"], $reportList, "admReports", $cookieName);

          // Further code is expecting json encoded string
          $response = HCU_JsonEncode($response);
        }

        if (strpos($response, "<html>") !== false) // Redirected to permissions page
          $errors[]= "You do not have the necessary rights to view the data from $server.";
        else if (trim($response) == "") // No data found
          $errors[]= "No data found from $server!";
        else
        {
          $jsonResponse= json_decode($response, true);
          $errors= array_merge($errors, $jsonResponse["error"]);
          if (isset($jsonResponse["sql"]))
            $sqls= array_merge($sqls, $jsonResponse["sql"]);

          foreach($jsonResponse["reportData"]["data"] as $record)
          {
            reset($record);
            $cu= strtoupper(trim(next($record)));

            if (!isset($cuMap[$cu]) || trim($cuMap[$cu]) != $server)
              continue; // Skip records not in the official CU server.
            if ($showServer)
              $record["server"]= $server;
            $serverData[]= $record;
          }

          if (count($columnData) == 0)
          {
            $columnData= $jsonResponse["columnData"];
            $modelData= $jsonResponse["modelData"];

            if ($showServer)
            {
              $modelData["fields"]["server"]= array("type" => "string");
              $columnData[]= array("field" => "server", "title" => "Server");
            }
          }
        }
      }
    }

    return array("sql" => $sqls, "error" => $errors, "reportData" => array("data" => $serverData), "modelData" => $modelData, "columnData" => $columnData);
}

function generateCSV($dbh, &$errors, &$sqls, $reportList, $defaultDateFormat, $cookieName="")
{
    $parameters= array();
  dms_import_v2($parameters, "BOTTOM_LEVEL", array("report" => "string", "sortCols" => "string", "sortDirs" => "string", "filterCols" => "string",
    "filterOps" => "string", "filterValues" => "string"));

  array_merge($errors, cleanValuesForDatabase($parameters["BOTTOM_LEVEL"], array("report" => array("type" => "string", "required" => true))));

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

  // Will be validated later
  $sortCols= $parameters["BOTTOM_LEVEL"]["sortCols"];
  $sortDirs= $parameters["BOTTOM_LEVEL"]["sortDirs"];
  $filterCols= $parameters["BOTTOM_LEVEL"]["filterCols"];
  $filterOps= $parameters["BOTTOM_LEVEL"]["filterOps"];
  $filterValues= $parameters["BOTTOM_LEVEL"]["filterValues"];

  $parameters= array();
  dms_import_v2($parameters, "BOTTOM_LEVEL", array("report" => "string"));

  $sqls= array();
  $errors= cleanValuesForDatabase($parameters["BOTTOM_LEVEL"],
    array("report" => array("type" => "string", "required" => true)));
  $report= $parameters["BOTTOM_LEVEL"]["report"];
  $reportTitles= getReportTitles();
  $reportName= $reportTitles[$report];

  $reportValues= readAdmReportCommon(array("report" => $report, "includeSchema" => "Y", "limit" => -1, "offset" => 0, "sortCols" => $sortCols, "sortDirs" => $sortDirs, "filterCols" => $filterCols,
      "filterOps" => $filterOps, "filterValues" => $filterValues, "dontIncludeId" => "Y"), $dbh, $showSQL, $errors, $sqls, $reportList, $defaultDateFormat, $cookieName);

  printCSVData($reportValues, $report, $reportName, $reportList, $defaultDateFormat, "\t");
}

if (isset($previousScript))
  return;

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

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

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

$reports= getReportTitles();

$reportDDL= array();
$reportMenuDDL= array();
foreach($reports as $value => $text)
{
  $reportDDL[]= array("value" => $value, "text" => $text);

  //if ($value != $report)
    $reportMenuDDL[$text]= array("url" => "$presentationFile?report=" . $value);
}
$reportMenuDDL= array("REDIRECT" => array("list" => array("Report List" => array("url" => $presentationFile))), "Other Reports" => array("list" => $reportMenuDDL),
  "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 == "")
{
  $title= "Please Select Report";
  printMonitorPageTop($title, $homecuKendoVersion, $cloudfrontDomainName, '', '', true); ?>
<style>
  .grid_12 {
    margin-top: 5px;
  }
  .reportMenu {
    color: #595959;
    width: 90%;
    background: #fff;
    border-width: 0px;

  }
  .reportMenu .sectionHeader {
    background:gray;
    font-family:arial,helvetica;
    font-size:14pt;
    color:#fff
  }

  /* copy from admin_master CSS to get styling. Adding CSS in monitorView.i will mess up a lot of stuff */
  .reportMenu td {
    font-size:12px;
    padding: 2px;
    margin: 2px;
  }

  .reportMenu .odd {
    background:#f7f8fa;
  }

  .reportMenu .even {
    background:#ededed;
  }

  .serverCheck {
    margin-left: 36px;
  }

  #optionsRow > div {
    display: inline;
  }
</style>
<script type="text/javascript">
<?php
getErrorsAreShownFunction();
getEscapeHTMLFunction();
?>
function initReportSelectPage()
{

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

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

    var data= {error: []};
    if ($(".reportRadioButton:checked").length == 0)
      data.error.push("Please select a report.");

    if (!errorsAreShown(data, "formValidateMainDiv"))
    {
      var url= $(".reportRadioButton:checked").val();
      var showServer= $("#showServerCheckbox:checked").length > 0 ? "Y" : "N";
      var servers= [];
      if ($("#www3Checkbox").prop("checked"))
        servers.push("www3");
      if ($("#www5Checkbox").prop("checked"))
        servers.push("www5");
      if ($("#www6Checkbox").prop("checked"))
        servers.push("www6");
      if ($("#myCheckbox").prop("checked"))
        servers.push("<?php echo $_SERVER['SERVER_NAME']; ?>");
      servers= kendo.stringify(servers);
      url+= "&showServer=" + showServer + "&servers=" + servers;
      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_12">
    <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">
      <?php echo compileMenu($reportMenu, $reportList, $dataFile, true); ?>
    </div>
    <div class="grid_12">Include Data from:</div>
    <div class="grid_12">
      <div class="serverCheck">www3: <input type="checkbox" id="www3Checkbox"></div>
    </div>
    <div class="grid_12">
      <div class="serverCheck">www5: <input type="checkbox" id="www5Checkbox"></div>
    </div>
    <div class="grid_12">
      <div class="serverCheck">www6: <input type="checkbox" id="www6Checkbox"></div>
    </div>
    <div class="grid_12">
      <div class="serverCheck">Odyssey: <input type="checkbox" id="myCheckbox"></div>
    </div>
    <div class="grid_12">
      Show Server: <input type="checkbox" id="showServerCheckbox">
    </div>
    <div class="grid_12">
      <a href="#" class="k-button k-button-icontext" id="runReportBtn">Go</a>
    </div>
  </div>
<?php printMonitorPageBottom();
}
// Page for displaying the reports.
// **************************************************************
else
{
  $title= isset($reports[$report]) ? $reports[$report] : "Unrecognized Report";
  printMonitorPageTop($title, $homecuKendoVersion, $cloudfrontDomainName);
?>

<style>
  .hide { position:absolute; top:-1px; left:-1px; width:1px; height:1px; }
  #filterSettingsDiv {
    width: 342px;
    margin-bottom: 5px;
    border: 1px solid black;
    border-radius: 5px;
    padding: 5px;
  }
  #filterSettingsDiv > div {
    width: 33%;
    display: inline;
  }
  #formValidateMainDiv li {
    list-style-position: inside;
  }
</style>

<script type="text/javascript">

<?php
if (!isset($showServer)) {$showServer = "";}
if (!isset($servers)) {$servers = "";}

// 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= "150px"; // CU
}

function addWidthsPost(grid)
{
  for(var i=1, length=grid.columns.length; i!=length; i++)
  {
    grid.autoFitColumn(i);
  }
  var tableWidth= Number($("#reportGrid table").css("width").replace("px", ""));
  var minWidth= 400;
  var colWidth= 0;
  if (tableWidth < minWidth)
  {
    tableWidth= minWidth;
    colWidth= (minWidth-150)/(grid.columns.length-1);
    $("#reportGrid .k-grid-header-wrap").find("colgroup col:not(:first)").width(colWidth);
    $("#reportGrid .k-grid-content").find("colgroup col:not(:first)").width(colWidth);
  }
  $("#reportGrid").css({width: tableWidth});
  grid.reorderColumn(1, grid.columns[0]);
  grid.reorderColumn(1, grid.columns[0]);
}

function showNote()
{
    var notification = $("#notification").kendoNotification({
    position: {
      pinned: true,
      top: 118,
      left: 128
    },
    show: function ()
    {
      notificationIsShown= true;
    },
    hide: function ()
    {
      notificationIsShown= false;
    }
  }).data("kendoNotification");

  var notifificationIsShown= false;
  var infoLine= "<span class=\"k-icon k-i-filter\"></span><b>To Filter:</b> Click on the (<span class=\"k-icon k-i-filter\"></span>) icon in a column that you want to filter.  A dialog will pop up with filter value and options.<br>";
  infoLine+= "<span class=\"k-icon k-i-arrow-n\"></span><b>To Sort:</b> Click on a column (not on the (<span class=\"k-icon k-i-filter\"></span>) icon).  That column will sort ascending.  ";
  infoLine+= "Column will show with the (<span class=\"k-icon k-i-arrow-n\"></span>) icon.  Click again and it will sort descending.  ";
  infoLine+= "Column will show with the (<span class=\"k-icon k-i-arrow-s\"></span>) icon. A third click will clear the sort.";
  notification.info(infoLine);
}

$(document).ready(function () {
  initReport();
  $("#helpBtn").click(function () {
    showNote();
    return false;
  });
});
</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>
    <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