include 'constants.php'; include '../../phplib/sqlfunc.php'; include '../../phplib/calendarfunc.php'; $string = implode($_SERVER['argv']," "); $tok = strtok($string, "="); $ID = strtok("&"); $ID = trim($ID); parse_str($string); $connection = mysql_connect($host, $user, $password); echo ''; echo '
User | Date | Hours | Description | Type | '; echo '
'; echo ' | '; $today = getdate(); $month = $today['mon']; $mday = $today['mday']; $year = $today['year']; echo ''; echo ' | '; echo ' | '; echo ' | '; $query = 'SELECT * FROM types'; $result = mysql_db_query($database, $query, $connection); error($query); echo ' | '; echo '
'; echo ''; echo ' |
User | '; while ($r1 = mysql_fetch_array($result1)) { $types[$i++] = $r1["id"]; echo '' .$r1["description"] .' | '; } echo 'Total(h) |
' .$name .' | '; 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 '' .$hours .' | '; } } $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 '' .$hours .' |
Total | '; for ($n=0; $n<=$j; $n++) { echo '' .$total[$n] .' | '; } echo '
User | Day | Date | Hour(s) | Type | Description | '; echo '
' .$r["firstname"] .' | ' .$r["date"] .' | ' .dayOfWeek($r["date"]) .' | ' .$r["hours"] .' | ' .$r[4] .' | ' .$r[3] .' |