Execute($sql); if ($rs && !$rs->EOF) { $regions = $rs->GetArray(); } else { die('DB error'); } $region = 1; $region_id = $regions[$region]['id']; $sql = <<Execute($sql); if ($rs && !$rs->EOF) { $regionData = $rs->GetArray(); } else { die('DB error'); } $lastRegion = ''; $rIndex = -1; $graphData['label'] = array(); for ($i=0,$j=count($regionData); $i<$j; $i++) { if ($lastRegion != $regionData[$i]['region_id']) { $lastRegion = $regionData[$i]['region_id']; $rIndex++; $graphData['r'.$rIndex]['label'] = array(); $graphData['r'.$rIndex]['rev'] = array(); $graphData['r'.$rIndex]['revFmt'] = array(); } if (!$rIndex) { //first region only $graphData['label'][] = $regionData[$i]['short_desc']; } $graphData['r'.$rIndex]['label'][] = $regionData[$i]['short_desc']."\n$".number_format($regionData[$i]['rev']); $graphData['r'.$rIndex]['rev'][] = $regionData[$i]['rev']; $graphData['r'.$rIndex]['revFmt'][] = '$'.number_format($regionData[$i]['rev']); $graphData['r'.$rIndex]['targets'][] = DRILL_GRAPH.$regionData[$i]['region_id']; $graphData['r'.$rIndex]['alts'][] = "Click for more information regarding {$regions[$rIndex]['region']} sales."; $graphData['r'.$rIndex]['map_x'] = $regionData[$i]['map_x']; $graphData['r'.$rIndex]['map_y'] = $regionData[$i]['map_y']; } $sliceColors = array('lightgreen', 'pink', 'lightblue'); $graphName = IMG_DIR.'abc_channel_graph.png'; $graph = new PieGraph(WIDTH, HEIGHT); $graph->SetBackgroundImage('img/abc-regions.png', BGIMG_FILLFRAME); for ($i=0; $i<$rIndex+1; $i++) { $pickRegion = 'r'.$i; $p1 = new PiePlot($graphData[$pickRegion]['rev']); $p1->SetCenter($graphData[$pickRegion]['map_x'], $graphData[$pickRegion]['map_y']); $p1->SetSize(PIE_SIZE); $p1->SetLabels($graphData[$pickRegion]['revFmt']); $p1->SetSliceColors($sliceColors); $p1->SetCSIMTargets($graphData[$pickRegion]['targets'], $graphData[$pickRegion]['alts']); if (!$i) { $p1->SetLegends($graphData['label']); } $graph->Add($p1); } $graph->legend->Pos(0.9, 0.85, 'center', 'center'); $graph->Stroke($graphName); $mapName = 'ABC_Region_Drill'; $imgMap = $graph->GetHTMLImageMap($mapName); print << EOS; ?>