Don\'t reload this page!!!

Report time

'; echo ''; echo ''; echo ''; echo ''; $today = getdate(); $month = $today['mon']; $mday = $today['mday']; $year = $today['year']; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '

User	Date	Hours	Description	Type
'; echo ' '; $query = 'SELECT id, user FROM users'; $result = mysql_db_query($database, $query, $connection); error($query); echo ''; if ($result) { while ($r = mysql_fetch_array($result)) { $id = $r["id"]; $user = $r["user"]; if ($id == $userid) { echo '' .$user .''; }else { echo '' .$user .''; } } } echo '				'; $query = 'SELECT * FROM types'; $result = mysql_db_query($database, $query, $connection); error($query); echo ''; if ($result) { while ($r = mysql_fetch_array($result)) { $id = $r["id"]; $name = $r["description"]; echo '' .$name .''; } } echo '

Statistics

'; $query = 'SELECT * FROM types'; $result1 = mysql_db_query($database, $query, $connection); error($query); if ($result1) { $i = 0; echo ''; while ($r1 = mysql_fetch_array($result1)) { $types[$i++] = $r1["id"]; echo ''; } echo ''; } $query = 'SELECT id, firstname FROM users WHERE ID>0'; $result = mysql_db_query($database, $query, $connection); error($query); if ($result) { while ($r = mysql_fetch_array($result)) { $id = $r["id"]; $name = $r["firstname"]; echo ''; for($j=0; $j<$i; $j++) { $query = 'SELECT SUM(hours) FROM timereport WHERE (user="' .$id .'" OR user="0") AND type="' .$types[$j] .'"'; $result1 = mysql_db_query($database, $query, $connection); error($query); if ($result1) { $r1 = mysql_fetch_array($result1); $hours = $r1["SUM(hours)"]; $total[$j] += $hours; echo ''; } } $query = 'SELECT SUM(hours) FROM timereport WHERE user="' .$id .'" OR user="0"'; $result1 = mysql_db_query($database, $query, $connection); error($query); if ($result1) { $r1 = mysql_fetch_array($result1); $hours = $r1["SUM(hours)"]; $total[$j] += $hours; echo ''; } } echo ''; for ($n=0; $n<=$j; $n++) { echo ''; } echo ''; } echo '

User	' .$r1["description"] .'	Total(h)
' .$name .'	' .$hours .'	' .$hours .'
Total	' .$total[$n] .'

Last 30 reported

'; echo ''; echo ''; echo ''; while ($r = mysql_fetch_array($result)) { echo ''; } echo '

User	Day	Date	Hour(s)	Type	Description
' .$r["firstname"] .'	' .$r["date"] .'	' .dayOfWeek($r["date"]) .'	' .$r["hours"] .'	' .$r[4] .'	' .$r[3] .'