graphs.php

Go to the documentation of this file.

<?php
# This file is part of the Savane project
# <http://gna.org/projects/savane/>
#
# $Id: graphs.php 4567 2005-06-30 17:19:37Z toddy $
#
#  Copyright 2004 (c) Mathieu Roy <yeupou--at--gnu.org>
#
# The Savane project is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License
# as published by the Free Software Foundation; either version 2
# of the License, or (at your option) any later version.
#
# The Savane project is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with the Savane project; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA

# Attempt to replace HTML_graphs.php with someone more spartian, efficient
# and w3c compliant.

# It can accept db result directy or an array.
# Total must be an array too, if provided
function graphs_build ($result, $field=0, $dbdirect=1,$total=0)
{
  if (!$result)
    {
      fb(_("No data to work on, no graph will be built"), 1);
      break;
    }

  if ($dbdirect)
    {
      $content = array();
      for ($i=0; $i < db_numrows($result) ; $i++)
        {
          $content[db_result($result, $i, 0)] = db_result($result, $i, 1);
        }
    }
  else
    {
      $content = $result;
    }

  # Get the total number of items
  # Total should not be passed as argument, normally
  if (!$total)
    {
      $totalvar = 0;
      while(list($k, $v)=each($content))
        {
          $totalvar += $v;
        }

      $total = array();
      reset($content);
      while(list($k, $v)=each($content))
        {
          $total[$k] = $totalvar;
        }
    }
  else
    {
      # If total was passed as argument, no crosscheck, assume it is accurate
      $totalvar = 1;
    }

  # Print the stats, unless $total is nul
  # If total was passed as argument, strange result may be printed.
  if ($totalvar)
    {
      print "\n\n<table width=\"100%\">\n";
      reset($content);
      while(list($k, $v)=each($content))
        {
          if ($total[$k] > 0)
            {
              $percent_width = round(($v / $total[$k]) * 100);
              $percent_print = sprintf(_("%s%%"), $percent_width);
            }
          else
            {
              $percent_width = 0;
              $percent_print = _("n/a");
              $total[$k] = 0;
            }

          if ($field && $field == "assigned_to")
            { $title = utils_user_link($k); }
          else
            { $title = $k; }


          if ($percent_width > 25)
            { unset($class); }
          else
            { $class="closed"; }

          print '<tr width="100%">'.
            '<td width="15%" align="right" valign="center">'.$title.'</td>'.
            '<td width="5%" align="right" valign="center">'.sprintf(_("%s/%s"), $v, $total[$k]).'</td>'.
            '<td width="5%" align="center" valign="center">'.$percent_print.'</td>'.
            '<td width="75%" class="prioraclosed" align="left"><table class="priori'.$class.'" width="'.$percent_width.'%" cellpadding="0" cellspacing="0"><tr><td>&nbsp;</td></tr></table></td>'.
            '</tr>';
        }
      print "\n</table>\n\n";
    }
  else
    {
      print '<p class="warn">';
      print _("The total of results is zero.");
      print '</p>';
    }
}

?>

---