/[PAMELA software]/utilities/downlinktable/src/lista.php
ViewVC logotype

Annotation of /utilities/downlinktable/src/lista.php

Parent Directory Parent Directory | Revision Log Revision Log

Revision 1.2 - (hide annotations) (download)
Fri May 11 09:26:32 2007 UTC (18 years, 7 months ago) by cafagna
Branch: MAIN
CVS Tags: v1r2, HEAD
Changes since 1.1: +2 -1 lines 
Link to quicklook pages added
1 cafagna 1.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:&nbsp;<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:&nbsp;<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):&nbsp;<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 &amp; Hour MWT Download/Action</b></font></center></td>
123     <td width='13%'><center><font color='white' face='verdana' size='1'><b>Date &amp; 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 cafagna 1.2 echo "<td><font face=verdana size=1><a href='http://pamela-qlook.roma2.infn.it/filesFromYoda/".$row["nome"]."'>".$row["nome"]."</FONT></td>";
157 cafagna 1.1 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 cafagna 1.2
  ViewVC Help
Powered by ViewVC 1.1.23