\n";
+
+// echo " | \n"; // first field is a label set below for the query rows only
+// ** TABLE HEADER **
+echo "
| \n";
+write_header_cell ("list", "Exp Name");
+write_header_cell ("list", "Exp ID");
+write_header_cell ("list", "Chip ID");
+write_header_cell ("list", "Cam ID");
+write_header_cell ("list", "Fake ID");
+write_header_cell ("list", "Warp ID");
+write_header_cell ("list", "image");
+write_header_cell ("list", "image");
+write_header_cell ("list", "state");
+write_header_cell ("list", "label");
+write_header_cell ("list", "data grp");
+write_header_cell ("list", "dist grp");
+write_header_cell ("list", "Telescope");
+write_header_cell ("list", "Camera");
+write_header_cell ("list", "Date/Time");
+write_header_cell ("list", "RA");
+write_header_cell ("list", "DEC");
+write_header_cell ("list", "Object");
+write_header_cell ("list", "FILTER");
+write_header_cell ("list", "exp_time ");
+write_header_cell ("list", "airmass ");
+write_header_cell ("list", "backgnd");
+write_header_cell ("list", "stdev ");
+write_header_cell ("list", "Comment");
+echo "
\n";
+echo " | \n";
+write_sort_cell ("list", "rawExp.exp_name", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "rawExp.exp_id", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "chipRun.chip_id", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "camRun.cam_id", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "fakeRun.fake_id", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "warpRun.warp_id", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+echo " | \n";
+echo " | \n";
+write_sort_cell ("list", "warpRun.state", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "warpRun.label", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "warpRun.data_group", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "warpRun.dist_group", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "rawExp.telescope", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "rawExp.camera", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "rawExp.dateobs", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "rawExp.ra * 57.295783", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "rawExp.decl * 57.295783", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "rawExp.object", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "rawExp.filter", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "rawExp.exp_time", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "rawExp.airmass", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "rawExp.bg", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "rawExp.bg_stdev", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+write_sort_cell ("list", "rawExp.comment", $buttonLink, $ID, 'warpProcessedExp_Images.php');
+echo "
\n";
+// echo "\n";
+
+// query restriction form
+// echo "\n";
+// echo "| | \n";
+// ** TABLE QUERY **
+echo "
| ≥ | \n";
+write_query_row ('rawExp.exp_name', 5, 'string');
+write_query_row ('rawExp.exp_id', 5, 'min');
+write_query_row ('chipRun.chip_id', 7, 'min');
+write_query_row ('camRun.cam_id', 7, 'min');
+write_query_row ('fakeRun.fake_id', 7, 'min');
+write_query_row ('warpRun.warp_id', 7, 'min');
+echo " | \n";
+echo " | \n";
+write_query_row ('warpRun.state', 7, 'string');
+write_query_row ('warpRun.label', 7, 'string');
+write_query_row ('warpRun.data_group', 7, 'string');
+write_query_row ('warpRun.dist_group', 7, 'string');
+write_query_row ('rawExp.telescope', 10, 'string');
+write_query_row ('rawExp.camera', 10, 'string');
+write_query_row ('rawExp.dateobs', 19, 'min');
+write_query_row ('rawExp.ra', 8, 'min');
+write_query_row ('rawExp.decl', 8, 'min');
+write_query_row ('rawExp.object', 8, 'string');
+write_query_row ('rawExp.filter', 10, 'string');
+write_query_row ('rawExp.exp_time', 5, 'min');
+write_query_row ('rawExp.airmass', 5, 'min');
+write_query_row ('rawExp.bg', 5, 'min');
+write_query_row ('rawExp.bg_stdev', 5, 'min');
+write_query_row ('rawExp.comment', 65, 'string');
+echo "
| ≤ | \n";
+echo " | \n";
+write_query_row ('rawExp.exp_id', 5, 'max');
+write_query_row ('chipRun.chip_id', 7, 'max');
+write_query_row ('camRun.cam_id', 7, 'max');
+write_query_row ('fakeRun.fake_id', 7, 'max');
+write_query_row ('warpRun.warp_id', 7, 'max');
+echo " | \n";
+echo " | \n";
+echo " | \n";
+echo " | \n";
+echo " | \n";
+echo " | \n";
+echo " | \n";
+write_query_row ('rawExp.dateobs', 19, 'max');
+write_query_row ('rawExp.ra', 8, 'max');
+write_query_row ('rawExp.decl', 8, 'max');
+echo " | \n";
+echo " | \n";
+write_query_row ('rawExp.exp_time', 5, 'max');
+write_query_row ('rawExp.airmass', 5, 'max');
+write_query_row ('rawExp.bg', 5, 'max');
+write_query_row ('rawExp.bg_stdev', 5, 'max');
+echo " | \n";
+echo "
\n";
+// echo "\n";
+
+/* $warpIdCollection[$warpId]["00"] = "ul"; */
+/* $warpIdCollection[$warpId]["01"] = "ur"; */
+/* $warpIdCollection[$warpId]["10"] = "ll"; */
+/* $warpIdCollection[$warpId]["11"] = "lr"; */
+$warpIdCollection = array();
+
+$noImageValue = "![](\"noimage.png\")
";
+
+// list the results
+while ($qry->fetchInto($row)) {
+ // $link = "warpProcessedExp_Images.php" . "?expID=" . $row[0] . "&" . $ID['link'];
+
+ $class = "list";
+ // ** TD CLASS **
+
+ //Identify current warpId
+ $warpId = $row[5];
+/* echo "| Number of elements in warpIdCollection: ".count($warpIdCollection)." |
\n"; */
+/* echo "| (warpId=$warpId) |
\n"; */
+
+ if (!isSet($warpIdCollection[$warpId])) {
+/* echo "| $warpId not in warpIdCollection |
"; */
+ $warpIdCollection[$warpId] = array();
+ $skyCellValue = preg_replace("|skycell[.]|","",$row[23]);
+ $warpIdCollection[$warpId]["11"] = $skyCellValue;
+/* echo "| Skycell is [$skyCellValue] |
"; */
+
+ echo "\n";
+ // ** TABLE DATA **
+ echo " | \n";
+ write_table_cell ($class, '%s', "", $row[0]);
+ $link = "rawImfile.php" . "?menu=ipp.science.dat&" . $ID['link'];
+ $link = $link . "&rawImfile.exp_id=$row[1]";
+ write_table_cell ($class, '%d', $link, $row[1]);
+ $link = "chipProcessedImfile.php" . "?menu=ipp.science.dat&" . $ID['link'];
+ $link = $link . "&chipRun.chip_id=$row[2]";
+ write_table_cell ($class, '%d', $link, $row[2]);
+ $link = "camProcessedExp.php" . "?menu=ipp.science.dat&" . $ID['link'];
+ $link = $link . "&camRun.cam_id=$row[3]";
+ write_table_cell ($class, '%d', $link, $row[3]);
+ $link = "fakeProcessedImfile.php" . "?menu=ipp.science.dat&" . $ID['link'];
+ $link = $link . "&fakeRun.fake_id=$row[4]";
+ write_table_cell ($class, '%d', $link, $row[4]);
+ $link = "warpStageExp.php" . "?menu=ipp.science.dat&" . $ID['link'];
+ $link = $link . "&warpRun.warp_id=$row[5]";
+ write_table_cell ($class, '%d', $link, $row[5]);
+ /* Image */
+ echo "\n";
+ echo "\n";
+ echo " | $noImageValue | \n";
+ echo " $noImageValue | \n";
+ echo " \n";
+ echo " | $noImageValue | \n";
+ echo " $noImageValue |
\n";
+ echo " | \n";
+ $link = "getimage.php" . "?menu=ipp.science.dat&" . $ID['link'];
+ $link = $link . "&name=$row[22].$row[23]";
+ $link = $link . "&rule=PPSKYCELL.JPEG1";
+ $link = $link . "&camera=GPC1";
+ $link = $link . "&class_id=NONE";
+
+ /* Image as Text */
+ echo "\n";
+ echo "\n";
+ echo " | No image | \n";
+ echo " No image | \n";
+ echo " \n";
+ echo " | No image | \n";
+ echo " No image |
\n";
+ echo " | \n";
+
+ $cellContent = " ![](\\\"getimage.php?name=$row[22].$row[23]&rule=PPSKYCELL.JPEG2&camera=$row[11]&class_id=NONE\\\")
";
+ echo "";
+ $imageNameValue = ($row[23]=="noimage" ?
+ "No image" : $row[23]);
+ echo "";
+
+ //resume with "regular" columns
+ write_table_cell ($class, '%s', "", $row[6]);
+ write_table_cell ($class, '%s', "", $row[7]);
+ write_table_cell ($class, '%s', "", $row[8]);
+ write_table_cell ($class, '%s', "", $row[9]);
+ write_table_cell ($class, '%s', "", $row[10]);
+ write_table_cell ($class, '%s', "", $row[11]);
+ write_table_cell ($class, '%T', "", $row[12]);
+ write_table_cell ($class, '%C', "", $row[13] * 57.295783);
+ write_table_cell ($class, '%C', "", $row[14] * 57.295783);
+ write_table_cell ($class, '%s', "", $row[15]);
+ write_table_cell ($class, '%s', "", $row[16]);
+ write_table_cell ($class, '%.2f', "", $row[17]);
+ write_table_cell ($class, '%.4f', "", $row[18]);
+ write_table_cell ($class, '%.2f', "", $row[19]);
+ write_table_cell ($class, '%.2f', "", $row[20]);
+ write_table_cell ($class, '%s', "", $row[21]);
+ echo "
\n";
+
+ } else {
+ // Update table cell content
+/* echo "| $warpId in warpIdCollection |
"; */
+ $lrValue = $warpIdCollection[$warpId]["11"];
+ $skyCellValue = preg_replace("|skycell[.]|","",$row[23]);
+/* echo "| Current skycell is [$skyCellValue] / LowerRight is [$lrValue] |
"; */
+
+ $link = "getimage.php" . "?menu=ipp.science.dat&" . $ID['link'];
+ $link = $link . "&name=$row[22].$row[23]";
+ $link = $link . "&rule=PPSKYCELL.JPEG1";
+ $link = $link . "&camera=GPC1";
+ $link = $link . "&class_id=NONE";
+ $cellContent = " ";
+
+ if ($skyCellValue == $lrValue + 1) {
+/* echo "| Update LowerLeft |
"; */
+ $warpIdCollection[$warpId]["10"] = $skyCellValue;
+ echo "";
+ echo "";
+ } else {
+ if (!isSet($warpIdCollection[$warpId]["01"])) {
+/* echo "| Update UpperRight |
"; */
+ $warpIdCollection[$warpId]["01"] = $skyCellValue;
+ echo "";
+ echo "";
+ } else {
+ $urValue = $warpIdCollection[$warpId]["01"];
+ $warpIdCollection[$warpId]["00"] = $skyCellValue;
+ if ($urValue + 1 != $skyCellValue) {
+ $expected = $urValue + 1;
+ $actual = $skyCellValue;
+ echo "";
+ echo "| Problem in UpperLeft! |
";
+ } else {
+/* echo "| Update UpperLeft |
"; */
+ echo "";
+ echo "";
+ }
+ }
+ }
+ }
+
+
+}
+
+// query restriction form
+// echo "\n";
+// echo "| | \n";
+// TABLE QUERY
+// echo "
\n";
+
+// close the table and form
+echo "
\n";
+echo "