<?php
/* $Id: per_category.php,v 1.2 2006/01/27 22:53:50 rschilling Exp $ */

if (eregi(basename(__FILE__),$_SERVER['PHP_SELF'])) {
  print "Direct module access forbidden.";
  exit;
}

if (in_array("percat",$_POST['options'])) {
  if ($_GET['tech'] == "true") {
    $sql  = "SELECT cid,category ";
    $sql .= "FROM categories ";
    $sql .= "ORDER BY category";
    $c = $dbi->fetch_all($sql,"array");
    if (is_array($c)) {
      foreach ($c as $category) {
        $categories[$category['cid']] = $category['category'];
      }
    }
  } else {
    $categories = group_categories($gid);
  }
  unset($data);

  foreach ($categories as $key => $val) {
    $sql  = "SELECT COUNT(i.issueid) ";
    $sql .= "FROM issues i, issue_groups g ";
    $sql .= "WHERE i.issueid=g.issueid ";
    $sql .= $_GET['tech'] == "true" ? "AND g.assigned_to = '$userid' " : "AND g.gid='$gid' ";
    $sql .= "AND i.category='$key'";
    $sql .= $_POST['use_date'] == "on" ? "AND i.opened BETWEEN '$sdate' AND '$edate'" : "";
    $count = $dbi->fetch_one($sql);
    if ($count > 0) {
      $data[$val] = $count;
    }
  }

  if ($_POST['use_graphs'] == "on") {
    if ($_GET['tech'] == "true") {
      $title = username($userid);
    } else {
      $title = group_name($gid);
    }
    $title .= "\nWork Items Per Category";
    $title .= $_POST['use_date'] == "on" ? "\n".date("m/d/Y",$sdate)." - ".date("m/d/Y",$edate) : "";
    $image = hbar_graph($title,$data);

    if ($_SESSION['javascript']) {
      $options  = "width=660,height=500";
      $options .= ",menubar=no,toolbar=no,status=no,location=no";
      $javascript = "window.open('$image','Graph','$options'); return false;";
      $buffer = "<a href=\"#\" onClick=\"$javascript\">";
    } else {
      $buffer = "<a href=\"$image\" target=\"_blank\">";
    }

    $buffer .= "<img src=\"$image\" width=\"128\" height=\"128\" border=\"0\" alt=\"Work Items Per Category\"></a>";
    $smarty->assign('category_data',$buffer);
  } else {
    $smarty->assign('category_data',$data);
  }
}
?>