Viewing File web/history.test.php of 0.00.0a
|
1: <?php 2: ob_start(); 3: require("include.php"); 4: $NATS->Start(); 5: if (!$NATS_Session->Check($NATS->DB)) 6: { 7: header("Location: ./?login_msg=Invalid+Or+Expired+Session"); 8: exit(); 9: } 10: if ($NATS_Session->userlevel<1) UL_Error("View Test History"); 11: 12: $tmode=""; 13: switch($_REQUEST['testid'][0]) 14: { 15: case "L": $tmode="local"; 16: break; 17: default: $tmode="unknown"; 18: } 19: $stid=substr($_REQUEST['testid'],1,128); 20: 21: // get test info 22: $tnode=""; 23: $tname=""; 24: $ttype=""; 25: $tparam=""; 26: $tlastrunx=""; 27: $trecord=1; 28: 29: $q=""; 30: if ($tmode=="local") $q="SELECT * FROM fnlocaltest WHERE localtestid=".ss($stid); 31: 32: $r=$NATS->DB->Query($q); 33: 34: if (!$row=$NATS->DB->Fetch_Array($r)) 35: { 36: header("main.php?message=Error+opening+test+history"); 37: exit(); 38: } 39: 40: $tnode=$row['nodeid']; 41: $ttype=$row['testtype']; 42: $tparam=$row['testparam']; 43: $tlastrunx=$row['lastrunx']; 44: $tname=lText($ttype); 45: if ($tparam!="") $tname.=" (".$tparam.")"; 46: $NATS->DB->Free($r); 47: Screen_Header("History for ".$tname." on ".$tnode,1); 48: ob_end_flush(); 49: 50: $td_day=date("d"); 51: $td_mon=date("m"); 52: $td_yr=date("Y"); 53: 54: $start=array(); 55: $finish=array(); 56: if (isset($_REQUEST['st_day'])) $start['day']=$_REQUEST['st_day']; 57: else $start['day']=$td_day; 58: if (isset($_REQUEST['st_mon'])) $start['mon']=$_REQUEST['st_mon']; 59: else $start['mon']=$td_mon; 60: if (isset($_REQUEST['st_yr'])) $start['yr']=$_REQUEST['st_yr']; 61: else $start['yr']=$td_yr; 62: if (isset($_REQUEST['st_hour'])) $start['hour']=$_REQUEST['st_hour']; 63: else $start['hour']=0; 64: if (isset($_REQUEST['st_min'])) $start['min']=$_REQUEST['st_min']; 65: else $start['min']=0; 66: if (isset($_REQUEST['st_sec'])) $start['sec']=$_REQUEST['st_sec']; 67: else $start['sec']=0; 68: 69: if (isset($_REQUEST['fi_day'])) $finish['day']=$_REQUEST['fi_day']; 70: else $finish['day']=$td_day; 71: if (isset($_REQUEST['fi_mon'])) $finish['mon']=$_REQUEST['fi_mon']; 72: else $finish['mon']=$td_mon; 73: if (isset($_REQUEST['fi_yr'])) $finish['yr']=$_REQUEST['fi_yr']; 74: else $finish['yr']=$td_yr; 75: if (isset($_REQUEST['fi_hour'])) $finish['hour']=$_REQUEST['fi_hour']; 76: else $finish['hour']=23; 77: if (isset($_REQUEST['fi_min'])) $finish['min']=$_REQUEST['fi_min']; 78: else $finish['min']=59; 79: if (isset($_REQUEST['fi_sec'])) $finish['sec']=$_REQUEST['fi_sec']; 80: else $finish['sec']=59; 81: 82: 83: $startx=mktime($start['hour'],$start['min'],$start['sec'],$start['mon'],$start['day'],$start['yr']); 84: $finishx=mktime($finish['hour'],$finish['min'],$finish['sec'],$finish['mon'],$finish['day'],$finish['yr']); 85: //echo $startx." ".nicedt($startx)."<br>"; 86: //echo $finishx." ".nicedt($finishx)."<br>"; 87: 88: echo "<br><table border=0>"; 89: echo "<tr><td align=left valign=top>"; 90: echo "<b class=\"subtitle\">".$tname."</b><br>"; 91: 92: echo "<table class=\"nicetable\">"; 93: echo "<tr><td align=right>Node :</td>"; 94: echo "<td align=left><a href=node.php?nodeid=".$tnode.">".$tnode."</a>"; 95: echo "</tr></tr>"; 96: echo "<tr><td align=right valign=top>Last Run :</td>"; 97: echo "<td align=left align=top>"; 98: if ($tlastrunx>0) 99: { 100: echo nicedt($tlastrunx)."<br>"; 101: echo dtago($tlastrunx); 102: } 103: else echo "Never"; 104: echo "</td>"; 105: echo "</tr></tr>"; 106: echo "</table>"; 107: 108: echo "</td><td width=50> </td><td align=left valign=top>"; 109: 110: echo "<b><u>Reporting Period</u></b><br>"; 111: 112: echo "<table class=\"nicetable\">"; 113: echo "<tr><td> </td><td>Hour</td><td>Min</td><td>Sec</td><td>Day</td><td>Mon</td><td>Year</td></tr>"; 114: echo "<form action=history.test.php method=post>"; 115: echo "<input type=hidden name=testid value=\"".$_REQUEST['testid']."\">"; 116: 117: function slist($var,$min,$max,$val) 118: { 119: echo "\n<select name=\"".$var."\">\n"; 120: echo "<option value=\"".$val."\">".$val."</option>\n"; 121: for ($a=$min; $a<=$max; $a++) 122: echo "<option value=\"".$a."\">".$a."</option>\n"; 123: echo "</select>\n"; 124: } 125: 126: 127: echo "<tr><td><b>Start:</b></td>"; 128: echo "<td>"; 129: slist("st_hour",0,23,$start['hour']); 130: echo ":"; 131: echo "</td>"; 132: 133: echo "<td>"; 134: slist("st_min",0,59,$start['min']); 135: echo ":"; 136: echo "</td>"; 137: 138: echo "<td>"; 139: slist("st_sec",0,59,$start['sec']); 140: echo " "; 141: echo "</td>"; 142: 143: echo "<td>"; 144: slist("st_day",1,31,$start['day']); 145: echo "/"; 146: echo "</td>"; 147: 148: echo "<td>"; 149: slist("st_mon",1,12,$start['mon']); 150: echo "/"; 151: echo "</td>"; 152: 153: echo "<td>"; 154: echo "<input type=text name=st_yr value=\"".$start['yr']."\" size=5 maxlength=4>"; 155: 156: echo " <a href=history.test.php?testid=".$_REQUEST['testid'].">Today</a>"; 157: 158: echo "</td>"; 159: 160: echo "</tr>"; 161: 162: // ----- finish 163: 164: echo "<tr><td><b>Start:</b></td>"; 165: echo "<td>"; 166: slist("fi_hour",0,23,$finish['hour']); 167: echo ":"; 168: echo "</td>"; 169: 170: echo "<td>"; 171: slist("fi_min",0,59,$finish['min']); 172: echo ":"; 173: echo "</td>"; 174: 175: echo "<td>"; 176: slist("fi_sec",0,59,$finish['sec']); 177: echo " "; 178: echo "</td>"; 179: 180: echo "<td>"; 181: slist("fi_day",1,31,$finish['day']); 182: echo "/"; 183: echo "</td>"; 184: 185: echo "<td>"; 186: slist("fi_mon",1,12,$finish['mon']); 187: echo "/"; 188: echo "</td>"; 189: 190: echo "<td>"; 191: echo "<input type=text name=fi_yr value=\"".$finish['yr']."\" size=5 maxlength=4>"; 192: 193: echo " <input type=submit value=Go>"; 194: 195: echo "</td>"; 196: 197: echo "</tr>"; 198: 199: // 7 200: echo "<tr><td><b>Opts:</b></td>"; 201: echo "<td colspan=\"6\">"; 202: function cbd($var,$name) 203: { 204: if (isset($_REQUEST[$var])) $s=" checked"; 205: else $s=""; 206: echo "<input type=checkbox name=\"".$var."\" value=1".$s."> ".$name; 207: } 208: cbd("disp_hdata","Hide Data"); 209: echo " "; 210: cbd("disp_pass","Show Passed"); 211: echo " "; 212: cbd("disp_graph","Display Graph"); 213: echo "</td></tr>"; 214: 215: echo "</form>"; 216: echo "</table>"; 217: 218: echo "</td></tr></table>"; 219: 220: echo "<br><br>"; 221: 222: echo "<b>Report from ".nicedt($startx)." to ".nicedt($finishx); 223: // echo " (".nicediff($finishx-$startx).")"; 224: echo "</b><br><br>"; 225: 226: // graph data 227: //if (isset($_REQUEST['disp_graph'])) 228: echo "<img src=test.graph.php?testid=".$_REQUEST['testid']."&startx=".$startx."&finishx=".$finishx."&nodeid=".$tnode."><br><br>"; 229: 230: // table data 231: 232: if (!isset($_REQUEST['disp_hdata'])) 233: { 234: $q="SELECT alertlevel,testvalue,recordx FROM fnrecord WHERE "; 235: $q.="testid=\"".ss($_REQUEST['testid'])."\" AND recordx>=".$startx." AND recordx<=".$finishx; 236: if (!isset($_REQUEST['disp_pass'])) $q.=" AND alertlevel!=0"; 237: $q.=" ORDER BY recordx DESC"; 238: //echo $q; 239: $r=$NATS->DB->Query($q); 240: 241: echo "<table class=\"nicetable\">"; 242: while ($row=$NATS->DB->Fetch_Array($r)) 243: { 244: echo "<tr><td>".nicedt($row['recordx'])."</td>"; 245: echo "<td><b class=\"al".$row['alertlevel']."\">".oText($row['alertlevel'])."</b></td>"; 246: echo "<td>".$row['testvalue']."</td>"; 247: echo "</tr>"; 248: } 249: 250: echo "</tr>"; 251: echo "</table>"; 252: } 253: 254: 255: Screen_Footer(); 256: ?> 257: