<?php
$label=Array();
$area=Array();
$finalarea=Array();
$totalarea=Array();
$fldunion=Array();
$uniqarray=Array();
$uniqarraynew=Array();
$jsonarraytaluk = Array();
$jsonarray = Array();
$totarea="";
$state= 'andhra';
$layername= 'apflood50dsc04122015';
$str1= "with_aoi";

$layerurl ="ndem50d:apflood50dsc04122015";
//172.31.4.61 port=5432 dbname=baselayers user=postgres password=ndem$123
$db = pg_connect("host=172.31.4.61 port=5432 dbname=baselayers user=postgres password=ndem$123")or die ("cant disaster_event");
$tbl="select interfacelayername FROM master_layertable where state='andhra' and layerurl='ndem50d:apflood50dsc04122015'";

$restbl=pg_query($db,$tbl);
if($restbl1=pg_fetch_array($restbl))
{
$interfacename=$restbl1['interfacelayername'];
}
//echo $interfacename;
$db45 = pg_connect("host=172.31.4.61  port=5432 dbname=geoserver user=postgres password=ndem$123")or die ("cant geoserver");
$fld="select geom FROM s50d.apflood50dsc04122015";
$resultm=pg_query($db45,$fld);
$mk=0;
while($resm=pg_fetch_array($resultm)){
$fldgeom=$resm['geom'];

//echo $fldgeom;
//if($str1="without_aoi"){// added on 30oct14..neha...
//$fldtry="select ST_collect(ST_Intersection(st_GeomFromText('".$str1."','4326'), '".$fldgeom."'))" ;
//echo $fldtry;
//$resultry=pg_query($db45,$fldtry);
//$restry=pg_fetch_array($resultry);
//$fldgeom=$restry[0];
//}
$intersect="select ST_collect(ST_Intersection('".$fldgeom."', geom)) FROM s50k.aptaluk50soi2001 where St_intersects('".$fldgeom."',geom)" ;
//echo $intersect;
$result1=pg_query($db45,$intersect);
$res1=pg_fetch_array($result1);
$geom=$res1[0];
//echo $geom;

$lulc_code="select distinct taluk FROM s50k.aptaluk50soi2001 WHERE ST_Intersects(geom,'".$geom."')";
$result=pg_query($db45,$lulc_code);
while($row=pg_fetch_array($result))
{
$descrip="SELECT DISTINCT geom,taluk from s50k.aptaluk50soi2001 where taluk='".$row[0]."'";
$output1=pg_query($db45,$descrip);
$value1=pg_fetch_array($output1);
$label[$mk]=$value1[1];
$sarea="SELECT distinct ST_Area(ST_Intersection('".$value1[0]."', '".$fldgeom."')) FROM s50k.aptaluk50soi2001 where taluk='".$row[0]."'";
$output2=pg_query($db45,$sarea);
//echo $output2;
$value2=pg_fetch_array($output2);
$out=$value2[0];
//echo $out;
$out1=round((($out*111.00*111.00)),2);
$area[$mk]=$out1;
$mk++;
}
}
$length=count($area);
$uniqarray=array_values(array_unique($label));
$p=0;
for($p;$p<=count($uniqarray);$p=$p+1){
for($n=0;$n<$length;$n++){
if((!strcmp($uniqarray[$p],$label[$n]))){
$finalarea[$p]=$finalarea[$p]+$area[$n];
}
}
}
$totalarea[0]="<b>Taluk</b>".",".'<b>'.$layerurl.'<br>InundatedArea(Sqkm)</b>';
$kl=0;
for($l=1;$l<count($uniqarray)+1;$l++){
$row_data['id'] = $uniqarray[$kl];
   //layana_json_scalewise.push([arr[i],outarea[i]]);
//array_push($jsonarraytaluk,$uniqarray[$kl]);
// echo array_push($jsonarraytaluk,$uniqarray[$kl]);
//$row_data[] = $finalarea[$kl];
array_push($jsonarray,$uniqarray[$kl],$finalarea[$kl]);
 $totalarea[$l]=$uniqarray[$kl].",".$finalarea[$kl];
 $kl++;
}
if($kl==0){
echo "No Data";
}
else{
$jsonencodedata = json_encode($jsonarray);
//$jsonencodedata= str_replace(']','',(str_replace('[','',(str_replace('"','',(json_encode($jsonarray)))))));
}
echo $jsonencodedata;
pg_close($db);
?>

<script src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.5/d3.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/c3/0.4.10/c3.min.js"></script>

<link href="https://cdnjs.cloudflare.com/ajax/libs/c3/0.4.10/c3.min.css" rel="stylesheet" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>

<div id="chart"></div>


<script>

//dataFromJSON =[["ADDANKI",11.98],["CHIRALA",23.06],["ONGOLE",185.64],["KOVVUR",133.16],["KANDUKUR",127.02],["KAVALI",116.46],["KANIGIRI",0.54],["UDAYAGIRI",4.04],["NELLORE",226.52],["ATMAKUR",0],["RAPUR",11.04],["SIDHOUT",1.16],["GUDUR",176.48],["SRI KALAHASTI",194.9],["RAJAMPET",19.86],["VENKATAGIRI",45.28],["PUTTUR",15.3],["SULURPET",0.84],["ATYAVEDU",48.1],["CHANDRAGIRI",8.9]];
dataFromJSON=["ADDANKI",11.98,"CHIRALA",23.06,"ONGOLE",185.64,"KOVVUR",133.16,"KANDUKUR",127.02,"KAVALI",116.46,"KANIGIRI",0.54,"UDAYAGIRI",4.04,"NELLORE",226.52,"ATMAKUR",0,"RAPUR",11.04,"SIDHOUT",1.16,"GUDUR",176.48,"SRI KALAHASTI",194.9,"RAJAMPET",19.86,"VENKATAGIRI",45.28,"PUTTUR",15.3,"SULURPET",0.84,"SATYAVEDU",48.1,"CHANDRAGIRI",8.9];
var chart = c3.generate({
    data: {
        columns: dataFromJSON
    }
});

setTimeout(function () {
    chart.transform('pie');
}, 1000);

/*
setTimeout(function () {
    chart.transform('line');
}, 2000);
*/
setTimeout(function () {
    chart.transform('pie');
}, 3000);

</script>