source: trunk/MagicSoft/Mars/datacenter/db/ganymed.php@ 7516

Last change on this file since 7516 was 7516, checked in by Daniela Dorner, 19 years ago
*** empty log message ***
  • Property svn:executable set to *
File size: 9.9 KB
Line 
1<?php
2{
3 function CreateQuery($_GET)
4 {
5 $query0 = "SELECT ";
6 //datasets (0-3)
7 $query0 .= " DataSets.fDataSetNumber, fWobble, fComment, ";//0,1,2
8 $query0 .= " fSourceName, ";//3
9 //steps (4-7)
10 $query0 .= " fDataSetInserted, fStarFilesAvail, ";//4,5
11 $query0 .= " fGanymed, fFillGanymed, ";//6,7
12 //ganymed (8-13)
13 $query0 .= " fExcessEvents, fBackgroundEvents, fSignalEvents, ";//8,9,10
14 $query0 .= " fSignificance, fScaleFactor, fEffOnTime ";//11,12,13
15
16 $query0 .= " FROM DataSets ";
17
18 $query0 .= " LEFT JOIN Source ON DataSets.fSourceKEY=Source.fSourceKEY ";
19 $query0 .= " LEFT JOIN DataSetProcessStatus ON DataSets.fDataSetNumber=DataSetProcessStatus.fDataSetNumber ";
20 $query0 .= " LEFT JOIN Ganymed ON DataSets.fDataSetNumber=Ganymed.fDataSetNumber ";
21
22 $query0 .= " WHERE DataSets.fDataSetNumber between " . $_GET["fRunMin"] . " and " . $_GET["fRunMax"] ;
23 if (!empty($_GET["fSequenceNo"]))
24 $query0 .= " AND DataSets.fDataSetNumber='" . $_GET["fSequenceNo"] . "'";
25 $query0 .= " AND fSourceName REGEXP \"^" . $_GET["fSourceN"] . "\" ";
26 $query0 .= " ORDER BY DataSets.fDataSetNumber ";
27
28 return $query0;
29 }
30
31 function InitGet($_GET)
32 {
33 // Find out whether it is the first call to the php script
34 $first = empty($_GET["fRunMin"]) && empty($_GET["fRunMax"]);
35
36 if (empty($_GET["fNumResults"]))
37 $_GET["fNumResults"]="20";
38
39 if (empty($_GET["fAll"]))
40 $_GET["fAll"]=$first?"On":"";
41
42 }
43
44 function PrintForm($_GET, $db)
45 {
46 printf("<center>\n");
47 printf("<form action=\"ganymed.php\" METHOD=\"GET\">\n");
48
49 printf("DataSet#&nbsp;<input name=\"fDataSetNo\" type=\"text\" size=\"6\" maxlength=\"6\" value=\"");
50 if (!empty($_GET["fDataSetNo"]))
51 printf("%s", $_GET["fDataSetNo"]);
52 printf("\">&nbsp;&nbsp;&nbsp;\n");
53
54 if (empty($_GET["fRunMin"]))
55 $min = GetMin("fDataSetNumber", "DataSets", $db);
56 else
57 $min = $_GET["fRunMin"];
58
59 if (empty($_GET["fRunMax"]))
60 $max = GetMax("fDataSetNumber", "DataSets", $db);
61 else
62 $max = $_GET["fRunMax"];
63
64 printf("DataSets&nbsp;from&nbsp;<input name=\"fRunMin\" type=\"text\" size=\"6\" maxlength=\"6\" value=\"%s\">\n", $min);
65 printf("to&nbsp;<input name=\"fRunMax\" type=\"text\" size=\"6\" maxlength=\"6\" value=\"%s\">&nbsp;&nbsp;&nbsp;\n", $max);
66
67 if ($_GET["fAll"]=="On")
68 $checked = "checked";
69 else
70 $checked = "";
71 printf("<input type=\"checkbox\" name=\"fAll\" value=\"On\" %s>plots\n", $checked);
72
73 printf(" <P>\n");
74
75 printf("Source&nbsp;(<A HREF=\"regexp.html\">regexp</A>)&nbsp;<input name=\"fSourceN\" type=\"text\" size=\"15\" maxlength=\"15\" value=\"");
76 if (!empty($_GET["fSourceN"]))
77 printf("%s", $_GET["fSourceN"]);
78 printf("\">&nbsp;&nbsp;&nbsp;\n");
79
80
81 ini_set("mysql.trace_mode", "Off");
82 ini_set("display_errors", "Off");
83
84 printf("<input class='Width' type='submit' value='Query Table'>&nbsp;&nbsp;&nbsp;\n");
85 printf("<input class='Width' type='button' value='Reset' onClick='self.location.href=\"ganymed.php\"'>&nbsp;&nbsp;&nbsp;\n");
86 if (strchr($_SERVER["REQUEST_URI"], '?')!=FALSE)
87 printf("<input class='Width' type='button' value='Print' onClick='self.location.href=\"%s&fPrintTable=1\"'>&nbsp;&nbsp;&nbsp;\n", $_SERVER["REQUEST_URI"]);
88 printf("</form>\n");
89 printf("</center>\n");
90 printf("</td>\n");
91 printf("</tr>\n");
92 printf("<tr class='Block'>\n");
93 printf("<td>\n");
94 }
95
96 function GetStatus($step)
97 {
98 if (is_null($step))
99 return "<font color='#FF0000'>not done</font>";
100 else
101 {
102 if (strpos($step, "1970-01-01 00:00:00")==FALSE)
103 return "done";
104 else
105 return "not to be done";
106 }
107 return "there is an error -> tell Dani";
108 }
109/*
110 function GetSequences($datasetfile)
111// function QueryRuns($type, $sequ, $db_id, $db)
112 {
113 printf(" <td align='left'>");
114 printf(" to be done");
115 printf(" </td>\n");
116 printf(" <td> to be done ");
117 printf(" </td>\n");
118 }
119
120 function QueryMissingFiles($sequ, $db_id, $db)
121 {
122 $query2 = "SELECT fSequenceFirst FROM SequencesSequenceProcessStatus ";
123 $query2 .= " WHERE fSequenceFirst=" . $sequ . " AND IsNull(fStar)";
124
125 mysql_select_db($db);
126 $files = mysql_query($query2, $db_id);
127 $numfiles = mysql_num_rows($files);
128 printf(" <td align='left'>");
129 for ($i=0 ; $i<$numfiles ; $i++)
130 {
131 $file=mysql_result($files, $i, 0);
132 if ($i!=0)
133 printf(", ");
134 printf(" %s ", $file);
135 }
136 printf(" </td>\n");
137 }
138*/
139
140 function PrintSequenceInfo($result0, $db_id, $db)
141 {
142 $numres = mysql_num_rows($result0);
143
144 printf("<center>");
145 printf("<table BORDER=\"0\">\n");
146 printf("<tr><td>");
147 printf("# of DataSets: %d ", $numres);
148 printf("</td></tr>");
149
150 for ($i=0 ; $i<$numres ; $i++)
151 {
152 $datasetno=mysql_result($result0, $i, 0);
153 $wobble=mysql_result($result0, $i, 1);
154 $comment=mysql_result($result0, $i, 2);
155 $source=mysql_result($result0, $i, 3);
156 $inserted=mysql_result($result0, $i, 4);
157 $filesavail=mysql_result($result0, $i, 5);
158 $ganymed=mysql_result($result0, $i, 6);
159 $fillganymed=mysql_result($result0, $i, 7);
160 $excess=mysql_result($result0, $i, 8);
161 $bg=mysql_result($result0, $i, 9);
162 $signal=mysql_result($result0, $i, 10);
163 $signif=mysql_result($result0, $i, 11);
164 $scale=mysql_result($result0, $i, 12);
165 $effontime=mysql_result($result0, $i, 13);
166
167 printf("<tr><td>");
168
169 printf(" <table BORDER=\"1\">");
170 printf(" <tr BGCOLOR='#C0C0C0'>\n");
171 printf(" <th colspan=\"6\"><u>DataSet#:</u> %s </th>", $datasetno);
172 printf(" </tr><tr BGCOLOR='#E0E0E0' ALIGN='left'>\n");
173 printf(" <th colspan=\"6\"> %s - Wobble %s ", $comment, $wobble);
174 if (!is_null($ganymed))
175 printf(", <font color='green'>ganymed done</font> ");
176 printf(" </th></tr>\n");
177
178 printf(" <tr><td colspan=\"6\"></td></tr>\n");
179
180 if (!is_null($fillganymed))
181 {
182 printf(" <tr BGCOLOR='#C0C0C0'><th colspan=\"6\">results</th></tr>");
183 printf(" <tr BGCOLOR='#E0E0E0'>\n");
184 printf(" <td>excess events</td>\n");
185 printf(" <td>background events</td>\n");
186 printf(" <td>signal events</td>\n");
187 printf(" <td>significance</td>\n");
188 printf(" <td>scale factor</td>\n");
189 printf(" <td>effective ontime</td>\n");
190 printf(" </tr><tr BGCOLOR='#D0D0D0' align='right'>");
191 printf(" <td>%s</td>\n", $excess);
192 printf(" <td>%s</td>\n", $bg);
193 printf(" <td>%s</td>\n", $signal);
194 printf(" <td>%s</td>\n", $signif);
195 printf(" <td>%s</td>\n", $scale);
196 printf(" <td>%s</td>\n", $effontime);
197 }
198
199
200 if ($_GET["fAll"]=="On" && !is_null($ganymed))
201 {
202 printf("</td></tr><tr><td>\n");
203
204 printf(" <table BORDER=\"1\">");
205 printf(" <tr BGCOLOR='#C0C0C0'>\n");
206 printf(" <th colspan=\"6\">plots</th>");
207 printf(" </tr>\n");
208 printf(" <tr><td colspan=\"6\">\n");
209 $num=sprintf("%08d",$datasetno);
210 printf(" <a href=\"http://www.astro.uni-wuerzburg.de/datacenter/ganymed/%s/%s/\">files</a>",
211 substr($num,0,5), $num);
212 printf(" </tr></table>");
213
214 }
215 printf(" </table>");
216 printf("</td></tr><tr><td><br></td></tr>");
217
218 }
219 printf("</table>\n");
220
221 printf("</center>\n");
222 printf("</tr><tr class='Block'><td>\n");
223 }
224
225 function PrintPage($html, $db)
226 {
227 $db_id = mysql_connect("hercules.astro.uni-wuerzburg.de", "MAGIC", "d99swMT!");
228 if ($db_id==FALSE)
229 {
230 printf("mysql_connect returned the following error: %s\n", mysql_error());
231 die("");
232 }
233 mysql_select_db($db);
234
235 $query0 = CreateQuery($_GET);
236
237 $result0 = mysql_query($query0, $db_id);
238
239 if ($result0)
240 {
241 if ($html=="1" || $html=="2")
242 PrintSequenceInfo($result0, $db_id, $db);
243 else
244 PrintText($result0);
245
246 mysql_free_result($result0);
247 }
248 mysql_close($db_id);
249
250 if ($html=="1")
251 printf("<U><B>submitted query:</B></U><BR>%s<BR>", htmlspecialchars($query0));
252 }
253
254 include ("include.php");
255 include ("db.php");
256
257 ini_set("display_errors", "On");
258 ini_set("mysql.trace_mode", "On");
259
260 if (!empty($_GET["fSendTxt"]))
261 {
262 header("Content-type: application/octet");
263 header("Content-Disposition: attachment; filename=query-result.txt");
264
265 PrintPage("0", $db);
266 }
267 else
268 {
269 echo (file_get_contents("index-header.html"));
270
271 $environment = sizeof($_GET);
272
273 InitGet($_GET);
274 if (empty($_GET["fPrintTable"]))
275 PrintForm($_GET, $db);
276
277 if ($environment==0)
278 printf("No query submitted yet.<BR>");
279 else
280 {
281 if (empty($_GET["fPrintTable"]))
282 PrintPage("1", $db);
283 else
284 PrintPage("2", $db);
285 }
286
287 echo (file_get_contents("index-footer.html"));
288 }
289
290 ini_set("display_errors", "Off");
291 ini_set("mysql.trace_mode", "Off");
292}
293?>
Note: See TracBrowser for help on using the repository browser.