'; ?> output.txt &"; exec($exec); } } $sql = "SELECT DISTINCT fkey_wms_id FROM mb_monitor"; $res = db_prep_query($sql, array(), array()); $cnt = 0; $wms = array(); while(db_fetch_row($res)){ $wms[$cnt] = db_result($res,$cnt,"fkey_wms_id"); $cnt++; } $status = array(); $upload_id = array(); for ($i=0; $i intval(TIME_LIMIT)) { $comment[$wms[$i]] = "Monitoring process timed out."; $new_sql = "UPDATE mb_monitor SET status = '-1', status_comment = 'Monitoring process timed out.', timestamp_end = $1 WHERE fkey_wms_id = $2 AND upload_id = $3"; $new_v = array((intval($upload_id[$wms[$i]])+intval(TIME_LIMIT)), $wms_id[$wms[$i]], $upload_id[$wms[$i]]); $new_t = array('s', 'i', 's'); $new_res = db_prep_query($new_sql,$new_v,$new_t); } $sql = "SELECT COUNT(upload_id) FROM mb_monitor WHERE fkey_wms_id = $1 AND NOT status = '-2'"; $v = array($wms[$i]); $t = array('i'); $res = db_prep_query($sql, $v, $t); $total[$wms[$i]] = db_result($res, 0, 0); $sql = "SELECT COUNT(upload_id) FROM mb_monitor WHERE fkey_wms_id = $1 AND status = '-1'"; $v = array($wms[$i]); $t = array('i'); $res = db_prep_query($sql, $v, $t); $fail = db_result($res, 0, 0); $percentage[$wms[$i]] = 100 - round(100*floatval($fail)/floatval($total[$wms[$i]]), 1); } $newArray = $status; if ($_GET['sortby']) { if ($_GET['sortby'] == "wms") { $newArray = $wms_id; asort($newArray); } elseif ($_GET['sortby'] == "status") { $newArray = $status; asort($newArray); } elseif ($_GET['sortby'] == "avgresp") { $newArray = $avg_response_time; asort($newArray); } elseif ($_GET['sortby'] == "avail") { $newArray = $percentage; arsort($newArray); } elseif ($_GET['sortby'] == "last") { $newArray = $upload_id; arsort($newArray); } elseif ($_GET['image'] == "last") { $newArray = $image; arsort($newArray); } } $str = "monitoring results

\n"; $str .= "
\n\t"; $str .= "\n\t\n"; $str .= "\n\t\n

\n "; $str .= ""; $str .= ""; $str .= ""; $str .= ""; $str .= ""; $str .= ""; $cnt = 0; foreach ($newArray as $k => $value) { $img = "stop.bmp"; if ($status[$k]==0) $img = "wait.bmp"; elseif ($status[$k]==1) $img = "go.bmp"; if ($updated[$k] == "0" && $status[$k] == 0) $fill = "checked"; else $fill = "disabled"; if (fmod($cnt, 2) == 1) { $str .= "\n\t\t"; } else { $str .= "\n\t\t"; } $str .= "\n\t\t\t"; $str .= "\n\t\t\t"; $str .= "\n\t\t\t"; $str .= "\n\t\t\t"; $str .= "\n\t\t\t"; } else { $str .= "'>x
wmscurrent statusimageavg. response timeoverall availability
" . $wms_id[$k] . "
" . $admin->getWmsTitleByWmsId($wms_id[$k]) . "		" . $comment[$k] . "
".date("F j, Y, G:i:s", $upload_id[$k])."
"; $str .= "
o
"; } $str .= "\n\t\t\t"; if ($avg_response_time[$k] == NULL) { $str .= "n/a"; } else { $str .= $avg_response_time[$k] . " s"; } $str .= ""; $str .= "\n\t\t\t" . $percentage[$k] . " %  (" . $total[$k] . " cycles)
"; $str .= ""; $val = $percentage[$k]; for ($i=0; $i<10; $i++) { if ($val>=10) { $str .= ""; $val-=10; } elseif($val>0){ $str .= ""; if (round($val) < 10) { $str .= ""; } $val=-1; } else { $str .= ""; } } $str .= "
"; # $str .= "\n\t\t\tlog"; $str .= "\n\t\t"; $cnt++; } $str .= "\n\t\n\t
\n
"; echo $str; ?>