| $summit_exp_link $expType | $pz_exp $downloadState | $pz_exp registering | $count";
+ } else {
+ echo "| $summit_exp_link $expType | $pz_exp $downloadState | $raw_exp $rawState | $count";
+ }
}
- if ($downloadState == NULL) {
- echo " | | $summit_exp_link $expType | loading imfiles | null | $count";
- } else {
- if ($downloadState == 'run') {
- echo "| $summit_exp_link $expType | $pz_exp copying | $pz_exp saving | $count";
- } else {
- if ($rawState == NULL) {
- echo "| $summit_exp_link $expType | $pz_exp $downloadState | $pz_exp registering | $count";
- } else {
- echo "| $summit_exp_link $expType | $pz_exp $downloadState | $raw_exp $rawState | $count";
- }
- }
- }
- }
-
+ }
+
+ // --- Query 2 ---
echo " | Last night $previousDate (UTC), $mjdDaym1 (MJD)";
$sql = "
- SELECT sum_type, pzstate, rawstate, count(*), sum_exp, pz_exp, raw_exp
- FROM
- (SELECT summitExp.exp_type as sum_type, pzDownloadExp.state as pzstate, rawExp.state as rawstate, summitExp.exp_name as sum_exp, pzDownloadExp.exp_name as pz_exp, rawExp.exp_name as raw_exp
- FROM summitExp
- LEFT JOIN pzDownloadExp USING (summit_id)
- LEFT JOIN rawExp ON summitExp.exp_name = rawExp.exp_name
- WHERE summitExp.summit_id >= (
- SELECT COALESCE(MIN(summit_id), 0)
- FROM summitExp
- WHERE exp_name LIKE '$expnamem5'
- )
- AND summitExp.exp_name LIKE '$expnamem1' ORDER BY summitExp.dateobs desc) as sub
+ SELECT sum_type, pzstate, rawstate, count(*), sum_exp, pz_exp, raw_exp
+ FROM (SELECT summitExp.exp_type as sum_type,
+ pzDownloadExp.state as pzstate,
+ rawExp.state as rawstate,
+ summitExp.exp_name as sum_exp,
+ pzDownloadExp.exp_name as pz_exp,
+ rawExp.exp_name as raw_exp
+ FROM summitExp
+ LEFT JOIN pzDownloadExp USING (summit_id)
+ LEFT JOIN rawExp ON summitExp.exp_name = rawExp.exp_name
+ WHERE summitExp.summit_id >= (
+ SELECT COALESCE(MIN(summit_id), 0)
+ FROM summitExp WHERE exp_name LIKE '$expnamem5')
+ AND summitExp.exp_name LIKE '$expnamem1'
+ ORDER BY summitExp.dateobs desc) as sub
GROUP BY sum_type, pzstate, rawstate";
if ($debug) {echo "$sql
";}
$qry = $projectdb->query($sql);
- while ($qry->fetchInto($tmp)) {
+ while ($tmp = $qry->fetch(PDO::FETCH_NUM)) {
list($expType, $downloadState, $rawState, $count, $summit_exp, $pz_exp, $raw_exp) = $tmp;
- if ($proj == "gpc1") {
- $summit_exp_link = "$summit_exp";
+ $summit_exp_link = ($proj == "gpc1")
+ ? "$summit_exp"
+ : "$summit_exp";
+
+ if ($downloadState === NULL) {
+ echo " |
|---|
| $summit_exp_link $expType | loading imfiles | null | $count";
+ } elseif ($downloadState === 'run') {
+ echo "| $summit_exp_link $expType | $pz_exp copying | $pz_exp saving | $count";
} else {
- $summit_exp_link = "$summit_exp";
+ if ($rawState === NULL) {
+ echo "| $summit_exp_link $expType | $pz_exp $downloadState | $pz_exp registering | $count";
+ } else {
+ echo "| $summit_exp_link $expType | $pz_exp $downloadState | $raw_exp $rawState | $count";
+ }
}
- if ($downloadState == NULL) {
- echo " | | $summit_exp_link $expType | loading imfiles | null | $count";
- } else {
- if ($downloadState == 'run') {
- echo "| $summit_exp_link $expType | $pz_exp copying | $pz_exp saving | $count";
- } else {
- if ($rawState == NULL) {
- echo "| $summit_exp_link $expType | $pz_exp $downloadState | $pz_exp registering | $count";
- } else {
- echo "| $summit_exp_link $expType | $pz_exp $downloadState | $raw_exp $rawState | $count";
- }
- }
- }
- }
-
+ }
+
+ // End timer
echo " | ";
- // End timer
$total_time = round(microtime(true) - $start, 3);
echo "loading in $total_time seconds
";
-
echo " |
|---|
";
echo "
";
}
-
-function formatState($state) {
- // Formats display of the state for better readability
- if (is_null($state)) {
- return "null";
- } elseif ($state == 'run') {
- return "loading";
- } else {
- return $state;
- }
-}
-###########################################################################
-#
-# Gets disk status
-#
-###########################################################################
-function getHostsold($db) {
- // timer start
- $time = microtime();
- $time = explode(' ', $time);
- $time = $time[1] + $time[0];
- $start = $time;
-
- #echo "";
- echo "";
- echo "
";
- echo " ";
- echo " ";
- echo " Free";
- echo " Used";
- echo " > 97% limit";
- echo " Down | Repair";
- echo " Power Off";
- echo " ";
- echo "
";
-}
-
-###########################################################################
-#
-# Gets disk status
-#
-###########################################################################
-function getHosts($db) {
- $start = microtime(true);
-
-
- // Set environment variables
- putenv("PATH=/usr/local/bin:/usr/bin:/bin:/data/ippc65.0/ipp/src/psconfig//ipp-20210708-gentoo.lin64/bin");
- putenv("PERL5LIB=/data/ippc65.0/ipp/src/psconfig//ipp-20210708-gentoo.lin64/lib");
-
- $hostnoteall = array();
- exec("neb-host |cut -b 17-30,86-", $hostnoteall);
-
- $sql = "SELECT host, format(total, 2), format(available, 2), format(used, 2), writable, readable, format(used/total*100,3) as ratio FROM hosts where xattr <> 3 ORDER BY CASE WHEN ROUND(used/total*100,3) = 100 THEN 0 ELSE 1 END, CASE WHEN host LIKE '%\_bck.0' THEN 1 ELSE 0 END, host;";
- $qry = $db->query($sql);
-
- if ($qry === false) {
- echo "Error with SQL query
";
- return;
- }
-
- $sqlMax = "SELECT MAX(total) AS max_total FROM hosts WHERE xattr <> 3";
- $qryMax = $db->query($sqlMax);
- $maxUsed = 0;
-
- if ($qryMax && $qryMax->fetchInto($rowMax)) {
- $maxUsed = $rowMax[0]; // max_total value
- }
-
- $dataRows = array();
- while ($qry->fetchInto($row)) {
- // Access by index
- $host = $row[0]; // ipp071.0
- $total = $row[1]; // 80.0352 TB
- $available = $row[2]; // 10.8096 TB
- $used = $row[3]; // 69.2256 TB
- $writable = $row[4]; // 0
- $readable = $row[5]; // 1
- $ratio = $row[6]; // 86.4939 %
-
- // Match notes
- $hostnotes = preg_grep("/$host/", $hostnoteall);
- $hostnote = reset($hostnotes);
-
- // Defaults
- $styles = "stroke-width: .5; stroke-color: black;";
- $status = "down";
- $usedColor = "lightgrey";
- $freeColor = "lightgrey";
-
- // Status logic
- if ($writable == 1 && $readable == 1) {
- $status = "up";
- $usedColor = ($ratio >= 97) ? "pink" : "yellow"; // red if â¥97%
- $freeColor = "#a6ec99"; // green free
- } elseif ($writable == 0 && $readable == 1) {
- $status = "repair";
- $usedColor = ($ratio >= 97) ? "pink" : "yellow";
- $freeColor = "lightgrey"; // grey free
- } elseif ($available < 1) {
- $used = $maxUsed;
- $available = 0;
- $status = "offline";
- $usedColor = "white";
- $freeColor = "white";
- }
-
- if ($status == "down") {
- $tooltipUsed = $host . ": " . round($ratio, 1) . "% of " . $total . " TB used ".
- "
" . $hostnote . "";
- $tooltipFree = "" .
- $host . ": " . $available . " TB free" .
- "";
- } elseif ($status == "offline") {
- $tooltipUsed = $host . ": " . round($ratio, 1) . "% of " . $total . " TB used ".
- "
" . $hostnote . "";
- $tooltipFree = "" .
- $host . ": " . $total . " TB free" .
- "";
- } else {
- $tooltipUsed = $host . ": " . round($ratio, 1) . "% of " . $total . " TB used
" . $hostnote;
- $tooltipFree = $host . ": " . $available . " TB free";
- }
-
- // Build data row (manual string concatenation for old PHP)
- $dataRows[] =
- "[ \"" . $host . ":" . $status . "\", " .
- $used . ", \"" . $styles . " color: " . $usedColor . ";\", \"" . $tooltipUsed . "\", " .
- $available . ", \"" . $styles . " color: " . $freeColor . ";\", \"" . $tooltipFree . "\" ]";
-
- }
- echo "";
-
-echo "
-
-
-
-
-
-
-
- Free
- Used
- 97% Usage
- Down/Repair
- Offline
-
-
-
-
-
";
-}
-
-###########################################################################
-#
-# Gets disk spaces status
-#
-###########################################################################
-function getSpaces($db) {
- // timer start
- $time = microtime();
- $time = explode(' ', $time);
- $time = $time[1] + $time[0];
- $start = $time;
-
-
- $db->query("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts where host like 'ippb%' and xattr <> 3")->fetchInto($row);
- $ippbusable = $row[0];
- $db->query("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts where host like 'ippb%' and writable = 1 and xattr <> 3")->fetchInto($row);
- $ippbfree = $row[0];
-
- $db->query("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts where host not like 'ippb%' and xattr <> 3")->fetchInto($row);
- $ippusable = $row[0];
- $db->query("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts where host not like 'ippb%' and writable = 1 and xattr <> 3")->fetchInto($row);
- $ippfree = $row[0];
-
- $db->query("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts where host like 'ipp%_bck.0' and xattr <> 3")->fetchInto($row);
- $bckusable = $row[0];
- $db->query("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts where host like 'ipp%_bck.0' and writable = 1 and xattr <> 3")->fetchInto($row);
- $bckfree = $row[0];
-
- $sql = "select format(used/total*100,1), usable from cluster_space order by timestamp desc limit 1;";
-
- if ($debug) {echo "$sql
";}
- $qry = $db->query($sql);
- if (dberror($qry)) {echo "error with $sql
\n";}
- $qry->fetchInto($row);
- $allocated = $row[0];
- $usable = $row[1];
-
- #echo "";
- echo "";
- echo "
";
- echo " ";
- echo " ";
- echo " ipp*_bck: $bckusable TB (usable) ";
- echo " ipp*_bck: $bckfree TB (free) ";
- echo " ";
- echo "
";
-}
-
-###########################################################################
-#
-# Gets data quality status
-#
-###########################################################################
-function getDataQuality($db) {
- // timer start
- $time = microtime();
- $time = explode(' ', $time);
- $time = $time[1] + $time[0];
- $start = $time;
-
- $date = gmdate("Y-m-d");
- $sql = "SELECT MAX(exp_id) FROM rawExp WHERE dateobs BETWEEN DATE_SUB('$date', INTERVAL 20 DAY) AND DATE_SUB('$date', INTERVAL 10 DAY)";
- if ($debug) {echo "$sql
";}
- $qry = $db->query($sql);
-
- if (dberror($qry)) {
- echo "*** WARNING: No data in the period 10-20 days before requested date (query will be slower) **\n";
- $refExpID = 0;
- } else {
- $qry->fetchInto($refExpID);
- $refExpID = isset($refExpID[0]) ? $refExpID[0] : 0;
- }
- // Print the result of the query
- if ($debug) {echo "The result of MAX(exp_id) is: $refExpID
";}
- {echo "The result of MAX(exp_id) is: $refExpID
";}
-
- #Query for the needed data
- $DQarray = array();
-
- $sql = "SELECT subtime(dateobs,'10:00:00') as time,iq_fwhm_major,iq_fwhm_minor,zpt_obs,zpt_stdev,rawExp.filter,rawExp.exp_time,rawExp.comment FROM rawExp JOIN chipRun using (exp_id) JOIN camRun using (chip_id) JOIN camProcessedExp using (cam_id)";
-# $sql.= " WHERE (rawExp.dateobs > utc_date() - INTERVAL 14 hour) and (rawExp.dateobs < utc_date() + INTERVAL 10 hour)";
- $sql.= " WHERE (rawExp.dateobs > utc_date())";
-# $sql.= " WHERE (rawExp.dateobs > '2024-10-24')";
-# $sql.= " AND (rawExp.dateobs < '2024-10-25')";
- $sql.= " AND exp_id > $refExpID[0]";
- $sql.= " AND exp_type = 'OBJECT' AND camRun.state like 'full' ORDER BY dateobs asc;";
- if ($debug) {echo "$sql
";}
- $qry = $db->query($sql);
- if (dberror($qry)) {echo "error with $sql
\n";}
-# echo "error with $sql
\n";
- while ($qry->fetchInto($row)) {
- $DQarray[] = $row;
- }
-
- #also find the median zeropoint
-# foreach($DQarray as $row) {
-# $zpt[] = $row[3];
-# }
-
-# sort($zpt);
-# $count = sizeof($zpt); // cache the count
-# $index = floor($count/2); // cache the index
-# $zpt_med = $zpt[$index];
-
- #echo "";
- echo "";
- echo "
";
- echo " ";
- echo " ";
- echo " ";
- echo "
";
- echo " ";
- echo " ";
- echo " ";
- echo "
";
- echo " ";
- echo " ";
- echo " ";
- echo "
";
-}
-
@@ -3269,370 +2840,4 @@
}
-
-###########################################################################
-#
-# Get data quality
-#
-###########################################################################
-function getDataQuality2($db) {
- // Start timer
- $start = microtime(true);
-
- $mjdDay = getMJD();
- $expname = "o".$mjdDay."%";
-
- $sql = "SELECT SUBTIME(dateobs, '10:00:00') AS time,
- round(( 367*YEAR(dateobs)- FLOOR((7 * (YEAR(dateobs) + FLOOR((MONTH(dateobs) + 9) / 12))) / 4) + FLOOR(275 * MONTH(dateobs) / 9)
- + DAY(dateobs) + 1721013.5 + (HOUR(dateobs) / 24.0) + (MINUTE(dateobs) / 1440.0) + (SECOND(dateobs) / 86400.0) - 2400000.5), 5) AS MJD,
- filter, comment, ra*180/pi() as RA, decl*180/pi() as DECL, exp_name, alt, az, fwhm_major, fwhm_minor, zpt_obs, zpt_stdev, rawExp.exp_id
- FROM rawExp JOIN chipRun using (exp_id) JOIN camRun using (chip_id) JOIN camProcessedExp using (cam_id)
- WHERE rawExp.exp_name like '$expname'
- AND exp_type = 'OBJECT'
- AND camRun.state like 'full'
- AND camProcessedExp.fault = 0
- AND camProcessedExp.zpt_obs != 0; ";
-
- $DQarray = array();
- $qry = $db->query($sql);
- if (dberror($qry)) {
- echo "Error with $sql
\n";
- return;
- }
-
- while ($qry->fetchInto($row)) {
- $DQarray[] = $row;
- }
-
- // Ensure $DQarray is not empty
- if (empty($DQarray)) {
- echo " No data for MJD: $mjdDay ";
- return; // Stop execution if no data to encode
- }
-
- // Convert data array to JSON for easier handling in JavaScript
- $dataJson = json_encode($DQarray);
-
- if ($dataJson === false) {
- echo "Error encoding JSON: " . json_last_error_msg(); // Display any JSON encoding errors
- return; // Stop execution if JSON encoding fails
- }
-
- echo ""; // Log JSON output to console for debugging
-
-echo <<
-
-
-
-
-
-
-
-
-
-HTML;
- // End timer
- $total_time = round(microtime(true) - $start, 3);
- echo "loading plot in $total_time seconds
";
-
-}
-
-
-
function getprocrate ($proc1, $proc0, $trange) {
if($proc1 > $proc0) {
@@ -3646,4 +2851,3 @@
-
?>
Index: /trunk/ippMonitor/raw/dataquality.php
===================================================================
--- /trunk/ippMonitor/raw/dataquality.php (revision 42971)
+++ /trunk/ippMonitor/raw/dataquality.php (revision 42972)
@@ -15,5 +15,5 @@
else {$myMenu = "ipp.czar.dat";}
-menu($myMenu, 'Czartool on '.$lastUpdateTime, 'ipp.css', $ID['link'], $ID['proj']);
+menu($myMenu, 'Czartool on', ' ipp.css', $ID['link'], $ID['proj']);
$pass = $ID['pass'];
@@ -22,5 +22,7 @@
// Fetch data based on range selection
-$range = isset($_GET['range']) ? $_GET['range'] : 'yday';
+$range = isset($_GET['range']) ? $_GET['range'] : 'week';
+
+require_once 'functions.php';
echo "";
@@ -28,495 +30,49 @@
echo " ";
echo " Data Quality Report";
-echo " ";
-echo ' Last night (default) | ';
-echo ' Today (MJD '.getMJD().') | ';
-echo ' Past 7 days | ';
-echo ' Past 30 days | ';
-echo ' Past 365 days | ';
-echo ' All ';
+
+#
+# project selector
+echo '';
+# Project selector with highlight
+$projects = ["gpc1" => "GPC1", "gpc2" => "GPC2"];
+foreach ($projects as $key => $label) {
+ if ($proj == $key) {
+ echo "$label | ";
+ } else {
+ echo '' . $label . ' | ';
+ }
+}
+echo "
";
+
+# range links with highlighting
+$ranges = [
+ "today" => "Today",
+ "yesterday" => "Yesterday",
+ "week" => "Week",
+ "month" => "Month",
+ "year" => "Year",
+ "all" => "All"
+];
+
+foreach ($ranges as $key => $label) {
+ if ($range == $key) {
+ echo "$label | ";
+ } else {
+ echo '' . $label . ' | ';
+ }
+}
+
echo " | ";
echo "";
echo " ";
-echo getDataQuality($projectdb, $range);
+
+echo " ";
+echo " Current MJD: " . getMJD();
+echo " ";
+
+echo getDataQuality($projectdb, $range, $proj);
menu_end();
-/////////////////////////////////////////////////////////////////////////////
-// //
-// Functions //
-// //
-/////////////////////////////////////////////////////////////////////////////
-
-###########################################################################
-#
-# Get data quality
-#
-###########################################################################
-function getDataQuality($db, $range = 'yday') {
- // Start timer
- $start = microtime(true);
-
- $mjdDay = getMJD();
- $mjdDay_yearback = $mjdDay - 366;
- $mjdDay_monthback = $mjdDay - 32;
- $min_exp_id = 0;
-
- // Determine the reference exp_name based on the selected range
- switch ($range) {
- case 'year':
- $expname = "o" . $mjdDay_yearback . "%";
- break;
- case 'month':
- $expname = "o" . $mjdDay_monthback . "%";
- break;
- case 'week':
- $expname = "o" . ($mjdDay - 7) . "%";
- break;
- case 'day':
- $expname = "o" . $mjdDay . "%";
- break;
- default:
- $expname = "o" . ($mjdDay - 1) . "%"; // Default: last night
- break;
- }
-
- // Query to get the minimum exp_id
- $expIdQuery = "SELECT MIN(exp_id) AS min_exp_id FROM rawExp WHERE rawExp.exp_name LIKE '$expname'";
- $result = $db->query($expIdQuery);
-
- if (DB::isError($result)) {
- die("Database error: " . $result->getMessage());
- }
-
- $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
-
- if (!empty($row['min_exp_id'])) {
- $min_exp_id = $row['min_exp_id'];
- // echo "Minimum exp_id: " . $min_exp_id;
- } else {
- echo "No results found.";
- }
-
- //echo "
";
-
- // Determine the date constraint based on the range
- switch ($range) {
- case 'year':
- $dateConstraint = "dateobs >= NOW() - INTERVAL 365 DAY AND rawExp.exp_id >= $min_exp_id";
- break;
- case 'month':
- $dateConstraint = "dateobs >= NOW() - INTERVAL 30 DAY AND rawExp.exp_id >= $min_exp_id";
- break;
- case 'week':
- $expnames = array();
- for ($i = 0; $i < 7; $i++) {
- $expnames[] = "rawExp.exp_name LIKE 'o" . ($mjdDay - $i) . "%'";
- }
- $dateConstraint = "(" . implode(" OR ", $expnames) . ") AND rawExp.exp_id >= $min_exp_id";
- break;
- case 'yday':
- $dateConstraint = "rawExp.exp_name LIKE 'o" . ($mjdDay - 1) . "%' AND rawExp.exp_id >= $min_exp_id";
- break;
- case 'day':
- $dateConstraint = "rawExp.exp_name LIKE 'o$mjdDay%' AND rawExp.exp_id >= $min_exp_id";
- break;
- case 'all':
- $dateConstraint = "rawExp.exp_id >= 0";
- break;
- default: // Default to last night
- $dateConstraint = "rawExp.exp_name LIKE 'o" . ($mjdDay - 1) . "%' AND rawExp.exp_id >= $min_exp_id";
- break;
- }
-
- // Updated SQL query
- $sql = "select * from (SELECT SUBTIME(dateobs, '10:00:00') AS time,
- round(( 367*YEAR(dateobs)- FLOOR((7 * (YEAR(dateobs) + FLOOR((MONTH(dateobs) + 9) / 12))) / 4) + FLOOR(275 * MONTH(dateobs) / 9)
- + DAY(dateobs) + 1721013.5 + (HOUR(dateobs) / 24.0) + (MINUTE(dateobs) / 1440.0) + (SECOND(dateobs) / 86400.0) - 2400000.5), 5) AS MJD,
- filter, comment, ra*180/pi() as RA, decl*180/pi() as DECL, exp_name, alt, az, fwhm_major, fwhm_minor, zpt_obs, zpt_stdev, rawExp.exp_id, camRun.label
- FROM rawExp
- JOIN chipRun USING (exp_id)
- JOIN camRun USING (chip_id)
- JOIN camProcessedExp USING (cam_id)
- WHERE $dateConstraint
- AND exp_type = 'OBJECT'
- AND camRun.state LIKE 'full'
- AND camProcessedExp.fault = 0
- AND camProcessedExp.zpt_obs != 0 ORDER BY RAND() limit 5000) as sub order by time;";
-
- $DQarray = array();
- $qry = $db->query($sql);
- if (dberror($qry)) {
- echo "Error with $sql
\n";
- return;
- }
- // echo "$sql
\n";
-
- while ($qry->fetchInto($row)) {
- $DQarray[] = $row;
- }
-
- // Ensure $DQarray is not empty
- if (empty($DQarray)) {
- echo " No data for MJD: $mjdDay ";
- return; // Stop execution if no data to encode
- }
-
- // Convert data array to JSON for easier handling in JavaScript
- $dataJson = json_encode($DQarray);
-
- if ($dataJson === false) {
- echo "Error encoding JSON: " . json_last_error_msg(); // Display any JSON encoding errors
- return; // Stop execution if JSON encoding fails
- }
-
- echo ""; // Log JSON output to console for debugging
-echo <<
-
-
-
-
-
-
-
-
-
-
-
-HTML;
- // End timer
- $total_time = round(microtime(true) - $start, 3);
- echo "loading plot in $total_time seconds
";
-
-}
-
-
-
?>
Index: /trunk/ippMonitor/raw/functions.php
===================================================================
--- /trunk/ippMonitor/raw/functions.php (revision 42972)
+++ /trunk/ippMonitor/raw/functions.php (revision 42972)
@@ -0,0 +1,1529 @@
+
+";
+
+###########################################################################
+#
+# Gets disk status
+#
+###########################################################################
+function getHosts($db) {
+ $start = microtime(true);
+ // Set environment variables
+ include_once __DIR__ . '/site.php';
+
+ global $PERLLIB, $BINDIR;
+
+ putenv("PERL5LIB=$PERLLIB");
+ putenv("PATH=$BINDIR:" . getenv('PATH'));
+
+ // Run external command
+ $hostnoteall = [];
+ exec('neb-host | cut -b 17-30,86-', $hostnoteall);
+
+ $sql = "SELECT host, format(total, 2), format(available, 2), format(used, 2), writable, readable,
+ FORMAT(
+ CASE
+ WHEN total = 0 THEN 100
+ ELSE used / total * 100
+ END, 3
+ ) AS ratio
+ FROM hosts where xattr <> 3
+ ORDER BY CASE WHEN ratio = 100 THEN 0 ELSE 1 END, host;";
+
+ $qry = $db->query($sql);
+
+ if ($qry === false) {
+ $err = $db->errorInfo();
+ echo "Error with SQL query: " . htmlspecialchars($err[2]) . "
";
+ return;
+ }
+
+ $sqlMax = "SELECT MAX(total) AS max_total FROM hosts WHERE xattr <> 3";
+ $qryMax = $db->query($sqlMax);
+ $maxUsed = 0;
+
+ if ($qryMax) {
+ // single value
+ $maxUsed = $qryMax->fetchColumn(); // returns MAX(total)
+ }
+
+
+ $dataRows = [];
+ while ($row = $qry->fetch(PDO::FETCH_NUM)) {
+
+ // Access by index
+ $host = $row[0]; // ipp071.0
+ $total = $row[1]; // 80.0352 TB
+ $available = $row[2]; // 10.8096 TB
+ $used = $row[3]; // 69.2256 TB
+ $writable = $row[4]; // 0
+ $readable = $row[5]; // 1
+ $ratio = $row[6]; // 86.4939 %
+
+ // Match notes
+ $hostnotes = preg_grep("/$host/", $hostnoteall);
+ $hostnote = reset($hostnotes);
+
+ // Defaults
+ $styles = "stroke-width: .5; stroke-color: black;";
+ $status = "down";
+ $usedColor = "lightgrey";
+ $freeColor = "lightgrey";
+
+ // Status logic
+ if ($writable == 1 && $readable == 1) {
+ $status = "up";
+ $usedColor = ($ratio >= 97) ? "pink" : "yellow"; // red if â¥97%
+ $freeColor = "#a6ec99"; // green free
+ } elseif ($writable == 0 && $readable == 1) {
+ $status = "repair";
+ $usedColor = ($ratio >= 97) ? "pink" : "yellow";
+ $freeColor = "lightgrey"; // grey free
+ } elseif ($available < 1) {
+ $used = $maxUsed;
+ $available = 0;
+ $status = "offline";
+ $usedColor = "white";
+ $freeColor = "white";
+ }
+
+ $fontSize = "18px";
+
+ if ($status == "down") {
+ $tooltipUsed = "" . $host . ": " . round($ratio, 1) . "% of " . $total . " TB used " .
+ "
" . $hostnote . "";
+ $tooltipFree = "" .
+ $host . ": " . $available . " TB free" . "";
+ } elseif ($status == "offline") {
+ $tooltipUsed = "" . $host . ": " . round($ratio, 1) . "% of " . $total . " TB used " .
+ "
" . $hostnote . "";
+ $tooltipFree = "" .
+ $host . ": " . $total . " TB free" . "";
+ } else {
+ $tooltipUsed = "" .
+ $host . ": " . round($ratio, 1) . "% of " . $total . " TB used
" . $hostnote . "";
+ $tooltipFree = "" .
+ $host . ": " . $available . " TB free" . "";
+ }
+
+ // Build data row (manual string concatenation for old PHP)
+ $dataRows[] =
+ "[ \"" . $host . ":" . $status . "\", " .
+ $used . ", \"" . $styles . " color: " . $usedColor . ";\", \"" . $tooltipUsed . "\", " .
+ $available . ", \"" . $styles . " color: " . $freeColor . ";\", \"" . $tooltipFree . "\" ]";
+
+ }
+ echo "";
+
+ echo "
+
+
+
+ Free
+ Used
+ 97% Usage
+ Down/Repair
+ Offline
+
+
+
";
+}
+
+
+###########################################################################
+#
+# Gets disk spaces status
+#
+###########################################################################
+function getSpaces(PDO $db, bool $debug = false) {
+ $start = microtime(true);
+
+ // helper for single-value queries
+ $getValue = function($sql) use ($db, $debug) {
+ if ($debug) echo htmlspecialchars($sql) . "
\n";
+ $stmt = $db->query($sql);
+ if (!$stmt) {
+ $err = $db->errorInfo();
+ echo "Error with $sql: " . $err[2] . "
\n";
+ return 0;
+ }
+ return $stmt->fetchColumn();
+ };
+
+ // compute values
+ $ippbusable = $getValue("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts WHERE host LIKE 'ippb%' AND xattr <> 3");
+ $ippbfree = $getValue("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts WHERE host LIKE 'ippb%' AND writable = 1 AND xattr <> 3");
+ $ippusable = $getValue("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts WHERE host NOT LIKE 'ippb%' AND xattr <> 3");
+ $ippfree = $getValue("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts WHERE host NOT LIKE 'ippb%' AND writable = 1 AND xattr <> 3");
+ $bckusable = $getValue("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts WHERE host LIKE 'ipp%_bck.0' AND xattr <> 3");
+ $bckfree = $getValue("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts WHERE host LIKE 'ipp%_bck.0' AND writable = 1 AND xattr <> 3");
+
+ // get cluster space top row
+ $sql = "SELECT FORMAT(used/total*100,1), usable FROM cluster_space ORDER BY timestamp DESC LIMIT 1";
+ if ($debug) echo htmlspecialchars($sql) . "
\n";
+ $stmt = $db->query($sql);
+ [$allocated, $usable] = $stmt->fetch(PDO::FETCH_NUM);
+
+ // fetch cluster_space rows for chart
+ $interval = 10;
+ $sql = "SELECT sub.dated, sub.usable, sub.available
+ FROM (
+ SELECT DATE_FORMAT(timestamp, \"%Y.%m.%d.%H.%i\") AS dated, usable, available
+ FROM cluster_space
+ WHERE timestamp > CURDATE() - INTERVAL $interval DAY
+ ) AS sub
+ GROUP BY dated";
+ if ($debug) echo htmlspecialchars($sql) . "
\n";
+ $stmt = $db->query($sql);
+
+ $rowsJs = '';
+ while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
+ $tsp = explode('.', $row[0]);
+ $mon = $tsp[1] - 1;
+ $rowsJs .= "[new Date($tsp[0], $mon, $tsp[2], $tsp[3], $tsp[4]), {$row[1]}, {$row[2]}],";
+ }
+
+ // build HTML + JS all at once
+ $output = <<
+ google.charts.setOnLoadCallback(drawChart);
+ function drawChart() {
+ var data = new google.visualization.DataTable();
+ data.addColumn('datetime', 'Day');
+ data.addColumn('number', 'Usable (ipp:$ippusable, ippb:$ippbusable) TB');
+ data.addColumn('number', 'Free (ipp:$ippfree, ippb:$ippbfree) TB');
+ data.addRows([
+ $rowsJs
+ ]);
+
+ var options = {
+ title: 'Total Available Cluster Space in the Past $interval Days ($allocated% of total allocated)',
+ height: 400,
+ legend: { position: 'top', alignment: 'center'},
+ lineWidth: 2,
+ series: {0:{color:'#0000ff',lineWidth:3},1:{color:'#33a532',lineWidth:3}},
+ hAxis: { title:'Date/Time (HST)', format:'MMM dd'},
+ vAxis: { title:'Available (TB)', viewWindow:{min:500}},
+ chartArea:{left:80,top:50,right:20,bottom:50},
+ fontSize:13
+ };
+ var chart = new google.visualization.LineChart(document.getElementById('space_div'));
+ chart.draw(data, options);
+ }
+
+
+
+
+
+ ipp*_bck: $bckusable TB (usable)
+ ipp*_bck: $bckfree TB (free)
+
+
";
+}
+
+// Global helper function (loaded once)
+echo <<
+function buildTooltip(row) {
+ return `
+ expname : \${row.exp_name}
+ exp_id : \${row.exp_id}
+ dateobs : \${row.time} (HST)
+ (RA, Dec) : \${row.RA}, \${row.DECL} (deg)
+ filter : \${row.filter}
+ airmass : \${row.airmass}
+ (RA_off, scat) : \${row.AST_R0}, \${row.AST_RS} (TP)
+ (DEC_off, scat): \${row.AST_D0}, \${row.AST_DS} (TP)
+ zp, stdev : \${row.zpt_obs}, \${row.zpt_stdev}
+ pa, alt, az : \${row.posang}, \${row.alt}, \${row.az}
+ exp_time : \${row.exp_time}(s)
+ cam_label : \${row.label}
+ cam_id : \${row.cam_id}
+ moon_angle : \${row.moon_angle}
+ raw_chips : \${row.n_raw}
+ good_chips : \${row.g_chips}
+ comment : \${row.comment}
+ `;
+}
+
+HTML;
+
+
+###########################################################################
+#
+# Get pointing
+#
+###########################################################################
+function getPointing($db, $range = 'week', $proj) {
+ // Start timer
+ $start = microtime(true);
+
+ // testing day
+ //$mjdDay = 60945;
+ $mjdDay = getMJD();
+ $mjdDay_yearback = $mjdDay - 366;
+ $mjdDay_monthback = $mjdDay - 32;
+ $min_exp_id = 0;
+
+
+ // Determine the reference exp_name based on the selected range
+ switch ($range) {
+ case 'year':
+ $expname = "o" . $mjdDay_yearback . "%";
+ break;
+ case 'month':
+ $expname = "o" . $mjdDay_monthback . "%";
+ break;
+ case 'week':
+ $expname = "o" . ($mjdDay - 7) . "%";
+ break;
+ case 'today':
+ $expname = "o" . $mjdDay . "%";
+ break;
+ case 'yesterday':
+ $expname = "o" . ($mjdDay - 1) . "%";
+ break;
+ default:
+ $expname = "o" . ($mjdDay - 7) . "%"; // Default: week
+ break;
+ }
+
+ // --- PDO query for min_exp_id ---
+ $stmt = $db->prepare("SELECT MIN(exp_id) AS min_exp_id FROM rawExp WHERE exp_name LIKE :expname");
+ $stmt->execute([':expname' => $expname]);
+ $row = $stmt->fetch(PDO::FETCH_ASSOC);
+// if (!empty($row['min_exp_id'])) {
+// $min_exp_id = $row['min_exp_id'];
+// } else {
+// echo "No results found for min_exp_id";
+// }
+
+ if (!empty($row['min_exp_id'])) {
+ $min_exp_id = $row['min_exp_id'];
+ echo "min_exp_id:$min_exp_id $mjdDay_monthback $mjdDay";
+ } else {
+ echo "No results found for min_exp_id:$min_exp_id $mjdDay_monthback $mjdDay";
+ }
+
+ //echo "
";
+
+ // Determine the date constraint based on the range
+ switch ($range) {
+ case 'year':
+ $dateConstraint = "dateobs >= NOW() - INTERVAL 365 DAY AND rawExp.exp_id >= $min_exp_id";
+ break;
+ case 'month':
+ $dateConstraint = "dateobs >= NOW() - INTERVAL 30 DAY AND rawExp.exp_id >= $min_exp_id";
+ break;
+ case 'week':
+ $expnames = array();
+ for ($i = 0; $i < 7; $i++) {
+ $expnames[] = "rawExp.exp_name LIKE 'o" . ($mjdDay - $i) . "%'";
+ }
+ $dateConstraint = "(" . implode(" OR ", $expnames) . ") AND rawExp.exp_id >= $min_exp_id";
+ break;
+ case 'yesterday':
+ $dateConstraint = "rawExp.exp_name LIKE 'o" . ($mjdDay - 1) . "%' AND rawExp.exp_id >= $min_exp_id";
+ break;
+ case 'today':
+ $dateConstraint = "rawExp.exp_name LIKE 'o$mjdDay%' AND rawExp.exp_id >= $min_exp_id";
+ break;
+ case 'all':
+ $dateConstraint = "rawExp.exp_id >= 0";
+ break;
+ default: // Default to last night
+ $dateConstraint = "rawExp.exp_name LIKE 'o" . ($mjdDay - 1) . "%' AND rawExp.exp_id >= $min_exp_id";
+ break;
+ }
+
+ // Updated SQL query
+ $sql = "select * from (SELECT SUBTIME(dateobs, '10:00:00') AS time, AST_R0, AST_D0, AST_RS, AST_DS, AST_T0, posang,
+ round(( 367*YEAR(dateobs)- FLOOR((7 * (YEAR(dateobs) + FLOOR((MONTH(dateobs) + 9) / 12))) / 4) + FLOOR(275 * MONTH(dateobs) / 9)
+ + DAY(dateobs) + 1721013.5 + (HOUR(dateobs) / 24.0) + (MINUTE(dateobs) / 1440.0) + (SECOND(dateobs) / 86400.0) - 2400000.5), 5) AS MJD,
+ filter, comment, round(ra*180/pi(), 5) as RA, round(decl*180/pi(), 5) as DECL, exp_name, alt,
+ az, fwhm_major, fwhm_minor, zpt_obs, zpt_stdev, airmass, exp_time,
+ rawExp.exp_id, camRun.label, moon_angle, cam_id, BIT_COUNT(astrom_chips) AS working_chips
+ FROM rawExp
+ JOIN chipRun USING (exp_id)
+ JOIN camRun USING (chip_id)
+ JOIN camProcessedExp USING (cam_id)
+ WHERE $dateConstraint
+ AND exp_type = 'OBJECT'
+ AND camRun.state LIKE 'full'
+ AND camProcessedExp.fault = 0
+ AND camProcessedExp.zpt_obs != 0 ORDER BY RAND() limit 10000) as sub order by time;";
+
+ $stmt = $db->query($sql);
+ $DQarray = $stmt->fetchAll(PDO::FETCH_ASSOC);
+
+ // Ensure $DQarray is not empty
+ if (empty($DQarray)) {
+ echo " No data for MJD: $mjdDay ";
+ return; // Stop execution if no data to encode
+ }
+
+ // Convert data array to JSON for easier handling in JavaScript
+ $dataJson = json_encode($DQarray);
+
+ if ($dataJson === false) {
+ echo "Error encoding JSON: " . json_last_error_msg(); // Display any JSON encoding errors
+ return; // Stop execution if JSON encoding fails
+ }
+
+ echo ""; // Log JSON output to console for debugging
+
+
+ echo <<
+ // Use the encoded JSON directly in JavaScript
+ const dataArray = JSON.parse('{$dataJson}'); // Directly parse the PHP JSON string
+
+ const nRows = dataArray.length;
+
+ // draw pointing vs mjd
+ function drawMJDChart() {
+ var data = new google.visualization.DataTable();
+ data.addColumn('number', 'MJD');
+ data.addColumn('number', 'RA_offset (AST_R0)');
+ data.addColumn({type: 'string', role: 'tooltip', 'p': {'html': true}});
+ data.addColumn({type: 'number', role: 'interval'});
+ data.addColumn({type: 'number', role: 'interval'});
+ data.addColumn('number', 'Dec_offset (AST_D0)');
+ data.addColumn({type: 'string', role: 'tooltip', 'p': {'html': true}});
+ data.addColumn({type: 'number', role: 'interval'});
+ data.addColumn({type: 'number', role: 'interval'});
+ data.addColumn('number', '20 TP unit ~5.1"');
+ data.addColumn('number', '-20 TP unit ~5.1"');
+
+ const mjdValues = dataArray.map(r => parseFloat(r.MJD));
+ let mjdMin0 = Math.min(...mjdValues);
+ const mjdMin = Math.floor(mjdMin0 * 10) / 10; // 1 decimal place or floor/ceil depending on your needs
+ let mjdMax0 = Math.max(...mjdValues);
+ const mjdMax = Math.ceil(mjdMax0 * 10) / 10; // 1 decimal place or floor/ceil depending on your needs
+ // Extract the first MJD value from dataArray
+ const firstMJD = dataArray.length > 0 ? Math.floor(parseFloat(dataArray[0].MJD)) : "N/A";
+ console.log("First MJD Value:", firstMJD);
+ const mjdoff = mjdMin;
+
+ const mjdVals = [];
+ const rows = dataArray.map(row => {
+ const mjd = parseFloat(row.MJD) - mjdoff; // MJD shift to first one
+ mjdVals.push(mjd); // collect MJD offset values
+ const ra_off = parseFloat(row.AST_R0); // RA_offset (AST_R0)
+ const dec_off = parseFloat(row.AST_D0); // DEC_offset (AST_D0)
+ const ra_sct = parseFloat(row.AST_RS); // RA_scatter (AST_RS)
+ const dec_sct = parseFloat(row.AST_DS); // DEC_scatter (AST_DS)
+ const tooltip = buildTooltip(row); // Tooltip
+
+ return [
+ mjd, ra_off, tooltip, ra_off-ra_sct, ra_off+ra_sct, dec_off, tooltip, dec_off-dec_sct, dec_off+dec_sct,
+ 20, // Dummy value for 20 TP unit
+ -20 // Dummy value for -20 TP unit
+ ];
+ });
+
+ data.addRows(rows);
+
+ // After building rows:
+ const allVerticalVals = rows.flatMap(r => [
+ r[3], // ra_off - ra_sct
+ r[4], // ra_off + ra_sct
+ r[7], // dec_off - dec_sct
+ r[8] // dec_off + dec_sct
+ ]).filter(v => !isNaN(v)); // â
+ remove NaN values
+
+ // If array is empty after filtering, use safe defaults
+ const minY = allVerticalVals.length ? Math.min(...allVerticalVals) : 0;
+ const maxY = allVerticalVals.length ? Math.max(...allVerticalVals) : 0;
+
+ // Clamp values: use ±100 if beyond 100
+ const yMin = Math.abs(minY) > 150 ? -150 : minY;
+ const yMax = Math.abs(maxY) > 150 ? 150 : maxY;
+
+ console.log("minY:", minY, yMin, "maxY:", maxY, yMax);
+
+ // Now compute min and max
+ const mjdMin1 = Math.min(...mjdVals);
+ const mjdMax1 = Math.max(...mjdVals);
+
+ const defaultSeries = { pointSize: 5, lineWidth: 0 };
+
+ const titleText = `Pointing Offset vs. MJD ({$proj}) â \${nRows} rows\${dataArray.length >= 10000 ? " (sampled)" : ""}`;
+ const options = {
+ //title: 'Pointing Offset vs. MJD ({$proj})',
+ title: titleText,
+ titleTextStyle: {color: 'black', fontSize: 15},
+ width: '100%',
+ height: 480,
+ legend: { position: 'top', alignment: 'center' },
+ series: {
+ 0: { color: '#0000ff', pointSize: 3, lineWidth: 0 }, // RA_offset series
+ 1: { color: '#33a532', pointSize: 3, lineWidth: 0 }, // Dec_offset series
+ 2: { color: 'red', lineWidth: 2, lineDashStyle: [8, 4], pointSize: 0 }, // Line at y = 20
+ 3: { color: 'red', lineWidth: 2, lineDashStyle: [8, 4], pointSize: 0 } // Line at y = -20
+ },
+ intervals: { lineWidth: .5, style: 'sticks' },
+ interval: {
+ 0: {color: 'blue'}, // interval columns attached to first series
+ 1: {color: 'green'} // interval columns attached to second series
+ },
+ hAxis: {
+ title: 'MJD - ' + mjdoff + ' (day)',
+ viewWindow: {
+ min: 0., // small padding
+ max: mjdMax1 + 0.005
+ },
+ gridlines: { count: -1 } // auto gridlines
+ },
+ vAxis: {
+ title: 'Pointing Offset (TP units)',
+ viewWindow: {
+ min: yMin,
+ max: yMax
+ }
+ },
+ tooltip: { isHtml: true }, // Render tooltips as HTML
+ chartArea: {left: '7%', top: 60, right: '4%', bottom: 50}, // Adjust left and right
+ fontSize: 15,
+ };
+
+ const chart = new google.visualization.ScatterChart(document.getElementById('dq_div_mjd'));
+ chart.draw(data, options);
+ }
+
+ // position angle
+ function drawPOSChart() {
+ var data = new google.visualization.DataTable();
+ data.addColumn('number', 'Posang');
+ data.addColumn('number', 'RA_offset (AST_R0)');
+ data.addColumn({'type': 'string', 'role': 'tooltip', 'p': {'html': true}});
+ data.addColumn('number', 'Dec_offset (AST_D0)');
+ data.addColumn({'type': 'string', 'role': 'tooltip', 'p': {'html': true}});
+
+ const rows = dataArray.map(row => {
+ const posang = parseFloat(row.posang); // Position Angle
+ const ra_off = parseFloat(row.AST_R0); // RA_offset (AST_R0)
+ const dec_off = parseFloat(row.AST_D0); // DEC_offset (AST_D0)
+ const tooltip = buildTooltip(row); // Tooltip
+ return [
+ posang, ra_off, tooltip, dec_off, tooltip
+ ];
+ });
+
+ data.addRows(rows);
+
+ const titleText = `Pointing Offset vs. Position Angle ({$proj}) â \${nRows} rows\${dataArray.length >= 10000 ? " (sampled)" : ""}`;
+ const options = {
+ title: titleText,
+ titleTextStyle: {color: 'black', fontSize: 15},
+ width: '100%',
+ height: 480,
+ legend: { position: 'top', alignment: 'center' },
+ // pointSize: 5, // Point size for scatter plot
+ // lineWidth: 2,
+ series: {
+ 0: { color: '#0000ff', pointSize: 3, lineWidth: 0 }, // RA_offset series
+ 1: { color: '#33a532', pointSize: 3, lineWidth: 0 }, // Dec_offset series
+ },
+ intervals: { color: 'red', lineWidth: 2, style: 'sticks' },
+ hAxis: {
+ title: 'Position Angle (deg)',
+ gridlines: {count: -1}
+ },
+ vAxis: {
+ title: 'Pointing Offset (TP units)',
+ },
+ tooltip: { isHtml: true }, // Render tooltips as HTML
+ chartArea: {left: '7%', top: 60, right: '4%', bottom: 50}, // Adjust left and right
+ fontSize: 15,
+ };
+
+ const chart = new google.visualization.ScatterChart(document.getElementById('dq_div_pos'));
+ chart.draw(data, options);
+ }
+
+ function drawALTChart() {
+ var data = new google.visualization.DataTable();
+ data.addColumn('number', 'Altitute');
+ data.addColumn('number', 'RA_offset (AST_R0)');
+ data.addColumn({'type': 'string', 'role': 'tooltip', 'p': {'html': true}});
+ data.addColumn('number', 'Dec_offset (AST_D0)');
+ data.addColumn({'type': 'string', 'role': 'tooltip', 'p': {'html': true}});
+
+ const rows = dataArray.map(row => {
+ const alt = parseFloat(row.alt); // Altitude
+ const ra_off = parseFloat(row.AST_R0); // RA_offset (AST_R0)
+ const dec_off = parseFloat(row.AST_D0); // DEC_offset (AST_D0)
+ const tooltip = buildTooltip(row); // Tooltip
+ return [
+ alt, ra_off, tooltip, dec_off, tooltip
+ ];
+ });
+
+ data.addRows(rows);
+
+ const titleText = `Pointing Offset vs. Altitude ({$proj}) â \${nRows} rows\${dataArray.length >= 10000 ? " (sampled)" : ""}`;
+ const options = {
+ title: titleText,
+ titleTextStyle: {color: 'black', fontSize: 15},
+ width: '100%',
+ height: 480,
+ legend: { position: 'top', alignment: 'center' },
+ series: {
+ 0: { color: '#0000ff', pointSize: 3, lineWidth: 0 }, // RA_offset series
+ 1: { color: '#33a532', pointSize: 3, lineWidth: 0 }, // Dec_offset series
+ },
+ intervals: { color: 'red', lineWidth: 2, style: 'sticks' },
+ hAxis: {
+ title: 'Altitude (deg)',
+ gridlines: {count: -1}
+ },
+ vAxis: {
+ title: 'Pointing Offset (TP units)',
+ },
+ tooltip: { isHtml: true }, // Render tooltips as HTML
+ //chartArea: {left: 80, top: 50, right: 20, bottom: 50},
+ chartArea: {left: '7%', top: 60, right: '4%', bottom: 50}, // Adjust left and right
+ fontSize: 15,
+ };
+
+ const chart = new google.visualization.ScatterChart(document.getElementById('dq_div_alt'));
+ chart.draw(data, options);
+ }
+
+ function drawAZChart() {
+ var data = new google.visualization.DataTable();
+ data.addColumn('number', 'Azumith');
+ data.addColumn('number', 'RA_offset (AST_R0)');
+ data.addColumn({'type': 'string', 'role': 'tooltip', 'p': {'html': true}});
+ data.addColumn('number', 'Dec_offset (AST_D0)');
+ data.addColumn({'type': 'string', 'role': 'tooltip', 'p': {'html': true}});
+
+ const rows = dataArray.map(row => {
+ const az = parseFloat(row.az); // Azumith
+ const ra_off = parseFloat(row.AST_R0); // RA_offset (AST_R0)
+ const dec_off = parseFloat(row.AST_D0); // DEC_offset (AST_D0)
+ const tooltip = buildTooltip(row); // Tooltip
+ return [
+ az, ra_off, tooltip, dec_off, tooltip
+ ];
+ });
+
+ data.addRows(rows);
+
+ const titleText = `Pointing Offset vs. Azumith ({$proj}) â \${nRows} rows\${dataArray.length >= 10000 ? " (sampled)" : ""}`;
+ const options = {
+ title: titleText,
+ titleTextStyle: {color: 'black', fontSize: 15},
+ width: '100%',
+ height: 480,
+ legend: { position: 'top', alignment: 'center' },
+ series: {
+ 0: { color: '#0000ff', pointSize: 3, lineWidth: 0 }, // RA_offset series
+ 1: { color: '#33a532', pointSize: 3, lineWidth: 0 }, // Dec_offset series
+ },
+ intervals: { color: 'red', lineWidth: 2, style: 'sticks' },
+ hAxis: {
+ title: 'Azumith (deg)',
+ gridlines: {count: -1}
+ },
+ vAxis: {
+ title: 'Pointing Offset (TP units)',
+ },
+ tooltip: { isHtml: true }, // Render tooltips as HTML
+ //chartArea: {left: 80, top: 50, right: 20, bottom: 50},
+ chartArea: {left: '7%', top: 60, right: '4%', bottom: 50}, // Adjust left and right
+ fontSize: 15,
+ };
+
+ const chart = new google.visualization.ScatterChart(document.getElementById('dq_div_az'));
+ chart.draw(data, options);
+ }
+
+
+ function drawScatChart() {
+ var data = new google.visualization.DataTable();
+ data.addColumn('number', 'tmp');
+ data.addColumn('number', 'RA_scat (AST_RS)');
+ data.addColumn({'type': 'string', 'role': 'tooltip', 'p': {'html': true}});
+ data.addColumn('number', 'Dec_scat (AST_DS)');
+ data.addColumn({'type': 'string', 'role': 'tooltip', 'p': {'html': true}});
+
+ const rows = dataArray.map(row => {
+ const par = parseFloat(row.MJD);
+ const ra_scat = parseFloat(row.AST_RS); // RA_scat (AST_RS)
+ const dec_scat = parseFloat(row.AST_DS); // DEC_scat (AST_DS)
+ const tooltip = buildTooltip(row); // Tooltip
+ return [
+ par, ra_scat, tooltip, dec_scat, tooltip
+ ];
+ });
+
+ data.addRows(rows);
+
+ const titleText = `Pointing Offset vs. MJD ({$proj}) â \${nRows} rows\${dataArray.length >= 10000 ? " (sampled)" : ""}`;
+ const options = {
+ title: titleText,
+ titleTextStyle: {color: 'black', fontSize: 15},
+ width: '100%',
+ height: 480,
+ legend: { position: 'top', alignment: 'center' },
+ series: {
+ 0: { color: '#0000ff', pointSize: 3, lineWidth: 0 }, // RA_offset series
+ 1: { color: '#33a532', pointSize: 3, lineWidth: 0 }, // Dec_offset series
+ },
+ intervals: { color: 'red', lineWidth: 2, style: 'sticks' },
+ hAxis: {
+ title: 'MJD',
+ gridlines: {count: -1}
+ },
+ vAxis: {
+ title: 'Pointing Scatter (TP units)',
+ viewWindow: {
+ min: 0,
+ // max: 20
+ }
+ },
+ tooltip: { isHtml: true }, // Render tooltips as HTML
+ //chartArea: {left: 80, top: 50, right: 20, bottom: 50},
+ chartArea: {left: '7%', top: 60, right: '4%', bottom: 50}, // Adjust left and right
+ fontSize: 15,
+ };
+
+ const chart = new google.visualization.ScatterChart(document.getElementById('dq_div_scat'));
+ chart.draw(data, options);
+ }
+
+ google.charts.setOnLoadCallback(drawMJDChart);
+ google.charts.setOnLoadCallback(drawPOSChart);
+ google.charts.setOnLoadCallback(drawALTChart);
+ google.charts.setOnLoadCallback(drawAZChart);
+ google.charts.setOnLoadCallback(drawScatChart);
+
+
+
+
+
+
+
+
+
+
+
+HTML;
+
+// End timer
+$total_time = round(microtime(true) - $start, 3);
+echo "Loading plot in $total_time seconds
";
+
+}
+
+###########################################################################
+#
+# Get data quality
+#
+###########################################################################
+function getDataQuality($db, $range = 'week', $proj) {
+ // Start timer
+ $start = microtime(true);
+
+ // testing day
+ $mjdDay = getMJD();
+ //$mjdDay = 60950;
+ $mjdDay_yearback = $mjdDay - 366;
+ $mjdDay_monthback = $mjdDay - 32;
+ $min_exp_id = 0;
+
+
+ // Determine the reference exp_name based on the selected range
+ switch ($range) {
+ case 'year':
+ $expname = "o" . $mjdDay_yearback . "%";
+ break;
+ case 'month':
+ $expname = "o" . $mjdDay_monthback . "%";
+ break;
+ case 'week':
+ $expname = "o" . ($mjdDay - 7) . "%";
+ break;
+ case 'yesterday':
+ $expname = "o" . ($mjdDay - 1) . "%";
+ break;
+ case 'today':
+ $expname = "o" . $mjdDay . "%";
+ break;
+ default:
+ $expname = "o" . ($mjdDay - 7) . "%"; // Default: week
+ break;
+ }
+
+ // --- PDO query for min_exp_id ---
+ $stmt = $db->prepare("SELECT MIN(exp_id) AS min_exp_id FROM rawExp WHERE exp_name LIKE :expname");
+ $stmt->execute([':expname' => $expname]);
+ $row = $stmt->fetch(PDO::FETCH_ASSOC);
+ if (!empty($row['min_exp_id'])) {
+ $min_exp_id = $row['min_exp_id'];
+ echo "min_exp_id:$min_exp_id $mjdDay_monthback $mjdDay";
+ } else {
+ echo "No results found for min_exp_id:$min_exp_id $mjdDay_monthback $mjdDay";
+ }
+
+ // Determine the date constraint based on the range
+ switch ($range) {
+ case 'year':
+ $dateConstraint = "rawExp.dateobs >= NOW() - INTERVAL 365 DAY AND rawExp.exp_id >= $min_exp_id";
+ break;
+ case 'month':
+ $dateConstraint = "rawExp.dateobs >= NOW() - INTERVAL 30 DAY AND rawExp.exp_id >= $min_exp_id";
+ break;
+ case 'week':
+ $expnames = array();
+ for ($i = 0; $i < 7; $i++) {
+ $expnames[] = "rawExp.exp_name LIKE 'o" . ($mjdDay - $i) . "%'";
+ }
+ $dateConstraint = "(" . implode(" OR ", $expnames) . ") AND rawExp.exp_id >= $min_exp_id";
+ $qday = $mjdDay - 6; // or something meaningful for week
+ break;
+ case 'yesterday':
+ $dateConstraint = "rawExp.exp_name LIKE 'o" . ($mjdDay - 1) . "%' AND rawExp.exp_id >= $min_exp_id";
+ $qday = $mjdDay - 1;
+ break;
+ case 'today':
+ $dateConstraint = "rawExp.exp_name LIKE 'o$mjdDay%' AND rawExp.exp_id >= $min_exp_id";
+ $qday = $mjdDay;
+ break;
+ case 'all':
+ $dateConstraint = "rawExp.exp_id >= 0";
+ break;
+ default: // Default to last night
+ $dateConstraint = "rawExp.exp_name LIKE 'o" . ($mjdDay - 1) . "%' AND rawExp.exp_id >= $min_exp_id";
+ $qday = $mjdDay - 1;
+ break;
+ }
+
+ // Updated SQL query
+ $sql1 = "select * from (SELECT SUBTIME(dateobs, '10:00:00') AS time, AST_R0, AST_D0, AST_RS, AST_DS, AST_T0, posang,
+ round(( 367*YEAR(dateobs)- FLOOR((7 * (YEAR(dateobs) + FLOOR((MONTH(dateobs) + 9) / 12))) / 4) + FLOOR(275 * MONTH(dateobs) / 9)
+ + DAY(dateobs) + 1721013.5 + (HOUR(dateobs) / 24.0) + (MINUTE(dateobs) / 1440.0) + (SECOND(dateobs) / 86400.0) - 2400000.5), 5) AS MJD,
+ filter, comment, round(ra*180/pi(), 5) as RA, round(decl*180/pi(), 5) as DECL, exp_name, alt,
+ az, fwhm_major, fwhm_minor, zpt_obs, zpt_stdev, airmass, exp_time,
+ rawExp.exp_id, camRun.label, moon_angle, cam_id, BIT_COUNT(astrom_chips) AS working_chips
+ FROM rawExp
+ JOIN chipRun USING (exp_id)
+ JOIN camRun USING (chip_id)
+ JOIN camProcessedExp USING (cam_id)
+ WHERE $dateConstraint
+ AND exp_type = 'OBJECT'
+ AND camRun.state LIKE 'full'
+ AND camProcessedExp.fault = 0
+ AND camProcessedExp.zpt_obs != 0 ORDER BY RAND() limit 5000) as sub order by time;";
+ $sql = " SELECT * FROM (SELECT
+ SUBTIME(rawExp.dateobs, '10:00:00') AS time,
+ cme.AST_R0,
+ cme.AST_D0,
+ cme.AST_RS,
+ cme.AST_DS,
+ cme.AST_T0,
+ rawExp.posang,
+ ROUND(
+ (367*YEAR(rawExp.dateobs)
+ - FLOOR((7*(YEAR(rawExp.dateobs)+FLOOR((MONTH(rawExp.dateobs)+9)/12)))/4)
+ + FLOOR(275*MONTH(rawExp.dateobs)/9)
+ + DAY(rawExp.dateobs)
+ + 1721013.5
+ + (HOUR(rawExp.dateobs)/24.0)
+ + (MINUTE(rawExp.dateobs)/1440.0)
+ + (SECOND(rawExp.dateobs)/86400.0)
+ - 2400000.5),5
+ ) AS MJD,
+ rawExp.filter,
+ rawExp.comment,
+ ROUND(rawExp.ra*180/PI(),5) AS RA,
+ ROUND(rawExp.decl*180/PI(),5) AS DECL,
+ rawExp.exp_name,
+ rawExp.alt,
+ rawExp.az,
+ cme.fwhm_major,
+ cme.fwhm_minor,
+ cme.zpt_obs,
+ cme.zpt_stdev,
+ rawExp.airmass,
+ rawExp.exp_time,
+ rawExp.exp_id,
+ rawExp.moon_angle,
+ camRun.label,
+ camRun.cam_id,
+ BIT_COUNT(astrom_chips) AS g_chips,
+ SUM(CASE WHEN rim.bg > 0 THEN 1 ELSE 0 END) AS n_raw,
+ SUM(CASE WHEN chi.bg IS NOT NULL THEN 1 ELSE 0 END) AS n_read,
+ SUM(CASE WHEN chi.quality > 0 THEN 1 ELSE 0 END) AS n_poor
+
+FROM camProcessedExp cme
+JOIN camRun USING (cam_id)
+JOIN chipRun USING (chip_id)
+JOIN chipProcessedImfile chi USING (chip_id)
+JOIN rawExp ON (rawExp.exp_id = chipRun.exp_id)
+JOIN rawImfile rim ON (rim.exp_id = rawExp.exp_id)
+
+WHERE
+ $dateConstraint
+ AND rawExp.exp_type = 'OBJECT'
+ AND camRun.state = 'full'
+ AND cme.fault = 0
+ AND cme.zpt_obs != 0
+ AND rim.class_id = chi.class_id
+
+GROUP BY
+ rawExp.exp_name,
+ camRun.label,
+ cam_id,
+ rawExp.dateobs,
+ rawExp.ra,
+ rawExp.decl,
+ rawExp.alt,
+ rawExp.moon_angle,
+ astrom_chips,
+ cme.bg,
+ cme.n_stars
+
+ORDER BY RAND() limit 5000) as sub order by time;
+";
+
+//echo "$sql
";
+//echo "$sql1";
+ $stmt = $db->query($sql);
+ $DQarray = $stmt->fetchAll(PDO::FETCH_ASSOC);
+
+ // Ensure $DQarray is not empty
+ if (empty($DQarray)) {
+ echo " No data for MJD: $qday ";
+ // End timer
+ $total_time = round(microtime(true) - $start, 3);
+ echo "loading plot in $total_time seconds
";
+ return; // Stop execution if no data to encode
+ }
+
+ // Convert data array to JSON for easier handling in JavaScript
+ $dataJson = json_encode($DQarray);
+
+ if ($dataJson === false) {
+ echo "Error encoding JSON: " . json_last_error_msg(); // Display any JSON encoding errors
+ // End timer
+ $total_time = round(microtime(true) - $start, 3);
+ echo "loading plot in $total_time seconds
";
+ return; // Stop execution if JSON encoding fails
+ }
+
+ echo ""; // Log JSON output to console for debugging
+
+ // start for Google Chart plot.
+ echo <<
+ // Use the encoded JSON directly in JavaScript
+ const dataArray = JSON.parse('{$dataJson}'); // Directly parse the PHP JSON string
+
+ const nRows = dataArray.length;
+
+ // draw working chips vs MJD
+ function drawCHIPChart() {
+
+ // data header
+ var data = new google.visualization.DataTable();
+ data.addColumn('number', 'MJD');
+ data.addColumn('number', 'Number of raw Chips');
+ data.addColumn({'type': 'string', 'role': 'tooltip', 'p': {'html': true}});
+// data.addColumn('number', 'Number of Good Chips');
+// data.addColumn({'type': 'string', 'role': 'tooltip', 'p': {'html': true}});
+
+ const mjdValues = dataArray.map(r => parseFloat(r.MJD));
+ let mjdMin0 = Math.min(...mjdValues);
+ const mjdMin = Math.floor(mjdMin0 * 10) / 10; // 1 decimal place or floor/ceil depending on your needs
+ let mjdMax0 = Math.max(...mjdValues);
+ const mjdMax = Math.ceil(mjdMax0 * 10) / 10; // 1 decimal place or floor/ceil depending on your needs
+ // Extract the first MJD value from dataArray
+ const firstMJD = dataArray.length > 0 ? Math.floor(parseFloat(dataArray[0].MJD)) : "N/A";
+ const mjdoff = mjdMin;
+ // output at console
+ // console.log("First MJD Value:", firstMJD);
+
+ // build data rows
+ const mjdVals = [];
+ const rows = dataArray.map(row => {
+ const mjd = parseFloat(row.MJD) - mjdoff;
+ mjdVals.push(mjd); // collect MJD offset values
+
+ const n_raw = parseFloat(row.n_raw)+1;
+ const n_chips = parseFloat(row.g_chips);
+ const f_good = n_chips / n_raw;
+ const tooltip = buildTooltip(row);
+
+ return[
+ mjd, f_good, tooltip,
+ ];
+ });
+
+ data.addRows(rows);
+
+ // Now compute min and max
+ const mjdMin1 = Math.min(...mjdVals);
+ const mjdMax1 = Math.max(...mjdVals);
+
+ const titleText = `N Chips vs. MJD ({$proj}) â \${nRows} rows\${dataArray.length >= 5000 ? " (sampled)" : ""}`;
+
+ const options = {
+ title: titleText,
+ titleTextStyle: {color: 'black', fontSize: 14, bold: true},
+ width: '100%',
+ height: Math.min(window.innerHeight * 0.6, 430), // This gives a nice result on smaller screens.
+ legend: { position: 'top', alignment: 'center' },
+ series: {
+ 0: { color: '#0000ff', pointSize: 3, lineWidth: 0. },
+ 1: { color: '#33a532', pointSize: 3, lineWidth: 0. },
+ 2: { color: 'red', lineWidth: 2, pointSize: 0 },
+ 3: { color: 'red', lineWidth: 2, lineDashStyle: [8, 4], pointSize: 0 }
+ },
+ intervals: { color: 'red', lineWidth: 2, style: 'sticks' },
+ hAxis: {
+ title: 'MJD - ' + mjdoff + ' (day)',
+ viewWindow: {
+ min: 0., // small padding
+ max: mjdMax1 + 0.005
+ },
+ gridlines: { count: -1 } // auto gridlines
+ },
+ vAxis: {
+ title: 'Good chips (number)',
+ // viewWindow: {
+ // max: 65,
+ // min: 0
+ // },
+ },
+ tooltip: { isHtml: true }, // Render tooltips as HTML
+ chartArea: {left: '9%', top: '10%', right: '3%', bottom: 50}, // Adjust left and right
+ fontSize: 14,
+ };
+
+ const chart = new google.visualization.ScatterChart(document.getElementById('dq_div_chips'));
+ chart.draw(data, options);
+ }
+
+ // draw FWHM vs MJD
+ function drawFWHMChart() {
+
+ // data header
+ var data = new google.visualization.DataTable();
+ data.addColumn('number', 'MJD');
+ data.addColumn('number', 'FWHM_maj');
+ data.addColumn({'type': 'string', 'role': 'tooltip', 'p': {'html': true}});
+ data.addColumn('number', 'FWHM_min');
+ data.addColumn({'type': 'string', 'role': 'tooltip', 'p': {'html': true}});
+ data.addColumn('number', '1"');
+ data.addColumn('number', '3"');
+
+ const mjdValues = dataArray.map(r => parseFloat(r.MJD));
+ let mjdMin0 = Math.min(...mjdValues);
+ const mjdMin = Math.floor(mjdMin0 * 10) / 10; // 1 decimal place or floor/ceil depending on your needs
+ let mjdMax0 = Math.max(...mjdValues);
+ const mjdMax = Math.ceil(mjdMax0 * 10) / 10; // 1 decimal place or floor/ceil depending on your needs
+ // Extract the first MJD value from dataArray
+ const firstMJD = dataArray.length > 0 ? Math.floor(parseFloat(dataArray[0].MJD)) : "N/A";
+ const mjdoff = mjdMin;
+ // output at console
+ // console.log("First MJD Value:", firstMJD);
+
+ // build data rows
+ const mjdVals = [];
+ const rows = dataArray.map(row => {
+ const mjd = parseFloat(row.MJD) - mjdoff;
+ mjdVals.push(mjd); // collect MJD offset values
+
+ const fwhm_maj = parseFloat(row.fwhm_major);
+ const fwhm_min = parseFloat(row.fwhm_minor);
+ const tooltip = buildTooltip(row);
+
+ return[
+ mjd, fwhm_maj, tooltip, fwhm_min, tooltip, 4, 12,
+ ];
+ });
+
+ data.addRows(rows);
+
+ // Now compute min and max
+ const mjdMin1 = Math.min(...mjdVals);
+ const mjdMax1 = Math.max(...mjdVals);
+
+ const titleText = `FWHM vs. MJD ({$proj}) â \${nRows} rows\${dataArray.length >= 5000 ? " (sampled)" : ""}`;
+
+ const options = {
+ title: titleText,
+ titleTextStyle: {color: 'black', fontSize: 14, bold: true},
+ width: '100%',
+ height: Math.min(window.innerHeight * 0.6, 430), // This gives a nice result on smaller screens.
+ legend: { position: 'top', alignment: 'center' },
+ series: {
+ 0: { color: '#0000ff', pointSize: 3, lineWidth: 0. },
+ 1: { color: '#33a532', pointSize: 3, lineWidth: 0. },
+ 2: { color: 'red', lineWidth: 2, pointSize: 0 },
+ 3: { color: 'red', lineWidth: 2, lineDashStyle: [8, 4], pointSize: 0 }
+ },
+ intervals: { color: 'red', lineWidth: 2, style: 'sticks' },
+ hAxis: {
+ title: 'MJD - ' + mjdoff + ' (day)',
+ viewWindow: {
+ min: 0., // small padding
+ max: mjdMax1 + 0.005
+ },
+ gridlines: { count: -1 } // auto gridlines
+ },
+ vAxis: {
+ title: 'FWHM (pixels)',
+ },
+ tooltip: { isHtml: true }, // Render tooltips as HTML
+ chartArea: {left: '9%', top: '10%', right: '3%', bottom: 50}, // Adjust left and right
+ fontSize: 14,
+ };
+
+ const chart = new google.visualization.ScatterChart(document.getElementById('dq_div_fwhm'));
+ chart.draw(data, options);
+ }
+
+ function drawZPTChart() {
+ let gzp0, rzp0, izp0, zzp0, yzp0, wzp0; // declare outside
+ switch ('{$proj}') {
+ case 'gpc1':
+ // ref?
+ gzp0 = 24.563; rzp0 = 24.750; izp0 = 24.611; zzp0 = 24.240; yzp0 = 23.320; wzp0 = 26.000;
+ //
+ //gzp0 = 24.563; rzp0 = 24.750; izp0 = 24.611; zzp0 = 24.240; yzp0 = 23.320; wzp0 = 26.000;
+ break;
+ case 'gpc2':
+ // ref?
+ gzp0 = 25.013; rzp0 = 28.840; izp0 = 24.711; zzp0 = 24.300; yzp0 = 23.570; wzp0 = 26.000;
+ break;
+ }
+ const filters = [
+ { key: 'g', zp: gzp0, color: '#00f000', shape: 'circle' },
+ { key: 'r', zp: rzp0, color: '#f00000', shape: 'triangle' },
+ { key: 'i', zp: izp0, color: '#f05000', shape: 'square' },
+ { key: 'z', zp: zzp0, color: '#0050a0', shape: 'diamond' },
+ { key: 'y', zp: yzp0, color: '#ffe000', shape: 'star' },
+ { key: 'w', zp: wzp0, color: '#808080', shape: 'polygon' }
+ ];
+
+ // Count occurrences of each filter
+ const filterCounts = Object.fromEntries(filters.map(f => [f.key, 0]));
+
+ const mjdValues = dataArray.map(r => parseFloat(r.MJD));
+ const mjdMin0 = Math.min(...mjdValues);
+ const mjdMax0 = Math.max(...mjdValues);
+ const mjdMin = Math.floor(mjdMin0 * 10) / 10;
+ const mjdMax = Math.ceil(mjdMax0 * 10) / 10;
+ const mjdoff = mjdMin;
+
+ const mjdVals = [];
+
+ // build rows
+ const rows = dataArray.map(row => {
+ const mjd = parseFloat(row.MJD) - mjdoff;
+ mjdVals.push(mjd);
+
+ const filter = row.filter[0];
+ const zpt_obs = parseFloat(row.zpt_obs);
+ const zpt_stdev = parseFloat(row.zpt_stdev);
+
+ // Initialize one slot per filter
+ const zpVals = {};
+ filters.forEach(f => zpVals[f.key] = null);
+
+ if (filterCounts.hasOwnProperty(filter)) {
+ filterCounts[filter] += 1;
+ zpVals[filter] = zpt_obs - 0.0; // offset if needed
+ }
+
+ const tooltip = buildTooltip(row); // Tooltips
+
+ return [
+ mjd,
+ ...filters.flatMap(f => [
+ zpVals[f.key],
+ tooltip,
+ zpVals[f.key] !== null ? zpVals[f.key] - zpt_stdev : null,
+ zpVals[f.key] !== null ? zpVals[f.key] + zpt_stdev : null
+ //zpVals[f.key] !== null ? zpVals[f.key] + zpt_stdev : null, f.zp
+ ])
+ ];
+ });
+
+ // Build table
+ const data = new google.visualization.DataTable();
+ data.addColumn('number', 'MJD');
+
+ filters.forEach(f => {
+ const label = filterCounts[f.key] !== 0 ? filterCounts[f.key] : "N/A";
+ data.addColumn('number', `\${f.key} (\${label})`);
+ data.addColumn({type: 'string', role: 'tooltip', p: {html: true}});
+ data.addColumn({type: 'number', role: 'interval'});
+ data.addColumn({type: 'number', role: 'interval'});
+ //data.addColumn('number');
+ });
+
+ data.addRows(rows);
+
+ const mjdMin1 = Math.min(...mjdVals);
+ const mjdMax1 = Math.max(...mjdVals);
+ const defaultSeries = { pointSize: 6, lineWidth: 0 };
+
+ const titleText = `ZPs vs. MJD ({$proj}) â \${nRows} rows\${dataArray.length >= 5000 ? " (sampled)" : ""}`;
+
+ const options = {
+ title: titleText,
+ titleTextStyle: { color: 'black', fontSize: 14 },
+ width: '100%',
+ height: Math.min(window.innerHeight * 0.6, 430),
+ legend: { position: 'top', alignment: 'center', maxLines: 3 },
+ //series: Object.fromEntries(filters.map((f, i) => [i*2, {
+ series: Object.fromEntries(filters.map((f, i) => [i, {
+ ...defaultSeries,
+ color: f.color,
+ pointShape: f.shape
+ }])),
+ intervals: { color: 'red', lineWidth: .0, style: 'sticks' },
+ hAxis: {
+ title: 'MJD - ' + mjdoff + ' (day)',
+ viewWindow: { min: 0, max: mjdMax1 + 0.005 },
+ gridlines: { count: -1 }
+ },
+ vAxis: {
+ title: 'Zeropoint (mag)',
+ viewWindow: { min: 22, max: 27 }
+ },
+ tooltip: { isHtml: true },
+ chartArea: { left: '9%', top: '10%', right: '3%', bottom: 50 },
+ fontSize: 14,
+ };
+ // options.series[1] = { color: 'black', lineDashStyle: [2, 3], lineWidth: 2, pointSize: 0 };
+ // options.series[3] = { color: 'black', lineDashStyle: [2, 3], lineWidth: 2, pointSize: 0 };
+ // options.series[5] = { color: 'black', lineDashStyle: [2, 3], lineWidth: 2, pointSize: 0 };
+ // options.series[7] = { color: 'black', lineDashStyle: [2, 3], lineWidth: 2, pointSize: 0 };
+ // options.series[9] = { color: 'black', lineDashStyle: [2, 3], lineWidth: 2, pointSize: 0 };
+ // options.series[11] = { color: 'black', lineDashStyle: [2, 3], lineWidth: 2, pointSize: 0 };
+
+ const chart = new google.visualization.ScatterChart(document.getElementById('dq_div_zpt'));
+ chart.draw(data, options);
+ }
+
+ // draw zoomed zerpoint vs mjd
+ function drawZOOMZPTChart() {
+ const mjdValues = dataArray.map(r => parseFloat(r.MJD));
+ let mjdMin0 = Math.min(...mjdValues);
+ const mjdMin = Math.floor(mjdMin0 * 10) / 10; // 1 decimal place or floor/ceil depending on your needs
+ let mjdMax0 = Math.max(...mjdValues);
+ const mjdMax = Math.ceil(mjdMax0 * 10) / 10; // 1 decimal place or floor/ceil depending on your needs
+ // Extract the first MJD value from dataArray
+ const firstMJD = dataArray.length > 0 ? Math.floor(parseFloat(dataArray[0].MJD)) : "N/A";
+ const mjdoff = mjdMin;
+ // output at console
+ console.log("First MJD Value:", firstMJD);
+
+ // Compute median zpt_obs per filter
+ function median(arr) {
+ const sorted = arr.filter(v => !isNaN(v)).sort((a, b) => a - b);
+ const len = sorted.length;
+ if (len === 0) return null;
+ const mid = Math.floor(len / 2);
+ return len % 2 === 0 ? (sorted[mid - 1] + sorted[mid]) / 2 : sorted[mid];
+ }
+
+ // Group zpt_obs by filter
+ const zptByFilter = { g: [], r: [], i: [], z: [], y: [], w: [] };
+
+ dataArray.forEach(row => {
+ const f = row.filter[0]; // 'g','r','i','z','y','w'
+ const zpt = parseFloat(row.zpt_obs);
+ if (!isNaN(zpt) && zptByFilter.hasOwnProperty(f)) {
+ zptByFilter[f].push(zpt);
+ }
+ });
+
+ // Compute medians (this replaces hardcoded zp0 values)
+ let gzp1 = median(zptByFilter.g);
+ let rzp1 = median(zptByFilter.r);
+ let izp1 = median(zptByFilter.i);
+ let zzp1 = median(zptByFilter.z);
+ let yzp1 = median(zptByFilter.y);
+ let wzp1 = median(zptByFilter.w);
+
+ let gzp0, rzp0, izp0, zzp0, yzp0, wzp0; // declare outside
+ switch ('{$proj}') {
+ case 'gpc1':
+ // ref?
+ gzp0 = 24.563; rzp0 = 24.750; izp0 = 24.611; zzp0 = 24.240; yzp0 = 23.320; wzp0 = 26.000;
+ //
+ //gzp0 = 24.563; rzp0 = 24.750; izp0 = 24.611; zzp0 = 24.240; yzp0 = 23.320; wzp0 = 26.000;
+ break;
+ case 'gpc2':
+ // ref?
+ gzp0 = 25.013; rzp0 = 28.840; izp0 = 24.711; zzp0 = 24.300; yzp0 = 23.570; wzp0 = 26.000;
+ break;
+ }
+
+ console.log("Dynamic median zeropoints per filter:", {
+ g: gzp0, r: rzp0, i: izp0, z: zzp0, y: yzp0, w: wzp0
+ });
+
+ // Build filters array (with safe label for missing zp)
+ const filters = [
+ { key: 'g', zp: gzp0, zpm: gzp1},
+ { key: 'r', zp: rzp0, zpm: rzp1},
+ { key: 'i', zp: izp0, zpm: izp1},
+ { key: 'z', zp: zzp0, zpm: zzp1},
+ { key: 'y', zp: yzp0, zpm: yzp1},
+ { key: 'w', zp: wzp0, zpm: wzp1}
+ ];
+
+ // Keep zpMap for quick lookup
+ const zpMap = {
+ g: gzp0, r: rzp0, i: izp0,
+ z: zzp0, y: yzp0, w: wzp0
+ };
+
+ const mjdVals = [];
+ let allZps = [];
+ const rows = dataArray.map(row => {
+ const mjd = parseFloat(row.MJD) - mjdoff;
+ const zpt_obs = parseFloat(row.zpt_obs);
+ const zpt_stdev = parseFloat(row.zpt_stdev);
+ const airmass = parseFloat(row.airmass);
+ const filterChar = row.filter[0]; // 'g','r','i','z','y','w'
+ const filter = row.filter;
+
+ // shift relative to median
+ let zpValues = { g: null, r: null, i: null, z: null, y: null, w: null };
+ if (zpMap.hasOwnProperty(filterChar) && !isNaN(zpt_obs) && zpMap[filterChar] !== null) {
+ zpValues[filterChar] = zpt_obs - zpMap[filterChar] ;
+ }
+
+ const tooltip = buildTooltip(row); // Tooltips
+
+ // Build row for chart
+ const rowData = [mjd];
+ ["g", "r", "i", "z", "y", "w"].forEach(f => {
+ const zp = zpValues[f];
+ rowData.push( zp, tooltip, zp !== null ? zp - zpt_stdev : null, zp !== null ? zp + zpt_stdev : null);
+ });
+
+ // collect MJD offset values
+ mjdVals.push(mjd);
+
+ // collect valid zp values
+ Object.values(zpValues).forEach(v => {
+ if (v !== null && !isNaN(v)) allZps.push(v);
+ });
+
+ return rowData;
+ });
+
+ // find minimum zp across all filters
+ const minZp = Math.min(...allZps);
+ const clampedMinZp = minZp*2. < -0.5 ? -0.5 : minZp*2.;
+ const maxZp = Math.max(...allZps);
+ const clampedMaxZp = maxZp*2. > 0.5 ? 0.5 : maxZp*2.;
+ console.log("Min Zeropoint:", minZp, clampedMinZp);
+ console.log("Max Zeropoint:", maxZp, clampedMaxZp);
+
+ const legendDiv = document.getElementById("legend");
+ legendDiv.innerHTML = ""; // clear before filling
+
+ // Define series styles (must match your chart series order)
+ const seriesStyles = [
+ { bgColor: '#ffffff', color: '#00f000', pointShape: 'circle' }, // g
+ { bgColor: '#ffffff', color: '#f00000', pointShape: 'triangle' }, // r
+ { bgColor: '#ffffff', color: '#f05000', pointShape: 'square' }, // i
+ { bgColor: '#ffffff', color: '#0050a0', pointShape: 'diamond' }, // z
+ { bgColor: '#ffffff', color: '#ffe000', pointShape: 'star' }, // y
+ { bgColor: '#ffffff', color: '#808080', pointShape: 'polygon' }, // w
+ ];
+
+ // Map pointShape to simple Unicode / CSS symbol
+ const shapeSymbols = {
+ circle: 'â',
+ triangle: 'â²',
+ square: 'â ',
+ diamond: 'â',
+ star: 'â
+',
+ polygon: 'â¬'
+ };
+
+ // create data column
+ var data = new google.visualization.DataTable();
+ data.addColumn('number', 'MJD');
+ //filters.forEach(f => {
+ filters.forEach((f, index) => {
+
+ const zpLabel = f.zp !== null ? f.zp.toFixed(3) : "N/A";
+ const zpm = f.zpm !== null ? f.zpm.toFixed(3) : "N/A";
+ data.addColumn('number', `\${f.key}:\${zpLabel}`);
+ // data.addColumn('number', `\${f.key}`);
+ data.addColumn({type: 'string', role: 'tooltip', p: {html: true}});
+ data.addColumn({type: 'number', role: 'interval'});
+ data.addColumn({type: 'number', role: 'interval'});
+
+ // add to legend instead
+ const style = seriesStyles[index % seriesStyles.length];
+
+ const span = document.createElement("span");
+ span.style.marginRight = "20px";
+ span.style.whiteSpace = "nowrap";
+ span.style.color = style.color;
+ span.style.backgroundColor = style.bgColor;
+
+ // Use Unicode symbol for pointShape
+ const shape = shapeSymbols[style.pointShape] || 'â';
+
+ span.innerText = `\${shape} \${f.key}:\${zpm}`;
+
+ legendDiv.appendChild(span);
+
+ });
+
+ data.addRows(rows);
+
+ // plot options
+ const mjdMin1 = Math.min(...mjdVals);
+ const mjdMax1 = Math.max(...mjdVals);
+ const defaultSeries = { pointSize: 6, lineWidth: 0 };
+
+ const titleText = `ZPs_off vs. MJD ({$proj}) â \${nRows} rows\${dataArray.length >= 5000 ? " (sampled)" : ""}`;
+
+ const options = {
+ title: titleText,
+ titleTextStyle: { color: 'black', fontSize: 15},
+ width: '100%',
+ height: Math.min(window.innerHeight * 0.6, 430), // This gives a nice result on smaller screens.
+ //legend: { position: 'top', alignment: 'center', maxLines: 3, textStyle: {fontSize: 12} },
+ legend: { position: 'none', alignment: 'center', maxLines: 3 },
+ series: {
+ 0: { ...defaultSeries, color: '#00f000', pointShape: 'circle', }, // 'g' filter
+ 1: { ...defaultSeries, color: '#f00000', pointShape: 'triangle', }, // 'r' filter
+ 2: { ...defaultSeries, color: '#f05000', pointShape: 'square', }, // 'i' filter
+ 3: { ...defaultSeries, color: '#0050a0', pointShape: 'diamond', }, // 'z' filter
+ 4: { ...defaultSeries, color: '#ffe000', pointShape: 'star', }, // 'y' filter
+ 5: { ...defaultSeries, color: '#808080', pointShape: 'polygon', }, // 'w' filter
+ },
+ intervals: { color: 'red', lineWidth: .0, style: 'sticks' },
+ hAxis: {
+ title: 'MJD - ' + mjdoff + ' (day)',
+ viewWindow: {
+ min: 0, // small padding
+ max: mjdMax1 + 0.005
+ },
+ gridlines: { count: -1 },
+ minorGridlines: { count: 1 }
+ },
+ vAxis: {
+ title: 'Zeropoint offset (mag)',
+ //viewWindow: { min: clampedMinZp, max: clampedMaxZp },
+ viewWindow: { min: -0.3, max: 0.15 },
+ gridlines: { count: -1 },
+ minorGridlines: { count: 1 }
+ },
+ tooltip: { isHtml: true},
+ chartArea: { left: '9%', top: '12%', right: '3%', bottom: 50 },
+ fontSize: 14,
+ };
+
+ const chart = new google.visualization.ScatterChart(document.getElementById('dq_div_zoomzpt'));
+ chart.draw(data, options);
+
+ }
+ google.charts.setOnLoadCallback(drawCHIPChart);
+ google.charts.setOnLoadCallback(drawFWHMChart);
+ google.charts.setOnLoadCallback(drawZPTChart);
+ google.charts.setOnLoadCallback(drawZOOMZPTChart);
+
+
+
+
+
+
+
+
+
+
+
+
+HTML;
+ // End timer
+ $total_time = round(microtime(true) - $start, 3);
+ echo "loading plot in $total_time seconds
";
+
+}
+
+?>
+
Index: /trunk/ippMonitor/raw/pointing.php
===================================================================
--- /trunk/ippMonitor/raw/pointing.php (revision 42971)
+++ /trunk/ippMonitor/raw/pointing.php (revision 42972)
@@ -15,5 +15,5 @@
else {$myMenu = "ipp.czar.dat";}
-menu($myMenu, 'Czartool on '.$lastUpdateTime, 'ipp.css', $ID['link'], $ID['proj']);
+menu($myMenu, 'Czartool on ', 'ipp.css', $ID['link'], $ID['proj']);
$pass = $ID['pass'];
@@ -22,483 +22,55 @@
// Fetch data based on range selection
-$range = isset($_GET['range']) ? $_GET['range'] : 'yday';
+$range = isset($_GET['range']) ? $_GET['range'] : 'week';
+
+require_once 'functions.php';
echo "";
echo "";
echo " ";
-echo " Pointing Report";
-echo " ";
-echo ' Last night (default) | ';
-echo ' Today (MJD '.getMJD().') | ';
-echo ' Past 7 days | ';
-echo ' Past 30 days | ';
-echo ' Past 365 days | ';
-echo ' All ';
+echo " Data Quality Report";
+
+#
+# project selector
+echo '';
+# Project selector with highlight
+$projects = ["gpc1" => "GPC1", "gpc2" => "GPC2"];
+foreach ($projects as $key => $label) {
+ if ($proj == $key) {
+ echo "$label | ";
+ } else {
+ echo '' . $label . ' | ';
+ }
+}
+echo "
";
+
+# range links with highlighting
+$ranges = [
+ "today" => "Today",
+ "yesterday" => "Yesterday",
+ "week" => "Week",
+ "month" => "Month",
+ "year" => "Year",
+ "all" => "All"
+];
+
+foreach ($ranges as $key => $label) {
+ if ($range == $key) {
+ echo "$label | ";
+ } else {
+ echo '' . $label . ' | ';
+ }
+}
+
echo " | ";
echo " ";
echo " ";
-echo getPointing($projectdb, $range);
+echo " ";
+echo " Current MJD: " . getMJD();
+echo " ";
+
+echo getPointing($projectdb, $range, $proj);
menu_end();
-
-
-/////////////////////////////////////////////////////////////////////////////
-// //
-// Functions //
-// //
-/////////////////////////////////////////////////////////////////////////////
-###########################################################################
-#
-# Get data quality
-#
-###########################################################################
-function getPointing($db, $range = 'yday') {
- // Start timer
- $start = microtime(true);
-
- $mjdDay = getMJD();
- $mjdDay_yearback = $mjdDay - 366;
- $mjdDay_monthback = $mjdDay - 32;
- $min_exp_id = 0;
-
- // Determine the reference exp_name based on the selected range
- switch ($range) {
- case 'year':
- $expname = "o" . $mjdDay_yearback . "%";
- break;
- case 'month':
- $expname = "o" . $mjdDay_monthback . "%";
- break;
- case 'week':
- $expname = "o" . ($mjdDay - 7) . "%";
- break;
- case 'day':
- $expname = "o" . $mjdDay . "%";
- break;
- default:
- $expname = "o" . ($mjdDay - 1) . "%"; // Default: last night
- break;
- }
-
- // Query to get the minimum exp_id
- $expIdQuery = "SELECT MIN(exp_id) AS min_exp_id FROM rawExp WHERE rawExp.exp_name LIKE '$expname'";
- $result = $db->query($expIdQuery);
-
- if (DB::isError($result)) {
- die("Database error: " . $result->getMessage());
- }
-
- $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
-
- if (!empty($row['min_exp_id'])) {
- $min_exp_id = $row['min_exp_id'];
- // echo "Minimum exp_id: " . $min_exp_id;
- } else {
- echo "No results found.";
- }
-
- //echo "
";
-
- // Determine the date constraint based on the range
- switch ($range) {
- case 'year':
- $dateConstraint = "dateobs >= NOW() - INTERVAL 365 DAY AND rawExp.exp_id >= $min_exp_id";
- break;
- case 'month':
- $dateConstraint = "dateobs >= NOW() - INTERVAL 30 DAY AND rawExp.exp_id >= $min_exp_id";
- break;
- case 'week':
- $expnames = array();
- for ($i = 0; $i < 7; $i++) {
- $expnames[] = "rawExp.exp_name LIKE 'o" . ($mjdDay - $i) . "%'";
- }
- $dateConstraint = "(" . implode(" OR ", $expnames) . ") AND rawExp.exp_id >= $min_exp_id";
- break;
- case 'yday':
- $dateConstraint = "rawExp.exp_name LIKE 'o" . ($mjdDay - 1) . "%' AND rawExp.exp_id >= $min_exp_id";
- break;
- case 'day':
- $dateConstraint = "rawExp.exp_name LIKE 'o$mjdDay%' AND rawExp.exp_id >= $min_exp_id";
- break;
- case 'all':
- $dateConstraint = "rawExp.exp_id >= 0";
- break;
- default: // Default to last night
- $dateConstraint = "rawExp.exp_name LIKE 'o" . ($mjdDay - 1) . "%' AND rawExp.exp_id >= $min_exp_id";
- break;
- }
-
- // Updated SQL query
- $sql = "select * from (SELECT SUBTIME(dateobs, '10:00:00') AS time, AST_R0, AST_D0,
- round(( 367*YEAR(dateobs)- FLOOR((7 * (YEAR(dateobs) + FLOOR((MONTH(dateobs) + 9) / 12))) / 4) + FLOOR(275 * MONTH(dateobs) / 9)
- + DAY(dateobs) + 1721013.5 + (HOUR(dateobs) / 24.0) + (MINUTE(dateobs) / 1440.0) + (SECOND(dateobs) / 86400.0) - 2400000.5), 5) AS MJD,
- filter, exp_time, comment, ra*180/pi() as RA, decl*180/pi() as DECL, AST_RS, AST_DS, AST_T0, posang, exp_name, alt, az, rawExp.exp_id, camRun.label
- FROM rawExp
- JOIN chipRun USING (exp_id)
- JOIN camRun USING (chip_id)
- JOIN camProcessedExp USING (cam_id)
- WHERE $dateConstraint
- AND exp_type = 'OBJECT'
- AND camRun.state LIKE 'full'
- AND camProcessedExp.fault = 0
- AND camProcessedExp.zpt_obs != 0 ORDER BY RAND() limit 5000) as sub order by time;";
-
- $DQarray = array();
- $qry = $db->query($sql);
- if (dberror($qry)) {
- echo "Error with $sql
\n";
- return;
- }
- // echo "$sql
\n";
-
- while ($qry->fetchInto($row)) {
- $DQarray[] = $row;
- }
-
- // Ensure $DQarray is not empty
- if (empty($DQarray)) {
- echo " No data for MJD: $mjdDay ";
- return; // Stop execution if no data to encode
- }
-
- // Convert data array to JSON for easier handling in JavaScript
- $dataJson = json_encode($DQarray);
-
- if ($dataJson === false) {
- echo "Error encoding JSON: " . json_last_error_msg(); // Display any JSON encoding errors
- return; // Stop execution if JSON encoding fails
- }
-
- echo ""; // Log JSON output to console for debugging
-echo <<
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-HTML;
-
-// End timer
-$total_time = round(microtime(true) - $start, 3);
-echo "Loading plot in $total_time seconds
";
-
-}
?>
Index: /trunk/ippMonitor/raw/storage.php
===================================================================
--- /trunk/ippMonitor/raw/storage.php (revision 42971)
+++ /trunk/ippMonitor/raw/storage.php (revision 42972)
@@ -12,8 +12,9 @@
$projectdb = dbconnect($ID['proj']);
+
if ($ID['menu']) {$myMenu = $ID['menu'];}
else {$myMenu = "ipp.czar.dat";}
-menu($myMenu, 'Czartool on '.$lastUpdateTime, 'ipp.css', $ID['link'], $ID['proj']);
+menu($myMenu, 'Czartool on ', 'ipp.css', $ID['link'], $ID['proj']);
$pass = $ID['pass'];
@@ -25,4 +26,7 @@
echo " | ";
echo " Storage status";
+
+require_once 'functions.php';
+
# storage timeseries
echo getSpaces($czardb);
@@ -35,277 +39,4 @@
menu_end();
-
-/////////////////////////////////////////////////////////////////////////////
-// //
-// Functions //
-// //
-/////////////////////////////////////////////////////////////////////////////
-
-###########################################################################
-#
-# Gets disk status
-#
-###########################################################################
-function getHosts($db) {
- $start = microtime(true);
-
-
- // Set environment variables
- putenv("PATH=/usr/local/bin:/usr/bin:/bin:/data/ippc65.0/ipp/src/psconfig//ipp-20210708-gentoo.lin64/bin");
- putenv("PERL5LIB=/data/ippc65.0/ipp/src/psconfig//ipp-20210708-gentoo.lin64/lib");
-
- $hostnoteall = array();
- exec("neb-host |cut -b 17-30,86-", $hostnoteall);
-
- $sql = "SELECT host, format(total, 2), format(available, 2), format(used, 2), writable, readable, format(used/total*100,3) as ratio FROM hosts where xattr <> 3 ORDER BY CASE WHEN ROUND(used/total*100,3) = 100 THEN 0 ELSE 1 END, xattr, host;";
- $qry = $db->query($sql);
-
- if ($qry === false) {
- echo "Error with SQL query
";
- return;
- }
-
- $sqlMax = "SELECT MAX(total) AS max_total FROM hosts WHERE xattr <> 3";
- $qryMax = $db->query($sqlMax);
- $maxUsed = 0;
-
- if ($qryMax && $qryMax->fetchInto($rowMax)) {
- $maxUsed = $rowMax[0]; // max_total value
- }
-
- $dataRows = array();
- while ($qry->fetchInto($row)) {
- // Access by index
- $host = $row[0]; // ipp071.0
- $total = $row[1]; // 80.0352 TB
- $available = $row[2]; // 10.8096 TB
- $used = $row[3]; // 69.2256 TB
- $writable = $row[4]; // 0
- $readable = $row[5]; // 1
- $ratio = $row[6]; // 86.4939 %
-
- // Match notes
- $hostnotes = preg_grep("/$host/", $hostnoteall);
- $hostnote = reset($hostnotes);
-
- // Defaults
- $styles = "stroke-width: .5; stroke-color: black;";
- $status = "down";
- $usedColor = "lightgrey";
- $freeColor = "lightgrey";
-
- // Status logic
- if ($writable == 1 && $readable == 1) {
- $status = "up";
- $usedColor = ($ratio >= 97) ? "pink" : "yellow"; // red if â¥97%
- $freeColor = "#a6ec99"; // green free
- } elseif ($writable == 0 && $readable == 1) {
- $status = "repair";
- $usedColor = ($ratio >= 97) ? "pink" : "yellow";
- $freeColor = "lightgrey"; // grey free
- } elseif ($available < 1) {
- $used = $maxUsed;
- $available = 0;
- $status = "offline";
- $usedColor = "white";
- $freeColor = "white";
- }
-
- if ($status == "down") {
- $tooltipUsed = $host . ": " . round($ratio, 1) . "% of " . $total . " TB used ".
- "
" . $hostnote . "";
- $tooltipFree = "" .
- $host . ": " . $available . " TB free" .
- "";
- } elseif ($status == "offline") {
- $tooltipUsed = $host . ": " . round($ratio, 1) . "% of " . $total . " TB used ".
- "
" . $hostnote . "";
- $tooltipFree = "" .
- $host . ": " . $total . " TB free" .
- "";
- } else {
- $tooltipUsed = $host . ": " . round($ratio, 1) . "% of " . $total . " TB used
" . $hostnote ;
- $tooltipFree = $host . ": " . $available . " TB free";
- }
-
-
- // Build data row (manual string concatenation for old PHP)
- $dataRows[] =
- "[ \"" . $host . ":" . $status . "\", " .
- $used . ", \"" . $styles . " color: " . $usedColor . ";\", \"" . $tooltipUsed . "\", " .
- $available . ", \"" . $styles . " color: " . $freeColor . ";\", \"" . $tooltipFree . "\" ]";
-
- }
- echo "";
-
-echo "
-
-
-
-
-
-
-
- Free
- Used
- 97% Usage
- Down/Repair
- Offline
-
-
-
-
-
";
-}
-
-
-###########################################################################
-#
-# Gets disk spaces status
-#
-###########################################################################
-function getSpaces($db) {
- // timer start
- $time = microtime();
- $time = explode(' ', $time);
- $time = $time[1] + $time[0];
- $start = $time;
-
- $db->query("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts where host like 'ippb%' and xattr <> 3")->fetchInto($row);
- $ippbusable = $row[0];
- $db->query("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts where host like 'ippb%' and writable = 1 and xattr <> 3")->fetchInto($row);
- $ippbfree = $row[0];
-
- $db->query("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts where host not like 'ippb%' and xattr <> 3")->fetchInto($row);
- $ippusable = $row[0];
- $db->query("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts where host not like 'ippb%' and writable = 1 and xattr <> 3")->fetchInto($row);
- $ippfree = $row[0];
-
- $db->query("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts where host like 'ipp%_bck.0' and xattr <> 3")->fetchInto($row);
- $bckusable = $row[0];
- $db->query("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts where host like 'ipp%_bck.0' and writable = 1 and xattr <> 3")->fetchInto($row);
- $bckfree = $row[0];
-
-
- $sql = "select format(used/total*100,1), usable from cluster_space order by timestamp desc limit 1;";
-
- if ($debug) {echo "$sql
";}
- $qry = $db->query($sql);
- if (dberror($qry)) {echo "error with $sql
\n";}
- $qry->fetchInto($row);
- $allocated = $row[0];
- $usable = $row[1];
-
- #echo "";
- echo "";
- echo "
";
- echo " ";
- echo " ";
- echo " ipp*_bck: $bckusable TB (usable) ";
- echo " ipp*_bck: $bckfree TB (free) ";
- echo " ";
- echo "
";
-}
-
-
?>
| | | | | | | | | |