| $tmp[0] | null | null | $tmp[3]";
+ list($expType, $downloadState, $rawState, $count, $summit_exp, $pz_exp, $raw_exp) = $tmp;
+ if ($downloadState == NULL) {
+ echo "| $expType ($summit_exp) | loading imfiles | null | $count";
} else {
- if ($tmp[1] == 'run') {
- echo "| $tmp[0] | loading | null | $tmp[3]";
+ if ($downloadState == 'run') {
+ echo "| $expType ($summit_exp) | summit_copy ($pz_exp) | saving ($pz_exp) | $count";
} else {
- if ($tmp[2] == NULL) {
- echo "| $tmp[0] | $tmp[1] | loading | $tmp[3]";
+ if ($rawState == NULL) {
+ echo "| $expType ($summit_exp) | $downloadState ($pz_exp) | registering ($pz_exp) | $count";
} else {
- echo "| $tmp[0] | $tmp[1] | downloaded | $tmp[3]";
+ echo " | | $expType ($summit_exp) | $downloadState ($pz_exp) | $rawState ($raw_exp) | $count";
}
}
@@ -1561,35 +1548,85 @@
}
- echo " | | Last night $datem1 (UTC)";
- $sql = "SELECT summitExp.exp_type,pzDownloadExp.state,rawExp.state,COUNT(*) FROM summitExp
- LEFT JOIN pzDownloadExp USING (summit_id) LEFT JOIN rawExp on summitExp.exp_name = rawExp.exp_name
- WHERE summitExp.dateobs like '$datem1%' group by summitExp.exp_type,pzDownloadExp.state,rawExp.state";
+ 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
+ GROUP BY sum_type, pzstate, rawstate";
+ // $sql = "
+ // SELECT summitExp.exp_type, pzDownloadExp.state, rawExp.state, COUNT(*)
+ // 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'
+ // GROUP BY summitExp.exp_type, pzDownloadExp.state, rawExp.state";
+ if ($debug) {echo "$sql
";}
+
$qry = $projectdb->query($sql);
while ($qry->fetchInto($tmp)) {
- if ($tmp[1] == NULL) {
- echo " |
|---|
| $tmp[0] | null | null | $tmp[3]";
+ list($expType, $downloadState, $rawState, $count, $summit_exp, $pz_exp, $raw_exp) = $tmp;
+ if ($downloadState == NULL) {
+ echo "| $expType ($summit_exp) | loading imfiles | null | $count";
} else {
- if ($tmp[1] == 'run') {
- echo "| $tmp[0] | loading | null | $tmp[3]";
+ if ($downloadState == 'run') {
+ echo "| $expType ($summit_exp) | summit_copy ($pz_exp) | saving ($pz_exp) | $count";
} else {
- if ($tmp[2] == NULL) {
- echo "| $tmp[0] | $tmp[1] | loading | $tmp[3]";
+ if ($rawState == NULL) {
+ echo "| $expType ($summit_exp) | $downloadState ($pz_exp) | registering | $count";
} else {
- echo "| $tmp[0] | $tmp[1] | downloaded | $tmp[3]";
+ echo " | | $expType ($summit_exp) | $downloadState ($pz_exp) | $rawState ($raw_exp) | $count";
}
}
}
}
- // timer finished
+ //while ($qry->fetchInto($tmp)) {
+ // list($expType, $downloadState, $rawState, $count) = $tmp;
+ // if ($downloadState == NULL) {
+ // echo " | | $expType | null | null | $count";
+ // } else {
+ // if ($downloadState == 'run') {
+ // echo "| $expType | loading | null | $count";
+ // } else {
+ // if ($rawState == NULL) {
+ // echo "| $expType | $downloadState | loading | $count";
+ // } else {
+ // echo "| $expType | $downloadState | download ($rawState) | $count";
+ // }
+ // }
+ // }
+ //}
+
echo " | ";
- $time = microtime();
- $time = explode(' ', $time);
- $time = $time[1] + $time[0];
- $finish = $time;
- $total_time = round(($finish - $start), 3);
- echo "loading in $total_time seconds.";
- $start= $finish;
+ // 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;
+ }
}
###########################################################################
@@ -1608,5 +1645,5 @@
echo "";
echo "
";
- echo " ";
+ echo " ";
echo " ";
echo " Free";
@@ -1686,7 +1723,8 @@
echo " },";
echo " bar: { groupWidth: '95%' },";
- echo " chartArea: {left:70, top:30, right:20, bottom:40},";
- echo " fontSize: 12,";
- echo " isStacked: true";
+ echo " chartArea: {left:100, top:30, right:20, bottom:40},";
+ echo " fontSize: 15,";
+ echo " isStacked: true,";
+ echo " colors: ['#76A7FA', '#FF5733', '#C70039', '#900C3F', '#581845']";
echo " };";
echo " var chart = new google.visualization.BarChart(document.getElementById('disk_div'));";
@@ -1821,14 +1859,18 @@
$date = gmdate("Y-m-d");
- $sql = "SELECT MAX(exp_id) FROM rawExp WHERE dateobs >= date_sub('$date', interval 20 day) AND dateobs <= date_sub('$date', interval 10 day)";
+ $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)) {
- print "*** WARNING: no data in period 10-20 days before requested date (query will be slower) **\n";
+ echo "*** WARNING: No data in the period 10-20 days before requested date (query will be slower) **\n";
$refExpID = 0;
- }
- $qry->fetchInto($refExpID);
- if ($refExpID[0] = 'NULL') {
- $refExpID[0] = 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
@@ -1838,4 +1880,6 @@
# $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;";
@@ -1843,4 +1887,5 @@
$qry = $db->query($sql);
if (dberror($qry)) {echo " error with $sql \n";}
+# echo " error with $sql \n";
while ($qry->fetchInto($row)) {
$DQarray[] = $row;
@@ -2044,10 +2089,10 @@
#define new zeropoints
- if(substr($row[5],0,1) == 'g') {$col_string = 'blue'; $zpt_off = $zp - 25.013;}
- if(substr($row[5],0,1) == 'r') {$col_string = 'red'; $zpt_off = $zp - 24.840;}
- if(substr($row[5],0,1) == 'i') {$col_string = '#6a3d9a'; $zpt_off = $zp - 24.711;}
- if(substr($row[5],0,1) == 'z') {$col_string = 'green'; $zpt_off = $zp - 24.30;}
- if(substr($row[5],0,1) == 'y') {$col_string = 'cyan'; $zpt_off = $zp - 23.57;}
- if(substr($row[5],0,1) == 'w') {$col_string = 'grey'; $zpt_off = $zp - 26.000;}
+ if(substr($row[5],0,1) == 'g') {$col_string = '#00f000'; $zpt_off = $zp - 25.013;}
+ if(substr($row[5],0,1) == 'r') {$col_string = '#f00000'; $zpt_off = $zp - 24.840;}
+ if(substr($row[5],0,1) == 'i') {$col_string = '#f05000'; $zpt_off = $zp - 24.711;}
+ if(substr($row[5],0,1) == 'z') {$col_string = '#0050a0'; $zpt_off = $zp - 24.300;}
+ if(substr($row[5],0,1) == 'y') {$col_string = '#ffe000'; $zpt_off = $zp - 23.570;}
+ if(substr($row[5],0,1) == 'w') {$col_string = '#808080'; $zpt_off = $zp - 26.060;}
$tt_string1 = sprintf('time: %s\n zeropoint: %s\n filter: %s\n exp_time: %s\n comment: %s', $timestamp, $zp,$row[5],$row[6],$row[7]);
@@ -2101,4 +2146,7 @@
}
+
+
+
###########################################################################
#
@@ -2108,8 +2156,5 @@
function Gettimeseries($db, $selectedMode, $selectedLabel, $proj, $selectedStage) {
// timer start
- $time = microtime();
- $time = explode(' ', $time);
- $time = $time[1] + $time[0];
- $start = $time;
+ $start = microtime(true);
// google chart javascript source code
@@ -2512,11 +2557,5 @@
// timer end
- $time = microtime();
- $time = explode(' ', $time);
- $time = $time[1] + $time[0];
- $finish = $time;
- $total_time = round(($finish - $start), 3);
- $start= $finish;
- echo " loading in $total_time seconds";
+ echo " loading in " . round((microtime(true) - $start), 3) . " seconds. ";
}
@@ -2994,4 +3033,370 @@
}
+
+###########################################################################
+#
+# 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) {
| | | | | | | | | | | | | | |