My data in gantt chart is overlap to other data how to fix this? Thanks

72 views
Skip to first unread message

Albe Nopre

unread,
Aug 21, 2013, 2:56:12 AM8/21/13
to jpg...@googlegroups.com
<?php // content="text/plain; charset=utf-8"
// Gantt example
require_once ('jpgraph-3.5.0b1/src/jpgraph.php');
require_once ('jpgraph-3.5.0b1/src/jpgraph_gantt.php');
require ('class/class1.php');

$graph = new GanttGraph();

$graph->title->Set("Only month & year scale");

// Setup some "very" nonstandard colors
$graph->SetMarginColor('lightgreen@0.8');
$graph->SetBox(true,'yellow:0.6',2);
$graph->SetFrame(true,'darkgreen',4);
$graph->scale->divider->SetColor('yellow:0.6');
$graph->scale->dividerh->SetColor('yellow:0.6');

// Explicitely set the date range
// (Autoscaling will of course also work)
$graph->SetDateRange('2001-9-06','2002-4-10');

// Display month and year scale with the gridlines
$graph->ShowHeaders(GANTT_HMONTH | GANTT_HYEAR);
$graph->scale->month->grid->SetColor('gray');
$graph->scale->month->grid->Show(true);
$graph->scale->year->grid->SetColor('gray');
$graph->scale->year->grid->Show(true);


// Setup activity info

// For the titles we also add a minimum width of 100 pixels for the Task name column
$graph->scale->actinfo->SetColTitles(
    array('Name','Duration','Start','Finish'),array(100));
$graph->scale->actinfo->SetBackgroundColor('green:0.5@0.5');
$graph->scale->actinfo->SetFont(FF_ARIAL,FS_NORMAL,10);
$graph->scale->actinfo->vgrid->SetStyle('solid');
$graph->scale->actinfo->vgrid->SetColor('gray');

// Data for our example activities
$query = "SELECT * FROM `data4`";

if ($query_run =mysql_query($query)){


  while ($query_row = mysql_fetch_assoc($query_run)){

  $name = $query_row ['Name'];
  $duration = $query_row['Duration'];
  $start = $query_row ['Start'];
  $finish = $query_row ['Finish'];

$data = array(
    array(0,array($name,$duration,$start,$finish)
          , $start,$finish,FF_ARIAL,FS_NORMAL,8),
    
array(1,array($name,$duration,$start,$finish)
          , $start,$finish,FF_ARIAL,FS_NORMAL,8),
    );


// Create the bars and add them to the gantt chart


for($i=0; $i<count($data); ++$i) {
    $bar = new GanttBar($data[$i][0],$data[$i][1],$data[$i][2],$data[$i][3],"[50%]",10);

    if( count($data[$i])>4 )
        $bar->title->SetFont($data[$i][4],$data[$i][5],$data[$i][6]);

       
    $bar->SetPattern(BAND_RDIAG,"yellow");
    $bar->SetFillColor("gray");
    $bar->progress->Set(0.5);
    $bar->progress->SetPattern(GANTT_SOLID,"darkgreen");
    $graph->Add($bar);
}

}
}

// Output the chart
$graph->Stroke();

?>

Subramanian Annamalai

unread,
Oct 16, 2022, 3:41:57 PM10/16/22
to JpGraph
I am facing the same issue.  Did you find a solution?
Reply all
Reply to author
Forward
0 new messages