TrustedReport.prg

<?php
  /*
   * File: TrustedReport
   *
   * Purpose:  To show trusted vendor master and detail settings
   * Changes:
   *  SPB 9/28/2015-- Added aggregateData function to get values from a proxy file that gathers all TrustedReport.data from all applicable servers versus a call to TrustedReport.data.
   *  SPB 9/28/2015-- Added calls to common header.
   *  ENR 2/26/2019-- Added small form to export clients and trusted detail values to csv
   */
$monLibrary= dirname(__FILE__) . "/../library";
require_once("$monLibrary/cu_top.i");
require_once("$monLibrary/ck_hticket.i");
require_once("$sharedLibrary/cu_func.i");
require_once("$monLibrary/monitorView.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;
  }

  printMonitorPageTop("Trusted Vendor Report", $homecuKendoVersion, $cloudfrontDomainName);
?>
<style>
      body {
        font-family: Arial, Helvetica, sans-serif;
        background-color: #EFEFEF;
      }
     .k-grid .k-hierarchy-col {
        width: 10px;
      }
      #currentStatus {
        position: fixed;
        right: 20px;
        top:50px;
        width: 250px;
        padding: 10px;
      }
      .settingStatus {
        width: 500px;
        min-height: 50px;
        padding-top: 10px;
        z-index: 10010;
      }
      .settingStatus .section,
      .settingStatus .section-clean,
      .settingStatus .section-dirty {
        margin-bottom: 20px;
      }
      #currentStatus.dirty .section-dirty {
        display: block;
      }
      #currentStatus.clean .section-clean {
        display: block;
      }

      #gridProxy {
        font-size: 12px;
        width: 500px;
      }
      .k-tooltip-content { text-align: left;
                           font-size: 12px;
                           max-width: 300px;
                         }

      .Clients .k-hierarchy-col {
        width: 50px;
      }

      .k-grid td {
         border-width: 0;
      }

  #exportForm {
    margin: .5em;
  }

</style>

<?php printMonitorPageMiddle("Trusted Vendor Report"); ?>

<div style='font-size:12px;'>
    <script id="masterpropTempl" type="text/x-kendo-template">
        <div class="tabstrip">
            <ul>
                <li class="k-state-active">#=trustedid # Properties</li>
                <li>Clients</li>
            </ul>
            <div class="k-block">
                <table>
                    # for (var i = 0; i < trustedprops.length; i++){ #
                    <tr>
                        <td width="20%">#=trustedprops[i].vname #</td>
                        <td width="20%">#=trustedprops[i].vtype #</td>
                        <td width="*">#=trustedprops[i].vdefault #</td>
                    </tr>
                    # } #
                </table>
            </div>
            <div>
                <div class="Clients"></div>
            </div>
        </div>
    </script>
</div>
    <script id="clientpropTempl" type="text/x-kendo-template">
    <div class="k-block">
        <table>
        # for (var i = 0; i < trustedprops.length; i++){ #
        <tr>
            <td>#=trustedprops[i].propname #</td>
            <td>#=trustedprops[i].propval #</td>
        </tr>
        # } #
        </table>
    </div>
</script>
<form id="exportForm" action="TrustedReport.proxy.data" method="POST">
<label for="trustedid" class="k-label">Enter a Trusted ID:</label>
<input id="trustedid" name="trustid" class="k-textbox" type="text" required/>
<input id="action" name="action" class="k-hidden" type="hidden" value="export_clients"/>
<input type="submit" id="exportBtn" class="k-button" value="Export"/>
</form>
<div id="mastergrid"></div>

<script>
  $(document).ready(function() {

    //autocomplete for Vendor IDs input
    $("#trustedid").kendoAutoComplete({
      minlength: 2,
      clearButton: false,
      dataTextField: "trustedid",
      dataSource: new kendo.data.DataSource({
        transport: {
          read: function(options) {
            aggregateData(options, "read_master");
          }
        },
        schema: {
          data: "homecuData"
        }
      }),
      placeholder: "Start typing...",
      change: function() {
        var found = false;
        var value = $("#trustedid").val();
        var data = this.dataSource.view();
        for( var i = 0, length = data.length; i < length; i++ ) {
          if( data[i].trustedid === value) {
            found = true;
            break;
          }
        }

        if( !found ) {
          this.value("");
          alert("Please select a value from the list.");
        }
      }
    });

    $("#mastergrid").kendoGrid({
      dataSource: {
        pageSize: 10,
        serverPaging: false,
        transport: {
          read: function(options) {
            aggregateData(options, "read_master");
          }
        },
        schema: {
          data: "homecuData",
          total: "homecuCount",
          model: {
            fields: {
              trustedid : {type: "string"},
              trustedvendor : {type: "string"},
              trustedtype : {type: "string"},
              trustedprops : {Type : {type: "string"}, Default : {type: "string"}}
            }
          }
        },
        sort: [{field: "trustedid", dir: "asc"}]
      },
      sortable: true,
      pageable: {
        pageSizes: [10, 20, 50],
        info: true,
        refresh: true,
          messages: {
            display: "Showing {0}-{1} from {2} data items"
          }
      },
      columns: [
        {
          field: "trustedid",
          title: "Trusted ID",
          width: "50px"
        },
        {
          field: "trustedvendor",
          title: "Vendor",
          width: "50px"
        },
        {
          field: "trustedtype",
          title: "Type",
          width: "45px"
        },
      ],
      detailTemplate: kendo.template($("#masterpropTempl").html()),
      detailInit: function(e) {
          var detailRow = e.detailRow;
          detailRow.find(".tabstrip").kendoTabStrip({
            animation: {
              open: { effects: "fadeIn" }
            }
          });
          detailRow.find(".Clients").kendoGrid({
            detailTemplate: kendo.template($("#clientpropTempl").html()),
            detailInit: function(e) {
              // without this line, detail template bindings will not work
              kendo.bind(e.detailRow, e.data);
            },

            dataSource: {
              autoSync: false,
              batch: false,
              serverPaging: false,
              pageSize: 10,
              transport: {
                read: function(options) {
                  aggregateData(options, "read_clients", e.data.trustedid);
                }
              },
              schema: {
                data: "homecuData",
                total: "homecuCount",
                model: {
                  fields: {
                    cu : {type: "string"},
                    trustedid : {type: "string"},
                    trustedprops : {propname : {type: "string"}, propval : {type: "string"}},
                    server: {type: "string"}
                  }
                }
              },
              sort: [{field: "cu", dir: "asc"}]
            },
            scrollable: false,
            sortable: true,
              pageable: {
                info: true,
                refresh: true,
                messages: {
                  display: "Showing {0}-{1} from {2} data items"
                }
              },
              columns: [
                { field: "server", title: "Server", width: "33%"},
                { field: "cu", title: "Client", width: "34%"},
                { field: "trustedid", title:"Trusted ID", width: "33%"}
              ]
            });
          }
        });
      });

function aggregateData(options, action, trustedid) {
  $.post("TrustedReport.proxy.data", {action: action, trustid: trustedid}, function (data) {
    options.success(data);
  });

}



</script>

<?php printMonitorPageBottom(); ?>