$name $range $Request List END; if ($s != ""){ print << END; $query = "SELECT count(*) from request"; if ($n != "") { $query .= " where AssignTo='$username'"; } if ($s != "") { $query .= " where $computer"; } $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); if (mysql_num_rows($result) == 1) { $row = mysql_fetch_row($result); print "Total: $row[0]"; $nt = $row[0]; } $query = "SELECT count(*), AVG(TO_DAYS(UpdateTime) - TO_DAYS(ReportTime)) from request WHERE Status = '8'"; if ($n != "") { $query .= " and AssignTo='$username'"; } if ($s != "") { $query .= " and $computer"; } $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); if (mysql_num_rows($result) == 1) { $row = mysql_fetch_row($result); $d = (int)$row[1]; print "Closed: $row[0]Average open $d days"; $nc = $row[0]; } $query = "SELECT count(*), AVG(TO_DAYS(NOW()) - TO_DAYS(ReportTime)) from request WHERE Status <> '8'"; if ($n != "") { $query .= " and AssignTo='$username'"; } if ($s != "") { $query .= " and $computer"; } $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); if (mysql_num_rows($result) == 1) { $row = mysql_fetch_row($result); $d = (int)$row[1]; print "Open: $row[0]Average open $d days"; $no = $row[0]; } $order_LU="1"; $order_RT="1"; $order_P="1"; $img_LU=""; $img_RT=""; $img_P=""; $range = $_GET["range"]; if ($range == 'Open') { $num = $no; $query = "SELECT SerialNo, Status, UpdateTime, ReportTime, TO_DAYS(NOW()) - TO_DAYS(ReportTime), LEFT(Description, 80), UNIX_TIMESTAMP(UpdateTime), Priority, AssignTo, Type, StationNo from request WHERE Status <> '8'"; if ($n != "") { $query .= " and AssignTo='$username'"; } if ($s != "") { $query .= " and $computer"; } } else if ($range == 'Closed') { $num = $nc; $query = "SELECT SerialNo, Status, UpdateTime, ReportTime, TO_DAYS(NOW()) - TO_DAYS(ReportTime), LEFT(Description, 80), UNIX_TIMESTAMP(UpdateTime), Priority, AssignTo, Type, StationNo from request WHERE Status = '8'"; if ($n != "") { $query .= " and AssignTo='$username'"; } if ($s != "") { $query .= " and $computer"; } } else if ($range == 'Total') { $num = $nt; $query = "SELECT SerialNo, Status, UpdateTime, ReportTime, TO_DAYS(NOW()) - TO_DAYS(ReportTime), LEFT(Description, 80), UNIX_TIMESTAMP(UpdateTime), Priority, AssignTo, Type, StationNo from request"; if ($n != "") { $query .= " where AssignTo='$username'"; } if ($s != "") { $query .= " where $computer"; } }; if ($t == "l") { $query = $query." order by Updatetime"; if ($o == "1") { $order_LU = "2"; $img_LU=" "; $query = $query." DESC"; } else { $img_LU=" "; $query = $query." ASC"; } } else if ($t == "r") { $query = $query." order by ReportTime"; if ($o == "1") { $order_RT = "2"; $img_RT=" "; $query = $query." DESC"; } else { $img_RT=" "; $query = $query." ASC"; } } else if ($t == "p") { $query = $query." order by Priority"; if ($o == "1") { $order_P = "2"; $img_P=" "; $query = $query." DESC"; } else { $img_P=" "; $query = $query." ASC"; } $query = $query.", Updatetime DESC"; } print << Station Status Last Update$img_LU Report Time$img_RT To Date Priority$img_P Assigned To Type END; $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); if (mysql_num_rows($result) >= 1) { $i = 0; while ($row = mysql_fetch_row($result)) { $i++; if ($i < ($page-1)*6+1){continue;} else if ($i > $page*6){break;} if ($row[1]==0){$row[1]='Open';} else if ($row[1]==8){$row[1]='Closed';} else if ($row[1]==3){$row[1]='Solved';} if ($row[6] > $listtime) {$image="";} else {$image="";} if ($row[7] == '1') { $Priority = "Medium"; } else if ($row[7] == '2') { $Priority = " High"; } else if ($row[7] == '0') { $Priority = " Low"; } $Person = "None"; if ($row[8] != '') { $query2 = "SELECT FirstName, LastName from userlist WHERE username = '$row[8]'"; $result2 = mysql_query($query2, $connection) or die ("Error in query: $query2. " . mysql_error()); if (mysql_num_rows($result2) == 1) { $row2 = mysql_fetch_row($result2); $Person = $row2[0]; } } print << $row[10] $row[1] $row[2] $row[3] $row[4] Days $Priority $Person $row[9] $image$row[5] ... END; } } echo ""; echo "< "; $p = $page - 1; if ($p > 0) { print "Previous"; } $m = $num/6; if ($num%6 >0){$m++;} for ($i = 1; $i <= $m; $i++) { if ($i == $page){print " $i";} else {print " $i";} } $p = $page + 1; if ($p < $m || ($p == $m) && ($num%6) ==0) { print " Next"; } echo " >"; ?>
