<?php
require "config.php";
$dsn  = 'Driver='    . DB_DRIVER;
$dsn .= ';Server='   . DB_HOST;
$dsn .= ';Port='     . DB_PORT;
$dsn .= ';Database=' . DB_DATABASE;
$db_conn = odbc_connect("$dsn",$_SERVER['PHP_AUTH_USER'],$_SERVER['PHP_AUTH_PW'],SQL_CUR_USE_ODBC);
     $report = '';                                                                                                                                                    
     $i=0;                                                                                                                                                            
     $rest;          
$from='yesterday';                                                                                                                                                      
$to='today';
//     if($src=='All'){                                                                                                                                                 
	 $query = "select * from mis.rpdtc_class_enhanced_new('$from','$to') as (\"Alone\" bigint,\"Suspicious\" bigint, \"Suspicious+\" bigint,                      
                   \"Suspicious++\" bigint, \"cnt\" bigint)";                                                                                                 
/*      }                                                                                                                                                                
     else{                                                                                                                                                            
	 $query = "select * from mis.rpdtc_class_camas_enhanced_new('$from','$to') as (\"Alone\" bigint,\"Suspicious\" bigint, \"Suspicious+\" bigint,                
                     \"Suspicious++\" bigint, \"cnt\" bigint)";                                                                                                 
     }                                                                                                                                                                
*/
print $query;
$res = odbc_exec($db_conn,$query);                                                                                                                         
    while(odbc_fetch_row($res)){ 
          $row_total = 0;                                                                                                                                          
          switch($i){                                                                                                                                              
            case 0:                                                                                                                                                
               $report .= "Malware Count";                                                                                                                           
		 $report .= "|";                                                                                                                                       
            break;                                                                                                                                                 
            case 1:                                                                                                                                                
             $report .= "Safe Count";                                                                                                                              
             $report .= "|";                                                                                                                                       
             break;                                                                                                                                                 
            case 2:                                                                                                                                                
               $report .= "Conflict Count";                                                                                                                          
              $report .= "|";                                                                                                                                       
            break;                                                                                                                                                 
            case 3:                                                                                                                                                
                 $report .= "Unknown Count";                                                                                                                           
                $report .= "|";                                                                                                                                       
             break; 
             }
              $cnt = odbc_result($res,"cnt");  
		 if($cnt > 0 ){
                                                                                                                                                                                                                                                                                                                                                                            
		$rest = abs(odbc_result($res,"cnt")- odbc_result($res,"Alone")-odbc_result($res,"Suspicious")-odbc_result($res,"Suspicious+")-odbc_result($res,"Suspicious++"));}
		 $report .= odbc_result($res,"Alone");
		$report .= "|";
		$report .= odbc_result($res,"Suspicious");
		$report .= "|";
		$report .= odbc_result($res,"Suspicious+");
		$report .= "|";
		$report .= odbc_result($res,"Suspicious++");
		$report .= "|";
		$report .= $rest;
		$report .= "\n";
		$i++;
	     }
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
print "<pre>".$report."</pre>";


?>