// Make a visual page of HFC database content
require "functions.php";
include "header.php";
include 'but_menu.php';
?>
<style type="text/css">
td.default { border:1px solid #dbd7d4; width:20%; padding: 3px; text-align: center;}
</style>
<?php
echo '</head>';
echo '<h5 class="winA">HFC content</h5>';
//echo '<div style="text-align: right;"><span id="but_back_query"><a href="index.php">Back to query form</a></div>';
// Printing global date ranges for each type of feature
$tab_id = array("fil" => "Filament", "pro" => "Prominence", "ar" => "Active region", "ch" => "Coronal hole", "sp" => "Sunspot", "t3" => "Type III", "rs" => "Radio source");
//$instru_by_date = get_minmaxdate_by_instrument();
$instru_by_date = get_minmaxdate_for_instrument_code_from_tstat();
//$query = "SELECT * FROM ASSOC_OBSERVATORY_FRC, OBSERVATORY, FRC_INFO WHERE OBSERVATORY_ID=ID_OBSERVATORY AND FRC_INFO_ID=ID_FRC_INFO";
//$instru_by_date = execute_query($query);
//print_r($instru_by_date);
echo '<div class="ui-widget-content ui-corner-all">';
echo '<p><span class="ui-icon ui-icon-info" style="float: left; margin-right: .3em;"></span>Date range</p>';
echo '<TABLE>' . "\n";
echo "<TR>\n";
echo "<TH>Feature</TH><TH>Observatory/Instrument/Telescop</TH><TH>FRC Code</TH><TH>First date</TH><TH>Last date</TH>\n";
echo "</TR>\n";
foreach ($tab_id as $feat_type => $feat_name) {
foreach ($instru_by_date[$feat_type] as $data) {
if (strlen($data['TELESCOP'][0])) {
$obsname = $data['OBSERVAT'][0] . ' ' . $data['INSTRUME'][0] . ' ' . $data['TELESCOP'][0];
} else {
$obsname = $data['OBSERVAT'][0] . ' ' . $data['INSTRUME'][0] . ' ' . $data['WAVEMIN'][0];
function print_feature_sel()
{
global $minmax_fil_val, $minmax_pro_val, $minmax_ar_val, $minmax_ch_val, $minmax_sp_val, $minmax_t3_val;
//$tab_tables1 = array("Filament"=>"FILAMENTS", "Prominence"=>"PROMINENCES");
//$tab_tables2 = array("Active region"=>"ACTIVEREGIONS", "Coronal hole"=>"CORONALHOLES", "Sunspot"=>"SUNSPOTS", "Type III"=>"TYPE_III", /*"Type II"=>"TYPE_II",*/ "Radio source"=>"RADIOSOURCES");
$tab_id = array("fil" => "Filament", "pro" => "Prominence", "ar" => "Active region", "ch" => "Coronal hole", "sp" => "Sunspot", "t3" => "Type III", "rs" => "Radio source");
//$instru_by_date = get_minmaxdate_by_instrument();
$instru_by_date = get_minmaxdate_for_instrument_code_from_tstat();
echo "<TABLE><TR>\n";
echo "<TH>Feature type</TH><TH>Observatory</TH>\n";
echo "</TR>\n";
// for features with pre-processing
foreach ($tab_id as $feat_type => $feat_name) {
echo "<TR>\n";
echo '<TD NOWRAP class="feat_sel"><input type="checkbox" id="' . $feat_type . '" name="features[]" value="' . $feat_type . '" ';
if (isset($_SESSION['par_post']['features']) && in_array($feat_type, $_SESSION['par_post']['features'])) {
echo 'checked';
}
echo ' /><label for="' . $feat_type . '">' . $feat_name . '</label></TD>';
echo '<TD class="feat_sel">';
echo '<SELECT name="obs_' . $feat_type . '[]" multiple size="2">';
foreach ($instru_by_date[$feat_type] as $data) {
echo '<OPTION value="' . $data['ID_OBSERVATORY'][0] . '">' . $data['OBSERVAT'][0] . '/' . $data['INSTRUME'][0] . ' - ' . $data['CODE'][0] . ' ' . $data['MIN_DATE_OBS'][0] . ' ' . $data['MAX_DATE_OBS'][0];
}
echo '</SELECT>';
echo '</TD><TD>';
print_ext_criteria_feat($feat_type);
/*switch ($feat_type) {
case 'fil';
print_ext_criteria_feat('fil', $minmax_fil_val);
break;
case 'pro';
print_ext_criteria_feat('pro', $minmax_pro_val);
break;
case 'ar';
print_ext_criteria_feat('ar', $minmax_ar_val);
break;
case 'ch';
print_ext_criteria_feat('ch', $minmax_ch_val);
break;
case 'sp';
print_ext_criteria_feat('sp', $minmax_sp_val);
break;
case 't3';
print_ext_criteria_feat('t3', $minmax_t3_val);
break;
}*/
echo "</TD></TR>\n";
}
echo "</TABLE>\n";
}
