--- db2gantt.cgi 2002/09/13 11:17:20 1.4 +++ db2gantt.cgi 2002/09/13 11:59:08 1.5 @@ -145,7 +145,7 @@ return($html); } -my $sql = "select start,finish,specification,status +my $sql = "select start,finish,specification,status,user_group_host,type,sessionid from gantt where (start < '$from' and finish > '$from') or (start > '$from' and start < '$to') @@ -208,7 +208,12 @@ } print STDERR "[$less",$row->{status}," $curr_t:$len$more]" if ($debug); - print bar($len,$row->{status},$row->{start}." - ".$row->{finish}." ".$row->{status}); + + my $alt = $row->{start}." - ".$row->{finish}."
". + $row->{type}." ".$row->{status}."
". + $row->{user_group_host}." ".$row->{sessionid}.""; + $alt =~ s/:\d\d\.\d+//g; + print bar($len,$row->{status},$alt); $curr_t += $len;