Reports Menu\n";
echo "
Activity Log, $rptHeader
\n";
$query = "select user_id, login,fname,lname from ZENTRACK_USERS where $where order by lname, fname;";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
/* LOOP FOR EACH PERSON: */
for ( $i1=0; $i1<$num_results; $i1++){
$row = mysql_fetch_array($result);
$user_id = $row["user_id"];
echo "".$row['fname'].' '.$row['lname']."
";
/* LOOP FOR EACH PERSON */
$query2 = "SELECT a.lid, a.ticket_id, a.user_id, a.bin_id, a.created, a.action, a.hours, a.entry, a.tDate, p.title as projname FROM ZENTRACK_LOGS a, ZENTRACK_TICKETS p WHERE a.ticket_id = p.id and a.user_id = $user_id and a.action <>'CREATED' and $filter ORDER BY $rptOrder ;";
$result2 = mysql_query($query2);
$num_result2 = mysql_num_rows($result2);
/* echo "Number of entries: ".$num_result2.""; */
if ( $rptFormat == 'table') {
echo "\n";
for ( $i2=0; $i2 < $num_result2; $i2++) {
$row2 = mysql_fetch_array($result2);
$i3 = $i2 + 1;
$logid=$row2['lid'];
echo "| $i3";
echo '. | '.$row2["tDate"]." | ".$row2["ticket_id"]." | ".$row2['projname'].' | '.$row2['hours']." | ".$row2['entry']." | ";
}
echo "
\n";
} else {
/** non-table version **/
for ( $i2=0; $i2 < $num_result2; $i2++) {
$row2 = mysql_fetch_array($result2);
$i3 = $i2 + 1;
$logid=$row2['lid'];
echo "$i3";
echo '. '.$row2["tDate"]." - ".$row2["ticket_id"]." - ".$row2['projname'].' - '.$row2['hours']." hrs. - ".$row2['entry']."
";
}
}
}
echo "";
require('menu.php')
?>