<?php // Gantt example include "../jpgraph.php"; include "../jpgraph_gantt.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-10-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 $data = array(array(0, array("Pre-study", "102 days", "23 Nov '01", "1 Mar '02"), "2001-11-23", "2002-03-1", FF_ARIAL, FS_NORMAL, 8), array(1, array("Prototype", "21 days", "26 Oct '01", "16 Nov '01"), "2001-10-26", "2001-11-16", FF_ARIAL, FS_NORMAL, 8), array(2, array("Report", "12 days", "1 Mar '02", "13 Mar '02"), "2002-03-01", "2002-03-13", FF_ARIAL, FS_NORMAL, 8));
} $data[] = array($d[$d2] - 1, date("Y-m-d", $end), "00:00", date("H:i", $end), $start); } if (!$d[$d1]) { $d[$d1] = $idx++; } $data[] = array($d[$d1] - 1, date("Y-m-d", $start), date("H:i", $start), $d2 <= $d1 ? date("H:i", $end) : "23:59", $start); $suma += $row['gone'] - $row['came']; } include "lib/jpgraph/jpgraph.php"; include "lib/jpgraph/jpgraph_gantt.php"; $imgfilename = 'auto'; $graph = new GanttGraph($main_width - 10, 0, $imgfilename, 1); $graph->SetMarginColor('#C4C4C4'); $graph->SetColor('white'); $graph->SetFrame(true, 'gray', 1); $graph->ShowHeaders(GANTT_HHOUR); $graph->scale->UseWeekendBackground(false); $graph->scale->hour->SetBackgroundColor('lightyellow:1.5'); $graph->scale->hour->SetSundayFontColor('black'); $graph->scale->day->SetBackgroundColor('lightyellow:1.5'); $graph->scale->day->SetSundayFontColor('black'); $graph->scale->hour->SetFont(FF_FONT1); $graph->scale->hour->SetIntervall(1); $graph->scale->hour->SetStyle(HOURSTYLE_H24); $graph->hgrid->SetRowFillColor('whitesmoke@0.9', 'darkblue@0.9'); $graph->setMargin(0, 0, 0, 20); $graph->scale->hour->SetFont(FF_FONT1); $graph->scale->day->SetFont(FF_FONT1, FS_BOLD); $graph->title->SetColor('white'); $graph->scale->UseWeekendBackground(false);
$q->addWhere('project_status != 7'); } $pjobj->setAllowedSQL($AppUI->user_id, $q, null, 'p'); $q->addGroup('p.project_id'); $q->addOrder('project_name, task_end_date DESC'); $projects = $q->loadList(); $q->clear(); // Don't push the width higher than about 1200 pixels, otherwise it may not display. $width = min(dPgetParam($_GET, 'width', 600), 1400); $start_date = dPgetParam($_GET, 'start_date', 0); $end_date = dPgetParam($_GET, 'end_date', 0); $showAllGantt = dPgetParam($_REQUEST, 'showAllGantt', '0'); //$showTaskGantt = dPgetParam($_GET, 'showTaskGantt', '0'); $graph = new GanttGraph($width); $graph->ShowHeaders(GANTT_HYEAR | GANTT_HMONTH | GANTT_HDAY | GANTT_HWEEK); $graph->SetFrame(false); $graph->SetBox(true, array(0, 0, 0), 2); $graph->scale->week->SetStyle(WEEKSTYLE_FIRSTDAY); $pLocale = setlocale(LC_TIME, 0); // get current locale for LC_TIME $res = @setlocale(LC_TIME, $AppUI->user_lang[0]); if ($res) { // Setting locale doesn't fail $graph->scale->SetDateLocale($AppUI->user_lang[0]); } setlocale(LC_TIME, $pLocale); if ($start_date && $end_date) { $graph->SetDateRange($start_date, $end_date); } $graph->scale->actinfo->SetFont(FF_CUSTOM, FS_NORMAL, 8); $graph->scale->actinfo->vgrid->SetColor('gray');
function grafica($fecha_max, $fecha_min, $datos) { $graph = new GanttGraph(); $graph->title->Set(""); // Rango de fechas a presentar $graph->SetDateRange($fecha_min, $fecha_max); // linea de espaciado vertical entre los elementos $graph->SetVMarginFactor(2); // configuracion de colores $graph->SetMarginColor('lightgreen@0.8'); // color del fondo $graph->SetBox(true, 'yellow:0.6', 2); // contorno del marco interior $graph->SetFrame(true, 'darkgreen', 4); // contorno del marco exterior $graph->scale->divider->SetColor('yellow:0.6'); // linea divisora de datos y grafico $graph->scale->dividerh->SetColor('red:0.6'); //liena que divide el tiempo con las barras de la grafica // Ponemos la medida de tiempo que queremos usar, por ejemplo años, meses, dias, hors o minutos //por ejemplo, si queremos solamente la division por meses y semanas en lugar de tener //GANTT_HWEEK | GANTT_HMONTH | GANTT_HYEAR | GANTT_HDAY //dejamos //GANTT_HWEEK | GANTT_HMONTH // para mas opciones de division de tiempo ver comentarios abajo $graph->ShowHeaders(GANTT_HWEEK | GANTT_HMONTH | GANTT_HYEAR | GANTT_HDAY); $graph->scale->month->grid->SetColor('gray'); //lineas verticales que dividen los meses $graph->scale->month->grid->Show(true); $graph->scale->year->grid->SetColor('gray'); // linea verticales que dividen los años $graph->scale->year->grid->Show(true); $graph->scale->actinfo->SetColTitles(array('Acción', 'Duracion', 'Inicio', 'Final', 'Porcentaje'), array(30, 100)); $graph->scale->actinfo->SetBackgroundColor('blue:0.5@0.5'); //color de fondo de los titulos de la tabla $graph->scale->actinfo->SetFont(FF_ARIAL, FS_NORMAL, 12); //tipografia // division vertical de los datos a la izquierda, posibles valores 'solid', 'dotted', 'dashed' $graph->scale->actinfo->vgrid->SetStyle('solid'); $graph->scale->actinfo->vgrid->SetColor('red'); // color de las divisiones puestas en el renglon anterior // Configuración de los iconos que queremos usar //para poner algun icono no definido podemos usarlo de la siguiente manera //$icon = new IconImage("imagen.png",0.7); //en el ejemplo estoy usando una omagen desde blogspot //el numero que es el segundo parametro de IconImage es el porcentaje de la imagen, en este caso esta al 20% $erricon = new IconImage("logo-copia.png", 0.2); $startconicon = new IconImage(GICON_FOLDEROPEN, 0.6); $endconicon = new IconImage(GICON_TEXTIMPORTANT, 0.5); //ahora ponemos los datos de la tabla e iniciamos los datos de las barras // $data = array( // //valores del arreglo: // //indice del arreglo, arreglo de datos para la informacion a la izquierda, fecha de inicio de la barra, fecha final de la barra, tipografia, estilo,tamaño tipografia,% de progreso en la barra // array(0,array("Pre-study","17 days","1 Nov '2011","1 Mar '2012") // , "2011-11-01","2012-01-1",FF_ARIAL,FS_NORMAL,8, 0.5),//el 0.5 indica el 50%, que ocuparemos en la linea 74, dando su posicion en el arreglo // array(1,array("Prototype","10 days","26 Oct '2011","16 Nov '2011"), // "2011-10-26","2011-11-01",FF_ARIAL,FS_NORMAL,8, 0.12), // array(2,array("Report","12 days","1 Mar '2012","13 Mar '2012"), // "2012-03-01","2012-03-13",FF_ARIAL,FS_NORMAL,8, 1) // ); $data = $datos; // Crea las barras y las añade a la grafica gantt for ($i = 0; $i < count($data); ++$i) { $bar = new GanttBar($data[$i][0], $data[$i][1], $data[$i][2], $data[$i][3], '', 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($data[$i][7]); // ocupamos el % de adelanto en la actividad $bar->progress->SetPattern(GANTT_SOLID, "darkgreen"); //$bar->title->SetCSIMTarget(array('#1'.$i,'#2'.$i,'#3'.$i,'#4'.$i,'#5'.$i),array('11'.$i,'22'.$i,'33'.$i)); $graph->Add($bar); //echo "<br>--> ".$data[$i][7]; } // Creamos la imagen y le damos nombre, la imagen se guarda donde estan estos archivos $graph->Stroke('imagenprueba.jpg'); }
// fake 1 record so the chart doesn't error $data[] = array(0, date("Y-m-d"), '00:00', '00:00', time()); } // remove any and all output buffers $ps->ob_clean(); $graph = new GanttGraph(0, 0, $imgfilename, CACHE_TIMEOUT); $showfooter = (bool) $styles->val('image.session.showfooter', 'image.common.footer.show'); $top = intval($styles->val('image.session.margin.top', 'image.common.margin.top', true)); $right = intval($styles->val('image.session.margin.right', 'image.common.margin.right', true)); $bottom = intval($styles->val('image.session.margin.bottom', 'image.common.margin.bottom', true)); $left = intval($styles->val('image.session.margin.left', 'image.common.margin.left', true)); $graph->setMargin($left, $right, $top, ($showfooter and $bottom < 14) ? 14 : $bottom); $graph->ShowHeaders(GANTT_HHOUR); //$graph->SetBackgroundGradient('gray','whitesmoke',GRAD_LEFT_REFLECTION,BGRAD_MARGIN); $graph->SetMarginColor($styles->val('image.session.frame.margin', '#C4C4C4', true)); $graph->SetFrame(true, $styles->val('image.session.frame.color', 'gray', true), $styles->val('image.session.frame.width', 1, true)); //if (!$noname) $graph->title->Set($plrname); //$graph->title->SetColor('blue'); //$graph->subtitle->Set(imgdef($s['frame']['title'], 'Player Sessions')); //$graph->subtitle->SetFont(constant(imgdef($s['@frame']['font'], 'FF_FONT0'))); // must override the weekend settings ... $graph->scale->UseWeekendBackground(false); $graph->scale->day->SetWeekendColor($styles->val('image.session.header.bgcolor', 'lightyellow:1.5', true)); $graph->scale->day->SetFontColor($styles->val('image.session.header.color', 'black', true)); $graph->scale->day->SetSundayFontColor($styles->val('image.session.header.color', 'black', true)); // match the weekend settings ... $graph->scale->hour->SetFontColor($styles->val('image.session.header.color', 'black', true)); $graph->scale->hour->SetBackgroundColor($styles->val('image.session.header.bgcolor', 'lightyellow:1.5', true)); $graph->scale->hour->SetFont(constant($styles->val('image.session.font', 'FF_FONT0', true))); $graph->scale->hour->SetIntervall($styles->val('image.session.interval', 2, true)); $graph->scale->hour->SetStyle(constant($styles->val('image.session.header.hourstyle', 'HOURSTYLE_H24', true)));
public function graficar($filename) { $graph = new GanttGraph(); $graph->SetShadow(); $graph->SetBox(); // Only show part of the Gantt $graph = new GanttGraph(1000); /* $graph->title->Set('Proceso '.$this->dataSource->getParameter('desc_proceso_macro')."\n". 'Seguimiento de Solicitud '.$this->dataSource->getParameter('numero')."\n". 'Unidad '.$this->dataSource->getParameter('desc_uo')); $graph->title->SetFont(FF_ARIAL,FS_BOLD,6); */ define('UTF-8', $locale_char_set); // 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) // Display month and year scale with the gridlines $graph->ShowHeaders(GANTT_HMONTH | GANTT_HYEAR | GANTT_HDAY); $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 a horizontal grid $graph->hgrid->Show(); $graph->hgrid->SetRowFillColor('darkblue@0.9'); // 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('Tipo', 'Estado', 'Responsable', 'Duracion', 'Inicio', 'Fin'), array(40, 100)); $graph->scale->actinfo->SetBackgroundColor('green:0.5@0.5'); $graph->scale->actinfo->SetFont(FF_ARIAL, FS_NORMAL, 10); $data = array(); $dataset = $this->dataSource->getDataset(); $tamanioDataset = count($dataset); $fechaInicio = 0; $fechaFin = 0; for ($i = 0; $i < $tamanioDataset; $i++) { if ($i == 0) { $fechaInicio = $dataset[$i]['fecha_reg']; } /* if($dataset[$i]['nombre_estado']=='En_Proceso'||$dataset[$i]['nombre_estado']=='Habilitado para pagar'||$dataset[$i]['nombre_estado']=='En Pago'){ $milestone = new MileStone($i,$dataset[$i]['nombre_estado'],$dataset[$i]['fecha_reg'],$dataset[$i]['fecha_reg']); $milestone->title->SetColor("black"); $milestone->title->SetFont(FF_FONT1,FS_BOLD); $graph->Add($milestone); continue; } */ $actividad = array(); array_push($actividad, $i); if ($i == $tamanioDataset - 1) { $fechaFin = $dataset[$i]['fecha_reg']; } else { $fechaFin = $dataset[$i + 1]['fecha_reg']; } $startLiteral = new DateTime($dataset[$i]['fecha_reg']); $endLiteral = new DateTime($fechaFin); $start = strtotime($dataset[$i]['fecha_reg']); $end = strtotime($fechaFin); $days_between = round(($end - $start) / 86400); $cabecera = array($dataset[$i]['proceso'], $dataset[$i]['estado'], $dataset[$i]['funcionario'] != '-' ? $dataset[$i]['func'] : $dataset[$i]['depto'], "{$days_between}" . ' dias', $startLiteral->format('d M Y'), $endLiteral->format('d M Y')); array_push($actividad, $cabecera); array_push($actividad, $dataset[$i]['fecha_reg']); array_push($actividad, $fechaFin); array_push($actividad, FF_ARIAL); array_push($actividad, FS_NORMAL); array_push($actividad, 8); array_push($data, $actividad); } // 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], "[100%]", 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(1); $bar->progress->SetPattern(GANTT_SOLID, "darkgreen"); $graph->Add($bar); } //$graph->SetDateRange($fechaInicio,$fechaFin); $archivo = dirname(__FILE__) . '/../../../reportes_generados/' . $filename; //$graph->StrokeCSIM(); //exit; $graph->Stroke($archivo); }
$glpi_id = $item['psu_name']; $glpi_ids[] = $glpi_id; //get the list of just the glpi_ids for the gannt view $count = CTSDatabaseAPI::count($glpi_id); $item['count'] = $count; //hold all of the items in an array $temp_items[] = $item; } //--------------------------------------------------------------- // Gantt view //--------------------------------------------------------------- include 'jpgraph/jpgraph.php'; include 'jpgraph/jpgraph_gantt.php'; //graph code found in loan_sched.html in /cts $graph = new GanttGraph(900); $graph->SetFrame(true, 'darkblue', 2); $graph->scale->day->SetLabelFormatString('%a %m/%e'); $graph->scale->day->SetStyle(DAYSTYLE_CUSTOM); $graph->scale->day->SetFont(FF_FONT1, FS_BOLD, 12); $graph->SetMargin(-1, -1, -1, -1); $graph->ShowHeaders(GANTT_HDAY); $graph->hgrid->Show(); //$graph->scale->day->SetFont(15); $graph->hgrid->SetRowFillColor('#B5BD88@0.5'); $graph->SetDateRange($start_date, $end_date); $equipment_reservations = CTSDatabaseAPI::equipment_by_date($dates); foreach ($glpi_ids as $id) { //iterate through the ids and check to see if they are in the equipment array if ($equipment_reservations[$id]) { //put the information in a new array $gantt_data[$id] = $equipment_reservations[$id]['reservations'];
$gdate2 = $_POST['gdate2']; } elseif (isset($_GET['gdate2']) and $_GET['gdate2'] != '') { $gdate2 = $_GET['gdate2']; } else { $gdate2 = strftime('%Y/%m/%d', strtotime('+2 weeks')); } } $count = 0; $adate1 = explode('/', $gdate1); $epocdate1 = mktime(0, 0, 0, $adate1['1'], $adate1['2'], $adate1['0']); $adate2 = explode('/', $gdate2); $epocdate2 = mktime(0, 0, 0, $adate2['1'], $adate2['2'], $adate2['0']); $graph = new GanttGraph($graphWidth); $graph->SetMarginColor('lightskyblue3@0.5'); $graph->SetBox(true, 'blue@0.8', 2); $graph->SetFrame(true, 'darkgreen', 4); $graph->scale->divider->SetColor('yellow:0.6'); $graph->scale->dividerh->SetColor('yellow:0.6'); $graph->scale->actinfo->SetColTitles(array('Projects'), array(100)); $graph->scale->actinfo->SetBackgroundColor('green:0.5@0.5'); $graph->scale->actinfo->SetFont(FF_VERA, FS_NORMAL, 10); $graph->scale->actinfo->vgrid->SetStyle('solid'); $graph->scale->actinfo->vgrid->SetColor('gray'); if ($epocdate2 - $epocdate1 > 12000000) { $graph->ShowHeaders(GANTT_HYEAR | GANTT_HMONTH); $graph->scale->month->grid->SetColor('gray'); $graph->scale->month->grid->Show(true); $graph->scale->year->grid->SetColor('gray'); $graph->scale->year->grid->Show(true); } elseif ($epocdate2 - $epocdate1 > 6000000) { $graph->ShowHeaders(GANTT_HYEAR | GANTT_HMONTH | GANTT_HWEEK);