| 1 |
<?
|
| 2 |
// lista.php
|
| 3 |
// Title: downlink table
|
| 4 |
|
| 5 |
session_start();
|
| 6 |
|
| 7 |
include("ins/connect.inc.php");
|
| 8 |
include("header-list.html");
|
| 9 |
?>
|
| 10 |
<script type="text/javascript">
|
| 11 |
function conferma () {
|
| 12 |
chiediConferma = confirm('Are you sure of wanting to cancel the record?!!!!!');
|
| 13 |
|
| 14 |
if (chiediConferma == true){
|
| 15 |
location.href="lista.php"; //ricarica la pagina
|
| 16 |
}
|
| 17 |
else{
|
| 18 |
document.write("Cancelled procedure")
|
| 19 |
window.location.reload('lista.php');
|
| 20 |
|
| 21 |
}
|
| 22 |
}
|
| 23 |
</script>
|
| 24 |
<?
|
| 25 |
|
| 26 |
if ( !isset($_SESSION["login"]) ) {
|
| 27 |
echo "<hr><p align=left><font face=Verdana size=2><b><a href='ins/loginform.php'>Login Downlink</a> </b></font></p>";
|
| 28 |
} else {
|
| 29 |
echo "<hr><p align=left><font face=Verdana size=2><b><a href='ins/logout.php'>Logout Downlink</a></b></font></p>";
|
| 30 |
}
|
| 31 |
if ( !isset($_SESSION["login"]) ) {
|
| 32 |
echo "<hr><p align=left><font face=Verdana size=2><b><a href='action/loginform.php'>Login Action</a> </b></font></p>";
|
| 33 |
echo "<hr>";
|
| 34 |
} else {
|
| 35 |
echo "<hr><p align=left><font face=Verdana size=2><b><a href='action/logout.php'>Logout Action</a></b></font></p>";
|
| 36 |
echo "<hr>";
|
| 37 |
}
|
| 38 |
echo "<font face='verdana' size='2'><li><b><a href='ins/reg.php'>Form Downlink</a></b></font>";
|
| 39 |
echo "<br><br>";
|
| 40 |
echo "<font face='verdana' size='2'><li><b><a href='action/action.php'>Form Action</a></b></font>";
|
| 41 |
echo "<br>";
|
| 42 |
echo "<br><center><Font face='VERDANA' size=4 color=red><b>Downlink & Action Table</font></b></center><p>";
|
| 43 |
|
| 44 |
echo "<table width='100%' cellpadding='4' border='1'>";
|
| 45 |
echo "<tr><td bgcolor='#e4e9fc'>";
|
| 46 |
|
| 47 |
$totale=0.;
|
| 48 |
$str_1 ="create temporary table tmp1 select orbit, count(edtt) as ttt from comm_downlink group by orbit";
|
| 49 |
$query = mysql_query($str_1);
|
| 50 |
$str_2 ="select a.orbit, a.edtt, a.nome from comm_downlink as a, tmp1 as b where (a.error < 1000 AND (a.ipm LIKE '%3%' OR a.ipm LIKE '%4%') AND "
|
| 51 |
."a.orbit=b.orbit AND b.ttt>1)";
|
| 52 |
$query = mysql_query($str_2);
|
| 53 |
while ($row = mysql_fetch_row($query))
|
| 54 |
{
|
| 55 |
$or=$row[0];
|
| 56 |
$time=$row[1];
|
| 57 |
$file=$row[2];
|
| 58 |
$str="select orbit, edtt, nome from comm_downlink where (error < 1000 AND (ipm LIKE '%3%' OR ipm LIKE '%4%') AND orbit=$or)";
|
| 59 |
$query_ = MyQuery($str);
|
| 60 |
$t=$time;
|
| 61 |
while ($row_ = mysql_fetch_row($query_))
|
| 62 |
{
|
| 63 |
$time_=$row_[1];
|
| 64 |
$file_=$row_[2];
|
| 65 |
if ($file_>$file) {$t=$time_;}
|
| 66 |
} //echo "or=".$or." newor=".$row_[0]." time=".$t." file=".$file." newfile=".$file_."<BR>";
|
| 67 |
$totale=$totale+$t;
|
| 68 |
}
|
| 69 |
$str_3="create temporary table tmp2 select a.orbit from comm_downlink as a, tmp1 as b where a.orbit=b.orbit AND b.ttt<2";
|
| 70 |
$query = MyQuery($str_3);
|
| 71 |
|
| 72 |
$strsql = "select sum(a.edtt) as totalecolonna from comm_downlink as a, tmp2 as c WHERE (a.error < 1000 AND (a.ipm LIKE '%3%' OR a.ipm LIKE '%4%') AND "
|
| 73 |
."a.orbit=c.orbit)";
|
| 74 |
$query = mysql_query($strsql);
|
| 75 |
$row = mysql_fetch_array($query); //echo $totale."<BR>";
|
| 76 |
$totale = $totale+$row["totalecolonna"]; //echo $totale."<BR>";
|
| 77 |
|
| 78 |
//$strsql = "select sum(temp.edtt) as totalecolonna from (select distinct(orbit), edtt from comm_downlink WHERE (error < 1000 AND (ipm LIKE '%3%' OR ipm LIKE '%4%'))) as temp";
|
| 79 |
//$query = mysql_query($strsql);
|
| 80 |
//$row = mysql_fetch_array($query);
|
| 81 |
//$totale = $row["totalecolonna"];
|
| 82 |
echo "<font face=verdana size=1><b>TOT. Effective data taking time (s) with IPM 3/4: <font color='red'> $totale</b></font></font>";
|
| 83 |
echo "</td></tr>";
|
| 84 |
|
| 85 |
echo "<tr><td bgcolor='#e4e9fc'>";
|
| 86 |
//$strsql = "select sum(edtt) as totalecolonna from comm_downlink WHERE (ipm NOT LIKE '%3%' AND ipm NOT LIKE '%4%')";
|
| 87 |
MyQuery("create temporary table tmp3 select distinct(orbit), edtt from comm_downlink WHERE (ipm NOT LIKE '%3%' AND ipm NOT LIKE '%4%')");
|
| 88 |
$strsql = "select sum(edtt) as totalecolonna from tmp3";
|
| 89 |
|
| 90 |
$query = mysql_query($strsql);
|
| 91 |
$row = mysql_fetch_array($query);
|
| 92 |
$totale = $row["totalecolonna"];
|
| 93 |
echo "<font face=verdana size=1><b>TOT. Effective data taking time (s) without IPM 3/4: <font color='red'> $totale</b></font></font>";
|
| 94 |
echo "</td></tr>";
|
| 95 |
|
| 96 |
echo "<tr><td bgcolor='#e4e9fc'>";
|
| 97 |
//$strsql = "select sum(edtt) as totalecolonna from comm_downlink ";
|
| 98 |
MyQuery("create temporary table tmp4 select distinct(orbit), edtt from comm_downlink");
|
| 99 |
$strsql = "select sum(edtt) as totalecolonna from tmp4";
|
| 100 |
//$strsql = "select sum(temp2.edtt) as totalecolonna from (select distinct(orbit), edtt from comm_downlink) as temp2";
|
| 101 |
|
| 102 |
$query = mysql_query($strsql);
|
| 103 |
$row = mysql_fetch_array($query)or die (mysql_error());
|
| 104 |
$totale = $row["totalecolonna"];
|
| 105 |
echo "<font face=verdana size=1><b>TOT. Effective data taking time (s): <font color='red'> $totale</b></font></font>";
|
| 106 |
echo "</td></tr>";
|
| 107 |
|
| 108 |
echo "</table>";
|
| 109 |
echo "<br>";
|
| 110 |
echo "<br>";
|
| 111 |
echo "<table width='100%' cellpadding='4'>";
|
| 112 |
|
| 113 |
echo "<tr bgcolor='#708090'>";
|
| 114 |
if ( isset($_SESSION["login"]) ) {
|
| 115 |
echo "<td colspan='2'><center><font color='white' face='verdana' size='1'>Field modification</font></center></td>";
|
| 116 |
}
|
| 117 |
echo "<td width='3%'><center><font color='white' face='verdana' size='1'><b>Counter</b></font></center></td>";
|
| 118 |
echo "<td width='10%'><center><font color='white' face='verdana' size='1'><b>Filename/Action</b></font></center></td>
|
| 119 |
<td width='3%'><center><font color='white' face='verdana' size='1'><b>Orbit of download</b></font></center></td>
|
| 120 |
<td width='3%'><center><font color='white' face='verdana' size='1'><b>Absolute time (s)</b></font></center></td>
|
| 121 |
<td width='13%'><center><font color='white' face='verdana' size='1'><b>Effective Data<br>Taking Time (s)</b></font></center></td>
|
| 122 |
<td width='13%'><center><font color='white' face='verdana' size='1'><b>Date & Hour MWT Download/Action</b></font></center></td>
|
| 123 |
<td width='13%'><center><font color='white' face='verdana' size='1'><b>Date & Hour MWT Downlink (for downloads)</b></font></center></td>
|
| 124 |
<td width='5%'><center><font color='white' face='verdana' size='1'><b>Size (GB)</b></font></center></td>
|
| 125 |
<td width='5%'><center><font color='white' face='verdana' size='1'><b>Error Rate</b></font></center></td>
|
| 126 |
<td width='5%'><center><font color='white' face='verdana' size='1'><b>Trigger</b></font></center></td>
|
| 127 |
<td width='5%'><center><font color='white' face='verdana' size='1'><b>IPM</b></font></center></td>
|
| 128 |
<td width='5%'><center><font color='white' face='verdana' size='1'><b>ws</b></font></center></td>
|
| 129 |
<td width='40%'><center><font color='white' face='verdana' size='1'><b>Comments</b></font></center></td>";
|
| 130 |
|
| 131 |
echo "</tr>";
|
| 132 |
|
| 133 |
|
| 134 |
|
| 135 |
$sql = "SELECT * FROM comm_downlink ORDER BY orbit DESC ";
|
| 136 |
$res = MyQuery($sql);
|
| 137 |
|
| 138 |
//testo aggiunto per colorare righe
|
| 139 |
$bgcolor[0] = "bgcolor=#edf5fg";
|
| 140 |
$bgcolor[1] = "bgcolor=#cccccc";
|
| 141 |
$counter = 0;
|
| 142 |
//fine testo aggiunto per colorare righe
|
| 143 |
while( $row = mysql_fetch_array($res, MYSQL_ASSOC) ) {
|
| 144 |
|
| 145 |
// testo aggiunto per colorare righe
|
| 146 |
$bc = $bgcolor[$counter];
|
| 147 |
$counter = 1 - $counter;
|
| 148 |
|
| 149 |
echo "<tr $bc>";
|
| 150 |
//testo per modifica e eliminazione campo
|
| 151 |
if ( isset($_SESSION["login"]) ) {
|
| 152 |
echo "<td><font face=Verdana size=1><a href='ins/reg.php?id=".$row["id"]."'>change</a></td>";
|
| 153 |
echo "<td><font face=Verdana size=1><a href='ins/delete.php?id=".$row["id"]."' onClick='conferma();'>delete</a></td>";
|
| 154 |
}
|
| 155 |
echo "<td><font face=verdana size=1>".$row["id"]."</FONT></td>";
|
| 156 |
echo "<td><font face=verdana size=1><a href='http://pamela-qlook.roma2.infn.it/filesFromYoda/".$row["nome"]."'>".$row["nome"]."</FONT></td>";
|
| 157 |
echo "<td><font face=verdana size=1>".$row["orbit"]."</FONT></td>";
|
| 158 |
echo "<td><font face=verdana size=1>".$row["time"]."</FONT></td>";
|
| 159 |
echo "<td><font face=verdana size=1>".$row["edtt"]."</FONT></td>";
|
| 160 |
$myData = Explode( "-", $row["datedld"] );
|
| 161 |
|
| 162 |
echo "<td><font face=verdana size=1>$myData[2]/$myData[1]/$myData[0] - ".$row["oradld"]."</font></td>";
|
| 163 |
$myData1 = Explode( "-", $row["datedlk"] );
|
| 164 |
|
| 165 |
echo "<td><font face=verdana size=1>$myData1[2]/$myData1[1]/$myData1[0] - ".$row["oradlk"]."</font></td>";
|
| 166 |
echo "<td><font face=verdana size=1>".$row["rr"]."</font></td>";
|
| 167 |
echo "<td><font face=verdana size=1>".$row["error"]."</font></td>";
|
| 168 |
echo "<td><font face=verdana size=1>".$row["a18"]."</font></td>";
|
| 169 |
echo "<td><font face=verdana size=1>".$row["ipm"]."</font></td>";
|
| 170 |
echo "<td><font face=verdana size=1>".$row["ws"]."</font></td>";
|
| 171 |
|
| 172 |
echo "<td><font face=verdana size=1>".$row["comments"]."</font></td>";
|
| 173 |
|
| 174 |
|
| 175 |
echo "</tr>";
|
| 176 |
}
|
| 177 |
//fine testo
|
| 178 |
echo "</table>";
|
| 179 |
|
| 180 |
|
| 181 |
|
| 182 |
|
| 183 |
//testo scoperto oggi
|
| 184 |
|
| 185 |
//fine del testo tolto
|
| 186 |
include("footer-list.html");
|
| 187 |
?>
|
| 188 |
|
Parent Directory
| 
Revision Log