session_start();
/* taskReport-expt1.php - 05/15/2003 - Report of tasks, by person */
/*
$filter = $_GET['filter'];
$rptOrder = $_GET['rptOrder'];
echo "Running report -- settings:
\n";
echo "Filter = $filter
\n";
echo "Order = $rptOrder
\n";
*/
?>
Tasks
// $rptFormat = 'table';
include_once('setup.php');
include_once("../lib/proclib.php");
$debug = 0;
$compid = 1;
$sDate = '2003-01-01';
/** show only own log unless administrator or proj manager **/
// $where = checkUserRights($valid_accessLevel);
// if (! $where ) { return;}
/* $rptOrder = 'p.title, a.priority, a.title'; */
/* $filter = '1=1'; */
echo "Reports Menu\n";
echo "
Tasks, $rptHeader
\n";
// echo "Format: $rptFormat
";
if (strlen($where)<1) $where = 1;
$query = "SELECT a.id, a.title, a.priority, a.description, a.start_date, a.deadline,
a.project_id, a.user_id, a.bin_id, a.est_hours, p.title as projname, o.fname, o.lname,
u.fname, u.lname, u.baseRate, u.loadedRate
FROM ZENTRACK_TICKETS a, ZENTRACK_TICKETS p, ZENTRACK_USERS u, ZENTRACK_USERS o
WHERE a.project_id = p.id and a.user_id = u.user_id and a.creator_id = o.user_id and
( $filter ) and a.status <> 'CLOSED' and $where
ORDER BY $rptOrder ;";
debug($query);
$results = mysql_query($query);
$num_results = mysql_num_rows($results);
if ( $num_results == 0) {
echo "No records found. Try again.\n";
return 0;
}
/* echo "Number of entries: ".$num_results."
"; */
$rowcolor1 = 'BGCOLOR=#EEE9BF';
$rowcolor1 = 'BGCOLOR=#CCCCCC';
/* light blue: */
$rowcolor1 = 'BGCOLOR=#CCFFFF';
$fontcolor = '#0066CC';
$fontcolor = '#006699';
/* heading color */
$hdcolor = 'BGCOLOR=#CCFFCC';
/* group heading background */
$grpcolor = '#FF0000';
$grpcolor = '#FFFF00';
$xbreakval = 'xxxx';
if ( $rptFormat != 'TSK1') {
echo "\n";
echo "ID | Name | Date | ";
// echo "Task | Description | Priority | ";
echo "Task | Description | ";
// echo "Est. Hours | \n";
if ( $valid_accessLevel == 5 and 1 == 2) {
echo "Base Rate | Loaded Rate |
Base cost |
\n";
}
}
for ( $i=0; $i < $num_results; $i++) {
$row = mysql_fetch_array($results);
$projname = $row['projname'];
$user = $row['fname'].' '.$row['lname'];
$task_sdate = date('m/j/Y',$row['start_date']);
$description = ereg_replace( "\n", '
',$row['description']);
/** display project name if changes **/
/* echo "$rptOrder |
\n"; */
if ($rptOrder1 == 'project' ) {
/* echo "grp ptitle |
\n"; */
if ( $projname <> $xbreakval ) {
if ( $rptFormat != 'TSK1') {
echo "".$projname." |
\n";
} else {
echo "".$projname."
\n";
}
$xbreakval = $projname;
}
}
if ($rptOrder1 == 'user' ) {
if ( $user <> $xbreakval ) {
if ( $rptFormat != 'TSK1') {
echo "".$user." |
\n";
} else {
echo "".$user."
\n";
}
$xbreakval = $user;
}
}
$i3 = $i + 1;
$rowcolor ='';
if ($i % 2 == 1 ) { $rowcolor = $rowcolor1;}
$id = $row['id'];
$fname = $row['fname'];
$lname = $row['lname'];
$baseCost= $row['baseRate'] * $row['hours'];
$p = $row['priority'];
$pa = array('NA','High','Med-Hi','Med.','Med-lo','Low');
$p2 = $pa[$p];
if ( $rptFormat != 'TSK1') {
echo "";
echo "$i3.";
echo " ($id) | ";
echo "$fname $lname | ";
echo "".$task_sdate." (pr: $p2) | ";
echo "".$row["title"];
if ( $rptOrder1 != 'project'){
echo " (".$projname.")";
}
echo " | ";
echo "".$description." | ";
// echo "".$row['est_hours']." | ";
/** mgrs can see costs: DISABLED **/
if ( $valid_accessLevel == 5 and 1 == 2) {
echo "".$row['baseRate']." | ".$row['loadedRate']." | ".$baseCost." | ";
}
echo "
\n";
} else {
echo "$i3. ";
echo "($id)";
echo " ".$row["title"]."";
echo " - $fname $lname - ";
echo "Start: ".$task_sdate." - (priority: $p2)";
if ( $rptOrder1 != 'project'){
echo "
(".$projname.")";
}
echo "".$description."
";
// echo "".$row['est_hours']."";
/** mgrs can see costs: DISABLED **/
if ( $valid_accessLevel == 5 and 1 == 2) {
// echo $row['baseRate']."".$row['loadedRate']." | ".$baseCost." | ";
}
}
}
if ( $rptFormat != 'TSK1') {
echo "
\n";
}
echo "";
require('menu.php');
require('footer.php');
?>