<?php
//include_once "camdpams.class.php";
error_reporting(E_ALL);
require_once('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);

//require_once('dbconn.inc.php');
function Diagramm($im,$val,$LEGEND,$total) {
    GLOBAL $COLORS;

    $white=ImageColorAllocate($im,255,255,255);
    $black=ImageColorAllocate($im,0,0,0);
    $font_file = 'font/TimesNewRomanBold.ttf';
    $W=ImageSX($im);                 
    $H=ImageSY($im);
// Header 
	imagettftext($im,25,0,50,80,$black,$font_file,"".$total);
// Plot legends #################################
	$legend_count=count($LEGEND);
	$max_length=0;
        foreach($LEGEND as $v) if ($max_length<strlen($v)) $max_length=strlen($v);
// Fonts parametr
        $FONT=5;
	$font_w=ImageFontWidth($FONT);
	$font_h=ImageFontHeight($FONT);
// Coordinats legends
	$l_width=($font_w*$max_length)+$font_h+10+5+10;	
	$l_height=$font_h*$legend_count+10+100;
	$l_x1=$l_width - 70;
	$l_y1=($H-$l_height);
	$text_x=$l_x1+10+5+30;
	$square_x=$l_x1+20;
	$y=$l_y1+10;
	$i=0;
	foreach($LEGEND as $v) {
		$dy=$y+($i*30);
		//ImageString($im, $FONT, $text_x, $dy, $v, $black);
		imagettftext($im,20,0,$text_x,$dy, $COLORS[$i],$font_file,$v);
		ImageFilledRectangle($im,$square_x+1,$dy+1,$square_x+$font_h-1,$dy-15, $COLORS[$i]);
                $i++;
		}

// Plot diagrams----------------------------
	$total=array_sum($val);
	$anglesum=$angle=Array(0);
	$i=1;
// calc diametr
	$diametr=$l_x1-10-10;
// X and Y
        $circle_x=($diametr/2)+40;
	$circle_y=$H/2-10;

//Correct diametr
	if ($diametr>($H*2)-10-10) $diametr=($H*2)-20-20-40;
// Shadow
	$x = $val[0]/2+10+ 200;
	$y=$H/2-10;
	$y3=$y+$val[1]/2+$val[2]/2-$val[5];
	$y4=$y-$val[1]/2-$val[3]/2+$val[6];
	imageellipse($im,$x,$y,$val[0],$val[0],$COLORS[0]);
	imagefill($im,$x,$y,$COLORS[0]);
//	imagettftext($im,50,0,$x-120,$y+10,$black,$font_file,"A");
	imageellipse($im,$x+$val[0]/2+$val[1]/2-abs($val[4]/2),$y,$val[1],$val[1],$COLORS[1]);
	imagefill($im,$x+$val[0]/2+$val[1]/2-abs($val[4]/4),$y,$COLORS[1]);
//	imagettftext($im,50,0,$x+$val[0]/2+$val[1]/2-abs(200/2)-20,$y+10,$black,$font_file,"B");	
	imageellipse($im,$x+$val[0]/2+$val[1]/2-abs($val[4]/2),$y3,$val[2],$val[2],$COLORS[2]);
	imagefill($im,$x+$val[0]/2+$val[1]/2-abs($val[4]/2),$y3+$val[2]/2-2,$COLORS[2]);
//	imagettftext($im,30,0,$x+$val[0]/2+$val[1]/2-abs($val[0]-$val[1]),$circle_y+190,$black,$font_file,"C");	
	imageellipse($im,$x+$val[0]/2+$val[1]/2-abs($val[4]/2),$y4,$val[3],$val[3],$COLORS[3]);
	imagefill($im,$x+$val[0]/2+$val[1]/2-abs($val[4]/2),$y4-$val[3]/2+2,$COLORS[3]);
//	imagettftext($im,30,0,$circle_x+210,$circle_y-150,$black,$font_file,"D");	

}
/*if (!isset($_GET['a'])|!isset($_GET['b']) | !isset($_GET['c']) | !isset($_GET['d']) | !isset($_GET['a_b']) | 
    !isset($_GET['b_c']) | !isset($_GET['b_d'])|!isset($_GET['start']) | !isset($_GET['stop']) ){
*/
if (!isset($_GET['start']) | !isset($_GET['stop']) ){

print "NODATA";

}
else{
$start = date("Y-m-d",strtotime($_GET['start']));
$stop = date("Y-m-d",strtotime($_GET['stop']));
$sql = "SELECT sum(\"DetectedByCav\")as \"DetectedByCav\", sum(\"DetectedByCs\")as \"DetectedByCs\", 
	      sum(\"VerdictCamasSuspicious\")as \"VerdictCamasSuspicious\", sum(\"VerdictCamasSuspicious+\")as \"VerdictCamasSuspicious_p\", 
	      sum(\"A_B\")as \"A_B\", sum(\"B_C\")as \"B_C\", sum(\"B_D\")as \"B_D\" FROM \"mis\".\"get_report_samples_sources\"('$start','$stop') AS
        		(\"SourceName\" varchar, \"SubmittedTotal\" integer, \"SubmittedUniqueNew\" integer,\"DetectedByCav\" integer, \"DetectedByCs\" integer,
        		\"VerdictCamasSuspicious\" integer, \"VerdictCamasSuspicious+\" integer,\"A_B\" integer,\"B_C\" integer,\"B_D\" integer)";
$res = odbc_exec($db_conn, $sql);
$k;
switch(odbc_result($res,"DetectedByCav")){
case odbc_result($res,"DetectedByCav")<10000:$k=20;break;
case odbc_result($res,"DetectedByCav")<45000:$k=100;break;
case odbc_result($res,"DetectedByCav")<100000:$k=200;break;
case odbc_result($res,"DetectedByCav")<300000:$k=500;break;
case odbc_result($res,"DetectedByCav")<500000:$k=1500;break;
case odbc_result($res,"DetectedByCav")<1000000:$k=4000;break;
default:$k=4000;break;
}
//if(odbc_result($res,"DetectedByCav")/200<300){$k=100;}
//else{$k=200;}
$d1=odbc_result($res,"DetectedByCav")/$k;
$d2 = odbc_result($res,"DetectedByCs")/$k;
$d3=odbc_result($res,"VerdictCamasSuspicious")/$k;
$d4=odbc_result($res,"VerdictCamasSuspicious_p")/$k;
$a_b = odbc_result($res,"A_B")/$k;
$b_c = odbc_result($res,"B_C")/$k;
$b_d = odbc_result($res,"B_D")/$k;

$val=Array($d1,$d2,$d3,$d4,$a_b,$b_c,$b_d);
$LEGEND=Array("Detected BY CAV","Detected By Cs","Detecded Camas Suspicious","Detecded Camas Suspicious+");
$total_sub = "Sources Based Distribution between $start and $stop";

header("Content-Type: image/png");
$W=500*2;
$H=500*2;

$im=ImageCreate($W,$H);
$imd=imagecreatetruecolor($W/2,$H/2);

$bgcolor=ImageColorAllocate($im,255,255,210);

$COLORS[0] = imagecolorallocate($im, 255, 0, 0);
$COLORS[1] = imagecolorallocate($im, 0, 255, 0);
$COLORS[3] = imagecolorallocate($im, 0, 100, 0);
$COLORS[2] = imagecolorallocate($im, 187, 34, 34);

// Вызов функции рисования диаграммы
Diagramm($im,$val,$LEGEND,$total_sub);
imagecopyresampled($imd,$im,0,0,0,0,$W/2,$H/2,$W,$H);
imagedestroy($im);

imagepng($imd);
imagedestroy($imd);
}
?>