<?php
  require_once('Sajax.php');
  require_once('camdpams.class.php');

  function getReportSamplesVsSigs2($aFrom, $aTo, $aPeriod){
    $camdpams = new Camdpams();
    $result = $camdpams->getReportSamplesVsSigs2($aFrom, $aTo, $aPeriod);
    return $result;
  }

  function getReportSha1PerFamily($aFrom, $aTo, $aFamily, $aDetectedBy, $aPeriod, $aIncludeVariant){
    $camdpams = new Camdpams();
    $result = $camdpams->getReportSha1PerFamily($aFrom, $aTo, $aFamily, $aDetectedBy, $aPeriod, $aIncludeVariant);
    return $result;
  }

  function getReportSha1PerVariant($aFrom, $aTo, $aVariant, $aDetectedBy, $aPeriod){
    $camdpams = new Camdpams();
    $result = $camdpams->getReportSha1PerVariant($aFrom, $aTo, $aVariant, $aDetectedBy, $aPeriod);
    return $result;
  }

  function getAnalystNames(){
    $camdpams = new Camdpams();
    $stream = $camdpams->getAnalystNames();
    return $stream;
  }

  function getReportFamiliesPerAnalyst($aName){
    $camdpams = new Camdpams();
    $result = $camdpams->getReportFamiliesPerAnalyst($aName);
    return array("tblReportFamiliesPerAnalyst", $result);
  }

  function assignFamilyToAnalyst($aFamilyName, $aAnalystName){
    $camdpams = new Camdpams();
    $arrResult = $camdpams->addAssignFamilyToAnalyst($aFamilyName, $aAnalystName);
    return $arrResult;
  }

  function isFamilyAssignedToSomeone($aFamilyName){
    $camdpams = new Camdpams();
    $arrResult = $camdpams->isFamilyAssignedToSomeone($aFamilyName);
    $found = $arrResult[0];
    $name = '';
    if ($found){
      $name = $arrResult[2];
      if ( $arrResult[3] ){ $name .= ' ' . $arrResult[3]; }
    }
    return array($found, $name);
  }

  function getReportAnalystsPerFamily($aFamily){
    $camdpams = new Camdpams();
    $arrResult = $camdpams->getReportAnalystsPerFamily($aFamily);
    return array("tblReportAnalystsPerFamily", $arrResult);
  }

  function familyIntellisense($aFamily){
    $camdpams = new Camdpams();
    $arrResult = $camdpams->familyIntellisense($aFamily);
    $retVal = "";
    for ($i = 0; $i < count($arrResult); $i++){
      $retVal .= $arrResult[$i] . "|";
    }
    return $arrResult;
  }

  function addComment($aID, $aComment){
    $camdpams = new Camdpams();
    $arrResult = $camdpams->editAnalystPerFamilyData($aID, "comment", "TicketId: $aComment");
    return $arrResult;
  }

  function saveIsActive($aID, $aIsActive){
    $camdpams = new Camdpams();
    $arrResult = $camdpams->editAnalystPerFamilyData($aID, "isactive", $aIsActive);
    return $arrResult;
  }
  
  function saveLatestDueDate($aID, $aDate){
    if ($aDate && $aDate !== 'None'){
      // Convert date into db format
      $arrDate = explode("/", $aDate);
      $date = $arrDate[2] . "-" . $arrDate[1] . "-" . $arrDate[0];
    }else{
      $date = '';
    }
    $camdpams = new Camdpams();
    $arrResult = $camdpams->editAnalystPerFamilyData($aID, "latestdue", $date);
    return $arrResult;
  }

  function saveIsPoly($aID, $aIsActive){
    $camdpams = new Camdpams();
    $arrResult = $camdpams->editAnalystPerFamilyData($aID, "ispoly", $aIsActive);
    return $arrResult;
  }

  function saveNeedsEmulator($aID, $aIsActive){
    $camdpams = new Camdpams();
    $arrResult = $camdpams->editAnalystPerFamilyData($aID, "needsemulator", $aIsActive);
    return $arrResult;
  }

  function saveNeedsDisassembler($aID, $aIsActive){
    $camdpams = new Camdpams();
    $arrResult = $camdpams->editAnalystPerFamilyData($aID, "needsdisassembler", $aIsActive);
    return $arrResult;
  }

  function saveNeedsPackerSupport($aID, $aIsActive){
    $camdpams = new Camdpams();
    $arrResult = $camdpams->editAnalystPerFamilyData($aID, "packersupport", $aIsActive);
    return $arrResult;
  }
  
  function getReportFamilySearch($aPattern){
    $camdpams = new Camdpams();
    $arrResult = $camdpams->getReportFamilySearch($aPattern);
    return $arrResult;
  }
  
  function getReportFamilyStats($aFamily){
    $camdpams = new Camdpams();
    $arrResult = $camdpams->getReportFamilyStats($aFamily);
    return $arrResult;
  }


  /*
    ====================
    Sajax Initialisation
    ====================
  */
  $sajax_request_type = "POST";
  $sajax_debug_mode = 0;
  sajax_init();
  sajax_export( "getReportSamplesVsSigs2"
              , "getReportSha1PerFamily"
              , "getReportSha1PerVariant"
              , "getReportFamiliesPerAnalyst"
              , "assignFamilyToAnalyst"
              , "isFamilyAssignedToSomeone"
              , "getReportAnalystsPerFamily"
              , "familyIntellisense"
              , "addComment"
              , "saveIsActive"
              , "saveIsPoly"
              , "saveNeedsEmulator"
              , "saveNeedsDisassembler"
              , "saveNeedsPackerSupport"
              , "saveLatestDueDate"
              , "getReportFamilySearch"
              , "getReportFamilyStats"
              );
  sajax_handle_client_request();


?>

<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.0//EN'>
<html>
<head>
<meta http-equiv='content-type' content='text/html;charset=utf-8'>
<meta name='robots' content='noindex,nofollow'>
<title>[CAMDPAMS MIS] Reports: Samples-Advanced</title>
<link rel='stylesheet' type='text/css' href='camdpams.css'>
<link rel='stylesheet' type='text/css' href='intellisense.css'>
<link rel='stylesheet' type='text/css' href='edit-analyst-family-grid.css'>
<!--<link rel='stylesheet' type='text/css' href='color.css'> -->
<script type='text/javascript' src='camdpams.js'></script>
<script type='text/javascript' src='spinner.js'></script>
<script type='text/javascript' src='intellisense.js'></script>
<script type='text/javascript' src='edit-analyst-family-grid.js'></script>
<script type='text/javascript' src='prototype.js'></script>
<script type='text/javascript' src='scw.js'></script>


<style type='text/css'>
  #samplesCsVsSigsTbl .co1 {
  	text-align: right;
  	width: 400px;
  }
  #samplesCsVsSigsTbl .header .co1 {
  	text-align: left;
  }

  </style>

    <style type='text/css'>
    #tblReportFamiliesPerAnalyst tr td {
      font-size: 8pt;
    }

    
    #tblReportFamiliesPerAnalyst .co1 {
    	text-align: right;
    	width: 40px;
    }
    #tblReportFamiliesPerAnalyst .header .co1 {
    	text-align: left;
    }
    #tblReportFamiliesPerAnalyst .co1 {
    	width: 60px;
    }

    /*
      ===================================
      Assign Analyst to Family Messagebox
      BEGIN
      ===================================
    */

    #divCheckAssign {
      display: none;
    }

    #divCheckAssign {
      width: auto;
      height: auto;
      margin-left: 167px;
      float: left;
    }

    #divCheckAssignMessage {
      position: relative;
      width: 500px;
      padding-top: 10px;
      padding-bottom: 30px;
      margin-left: auto;
      margin-right: auto;
      margin-bottom: 5px;

      color: #000;
    	background: #FDFDFD;
    	border-top: 1px solid #ddd;
    	border-left: 1px solid #ddd;
    	border-bottom: 1px solid #ccc;
    	border-right: 1px solid #ccc;
    }

    #p1_divCheckAssignMessage {
      margin-bottom:10px;
      margin-left:auto;
      margin-right:auto;
      padding-left: 10px;
      padding-right: 10px;
      text-align: center;
      color: #AF4141;
    }

    #divCheckAssignYesNo {
      position:relative;
      width:100px;
      height:auto;
      margin-left:auto;
      margin-right:auto;
      margin-bottom:20px;
    }

    #btnYesAssign {
      position:absolute;
      left:0px;
    }

    #btnNoAssign {
      position:absolute;
      right:0px;
    }

    /*
      ===================================
      END
      Assign Analyst to Family Messagebox
      ===================================
    */

</style>
<script type='text/javascript'>
  <?
    /*
      ====================
      Sajax Initialisation
      ====================
    */
  sajax_show_javascript();
  ?>

  function init()
  {
  	var s;
  	if ((s = cookie.get('samplesReport0Period')) != null) E('_samplesReport0Period').value = s;
  	if ((s = cookie.get('samplesReportSamplesVsSigs2Period')) != null) E('_samplesReportSamplesVsSigs2Period').value = s;
  	if ((s = cookie.get('samplesReportSha1PerFamilyIncludeVariant')) != null) E('_samplesReportSha1PerFamilyIncludeVariant').value = s;
  	if ((s = cookie.get('samplesReportSha1PerVariantPeriod')) != null) E('_samplesReportSha1PerVariantPeriod').value = s;
  	E('_samplesReportSamplesVsSigs2Period').onkeypress = function(ev) { if (checkEvent(ev).keyCode == 13) getReportSamplesVsSigs2(); }
  	E('_samplesReportSha1PerFamilyPeriod').onkeypress = function(ev) { if (checkEvent(ev).keyCode == 13) getReportSha1PerFamily(); }
  	E('_samplesReportSha1PerVariantPeriod').onkeypress = function(ev) { if (checkEvent(ev).keyCode == 13) getReportSha1PerVariant(); }

  }

  function disableButtons(){
    enableDisableButton('samplesReportSamplesVsSigs2Btn', 1);
    enableDisableButton('samplesReportSha1PerFamilyBtn', 1);
    enableDisableButton('samplesReportSha1PerVariantBtn', 1);
    enableDisableButton('samplesReportFamiliesPerAnalystBtn', 1);
    enableDisableButton('btnAssignFamiliesPerAnalyst', 1);
    enableDisableButton('btnReportAnalystsPerFamily', 1);
    enableDisableButton('btnReportFamilySearch', 1);
  }

  function enableButtons(){
    enableDisableButton('samplesReportSamplesVsSigs2Btn', 0);
    enableDisableButton('samplesReportSha1PerFamilyBtn', 0);
    enableDisableButton('samplesReportSha1PerVariantBtn', 0);
    enableDisableButton('samplesReportFamiliesPerAnalystBtn', 0);
    enableDisableButton('btnAssignFamiliesPerAnalyst', 0);
    enableDisableButton('btnReportAnalystsPerFamily', 0);
    enableDisableButton('btnReportFamilySearch', 0);
  }

  function openReportXLFolder_cb(arrResult){
    removeSpinner();
    enableButtons();
    if ( arrResult[0] == undefined ){
      var result = arrResult;
    }else{
      var result = arrResult[0];
    }
    if (result == 'fileName = empty'){
      window.alert('No data found');
    }else{
      var folder = arrResult[1];
      if (!folder){ folder = false; }
      openReportsUrlPath(folder);
    }
  }

  function openReportsUrlPath(folder){
    if (!folder){ folder = 'reports'; }
    var url = "http://mis.camdpams.comodo.com/" + folder;
    this.location.href = url;
  }


  function enableDisableButton(buttonID, isDisabled){
    document.getElementById(buttonID).disabled = isDisabled;
  }

  function getElemByName(elem){
    var arrElements = document.getElementsByName(elem);
    return arrElements[0];
  }

  function getTableData_cb(arrResult){
    removeSpinner();
    var table = arrResult[0];
    var data = arrResult[1];
    var obj = eval(table);
    obj.populate = function(text){
      if (text){
      	var i, r;
      	var buf = text.split('\n');
      	this.removeAllData();
      	for (i = 0; i < buf.length-1; ++i) {
      		r = buf[i].split('|');
      		this.insertData(-1, r);
      	}
      }else{
        this.removeAllData();
        var totCols = this.tb.getElementsByTagName('tr')[0].getElementsByTagName('td').length
        var tr=document.createElement('tr');
        for(var i=0;i<totCols;i++){
            var td=document.createElement('td');
            td.appendChild(document.createTextNode('No data'));
            tr.appendChild(td);
        }
        this.tb.appendChild(tr);
      }
    }
    obj.populate(data);
    if ( obj.extra != undefined ){ obj.extra(); }
    enableButtons();
  }

  function isNumeric(id){
    var obj = document.getElementById(id);
    if ( isNaN(obj.value)==true ){
      alert("Please enter digits");
      return false;
    }
    return true;
  }

</script>
</head>
  <body onload='init()'>
    <form action='javascript:{}'>
      <table id='container' cellspacing=0>
        <tr>
          <td colspan=2 id='header'>
          	<div class='title'>CAMDPAMS Management Information System</div>
          	<div class='version'>Version 1.1</div>
          </td>
        </tr>
        <tr id='body'>
          <td id='navi'><script type='text/javascript'>navi()</script></td>
          <td id='content'>
            <div id='ident'>CAMDPAMS</div>



            <!--
              =================================
              Advanced Report Samples Vs Sigs 2
              BEGIN
              =================================
            -->

            <div class='section-title'>All Families</div>
            <div id='divReportSamplesVsSigs2Section' class='section'>
              <script type='text/javascript'>
                createFieldTable('', [
                	{ title: 'Period'
                  , name: 'samplesReportSamplesVsSigs2Period'
                  , type: 'select'
                  , options: [['Today','Today'],['Yesterday','Yesterday'],['This Week','This Week'],['Last Week','Last Week'],['This Month','This Month'],['Last Month','Last Month']]
                  , value: "Today"
                  , onfocus: "isOkToCloseIntellisense(this);"
                  , suffix: ' <input type="button" value="Get report" onclick="isOkToCloseIntellisense(this); getReportSamplesVsSigs2();" id="samplesReportSamplesVsSigs2Btn">'
                  }
                ]);

                function getReportSamplesVsSigs2(){
                  var period = E('_samplesReportSamplesVsSigs2Period').value;
                  var r = getRangeByPeriod(period);
                	var from = r.from.toDateString();
                	var to = r.to.toDateString();
                  cookie.set('_samplesReportSamplesVsSigs2Period', period);
                  disableButtons();
                  addSpinner('divReportSamplesVsSigs2Section');
                	x_getReportSamplesVsSigs2(from, to, period, openReportXLFolder_cb);
                }

              </script>
            </div>

            <!--
              =================================
              END
              Advanced Report Samples Vs Sigs 2
              =================================
            -->


            <div class='section-title'>Family Specific On-Demand Samples Report</div>
            <div id='divReportSha1PerFamilySection' class='section'>
              <script type='text/javascript'>
                createFieldTable('', [
                  { title: 'Family'
                  , name: 'samplesReportSha1PerFamilyName'
                  , type: 'text'
                  , size: '50'
                  , value: ""
                  , onfocus: "isOkToCloseIntellisense(this);"
                  , onkeyup: "familyIntellisense(this);"
                  },
                  { title: 'Detected By'
                  , name: 'samplesReportSha1PerFamilyList'
                  , type: 'select'
                  , options: [['PE/Gen','PE/Gen'],['First','First'],['Complete','All Type Signs']]
                  , value: 'PE/Gen'
                  , onfocus: "isOkToCloseIntellisense(this);"
                  },
                  { title: 'Period'
                  , name: 'samplesReportSha1PerFamilyPeriod'
                  , type: 'select'
                  , options: [['Today','Today'],['Yesterday','Yesterday'],['This Week','This Week'],['Last Week','Last Week'],['This Month','This Month'],['Last Month','Last Month']]
                  , value: "Today"
                  , onfocus: "isOkToCloseIntellisense(this);"
                  },
                  { title: 'Include variant?'
                  , name: 'samplesReportSha1PerFamilyIncludeVariant'
                  , type: 'checkbox'
                  , value: '0'
                  , onfocus: "isOkToCloseIntellisense(this);"
                  , suffix: ' <input type="button" value="Get report" onclick="isOkToCloseIntellisense(this); getReportSha1PerFamily();" id="samplesReportSha1PerFamilyBtn">'
                  }
                ]);

                function getReportSha1PerFamily(){
                  var includeElem = getElemByName('samplesReportSha1PerFamilyIncludeVariant');
                  if ( includeElem.checked ){
                    includeElem.value = '1';
                  }else{
                    includeElem.value = '0';
                  }
                  var period = E('_samplesReportSha1PerFamilyPeriod').value;
                  var family = E('_samplesReportSha1PerFamilyName').value;
                  var detected = E('_samplesReportSha1PerFamilyList').value;
                  var variant = E('_samplesReportSha1PerFamilyIncludeVariant').value;
                  var r = getRangeByPeriod(period);
                	var from = r.from.toDateString();
                	var to = r.to.toDateString();
                  cookie.set('_samplesReportSha1PerFamilyPeriod', period);
                  cookie.set('_samplesReportSha1PerFamilyName', family);
                  cookie.set('_samplesReportSha1PerFamilyList', detected);
                  cookie.set('_samplesReportSha1PerFamilyIncludeVariant', variant);
                  disableButtons();
                  addSpinner('divReportSha1PerFamilySection');
                	x_getReportSha1PerFamily(from, to, family, detected, period, variant, openReportXLFolder_cb);
                }

              </script>
            </div>
            <div class='section-title'>Variant Specific Report</div>
            <div id='divReportSha1PerVariantSection' class='section'>
              <script type='text/javascript'>
                createFieldTable('', [
                	{ title: 'Variant'
                  , name: 'samplesReportSha1PerVariantName'
                  , type: 'text'
                  , size: '50'
                  , value: ""
                  , onfocus: "isOkToCloseIntellisense(this);"
                  },
                  { title: 'Detected By'
                  , name: 'samplesReportSha1PerVariantList'
                  , type: 'select'
                  , options: [['PE/Gen','PE/Gen'],['First','First'],['Complete','Complete']]
                  , value: 'PE/Gen'
                  , onfocus: "isOkToCloseIntellisense(this);"
                  },
                  { title: 'Period'
                  , name: 'samplesReportSha1PerVariantPeriod'
                  , type: 'select'
                  , options: [['Today','Today'],['Yesterday','Yesterday'],['This Week','This Week'],['Last Week','Last Week'],['This Month','This Month'],['Last Month','Last Month']]
                  , value: "Today"
                  , onfocus: "isOkToCloseIntellisense(this);"
                  , suffix: ' <input type="button" value="Get report" onclick="isOkToCloseIntellisense(this); getReportSha1PerVariant();" id="samplesReportSha1PerVariantBtn">'
                  }
                ]);

                function getReportSha1PerVariant(){
                  var period = E('_samplesReportSha1PerVariantPeriod').value;
                  var variant = E('_samplesReportSha1PerVariantName').value;
                  var detected = E('_samplesReportSha1PerVariantList').value;
                  var r = getRangeByPeriod(period);
                	var from = r.from.toDateString();
                	var to = r.to.toDateString();
                  cookie.set('_samplesReportSha1PerVariantPeriod', period);
                  cookie.set('_samplesReportSha1PerVariantName', variant);
                  cookie.set('_samplesReportSha1PerVariantList', detected);
                  disableButtons();
                  addSpinner('divReportSha1PerVariantSection');
                	x_getReportSha1PerVariant(from, to, variant, detected, period, openReportXLFolder_cb);
                }

              </script>
            </div>


            <!--
              ====================================
              Advanced Report Families Per Analyst
              BEGIN
              ====================================
            -->

            <div class='section-title'>Advanced Report Families Per Analyst</div>
            <div id='divReportFamiliesPerAnalystSection' class='section'>
              <script type='text/javascript'>

                createFieldTable('', [
                  { title: 'Analyst Name'
                  , name: 'samplesReportFamiliesPerAnalystNameList'
                  , type: 'select'
                  , options: <?php echo ( getAnalystNames() ); ?>
                  , value: ''
                  , onfocus: "isOkToCloseIntellisense(this);"
                  , suffix: ' <input type="button" value="Get report" onclick="isOkToCloseIntellisense(this); getReportFamiliesPerAnalyst();" id="samplesReportFamiliesPerAnalystBtn">'
                  },
                  { title: 'Family Name'
                  , name: 'samplesReportFamiliesPerAnalystFamilyName'
                  , type: 'text'
                  , size: '50'
                  , value: ""
                  , onkeyup: "familyIntellisense(this);"
                  , onfocus: "isOkToCloseIntellisense(this);"
                  , suffix: ' <input type="button" value="Assign To Analyst" onclick="isOkToCloseIntellisense(this); isFamilyAssignedToSomeone();" id="btnAssignFamiliesPerAnalyst">'
                  }
                ]);

                // Assigning onChange() event to analyst-names select-list
                document.getElementById('_samplesReportFamiliesPerAnalystNameList').setAttribute("onChange", "changeAnalyst();" );
                function changeAnalyst(){
                  var selName = document.getElementById('_samplesReportFamiliesPerAnalystNameList');
                  var idx = selName.selectedIndex;
                  var title = selName.options[idx].text;
                  document.getElementById('btnAssignFamiliesPerAnalyst').value = "Assign To " + title;
                }
                changeAnalyst();

                function getReportFamiliesPerAnalyst(){
                  var name = E('_samplesReportFamiliesPerAnalystNameList').value;
                  cookie.set('_samplesReportFamiliesPerAnalystNameList', name);
                  disableButtons();
                  addSpinner('divReportFamiliesPerAnalystSection');
                  x_getReportFamiliesPerAnalyst(name, getTableData_cb);
                }

                function isFamilyAssignedToSomeone(){
                  var analyst = E('_samplesReportFamiliesPerAnalystNameList').value;
                  cookie.set('_samplesReportFamiliesPerAnalystNameList', analyst);
                  var family = E('_samplesReportFamiliesPerAnalystFamilyName').value;
                  cookie.set('_samplesReportFamiliesPerAnalystFamilyName', family);
                  disableButtons();
                  x_isFamilyAssignedToSomeone(family, isFamilyAssignedToSomeone_cb);
                }

                function isFamilyAssignedToSomeone_cb(result){
                  var found = result[0];
                  if (found){
                    var selName = document.getElementById('_samplesReportFamiliesPerAnalystNameList');
                    var idx = selName.selectedIndex;
                    var newAnalyst = selName.options[idx].text;
                    var oldAnalyst = result[1];
                    var family = E('_samplesReportFamiliesPerAnalystFamilyName').value;
                    document.getElementById('divCheckAssign').style.display = 'block';
                    document.getElementById('divCheckAssign').innerHTML =
                      '<div id="divCheckAssignMessage">'
                    +   '<p id="p1_divCheckAssignMessage" >'
                    +     'This family, ' + family + ', is assigned to ' + oldAnalyst + '. '
                    +     'Are you sure you want to assign to ' + newAnalyst + ' instead?<br/>'
                    +   '</p>'
                    +   '<div id="divCheckAssignYesNo" >'
                    +     '<input type="button" value="Yes" onclick="assignFamilyToAnalyst();" id="btnYesAssign">'
                    +     '<input type="button" value="No" onclick="closeFamilyAssignAnalystMessage();" id="btnNoAssign">'
                    +   '</div>'
                    + '</div>';
                  }else{
                    assignFamilyToAnalyst();
                  }
                }

                function assignFamilyToAnalyst(){
                  closeFamilyAssignAnalystMessage();
                  var analyst = E('_samplesReportFamiliesPerAnalystNameList').value;
                  var family = E('_samplesReportFamiliesPerAnalystFamilyName').value;
                  addSpinner('divReportFamiliesPerAnalystSection');
                  var command = "x_assignFamilyToAnalyst('" + family + "', '" + analyst + "', assignFamilyToAnalyst_cb);";
                  setTimeout(command, 250);
                }

                function assignFamilyToAnalyst_cb(result){
                  var success = result[0];
                  if (success){
                    var command = "getReportFamiliesPerAnalyst();";
                    setTimeout(command, 250);
                    getReportFamiliesPerAnalyst()
                  }else{
                    removeSpinner();
                    var message = result[1];
                    window.alert(message);
                  }
                }

                function closeFamilyAssignAnalystMessage(){
                  document.getElementById('divCheckAssign').innerHTML = "";
                  document.getElementById('divCheckAssign').style.display = 'none';
                  enableButtons();
                }

              </script>
              <div id='divCheckAssign'></div>
              <div id="divLegend">
                <label><strong>IPN:</strong></label><span>Is Packer Support Needed</span>
                <label><strong>IP:</strong></label><span>Is Poly</span>
                <label><strong>NE:</strong></label><span>Needs Emulator</span>
                <label><strong>ND:</strong></label><span>Needs Disassembler</span>
              </div>
              <style>
              
                #divLegend {
                  width: auto;
                  margin-top: 10px;
                  margin-bottom: 5px;
                }
                
                #divLegend label {
                  margin-right: 2px;
                }
                
                #divLegend span {
                  margin-left: 1px;
                  margin-right: 10px;
                }

              </style>
              <table id='tblReportFamiliesPerAnalyst' class='camdpams-grid' cellspacing=1></table>
              <script language='javascript'>
                var tblReportFamiliesPerAnalyst = new CamdpamsGrid();
                tblReportFamiliesPerAnalyst.setup = function() {
                	this.init('tblReportFamiliesPerAnalyst');
                	this.headerSet(['Id', 'FamilyName', 'Vendor', 'Assigned', 'UnAssigned', 'Active', 'Comment', 'LatestDue', 'IP', 'NE', 'ND', 'IPN']);
                }
                tblReportFamiliesPerAnalyst.setup();
                tblReportFamiliesPerAnalyst.extra = function(){
                  makeCellUpdateable('tblReportFamiliesPerAnalyst', 5, 'isactive');
                  makeCellUpdateable('tblReportFamiliesPerAnalyst', 6, 'comment');
                  makeCellUpdateable('tblReportFamiliesPerAnalyst', 7, 'latestdue');
                  makeCellUpdateable('tblReportFamiliesPerAnalyst', 8, 'ispoly');
                  makeCellUpdateable('tblReportFamiliesPerAnalyst', 9, 'needsemulator');
                  makeCellUpdateable('tblReportFamiliesPerAnalyst', 10, 'needsdisassembler');
                  makeCellUpdateable('tblReportFamiliesPerAnalyst', 11, 'packersupport');
                }

              </script>
              <pre id='stats'></pre>
            </div>

            <!--
              ====================================
              END
              Advanced Report Families Per Analyst
              ====================================
            -->


            <!--
              ====================================
              Advanced Report Analysts Per Family
              BEGIN
              ====================================
            -->


            <div class='section-title'>Advanced Report Analysts Per Family</div>
            <div id='divReportAnalystsPerFamilySection' class='section'>
              <script type='text/javascript'>
                createFieldTable('', [
                	{ title: 'Family Name'
                  , name: 'samplesReportAnalystsPerFamilyFamilyName'
                  , type: 'text'
                  , size: '50'
                  , value: ""
                  , onkeyup: "familyIntellisense(this);"
                  , onfocus: "isOkToCloseIntellisense(this);"
                  , suffix: ' <input type="button" value="Get report" onclick="isOkToCloseIntellisense(this); getReportAnalystsPerFamily();" id="btnReportAnalystsPerFamily">'
                  }
                ]);

                function getReportAnalystsPerFamily(){
                  var family = E('_samplesReportAnalystsPerFamilyFamilyName').value;
                  cookie.set('_samplesReportAnalystsPerFamilyFamilyName', family);
                  if (!family){
                    window.alert('No family specified');
                  }
                  disableButtons();
                  addSpinner('divReportAnalystsPerFamilySection');
                  x_getReportAnalystsPerFamily(family, getTableData_cb);
                }

              </script>
              <table id='tblReportAnalystsPerFamily' class='camdpams-grid' cellspacing=1></table>
              <script language='javascript'>
                var tblReportAnalystsPerFamily = new CamdpamsGrid();
                tblReportAnalystsPerFamily.setup = function() {
                	this.init('tblReportAnalystsPerFamily');
                	this.headerSet(['Id', 'Analyst', 'Assigned', 'UnAssigned', 'IsActive', 'Comment']);
                }
                tblReportAnalystsPerFamily.setup();
                tblReportAnalystsPerFamily.extra = function(){
                  makeCellUpdateable('tblReportAnalystsPerFamily', 5, 'comment');
                  makeCellUpdateable('tblReportAnalystsPerFamily', 4, 'isactive');
                }
              </script>
              <pre id='stats'></pre>

            </div>

            <!--
              ====================================
              END
              Advanced Report Analysts Per Family
              ====================================
            -->
            
            
            <!--
              =============================
              Advanced Family Search Report
              BEGIN
              =============================
            -->
            
            <div class='section-title'>Advanced Family Search Report</div>
            <div id='divReportFamilySearchSection' class='section'>
              <script type='text/javascript'>
                createFieldTable('', [
                	{ title: 'Pattern'
                  , name: 'samplesReportFamilySearchPattern'
                  , type: 'text'
                  , size: '50'
                  , value: ""
                  , onfocus: "isOkToCloseIntellisense(this);"
                  , suffix: ' <input type="button" value="Search" onclick="isOkToCloseIntellisense(this); getReportFamilySearch();" id="btnReportFamilySearch">'
                  }
                ]);

                function getReportFamilySearch(){
                  var pattern = E('_samplesReportFamilySearchPattern').value;
                  cookie.set('_samplesReportFamilySearchPattern', pattern);
                  if (!pattern){
                    window.alert('No pattern specified');
                  }
                  disableButtons();
                  addSpinner('divReportFamilySearchSection');
                  x_getReportFamilySearch(pattern, getTableData_cb);
                }

              </script>
              <table id='tblReportFamilySearch' class='camdpams-grid' cellspacing=1></table>
              <script language='javascript'>
                var tblReportFamilySearch = new CamdpamsGrid();
                tblReportFamilySearch.setup = function() {
                	this.init('tblReportFamilySearch');
                	this.headerSet(['Family']);
                }
                tblReportFamilySearch.setup();
                tblReportFamilySearch.extra = function(){
                  var table = document.getElementById('tblReportFamilySearch');
                  var numRows = table.rows.length;
                  for (i=1; i<numRows; i++){
                    var cell = table.rows[i].cells[0];
                    if (cell.childNodes[0]){
                      var data = cell.innerHTML;
                      data = "<a href='#'>" + data + "</a>";
                      cell.innerHTML = data;
                    }
                  }
                }

              </script>
              <pre id='stats'></pre>

            </div>
            
            <!--
              =============================
              END
              Advanced Family Search Report
              =============================
            -->
            
            
            <!--
              =============================
              Advanced Family Stats Report
              BEGIN
              =============================
            -->

            <div class='section-title'>Advanced Family Stats Report</div>
            <div id='divReportFamilyStatsSection' class='section'>
              <script type='text/javascript'>
                createFieldTable('', [
                	{ title: 'Family Name'
                  , name: 'samplesReportFamilyStatsFamilyName'
                  , type: 'text'
                  , size: '50'
                  , value: ""
                  , onkeyup: "familyIntellisense(this);"
                  , onfocus: "isOkToCloseIntellisense(this);"
                  , suffix: ' <input type="button" value="Get Report" onclick="isOkToCloseIntellisense(this); getReportFamilyStatsAndDetected();" id="btnReportFamilySearch">'
                  }
                ]);
                
                function getReportFamilyStatsAndDetected(){
                  getReportFamilyStats();
                }

                function getReportFamilyStats(){
                  var family = E('_samplesReportFamilyStatsFamilyName').value;
                  cookie.set('_samplesReportFamilyStatsFamilyName', family);
                  if (!family){
                    window.alert('No family specified');
                  }
                  disableButtons();
                  addSpinner('divReportFamilyStatsSection');
                  x_getReportFamilyStats(family, getReportFamilyStats_cb);
                }
                
                function getReportFamilyStats_cb(arrResult){
                  getTableData_cb( arrResult[0] );
                  // getReportFamilyDetected();
                }

              </script>
              <table id='tblReportFamilyStatsAnalysts' class='camdpams-grid' cellspacing=1></table>
              <br>
              <table id='tblReportFamilyStatsDetected' class='camdpams-grid' cellspacing=1></table>
              <script language='javascript'>
                var tblReportFamilyStatsAnalysts = new CamdpamsGrid();
                tblReportFamilyStatsAnalysts.setup = function() {
                	this.init('tblReportFamilyStatsAnalysts');
                	this.headerSet(['ID', 'Analyst', 'Assigned', 'UnAssigned', 'IsActive', 'Comment']);
                }
                var tblReportFamilyStatsDetected = new CamdpamsGrid();
                tblReportFamilyStatsDetected.setup = function(){
                  this.init('tblReportFamilyStatsDetected');
                	this.headerSet(['TotalSamples', 'SamplesDetectedByFirstSigns', 'SamplesDetectedByPE-GenSigns', 'TotalPEGenSigns']);

                }
                tblReportFamilyStatsAnalysts.setup();
                tblReportFamilyStatsAnalysts.extra = function(){
                  makeCellUpdateable('tblReportFamilyStatsAnalysts', 5, 'comment');
                }
                tblReportFamilyStatsDetected.setup();

              </script>
              <pre id='stats'></pre>

            </div>

            <!--
              =============================
              END
              Advanced Family Stats Report
              =============================
            -->

          </td>
        </tr>
        <tr><td id='footer' colspan=2>&nbsp;</td></tr>
      </table>
    </form>
    <div id='divListFamilies'></div>
    <div id='divAddComment'></div>

    <script type='text/javascript'>
      enableButtons();
    </script>
  </body>
</html>