<?php

public function getReport0($from, $to)
  {
    $fromTime = str_replace(' ', '', $from);
    $fromTime = str_replace(':', '', $from);
    $toTime = str_replace(' ', '', $to);
    $fileName = "Report0_Results_From_" . $fromTime . "_To_" . $toTime;
    //return "fileName = $fileName";
    /*
    $query = "select mal.\"CsFamily\" as \"Family\""
           .      ", count( DISTINCT(sam.\"SampleId\") ) as \"TotalSamples\""
           .      ", count(case when sig.\"SigFormatId\" = 11 then true else null end) AS \"DetectedByFirstSigs\""
           .      ", count(case when sig.\"SigFormatId\" = 2 OR sig.\"SigFormatId\" = 7 then sig.\"SigId\" else null end) AS \"DetectedByPeSigs\""
           .      ", count(distinct res.\"SampleId\")-count(case when sig.\"SigFormatId\" = 2 OR sig.\"SigFormatId\" = 7 then sig.\"SigId\" else null end) AS \"NotDetectedByPeSigs\""
           .      ", count(distinct(case when sig.\"SigFormatId\" = 2 OR sig.\"SigFormatId\"  = 7 then sig.\"SigId\" else null end)) AS \"PeSigs\" "
           .   "from cs_vendors ven "
           .  "inner join cs_results res on res.\"CsVendorId\" = ven.\"CsVendorId\" "
           .  "inner join \"samples\" sam on sam.\"SampleId\" = res.\"SampleId\" "
           .  "inner join \"samples_sigs\" samsig on samsig.\"SampleId\" = res.\"SampleId\" "
           .  "inner join \"sigs\" sig on sig.\"SigId\" = samsig.\"SigId\" "
           .  "inner join cs_malware_names mal on mal.\"CsMalwareNameId\" = res.\"CsMalwareNameId\" "
           .  "where res.\"DateTimeScanned\" between '$from'::timestamp and '$to'::timestamp "
           .    "and ven.\"CsVendorId\" = 8 "
           .  "group by mal.\"CsFamily\"";
trigger_error("getReport0(): query = $query (" . gettype($query) . ")", E_USER_WARNING);
    $res = odbc_exec($this->db_conn, $query);
    /*
      ======================
      Writing XL spreadsheet
      BEGIN
      ======================
    */
    /*
    $xls = new ExcelExport();
    $xls->fileName = ""; //$fileName;
    // Writing heading
    $xls->addRow( array("Report0 Results"), null );
    $row = $xls->row;
    $row++;
    $xls->addRow( array("From:", $from), $row );
    $row = $xls->row;
    $row++;
    $xls->addRow( array("To:", $to), $row );
    $row = $xls->row;
    $row += 3;
    $xls->addRow( array("Family", "Total Samples", "Detected By First Sigs", "Detected By PE Sigs", "Not Detected By PE Sigs", "PE Sigs"), $row );
    // Writing data
    while( odbc_fetch_row($res) )
		{
      $familyName = odbc_result($res,"Family");
      $totalSamples = odbc_result($res,"TotalSamples");
      $detectedByFirstSigs = odbc_result($res,"DetectedByFirstSigs");
      $detectedByPeSigs = odbc_result($res,"DetectedByPeSigs");
      $notDetectedByPeSigs = odbc_result($res,"NotDetectedByPeSigs");
      $numPeSigs = odbc_result($res,"PeSigs");
      $xls->addRow( array($familyName, $totalSamples, $detectedByFirstSigs, $detectedByPeSigs, $notDetectedByPeSigs, $numPeSigs), null);
    }
    $xls->sendFile();
    /*
      ======================
      END
      Writing XL spreadsheet
      ======================
    */
    return "fileName = $fileName";
  }

?>